Shailesh Chaudhru=i

• Engineered and fine-tuned PL/SQL packages, procedures, functions, focusing on optimizing data retrieval and processing for enhanced analytical capabilities.
• Conducted detailed unit testing on SQL and PL/SQL code, analyzing data integrity and output accuracy to ensure reliability in subsequent analyses.
• Supported system testing and user acceptance testing (UAT), applying analytical techniques to validate data consistency and the functionality of reporting tools against business requirements.
• Designed and developed sophisticated back-office reporting solutions, such as transaction reporting and financial statements, using advanced data visualization tools to provide actionable insights to business stakeholders.
• Participated in a Scrum/Agile delivery team, employing data-driven strategies to prioritize tasks and manage multiple project timelines effectively in a fast-paced environment.
• Utilized enterprise job scheduling tools to automate data flows and implemented robust data monitoring and alerting systems to ensure high data quality and timely analytical reporting.
• Managed product delivery pipelines and maintained source control with GIT, emphasizing version control practices crucial for collaborative data analysis projects.
• Led the migration of data platforms from on-prem Informatica and Oracle to cloud-based solutions like AWS and Redshift, focusing on enhancing data scalability and accessibility for comprehensive analytics.

Interacting with business users, producing end to end design.
Development and Unit Testing of Informatica PowerCenter routines.
Development and Unit Testing of shell scripts.
Provide technical support during the SIT and UAT phases.
Prepare low level design documents and Deployment plans.
Deployments between development and test environments.
Upgrade Informatica PowerCenter 8.6.1 to PowerCenter 9.0.1.
Support and maintain existing PowerCenter code and Business Objects reports.
Creating Business Objects Universe.
Creating Documents and Reports in Business Objects.

Design, Develop PL/SQL packages, procedures, functions and Informatica mappings and workflows.
Unit testing of Developed code in Oracle and Informatica.
Supported System Testing and User Acceptance Testing (UAT).
Developed back-office reporting solutions such as Transaction Reporting and Statements.
Scrum /Agile delivery team, dealt with multiple priorities in a fast-paced environment.
Utilised enterprise job scheduling, data controls, monitoring, and alerting.
Built product delivery pipelines and maintained source control via GIT.
Helped migrate to Informatica, AWS and Redshift from on-prem Informatica and Oracle.
Later, helped migrate to Snowflake and DBT from Informatica and Oracle.

Extend the current Datawarehouse Banking Mart.
Design and Develop PowerCenter mappings and workflows.
Unit testing of Developed code.
Support System Testing and User Acceptance Testing (UAT).
Following change control processes with the defined SLA.
Code deployment to all environments except Prod using the automated code deployment strategy.
Code migration from on prem Informatica to IICS.

Code migration from on prem Informatica to IICS.
Interact with business teams & provide solutions for technical requirements.
Produce High level design.
Help with the preparation of low-level design and deployment plans.
Work with the developers and aid in development of code.
Provide technical & functional support during the SIT and UAT phase.
Co-ordinate communication between the technical, functional and business teams.

Design and Implement PowerCenter data load framework.
Design and Develop PowerCenter mappings and workflows.
Design and Develop Data Quality mappings and workflows.
Design application archival flows in ILM.
Build user access audit reporting using python.
Unit testing of Developed mappings, workflows, applications and shell scripts.
Supported the System Testing and User Acceptance Testing (UAT).
Planning for future upgrades to accommodate Grid and High Availability.
Following change control processes with the defined SLA.

Design and Build the Informatica Data Quality platform.
Design and Build reusable IDQ code templates.
Design and Build automated code review procedures in IDQ.
Design and Build IDQ batch scheduler (shell script).
Design and Build PowerCenter data load framework.
Design and Build QlikView dashboards for internal customers.
Design and Build Tableau dashboards for internal customers.
Outline development guidelines and standards.
Define the Strategic roadmap for the Data Quality program.

Contribute towards Data Quality process improvement.
Design and Develop Data Quality mappings and workflows.
Design and Develop PowerCenter mappings and workflows.
Unit testing of Developed mappings, workflows, applications, and shell scripts.
Design versioning and Code Deployment strategies across environments.
Define performance tuning strategies for the Data Quality Code.
Capacity planning for a scalable infrastructure to support 75 jurisdictions.
Planning for future upgrades to accommodate Grid and High Availability in Data Quality services.

Design and Improve Informatica shared platform & services including Informatica Metadata Manager 9.5, Informatica PowerCenter 9.1, Informatica PowerExchange 9.1, Informatica Data Quality (IDQ) 9.1 & 9.5, Informatica LifeCycle Management(ILM) 9.5.2, and Informatica B2B 9.1.
Improving maintenance of the Informatica environments to include build upgrades and capacity planning.
Implement Informatica Data Quality Services and make it available RBS wide.
Implement Grid Infrastructure and High Availability across a domain comprising of 18 nodes and 200+ services in total.
Performing root cause analysis and remediate issues appropriately.
Troubleshooting and problem solving of Informatica infrastructure configuration and performance issues.
Implementing changes using the RBS standard processes.
Producing documentation to aid the support of the Informatica environment.
Liaising with the appropriate development teams to optimise value to the business.
Supporting Development & Pre-Production Informatica environments.
Undertaking Informatica upgrades & patching.
Ongoing evaluation and analysis of the Informatica environments to provide optimum performance.
Testing of third-party software prior to release to the production environment.
Liaising with Global Business Intelligence and Database teams ensuring a consistent approach.
Following change control processes with SLA defined.
POC work on CDC for DB2 & Oracle.

Interacting with business users to understand the business requirement and transform them into high level design for the solution.
Development and Unit Testing of Informatica PowerCenter routines.
Development and Unit Testing of shell scripts.
Co-ordinate communication between the technical, functional and business teams.
Provide technical support during the SIT and UAT phase.
Prepare low level design documents and Deployment plans.
Deployments between development, test, and prod environments.
Installation of Informatica v9.0.1 on Exadata hardware.
Implement Grid and High Availability Infrastructure.
Informatica upgrade from v8.1.1 to 9.0.1.
Administration of Informatica v9.0.1 on Exadata hardware.
Support and maintain existing PowerCenter code.

Interaction with Telecom Operators from various countries to gather requirements and to produce High level design for the solution.
Development and Unit Testing of Informatica PowerCenter routines.
Development and Unit Testing of shell and PL/SQL scripts.
Co-ordinate communication between the technical, functional and business teams.
Provide technical support during the SIT and UAT phases.
Prepare low level design documents and Deployment plans.
Mentoring Junior team members and bringing them up to speed.