Current Employment Status:
Hired Full Time on Sep 25, 2024
3 YEARS DATA ANALYST
- Efficiently organize, visualize, and validate data for meaningful insights.
- Utilize advanced formulas, nesting, arrays, and optimization tools for complex calculations.
- Cleanse and restructure data through text manipulation, conditional formatting, and merging techniques.
- Automate tasks, extend functionality, and enhance productivity through VBA scripting and macro recording.
- Facilitate seamless collaboration, control access, and track changes in shared spreadsheets.
- Build interactive dashboards with dynamic charts and formatting for impactful data visualization.
- Import data from external sources, export in various formats, and establish web connections for data retrieval.
- Plan, track, and automate project workflows, resource allocation, and task scheduling.
- Forecast budgets, analyze financial data, and conduct scenario analysis to support decision-making.
- Identify and resolve errors in formulas, macros, and data challenges for accurate analysis.
- Google Data Analytics Certificate.
2 YEARS BOOKKEEPER
- Meticulously verify figures to maintain integrity.
- Prioritize meeting strict deadlines without compromising accuracy.
- Identify discrepancies for consistent data entry.
- Handle data from various sources for comprehensive analysis. Adhere strictly to safeguard sensitive financial information.
- Diligently reconcile payments to ensure integrity.
- Prioritize meeting strict deadlines while upholding accuracy.
- Identify inconsistencies for uniform data entry.
- Manage data from various sources for comprehensive analysis.
- Strictly adhere to safeguarding sensitive financial information.
ZAPIER, BARDEEN AI,
- Set up a simple automation to collect
- Automated saving
- Implemented basic notifications in Slack for new calendar events, keeping the team updated with minimal setup.
- Connected Shopify and Trello via Zapier to automatically create task cards for new orders, simplifying project tracking for beginners.
- Designed a basic workflow using Bardeen to automatically extract data from specified web pages and store it directly into a Google Sheets document.
- Configured the automation to run periodically, ensuring continuous data updates without manual intervention.
- Implemented a simple, user-friendly process to gather and organize web data efficiently, minimizing errors and manual data entry.
- Set up integrations between web sources and Google Sheets using Bardeen, facilitating seamless data flow and storage, enabling easier access and analysis.- Proficient in extracting
Experience: 2 - 5 years
✦ Data Cleaning ✦ Complex Excel & Google Sheet Formula ✦ VBA & Google AppsScript Automation ✦ Advanced formulas (VLOOKUP, HLOOKUP, INDEX-MATCH) ✦ Nested functions ✦ Array formulas ✦ Goal Seek and Solver✦ Text-to-columns ✦ Conditional formatting ✦ Data cleaning techniques ✦ Merging and splitting cells ✦ Business Process Automation ✦ VBA (Visual Basic for Applications) ✦ Macro recording and editing ✦ Automation of repetitive tasks ✦ Zapier ✦ Bardeen AI ✦ Sharing and permissions in Google Sheets ✦ Collaboration tools (Comments, Suggestions) ✦ Version history and tracking changes ✦ Building interactive dashboards ✦ Google sheet and Excel Dynamic charts and graphs ✦ Conditional formatting for visual impact ✦ Looker Studio ✦ Importing data from external sources ✦ Exporting data to different formats ✦ Web scraping and data connections ✦ Gantt charts and project tracking ✦ Resource planning using spreadsheets ✦ Task automation for project workflows ✦ Budgeting and forecasting ✦ Financial analysis and modeling ✦ Scenario analysis and sensitivity tables ✦ Identifying and fixing errors in formulas ✦ Debugging macros and scripts ✦ Finding optimal solutions for data challenges
Experience: 2 - 5 years
✦ Efficiently organize, visualize, and validate data for meaningful insights. ✦ Utilize advanced formulas, nesting, arrays, and optimization tools for complex calculations. ✦ Cleanse and restructure data through text manipulation, conditional formatting, and merging techniques. ✦ Automate tasks, extend functionality, and enhance productivity through VBA scripting and macro recording. ✦ Facilitate seamless collaboration, control access, and track changes in shared spreadsheets. ✦ Build interactive dashboards with dynamic charts and formatting for impactful data visualization. ✦ Import data from external sources, export in various formats, and establish web connections for data retrieval. ✦ Plan, track, and automate project workflows, resource allocation, and task scheduling. ✦ Forecast budgets, analyze financial data, and conduct scenario analysis to support decision-making. ✦ Identify and resolve errors in formulas, macros, and data challenges for accurate analysis
Experience: 2 - 5 years
Dashboard Creation: Proficient in crafting dashboards using Excel and Looker Studio. Automation of Reports: Skilled in automating report generation processes. Error Formula Resolution: Experienced in identifying and resolving formula errors. Complex Excel and Google Sheet Formulas: Adept at creating intricate formulas in both Excel and Google Sheets. Macro VBA and Google Appscript: Well-versed in developing macros using VBA in Excel and utilizing Google Appscript for automation in Google Sheets.
Experience: 1 - 2 years
Experience: 2 - 5 years
This is my way to communicate for professional discussions
Experience: 2 - 5 years
Experience: 2 - 5 years
Experience: Less than 6 months
Experience: 2 - 5 years
Working with International Partners
“I have one of the best VAs I've had in a long time...she's been amazing”
Davonna Willis
SEE MORE REAL RESULTS“We'll definitely continue to hire people using Onlinejobs because it has taken our agency to the next level”
- Marc Diez
Onlinejobs.ph "ID Proof" indicates if "they are who they say they are".
It DOES NOT indicate skill level.
ID Proof scores are 0 - 99 with 99 being the best. It is calculated based on dozens of data points.
It's intended to help employers know who they're talking to is real, and not a fake identity.