Pratichi Singh
SQL & Power BI Developer | DAX • ETL • Oracle • PostgreSQL • ADF | Microsoft Certified PL-300 & DP-900 | PwC India
Delhi
7+ years of work experience
Jul 20233 yrs 1 moPresent
Noida
At PwC India, I develop and deliver data and BI solutions for Banking and
Financial Services clients — spanning Power BI dashboards, ETL pipelines,
database development, and workflow automation.
Key Contributions:
▸ Designed and developed Power BI reports and dashboards using advanced DAX
(aggregate, date, logical, string, and table calculations) and Power Query
for data cleaning and transformation, enabling self-service analytics for
business stakeholders.
▸ Validated data accuracy and report integrity across Power BI solutions
through systematic testing and reconciliation against source systems,
ensuring trustworthy reporting outputs.
▸ Implemented Row Level Security (RLS) by defining role-based constraints
within Power BI, ensuring data access governance and compliance across
client dashboards.
▸ Developed and optimized complex SQL and PL/SQL queries using joins,
subqueries, CTEs, and analytical/window functions across Oracle 21c,
PostgreSQL, and MS SQL Server to support reporting and business decisions.
▸ Designed and implemented end-to-end ETL pipelines using SSIS and Azure
Data Factory (ADF) for large-scale data extraction, transformation,
validation, and loading across structured and semi-structured sources.
▸ Executed data migration from legacy banking systems to Oracle 21c and
PostgreSQL, implementing delta sync logic and validation scripts to ensure
100% data accuracy and referential integrity post-migration.
▸ Optimized database and report performance through query tuning, indexing
strategies, execution plan analysis, and bulk processing, reducing average query response times.
▸ Automated 10+ recurring reporting and business processes using DBMS
Scheduler and Power Automate, significantly reducing manual effort and
improving operational efficiency across client environments.
Tech Stack: Power BI | DAX | Power Query | Oracle 21c | PostgreSQL | MS SQL
Server | PL/SQL | SSIS | Azure Data Factory | Python | Power Automate
May 20194 yrs 1 moMay 2023
Odisha, India
B.Tech in Computer Science & Communication Engineering, CGPA: 8.65
Jan 20224 mosApr 2022
Technology internship at EPIKInDiFi, a fintech-focused organization,
gaining early hands-on exposure to data and technology workflows.
▸ Assisted in data collection, cleaning, and basic analysis tasks
supporting the technology team.
▸ Developed foundational skills in SQL and data handling in a
professional environment.
▸ Gained exposure to fintech data workflows and business processes.
Sep 20211 moSep 2021
Short-term data analytics internship with KPMG India, gaining exposure
to how a Big 4 professional services firm approaches data analysis,
reporting, and client delivery.
▸ Gained foundational exposure to data analysis workflows and reporting
practices in a professional services environment.
▸ Developed understanding of structured problem-solving and data-driven
decision-making frameworks used in client engagements.
▸ Built early familiarity with Excel-based analysis and data presentation
for business stakeholders.
Education
B.Tech, Computer Science and Communication Engineering
Kalinga Institute of Industrial Technology, Bhubaneswar
20194 yrs2023
Class 11-12, CBSE
Sri Chaitanya College of Education
20172 yrs2019
Join Pratichi and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal Boss