Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

SONAL CHAPEGADIKAR

Kalyan

Summary

Detail-oriented Analyst with a proven ability to enhance data quality and operational efficiency through innovative solutions. Proficient in managing large datasets, developing GIS maps, and creating interactive dashboards. Skilled in statistical research and machine learning to ensure data integrity and reliability.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Associate

Wood Mackenzie
Edinburgh
10.2022 - 06.2024
  • Utilized SQL and Microsoft Access to handle 5,000+ data queries, reducing data inconsistencies by 55% and improving dataset dependability.
  • Developed and optimized GIS maps for over 50 EMEA projects using ArcMap/ArcGIS, incorporating critical data insights to facilitate strategic decision-making and spatial analysis.
  • Collaborated with cross-functional research teams to synthesize data insights, enhancing decision-making and aligning with business objectives.

Operations Analyst

SMARTe Inc
Navi Mumbai
05.2016 - 12.2018
  • Supervised the Agile framework for project development, monitoring new features, enhancements, and issues.
  • Monitored CRM operations: bringing in Opportunities, Accounts, and posting contracts in Salesforce.
  • Formulated and executed detailed product verification testing protocols, quality assurance processes, and acceptance standards.
  • Enhance the QA daily process by creating automated test systems that can execute repetitive testing and create quality reports.

Data Analyst Intern

SMARTe Inc
Navi Mumbai
09.2015 - 03.2016
  • Used SQL and Excel to manage large datasets and complex databases, improving reliability by 16%.
  • Designed 12 PowerBI-based interactive dashboards that visualized KPIs and gave top management relevant, actionable information.
  • Helped implement Client Data technology and maintained worldwide reference data management standards.

Education

Master of Science - Data Science and Artificial Intelligence

University of Liverpool
Liverpool, UK
01-2022

Bachelor of Engineering - Electronics & Telecommunication Engineering

G.H. Raisoni College of Engineering
Nagpur, India
06-2015

Skills

  • Python
  • R
  • SQL
  • RDBMS
  • Advanced Excel
  • Tableau
  • PowerBI
  • SAS
  • Matplotlib
  • Scikit-learn
  • GitHub Version Control
  • MS-Office (Word, PowerPoint),
  • Machine Learning Algorithm
  • Agile
  • AWS
  • Scrum
  • Confluence
  • Jira
  • Communication
  • Problem-solving
  • Time management
  • Adaptability
  • Leadership
  • Collaboration
  • Team building
  • Reporting
  • Data analysis
  • Data visualization
  • Statistical analysis
  • Data modelling
  • Data interpretation
  • Project management
  • Business analysis
  • Critical thinking
  • Decision making

Certification

  • SQL for Data Science, University of California, Davis (Coursera)
  • Data Science Prodegree, Imarticus Learning
  • IBM Data Science Professional Certificate, Coursera

Projects

  • Detection fake job postings using text classification (NLP)

- Utilized NLP pre-processing techniques, including tokenization, lowercasing, and lemmatization, to   prepare raw textual data for machine learning algorithms.

- Transformed the data into numerical vectors using Bag of Words (BoW), TF-IDF, and word embeddings.

- Successfully deployed and tested over 5 machine learning models, achieving a classification accuracy rate of 90% for job ads.

  • Use of Machine learning for fast and accurate anomaly detection in Industrial IoT

- Imported and merged network traffic data from CSV and p.cap formats into a single data frame using Pandas, processing over 1 million rows of data.

- Analyzed network packets and detected cyber attacks on Industrial IoT devices.

- Standardized models with fit-scalar functions and tuned hyperparameters, reducing Type-1 errors by 23% and improving precision by 18%.

  • Prediction and Analysis Of Default Rate Future Loan

- Created a data model to forecast the likelihood of defaulters and non-defaulters with techniques like SVM, Random Forest, Bagging and Logical Regression.

Timeline

Data Associate

Wood Mackenzie
10.2022 - 06.2024

Operations Analyst

SMARTe Inc
05.2016 - 12.2018

Data Analyst Intern

SMARTe Inc
09.2015 - 03.2016

Master of Science - Data Science and Artificial Intelligence

University of Liverpool

Bachelor of Engineering - Electronics & Telecommunication Engineering

G.H. Raisoni College of Engineering
SONAL CHAPEGADIKAR