Vikram Kumar

Mob.: +357-96346120 | E-Mail: vikram1840@gmail.com

LinkedIn |GitHub | Limassol, Cyprus

Professional Summary

Business-driven Senior Data Analyst with 15 years of experience and expertise in influencing C-level strategy through data. Skilled in defining key metrics, performing deep-dive analysis, and providing recommendations to enhance customer experience and drive business growth. Expert in SQL, Python (Pandas, NumPy) and statistical methods to solve complex business problems.

Key Achievements

  • Increased daily order volume by 10-12% through high demand zone optimization.
  • Reduced order cancellation by 8-10% with root-cause dataset design.
  • Improved CSAT by 6% and reduced Ops cost by 10% through call center performance optimization.
  • Accelerated ad-hoc analysis by 40-50% through LLM-assisted analytics and insight generation.
  • Cut report generation time by 30% using SQL query optimization and job scheduling improvements.

Core Strengths

Leadership:Collaboration with Operation, Finance, Marketing & Sales, C-level Presentations, Team Mentoring
Analytics:KPI Design, A/B Testing, Hypothesis Testing, Regression Analysis
Domain Strategy:Subscription & Loyalty, Orders, Merchant, Call Centre, Operational Optimization
Data Quality:Source Reconciliations, dbt tests (not-null, unique, recency), daily anomaly checks
Data Capabilities:Daily & Real-time Dashboards, Data Mart & Transformation (DBT)
BI Tools:SQL (Redshift, PostgreSQL, Clickhouse), Python (Pandas, NumPy), Tableau, Superset, Excel
AI & Automation:Reporting Automation, LLM-based Insight Generation, Ad-hoc Query Intelligence

Professional Experience

ARAM MEEM Ltd (ToYou Delivery Platform) – Senior Data Analyst

Sept 2021 – Present

Limassol, Cyprus

    [cite_start]
  • Designed and analyzed A/B tests on subscription and promo strategies, using RFM-based segmentation to tailor offers and measure impact on contribution margin and order volume[cite: 18, 19].
    • [cite_start]
  • Defined and executed BI Strategy converting ad-hoc asks into portfolio of self-service dashboards and data marts used daily by finance, operation and management team[cite: 20].
    • [cite_start]
  • Introduced Clickhouse and Superset in BI for real-time monitoring backbone and delivered 10+ interactive real-time dashboards used daily by 100+ operations and CX users[cite: 21].
    • [cite_start]
  • Mentored junior analysts on SQL, dashboards and metric definitions, reviewing their queries and helping standardized logic across reports[cite: 22].
    • [cite_start]
  • Uncovered Call Center inefficiencies (SQL, Python, Tableau) - agent performance gaps, load issues, lower shift utilization led to staffing optimization and 6% CSAT improvement[cite: 24].
    • [cite_start]
  • Conducted churn and retention analysis identifying high-impact segments - prioritizing fixes that reduced churn and improved customer retention by 10-12%[cite: 25].
    • [cite_start]
  • Designed a complex cancellation reason dataset (SQL) with ownership mapping, reduced cancellation by 10%, improved customer experience and streamlined merchant compensation flows[cite: 26].
    • [cite_start]
  • Identified and resolved configuration barriers that boosted daily order volume by 10-12% without additional marketing spend[cite: 27].
    • [cite_start]
  • Integrated LLMs (ChatGPT, Gemini) into analytics workflow for insight generation, debugging SQL/Python logic, and reduced ad-hoc turnaround time by 30-40%[cite: 28].

Amdocs Ltd – Senior BI Developer

Jan 2015 – Aug 2021

Limassol, Cyprus (2017-2021) | Gurgaon, India (2015-2017)

    [cite_start]
  • Led a team of 10 BI analysts and migrated 250+ enterprise reports to cloud infrastructure, improved speed, scalability and governance[cite: 32].
    • [cite_start]
  • Educated business users through Power BI training on self-service reporting, DAX usage, filters and effective visualization to maximize reporting value[cite: 33].
    • [cite_start]
  • Developed in-house automation tools, saved man hours and enabled additional projects without extra headcounts[cite: 34].
    • [cite_start]
  • Applied exploratory data analysis (EDA) on telecom network KPIs, doubling user throughput and reducing drop rate from 1% to 0.6%[cite: 35].

Earlier Experience – Telecom | Network Analytics

Sept 2010 – Jan 2015

Bangalore, India

Certification & Award

  • Microsoft Certified Power BI Analyst | DBT Certified
  • Awarded by Amdocs and Nokia for innovation in delivery and automation
  • Workshop leader to promote rapid prototyping and enhance work culture across Amdocs Cyprus

Education

Master's degree (EPGDBM) - Business Statistics2016-2018
Symbiosis International University, Pune (India)
Bachelor's degree (B-Tech): Electronics & Telecom2006-2010
Kalinga Institute of Industrial Technology, Bhubaneswar (India)