Data Analyst Sales

SANDEEP RANI PRADEEP KUMAR

***********@*****.*** 469-***-**** Dallas, TX 75252 www.linkedin.com/in/sandeeprani/ https://github.com/rsandy94

Recent graduate with Master’s in Business Analytics and over 2+ years of experience in Data Analytics and Business Intelligence delivering data driven business solutions to drive ROI and value. Data enthusiast with keen business acumen and analytical skills. Proven track record of technical and project management expertise.

Technical Competencies: Inferential statistics, predictive modelling, hypothesis testing, data warehousing, data visualization

Tools and Technologies: SQL, NoSQL, Python, R, SAS, Tableau, Power BI, QlikView, PL/SQL, AWS, Microsoft Azure, Advanced MS Excel(Pivot tables, Vlookups), Google Analytics, Adobe Analytics

Data Science Libraries: NumPy, Pandas, Scikit-learn, Matplotlib, TensorFlow

EDUCATION

•The University of Texas at Dallas Richardson, TX, USA

MS in Business Analytics with honors; Specialization: Data Science Aug 2018 - May 2020

GPA: 3.67

Relevant Coursework: Statistics, Machine Learning, Database Foundations, Predictive Analytics, Business Analytics with R, Econometrics, Data warehousing, Big Data, Marketing Web Analytics

•College of Engineering, Guindy Chennai, TN, India

Bachelor of Technology in Electronics and Communication Aug 2012 - May2016

PROFESSIONAL WORK EXPERIENCE

COPART Inc. Dallas, TX, USA

Product Analyst Intern Feb 2020 - May 2020

Being a product owner for operations in Germany, Spain and Brazil, communicated with the stakeholders and end business users to solve business problems and drive value, thereby increasing ROI by 10-15%

Built and analysed Tableau reports and dashboards to monitor KPIs and other metrics, derived meaningful insights and suggested recommendations to keep improving the business value

Worked with databases and executed complex SQL queries to build business reports with useful data interpretations and insights that capture user’s interaction with the products

BIOWORLD MERCHANDISING Inc., Dallas, TX, USA

Business Analyst Intern Jun 2019 - Aug 2020

Built a PowerBI dashboard for use by the C-level executives and the Marketing team to track their KPIs, campaigns, budget expenses, sales performance and popularity of the products of an e-commerce website

Analyzed the performance of different areas and categories in apparels, headwear, accessories and recommended marketing strategies to improve reach and increase revenue by 20%

Saturam Inc., Bangalore, KA, India

Data Analyst Jun 2017 - May 2018

Created web crawlers using Python to scrape product and pricing data from competitor’s websites and thereby generate price benchmarking reports for the client to expand market share by 5 - 10%

Developed a price recommendation engine for the client (Big Basket) that automatically updates revised product prices thus increasing the client company’s revenue by 50- 60%

PROJECTS

Pricing and Marketing Analytics for Mayonnaise brands SAS Sep 2019 - Nov 2019

Using RFM analysis, identified customer purchase patterns to create segments and analyse customer behaviour across segments to boost sales of Hellman’s by at least 10%

Determined the influence of price and promotions on the sales of Hellman’s brand and made suggestions to outperform competitors and improve market share by 5-10%

Researched the impact of display, feature and price reduction on customer’s preference of Hellman’s over Kraft Miracle Whip and Best Foods and proposed strategies to attract more customers

Gaming industry analysis and Forecasting R Aug 2019 - Nov 2019

Obtained insights on the console war between PlayStation, Xbox and Nintendo and how factors like critics and user ratings, genres, developers affected the sales

Created insightful Tableau dashboards that highlight KPIs and other important metrics that explain user’s interaction with the data

Adobe Analytics Challenge- MLB data Adobe Analytics Sept 2019 - Oct 2019

Extracted meaningful insights from real-world MLB data using Adobe Analytics and provided recommendations to create an in-stadium experience online, improve customer engagement and increase revenue by 20%

Provided website optimization techniques for better advertisement revenue generation

Contact this candidate