DEVANSHI PATEL
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Analyst I
Havas Edge
Carlsbad, CA
09.2024 - Current
- Developed and optimized data feeds, integrating marketing data from GCM, Microsoft, Meta, and LinkedIn Ads, to attribute responses by funnel stage, tailored to the client's marketing goals.
- Built client-specific dashboards using Supermetrics API, AWS, Looker Studio, and Tableau, enabling insightful data visualization and decision-making.
- Conducted minute-by-minute marketing analysis to optimize linear TV campaigns.
Business Analyst Intern
Havas Edge
06.2024 - 08.2024
- Developed an attribution model using R, leveraging dplyr & ggplot for data manipulation, visualization and insights
- Enhanced a major client's Tableau dashboard, reducing load times by 30-45% and improving data visualization
- Optimized SQL queries and streamlined data processing workflows in Looker Studio, resulting in more efficient reporting
- Led a presentation on the impact of cookie deprecation, effectively communicating the implications of privacy changes on data strategies and fostering a collaborative discussion on adapting to these shifts
Supply Chain Analyst (Capstone)
Thermo Fisher Scientific
04.2024 - 06.2024
- Optimized inventory with SQL and Python, identifying dekit opportunities and predicting usage patterns through machine learning
- Streamlined operations using ERP and SCM systems, designing Tableau dashboards for improved decision-making and supply chain efficiency
- Project: Dekitting and Salvaging Parts for E&O Reduction
Software Developer
Yardi Systems
Oxnard, CA
02.2021 - 08.2021
- Optimized VendorCafe's (part of the property management software) data reporting and compliance, resolving 10 critical bugs and enhancing the custom dashboard for improved client interaction
- Utilized a tech stack (Oracle, Visual Studio Code, WinSCP, SQL, Java, XML) to integrate platforms, refine data, and enhance application functionality
Education
Master of Science - Business Analytics
University of California, San Diego
12.2024
Bachelor of Science - Computer Science
California State University, Northridge
12.2022
Skills
- Data Analysis and Visualization
- Machine Learning
- Statistical Analysis and Modeling
- Cloud Analytics
- Data Mining
- Experimental Design (A/B Testing & RCT)
- SQL Query Optimization
- Marketing Analysis
Certification
Google Analytics 4, 07/01/24
Projects
Intuit QuickBooks Upgrade Analysis
- Led a predictive modeling project to forecast QuickBooks 3.0 upsell outcomes for 75,000 businesses.
- Optimized marketing strategies by analyzing response rates, profitability, and ROI, resulting in a 10% increase in upsell performance.
Book Recommendation System
- Developed a personalized recommendation system using advanced techniques (cosine similarity, SVD, collaborative filtering) to enhance user experience. Improved recommendation accuracy through feature engineering.
Timeline
Business Analyst I
Havas Edge
09.2024 - Current
Business Analyst Intern
Havas Edge
06.2024 - 08.2024
Supply Chain Analyst (Capstone)
Thermo Fisher Scientific
04.2024 - 06.2024
Software Developer
Yardi Systems
02.2021 - 08.2021
Master of Science - Business Analytics
University of California, San Diego
Bachelor of Science - Computer Science
California State University, Northridge
Similar Profiles
EMILY KAZMAREKEMILY KAZMAREK
ACCOUNT MANAGER at HAVAS EDGEACCOUNT MANAGER at HAVAS EDGE
Maggie KahnMaggie Kahn
Media Operations Specialist at Havas EdgeMedia Operations Specialist at Havas Edge
Assata Johnson-WilliamsAssata Johnson-Williams
Associate Project Manager at Havas Health & YouAssociate Project Manager at Havas Health & You
Shonkeya ShawShonkeya Shaw
Business Analyst I at Georgia Department of Community HealthBusiness Analyst I at Georgia Department of Community Health
Kendra AllenKendra Allen
Business Analyst I at WalmartBusiness Analyst I at Walmart