Sign in

Data Analyst

Chicago, Illinois, United States
November 04, 2018

Contact this candidate


Pavan Dinkar Palve

Chicago, IL 312-***-**** GitHub Portfolio SUMMARY

Business-minded aspiring data scientist with strong mathematics background and 4 years of experience in delivering value adding insights via data driven methods and statistical modeling. Proficient at devising data driven solutions using machine learning algorithms in R and Python. SKILLS

o Machine Learning Algorithms: Regression (Linear & Logistics), Naive Bayes Classifiers, Decision Trees & Random Forests, Support Vector Machines (SVMs), Neural Networks, Clustering

(Hierarchical & K-Means), Association Rules

o Python: NumPy, SciPy, Pandas, Matplotlib, nltk, Scikit-Learn, Seaborn & Statsmodels o R: dplyr, ggplot2, mlr, rpart, ROCR, nnet, e1071, mice, randomforest, DAAG o Database: MySQL, Postgres

o Tools: Jupyter, Spyder, Tableau, Microsoft PowerBI, GitHub, Google Analytics, MS-Excel Advanced o Java: J2EE, JSP, MVC


The University of Illinois at Chicago – MS in Management of Information Systems Aug 17 – Dec 18 University of Pune, India – Bachelor of Technology in Computer Engineering Jul 09 – May 12 WORK EXPERIENCE

Metropolitan Water Reclamation District of Greater Chicago Aug 18 – Present Data Analyst Intern – Team Lead

Goal: 20% improvement in the turnaround time of IT service requests. o Saved cost of an Extract-Transfer-Load tool by writing a script using Python to perform ETL. o Performed exploratory data analysis using principal component analysis in Python. o Analyzed issues causing delays and conflicts in service requests, using cluster analysis in Python. o Built predictive data model using logistic regression to predict SLA breach. o Modeling decision trees to classify incidents to assign priority levels. o Identified key metrics and KPIs to monitor IT Service Desk process. o Visualize KPIs using PowerBI.

Zuri Products, Brazil Dec 17 – May 18

Marketing & Data Analytics Intern – Team Lead

Goal: Assess the impact of marketing actions on sales, traffic and brand choices. o Performed exploratory data analysis using principal component analysis in Python. o Analyzed target cities and customer profiles using linear and logistic data models in Python. o Developed decisions trees to classify customers using income and physical attributes. o Analyzed customer interests from textual feedbacks to analyze behavior and brand choices using natural language processing in Python (nltk).

o Applied random forest classifiers to segment market using existing marketing channels. o Defined omnichannel marketing strategy to promote products in the Brazilian market. o Created tableau story for investors.

South Florida PBS, Florida Aug 17 – Dec 17

Process Management Intern – Team Lead

Goal: Improve process efficiency by at least 30%.

o Performed AS-IS analysis of Procure to Pay business processes. o Improved the turnaround time for purchase orders by 40% by automating the process. o Created a central knowledge repository using ARIS cloud. o Configured the centralized document management portal, using Square 9 systems. KPMG India, Bangalore Dec 16 – Jul 17

Consultant – Business Excellence

Goal: Support client in digital transformation and improve decision making by leveraging statistical data modeling. o Danieli Corporation – Process Manager

• 35% reduction in turnaround time of vendor selection process.

• Enabled data analytics by capturing primary performance metrics. o The Executive Council, Dubai – Team Lead

• Enabled centralized process governance by defining process architecture and repository.

• Facilitated data collection and analysis to generate reports and dashboards. TechMahindra Ltd., Pune Mar 14 – Dec 16

Business Process Analyst

Client: Reliance Industries Limited (Fortune 500 organization) Goal: Create a central process repository for facilitating governance and management reporting. o Defined central process repository using ARIS BPM suite to govern business processes. o Enabled management reporting by capturing key performance indicators. o Enabled data analytics and reporting using ARIS mashzone and excel. o Deployed standard reports and dashboards on the web platform. o Led research & development initiative to optimize data reports. K. K. Wagh College of Engineering, Nashik May 12 – Jul 13 Lecturer

o Instructed Data Structures using C & Theory of Algorithms in Computer Engineering department. o Supervised capstone project work of a group of 3 graduating students. ACADEMIC & PERSONAL PROJECTS

Jain University – Admission Dilemma (Python)

Implemented random forest classifier to classify students for admission using R. Employee Satisfaction in Federal Agencies (R)

o Developed employee satisfaction index using the factor analysis of employee feedback data in R. o Created linear & logistics regression data models in R. Profitability of Auto-Insurance Firm (R)

o Implemented kmeans and hierarchical clustering to identify subgroups within dataset in R. o Analyzed relationship between profit and demographic, income and vehicle attributes using linear and logistic regression in R.

Predict Rating from Review on Yelp (Python – nltk, sklearn - naive Bayes) o Extracted meaningful information from reviews using natural language processing in Python. o Written functions to perform text preprocessing to remove punctuations & stop-words. o Built corpus and bag words to compute term and inverse term frequencies. o Modeled Multinomial Naïve-Bayes classifier to predict the rating. Microsoft Stock Price Analysis (MS Excel – Analysis toolkit) Predicted the stock price based on the S&P 500 index using linear regression analysis. Database Management Toolset (J2EE, JSP, JSF2.0 & MVC) o Developed a web interface to manage various RDBMS activities. o Web interface provided a secure login, CRUD, Descriptive Analysis, Regression reports, and plots. Data Visualization for SouthWest Airlines (Tableau) Analyzed operational efficiency of SouthWest by visualizing delays, on-time performance and flight network.

Contact this candidate