Data Analyst Sales

Saran Padmakar

***************@*****.*** www.linkedin.com/in/saran-padmakar/ 469-***-****

Data Analyst providing data-driven, action-oriented solutions to challenging business problems

WORK EXPERIENCE

Holiday Inn Club Vacations, Orlando, USA September 2019 – April 2020

Data Scientist Intern

Extensively worked on SQL for data manipulation and programmed complex SQL queries utilizing multiple joins, nested queries to extract, manipulate and analyze Timeshare data based on project requirements

Designed and automated an interactive dashboard with KPIs, graphs and scheduled data refresh using Power BI to study trends and delivered timely information on key resort performance metrics providing actionable insights leading to 12% increase in revenue

Developed a regression model with 72% accuracy to identify key factors influencing guest experience and leveraged statistical techniques for ad-hoc analysis which subsequently boosted Timeshare sales by $270K in 6 months

Investigated guest checkout responses from Medallia, identified customer emotions and resolved key pain points by performing text analytics using NLTK libraries and maximized overall stay experience by 17%

Performed data preprocessing including anomaly detection, missing value imputation using Python and built an Employee Management tool to help the HR team efficiently track Employees, Budgets and optimized the overall recruitment process

Freshworks, Chennai, India August 2016 - July 2018

Data Analyst

Performed A/B testing experiments on Freshworks’ pricing page to track its effectiveness and the suggested variant increased the product conversion rate by 18%

Extracted Freshdesk’s ad campaign data, created multivariate regression models using Python and created Tableau dashboards to study the key business metrics

Designed database structure using data warehouse methodologies for Freshmarketer’s email campaigning app

Presented customers with clear business insights on their webpage traffic by analyzing data and reporting based on quantitative and qualitative research

Education

The University of Texas at Dallas May 2020

M.S., Information Technology and Management

Anna University, Chennai, India May 2016

B.E., Electronics and Communication Engineering

ACADEMIC PROJECTS https://github.com/saran-p Wine Quality Prediction:

Built models to predict the quality of wine using Logistic, KNN and RandomForestClassifier with a recall of 89%

Performed Hyperparameter tuning and achieved an accuracy of 87% and visualized the results with Seaborn to identify trends and the factors affecting the quality of wine

Rossman Store Sales Analysis

Performed exploratory data analysis to visualize trends and gain insights on 3000 drug stores operating in USA

Analyzed the effect of significant variables, compared and derived prediction models (Linear, Ridge and Lasso, PCA) to predict sales with an 84% accuracy

Technology Summary

Programming: Python (Pandas, NumPy, TensorFlow), R (ggplot, dplyr), SQL, NoSQL (MongoDB), Java, HTML, Elasticsearch

Tools: Tableau, PowerBI, R Studio, Alteryx, SSRS, SSAS, SAS, SQL Server, QlikView, Advanced Excel (Pivot Table, Vlookup, Index, Match), Google Analytics, GIT, Amazon Redshift, S3

Expertise: Statistics, Data Analytics, Business Intelligence (BI), Data Visualization, Ad Hoc Reporting, KPIs dashboard, Web Analytics, Machine Learning, Data Warehousing (ETL), Data Management, Relational and Non-Relational Databases, Data Modelling, Data Mining, Agile Project Management

Contact this candidate