ABHISHEK SOMASHEKARA

+•• ••••• •••••••••••@•••••.com

3 yrs

  • Open to Bangalore · Delhi · Hyderabad · Mumbai · Pune
  • Hybrid, Remote

Ask about ABHISHEK

Skills

Claimed

Problem SolvingProject ExecutionWork Planning and PrioritizationCloud AutomationData TransformationData Unification and NormalizationFeature SelectionData PreprocessingTabular Data Cleaning & ValidationETL Pipeline DevelopmentAutomated Report GenerationTask Automation

Proof of Experience

Data Analyst - Revenue Operations Intelligence

Sky Cluster Group · Jan 2025 – Nov 2025

  • Automated recurring reporting workflows using SQL and Python pipelines, reducing manual reporting effort by 20+ hours per month across a 5-member analytics team.
  • Designed and delivered 12+ Power BI dashboards tracking revenue growth, campaign performance, retention, and operational KPIs for 10+ business stakeholders.
  • Built end-to-end ETL workflows consolidating CRM, sales, and inventory data from multiple sources, improving reporting consistency and reducing data errors by ~30%.
  • Developed structured KPI frameworks aligned with product and revenue goals, ensuring metric standardisation across marketing and operations teams.
  • Conducted cohort and trend analysis to identify revenue leakage patterns and user engagement opportunities.
  • Performed retention and campaign performance analysis to support weekly performance reviews and strategic planning discussions.
  • Implemented SQL-based data validation checks, increasing reporting reliability and reducing recurring discrepancies.
  • Delivered insight-driven recommendations that improved decision-making speed by ~30-35% across operational teams.
  • Collaborated cross-functionally with product, marketing, and operations teams to translate business problems into structured analytical tasks.
  • Documented dashboard logic, data models, and reporting workflows to ensure scalability and reuse across future projects.
LTIMindtree

Business Data Analyst

LTIMindtree · Aug 2021 – Oct 2023

  • Engineered Azure-based ETL pipelines integrating CRM, billing, subscription, and usage datasets, reducing reporting delays by 70%.
  • Designed and implemented star-schema data models to optimize analytical queries, improving SQL performance by ~40%.
  • Built advanced Power BI dashboards tracking MRR, churn rate, adoption %, ARPU, and growth metrics used by 50+ business users and leadership stakeholders.
  • Developed complex SQL queries (CTEs, window functions, aggregations) to support churn analysis and user lifecycle tracking.
  • Automated dashboard refresh processes and implemented access controls to ensure same-day data availability and secure reporting.
  • Performed deep-dive churn and retention analysis to identify behavioural drop-off points and upsell opportunities.
  • Conducted performance analysis on usage and engagement metrics to support product and revenue strategy decisions.
  • Reduced reporting defects by ~30% through structured data validation, reconciliation checks, and documentation improvements.
  • Partnered with cross-functional teams (finance, product, operations) to define KPIs and ensure alignment between data outputs and business objectives.
  • Supported ad-hoc executive requests by delivering rapid SQL-based analysis under tight deadlines while maintaining high data accuracy.

Proof-of-Work

No completed sessions yet. Anything ABHISHEK finishes shows up here with the evidence behind it.

Proof of Education

MSc, Artificial Intelligence Strategy

Brunel University London, UK · 2024 — 2025

BTech, Electronics and Communication

PESCE, INDIA · 2017 — 2021

A Proof CV — one profile, kept current, with the proof attached. Back to the portal