John

Data Analyst | Python, SQL & Spreadsheet Automation Specialist

70 ID PROOF
Verified
contact
mark as hired

Overview

Looking for work (0 hours/day)

at $0.00/hour ($0.00/month)

Bachelor's degree

Last Active

June 24th, 2026 (today)

Member Since

May 6th, 2026

Profile Description

I help businesses automate repetitive tasks using Google Sheets and Google Apps Script.

My services include:
• Spreadsheet automation
• Dashboard creation
• Data cleaning and transformation
• Automated reports
Email-to-Sheets workflows
• Custom formulas and integrations

I have experience building:
• Budget pacing dashboards
• Weekly and monthly reporting systems
• Invoice extraction workflows
• Data consolidation tools

I focus on creating reliable, easy-to-use systems that save time and reduce manual work.

If you need help automating your spreadsheets or improving your reporting process, I'd be happy to assist.

Top Skills

Experience: 6 months - 1 year

Worked under a Lead Analyst to build and maintain advanced Google Sheets systems for automation, reporting, and dashboard creation. Proficient in complex formulas such as BYROW, LAMBDA, SCAN, MAP, FILTER, QUERY, and ARRAYFORMULA, with experience connecting multiple spreadsheets and automating business workflows.

Experience: 6 months - 1 year

Worked under a Lead Analyst to clean and analyze business data, create reports and dashboards, and identify trends and insights that support decision-making and process improvements.

Experience: 6 months - 1 year

Worked under a Lead Analyst to develop Google Apps Script solutions for automating email reports, integrating APIs with Google Sheets, transferring data between spreadsheets, and streamlining business workflows.

Other Skills

Experience: Less than 6 months

Primarily work in Google Sheets, but able to import, clean, and automate Excel files and convert them into automated reporting and dashboard solutions.

Experience: 6 months - 1 year

Use JavaScript within Google Apps Script to build custom automations, API integrations, and workflow solutions.

Experience: Less than 6 months

Used Python to build ETL pipelines for cleaning, transforming, and validating large CSV datasets. Developed automation workflows for data processing, fuzzy matching, API integration, and exporting reports to Google Sheets and Looker Studio.

Experience: Less than 6 months

Used SQL and SQLite to create business reporting queries, generate KPIs, and analyze sales performance. Experienced with aggregations, joins, filtering, and monthly reporting for product, category, and regional analysis.

Experience: 6 months - 1 year

Used HTML to build and format web pages, email templates, and custom interfaces for automation and reporting solutions.

Basic Information

Age
25
Gender
Male
Website
Sign Up with Pro Account to View
Address
Cauayan, Negros Occidental
Tests Taken
IQ
Score:  112
DISC
Dominance: 24%
Influence: 10%
Steadiness: 36%
Compliance: 30%
English
C1(Advanced)
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

“They are definitely a valuable part of your business for all kinds of reasons.”

- Steven Rapposelli

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 »