SPARSH SONI

Data Analyst
Bengaluru, IN.

About

Highly analytical Data Analyst with 1 year of hands-on experience in leveraging Python, SQL, BI Tools, and machine learning to transform complex data into actionable insights. Proven ability to build robust dashboards, manage relational databases, and develop predictive models to drive data-driven decision-making and optimize business outcomes. Eager to apply advanced analytical techniques to solve challenging problems and contribute to strategic growth in a dynamic organization.

Work

Learnvista Private Limited
|

Data Analyst Intern

Bengaluru, Karnataka, India

→

Summary

Spearheaded data analysis initiatives for marketing campaigns and job market trends, leveraging advanced SQL and BI tools to drive data-driven strategies and actionable insights.

Highlights

Designed and implemented a robust MS SQL Server relational database, integrating diverse datasets (customer journeys, engagement, product info) and performing comprehensive ETL to ensure data integrity and accessibility for analysis.

Analyzed customer demographics, product performance, and campaign effectiveness, identifying key trends and delivering insights that informed targeted strategies to optimize Click-Through Rate (CTR) and conversion rates.

Executed comprehensive job market analyses by collecting, cleaning, and modeling multi-source job posting datasets using MS SQL Server and Excel, providing a unified view of market trends.

Developed and deployed interactive Power BI dashboards, leveraging DAX for dynamic measures and KPIs, to visualize job market trends, demand, top skills, and salary distributions, enabling data-driven strategic decisions.

Education

Ramaiah Institute of Technology
Bangalore, Karnataka, India

→

Bachelor of Engineering

Engineering

Grade: 8.80 CGPA

Publications

Publication by Elsevier Ltd.

Published by

Elsevier Ltd.

Summary

Research published in a peer-reviewed journal by Elsevier Ltd., demonstrating expertise in data analysis methodologies and contributing to academic knowledge in the field.

Certificates

Advance Data Science and AI Certification

Issued By

IBM

Skills

Maths & Statistics

Linear Algebra, Probability, Hypothesis Testing, Time Series.

Cloud and Deployment

AWS, Azure, Google Cloud.

Business Skills & Development Tools

KPI Design, A/B Testing, Data Storytelling, Git, Jupyter Notebook.

Machine Learning & AI

Scikit-learn, TensorFlow, Supervised Learning, Unsupervised Learning, Feature Engineering, Natural Language Processing, Neural Networks, Model Evaluation & Hyperparameter Tuning.

Programming and Databases

Python, SQL, Java, MS SQL Server, MongoDB, PostgreSQL.

Data Analysis & Visualization

Excel, Power BI, Tableau, Pandas, NumPy, Matplotlib, Seaborn.

Projects

Automated Ticket Classification Using NLP

→

Summary

Built a model that can automatically classify customer complaints based on the products and services that ticket mentions. To improve performance, data cleaning, text preprocessing, EDA, feature engineering, were carried out.

Bank Term Deposit Analysis

→

Summary

Developed a predictive machine learning model to forecast customer subscription to term-deposits using historical campaign data. Performed data preprocessing, exploratory data analysis, data visualization, feature engineering, and hyperparameter tuning to optimize model performance.