Pranav Prava

** ********** *****, ***. *, San Francisco, CA, USA 94131 518-***-**** mailto:adhxhy@r.postjobfree.com OBJECTIVE

Analytics Graduate seeking Business Analyst and Junior Data Analyst related full-time opportunities. Experience with different projects, assembled necessities from business stakeholders, and performed process analysis. EDUCATION

MASTER OF PROFESSIONAL STUDIES IN ANALYTICS NORTHEASTERN UNIVERSITY, BOSTON SEPT 2018 – JUN 2020

Related Courses: Data Visualization Database Design & Warehousing Data Mining Business Intelligence BACHELOR OF TECHNOLOGY IN ELECTRONICS AND COMMUNICATION GMRIT, INDIA SEPT 2012 – APR 2016

SKILLS AND ABILITIES

Programming Languages: SQL, R, Python, C, C++, JavaScript, HTML, MATLAB, CSS, LaTeX

Business Intelligence: Tableau, Power BI, Spotfire, Google Analytics, RShiny, Qlikview, Ad-hoc reporting

Database Systems: MySQL, SQL Server, Docker, MongoDB Others: MS Excel (VLOOKUP/Pivot tables), Linux, Bash Eclipse Machine Learning: Regression, Classification, Clustering(K- means), Hypothesis (A/B) testing, Forecasting

ML Libraries: pandas, numpy, sk-learn, keras, matplotlib, seaborn, tensorflow

Cloud Technologies: Hadoop, Spark, Cloudera VMWare, Amazon S3

PROFESSIONAL EXPERIENCE

BI INTERN REDCROW APR 2020 – JULY 2020

• Investigated the success factors associated with health care startups from public API’s mainly Crunch Base, Tech Crunch and Angel List.

• Programmed data cleaning, wrangling and integration of Crunch Base data in R using libraries tidyverse, dplyr, ggplot, margittr and lubridate

• Developed metrics that provide healthcare start-up data for process measurement and identifying KPI's for future improvement opportunities

• Designed interactive dashboards in Power BI and Tableau and performed EDA in MS Excel using VLOOKUP, PIVOT TABLES

• Implemented decision tree classifier predicting the funding success with an accuracy rate of 91%, over an increment of 10% over the mainstream model using rpart, rpart.plot packages and ctree in R

• Statistical analysis performed on CrunchBase data showed 70-80% of investors raised funds for healthcare and biotech startups that showed successful outcomes as compared to other categories JUNIOR BUSINESS ANALYST TECHMAHINDRA MAY 2017 – AUG 2018

• Worked closely with BI team and project managers to develop data infrastructure efficiency to 94% by using BI tools like Microsoft Power BI, Qlikview to develop and provide data to stakeholders

• Collaborated with cross-functional teams to structure problems, identify appropriate data sources, extract, transform and load data by using Python libraries for PETL like panadas and develop integrated information delivery solutions

• Develop and produced a framework on managing projects through status meetings, weekly reports, identifying risks, and tracking issues by setting up KPI’s using STORED PROCEDURES in MySQL

• Create and revitalized analytical approaches to perform analysis and Ad-hoc reports of domain-specific source data by using Spotfire to maintain management system as well as improving the operational performance by 82%

• Accelerated an increase of 75% population in fiber net compared to traditional internet cable by implementing A/B hypothesis in R ACADEMIC PROJECTS

CONMED- CANADA SALES DATA ANALYSIS

• Cultivated psychographics along with demographics to understand the behavioral pattern of users and their demand on medical equipment requirement through ‘text mining’ using MySQL

• Identified business requirements and devised implementation strategies to solve business problems by using EDA and Python along with packages like pandas, numpy, matplotlib and seaborn for data cleaning and wrangling.

• Created Power BI dashboards to cater the business needs and attained an increase in business with respect to orthopedic department UNICEF- COUNTRY DATA ANALYSIS AND STORYTELLING (R, TABLEAU)

• Generated data visualization using Tableau on child mortality rates and which country has the highest mortality rate with accordance to sustainable development goals (SDG) and automate pivot tables in MS Excel

• Conceptualized key features within the data using techniques like ARIMA model in R

• Design key risk indicators and maintain risk management reports by using Risk treatment response plan (RTRP)

• Designed and addressed detail mortality report on under five years of age using Google Analytics