Data Analyst Python

SUMMARY

• Over *+ years experience as a Data Analyst using SQL and Excel for Data Extraction and Reporting purposes

• Experienced in Dashboards, for reporting using Excel Charts, PIVOT Tables, PIVOT Charts and LOOKUPs

• Experienced in performing Cleaning, ETL, Analysis, and generate insights from raw data using Python scripts.

• Proficient in using Tableau, Power BI for creating Data Visualizations EXPERIENCE

TopGrads, Lewistown, Montana, USA

Data Analyst May 2020 - Dec 2020

• Predicted salary of 800 graduate students based on grades earned in 5 courses using Microsoft Excel

• Formulated more than 75 SQL queries in analyzing the database as per the business scenarios

• Developed data visualizations using Python and Tableau for business KPIs that reduced manual reporting work by 8 hours weekly

• Achieved 97.5% accuracy on the test data using Linear Regression Humanitics Dimensions Limited, New Delhi, India Jan 2018 – May 2019 Data Analyst

• Formatted, cleaned, combined, filtered and performed experimentation on hundreds of line of data using Microsoft Excel, Tableau, Python’s Pandas and NumPy library

• Communicated with client to understand business needs and translate business needs into actionable reports in Tableau saving 7 hours of manual work each week

• Implemented data blending using 9 disparate data sources and prepared stories using Tableau for a better understanding of the data

• Developed interactive cohort analysis report in Tableau for the product team with filters and parameters that helped improve monthly retention by 17% for a specific customer segment

• Facilitated in creating 2 clustering machine-learning model to analyze customer lifetime value based on customer traits

SKILLS

Programming Languages: Python (NumPy, Pandas, Seaborn, and Matplotlib), R, C Tools: Microsoft Excel (Pivot Table, Macros, VBA), MS Word, Power BI, Tableau Database Language: MySQL, T-SQL, MS Access, Alteryx Analysis: Data Analysis, Data Analytics, Hypothesis Testing, Data Cleaning, Exploratory Data Analysis, Data Modeling, Data Management, Data Warehousing, Data Visualization, Data Collection Big Data: Hadoop, Hive, Spark, MapReduce, Scala.

Others: Business Intelligence, Microsoft PowerPoint, Statistics, A/B Testing, MS Word ACADEMIC PROJECTS

Stevens Institute of Technology

Segmentation of Mall Customers Dec 2020

• Created 5 clusters of mall customers on the annual income and spending score using Python

• Implemented KMEANS unsupervised machine learning clustering algorithm to classify customers into groups Movie Recommendation System May 2020

• Created a content based recommendation system to recommend movies to users using Python

• Implemented Cosine Similarity and TF IDF vectorization to find similarity between users and movies EDUCATION

Stevens Institute of Technology, Hoboken, NJ Expected May 2021 Master of Science in Data Science GPA 3.33/4.00

Related Courses: Applied Machine Learning, Introduction to Probability Theory, Web Mining, Big Data Technology Manipal University Jaipur May 2019

Bachelors of Technology in Computer Science & Engineering Related Courses: Engineering Mathematics, Natural Language Processing, Relational Database Management System Adam Street, Hoboken, NJ UTSAV ARORA 1-929-***-**** www.linkedin.com/in/utsav491 ******@*******.***

Contact this candidate