I specialize in building automated business systems, Shopify integrations, and interactive dashboards using Google Sheets, Google Apps Script, and Looker Studio for inventory management, sales tracking, lead generation, and business analytics.
I create end-to-end solutions that reduce manual work, automate workflows, and transform raw data into actionable insights that help businesses make better decisions.
Key Solutions:
• Inventory Reconciliation System (detects missing items, mismatches, discrepancies + dashboard)
• Lead Stacking Dashboard (deduplicates leads, ranks high-priority prospects)
• Inventory & Sales Tracking System (real-time stock monitoring, sales tracking, alerts, and performance insights)
• Interactive Looker Studio Dashboard (KPI tracking, revenue analysis, and executive reporting)
• Shopify Live Sales Dashboard (real-time sales analytics powered by Shopify data)
• Shopify CSV Export & Reporting System (automated reporting and data processing for e-commerce operations)
• Google Apps Script Web Apps (custom portals, dashboards, and workflow automation)
• Business Process Automation (eliminating repetitive manual tasks through custom solutions)
Technical Stack / Tools:
Google Sheets (Advanced Formulas, QUERY, FILTER, ARRAYFORMULA), Google Apps Script (Automation, APIs & Web Apps), JavaScript, Shopify, Webhooks, Looker Studio, Microsoft Excel, Data Cleaning, Data Analysis, Dashboard Development, and Workflow Optimization.
Portfolio:
Inventory System:
Lead Dashboard:
Sales & Inventory System:
Looker Studio Dashboard:
Shopify Live Sales Dashboard:
Shopify CSV Export & Reporting System:
Web App (Live Demo):
Demo Credentials:
User: Mark
Pass: 1234
Experience: 2 - 5 years
Experience: 2 - 5 years
Experience: 2 - 5 years
Experience: 1 - 2 years
“I can find little blocks of time to focus so we can scale this business.”
Clearman Lawyers
SEE MORE REAL RESULTSOnlinejobs.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.