Business Intelligence, Business Ananlytics, SQL, R, Python

Rashi Saxena

www.linkedin.com/in/Saxena** • *****.******@*****.*** • 959-***-**** • Hartford, CT

Business Intelligence ● Agile Methodology ● Data Storytelling ● Advanced Microsoft Excel ● SQL Solutions driven professional with three years of experience in fast-paced Agile team environment. Adept in prescriptive and descriptive analytics honing strong communication skills as well as Management acumen to be able to communicate data in rhythm with business EDUCATION

M.S. in Business Analytics and Project Management, School of Business, University of Connecticut, GPA: 3.5/4 Aug 2019 – Dec 2020 Relevant Coursework: Business Intelligence, Visual Analytics, Predictive Modeling, Business Decision Modeling, Data Science using Python B.S. in Electronics and Communication, School of Engineering, IPS Academy, GPA: 8.19/10 Aug 2012 – Jun 2016 SKILLS

Programming Languages, Tools & Databases: SQL, Oracle 11g, R(ggplot2, dplyr, Lubridate, tidyverse), Python (NumPy, Pandas, Scikit- Learn), Tableau, Advanced MS Excel (V/H-Lookup, pivot tables, VBA, macros), Microsoft Office Suite, MS Visio, MS Project, Microsoft Access, SharePoint, SAS JMP, SAS 9.4, SAS Enterprise Miner, Google Analytics Statistical Analysis: Data Cleaning, Data Mining, Dimension Reduction, ETL, PCA, Hypothesis Testing, Linear Regression, Logistic Regression, Clustering, K-NN, Random Forests, Gradient Boosting, Neural Networks, Segmentation, Customer Analytics, A/B testing, Search Engine Optimization, Search Engine Marketing, Text Analysis, Time Series Forecasting, MapReduce, Market Basket Analysis, Go-To Market Plan PROFESSIONAL EXPERIENCE

University of Connecticut, Web Analyst, Connecticut Oct 2019 – Present

• Manage website architecture for the Center of Real Estate and Urban Economics using WordPress and Constant Contact

• Generated insights for staffing requirements and budgets for future events in the department using operational Tableau reports

• Increased student engagement on website by 20% by building predictive models on current and historical student demographic data enabling targeted marketing initiatives for various activities and seminar hosted by student affairs Tata Consultancy Services, Business Intelligence Analyst, Delhi Oct 2016 – Jun 2019

• Performed requirement analysis, data profiling using Entity – Relationship Diagram and logical data modeling. Performed extract, transform load procedures on 100+ tables to process and monitor patient claim data and send claim data to CMS in flat files

• Generated interactive reports using BI tools (Power BI) to identify the pharmaceutical trends and optimized business solutions, thus increasing the customer satisfaction rate by 20%

• Reduced the percentage of tickets that breached the SLA by 5%, analyzed the mean time to resolve (MTR) the issue using advanced excel reports resulting in reduction of time to resolve severity one issues Verdantis Technologies Pvt. Ltd., Business Intelligence Intern, Mumbai Jan 2016 – Mar 2016

• Assisted to enhance KPI reporting by transitioning Excel reports on Tableau, allowing senior management to make strategic decisions

• Identified traffic trends and site tagging opportunities by establishing product specific Tableau Dashboards highlighting insights on sales performance and conversions, improving site conversion rates ACADEMIC PROJECTS

Cookie Cats: Mobile Games A/B Testing R, A/B Testing, Hypothesis Testing University of Connecticut Feb 2020

• Analyzed the results of A/B testing and Hypothesis testing on the impact of changing a gate in a puzzle game from level 30 to 40

• The results concluded that user retention for 7-day period for treatment group (level 40) was better than control group (level 30) Mashable.com: Predicting number of online shares Predictive Analysis, SAS JMP 13 University of Connecticut Nov 2019

• Assembled regression models with relevant predictors such as day of release, self-reference, number of unique tokens, number of images, sentiment polarity and title subjectivity to predict number of online shares on articles published on mashable.com

• Implemented stratified sampling, binning and EDA; Neural network was found to be the best model with R-squared value of 0.88 Walmart: Forecasting highest weekly sales Data Mining, SAS 9.4 University of Connecticut Feb 2020

• Created a time series forecasting model for Walmart Department having highest weekly sales. Several ARMA and ARIMA models were executed and the best model was chose based on the white noise, unit root and seasonality test results. Google: Store Customer Revenue Prediction Customer Analytics, Google Analytics University of Connecticut Feb 2020

• Implemented stratified sampling, binning and EDA and build regression models to predict revenues and identify features impacting sales on the Google Merchandise Store; boosted tree was found to be the best model to predict revenue with accuracy of 65% ACHIEVEMENTS AND CERTIFICATIONS

• Vice President: Academics and Case Competitions at Net Impact – UCONN Graduate Chapter Sep 2019

• Received On the spot award for excellence for process improvement ideas – Tata Consultancy Services Mar 2018

Contact this candidate