What have I actually built?
A mix of banking workflows and personal projects.
Regulatory reporting, without the repetitive work.
A VBA workflow that reconciles records, validates inputs, and prepares reporting files with less manual intervention.
Automation case study75%less processing timeBuilding a data-quality gate for 5,000 records.
Of 5,000 records, 4,090 passed validation: an 81.8 percent data quality rate.
Case studyEnforcing a data regulation with 18 rules in Excel.
3,851 records accepted, 5,256 cells repaired: 77.02% compliance on the first pass.
Case study1,263violations caught before reportingOne sales model, nine measures, one source of truth.
5,000 transactions from January 2023 to December 2024, behind nine DAX measures.
Case study5,000transactions modelled from one fact tableOne KPI model for HR and MIS.
23 indicators across 10 divisions and four views by role, from one dataset.
Case study23indicators in one shared modelAffiliate picks people can trust: the GoOdays case study.
Every buy button is a Shopee Affiliate link with a SubID per placement.
Case study0invented ratings or prices, shown only when verified
How does one case come together?
Enforcing a data regulation with 18 rules in Excel.
Portfolio case study. All data is fictional and simulated.
Problem
A data governance regulation classifies every transaction field as mandatory or optional and defines what valid means for each one. The batch is 5,000 records. Manual review is slow, two people reach two different answers, and nothing is auditable.
1,263violations caught before reporting
View case study