Problem: Where do users and merchants encounter friction across signup, identity verification, bank linking, payment initiation, and successful completion—and which issues should be prioritized?
Outcome: A measurement framework for identifying friction across onboarding, verification, bank linking, and payment completion.
Problem: Where is traffic and PM2.5 pressure concentrated across monitored junctions, how do conditions change over time, and which early-warning signals should operators review first?
Outcome: Led data systems and BI reporting for an urban analytics prototype monitoring real-time traffic and PM2.5 across 5+ city junctions.
Problem: Where do filing workflows bottleneck, which error patterns need attention, and how can ETL and reporting automation improve processing efficiency and leadership visibility?
Outcome: Analyzed filing patterns and bottlenecks, restructured ETL pipelines for about 40% faster processing, and delivered Power BI dashboards with automated validation.
Tools: Excel · Power BI · SQL · Power Query · Python · DAX
Problem: Which channels and customer segments create valuable, retained customers rather than inexpensive but low-quality conversions?
Outcome: An analysis framework that distinguishes channel quality and retained customer value from low-quality inexpensive conversions using synthetic campaign data.