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

February 13th, 2025 (5 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
28
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 can find little blocks of time to focus so we can scale this business.”

Clearman Lawyers

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 »