Product Analyst and SEO Consultant, freelance Berlin, Germany
EST. 2014 Booking 2026 engagements

Turning organic
search into measurable
growth & revenue.

I'm Kiran Babu Thatha, a freelance SEO consultant and product analyst in Berlin. I spent four years at Wayfair working where technical SEO, data, and AI meet: page curation across millions of pages, ML internal linking, and AI search visibility across five brands and eight global stores. Now I do that work for clients.

Now Freelance SEO & analytics
Previously Wayfair, 2021 to 2025
Status Open to roles & projects
Technical SEO International Strategy Programmatic SEO Experimentation AI & LLM Integration Python Automation Site Architecture Data & Reporting Technical SEO International Strategy Programmatic SEO Experimentation AI & LLM Integration Python Automation Site Architecture Data & Reporting

Numbers that moved the business.

Shipped products, recovered revenue, and growth measured against real KPIs, not vanity metrics.

$15M
Revenue protected via
self-service SEO guardrails
98%
Traffic retained while cutting
indexable pages by 90%
+9%
Lift in page clicks via
ML-based internal linking
+30%
Indexation lift from automated
sitemap generation

My background sits at the seam between SEO strategy and applied data engineering. I started as a support engineer in banking and HR systems, resolving thousands of technical issues and automating over 200 manual processes, before moving to Germany for a Master's in Digital Engineering and joining Wayfair, where I scaled from intern to Senior Product Analyst.

At Wayfair, I worked on organic growth across five brands and eight international stores, partnering with Engineering, Product, and Content to align organic visibility with revenue. I shipped ML sentence-transformer models for internal linking, led page curation that cut indexable volume by 90% while keeping 98% of traffic, and built automation on the Claude and OpenAI APIs that lifted organic traffic by 5%. Since February 2026 I do this work independently for clients, alongside product experimentation and analytics.

What I care about: scale without manual toil. Most of my work ends in an automated pipeline, a self-service tool for non-technical teams, or a dashboard that replaces a recurring meeting. At Wayfair I pioneered Generative Engine Optimization (GEO), tracking visibility in Google AI Overviews, ChatGPT, and Perplexity and adapting content and schema so pages get cited by AI search. I build this kind of SEO tooling with Claude Code, custom Python crawlers, and the OpenAI and Anthropic APIs.

Outside of work I build at hackathons. I was runner-up at the Cyprus Hackathon with Workwise, an AI agent app. I read widely on culture, travel, and how systems get built.

A decade of building.

From banking ETL pipelines in Hyderabad to multilingual SEO at Wayfair, and now independent consulting from Berlin. Every role has been about scale, automation, and decisions backed by data.

/01
Product Analyst & SEO ConsultantFreelance, Berlin
I partner with product, marketing, and brand teams to grow through experimentation and organic search. Engagements cover A/B testing end to end, from hypothesis and KPI definition through monitoring and the statistical read, plus technical SEO audits, indexation fixes, SEO automation, and AI search (GEO) visibility. Scoped around outcomes, as short projects or ongoing retainers.
Feb 2026 to PresentBerlin, Germany
/02
Senior Product Analyst, SEOWayfair, Berlin
Ran A/B testing and experimentation programs end to end across five brands: Wayfair, Joss & Main, AllModern, Birch Lane, and Perigold. Pioneered Generative Engine Optimization, tracking visibility in Google AI Overviews, ChatGPT, and Perplexity. Led page curation across millions of pages, cutting indexable volume by 90% while keeping 98% of traffic and 95% of revenue, and automated sitemap generation that raised indexation rates by 30%.
Apr 2023 to Nov 2025Berlin, Germany
/03
Product Analyst, SEOWayfair, Berlin
Shipped Python and NLP scripts that cut content duplication by 90% and cannibalisation by 60% across EN, DE, and FR. Built an MVP guardrail tool that prevented an estimated $15M in revenue loss and reduced manual SEO intervention by 80%. Worked with Engineering on automated indexing that raised indexation rates by 15%.
Jun 2022 to Mar 2023Berlin, Germany
/04
SEO InternWayfair, Berlin
Automated KPI reporting with Python and Google BigQuery, lifting team efficiency by 30%. Built SQL scripts powering dashboards for keyword rankings and organic traffic KPIs, and applied text generation techniques to improve page relevance.
Dec 2021 to May 2022Berlin, Germany
/05
Senior Application Support EngineerADP, Hyderabad
Led a five-person team across HR and payroll systems. Drove a 70% drop in recurring delays through structured root-cause analysis and process automation. Coordinated with QA on stability and uptime.
Oct 2018 to Aug 2019Hyderabad, India
/06
Application Support EngineerVirtusa, Hyderabad
Cut application issues by 60% across three banking dev teams. Automated 200+ manual processes, shrinking support workload by 80%. Managed 1,000+ SQL queries and 100+ secure file transfers for high-stakes banking ops.
Dec 2014 to Oct 2018Hyderabad, India

Four projects, real outcomes.

Brief case studies from my work at Wayfair: the problem, the approach, and the numbers that made it worth shipping.

Case: ML / Internal Linking

Sentence-transformer driven internal linking at scale.

Replaced older fuzzy-matching internal linking logic with an ML pipeline using sentence-transformer embeddings to surface the most semantically relevant link targets, rolled out across five global projects.

+9%Page clicks
+2%SERP positions
5Global projects
Case: Guardrails & Tooling

Self-service SEO guardrails for merchandising.

Built an MVP self-service tool that proactively monitored site health and blocked harmful changes to high-performing pages, letting non-SEO teams ship safely without bottlenecking on the SEO team.

$15MRevenue protected
−80%Manual intervention
Case: NLP & Multilingual

Cannibalisation solved across three languages.

A Python, NLP, and RegEx pipeline to detect and resolve duplication and cannibalisation across EN, DE, and FR content, turning a recurring quality problem into a one-time engineering fix.

−90%Duplication
−60%Cannibalisation
3Languages
Case: LLM Workflows

Multilingual content generation, in production.

Designed and led product direction for a Python-based content workflow using OpenAI LLMs, aligning generated copy with searcher intent, brand voice, and the marketing funnel across multiple global stores.

5+Markets
Funnel-awareIntent mapping
Now booking 2026 engagements

SEO consulting that scales with you.

Six focused offerings drawn from production work at Wayfair. Engagements run as one-off audits, fixed-scope projects, or month-to-month retainers.

View all six services Python automation deep-dive

Things I work with daily.

A working snapshot, not an exhaustive list. Tools earn their place by appearing in something I shipped.

SEO & Search
  • Google Search Console
  • Ahrefs
  • Screaming Frog
  • Schema.org
  • Custom Python crawlers
  • AI search visibility (GEO)
Data & Analytics
  • Google BigQuery
  • SQL
  • Google Analytics 4
  • Looker / Data Studio
  • Tableau
  • Metabase
Code & AI
  • Python
  • JavaScript
  • OpenAI & Anthropic APIs
  • Claude Code
  • Sentence transformers
  • Git / GitLab
Workflow
  • JIRA
  • Agile / Scrum
  • Google Cloud
  • ETL pipelines
  • Vendor management

Degrees and certifications.

Master's degree
M.Sc. Digital Engineering
Otto-von-Guericke University Magdeburg
2019 to 2022, Magdeburg, Germany
Bachelor's degree
B.Tech, Electronics & Communication Eng.
Jawaharlal Nehru Technological University
2010 to 2014, Hyderabad, India
Neural Networks & Deep Learning, DeepLearning.ai
Convolutional Neural Networks, DeepLearning.ai
Cyprus Hackathon, Runner-up
/08 Get in touch

Let's build something
that ranks.

[email protected]
Book a call
Email LinkedIn +49 176 6915 0963 Berlin, Germany