Case Studies & Analytics
Detailed structural breakdowns of real-world operational and sales datasets. I apply business frameworks to make sense of complex metrics and drive performance.
Advanced SQL Business Querying
Currently engineering comprehensive relational database schemas and complex analytical queries to solve multi-departmental business challenges.
Olist E-Commerce Operations & GMV Analysis
Conducted a full-scale operational gap analysis of Brazil's largest e-commerce department. Modeled BPMN workflows, mapped Congruence gaps, and identified root causes of customer delivery friction.
I.P. Pharma Operational Dashboard & Sales Tracking
Engineered an automated stock management and representative sales tracking system for a tier-2 city pharmaceutical distributor, resolving field reporting inaccuracies.
Vrinda Store Retail Sales Performance Audit
Audited a complete retail transaction dataset in Excel to construct key customer profiles, regional performance indices, and channel success factors.