A graduate student at New York University with a passion to explore and enhance skill set in the field of Data Science and Analytics. I am an enthusiastic and dedicated person who takes up responsibility and ownership of the work given to me. I love to work in a passionate team with positive attitude and craving to make a difference to the customers.
Aparna Bhutani
336 85 St
Brooklyn, NY - 11209
ab8473@nyu.edu
Masters in Science - Applied Urban Science and Informatics • August 2020
Masters in Technology - Information Systems • June 2019
Bachelor of Engineering - Information Technology • June 2013
Graduate Teaching Assistant• August 2019 - June 2020
• Conducted recitation for course CORE-UA 111: From Data to Discovery incorporating programming and data analysis using R language, for 60 students
• Taught students quantitative and algorithmic thinking, statistical modeling
Data Science Intern• June 2018 - August 2018
• Developed first in house Recommendation Engine prototype for Siemens Generator Services department to automate task/issue assignment process to employees
• Performed data exploration, text wrangling & processing. Implemented K nearest neighbors to find similar issues, Cosine similarity to find top 10 employees to solve issues
Data Analyst• January 2016 - May 2017
• Developed Tableau dashboards providing insights on various milestone KPIs to help business make strategic decisions
• Worked extensively with SQL to improve meeting customer commitments and increase operational efficiencies by utilizing a data driven root cause analysis approach
• Analyzed customer behavior patterns and recommended beneficial changes to the process. Increased customer retention rate by 15%
• Eliminated spreadsheet reporting, reduced processing time by 50% and increased reporting accuracy
Business Intelligence Analyst• November 2013 - January 2015
• Performed data analysis, data visualization for large volume of historical data
• Built and tested Extraction, Transformation, Loading process to migrate client data from multiple source systems into the data warehouse using SAP BI tool
• Retrieved and aggregated data from multiple sources and compiled it into actionable format
• Collaborated with cross functional teams for defect prevention activities related to business issues and critical operations
• Presented, reported key findings and issues in data reconsolidation, ETL to the client in a simple intuitive format
Performed Exploratory Data Analysis on HR Dataset to reason employee attrition rate
PythonCreated a Dimensional model for AdventureWorks database and performed data profiling and ETL using SSIS and Talend. Visualized the data using Tableau, Power BI to create interactive dashboards.
SSIS, Talend, MySQL, TableauAnalyzed and designed a normalized EER Model for YouTube database
Toad Data Modeler, MySQLPerfomed CI/CD and deployed a Java Spring Boot REST Api web app on AWS EC2 using TravisCI and CodeDeploy
AWS, TravisCI, JavaScrapped Indeed.com to train jobs using Naive Bayes Classifier and predict profile for resume taken from API endpoint
Scala, Spark, Python