Summary
Overview
Work History
Education
Project
Skills
Timeline
Generic

Shubham Shakya

Noida

Summary

Results-driven Business Intelligence & Data Analytics professional with ~7 years of experience designing scalable BI solutions and shaping data strategy across industries. Skilled in data modeling, pipeline optimization, and translating business needs into actionable insights. Adept at collaborating with cross-functional teams to deliver impactful dashboards, streamline reporting processes, and enable data-driven decision-making. Recognized for improving efficiency, boosting stakeholder satisfaction, and driving measurable business outcomes through data leadership and advanced analytics.

Overview

8
8
years of professional experience

Work History

Senior Business Intelligence Analyst

Harman Connected Services
Gurgaon
03.2022 - Current
  • Led the implementation of cloud-based BI solutions (Quicksight, Redshift, RDS), enabling self-service analytics and improving reporting efficiency by 25%.
  • Designed and optimized ETL pipelines to integrate data from Salesforce, Google Analytics, and multiple databases, ensuring reliable and timely insights for stakeholders.
  • Conducted exploratory and statistical analyses on large datasets, uncovering trends and delivering actionable insights on customer behavior and business KPIs.
  • Partnered with business teams to define requirements and delivered interactive dashboards adopted across departments, enhancing visibility into key metrics.
  • Optimized SQL queries and reporting workflows, reducing data retrieval times and improving overall reporting accuracy.

Senior Analyst

Capgemini
Noida
11.2019 - 06.2021
  • Developed Power BI dashboards with advanced DAX and SQL, improving reporting turnaround by 30% and enabling leadership to track KPIs in real time.
  • Built ad-hoc reports integrating multiple data sources, increasing reporting accuracy and efficiency.
  • Created and optimized SQL queries to support exploratory analysis, improving ad-hoc reporting speed.
  • Applied statistical analysis to identify key trends, delivering actionable insights that guided business decisions.
  • Partnered with stakeholders to align BI solutions with business objectives, improving adoption across teams.

Analyst

HCL Technologies
Noida
03.2018 - 11.2019
  • Monitored and optimized SQL databases, reducing downtime by 20% through proactive issue identification and resolution.
  • Designed and automated Excel-based reports (Pivot Tables, VLOOKUP), streamlining reporting and saving significant manual effort.
  • Conducted routine database maintenance, backups, and patching to ensure high system availability.
  • Developed SQL-based reporting solutions to support operational teams, improving reporting accuracy and efficiency.
  • Collaborated with IT teams on troubleshooting and access management, ensuring secure and stable data environments.

Education

M.Tech - Data Science and Engineering

BITS Pilani Work Integrated Learning Program
10-2025

B.Tech - Electronics & Telecommunication Engineering

Dr. A.P.J. Abdul Kalam Technical University
01.2016

Project

NLP-Powered BI Dashboard for Natural Language Querying and Reporting

(M.Tech Dissertation)

  • Developed a dashboard that allows users to query databases in plain English and automatically generates accurate SQL queries.
  • Enabled instant visualization by converting query results into tables, charts, and concise insights.
  • Designed a conversational interface that supports follow-up questions and provides context-aware responses.
  • Implemented automated report generation with embedded data summaries and visuals.

Skills

  • Analytics & Data Science: Data Strategy, Marketing Analytics, Statistical Analysis, Hypothesis Testing,Predictive Analysis, Descriptive Analysis, Exploratory Data Analysis (EDA), Data Storytelling
  • Programming & Data Handling: Python (Pandas, NumPy), Advanced SQL (Query Optimization, Window Functions, CTEs), PostgreSQL, MySQL, Data Wrangling, ETL Pipelines
  • Business Intelligence and Visualization: Business Intelligence Strategy, Dashboard Design and Data Storytelling, Self-Service Analytics Enablement, Power BI, Tableau, AWS Quicksight, KPI Tracking.
  • Cloud & Data Platforms: AWS Redshift, AWS RDS, Cloud Data Warehousing, Data Integration
  • Product & Leadership: Stakeholder Management, Data Governance, Defining Data Roadmapping, Agile/Scrum, Cross-functional Collaboration, Problem Solving, Project Management

Timeline

Senior Business Intelligence Analyst

Harman Connected Services
03.2022 - Current

Senior Analyst

Capgemini
11.2019 - 06.2021

Analyst

HCL Technologies
03.2018 - 11.2019

M.Tech - Data Science and Engineering

BITS Pilani Work Integrated Learning Program

B.Tech - Electronics & Telecommunication Engineering

Dr. A.P.J. Abdul Kalam Technical University
Shubham Shakya