BHAVYA SHAH

469-***-**** adbyg1@r.postjobfree.com linkedin.com/in/bhavya-m-shah

EDUCATION

The University of Texas at Dallas, MS in Management Science (Data Analytics), Excellence Scholarship May 2020 University of Mumbai, Master of Commerce July 2017 Institute of Chartered Accountants of India, (Level II Chartered Accountant course) January 2013 SKILLS

Programming/databases SQL, R, Python, Hadoop, Sqoop, Hive, Impala, PySpark, Analytical & BI Tools Tableau, Power BI, Qlik View, Minitab, SAS, Audit Command Line(ACL), Alteryx Functional Skills Data Analytics, Data Mining, Data Manipulation, Database, Machine Learning, Finance, Statistics and Quantitative Analysis, Project Management, Consulting, Presentation, Leadership, Communication, Problem Solving, Data modelling, Econometrics Model Building, Geospatial Analysis

Statistical & Quantitative

skills:

Regression, ANOVA Test, LDA, PCA, KNN, K-means Clustering, Classification, Decision Trees, Naive Bayes Classifier

Relevant Coursework: Business Analytics with R, Statistics and Data Analysis, Database Foundations for Analytics, Data Visualization, Big Data, Agile Project management, Spreadsheet modelling and Analytics

RELEVANT EXPERIENCE

Shah & Lodaya Consultancy, Mumbai, India March 2016 – June 2018 Co-Founder/ Data Analyst

• Performed rigorous & quantitative analytics on large, complex datasets and provide strategic insights, hypotheses, and conclusions based upon findings to the tune of $ 3.30 million using R, Python and SQL

• Developed BI solutions across 10 projects on wide array of technologies such as Tableau, Microsoft Power BI and QlikView for financial data analytics

• Increased revenue by 30% to $2.5 Million by analyzing weather patterns and effect on wheat prices and designing hedging strategies for packaged food production company using Python, Tableau and PowerBI.

• Partnered with 12 finance analysts to help automate manual workflows and train them in tools and skills to face challenges and become self sufficient

Bhadresh B. Sanghavi & Associates, Mumbai, India May 2013 – February 2016 Reporting analyst

• Supervised finance team partners to drive the development of the data warehouse, master data management system, and reporting and analytics platforms thereby increasing the ability to analyze

• Used Historical VaR, Monte Carlo VaR, Multi-Factor Risk Models, Stressed VaR, Liquidity Risk models and Black and Scholes models to increase stock returns by 26% to $4 Million RELEVANT PROJECTS

• Location Intelligence to assess the best possible location for Asian restaurant using ArcGI January 2020

• Integrated analytics of disaster using R & tableau by K-means clustering & decision trees December2019

• Multi-map visualization of 10 years natural disaster data & refinery location data of an energy company using tableau and advanced excel October 2019

• Web scrapping weather.com data using python and delivering insights September 2019

• Performed rigorous analyses on large complex data set for retail data management and provided strategic insights hypotheses and conclusions based upon findings using R August 2019

• Analysis of financial as well as non-numerical data to arrive at a prediction model for Loan repayment after considering numerous variables for loan prediction using R May 2019

• Predicting future bitcoin values by using time series analysis on SAS, relating BitCoin values to S&P Index, Oil Prices and Dollar-Euro exchange rate November 2018