Back to Developers
Mridul Mehta

Mridul Mehta

Data Analyst

India, Noida
75
Profile Score

Skills & Expertise (21)

Python Intermediate
7.8/10
1
Years Exp
SQL Intermediate
7.5/10
1
Years Exp
Power BI Intermediate
7.3/10
1
Years Exp
NumPy Intermediate
7.2/10
1
Years Exp
Pandas Intermediate
7.2/10
1
Years Exp
HTML CSS JavaScript Advanced Excel MS SQL Server MySql scikit-learn EDA Logistic Regression Linear Regression Ridge / Lasso Decision Trees Random Forests Gradient Boosting Jupyter Notebook MySQL WorkBench

Work Experience

Data Analyst

Ericsson India Pvt. Ltd.

Aug 2022 - Present

Performed data mining using structured datasets sourced from multiple job portals including Naukri, LinkedIn, Indeed, Monster, and Shine. Utilized Python (Pandas, NumPy) and SQL for data extraction, cleansing, transformation, and validation. Conducted exploratory data analysis (EDA) to identify trends and anomalies affecting hiring, attrition, onboarding efficiency, and payroll accuracy. Developed and applied machine learning models including Logistic Regression, Decision Trees, Random Forests, and Gradient Boosting for attrition risk prediction. Used Linear Regression, Ridge/Lasso Regression, and Isolation Forest techniques for payroll variance detection and anomaly identification. Applied K-Means clustering for workforce and onboarding segmentation analysis. Prepared and shared consolidated Excel datasets derived from mined data with recruiters and HR stakeholders for decision support. Automated payroll and compensation workflows including Annual Salary Reviews (ASR) using Python and Excel-based logic. Built automated data consolidation pipelines to merge payroll, compensation, and employee datasets from multiple HR systems. Implemented validation and control checks to flag discrepancies in payroll, reimbursements, and compensation data. Designed and maintained Power BI dashboards to track workforce metrics, audit data, and HR operational performance. Built interactive dashboards to visualize onboarding conversion rates, hit ratio, and turnaround time (TAT). Translated analytical outputs into executive-ready visual stories aligned with defined KPIs and business objectives.

Education

Bachelor of Technology in Electrical and Electronics Engineering - Hindustan College of Science and Technology

2014 - 2018 · Afghanistan

Certifications

Fundamentals of the Generative AI Playground Assessment

Ericsson India Pvt. Ltd. · 2025

Generative AI Drivers License

Ericsson India Pvt. Ltd. · 2025

Responsible Use of Generative AI

Ericsson India Pvt. Ltd. · 2025

Track 1: Introduction to Machine Learning

Skillsoft · 2025

Track 2: Supervised Learning I: Linear and Logistic Regression

Skillsoft · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 0/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 75/100

Profile Overview

Member sinceFeb 2026

Skills (21)

Python SQL Power BI NumPy Pandas HTML CSS JavaScript Advanced Excel MS SQL Server +11 more