Data Audit
Combine Monthly CSV Files with Power Query
Combine monthly CSV exports with Power Query, preserve leading-zero codes, and check each file’s row count and sales total after every refresh.
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
Use Dropdowns to Keep Spreadsheet Categories Consistent
A category dropdown stops typos, and prevents the list from outgrowing its range. It does not correct old entries or prevent pastes. Set it up in Google Sheets and Excel, then add an audit column and a reconciliation check so no expense drops out of your category totals.
reporting
Use a Rolling Average to Read Sales Trends
A guarded 3-month rolling average formula for Excel and Google Sheets that blocks partial, blank and non-consecutive windows, and the one piece of arithmetic that explains why the average can rise while sales fall.