ROHIT RAWAT
Senior Data Analyst
Delhi
Summary
Results-driven BI & Data Engineering Professional with over 8.5 years of experience in SQL, data visualization, and developing interactive dashboards using Power BI and Tableau. Expertise includes data modeling, query optimization, and automating ETL workflows with Azure Data Factory. Demonstrated success in integrating complex data sources and delivering actionable insights that enhance strategic decision-making. Committed to leveraging advanced analytics to drive business growth and operational efficiency.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Power BI Developer
Capgemini
Noida
01.2022 - Current
- Developed interactive Power BI dashboards to analyze consumer behavior trends, enabling real-time insights, and improving decision-making efficiency by 30%.
- Optimized DAX queries using DAX Studio and Tabular Editor, reducing report load times by up to 40%, and improving query performance.
- Designed and implemented data models in Power BI with efficient relationships and calculated columns, ensuring high-performance data retrieval for large datasets.
- Utilized Power Query to clean, transform, and enrich raw consumer data, reducing data preparation time by 25%, and ensuring data accuracy.
- Managed Power BI Service for report deployment, user access control, and workspace security, ensuring compliance with organizational security standards.
- Integrated Azure SQL Database with Power BI to provide dynamic and secure data connections for consumer analytics dashboards.
- Automated ETL workflows using Azure Data Factory improve data ingestion and transformation processes for large-scale consumer datasets.
- Leveraged Azure Synapse Analytics for large-scale data analysis and query performance optimization, enhancing reporting capabilities for complex consumer metrics.
- Created advanced measures and KPIs in Power BI using DAX, delivering actionable insights into consumer purchasing patterns and engagement.
- Collaborated with cross-functional teams to gather business requirements and deliver customized Power BI solutions, improving data-driven decision-making across departments.
BI Developer
RADCOM
Delhi
06.2020 - 12.2021
- Developed and enhanced dashboards using Grafana and Dundas BI, improving decision-making efficiency through tailored visualizations in collaboration with Product Managers.
- Designed and optimized XML files for CDR probes, and migrated data into aggregation tables (minute, hourly, daily, weekly), increasing data availability for analysis by 20%.
- Validated data consistency between CDRs and aggregation tables, reducing data discrepancies by 15% during development.
- Enhanced dashboard interactivity by modifying and creating custom JavaScript functionalities (parameter changes, selection actions, navigation), resulting in a 25% improvement in user experience.
- Managed user groups and administrative tasks, streamlining access control, and maintaining data security compliance.
- Implemented advanced filtering techniques (parameters, cubes, hierarchies) to enable dynamic data segmentation and improve reporting flexibility.
- Developed parameterized Vertica database cubes, improving dashboard loading times by 15%.
- Created time-series data visualizations for network traffic analysis (protocols, POD, VLAN), reducing manual effort.
- Automated client reporting workflows with NiFi, reducing report turnaround time by 30%.
- Designed dashboards from scratch, including Message KPI, Roaming OUT/IN, and Release Cause Distribution, enhancing operational visibility and stakeholder insights. Designed dashboards from scratch, including Message KPI, Roaming OUT/IN, and Release Cause Distribution, improving operational visibility and stakeholder insights.
Senior Software Developer
UST
Trivandrum
03.2016 - 06.2020
- Company Overview: UST - Netapp
- Developed and automated BI reports using SAP BO, Crystal Reports, and Web Intelligence to streamline reporting processes
- Designed parameterized, cross-tab, and drill-down reports for financial and sales dashboards, enabling actionable insights
- Resolved loops and optimized universes using joins, contexts, and aliases, improving report performance and reducing processing time
- Automated data migration and integration workflows with SQL stored procedures, enhancing data accuracy and efficiency
- UST - Netapp
SQL & BI Developer
UST
10.2019 - 02.2020
- Company Overview: UST - Presbyterian Healthcare Services
- Created and optimized SQL queries to extract, validate, and report on critical healthcare data
- Designed BI reports analyzing health insurance KPIs, including claims, financial data, and account-level insights
- Conducted data mapping and validation across health edge tools and OLAP databases to ensure data integrity
- Collaborated with business analysts to design SQL-based reports, improving operational decision-making
- UST - Presbyterian Healthcare Services
Tableau Developer
UST
02.2019 - 09.2019
- Company Overview: UST - Costco
- Designed Tableau dashboards to visualize retail KPIs, including purchase orders, sales trends, and inventory performance
- Created advanced visualizations (e.g., heat maps, scatter plots, box plots) to deliver actionable business insights
- Performed data preparation, blending, and cleansing across diverse sources to ensure dashboard accuracy
- Analyzed and visualized year-over-year and quarterly trends, enabling strategic planning and performance tracking
- UST - Costco
Tableau Developer
UST
06.2017 - 01.2019
- Company Overview: UST - Costco
- Developed interactive dashboards to track inventory metrics, gross margins, and store-level sales performance
- Built advanced calculations for time-series analysis and trend monitoring, improving forecast accuracy
- Transformed and cleaned large datasets for precise visualization and actionable insights
- Analyzed SKU performance and sales metrics to identify opportunities for operational improvements
- UST - Costco
BI Developer (AS400 Environment)
UST
03.2016 - 05.2017
- Company Overview: UST - Shoppers Stop
- Automated BI reporting workflows in AS400 using RPG, CL, and COBOL, improving operational efficiency
- Conducted system maintenance, data validation, and debugging, ensuring smooth reporting operations
- Developed test plans and implemented error-handling protocols, maintaining high data accuracy and reliability
- UST - Shoppers Stop
Education
B.Tech -
Noida Institute of Engineering and Technology
Noida03.2015
CBSE -
Evergreen Public School
Delhi03.2010
CBSE -
Vanasthali Public School
Delhi03.2008
Skills
- Data analysis
- SQL
- Power BI
- Tableau Desktop
- Grafana
- Python
- Git
- Statistical analysis
- Data modeling
- Jira
Certification
- PL-300 : Power BI Data Analyst.
- Tableau Desktop Specialist.
- DP-203 : Azure Data Engineering Associate (Limited Project Experience)
Languages
Highly proficient, Very good command
Timeline
Power BI Developer
Capgemini
01.2022 - Current
BI Developer
RADCOM
06.2020 - 12.2021
SQL & BI Developer
UST
10.2019 - 02.2020
Tableau Developer
UST
02.2019 - 09.2019
Tableau Developer
UST
06.2017 - 01.2019
Senior Software Developer
UST
03.2016 - 06.2020
BI Developer (AS400 Environment)
UST
03.2016 - 05.2017
B.Tech -
Noida Institute of Engineering and Technology
CBSE -
Evergreen Public School
CBSE -
Vanasthali Public School
Similar Profiles
INDHIRAN RINDHIRAN R
Senior Consultant at CapgeminiSenior Consultant at Capgemini
Aasma ShaikhAasma Shaikh
Manager- GADM North America (Transformation Lead -Industrialization & Automation) and Sales to Delivery Handover Facilitator at CapgeminiManager- GADM North America (Transformation Lead -Industrialization & Automation) and Sales to Delivery Handover Facilitator at Capgemini
Bélinda BONACINABélinda BONACINA
Document Management, quality and configuration at CAPGEMINIDocument Management, quality and configuration at CAPGEMINI
Namrata DwivediNamrata Dwivedi
Front End Developer at CapgeminiFront End Developer at Capgemini
AMAN SHARMAAMAN SHARMA
Jr. Buisness Analyst at Vidya Online Services Pvt Ltd.Jr. Buisness Analyst at Vidya Online Services Pvt Ltd.