Summary
Overview
Work History
Education
Skills
Websites
Certification
Extracurricular
Timeline
Generic

ABHIRAM REDDY PALICHERLA

Business Data Analyst
Frankfurt am Main

Summary

Data & Analytics professional with experience building end to end BI stacks, ELT pipelines, and analytics apps. Proven track record standardizing reporting, automating workflows, and delivering actionable dashboards across retail, SaaS, and hospitality.

Overview

8
8
years of professional experience
1
1
Certification
4
4
Languages

Work History

Data Analyst / BI Consultant

Kemb GmbH
03.2022 - Current
  • Built and scaled BI infrastructure for 12+ clients (retail, SaaS, hospitality) handling up to 100M+ rows per client in Snowflake.
  • Designed 16+ reusable data transformation/reporting templates, reducing delivery time by ~50% across recurring projects.
  • Integrated CRM and third party tools (e.g., Sistrix, Personio, HubSpot) via REST APIs; unified data models saved 12+ hours/month of manual stitching.
  • Automated 5 web scraping pipelines to gather pricing & product intelligence across 300+ competitor URLs.
  • Created 20+ interactive dashboards for Marketing & Management; cut manual Excel work by up to 70% and boosted report adoption.
  • Led development of SEO/SEA reporting systems, unlocking €1,800+ MRR via packaged analytics services.
  • Built ML forecasting for CPC & conversion rates; improved planning accuracy by up to 25%.
  • Developed sentiment analysis for 10k+ reviews/month to surface motivators/detractors for hospitality strategy.
  • Automated internal time tracking & capacity planning; ~5 hours/week saved per team lead.
  • Deployed MAKE (Integromat) onboarding automations; reduced setup from ~1 day to ~2 hours.
  • Tech: Snowflake, dbt, Coalesce, Fivetran, AWS (Lambda, S3), Azure, Snowflake Cortex, Databricks, Streamlit, REST APIs, Metabase, Looker, PostgreSQL.

Technical Consultant

TATA Consultancy Services
11.2018 - 06.2021
  • Certified product consultant for Zuora; implemented for Toyota Financial Services with subscription products.
  • Built 14 FastForward automation test use cases; demos helped acquire 3 customers (Honeywell Fire, Honeywell BMS, Extreme Networks).
  • Created Zuora Workflow API use cases; automated 12 repetitive tasks (55% processing time).
  • Used Postman to GET/SET records on Zuora and Salesforce; synced via Zuora 360 and created product quotes.
  • Integrated Microsoft Excel with Zuora via Informatica PowerCenter (ETL) to load accounts/products.
  • Team lead for HID Global implementation (4 months): initial environment setup (accounts, products, accounting periods, invoice templates).

Performance Analyst Intern

Nokia Networks & Solutions
10.2017 - 07.2018
  • Generated KPI reports for MS, NI, NPO, and CARE business lines.
  • Developed Excel VBA macros; ~70% efficiency gain via automation.
  • Migrated KPI reporting from Excel to Power BI, enabling rich visualizations.
  • Trained a 12 member team on Power BI and standardized its usage.

Education

Master in Management - Data & Business Analytics concentration

Frankfurt School of Finance & Management
11-2023

Master of Technology (Integrated) - Software Engineering

Vellore Institute of Technology
01.2018

Skills

  • Programming: Python, Java, NET, HTML, CSS, VBA Macros
  • Data & Analytics: dbt, Coalesce, Fivetran, Metabase, Looker, Power BI, Tableau, Excel (advanced)
  • Data Platforms: Snowflake, Databricks, Snowflake Cortex, PostgreSQL, MySQL, Oracle
  • ELT & ELT Pipelines: Fivetran, REST APIs, Web Scraping, MAKE (Integromat)
  • Cloud: AWS (Lambda, S3), Azure
  • Apps & Viz: Snowflake Streamlit, Power BI, Tableau
  • CRM/MarTech: HubSpot, Personio, Sistrix, Salesforce, Zuora

Certification

Snowflake SnowPro Core

Extracurricular

Friends of Needy (FON) — Member (2015–Present) The Fine Arts Club (TFAC) — Artist (2016–2017) Make a Difference (MAD) — Volunteer (2015–2016)

Timeline

Data Analyst / BI Consultant

Kemb GmbH
03.2022 - Current

Technical Consultant

TATA Consultancy Services
11.2018 - 06.2021

Performance Analyst Intern

Nokia Networks & Solutions
10.2017 - 07.2018

Master in Management - Data & Business Analytics concentration

Frankfurt School of Finance & Management

Master of Technology (Integrated) - Software Engineering

Vellore Institute of Technology
ABHIRAM REDDY PALICHERLABusiness Data Analyst