Rohit Kumar Jain

Business Analyst

West Delhi, Delhi, India9 yrs 11 mos experience

Highly Stable

Key Highlights

5+ years of experience in Data Analytics and Consulting.
Expert in Power BI and SQL for data visualization.
Proven track record in improving process efficiency.

Stackforce AI infers this person is a Data Analytics professional with expertise in Consulting and E-commerce sectors.

Contact

Skills

Core Skills

Data AnalyticsData VisualizationStatistical AnalysisData Management

Other Skills

Advanced ExcelAnalytical SkillsBusiness InsightsCommunicationCritical ThinkingDAXDashboardDashboard BuildingDashboardingData CleaningData ModelingData ValidationDatabase Management System (DBMS)DatabasesExcel

About

A Data Analyst with 5+ years of Power bi and SQL experience in Analytics and Consulting industry. I also like to play chess and I post my ideas at https://www.instagram.com/chess_n_life?igsh=azJjZWZ3aGEyb2M4

Experience

9 yrs 11 mos

Total Experience

3 yrs 7 mos

Average Tenure

2 yrs 9 mos

Current Experience

Mercer

Data Analyst - Survey Administration

Sep 2023 – Present · 2 yrs 9 mos · Gurugram, Haryana, India

Compensation Benchmarking & Analytics: For Total Rewards, conducted statistical outlier validation, multi-year trend analysis, and survey mapping using Power Query, SQL, Python, and Advanced Excel, streamlining rewards and compensation analysis.
Survey Delivery & Insight Reporting: Managed end-to-end survey administration—from data collection and cleaning to loading and validation—while delivering multi-year trend insights to support pay equity and workforce planning. Built and maintained Power BI dashboards for revenue tracking and internal decision-making.
Client & Stakeholder Engagement: Collaborated with client HR Heads and Rewards Teams to understand role and level mapping for compensation benchmarking; shared SOWs, ELs, and Invoices; conducted report walkthroughs and addressed post-delivery data requests. Coordinated with internal Survey, AST, and leadership teams to align data inputs and deliver strategic reports.
Revenue Contribution: Contributed to ₹5 lakh in revenue through successful delivery of client projects as part of the consulting team, supporting compensation benchmarking and advisory engagements.
Process Efficiency: Improved benchmarking workflows with Power Query, improving accuracy and reducing manual effort by 20% for the internal analytics team.

Power QuerySQLPythonAdvanced ExcelPower BIData Analytics+1

Globallogic

Senior Analyst

Feb 2020 – Sep 2023 · 3 yrs 7 mos · Gurugram, Haryana, India · On-site

Product Categorization & Data Management: Analysed and categorized e-commerce products using SQL, ensuring data alignment with project guidelines to improve product visibility for Google Shopping.
Data Integration & Dashboarding: Built interactive Power BI dashboards by integrating large datasets from MySQL and Excel (over 1 million records), enabling sales trend analysis and business forecasting.
Performance Optimization: Improved Power BI dashboard performance using DAX Studio, reducing storage by 30% and enhancing processing speed by 10%.
Cross-Functional Collaboration: Worked with audit and quality teams to refine analytics and delivered Advanced Excel reports to provide actionable insights on a weekly basis.
Created ETL processes to transform and load data into analysis pipelines, increasing efficiency for e-commerce product categorization.

SQLPower BIDAXMySQLAdvanced ExcelData Analytics+1