Supriya Verma

Associate Consultant

Gurgaon, Haryana, India13 yrs experience

Most Likely To SwitchAI Enabled

Key Highlights

Expert in data analytics and business intelligence solutions.
Proven track record in developing scalable BI ecosystems.
Skilled in leveraging Power BI and SQL for impactful insights.

Stackforce AI infers this person is a SaaS-focused Data Analytics Consultant with expertise in BI solutions.

Contact

supriya.verma2009@gmail.com LinkedIn

Skills

Core Skills

Power BiData Analytics

Other Skills

Data MigrationAgile Project ManagementMicrosoft FabricDAXSQLPowerAppsData ModelingData AnalysisGoogle BigQueryAngularLakehouseKusto Query Language (KQL)StorytellingLeadershipManagement

About

As a Senior Consultant at Capgemini with over two years in this role and nearly 12 years of experience, I specialize in data analytics and business intelligence. My work focuses on leveraging tools like Power BI, SQL, and Azure to deliver impactful data solutions that align with organizational goals. I have been instrumental in developing and deploying advanced reporting systems, collaborating with cross-functional teams, and enabling data-driven decision-making. My expertise lies in creating scalable BI ecosystems and designing data models using DAX and ETL processes. I am dedicated to delivering actionable insights through innovative analytics initiatives, ensuring seamless integration of business needs with robust data strategies. Passionate about fostering collaboration and driving organizational success through data, I aim to empower teams with effective and efficient data-driven solutions.

Experience

13 yrs

Total Experience

3 yrs 3 mos

Average Tenure

5 yrs 2 mos

Current Experience

Capgemini

2 roles

Senior Consultant

Oct 2023 – Present · 2 yrs 8 mos

1. Migrated BI reports from DRS server to Microsoft Fabric, eliminating gateway dependency and enhancing scalability for report access.
2. Developed Power BI dashboards for Microsoft's IDEAs team, enabling strategic insights into M365 subscriptions across global markets.
3. Engineered complex DAX-driven reports, led Azure-to-Cosmos stream migrations, applied advanced SQL tuning (joins, indexing, partitioning) to improve query performance on large datasets.
4. Developed PBI for Audit & Governance Framework integrated with PowerApps form, enabling real-time user input and streamlined compliance workflows through RLS.
5. Designed and optimized a semantic model for Microsoft Fabric Data Agent, enabling intuitive natural language querying of sales data.

Data MigrationAgile Project ManagementPower BIData Analytics

Data Analytics Consultant

Apr 2021 – Oct 2023 · 2 yrs 6 mos

1. Directed BI transformation for Fluke Corporation's product shipment and inventory analytics, creating a ‘Single Source of Truth' to reduce data fragmentation.
2. Led the development of Power BI dashboards for marketing performance analytics of Kimberly-Clark's Marketing Analytics Solution, ensuring data accuracy via Google BigQuery.
3. Architected and led the transformation of a high-volume (660K+ records) survey analytics platform of Olam International, replacing slow Angular based visualizations with Power BI embedded, which reduced report load time from 4 mins to few seconds.

Data AnalysisAgile Project ManagementData AnalyticsPower BI

Walmart

Business Intelligence Developer

Mar 2016 – Apr 2021 · 5 yrs 1 mo · Gurgaon, India

Developed interactive dashboards on Power BI for Sales & Marketing, Supply Chain, Price Change Insights, COVID-19 Store Status Update, Global Promotion Analysis. Used different DAX functions for fact calculations, created featured Q&A.
Developed more than 30 complex reports on Cognos Analytics Tool for departments like Replenishment, Finance, Item File & Store Operations.
Designed, developed & implemented Freebie Web Portal across all the Walmart's Best Price Stores that automated the manual Freebie Distribution and inventory management system. It reduced customer's wait time at freebie help desk by 150 seconds hence improving customer experience and ensuring accuracy in freebie distribution. It reduced inventory shrinkage and manpower in Freebie department of the stores.
Designed & developed various .NET applications to automate different processes across the organization. Modified existing applications to correct errors and remove bugs, optimized the code to adapt to new hardware and did database tuning to improve their performance.
Created databases and schema objects including tables, indexes and applied constraints. Wrote functions, complex stored procedures and triggers on SQL Server.
Designed reports on SSRS that consisted sub reports, drill-through, drill-down and parameterized reports for reporting on new & existing .NET applications. Sound knowledge of using global variables, expressions & functions in SSRS.
Developed SSIS Packages with error handling to Extract, Transform and Load (ETL) data into the SQL server from different data sources like CSV files, MS Access, DB2 & Netezza. Scheduled the SSIS packages using SQL Server Agent.
Documented user-manuals and created workflow diagrams to clearly demonstrate the process being automated through the software solution.
Prepared test cases and advocated for end-users to perform testing and problem analysis through Agile approach for different software solutions.

Election commission of india

Software Developer

Feb 2015 – Feb 2016 · 1 yr · Greater Delhi Area

Worked under the project - NVSP (National Voters' Service Portal) to process and compile Electoral Roll Data of 9 states through SQL Server, ASP.NET (C#).
Modification, Deployment and Testing of Web Service in the states to synchronize state and national level databases.
Built databases and table structures for storing Electoral Roll Data of 9 states of the country on SQL Server. Performed ETL on the data as well to purify it of all the inconsistencies like duplicate data and other redundancies.

Election commission of india

Software Developer

Dec 2013 – Jun 2014 · 6 mos · New Delhi

1. Security of code - Converted on-page queries into stored procedures.
2. File Tracking Software - Designed and Developed Software on ASP.NET (C#) & SQL Server 2012 to trace the movement of file carrying a unique id.
3. Technical Support - Provided Technical Support on various websites and softwares of Election Commission to the District Magistrates and Chief Electoral Officers of 3 states - Karnataka, Madhya Pradesh & West Bengal.
4. Documentation - Documented books of 3 states consisting complete report of General Elections 2014.