GAURAV MUNDEPI
+91-639******* ***********@*****.*** linkedin.com/in/gauravmundepi github.com/gauravmundepi PROFESSIONAL SUMMARY
Data professional with 2+ years of experience managing end-to-end data operations — data cleaning, validation, ER-based data modeling, and dashboard delivery — using SQL, Python, Power BI, and Excel. Skilled in building preprocessing pipelines and structured data models that keep large datasets accurate and analysis-ready, with hands-on QA experience catching data-quality issues before reporting. Comfortable working across relational databases (MySQL) and collaborating with development and business teams to define KPIs, meet delivery SLAs, and turn data into decisions. Quick learner looking to extend this foundation into cloud-based data operations (Azure ADF, Blob Storage) and enterprise data governance practices.
TECHNICAL SKILLS
Databases & Data Modeling: MySQL, ER Diagrams, Data Modeling, Normalization, Data Warehousing (concepts) Data Operations: Data Cleaning, Data Validation & QA, Data Mining, ETL Concepts, Preprocessing Pipelines Visualization & BI: Power BI, Excel, Dashboard Development, Matplotlib, Seaborn, BI Reporting Programming: Python, SQL, C
Machine Learning: Scikit-learn, Predictive Analytics, SMOTE, Feature Engineering Tools & Collaboration: Git, Jira, Streamlit, MS Word/Excel/PowerPoint, Documentation Other: Requirement Gathering, Market Research, Stakeholder Communication, Problem Solving PROFESSIONAL EXPERIENCE
Research Data Analyst — IP House Apr 2025 – Present
●Identified, collected, and organized data from public sources, social media, and online databases, maintaining consistent documentation and monitoring for data quality issues.
●Performed data mining and validation using MS Excel, cross-checking website-specific records for accuracy before they entered reporting.
●Delivered monthly structured reports via MS Word and PowerPoint, consistently meeting 100% of delivery deadlines through close coordination with colleagues.
●Applied strong understanding of IP rights and web research to interpret, verify, and structure data from social media and online platforms. Data Analyst — Countrees AI Technology Pvt. Ltd, Dehradun Jan 2024 – Apr 2025
●Owned end-to-end data preprocessing workflows — cleaning, transforming, and validating datasets using Python and SQL — improving downstream data quality and reliability.
●Designed ER diagrams and structured data models to support consistent, analysis-ready databases across projects.
●Built and maintained Power BI dashboards and visual reports, reducing manual reporting effort and giving stakeholders real-time access to insights.
●Built and deployed a customer churn prediction model (Python, Scikit-learn) achieving 87.8% accuracy, applying data QA and feature engineering across the full pipeline.
●Partnered with cross-functional teams to define KPIs and used Git/Jira to track data workflows and meet delivery timelines. PROJECTS
Bank Customer Churn Prediction Python, Scikit-learn, Imbalanced-learn, SMOTE
●Built and benchmarked 6 machine learning models (Logistic Regression, SVC, KNN, Decision Tree, Random Forest, Gradient Boosting) to predict customer churn on a 10,000-record bank dataset.
●Addressed class imbalance (~80/20 split) using SMOTE oversampling and implemented feature scaling and one-hot encoding within a complete preprocessing pipeline — mirroring the data cleaning and validation rigor this role requires.
●Achieved 87.3% accuracy and a 0.87 F1-score with Random Forest, the top-performing model across accuracy, precision, recall, and F1-score.
●Saved and deployed the final model using Joblib to enable real-time churn-risk prediction on new customer data. EDUCATION
B.Sc. in Data Science — ICFAI University, Dehradun 2022 – 2025 CGPA: 8.4 Class XII — UK Board 82.2%
Class X — UK Board 81.6%
CERTIFICATIONS & ACHIEVEMENTS
●Machine Learning with Python — Great Learning
●Problem Solving Through Programming in C — NPTEL, IIT Kharagpur
●Awarded "Fresher of the Month" and "Analyst of the Month" at IP House for outstanding performance and contribution.