From financial dashboards used by C-suite executives to automated reconciliation pipelines — every project here solved a real business problem. SQL, Python, Power BI. Clean outputs. Measurable impact.
Real-time financial dashboard used by senior leadership daily. Integrates AP/AR data from SAP & Oracle ERP, visualises cash flow, vendor payment cycles and collection rates with drill-through capabilities across 12+ KPIs.
Multi-source reconciliation pipeline that cross-validates invoice and payment data between SAP and Oracle ERP systems. Automated variance flagging eliminates manual spreadsheet comparison, reducing vendor mismatches and audit prep time significantly.
Consolidated MIS reporting suite pulling data from 5+ source systems. Eliminated manual copy-paste reporting that previously took 2+ days per cycle. Custom Power Query transformations and scheduled refresh deliver updated reports automatically every morning.
Analytics system processing 300+ UGC items daily with 98%+ classification accuracy. Built weekly risk intelligence reports identifying behavioural patterns and policy violation trends, enabling proactive policy updates and reducing false positive rates measurably.
End-to-end analytics solution tracking DEMAT account conversion funnel, client acquisition efficiency, and competitor performance benchmarks. Identified key drop-off stages and optimisation opportunities that directly informed the sales team's targeting strategy.
Refactored legacy reporting queries using CTEs, window functions and indexing strategies to cut average report generation time by over 60%. Automated scheduled Python scripts replaced manual extraction tasks, eliminating 8+ hours of repetitive work per week.
Every project follows a disciplined process that ensures insights are accurate, explainable and actually used.
Whether it's a messy spreadsheet, a disconnected ERP or a dashboard that no one uses — I can help turn it into something your team actually trusts.