Shubham Khandelwal

Data Scientist

Faridabad, Haryana, India6 yrs 1 mo experience

Most Likely To Switch

Key Highlights

6 years of diverse data analysis experience.
Expert in data visualization and actionable insights.
Proficient in SQL, Python, and Tableau.

Stackforce AI infers this person is a Data Analyst with expertise in Healthcare and Banking sectors.

Contact

khandelwalshubham67@gmail.com LinkedIn

Skills

Core Skills

Data AnalyticsData Visualization

Other Skills

Business AnalyticsBusiness RequirementsC++Data MiningData WarehousingDatabasesETLExtract, Transform, Load (ETL)HIVEHiveQLKey Performance IndicatorsMicrosoft Power BIMySQLRandom ForestSQL

About

Data Analyst having hands on 6 years of experience across industries like Healthcare and Banking in interpreting, analysing and turning the data into actionable insights, and meaningful stories. Right from the data extraction till the final data product or actionable insights, i enjoy the journey with the data. An Experienced Data Visualization professional, crafting and delivering end to end data visualization projects implementing best visualization principles and design thinking to enable better insights. Key technologies worked on : SQL, Python, Machine Learning, Tableau, Hive, Hadoop, Spark

Experience

Boston consulting group (bcg)

Global Data Analyst Specialist

Jul 2023 – Present · 2 yrs 8 mos

Exl

Business Analyst

May 2022 – Jul 2023 · 1 yr 2 mos · India

Developed Price Elasticity model using Random Forest to forecast the market capture in the forthcoming years.
Created Hive queries that helped market analysts spot emerging trends by comparing fresh data
with reference tables and historical metrics.
Involved in advanced SQL operations (Join, Aggregation, Filter, Subquery, Grouping, Case When
Statement, Common Table Expression, Window Functions (Lead, Lag, Cummulative Sum, Rank, Dense Rank, Row number etc).
Gained Strong understanding of Tableau’s LOD functions, Filters, Table Calculations,
data blending, relationships and joins.
Implemented Performance optimization techniques using Data Source Filters, Context Filters
and extract connection.
Developed interactive Tableau dashboards using Dashboard Actions for Healthcare client using KPIs such as Price Growth, Competitor Price growth, Estimated members by marketing category, Broker Conversion, Persistency rate, Effectuation%.
Created different charts such as Doughnut chart to showcase the % distribution of est. 2023 addressable market in different marketing categories. Also used blended axis charts to show the distinction between forecasted budget members and the members estimated.
Utilized Tableau Server to publish and share the report with the business users.

Random ForestHiveQLSQLTableauData VisualizationData Analytics

Tata consultancy services

Data Analyst

Feb 2020 – May 2022 · 2 yrs 3 mos

● Created complex Tableau charts such as sunburst, Waffle and curved charts using data densification techniques.
● Developed Customer Segmentation interactive Dashboards using Bins, Parameters, Groups
& Sets.
● Designed, developed, and maintained SQL data warehouses, data pipelines, and reporting tools for Operational Business impact.
● Designed database schema using MySQL created tables to store data and performed data manipulation.
● Defined sources to target data mappings, data definitions, prepared data elements, data flow
diagrams and mapping documents for ETL jobs.
● Assisted senior level data scientists in the design of ETL processes, including SSIS packages.
● Performed SQL query performance tuning by creating/modifying indexes.
● Involved in creating Hive tables loading with data and writing Hive queries which runs
parallelly in map reduce way.