📞 0321-2582327 · 📧 [email protected] · GitHub
I look at messy operational databases and find exactly where company cash is trapped or where user pipelines are leaking. I build end-to-end data systems: raw SQL schemas → data sanitization scripts → interactive Power BI dashboards → single-page executive reports.Open to technical data analyst roles across product, growth, and business operations.
Database Engineering: MySQL · Advanced CTEs · Mathematical Window Functions · Subqueries · Schema Normalization · Session Overrides · Foreign Key Constraint Engineering
Visualization & Automation: Power BI Dashboard Design · DAX Modeling · Automated Reporting Processes · Advanced Excel · ETL Data Pipelines · KPI Formulation
Analytical Focus: Funnel Mapping · Retention Cohorts · Revenue Leakage Quantifying · Supply Chain Optimization · Onboarding Latency Analysis · ABC Inventory Segmentation
Technical Stack: MySQL (Window Functions) · Power BI · Advanced Excel Repository Code & Dashboard Layout: [Link]
The Bottleneck: Horizon Marketplace was facing shrinking profit margins due to slow-moving warehouse stock, while simultaneous supplier shipping delays caused high-demand items to go out of stock on the customer-facing mobile app. Standard historical tracking models failed to handle massive sales volatility spikes.
The Implementation • Audited 17,646 operational ledger transactions using MySQL window functions to calculate cumulative revenue contributions per SKU. • Coded a predictive restocking matrix script utilizing sales volatility standard deviations and rolling manufacturer timelines. • Formulated dynamic Safety Stock buffers and programmed automated database Reorder Point (ROP) triggers.
The Impact Metrics • Segmented a 50-item catalog to prove just 23 Class A items drive 80% of total marketplace revenue. • Quantified a hidden revenue bleed of $63,897.26 caused by a single high-demand apparel product sitting out of stock for 42 days. • Shifted the company from manual, time-intensive procurement to an automated, predictive data framework.