Filter by role, tool, domain, or project type. Cards stay usable without JavaScript. Detailed evidence lives on each case-study page.
Combine filters. State stays in the URL.
Showing 4 projects.
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.
Tools: Python · SQL · Excel · Power BI
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: Where are qualified prospects being lost, which channels create valuable opportunities, and is the current pipeline sufficient to meet revenue goals?
Outcome: A decision-support dashboard framing that identifies funnel bottlenecks, pipeline risk, and opportunities to improve sales prioritization using synthetic CRM data.
Tools: SQL · Power BI · Excel · DAX · Power Query
Problem: How can the organization reduce delayed orders, stockouts, and excess inventory while maintaining service levels?
Outcome: A monitoring and decision framework for balancing inventory availability, fulfillment performance, and working capital using synthetic operations data.
Tools: SQL · Excel · Power BI · Power Query · Python