Data Analyst Sales

MAYUR BHAT

*** ****** **, ******, ** ***** • +1-781-***-**** • ************@*****.*** • https://github.com/bhat-mayur EDUCATION

Master of Science in Engineering Management (Data Analytics) CGPA: 3.89/4 Northeastern University, Boston MA 12/2019 Bachelor of Engineering (Mechanical) First Class with Distinction VTU, Bangalore India 06/2013 TECHNICAL SKILLS

• Tools: Jupyter Notebook, R Studio, SSRS, Tableau Desktop, Power BI, Advanced Excel (Macros), SPSS, Microsoft Office (Advanced)

• Programming Languages: Python (pandas, NumPy, matplotlib, SciKit-learn), R, Advanced SQL, SAS, JavaScript, HTML, CSS

• Database Management: Azure SQL, AWS, MS SQL Server, Toad Data Modeler, MongoDB

• Functional Knowledge: UAT, Agile (Scrum), Waterfall, A/B Testing, Sales Funnel, Process improvement, P&L

• Data Science & Analytics: Descriptive & Inferential Statistics, PCA, Supervised and Unsupervised Learning PROFESSIONAL WORK EXPERIENCE

Consumer Data Analyst/ Product Management Co-op 05/2018 – 12/2018 General Electric Lighting

• Achieved 25% improvement in KPIs by developing and documenting multi-stage beta user acceptance test for 3 product lines

• Generated actionable insights by investigating, refining dashboards and automating data collection with web scraping scripts

• Improved app rating by 25% by conducting qualitative and root cause analysis to prioritize bug fixes and feature prioritization

• Performed quantitative analyses and reporting on company, competitor and industry data to define GE lighting’s positioning

• Analysed user behaviour and streamlined recommendations to voice integration services- Amazon Alexa and Google assistant Chief Operating Officer (Founder) 03/2015 – 04/2017 Geospot Technologies – A mobile only hyper local search/discovery platform. Exit: Lack of Series A funding

• Established KPIs and deployed user base growth strategies to scale platform to 12,000 weekly users and 500 stores in 5 months

• Identified expansion regions by engineering python scripts to iteratively retrieve geo-location data using google places API

• Recruited, trained and led a 15-member team with data collection, compliance, imaging and content standards for application feed

• Administered dashboards and scorecards in Tableau to track KPIs and marketing metrics generated from various data pipelines

• Reduced user acquisition cost by 30% ($2.23 to $1.59) through A/B testing of content for Facebook and Google AdWords advertising Business Data Analyst 08/2013 – 02/2015

Amazon India

• Achieved 250% improvement in processes by leading change management initiatives through excel macro data automations

• Conducted quantitative analyses on sellers’ sales data and recommended ideal product promotion strategy to vendor managers

• Developed and maintained reporting frameworks for seller and category sales performance on a weekly and bi-weekly cadence

• Boosted productivity by reducing catalog product creation time by 85% through process automation and standardization

• Lifted data integrity and completeness by 400% through catalog quality audit on 300,000 ASINs for 12 categories of products PROJECTS AND ACCOMPLISHMENTS

Healthcare spend analysis – SSIS, SSRS, SSAS, Python and Tableau

• Deployed a star schema data warehouse (6 facts and 9 dimensions) in Azure SQL by compiling data from various sources

• Audited and corrected missing data, performed transformations including lookups for ~25,000 rows of data

• Improved data flow efficiency by 30% by implementing error handling, sequence and task containers, and SCDs.

• Built multidimensional OLAP cubes and provided BI overview by visualizing data through dashboards and stories in Tableau Big Mart Sales Analysis – R and Python

• Data cleaning: Audited and corrected missing data, encoded categorical data and performed feature scaling for ~18000 SKUs

• Assessed performance for 3 prediction ensembles consisting of 7 base models and attained 90% accuracy of sales prediction

• Some models included: Linear regression, random forest regression, generalized linear model, boosted regression Hackathons and Business Case Competitions

• Won 1st place at Deloitte design studio for presentation of social web application to increase college football viewership in the US

• Won 4th place at MIT Fintech Hackathon for building CNN based solution for insurance agent prioritization Available beginning Feb 2020 with valid work authorization for up to 3 years

Contact this candidate