Data Analyst

AMEY BHIVSHET

Boston, MA ********.*@************.*** 857-***-**** LinkedIn Profile Link GitHub Link Motivated, team player, and a highly organized professional with excellent communication and management skills who has an extremely detail and process-oriented keen eye. Bringing forth the ability to synthesize quantitative information and interact effectively with colleagues and clients.

EDUCATION

Northeastern University : Master of Science - Data Analytics (GPA: 3.91) Exp. May 2021 PCCE (Goa University) : Bachelor of Engineering – Computer Engineering (GPA: 3.7) Aug 2017 TECHNICAL SKILLS

Programming Languages : Python, R, JavaScript, RShiny. ETL Tools : Alteryx, Talend, SSIS, SSDT.

Data Tools : Microsoft Excel, QlikView, Google Analytics, Microsoft Office. BI Tools : Tableau, Microsoft Power BI.

Databases : Microsoft SQL Server, MySQL, PostgreSQL. Techniques : Linear Regression, Logistic Regression. Certification : Tableau Analyst.

INDUSTRY EXPERIENCE

Brigham & Women’s Hospital, Boston Research Intern (Data Analyst) Aug 20 – Jan 21

• Involved in a research project based on understanding the Cisplatin-associated acute kidney injury.

• Extracted patient data from various source .txt files and transformed them into readable .csv files using R.

• Merged multiple files with varying number of columns and 1000’s of rows leveraging Excel power query.

• Produced interactive Tableau dashboards and developed detailed reports highlighting the results that helped the researchers make appropriate data-driven decisions.

• Wrote a R function that eased the process of finding the earliest medication date for a specific patient from 20K rows of data reducing manual effort by 80%.

• Improved identification of patients with comorbidities by 10% after combining the outputs obtained from text- matching and ICD codes.

• Modeled logistic regression for allocating scores to the important variables that helped in identifying the patients with a higher risk of acute kidney injury.

Northeastern University, Boston Graduate Teaching Assistant (Statistics) Sep 19 - Dec 19

• Conducted lab sessions introducing students to use R for statistical analysis.

• Collaborated with the professor and designed lab references and assignments using Rmarkdown.

• Assessed assignments of 40 international students and provided productive feedback to enhance their learning. National Informatics Centre, India Software Developer Nov 17 - May 18

• Developed a cross-platform application using Cordova and AngularJS for government officials that visualized retailer data in the form of bar charts, pie charts, tables delivering detailed information.

• Extracted JSON data from APIs and transformed the data to meet the requirements. ACADEMIC PROJECTS

A/B testing new website design (Python) Sep 19 - Dec 19

• Built a statistical model in Python that determined which version of the website performed better.

• Formulated Hypothesis, identified key metrics and used confidence intervals to make a decision. Data Warehouse & Business Intelligence (SQL Server, Talend, SSIS, Power BI) Jan 20 - Apr 20

• Built an enterprise Data warehouse to integrate Medicare data of healthcare providers payments, utilizations, OPR’s.

• Profiled data and generated reports using Talend which helped in understanding the overall structure of the data.

• Pipelined millions of rows from multiple sources into a data warehouse consisting of star schema using SSIS.

• Created lookup tables using SQL and implemented Error Handling, Load Statistics, Slowly Changing Dimensions and Performance Tuning thus making sure that data is consistent and free of errors.

• Identified the states where there could be a possible misuse of prescriber opioids utilizing Microsoft Power BI dashboard.

Stock Price Prediction using Deep Learning (Python, Keras) May 20 - Jul 20

• Devised and incorporated a forecasting model based on LSTM recurrent neural network using Keras library in Python.

• Forecasted the opening stock price for the next 20 days and compared the results with the actual prices.

Contact this candidate