MOHIT

Proactive Data Analyst with 2+ years of hands-on experience in data management, automation, and dashboard reporting. Skilled in transforming raw datasets into actionable insights to enhance decision-making and business performance. Experienced in working across multiple business domains including finance, product analysis, and operations. Strong communicator and collaborator with a track record of streamlining data processes and supporting organizational growth through analytical solutions.

• Data Analyst, SLA Consultants India, Delhi, 01/01/23 - 06/30/23
• Data Science, EXCLR

• Coding
• Read books
• Travelling

• Honest and self-confident
• Dedicated and hardworking
• Strong learning skills

1. Income Prediction Model (Regression Analysis)

• Built a predictive model to estimate individual income levels using Python and Scikit-Learn.
• Conducted data preprocessing, feature encoding, and feature selection to improve accuracy.
• Applied outlier detection (Isolation Forest) and scaling techniques to enhance model performance.

2. Customer Segmentation & Analysis (Clustering)

• Implemented K-Means clustering to segment customers based on purchasing behavior and demographics.
• Performed data cleaning, normalization, and feature engineering for improved segmentation.
• Delivered actionable insights for targeted marketing, improving customer engagement strategies.

3. DRS Tracking Dashboard (Automation & Reporting)

• Automated daily email-based reporting system using Google Sheets and Apps Script.
• Designed a real-time dashboard showing DRS submission status by department, team lead, and employee.
• Reduced manual work by 80% through automated data collection and time tracking.

4. Business Insights Dashboard (Power BI)

• Created interactive Power BI dashboards for business locations, CSR interventions, and institutions.
• Integrated Excel-based dynamic data updates with filters for State, Entity, and Cluster.
• Enabled management to analyze 1,500+ data points with state/district-level insights.