Data Analyst Python

Anshul Nitin Maathur

Jersey City, New jersey *************@*****.*** 862-***-**** www.linkedin.com/in/anshul-maathur Result oriented Data Analyst leveraging 2+ years of experience with functional and industry experience with proven track record in Data Analysis, Data Cleansing, Data Modeling, Data Validation and Report Creation. EDUCATION

New Jersey Institute of Technology Master of Science in Information Systems September 2017 - May 2019 Indus University Bachelor of Technology in Electronics and Telecommunication June 2012 - June 2016 EXPERIENCE

Data Analyst Wyndham Hotel and Resorts, New Jersey November 2019 - March 2020

• Built Data dictionary and Data mapping for ETL to support Data warehouse project, slashed search time by 40%

• Developed Financial KPI tracker in Tableau for MoM, QoQ and YoY to provide deep insights on revenue generation

• Executed complex SQL queries to validate data accuracy & perform RCA in OLTP - OLAP transfer to provide actionable insights

• Performed data cleaning for 100k+ data records using Python packages (Pandas, Numpy, Sci-kit learn) to analyze exploratory and statistical data

• Performed Data Validation in Excel (VLOOKUP/HLOOKUP) to generate reports to present in monthly meetings

• Identified, managed, updated and tracked bugs effectively using Defect Tracking Tool HP ALM and Jira

• Utilized agile software development methodology (SDLC) to ensure on-time package and build deployment Data Analyst Homer E-Learning, New York June 2018 - August 2018

• Collaborated with Marketing & Product team to identify business requirements and built KPI tracker dashboard using Looker

• Performed Cluster analysis and Basket analysis to provide insights on ways to increase user retention by 30%

• Unified data extracted by analysts from a wide variety of data sources using SQL queries to generate impact analysis reports

• Built and evaluated different models in Python to identify trends in financial data and perform revenue analysis

• Tracked and resolved 30 bugs using Bug tracking tool (Jira) in an aggressive timeline of 6 weeks before product deployment

• Actively engaged in Sprint Planning meetings to breakdown business requirements into periodically achievable milestones Data Analyst Lara Incorporate, India January 2016 – August 2017

• Forecasted customer demand with 80% accuracy using ARIMA time-series model and automated weekly forecast reports

• Created weekly forecast vs. actuals sales report using Advanced Excel to present in weekly stand-ins

• Automated data cleaning process using Python scripts for unstructured and structured data mined from different sources

• Validated quotes and negotiated agreements with 3PL transportation partner & raw material providers based on forecast PROJECTS

Predictive analysis on German Credit Dataset

• Objective – develop a credit scoring rule to determine if the new applicant is good/bad risk for banks to extend loans

• Formatted, cleaned, and assigned dummy variables to manipulate data using python libraries (Numpy & pandas)

• Predicted the credit score by implementing ML algorithms (Decision Tree and Neural Network) with 71% accuracy Predictive analysis on Diabetes Dataset

• Objective – diagnostically predict whether patient has diabetes, based on diagnostic measurement parameters

• Employed Pandas, Numpy, Matplot lib, Sci kit-learn in Python to develop several machine learning models

• Utilized algorithms such as Logistic regression, Support Vector Machine, Naïve-Bayes. Performed Data analysis to derive valuable insights from data

SKILLS

Analytical Tools: Python, SQL, Tableau, PowerBI, Looker, Advanced Excel, Sci-kit Learn, Numpy, Pandas, Seaborn Business and Data Analytics: Data Mining, Data Wrangling, Machine Learning Classifications, Clustering Other: JIRA, HP Application Lifecycle Management (ALM), Confluence, Git, MS Office, Unix/Linux, Sharepoint

Contact this candidate