MOHD SHAVHEJ

Data Analyst | Business Intelligence Specialist
Meerut, IN.

About

Highly analytical and results-driven Master of Computer Applications student with a strong foundation in data analysis, business intelligence, and programming. Proven ability to leverage Python, SQL, Power BI, and Tableau to extract actionable insights, develop interactive dashboards, and drive data-informed decisions, as demonstrated through impactful projects in ride-sharing, e-commerce, and HR analytics. Eager to apply advanced analytical skills and a passion for data-driven problem-solving to contribute to a dynamic organization.

Work

OLA Cabs (Project)
|

Data Analyst / Business Intelligence Developer

Meerut, Uttar Pradesh, India

Summary

Analyzed extensive ride data for OLA Cabs to identify patterns, improve driver allocation, and predict high-demand areas, enhancing ride availability and customer satisfaction.

Highlights

Processed and transformed over 100,000 rows of complex ride records using Python (Pandas) and SQL for robust analysis.

Uncovered key insights into peak booking hours, top-performing cities by revenue, and critical cancellation trends.

Developed and recommended data-driven strategies for optimized driver allocation, resulting in a 20% reduction in customer wait times.

Leveraged regression analysis to accurately predict high-demand areas, significantly improving Ola's ride availability and operational efficiency.

Amazon (Project)
|

Business Intelligence Developer / Data Analyst

Meerut, Uttar Pradesh, India

Summary

Developed an interactive Power BI dashboard for Amazon sales data, enhancing real-time decision-making and optimizing inventory across multiple product categories.

Highlights

Engineered an interactive Power BI dashboard to visualize Amazon sales performance across diverse product categories.

Designed and implemented custom DAX measures for critical KPIs, including Total Revenue, Profit Margin, and Monthly Growth, providing deep business insights.

Identified top-selling products and underperforming items, enabling simulated recommendations for optimized inventory management.

Streamlined reporting processes, reducing manual reporting time by 80% and facilitating real-time, data-driven decision-making for stakeholders.

Employee Performance (Project)
|

Data Analyst / HR Analytics Developer

Meerut, Uttar Pradesh, India

Summary

Analyzed employee data and developed a Power BI dashboard to visualize performance trends, training impact, and attrition risk, providing actionable insights for HR.

Highlights

Integrated and cleaned diverse datasets from HR, training, and payroll systems using SQL and Python (Pandas) for unified analysis.

Performed statistical analysis to accurately identify top and low performers across departments and tenure levels.

Developed a comprehensive Power BI dashboard to visually represent performance trends, assess training impact, and forecast attrition risk.

Revealed a direct correlation: employees completing >80% of training modules achieved 25% higher KPI targets, demonstrating training effectiveness.

Presented actionable data-driven insights to HR, directly informing performance appraisals and strategic upskilling program development.

Education

Swami Vivekanand Subharti University
Meerut, Uttar Pradesh, India

Master of Computer Applications

Computer Applications

Chaudhary Charan Singh University Meerut
Meerut, Uttar Pradesh, India

Bachelor of Computer Applications

Computer Applications

Awards

Deloitte Australia Data Analytics Job Simulation

Awarded By

Forage / Deloitte Australia

Successfully completed a virtual job simulation focused on data analysis and forensic technology, including the creation of a Tableau dashboard and leveraging Excel for drawing business conclusions.

Skills

Programming & Databases

Python, Pandas, Numpy, SQL, MySQL.

Data Visualization

Tableau, Power BI.

Data Analysis & Business Intelligence

Advanced Excel, Business Analysis, Data Analysis, Customer Acquisition.