Shubham Sahni - Commercial Data and Analytics Intern

Q: Where is Shubham based?

Shubham is based in Magdeburg, Germany .

Q: What languages does Shubham speak?

Shubham speaks the following languages: English (Advanced), German (Elementary) .

Q: How many years of experience does Shubham have?

Shubham has at least 4 years of experience. During this time, Shubham has worked in at least 3 different roles and for 3 different companies . The average length of individual experience is 1 year and 3 months . Note that Shubham may not have shared all experience and actually has more experience.

Q: What is Shubham's latest experience?

Shubham's most recent position is Commercial Data and Analytics Intern at Bavarian Nordic .

Q: What companies has Shubham worked for in recent years?

In recent years, Shubham has worked for Bavarian Nordic , BASF , and Provana .

Q: Which industries is Shubham most experienced in?

Shubham is most experienced in industries like Information Technology , Chemical , and Biotechnology . Shubham also has some experience in Pharmaceutical .

Q: Which business areas is Shubham most experienced in?

Shubham is most experienced in business areas like Business Intelligence , Information Technology , and Product Development .

Q: What is Shubham's education?

Shubham holds a Master in Big Data Management from IU Internationale Hochschule and a Bachelor in Business Informatics from The NorthCap University .

Q: What is the availability of Shubham?

Shubham will be available full-time from August 2026 .

Recommended expert

Magdeburg, Germany

Check rate

Experience

Dec 2025 - Present

7 months

Commercial Data and Analytics Intern

Bavarian Nordic

Partner with commercial, sales, and medical affairs teams to translate business questions into structured analyses and interactive Power BI dashboards, enabling data-driven decisions in a regulated pharma environment.
Design and maintain Power BI dashboards that integrate data from Veeva CRM, SharePoint and Databricks, providing real-time visibility into sales trends, territory performance, and commercial KPIs across multiple markets.
Query and join multiple tables in Databricks using SQL to build clean, analysis-ready datasets, applying transformations such as filtering, aggregation, and window functions to prepare data for reporting.
Implement Power Automate flows to automate data refresh processes and trigger alerts for KPI thresholds, improving the timeliness and reliability of commercial analytics reporting.

Sep 2023 - Mar 2025

1 year 7 months

Working Student - Data Analyst

BASF

Designed and built 10+ Tableau dashboards visualizing supply chain KPIs, contributing to a 20% improvement in reporting turnaround time by replacing manual Excel-based processes.
Developed and maintained ETL pipelines to extract data from Salesforce CRM, SAP, relational databases, and flat files, transforming and loading it into a centralized reporting layer for Tableau consumption.
Wrote and optimized complex SQL queries and stored procedures in PostgreSQL, including multi-table joins, subqueries, and aggregations, to extract and reshape large datasets for analysis.
Defined and documented KPI frameworks in collaboration with business stakeholders, ensuring metric definitions were consistent across departments and clearly understood by non-technical users.

Oct 2020 - Aug 2022

1 year 11 months

Data Analyst

Provana

Analyzed product usage data using SQL and Python to uncover user behaviour patterns, feature adoption trends, and performance drivers, delivering insights that informed product roadmap priorities.
Designed and executed A/B tests end-to-end, including hypothesis definition, sample size estimation, metric selection, and statistical evaluation, to measure the impact of product changes on user engagement.
Used Google BigQuery to write complex SQL queries (joins, aggregations, window functions, CTEs) to transform and analyze large-scale datasets, supporting both recurring reports and ad hoc analysis requests.
Performed exploratory data analysis (EDA) in Python using Pandas, Matplotlib, and Seaborn to identify trends in user segmentation and surface feature adoption insights for the product team.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Chemical, Biotechnology, and Pharmaceutical.

Information Technology

Chemical

Biotechnology

Pharmaceutical

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, and Product Development.

Business Intelligence

Information Technology

Product Development

Summary

Detail-oriented data analyst with 3+ years of experience turning raw data into actionable insights. Proficient in SQL, Power BI, Tableau, Excel, and Python for data manipulation, visualization, and reporting.

Experienced working across pharma, chemical, and tech industries, collaborating closely with sales, operations, and finance teams to support data-driven decision-making.

Skills

Programming & Query Languages

Python (Pandas, Numpy)
Sql (Postgresql, Ms Sql, Mongodb, T-Sql)

Data & Cloud Platforms

Databricks
Snowflake
Bigquery
Microsoft Fabric
Aws
Azure
Gcp

Crm & Erp

Salesforce
Veeva Crm
Sap
Dynamics 365

Data Visualization & Bi

Power Bi
Tableau
Dax

Data Engineering

Dbt
Etl/Elt Pipelines
Data Modeling (Star Schemas)
Ci/Cd Pipelines
Database Management

Data Management

Ms Excel (Vba, Power Query)
Data Analysis
Statistical Analysis
Data Cleaning
Forecasting

Devops & Version Control

Azure Devops
Git
Jira

Ai Tools

Chatgpt
Claude
Copilot

Core Competencies

Analytical Thinking
Problem Solving
Strong Communication
Stakeholder Management

Languages

English

Advanced

German

Elementary

Education

Oct 2022 - Mar 2025

IU Internationale Hochschule

MBA · Big Data Management · Germany

Jun 2015 - Jul 2020

The NorthCap University

Bachelor's · Business Informatics · Gurugram, India

Statistics

Experience

Total positions 3

Experience in Information Technology 2 y

Avg length 1 y 3 m

Longest experience 1 y 10 m

Expertise

Recent roles Commercial Data and Analytics Intern, Working Student - Data Analyst, Data Analyst

Main industries Information Technology, Chemical, Biotechnology

Main business areas Business Intelligence, Information Technology, Product Development

Qualifications

Highest degree Master

Profile

Created

June 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Shubham based?

Shubham is based in Magdeburg, Germany.

What languages does Shubham speak?

Shubham speaks the following languages: English (Advanced), German (Elementary).

How many years of experience does Shubham have?

Shubham has at least 4 years of experience. During this time, Shubham has worked in at least 3 different roles and for 3 different companies. The average length of individual experience is 1 year and 3 months. Note that Shubham may not have shared all experience and actually has more experience.

What roles would Shubham be best suited for?

Based on recent experience, Shubham would be well-suited for roles such as: Commercial Data and Analytics Intern, Working Student - Data Analyst, Data Analyst.

What is Shubham's latest experience?

Shubham's most recent position is Commercial Data and Analytics Intern at Bavarian Nordic.

What companies has Shubham worked for in recent years?

In recent years, Shubham has worked for Bavarian Nordic, BASF, and Provana.

Which industries is Shubham most experienced in?

Shubham is most experienced in industries like Information Technology, Chemical, and Biotechnology. Shubham also has some experience in Pharmaceutical.

Which business areas is Shubham most experienced in?

Shubham is most experienced in business areas like Business Intelligence, Information Technology, and Product Development.

What is Shubham's education?

Shubham holds a Master in Big Data Management from IU Internationale Hochschule and a Bachelor in Business Informatics from The NorthCap University.

What is the availability of Shubham?

Shubham will be available full-time from August 2026.

What is the rate of Shubham?

Shubham's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.