Data Analyst Engineer

Aman Chaturvedi

Hartford, CT (Relocation Available) 860-***-**** ****************@*****.*** https://www.linkedin.com/in/aman-chaturvedi/ Data enthusiast with 3+ years of experience in interpreting and analyzing data in order to drive business solutions. Passionate about working with large amount of data and turn data into insights and insights into decision. Always fascinated about telling stories with data using visualization. EDUCATION

University of Connecticut School of Business, CT, USA Jan’2020- Dec’2021 MS in Business Analytics and Project Management 4.00/4.0 Rajasthan Technical University, India 2012-2016

Bachelor of Technology, Mechanical Engineering 3.65/4.0 TECHNICAL SKILLS

Programming Languages & Tools: Python (Pandas, NumPy, SciPy, scikit-learn, Matplotlib, Seaborn), R Studio, SQL, PLSQL, JCL, C++, C, Oracle RDBMS, SAS 9.4, SAS JMP Pro 13, SAS Enterprise Miner, TOAD, MS Excel (Macros, VLOOKUP, Pivot Tables, VBA), IBM Mainframes, MS Project, Hadoop (Sqoop, Pig, Hive, PySpark), Tableau, Power Bl, AWS, GCP, Azure Data Lakes, Informatica Power Center Data/ Business Analysis Techniques and Technologies: Machine Learning, Data Mining, Data Reduction, Statistical Modeling (Logistic Regression, Linear Regression, Neural Networks(CNN,DNN), Tree Based Methods, Ensemble models), Discriminant Analysis, Principal Component Analysis, Clustering, Naïve Bayes, K-NN, Data Preprocessing, Data Visualizations, Probability and Sampling Distributions, Statistical Tests(Hypothesis) and P values, Predictive Analytics, Business Intelligence, Quantitative Analysis, Agile, Trend Analysis, Deep Learning, Natural Language Processing, Time Series Forecasting, AB-Testing, ETL, Text Mining. WORK EXPERIENCE

Tech Mahindra Limited, Software Engineer (Pune, India) - Jan 2018 - Dec,2019

• Worked for the largest automaker of the world as data analyst & led a team of 5 members to perform fact-based analysis on complex data of vehicles by extracting useful information by manipulating the data (using SQL, Python) to find trends.

• Extracted unstructured data from Mainframes using JCL & sorted it using Excel VBA (later automated with xlwings using Python).

• Performed analysis on the raw data of customers to check the most popular car model in various countries based upon different criteria (age, gender, etc.) using clustering algorithms (in Python).

• Automated the complete process using Python to get real-time updates of the task which reduced manual human efforts by 50%.

• Did market research analysis to learn about the audience & their preferences to help the clients build marketing strategies.

• Did AB-Testing to understand liking of potential customers & finding new ways to convert them into leads & leads into customers.

• Provided presales and post-sales report to clients using Tableau doing SWOT analysis, which helped them make data-driven decisions. Tech Mahindra Limited, Associate Software Engineer (Pune, India) - Aug 2016 - Dec,2017

• Worked for Telecommunication company as a data engineer to build data pipelines & automated the ETL jobs for data arriving from different channels & vendors to store it into data warehouse.

• Used complex high-performance SQL queries to analyze the type of packs customer are using based upon (gender, work status, etc.).

• Analyzed the issues faced by customers and generated the trends using Tableau for different issues faced at various locations.

• Incorporated the changes based upon the feedbacks from customers to enhance the user experience using problem solving skills.

• Led transition of legacy application to a Python-based web portal used by client’s retail store employees, saving at least, 20-man hours per week. Handled the entire data transition during this migration so that real-time customers aren’t affected.

• Awarded “Pat on the Back” for making timely deliveries in the year 2017 by client. Capstone Project: Stanley Black and Decker (Global Tools & Storage) Hartford, USA Graduate Data Analyst Consultant Jan 2021 – April,2021

• Performed root cause analysis on vendor chargebacks billed by SBD by deep diving into historical data using SQL/ Excel (VLOOKUP) & creating intuitive and concise dashboards using Tableau to enable efficient tracking of purchase order fulfillment operations.

• Provided recommendations based on the trend analysis built using different statistical models (using Python/SAS/JMP), by identifying key metrics primarily responsible for the chargebacks so that the future chargeback can be minimized & optimizing current reporting system so that SBD can refute incorrect chargebacks to help them reduce the revenue loss & save time. ACADEMIC PROJECTS

Face Mask Recognition (Mask vs No Mask) Model Deep Learning Python Jan 2021 to Apr 2021

• Created various Convolutional Neural Networks (CNN) models to detect if people are wearing a mask appropriately before entering a building or any other crowded place to curve down the spread of COVID-19. Sentiment Analysis on Airline Twitter Reviews SAS Python Sep 2020 to Dec 2020

• Used Text Mining and NLP techniques to determine the Airline’s reputation, understand customer’s likes, dislikes and built a Supervised Machine Learning model to predict customer’s sentiment from the provided review.

• Did twitter scrapping using Python to extract latest tweets and use them to test our model. Bank Marketing Strategy for Predicting Term Deposit Subscribers JMP Python Tableau Jan 2020 to Apr 2020

• Used SEMMA approach and applied Machine Learning techniques to identify the existing clients that have higher chance to subscribe for a term deposit and focus marketing effort on such clients.

• Used various machine learning models such as Decision Trees, Regression (Logistic), Neural Networks.

Contact this candidate