Yash Pasad

About Yash Pasad

MDM DeveloperMDM Assessment & Implementation– Conducted comprehensive MDM assessments across the value chain to identify critical master data domains.– Successfully implemented an MDM Hub consolidating over 20 master data domains using SQL Server’s out-of the-boxservices (MDS, DQS, SSIS, SSRS).– This centralization improved data consistency and accessibility across the organization.Complex Masters Development– Developed complex master data solutions involving multiple data sources and complex hierarchies, significantlyenhancing financial reporting capabilities across the organization.Data Profiling & Business Rules– Leveraged the SSIS Data Profiling task to create eight comprehensive data profiles, enhancing data quality by analyzingindividual columns and exploring relationships between columns and tables.– Conducted manual data profiling using SQL scripts to generate business rules, ensuring data quality and compliance with organizational standards.Infrastructure & SQL Server Installation– Established and configured project environments (Dev, QA, UAT, Prod & Training) from the ground up, including determining appropriate sizing and creating network matrices.– Successfully installed SQL Server and implemented Availability Groups to ensure High Availability (HA) and Disaster Recovery (DR).– Executed comprehensive DBA tasks to maintain database integrity and optimize performance.SQL Developer-Agile Development (SCRUM) Environment– Worked within an Agile SCRUM framework, focusing on delivering software incrementally through sprint-by-sprintdeliveries. Leveraged JIRA for managing sprint tasks and tracking progress and used HP ALM for bug and issuereporting. Actively participated in sprint planning to define scope and goals, sprint reviews to assessprogress, retrospectives to identify improvement areas, and daily stand-ups for regular team updates.Designing and Implementing RDBMS Models– Designed and implemented relational database models according to business requirements, including defining tables,relationships, and constraints.ETL Processes Development and Maintenance– Developed and maintained SSIS packages to automate data extraction, transformation, and loading from varioussources. Debugged and upgraded ETL structures as needed.Performance Tuning– Conducted performance tuning by rebuilding indexes and tables to enhance database efficiency and performance.Reviewing and Implementing Business Procedure Changes– Analyzed existing business procedures, recommended improvements, and implemented changes to optimize operations.

Experience

1. Senior Associate

   PwC India

   Apr 2023 — Present · Mumbai, IN

Education

• K. J. Somaiya Institute of Technology

  Bachelor of Engineering, -

  2015 — 2019