CASE 07 · EXECUTIVE DASHBOARD SUITEDATA
Leadership flew blind between month-ends. Now it's one click.
PROBLEMNo live read on Sales, Finance, HR or Inventory until the books closed.
BUILTExcel + Power BI dashboard suite with refreshable models (.pbix + .xlsm).
RESULTMonth-end reporting: 5 days → same day. One-click refresh. 20+ dashboards shipped.
RAW DATADASHBOARD
POWER BIEXCELPOWER QUERYDAXVBA
CASE 04 · E-COMMERCE FLEETE-COMMERCE
24 stores built, migrated and maintained across four platforms.
PROBLEMStores across Shopify, Magento, BigCommerce & WooCommerce needing builds, migrations and catalog ops.
BUILTStore builds + bulk data feeds, pricing automation, inventory sync. Flagship: a 300k+ SKU industrial catalog on BigCommerce.
RESULTCatalog updates: weeks → hours. 24 stores shipped and maintained.
// 24 STORES LIVE · 4 PLATFORMS · CLICK FEATURED SHOTS TO ZOOM
FilmNeverDie↗ LIVE
SHOPIFY
HotDealsToday↗ LIVE
WOOCOMMERCE
Strobels Supply03
BIGCOMMERCE · 300K SKU
20twenty Australia06
SHOPIFY
Industrial Supply11
MAGENTO
Beauty & Cosmetics15
SHOPIFY
Pet Supplies16
WOOCOMMERCE
Food & Beverage17
WOOCOMMERCE
Sporting Goods18
BIGCOMMERCE
Fashion Boutique19
SHOPIFY
Hardware & Tools20
MAGENTO
Gifts & Novelty21
WOOCOMMERCE
Wholesale Catalog22
BIGCOMMERCE
SHOPIFY ×11WOOCOMMERCE ×6MAGENTO ×4BIGCOMMERCE ×3FEED AUTOMATION
CASE 02 · SPORTS DATA PIPELINEAUTOMATION
40,000+ matches a season. Zero missed matchdays.
PROBLEMFootball results from hundreds of leagues needed collecting, validating and publishing nightly — no misses.
BUILTAutomated scraping + validation pipeline; auto-publish with anomaly flags.
RESULT40,000+ matches/season. Zero missed matchdays in 3 years.
# nightly · 22:00 cron
scrape(leagues=412) → validate → flag_anomalies
# 40,118 rows · 0 errors · published 23:14
SCRAPYN8NPYTHONCRON
CASE 05 · SCRAPING AT SCALEAUTOMATION
1M+ pages a month, structured and unattended.
PROBLEMCompetitor & product data from thousands of sites — structured, deduped, continuous.
BUILTSelf-hosted n8n pipelines (HTTP + body-HTML parsing), proxy rotation, output to Sheets/DB.
RESULT1M+ pages/month. 99.7% parse accuracy. Runs unattended.
# n8n · self-hosted
HTTP → parse(body_html) → dedupe → sheet
# 1,042,887 pages/mo · accuracy 99.7%
N8NPLAYWRIGHTPROXIESSQL
CASE 03 · CRITICAL POWERCRITICAL POWER
UPS commissioning reports: 2 days → 20 minutes per unit.
PROBLEMData-centre UPS & generator commissioning (Dublin, Manchester) produced raw logger data needing engineer-grade verification reports — 2 days each, by hand.
BUILTExcel/Word automation converting load-step, balance & sync test data into formatted verification documents.
RESULTTurnaround 2 days → 20 min/unit. Used on live hyperscale DC sites.
# DUB09 / MMA01 series
logger.csv → [0% SYNC · LOAD STEP · LOSS OF AC · NO BREAK]
→ verification.docx # signed off on live site
EXCELWORD AUTOMATIONVBADATA-CENTRE
CASE 01 · WAREHOUSE OPSAUTOMATION
23 hours a week, reclaimed. Zero reconciliation errors.
PROBLEMWarehouse staff manually updated 14 spreadsheets daily. Errors compounded by Friday.
BUILTApps Script + Excel reconciliation engine pulling from 3 sources — validates, reconciles, writes back.
RESULT23 hrs/week reclaimed. Zero reconciliation errors in 11 months running.
APPS SCRIPTEXCELGOOGLE SHEETS
CASE 06 · ZERO-TOUCH REPORTINGAUTOMATION
100% on-time client reports. 0 manual sends.
PROBLEMWeekly client reports assembled and emailed by hand. Late, error-prone.
BUILTApps Script auto-mailer — pulls Sheets data, renders, sends on schedule.
RESULT100% on-time delivery since launch. 0 manual sends.
APPS SCRIPTGMAIL APISHEETS
CASE 09 · RESEARCH FILE — AU MARKETRESEARCH
Decision-ready briefs with verifiable sourcing.
PROBLEMAU client needed deep market/competitor research — including a cloaking-detection investigation and an IPP & RAP dataset 18 revisions deep.
BUILTResearch pipeline combining scraping, manual verification and analyst write-ups.
RESULT48-hr turnaround standard. 18 dataset revisions delivered.
EXCELSCRAPINGVERIFICATIONANALYSIS
CASE 11 · CRM & AUTOMATIONCRM
GoHighLevel builds: CRM, funnels and marketing automation.
PROBLEMClients needed lead capture, nurture and pipeline automation that actually runs itself.
BUILTGoHighLevel CRM setups, funnels, automated workflows and reporting.
RESULTHands-off pipelines — leads in, follow-ups automatic, nothing dropped.
GOHIGHLEVELFUNNELSWORKFLOWS
CASE 12 · SEO RETAINERSSEO
Clients renew because rankings actually move.
PROBLEMSites invisible; agencies sending fluff reports.
BUILTTechnical SEO + content ops with transparent monthly reporting (real PDFs on file).
RESULTLong-running retainers — renewed month after month.
# monthly report · May 2026
crawl → fix(technical) → content → report.pdf
# real numbers, every month
TECHNICAL SEOCONTENTREPORTING
CASE 10 · ANDROID APPSAPPS
Two Android apps: a metal-trivia engine and a 100k-word dictionary.
PROBLEMA trivia game needed a huge audio + question library; a Bangla–English dictionary needed a modern UI and a data model that scales.
BUILTHeadbanger Trivia: AI-assisted content factory — 350+ audio clips, 500 questions/genre across 10+ genres, auto-QA. Bangla Dictionary: full UI mockup + normalized pipeline for 100k+ entries.
RESULTFull libraries shipped in weeks; pipelines reusable for future titles.
# content factory
genre × 500Q × audio → qa.pass → pack.json
# 351 clips · 103,578 words
PYTHONJSON PACKSUI DESIGNAUTO-QA
CASE 13 · FORECASTING MODELSDATA
Manufacturing pricing & budget forecasting in Excel.
PROBLEMA manufacturer needed dynamic pricing and a forward budget model out of messy historical data.
BUILTDynamic pricing forecast + budget model with scenario inputs, Power Query data prep and one-click recalculation.
RESULTPricing decisions in minutes; a living budget that updates as actuals land.
EXCELPOWER QUERYFORECASTINGVBA
CASE 14 · EXTRACTION & FIELD TOOLSAUTOMATION
Turning PDFs, scanners and QR into clean structured data.
PROBLEMDocuments, handheld-scanner logs and field check-ins all arrived as unstructured noise.
BUILTA PDF table extractor, a handheld-scanner inventory flow and a QR-code field tool that writes straight to a clean dataset.
RESULTManual re-keying eliminated; data lands validated and ready to use.
# field capture
scan / qr / pdf → parse → validate → sheet
# zero manual entry
PYTHONOCR / PDFQRAPPS SCRIPT
CASE 15 · WEB BUILDSWEB
Sites beyond the storefront — sport, records, community, gaming.
PROBLEMClients needed fast, maintainable sites: a football-results site, a records label, a community portal, a FiveM gaming store and WordPress blogs.
BUILTCustom & WordPress builds — Winton Rovers F.C., Guitars-Lesson, Janashona, Bathotileo, FiveMCar — hosted, secured and handed over editable.
RESULTEach shipped, live and maintained — several on long-term retainers.
WORDPRESSPHPSHOPIFYCLOUDFLARE