Prachi Paliwal

Hartford, CT • 860-***-**** • adba8c@r.postjobfree.com • LinkedIn

Analytics professional with experience in descriptive and prescriptive analytics, SQL, R, Python, Tableau, Statistics, Databases. Teamwork and Project Management, Strong analytical skills, ability to identify problems, research issues and provide solutions. EDUCATION:

• University of Connecticut, School of Business, Hartford, CT Aug 2019 - Dec 2020 Master of Science - Business Analytics and Project Management Coursework: Statistics, Predictive Modeling, Databases (SQL), Data Science Using Python, Data Mining Using SAS

• Rajiv Gandhi Technical University, Bhopal, India Aug 2015 - May 2019 Bachelor of Engineering - Electronics and Communication TECHNICAL SKILLS:

• Languages and Tools: Python, R, SAS JMP, C, C++, Hive, Pig, Excel, Access, PowerPoint, Visio, Project, Outlook, MATLAB, Salesforce, JavaScript, Google Analytics, Tableau, Jupyter Notebook, Spyder, SPSS, SharePoint

• Databases: Oracle 11g, SQL, MySQL, SQL Server, Hadoop, PostgreSQL, NoSQL, MongoDB

• Analytical Skills: Data Cleaning, Data Mining, Data Visualization, ANOVA, Hypothesis Testing, Exploratory Data Analysis, Logistic and Linear Regression, Tableau, Decision Trees, Random Forests, Neural Networks, Clustering, Dimension Reduction, A/B testing, Gradient Descent, Project Management, Risk & Cost Management, FMEA, Pivot Tables, vlookup, hlookup, Marketing Analytics, Swim lane, Time Series, ARIMA, Gantt Chart, Text Mining EXPERIENCE:

UCONN Graduate Consulting- Connecticut Education Network Analytics Consultant Hartford Oct 2019 - Present

• Formulated roadmap utilizing Website Analytics to boost website traffic and to identify most lucrative markets and highest value potential customers using demographics

• Implemented regression and random forest models to predict company’s expenditure for the upcoming fiscal year

• Created work breakdown structure and Gantt chart to help stakeholders estimate budget and duration of projects

• Organized, cleaned, merged data into single usable database using Python & MS Access, cut downed calculation time by 18%

• Prepared real-time dashboard on Tableau to analyze the business trends, reduced manual labor by 10 hours per month Alliant Infotech Data Analyst Intern India July 2018 - Jan 2019

• Segmented customers using clustering and other machine learning algorithms which lead to an increase in the profit by 15%

• Analyzed previous product performance to predict performance of upcoming products

• Collected, cleaned and merged data to identify loops in the existing strategies

• Created Tableau dashboards to summarize the most important KPI’s reducing manual labor by 8 hours per month ACADEMIC PROJECTS

NYC Taxi Trip Duration Prediction Python

• Built a regression model trained on a Kaggle dataset containing New York Taxi rides’ information that would predict the trip duration of an upcoming taxi ride using Python Credit Risk Analysis Loan Default Prediction R Tableau JMP SAS

• Developed model to predict loan default with maximum accuracy of 74%

• Explored patterns in predictors and dependent variable using filters, parameter in tableau and JMP SAS Hotel Management System Data Management and Business Process Modeling MS Visio Oracle SQL ERD

• Created entity relationship diagram and swim lane for As-Is, To-Be model and entity describing business model with proposed changes

• Revised database schema in Oracle SQL Developer to optimize process flow AWARDS AND ACTIVITIES:

• Received client recognition for presenting Business Strategy reports during internship

• Awarded for organizing blood donation camps, plantation drives and blind school visits while working for an NGO