Rohit Kumar
Gurgaon
Summary
Microsoft Certified Data Analyst Associate with around 3 years of experience in Data Analytics, Business Intelligence, Reporting using tools such as Power BI Desktop, DAX, Power BI Services, SQL
Overview
3
3
years of professional experience
1
1
Certification
Work History
Power BI Developer
Reckitt Benckiser Inc. (Adglobal360)
05.2024 - 02.2025
- Automated data imports from multiple SharePoint sites having CSV files into Power BI Desktop using Power Query.
- Developed reports incorporating four key performance indicators (KPIs): Stock Availability, Share of Search, Content Score, and Discount, with analysis by platform (e.g., Amazon, Blinkit), brand, category, and store.
- Designed a consolidated summary page for all platforms and a data-check dashboard using live connections to ensure daily data accuracy, reducing manual data validation time by 30-60 minutes daily.
- Set up Power BI workspaces and Apps, managing user permissions for secure access.
- Utilized Excel for comprehensive data validation and quality control.
Power BI Developer
Powersolve (RAS Software Solution)
02.2022 - 05.2024
- Analyzed sales data to derive insights of products sold based on customer attributes in Power BI
- Implemented analytics using DAX to identify top potential repeat customers by age group, demographics, and income resulting in 20% growth in revenue
- Conducted sales analysis and forecasting to assess the impact of promotions and offers on sales performance, leading to a 15% increase in profit
- Managed supply chain data to track critical KPIs such as On-time, In-full, and OTIF delivery by customers and cities, meeting stakeholder requirements enhancing customer satisfaction by 14%
- Imported and transformed data from Excel, SQL Server, and CSV files using Power Query
- Wrote SQL queries to extract data into Power BI from large datasets
- Designed Data model with one-to-many relationships (star schema) in Model view
- Used DAX to create key performance indicators (KPIs), measures, calculated columns, and tables
- Constructed interactive dashboards with various visuals including charts, matrix, maps, and tables
- Implemented filters and slicers on visuals and Pages to enable diverse data views
- Implemented Row-level Security (RLS) using roles and assigned in Power BI Services after report publish
- Configured scheduled and incremental refresh, utilizing the gateway for on-premises data connections
- Leveraged Report Builder for creating paginated reports.
Education
Masters of Computer Applications -
I.G.N.O.U.
01.2015
Skills
- SQL Server SSMS
- Power BI Desktop
- DAX
- Data Visualization
- Business Intelligence
- Power BI Services
- MS Excel
- Data Modeling
- ETL
- Data Validation
- Report Builder SSRS & SSAS
- Power Query
Certification
- Microsoft Certified: Power Bi Data Analyst Associate (PL-300), 2023-2025
- KPMG AU - Data Analytics Job Simulation, 11/01/23
Timeline
Power BI Developer
Reckitt Benckiser Inc. (Adglobal360)
05.2024 - 02.2025
Power BI Developer
Powersolve (RAS Software Solution)
02.2022 - 05.2024
- Microsoft Certified: Power Bi Data Analyst Associate (PL-300), 2023-2025
- KPMG AU - Data Analytics Job Simulation, 11/01/23
Masters of Computer Applications -
I.G.N.O.U.
Similar Profiles
Isabella AsiataIsabella Asiata
Softgel Operator at Reckitt Benckiser Inc.Softgel Operator at Reckitt Benckiser Inc.
ADEEL AHMADADEEL AHMAD
Territory Sales Incharge at Reckitt Benckiser India Pvt LtdTerritory Sales Incharge at Reckitt Benckiser India Pvt Ltd
Aditya SomaniAditya Somani
Finance Director Singapore & Productivity Lead for MSV Cluster at Reckitt BenckiserFinance Director Singapore & Productivity Lead for MSV Cluster at Reckitt Benckiser