At Raheem Solutions (Sales Assist), I designed an FMCG field-sales warehouse with 18 analytical tables, 9 fact tables, and 37 relationships. I also developed an SSAS Tabular model with approximately 120 business measures to support enterprise reporting.
I built SSIS pipelines using incremental loads, snapshot refreshes, monthly refreshes, and full synchronization. I developed a weighted Order Booker Performance Scorecard and automated reporting workflows, reducing report preparation effort by approximately 30%.
Previously, at Vizpro Pvt Ltd, I designed a Galaxy Schema warehouse for FMCG and BNPL reporting and built Power BI dashboards for KYC, lending, payment reconciliation, and app-based ordering. Redesigning the pipeline and reporting layer reduced report turnaround from approximately four hours to 22 minutes.

