AS
ABHISHEK SOMASHEKARA
Contact details — on requestProof of Work — on request
Experience
S
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.
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.
Skills 0 proven through work
Also works with
Problem SolvingProject ExecutionWork Planning and PrioritizationCloud AutomationData TransformationData Unification and NormalizationFeature SelectionData PreprocessingTabular Data Cleaning & ValidationETL Pipeline DevelopmentAutomated Report GenerationTask AutomationData-Driven RecommendationsStakeholder Communication AdaptationData StorytellingBusiness Growth StrategySales AnalysisCustomer Journey MappingCustomer Retention and Churn PreventionData CollectionCustomer Behavior AnalysisE-commerce Data AnalysisCustom Metric DesignData ModelingData ValidationDashboard UI DesignPower BIPython DevelopmentQuery WritingData Science
Proof of Work
Proof of Work
ABHISHEK shares this with people who ask. You'll hear back either way.
Education
MSc, Artificial Intelligence Strategy
Brunel University London, UK · 2024 — 2025
BTech, Electronics and Communication
PESCE, INDIA · 2017 — 2021
Contact details
Contact details
ABHISHEK shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal