Data Audit
Fix Date Locale Before Building a Monthly Report
Fix day/month interpretation before building a monthly report. Preserve raw dates, apply the source locale, and reconcile both invoice totals and exception rows.
Data Analytics · Systems · AI Engineering
Decades of Experience. A Modern, Data-Driven Approach.
Leveraging a career that spans manufacturing, education, and urban mobility, I specialize in solving complex challenges. My focus is on using data to find clarity and drive measurable growth, regardless of the industry.
Grain First
Table & Metric Clarity
4 Pillars
Metrics · Data · Reporting · Ownership
AI + Ops
Production Systems & RAG
analytics-workbench — Live Preview
Interactive01 · Grain FirstVERIFIED
Define What One Row Represents Before Counting
Conflicting totals usually start when spreadsheets mix orders, line items, and payments in the same view. Declaring the table grain first restores trust in every downstream metric.
Grain: 1 row per completed_order_id (net of refunds, UTC close)
Case Studies & Production Systems
Systems built for operational clarity and measurable outcomes.
Selected case studies across business development automation, educational transformation, and AI-assisted career learning.
Next.js · Supabase · AI
CareerTalkLab
An existing English-learning LMS, with a wider data and software career-learning direction planned.
Read case study
Operations · EdTech
Digital Transformation in Crisis
Leading a language school's complete pivot to online learning during COVID-19.
Read case study
Python · AI Pipeline
BD Automation Suite
A modular Python pipeline that automates multi-stream business development, from prospect research to AI-drafted outreach.
Read case study
Operator & Builder Perspective
Real-world operations meet disciplined data and AI systems.
With a unique blend of hands-on manufacturing expertise, educational leadership, and data analytics skills, I bring a comprehensive perspective to every project. My approach combines decades of real-world experience with modern technological solutions to deliver tangible results.
About Me
Focus AreasSMB Analytics · Grain First · AI
MethodologyClear Definitions & Owned Action
Community LabCareerTalkLab (A1–C1 + Data)
Writing & Field Notes
Practical essays on small-business analytics, Grain First, and building CareerTalkLab.
Field notes on turning messy spreadsheets into reliable decisions, alongside essays on AI engineering and language pedagogy.
Data Audit
Find Unmatched Customer IDs with XLOOKUP
Make unmatched customer IDs visible with XLOOKUP, diagnose spaces and missing records, and reconcile both exception dollars and row counts before approving a report.
Data Audit
Why Merging Tables Inflates Your Sales Total
Repeated lookup keys can multiply orders and overstate sales. Test key uniqueness, choose a business-rule filter or aggregation, then reconcile totals and each order.