Shubham Khandelwal

Associate Consultant

Bangalore Urban, Karnataka, India8 yrs 6 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Reduced data refresh time from hours to minutes.
Automated regulatory reporting, saving 70% work effort.
Created impactful dashboards for pharma and finance sectors.

Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Fintech industries.

Contact

Skills

Core Skills

Data AnalyticsData VisualizationData EngineeringData AnalysisData ReportingData AutomationConsultingPerformance Optimization

Other Skills

TableauApache AirflowPySparkSupersetPython (Programming Language)SparkSQLAirflowPythonData Build Tool (DBT)MetaBaseAmazon RedshiftSQLJasper ReportsExcelHealthcare Consulting

About

Seasoned data analyst with strong experience in data manipulation & data visualisation in pharma & finance industry. Hands-on experience on SQL, Tableau, R, dbt, Excel & Python. Currently pursuing 6-months Google's data analytics course.

Experience

8 yrs 6 mos

Total Experience

1 yr 8 mos

Average Tenure

3 yrs 4 mos

Current Experience

Airbnb

2 roles

Analytics & Insights Senior Analyst

Promoted

Sep 2024 – Present · 1 yr 7 mos · Bengaluru, Karnataka, India · Remote

Developed end-to-end data pipeline for leadership reporting in SparkSQL using Airflow, reducing refresh time from 2 hours to 10 mins.
Collaborated with Data Engineering on metric requirements, development, and schema needs.
Integrated python scripts in Tableau using TabPy API for anomaly detection, increasing efficiency by over 50%.
Supported data analytics and dashboarding for a community support team of 15000+ partners at Airbnb.

TableauApache AirflowPySparkSupersetPython (Programming Language)Data Analytics+1

Analytics & Insights Analyst

Dec 2022 – Sep 2024 · 1 yr 9 mos · Bengaluru, Karnataka, India · Remote

As an Analytics & Insights Analyst at Airbnb, I created and maintained a data pipeline in SparkSQL using Airflow, significantly reducing refresh time for a weekly report. I collaborated with Data Engineering on metric requirements and supported data analytics for a large team of supporting partners.

Zeta

Data Analyst

Jun 2021 – Dec 2022 · 1 yr 6 mos · Bengaluru, Karnataka, India · Remote

Responsible for heading critical regulatory reporting to RBI. Automated the whole process using Python & Excel while meeting requirements and deadlines, which resulted in a 70% decrease in work-effort in the creation of these monthly reports.
Analyzed database structure and data models and identified areas for improvement. Mined, analyzed & manipulated data models to generate SSOTs for various key metrics. Reduced overall refresh time by 10%, enabling faster access to data for decision-makers.
Directly engaged with client for requirement gathering, iterative feedback process & end to end execution with Hypercare support.

Data Build Tool (DBT)MetaBaseAmazon RedshiftSQLJasper ReportsPython (Programming Language)+2

D cube analytics

Associate Consultant

Jun 2020 – Jun 2021 · 1 yr · Bengaluru, Karnataka, India

Directly engaged and created 20+ Tableau dashboards for a top-tier US pharma client while leading a team of 4 analysts, resulting in a 25% increase in usage of data across the company.
Designed strategic KPI dashboards for various use-cases (Summary, Performance, Customer, Customer Profile, Basket & Execution) under ‘Good-to-Great’ initiative, bringing 40% improvement in dashboard loading time by improving performance by incorporating aggregations, indexes and tableau/ query optimization techniques.
Collaborated towards the initiative ‘Delivery Process Revamp’ by revising process documentation, which resulted in 50% better onboarding of new teammates.

SQLHealthcare ConsultingTeam BuildingKPI DashboardsTableauData Visualization+1

Iqvia

2 roles

Consultant

Promoted

Apr 2020 – Jun 2020 · 2 mos

Created 15+ dashboards, migrated from Excel based reporting to automated Tableau reports and reduced the time to produce the reports from 5 hours to 30 minutes.
Performed patient level analytics to understand the business growth & created appropriate solutions/ strategy which resulted into 15% better patient retention rate by leveraging SQL and Excel.
Designed and implemented an Incentive Compensation plan and report for the salesforce by utilizing SQL, Excel and Tableau to track employee performance.

Analyst

Jun 2018 – Mar 2020 · 1 yr 9 mos

Subros limited

Engineer

Jul 2017 – Jun 2018 · 11 mos · Manesar, Gurgaon

Carried out project on 'Cycle-time reduction of Injection molding machine by optimization of molding parameters' through statistical analysis using Minitab software.
Completed cost saving project on 'Locating and correction of unbalanced region in blower fan'.
Preparation and documentation of process documents like PFD, PFMEA, CP and QA-Network.
Presenting PPTs at management meetings like WRM, QRM.