Saurabh Kumar
Gurgaon
Summary
Dynamic and results-oriented data professional with 8+ years of extensive experience in Power BI and SQL. Proven track record in optimizing reporting processes and enhancing data accuracy, leading to improved decision-making. Adept at collaborating with cross-functional teams, leveraging strong analytical skills to drive business growth and operational efficiency.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Associate consultant
Softwareone India private limited
10.2022 - Current
- Collaborated with business analysts and stakeholders to clarify data requirements and objectives, ensuring alignment with project goals.
- Design and develop data models and relationships that effectively represent the underlying data structure.
- Transform raw data from various sources into usable datasets for reporting and visualizations.
- Create interactive, visually appealing dashboards, and reports using Power BI.
- Utilize DAX (Data Analysis Expressions) for creating complex calculations, measures, and KPIs.
- Developed and maintained ETL processes to streamline data flow and improve data accessibility.
- Optimize Power BI reports and dashboards for efficient performance, considering data volume and complexity.
- Diagnosed and resolved issues related to data sources, transformations, and visualizations, enhancing overall data integrity and reliability.
- Document data models, transformations, and development processes for future reference.
- Led a Power BI team of 5 to 6 members, overseeing project execution and team collaboration.
DM
ICICI Bank Ltd
10.2021 - 07.2022
- Analyzed customer and transaction-level data to support operational decision-making, identify trends, and ensure compliance with internal banking policies, enhancing overall operational integrity.
- Worked with large datasets related to customer onboarding, credit, or transactions, ensuring data accuracy and consistency across systems.
- Collaborated with operations, risk, and compliance teams to resolve data discrepancies, improving reporting accuracy and quality.
- Cultivated understanding of financial KPIs, regulatory requirements, and data governance, strengthening compliance and reporting frameworks.
- Performed data validation and reconciliation to ensure alignment between source systems and reported figures.
Executive
Baja Alliance General Insurance company Ltd
02.2021 - 10.2021
- Collaborated with senior management to identify business needs and translated them into actionable reports for strategic decision-making.
- Analyzed insurance policy and claims data to support underwriting and operational decision-making.
- Interpreted data for higher management, enabling informed corrective actions based on insights.
- Monitored key insurance metrics, such as policy volumes, premium collections, and claim ratios, for management reporting.
- Built data visualization using SQL and Power BI for business KPIs that reduced manual reporting.
- Developed comprehensive reports on product development and design, enhancing clarity and direction for project teams.
- Create pivot tables, and modify spreadsheets to achieve analytical goals.
Subject matter expert
Paisabazaar marketing and consulting Pvt Ltd
11.2015 - 01.2021
- Analyzed large volumes of customer and lead data from web platforms to support sales conversion, partner performance, and business growth initiatives.
- Collaborated with product, sales, and partner teams to deliver data-driven insights on customer eligibility, campaign effectiveness, and drop-off rates, enhancing decision-making processes.
- Supported data extraction and reporting automation efforts, reducing manual reporting effort, and improving turnaround time for business stakeholders.
- Developed and maintained dashboards and reports using Power BI and SQL to visualize lead funnel metrics, disbursements, and bank performance, supporting strategic initiatives.
- Tracked key KPIs, including lead-to-application conversion, approval rates, and turnaround time (TAT) for loans and credit cards, informing performance optimization efforts.
- Performed data cleaning, validation, and reconciliation to ensure accuracy of customer, application, and conversion data across multiple partner banks.
Education
MCA -
Indira Gandhi National Open University
01-2018
BCA -
Indira Gandhi National Open University
01-2011
10+2 -
BSEB
03-2010
High School -
BSEB
03-2008
Skills
- Python
- Excel
- Power BI
- SQL
- Data governance
- Dynamics 365 Business Central
- Power BI services
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Disclaimer
I hereby declare that the information given above is true to the best of my knowledge and beliefs.
Hobbies and Interests
- Playing Chess
- Traveling
- Interacting with new people
Timeline
Associate consultant
Softwareone India private limited
10.2022 - Current
DM
ICICI Bank Ltd
10.2021 - 07.2022
Executive
Baja Alliance General Insurance company Ltd
02.2021 - 10.2021
Subject matter expert
Paisabazaar marketing and consulting Pvt Ltd
11.2015 - 01.2021
MCA -
Indira Gandhi National Open University
BCA -
Indira Gandhi National Open University
10+2 -
BSEB
High School -
BSEB