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.
• 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
• 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
• 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
• 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