
Senior Analyst - Data
Capgemini · Apr 2023 – Apr 2026
- • Worked for RaceTrac retail, leading migration of Excel and Tableau dashboards to Power BI, delivering scalable, standardized, and performance-optimized reporting solutions.
- • Utilized a variety of data analysis, reporting, and visualization tools, including Oracle SQL, Python, Tableau, and Power BI, to extract, transform, and load (ETL) data from various sources.
- • Developed end-to-end retail reports from scratch by extracting, transforming, and analyzing data from SAP BW and Oracle SQL to support sales, inventory, supply chain, and operational KPIs.
- • Supported on-premise to Azure Synapse migration by creating and managing external tables on ADLS Gen2 and integrating curated datasets with Power BI for enterprise analytics.
- • Developed and maintained complex Power BI dashboards using DAX, data modeling, drill-throughs, and filters to support ad-hoc analysis, executive reporting, and retail performance monitoring.
- • Built inventory, supply chain, and warehousing dashboards to track stock levels, inventory aging, replenishment cycles, vendor performance, and warehouse efficiency.
- • Supported procurement team by developing vendor management dashboards to analyze supplier performance, spend trends, purchase orders, contract compliance, and SLA metrics.
- • Implemented data governance, validation, and quality checks by defining business metrics, monitoring refreshes, and ensuring data accuracy, security, and compliance across dashboards.
- • Performed ongoing dashboard maintenance, performance tuning, and enhancements while collaborating with business stakeholders in Agile/Scrum environments using Jira.

