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:
----------------------/page/Z0EuF
Shopify Live Sales Dashboard:
-----------
Shopify CSV Export & Reporting System:
-----------
Web App (Live Demo):
-----------
Demo Credentials:
User: Mark
Pass: 1234