Nitish Kumar Sah
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
1
1
Certification
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
06-2020
Higher Secondary -
The Central Modern School
04-2015
Primary -
The Central Modern School
04-2013
Skills
- SQL
- Power BI
- Python
Advanced Excel
Websites
Certification
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Azure DP-900
- Azure Data Factory for Data Engineers (Udemy)
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Bengali
Advanced (C1)
Personal Information
Hobbies and 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
Higher Secondary -
The Central Modern School
Primary -
The Central Modern School
Similar Profiles
Julian WalleJulian Walle
Technology Operations Manager at PwCTechnology Operations Manager at PwC
Gopika BesoonGopika Besoon
Senior Audit Associate 2 at PwCSenior Audit Associate 2 at PwC
Tareq Al-SaudiTareq Al-Saudi
Manager - Corporate Reporting Services at PwCManager - Corporate Reporting Services at PwC
Charlotte FolkardCharlotte Folkard
Litigated Recoveries Team Leader at PwCLitigated Recoveries Team Leader at PwC
Ratnadeep RoyRatnadeep Roy
Freelancer at Self-employed ServicesFreelancer at Self-employed Services