Siddhi Patel Email & Phone Number

Los Angeles, California, United States

• Crafted 30+ SQL queries and supported the development of a Google Looker Studio dashboard to efficiently analyze 6TB worth of user segment data in order to provide recommendations to the Chief Finance Officer for reallocating over 250 million dollars worth of content spend.• Built a Python logistic regression model that quantifies user retention benefits of adding/removing content in order to optimize future slates of titles offered on P+. • Communicated technical results of over 20… Show more • Crafted 30+ SQL queries and supported the development of a Google Looker Studio dashboard to efficiently analyze 6TB worth of user segment data in order to provide recommendations to the Chief Finance Officer for reallocating over 250 million dollars worth of content spend.• Built a Python logistic regression model that quantifies user retention benefits of adding/removing content in order to optimize future slates of titles offered on P+. • Communicated technical results of over 20 ad-hoc requests regarding quarterly financial earnings, content performance, and audience insights to executive stakeholders including FP&A and the VP of Data & Insights. • Independently wrote an algorithm that utilized 6+ metadata sources to efficiently tag genres for over 2000+ pieces of drama content using Python dictionaries and pandas. Show less

• Revised and released Python homework as well as graded midterms/finals for the Data Science 10: Principles of Data Science course for over 200 students under Professor Janine Tiefenbruck• Provided weekly one-on-one tutoring in the UCSD Computer Science lab to assist students with beginner Python coding in topics such as data exploration, statistical inference, and simulations

Ucsd

• Provided weekly one-on-one tutoring sessions to assist over 100 students with theoretical data science topics such as empirical risk minimization, optimization, regression, classification, and discrete probability• Graded midterms, finals, and homeworks for the Data Science 40A: Theoretical Foundations of Data Science I course under Professor Yian Ma and Professor Janine Tiefenbruck

Remote

• Engineered a SQL script that efficiently transformed 7TB worth of data into 60 columns that defined streaming and subscription metrics of 13M+ users• Utilized GCP's Vertex AI Notebooks to implement a Python K-Means classification algorithm that segmented ~8M subscribers into 5 segments of quality ranging from high quality to low quality subs• Created a Tableau dashboard that visualized multi-dimensional clusters as well as tables with metrics such as hours streamed, average tenure… Show more • Engineered a SQL script that efficiently transformed 7TB worth of data into 60 columns that defined streaming and subscription metrics of 13M+ users• Utilized GCP's Vertex AI Notebooks to implement a Python K-Means classification algorithm that segmented ~8M subscribers into 5 segments of quality ranging from high quality to low quality subs• Created a Tableau dashboard that visualized multi-dimensional clusters as well as tables with metrics such as hours streamed, average tenure, and number of titles watched for each cluster Show less

San Diego, California, United States

• Proposed a community approach to providing affordable and reliable WiFi compared to municipal wireless network competitors in the form of Community Wireless Networks (CWN)• Completed research at UCSD's Downtown Center by setting up the hardware for an anchor node and testing signal strengths at different locations under Professor Ramesh Rao• Drafted a Figma design for a mobile application that taught community members about different components of a CWN

San Diego, California, United States

• Developed a Python script that cleans and automates the retrieval of national, state, county, and metro-level data from Harvard’s Economic Tracker in order to evaluate California’s consumer spending trends.• Visualized San Diego’s zip code level foot traffic behavior over time using Python and folium in order to assess the impacts of COVID-19 on businesses.• Implemented dynamic reports of annual ACS data with SSIS in Microsoft Visual Studio to be released onto SANDAG’s DataSurfer… Show more • Developed a Python script that cleans and automates the retrieval of national, state, county, and metro-level data from Harvard’s Economic Tracker in order to evaluate California’s consumer spending trends.• Visualized San Diego’s zip code level foot traffic behavior over time using Python and folium in order to assess the impacts of COVID-19 on businesses.• Implemented dynamic reports of annual ACS data with SSIS in Microsoft Visual Studio to be released onto SANDAG’s DataSurfer website Show less

Ms Data Science Engineering, Overall Gpa: 4.0/4.0

Relevant courses: Large Scale Data Mining Models and Algorithms, Probability & Stats, Matrix Analysis

Bs: Data Science, Minor: Business, Overall Gpa: 3.81/4.0