Shiv Kapoor

-- Developed python and SQL algorithms to streamline database pulls and data analysis, reducing analysis time by 30 minutes -- Used python to optimize an API scraper and reduced run time by over 50% -- Developed excel model to analyze financial statements and create a credit score database for PIMCO and other investment firms

--Attended consulting training with Bain & Co employees to learn about data analytics and project presentations in a fast paced environment --Took initiative to optimize time management and adapt excel spreadsheets/data models to different scenarios --Conducted interviews with competitor clubs to reevaluate and improve the internal client acquisition process --Analyzed over 1400 survey respondents to suggest optimal allocation of funding for the rollout of the ASUW Shell House marketing and integration

--Conducted quantitative and qualitative data analysis of over 1500 data points of miles-to-dollar ratios in order to benchmark points conversion rates for 10 major airlines --Filtered databases and built statistical charts in R to model competitor loyalty programs --Developed a 25 slide presentation for managing director to recommend new strategies for Loyalty Program and optimization consumer brand loyalty

--Assisted the software engineering team to create a model to evaluate the efficacy of different app features on client conversion rate --Conducted statistical analysis of 5% of the user base (600,000) as test subjects to highlight the increased purchase rate through a potential relocation of icons --Co-presented a data-oriented predictive analysis of flight prices to assist the optimization of value deals offered at a discount to the managing director achieving a 2% increase in 2-week sales

Taught weekly swimming classes to children in grades 1-6; up to 10 participants at a time Taught 5 different groups of children in all skill levels through the Red Cross training levels Red Cross certified for first aid and swim instruction