Ekin Derdiyok

Cover Statement

Data analyst with e-commerce and CRM experience, strong skills in Python, SQL, data visualization, and a solid business acumen. Based in Berlin and available from May. Previously at Wayfair.

Technical Skills

• Analytics: SQL, Python, Looker (Studio), Tableau, Google BigQuery, Google Sheets, Statistics, Machine Learning
• Marketing: Automation, E-commerce, HTML, Google Search Console, Google Analytics 4, Figma
• Channels: CRM, SEO, email, push notifications, social media, paid ads

Work Experience

• • Owned the growth strategy for B2C email and push notification campaigns in Wayfair UK and DE.
• • Monitored e-commerce & performance metrics: ATCs, PDP views, cart-abandonments, store visits, cohort revenue.
• • Increased the shipment confirmation campaign visit rate by 19% by A/B testing alternative copies.
• • Boosted analyst work efficiency by 33% by scripting recyclable SQL queries using DECLARE clauses.
• • Planned and deployed 2 post-order journey touchpoints aiming to improve CX and drive repeat purchases.
• • Collabed with the engineering and creative teams on revamping 8 push primers to increase push notif opt-ins.
• • Optimized marketing campaigns customer flows by leveraging in-house marketing automation and CRM tool.
• • After the layoff, continued business-critical ops, allowing smooth wind down, and purged DE from queries and dashboards.

• • Increased organic search impressions by 30% using technical and on-page SEO.
• • Authored monthly newsletters, ran A/B tests on subject lines to increase open rate.
• • Developed a 10 page SaaS marketing website with 200+ CMS entries with 100 SEO score on Pagespeed.
• • Plotted B2B customer journey, catalogued marketing touchpoints, addressed leads' painpoints.
• • Organized 5 Apple Vision Pro Community Events with a total of 300+ attendees, set up a booth at AWE USA.

• • Applied computational models to 𝕏 (Twitter) data, used OpenAI API for NLP, constructed social network graphs.
• • Deployed machine learning algorithms (t-SNE, k-means, PCA) in Python on real-time user feedback.

Projects

• KPI Dashboard Dining Platform (Tableau): Visualize business-critical KPIs across product, marketing, B2B
• Customer Segmentation for Online Fashion Retailer (Python): Uses k-means, recency-frequency-monetary (RFM).
• Campaign Analytics for Mealkit Delivery (SQL): Calculates summary statistics and growth KPIs.
• Subscription-Model User Analytics Dashboard (Tableau) Builds a sleek, interactive Tableau dashboard.
• Causal Inference for Online Fashion Retailer (Python): Discusses the benefits of the method, codes a proof-of-concept.
• Information Diffusion on Twitter (Python): Compares computational models, constructs social network graphs.
• ↳ Visit my GitHub profile for full list of projects and code repositories.

Education

• Published Altered States Database as the second author in Nature scientific data.
• Courses: Neurocognitive Methods and Data Analysis, Probabilistic and Statistical Modeling, Introduction to Programming

• Courses: Data Collection, Experimental Design, Research Methods, Statistics for Social Sciences

Soft Skills

• Language: English (Professional fluency), German (B2), Turkish (Native)
• Presentation Skills: Expertly delivers engaging presentations. Crafts clear and concise reports.
• Business Impact Driven: Sets and monitors KPIs. Benchmarks results for intelligent business decision-making.
• Stakeholder Management: Collaborates with cross-functional teams, ensures alignment and manages expectations.

Certificates

• Professional Data Analyst by DataCamp: Python, SQL
• Google Cloud Data Analytics Certificate: Fundamental cloud concepts, BigQuery, Looker
• Google Analytics Certification: Google Analytics 4 (GA4), Google Tag Manager (GTM)
• ↳ See my LinkedIn for credential IDs and full list of certifications.

Hobbies

• Bachata: Social dancer, performer and instructor for 70+ beginner dancers.
• Personal finance: Keen interest in investing, stocks, and Web3 for 4+ years.
• Yoga: Practices regularly to enhance physical and mental well-being.