👋 Available for opportunities

Nitin Kumar
Sharma

Turning complex data into clear decisions — with SQL, Python, and Power BI. 2+ years building dashboards at Bajaj Allianz and Medianama that actually get used.

View My Work Get In Touch

LinkedIn GitHub Email

SCROLL

// about me

The person behind the data

I'm a Data Analyst based in Delhi, India, with 1.5+ years of hands-on experience in SQL, Python, and Power BI. I don't just build dashboards — I build dashboards that people actually open every morning.

At Medianama, I automated reporting pipelines that cut manual work by 40%, turning data from 5+ sources into clean, consistent insights through star schemas and real-time Power BI reports.

Currently pursuing my MBA in Finance from the University of Delhi, blending analytical thinking with business context to bridge the gap between raw numbers and strategic decisions.

Years of Experience

40%

Manual Work Reduced

Data Sources Integrated

DB Tables Normalized

// skills

What I work with

Programming & Analytics

SQL92%

Python (Pandas, NumPy)80%

Data Modeling & ETL85%

Statistics75%

Visualization & Databases

Power BI88%

Excel & Dashboards90%

PostgreSQL83%

MySQL78%

Tools & Collaboration

Apache Airflow dbt-core Databricks Git & GitHub Google Workspace Slack Discord Star Schema Data Transformation

// experience

Where I've made impact

Data Analyst Jun 2024 – Feb 2025

Medianama · Delhi, India

Built Excel dashboards to visualize company performance metrics, directly supporting the editorial team in producing data-driven business articles.
Developed and maintained Power BI dashboards for real-time stakeholder reporting, reducing manual workload by approximately 40%.
Extracted data from 5+ sources, performed cleaning and transformation, designed a star schema in PostgreSQL, and connected it to Power BI — improving both consistency and reporting speed.

Data Analyst Intern May 2023 – Jan 2024

Bajaj Allianz General Insurance · Full-time Internship

Built an automated Power BI dashboard for senior financial leadership, enabling detailed analysis of customer insurance policies and cutting manual reporting time by 25%.
Leveraged PostgreSQL for data cleaning and transformation, and designed fact-dimension data models to support automated, scalable Power BI reporting.
Analyzed 15+ insurance products (SWT, ULIP, E-Touch II, AWG Platinum, etc.) and built monthly reporting pipelines in PostgreSQL.
Enabled sales win-back strategies through data insights, improving conversion rates and contributing to revenue growth.

// projects

Things I've built

🏗️

Databricks Medallion Warehouse

Architected a production-ready data warehouse on Databricks using the Medallion architecture (Bronze → Silver → Gold). Orchestrated automated pipelines with Apache Airflow and dbt-core across tiered layers for streamlined data processing.

🚲

Bike Store Relational Database

Transformed unstructured flat data into a fully normalized relational schema across 9 PostgreSQL tables. Improved data consistency, eliminated redundancy, and enabled complex analytical queries across the store's operational data.