RAHUL MEHRA

DATA ANALYST
Hyderabad, IN.

About

Results-driven Data Analyst with 3+ years of experience, specializing in transforming complex datasets into actionable insights across diverse sectors including Finance, Healthcare, and E-commerce. Proven expertise in SQL, Python, Power BI, and Advanced Excel for ETL automation, interactive dashboarding, and predictive analytics. Successfully delivered data-driven solutions that increased revenue by 26%, reduced costs by 17%, and optimized operational efficiencies by up to 60% through strategic data storytelling and cross-functional collaboration.

Work

THE HACKETT GROUP
|

Data Analyst (IT, HR, Finance, GBS, Services & Marketing)

Hyderabad, Telangana, India

Summary

Led comprehensive data analysis and dashboard development across IT, HR, Finance, GBS, and Marketing, driving strategic insights and operational efficiencies for diverse clients.

Highlights

Designed and deployed an interactive HR & Payroll Dashboard, identifying a 28% higher attrition rate for employees earning ₹3L-6L and demonstrating a 14% increase in WFH employee productivity.

Automated monthly compensation audit reports using Python, reducing manual HR effort by 60%, and optimized payroll processing by 35% through automated SQL and Python scripts.

Developed an interactive Power BI dashboard for credit card financial analysis, driving a 26% increase in company revenue and a 17% decrease in overall costs by monitoring key performance metrics.

Constructed a comprehensive Power BI Dashboard for 4 fiscal years (2022-2025) using SQL, Python, and Excel, tracking 12+ critical KPIs and influencing FY2025 workforce investment decisions.

Conducted a Digital Maturity Leader Analysis on 100+ survey responses, revealing Top Performers reduced costs by 31% and achieved 2.6% fewer payroll errors through automation.

AI Variant IT & Services
|

Internship, Data Science

Bengaluru, Karnataka, India

Summary

Contributed to data science initiatives by developing machine learning models and end-to-end data pipelines for resume parsing and stock price prediction.

Highlights

Developed NLP-based resume parser and regression models, enhancing data extraction and predictive capabilities for stock-price forecasting.

Constructed end-to-end data pipelines, streamlining the process for ML model training, evaluation, and deployment.

Collaborated on proof-of-concept ML projects, effectively presenting outcomes and insights to key stakeholders.

TOPWAY LLC
|

Engineer

Muscat, Oman, Oman

Summary

Managed full project lifecycles, from planning to handover, overseeing procurement, execution, and resource allocation for engineering projects.

Highlights

Managed comprehensive project lifecycles from planning through handover, providing detailed reports on procurement, execution status, and resource allocation.

Utilized Oracle Primavera for robust project scheduling and monitoring, facilitating strategic reviews and effective communication with clients.

Education

Excel R Solutions
N/A, N/A, India

Certification

Data Scientist

Punjab Technical University
N/A, N/A, India

B. Tech

Civil Engineering

Languages

English
Hindi
Punjabi
Arabic

Certificates

Power BI Course

Issued By

IntelliPaat

Skills

Data Analysis & Business Intelligence

Data Analytics, Power BI Dashboard (DAX), Tableau, Advanced Excel, Google Analytics, Interactive Dashboarding, KPI Benchmarking, Data Storytelling, Automated Reporting.

Programming & Databases

SQL, Python, Pandas, NumPy, Matplotlib, Seaborn, ETL Automation, Complex SQL Queries (CTEs, Window Functions, Grouping Sets).

Machine Learning & Statistics

Machine Learning, Statistical Modelling, Predictive Analytics, NLP, Regression Models, Data Pipelines.

Project Management & Collaboration

Stakeholder Management, Cross-functional Collaboration, Project Lifecycle Management, Oracle Primavera.