Aditya Jain

I am a passionate and experienced data analyst with a keen eye for detail and a strong analytical mindset. With a background in statistics and data-driven decision-making, I excel at extracting insights from complex data sets to drive meaningful business outcomes. I have a proven track record of using data to identify patterns, trends, and opportunities and presenting my findings in a clear and concise manner to stakeholders.

As a data analyst, I am well-versed in various data analysis tools and techniques, including SQL, Python, R, Excel, and Tableau. I am also skilled in data visualization and have a knack for creating visually appealing and informative dashboards and reports. I am comfortable working with large data sets and am adept at data cleaning, data modeling, and data visualization to support decision-making processes.

In addition to technical skills, I possess strong communication skills, both written and verbal, which allow me to effectively communicate complex findings to non-technical stakeholders. I am a collaborative team player who enjoys working in a fast-paced environment and thrives on solving complex problems using data-driven insights.

I am a continuous learner, always eager to stay up-to-date with the latest advancements in the field of data analysis. I hold a bachelor's degree in Finance and have completed some certifications in data analysis and visualization. I am driven by curiosity, and I approach every data analysis task with a high level of enthusiasm and dedication.

In my free time, I enjoy exploring new data analysis techniques, staying up-to-date with the latest industry trends, and volunteering in my community. I am passionate about leveraging data to make informed decisions and drive positive change.

Overall, my combination of technical expertise, analytical mindset, and strong communication skills make me a valuable asset as a data analyst, and I am excited to continue leveraging data to unlock insights and drive business success.

• Designed and executed complex SQL and Python queries for data transformation efforts. Conducted data analysis on multiple databases after cleaning sales data to interpret trends and patterns. Achieved a 10% increase in sales through data-driven insights and a 15% improvement in forecasting accuracy. 
• Consolidated findings into centralized dashboards using Tableau and other end-to-end analytical data products and made close to 30 Tableau dashboards to enable leadership to have visibility of ongoing business operations.
• Collaborated with data managers to develop statistical models and reports utilizing SQL and R, also leading to a 14% increase in customer rating and delivery of actionable insights for decision-making.
• Maintained high accuracy and being scrupulous while working with large data sets and complex systems.
• Performed routine processing of large volumes of data daily and weekly.
• Managed and resolved escalated calls professionally, leading to a commendable satisfaction rating of 95%.

Advance Statistics for Data Science, Database Foundation for Data Science, Business Analytics with R, Data Visualization, Applied Econometrics, Big Data

Credit Card Churn Analysis (Python, Tableau, Machine Learning) Aug 2022 – Nov 2022

• Cleaned data and conducted feature engineering. Categorical variables were encoded according to 3 levels.
• Used logistic regression, clustering, decision tree, neural network, and gradient boosting model pipeline with hyperparameter optuna, classification and analyzed the dataset of credit card customers. Machine learning (ML) models were built to predict which customers will churn and achieved a ROC AUC score of 0.993 in the final model.

Built scalable database having 15 tables and normalized data to create tables and eliminate redundancy, additionally designed Entity Relationship Diagram. Created SQL queries and derived interesting insights from the data. Created, populated, and inspected the tables using SQL to make reports on the data and implement all data analysis phases