Hi, I’m
MERT MERTCAN
San Francisco,CA
Overview
8
years of professional experience
Work History
Eventbrite
Senior Product Analyst
05.2022 - 03.2023
Job overview
- Owned the analytics of Finance pillar by partnering with Director of Product Management and Product
- Managers
- Helped shaped product roadmaps with proactive deep dive analyses Defined KPIs and built monitoring and diagnostic dashboards with Tableau; resulted in over $40K in annual savings by replacing external dashboards Collaborated with Research and Finance team
- Defined the churn for the supply side of the business which then used by Product and Marketing teams for proactively keeping the existing users and reactivating the dormant users Defined the activation event that connected the supply and demand side of the business then created a robust metric
- Optimized the metric which improved the retention of users in major markets by ~5
Babylon Health
Senior Product Analyst
03.2021 - 05.2022
Job overview
- Owned the product analytics of registration and AI chatbot flow, partnering with Director of Product
- Management to define and manage analytics roadmaps Defined KPIs and built data models and dashboards with dbt, Bigquery, Airflow, Tableau and Looker data stack Managed and mentored a junior Product Analyst Built an experimentation tool with Looker which significantly improved the reliability, efficiency, and correctness of AB testing process Improved the eligibility check success rate from 42% to 57% by generating hypotheses and iterative AB tests
Product Data Analyst
09.2019 - 08.2020
Job overview
- Owned the experimentation process and produced the weekly deliverables on the experiment decisions Used advanced ETL skills to extract data for stakeholders who need key product questions answered Developed product insights and new KPIs that have significantly enhanced users experience and business metrics Created actionable deep dive analyses by using SQL, Python and Looker and presented it to upper management team Defined the activation event that users performed within a period and optimized that event which improved the retention by ~7% within 3 months
Draftkings
Growth Marketing Analyst
08.2018 - 02.2019
Job overview
- Built ETL and data mapping for various marketing data sources such as Adjust and Singular Conducted in-dept post campaign analysis, developed test plans for new user acquisition initiatives, and measured performance to identify testing opportunities Managed Yahoo Gemini and Yahoo DSP channels by conducting tests on the creatives and optimizing the media buying
Data Operations Analyst
11.2017 - 07.2018
Job overview
- Machine Zone (Cognant) Palo Alto Built retargeting user segments for mobile titles Yahoo Mail, Yahoo Sports, Yahoo Finance, and Airbnb by using RFM clustering that improved the re-install rate by 10% compared to the test group Built automated QA alerts to proactively catch issues in the data sources after the ETL by using RegEx functions in SQL which improved the efficiency by 25% and data accuracy by 15
Ironsource
Data Analyst
09.2015 - 10.2017
Job overview
- Recommended new metrics to the product team to be added in the product by analyzing the user funnel Built an index called M-Dex to find out the publishers that are underperforming
- As a result, the revenue of publishers increased by between 7% and 12
Education
BINGHAMTON
UNIVERSITY, STATE
UNIVERSITY OF
Master of Business from Marketing/Analytics
2015
BINGHAMTON
UNIVERSITY, STATE
UNIVERSITY OF
Bachelor of Science from Information
Systems
2013
ISTANBUL TECHNICAL
UNIVERSITY
Dual from Information Systems
Engineering
2013
Skills
- TECHNICAL SKILLS
- Advanced Analytics
- Product Analytics
- Marketing Analytics
- Data Wrangling
- Data Modeling
- Statistics and Probability
- SQL
- Tableau
- Looker
- Python (pandas, numpy)
- Dbt
- Mixpanel
Timeline
Senior Product Analyst
Eventbrite
05.2022 - 03.2023
Senior Product Analyst
Babylon Health
03.2021 - 05.2022
Product Data Analyst
09.2019 - 08.2020
Growth Marketing Analyst
Draftkings
08.2018 - 02.2019
Data Operations Analyst
11.2017 - 07.2018
Data Analyst
Ironsource
09.2015 - 10.2017
BINGHAMTON UNIVERSITY, STATE UNIVERSITY OF
Master of Business from Marketing/Analytics
BINGHAMTON UNIVERSITY, STATE UNIVERSITY OF
Bachelor of Science from Information
Systems
ISTANBUL TECHNICAL UNIVERSITY
Dual from Information Systems
Engineering