Summary
Overview
Work History
Education
Skills
Websites
Certification
Interests
Timeline
Generic

Nitish Kumar Sah

Data Analyst
Kolkata

Summary

Highly motivated Data Analyst with 3.7 years of experience in data analytics, business intelligence, and data warehousing. Proven expertise in SQL, Microsoft Power BI, and ETL processes. Strong track record of delivering actionable business insights. Dedicated professional with a knack for delivering optimal results under pressure. Optimistic and flexible team player seeking new challenges in a dynamic, growth-oriented environment.

Overview

4
4
years of professional experience
2020
2020
years of post-secondary education
3
3
Certifications
3
3
Languages

Work History

Associate, Data Analyst

PwC
10.2024 - 03.2025
  • Advanced Query Development: Developed and executed SQL queries to analyse transactional data, identifying potential risks and irregularities.
  • Conducted journal testing using SQL in Halo for Journals to detect anomalies and ensure compliance with audit standards.
  • Query Optimization: Optimized SQL queries to improve performance and reduce execution time for large-scale data operations.
  • Manage end-to-end ETL processes ensuring data quality and integrity.
  • Documented testing procedures, findings, and insights, enhancing audit efficiency and transparency.
  • Enhanced data accuracy by conducting thorough data validation and cleaning processes.
  • Collaborate with stakeholders to understand business needs and design effective data solutions.
  • Present analytical findings and actionable insights to support strategic decision-making.
  • Ensured compliance with all applicable privacy laws and regulations while handling confidential customer information during analysis projects.

Data Analyst / Project Engineer - Data Analytics Engineer for Lululemon

Tech Mahindra
08.2021 - 03.2024


  • Develop and maintain interactive dashboards using Microsoft Power BI to deliver real-time business insights.
  • Data Cleaning & Validation: Skilled in using SQL for data cleansing, validation, and ensuring data quality throughout the ETL process.
  • Collaborated with various teams and management to align data solutions with business objectives.
  • Integrated multiple data sources (CSV, DAT, JSON, Azure SQL Database, Azure Databricks, Azure Data Lake Storage Gen 2) via Power BI.
  • Employed both Import and Direct Query modes to build complex datasets.
  • Executed extensive ETL activities using Power Query, including filtering, merging, appending, pivoting, and unpivoting data.
  • Designed and implemented data models using Power Pivot with star and snowflake schema techniques.
  • Developed calculated columns and measures using DAX functions (text, number, statistical, logical, time intelligence).
  • Created dynamic visualizations (stacked column, line, area, waterfall charts, and more) and managed filter hierarchies with drill-down capabilities.
  • Implemented Row Level Security (RLS) to ensure secure and compliant data access.
  • Performed rigorous SQL-based testing to validate data accuracy and consistency.

Education

Bachelor of Technology - Electrical Engineering

RCC Institute Of Information Technology
Kolkata, India
05.2016 - 06.2020

Higher Secondary -

The Central Modern School
Kolkata, India
04.2013 - 04.2015

Primary -

The Central Modern School
04-2013

Skills

  • SQL

  • Power BI

  • Python

Advanced Excel

Certification

Microsoft Certified: Power BI Data Analyst Associate

Interests

Football
Cooking
Swimming
Travelling
Music

Timeline

Associate, Data Analyst

PwC
10.2024 - 03.2025

Data Analyst / Project Engineer - Data Analytics Engineer for Lululemon

Tech Mahindra
08.2021 - 03.2024

Bachelor of Technology - Electrical Engineering

RCC Institute Of Information Technology
05.2016 - 06.2020

Higher Secondary -

The Central Modern School
04.2013 - 04.2015

Primary -

The Central Modern School
Nitish Kumar SahData Analyst