Data Analyst Sales

Dhairya Shah

469-***-**** ***********@*****.*** https://www.linkedin.com/in/dhairya11/

EDUCATION

The University of Texas at Dallas, MS, Business Analytics, GPA 3.5/4 Aug-2018-May 2020 Coursework:

• Data Visualization • Business Analytics with R • Statistics & Data Analysis

• Spreadsheet modelling and Analytics • Programming for Data Science • Operations Management Nirma University, BTech, Electronics and Communication, GPA 3.7/4 Aug 2014-May 2018 CERTIFICATION & TECHNICAL SKILLS

Certification: Tableau Desktop Specialist, Lean Six Sigma, Data Analysis-Demand Planning Languages: R, Python, SQL, SAS, HTML

Tools: Tableau, QlikView, Alteryx ETL, SAP HANA, QuickBooks MS Office Software: Power BI, Advanced Excel(VLOOKUP, Pivot Table, Macros), Access Database: MSSQL, MySQL, Redshift, Oracle, SQL Server, BigQuery PROFESSIONAL EXPERIENCE

Data Analyst (Supply Chain), SanJose Systems July 2020-Oct 2020

• Automated end to end Procure-to-Pay process by managing a database for 102,000 SKU of 30 brands and integrating ERP system for EDI to streamline the order processing which resulted in 60% reduction in time

• Designed dynamic and interactive pricing dashboard based on cost drivers to track and predict future pricing

• Created an optimum inventory build plan to reduce safety stock by 15% by building a predictive time series model using the historical buying trends for the demand planning team

• Reduced category logistics cost by 15%, freed up inventory space by 10% by implementing drop shipping for 5 product categories: cargo pants, work pants, socks, ties, belts Data Science Consultant (Capstone Project), Intuilize Jan 2020-May 2020

• Devised SQL queries, multi-table joins for data extraction and performed EDA (exploratory data analysis) for better visibility on sales, customer, and product data

• Segmented the customers using RFM and products by gross margin in tableau and provided suggestions to retain customers in the last(drain) segment and increased the customer retention rate by 8%

• Uncovered 35% financial losses by reporting on product’s profit margin through the creation of summarized analysis and clear, compelling infographics in tableau Data Analyst (Co-op), Sattrix Infotech July 2017-May 2018

• Performed statistical analysis (linear regression/hypothesis test) and suggested strategies on product survey data to understand user acquisition, frequency which resulted in 7% decrease in the churn rate

• Minimized the cost of products by preparing daily live reports on vendor analysis(ABC analysis), price elasticity, product demand using Power BI for the demand planning and sales team

• Accelerated inventory efficiency by 10% by developing a predictive time series model(ARIMA) to forecast product demand using historical sales data in SAS

Marketing Analyst Intern, Converza Jan 2017-May 2017

• Integrated data from APIs, XML, SQL to define metrics for campaign performance across various digital channels

• Conducted A/B and multivariate testing in order to improve overall website experience for users which helped in keeping users on site longer and eventually increased the conversion rate by 3% ACADEMIC PROJECTS

Product demand Prediction (Python Tableau): Built a predictive model using Matplotlib, Seaborn, Pandas, Scikit- learn to predict car sales by channels; Implemented Lasso regression feature selection technique to select attributes Telecom Customer Churn Prediction (RStudio): Performed data transformation and exploration; Built predictive model using stepwise regression to estimate customer churn with an accuracy of 87.9%; validated using k-fold cross validation Sales and Distribution (SAP HANA): Developed an integrated order-to-cash cycle along with financial accounting process implementing integrated sales and distribution process in details underlying SAP functionality

Contact this candidate