Data Analyst Marketing

PETER SAIGA TALLO

415-***-**** *******@*****.*** https://www.linkedin.com/in/petertallo/

MARKETING DATA ANALYST DATA SCIENTIST FINANCE OPERATIONS SUMMARY

Proven Communicates actionable insights from complex datasets using statistical modeling, data visualization, and data analysis tools

Insightful Utilizes a variety of tools to lead data-driven strategy through data exploration, storytelling, and descriptive, predictive and prescriptive analytics Producer Performs data preparation, blending, and analytics to identify data trends, track project progress, and raise customer satisfaction

SKILLS

Tools: Python (Numpy, Pandas, Matplotlib, Scikit-learn, TensorFlow) SQL R Tableau Excel MS Access SmartSheet Power BI Qualtrics Alteryx SAP Data Analysis: Database Management Market Research and Strategy KPI Performance Optimization Predictive Analytics Salesforce Marketing Facebook & Google Ads Project Management: MS Project Stakeholder and Vendor Relations Agile Jira EXPERIENCE

Marketing Data Analyst

Exelixis (Biotech) Alameda Sep 2024 – Jan 2025 SKILLS: Excel (Pivot Tables), SQL, Tableau, Alteryx, SAP, Ariba

• Enhanced decision-making for stakeholders by tracking KPIs, pricing and cost-effectiveness, budget impact, and sales performance in interactive dashboards

• Discovered valuable insights in cost-effectiveness, competitor research, and compliance with regulatory requirements that support the value proposition of product to payers and healthcare providers

• Streamlined ETL workflow enabling automated, more accurate insights for strategic planning in marketing, finance, and sales operations

• Supported successful negotiation strategies by analyzing B2B partnership contracts to identify high- performing collaborations through actionable insights Marketing Data Analyst

San Mateo County Transit District (Transit) San Mateo Nov 2023 – Sep 2024 SKILLS: SmartSheet, MS Access, SQL, Tableau, Marketo, Qualtrics, SAP

• Presented marketing campaign progress, financial operations strategy, and scorecard metrics while facilitating clear communication and strategic decision making with marketing, communications, and finance teams

• Improved customer segmentation within the customer base (travel frequency, preferred routes, demographics) and targeted marketing campaigns

• Automated email workflows to send personalized travel updates, reminders, and promotions based on customer behavior and preferences

• Conducted statistical analysis, A/B tests, customer sentiment analysis, and data visualizations to report survey findings surrounding transportation services, service and infrastructure improvements, and customer satisfaction

Peter Tallo

2

Marketing Data Analyst

Google (YouTube) Mountain View Feb 2023 – Nov 2023 SKILLS: SQL, Google Sheets, Tableau, KPI, Dashboard, ETL, Python, Project Management

• Presented statistical findings (i.e. Reach Curve), qualitative evaluation (customer satisfaction), and feature adoption tracking to advertisement vendors

• Performed weekly validation checks between ad partner API and internal dashboard

• Updated systems and performed weekly check for bugs in API tools by debugging SQL workflows

• Clearly communicated product roadmap, priorities, and key performance indicators (KPIs) at regular stakeholder meetings

Marketing Data Analyst

SimPRO Software (SAAS) San Francisco Oct 2022 – Feb 2023 SKILLS: SQL, SmartSheet, Salesforce, SFMC, MS Excel, KPI, Dashboard, Sage Intact

• Monitored key campaign metrics (e.g., open rates, click-through rates, conversions) as well as paid digital and non-digital metrics (ROI, ROMI, and ROAS) to evaluate effectiveness and suggest improvement

• Conducted thorough SAAS market research through predictive statistics and customer analysis to monitor and forecast trends

• Increased marketing campaign performance by reporting down-funnel and top-of-funnel engagement metrics

• Managed paid campaigns and channels including Facebook and Google ads Marketing Data Analyst

The Doctors Company (Medical Malpractice Insurance) Napa Feb 2022 – Sep 2022 SKILLS: Smartsheet, MS Access, SQL, Tableau, Power BI, NICE SatMetrix, QlikView

• Strengthened customer and stakeholder relationships through customer surveys, physician data insights, and competitor reports

• Improved customer satisfaction survey response rate by 15% by collecting insights from A/B testing, consumer trends, target demographics, and competing brands

• Help identify market trends, asses risk, and make decisions regarding policy adjustments, claims processing strategy, and resource allocation

Marketing Data Analyst

ClosetWorld (Home Organizing) Whittier Aug 2021 – Feb 2022 SKILLS: MS Excel, R, Python, SQL, Yelp Analytics, Power BI, Adobe Analytics

• Led complete product launch process from concept to market, including vendor selection, pricing, and promotion

• Reported on marketing KPIs such as leads, conversion rates, website traffic and social media engagement (delivery, open, click-through rates) to VP of Marketing

• Optimized performance of search results and social media content to display across conversion funnels to increase customer engagement and conversions while decreasing cost of customer acquisition

• Collaborated with VP of Marketing to budget $50M in monthly ad campaigns across the US Marketing Data Analyst

MyItalianDecor (E-Commerce) Novato Jan 2021 – Aug 2021 SKILLS: MS Excel, Google Analytics, Tableau, SEO, HTML, WordPress Peter Tallo

3

• Increased website traffic by 20% with content marketing strategy (i.e. campaign development, website design, and customer research) across vendors

• Worked with the CEO to oversee and monitor marketing investments as well as report e-commerce metrics as needed

• Managed social media account, blogs, and digital marketing campaigns Marketing Data Analyst

PENSA (Information Systems) San Francisco Mar 2020 – Jan 2021 SKILLS: MS Excel, Power BI, Data Modeling, Google Analytics

• Enhanced retail performance by conducting thorough market research and identifying key trends

• Implemented successful loss prevention strategies, resulting in reduced shrinkage levels across multiple locations

• Streamlined inventory management processes for improved efficiency and cost reduction

• Increased brand visibility and collaborated with merchandising team to develop cohesive product presentations

Marketing Data Analyst

Advantage Solutions Marketing (Marketing Agency) Irvine Feb 2018 – Mar 2020 SKILLS: SmartSheet, Tableau, Data Collection, Qualtrics, Google Analytics, Outreach

• Increased brand exposure through targeted marketing campaigns

• Identified product issues and customer needs through focus groups and market research surveys

• Reported social media activity and website traffic to help inform actionable decision-making Marketing Data Analyst

TNG Merchandising (Retail) San Francisco Mar 2014 – Jan 2018 SKILLS: Excel, Google Analytics

• Negotiated product costs and contract terms by communicating with vendors

• Maximized effect of sales promotions by collaborating with brand representatives

• Assessed inventory levels and sell-through rate to identify capacity and profitability

• Planned new store assortments and prepared acquisition models

• Calculated sell-through rates to measure goods sold during set timeframes EDUCATION

Master of Science (M.S.), Business Analytics 2021 – 2022 California State Polytechnic University, Pomona

Selected Coursework: Optimization Methods Business Analytics Advanced Statistics for Decision- Making Big Data Technology Social Media Analytics Data Mining Data Management Idea Development and Team Science Advanced Programming Bachelor of Science (B.S.), Business Management 2018 – 2020 University of California, Riverside

ACKNOWLEDGEMENTS

Master Scholar Graduate RESPECT Award 2022

Recognition of resilience, ethics, teamwork, peer mentorship, engagement, conscientiousness, and initiative

Contact this candidate