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 2023Present · 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 2020Sep 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

Union public service commission( upsc )

Civil Services Aspirant

Jul 2016Feb 2020 · 3 yrs 7 mos · New Delhi, Delhi, India

Education

Guru Gobind Singh Indraprastha University

Bachelor of Technology (B.Tech.) — Electrical and Electronics Engineering

Jan 2012Jan 2016

G.S. Convent

Senior Secondary — PCM

Apr 2000Mar 2012

Stackforce found 100+ more professionals with Data Analytics & Data Visualization

Explore similar profiles based on matching skills and experience