Current Employment Status:
Hired Full Time on Sep 25, 2024

John

Data Analyst | Automation | Data  Scraper | Zapier| Make.co

85 ID PROOF
Verified
With Timeproof
contact
mark as hired

Overview

Looking for full-time work (8 hours/day)

at $6.00/hour ($1,056.00/month)

Bachelors degree

Last Active

November 24th, 2024 (4 days ago)

Member Since

November 27th, 2020

Profile Description


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, Upgrade to see actual info User

-  Set up a simple automation to collect email information and store it in a Google Sheets spreadsheet, helping track data easily without manual input.
-  Automated saving email attachments to Dropbox, reducing manual file handling and keeping important data backed up automatically.
-  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 emails and contact details from various websites for data collection and outreach purposes.

Top Skills

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.

Other Skills

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

Experience: Less than 6 months

Basic Information

Age
27
Gender
Male
Website
Sign Up with Pro Account to View
Address
San Mateo, Rizal
Tests Taken
IQ
Score:  115
DISC
Dominance: 46%
Influence: 15%
Steadiness: 11%
Compliance: 28%
English
C2(Advanced/Mastery)
Government ID
Sign Up with Pro Account to View

“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.

Read More »