Radha Bhavani

Client : RaboBank Netherlands
The scope of the project is to perform day-to-day production deliveries smoothly.Played a key role in incident management, ensuring swift resolution and minimizing the impact on operations.Performed OPs(operations) of the day once a week. Troubleshoot CI/CD pipeline issues. Implemented and Monitored data flows in Azure Data Factory and maintained the IBM Tivoli system (ITWS). Performed data analysis and addressed data-related issues through troubleshooting. Supported on migration project from on premise to Azure cloud. Analyzed and mitigated Vulnerabilities from Windows and Linux servers. Provided support for transitioning from an on-premises environment to Azure cloud infrastructure. Used Azure DevOps boards for agile way of work. Troubleshooting issues with WhereScape RED versions 8.5.1 and 8.6.1 for ETL loads. Troubleshooting issues with Informatica PowerCenter for ETL daily data loads. Addressed issues in the CI/CD pipeline and performed troubleshooting. Coordinated with various teams to identify process bottlenecks and inefficiencies, implementing improvements that significantly enhanced operational productivity. Conducting an impact analysis for deployments and changes in the production environment. Initiating the deployment of changes in the production and acceptance environments. Automated manual tasks when and where possible. Performed Certificate renewals(SSL certificate renewal) for various servers. Making manual adjustments to scripts based on requirements. Conducted regular reviews and audits of operational processes, identifying areas for improvement and implementing necessary changes to enhance overall effectiveness. Managed user accounts, groups, and permissions and ensuring secure access in informatica admin console. Managed passwords for users in CyberArk, including addition and removal. Created necessary documents for and uploaded it in confluence.

Client : Deutsche Bank Germany | DBRex Project
Implemented business rules by designing and created data pipelines i.e., mappings by using various transformations including aggregator, expression, joiner, filter, sorter, union, sequence generator, connected and unconnected lookup, router with Informatica PowerCenter Designer. Performed deployments from development till production using Informatica Powercenter Repository. Responsible for installation and migration of code from Informatica PowerCenter 9 version to 10 version. Experience in writing advanced SQL queries, PL/SQL Stored Procedures, Functions and Packages. Data modeling: Extensive experience in dimensional modeling using star schema, with a focus on identifying facts and dimensions in the data warehouse. Led data warehouse migration projects, ensuring zero data loss and maintaining perfect system uptime. Monitor/Coordinate the deployment of data sets to. the data warehouse and deploy upgrades that makes business possible to have their Data requirements in place. Experience in creating Unix shell scripts and also scheduled them via Crontab. Actively participated in Informatica and Oracle code reviews and maintenance of the code check-in in the GIT. Performed unit and regression testing. Interaction with the business user to understand the requirements. Understand existing business model and customer requirements. Analysis of business requirement, preparing technical design documents (TDD) based on functional requirements (functional document). Experience in working with Slowly Changing Dimensions using Type 1 and Type 2. Created both reusable and non-reusable sessions and workflows using Informatica Workflow manager. Experience with version control concepts in Informatica PowerCenter. Responsible for Scheduling data pipelines using the Control-M according to business needs. Performed deployment activities in higher environments like UAT, Acceptance and Production.Responsible for preparing rollback steps/manual workaround for the production deployments.

Client : Deutsche Bank Germany | Cash and Collateral Management Project
Proficient in extracting, transforming, and loading data from heterogeneous source systems such as flat files (.csv ,.xls, etc.,) and Oracle databases using Informatica PowerCenter. Responsible for ETL data pipelines i.e., mapping, sessions, and workflows as per the requirement. PL/SQL: writing functions and codes based on client requirements. SQL: daily basic task of writing queries for the ETL requirements. Verified the runs and records on daily basis. Validated the data in target database after ETL daily process. Performance tuning of the Informatica mappings using various components like parameter files, variables, and dynamic cache. Monitoring and running the jobs/workflows for ETL daily and monthly process. Improved database performance through redesigning data models using SQL and normalization techniques. Managed data warehousing projects, ensuring proper data integration and storage. Experience in creating the Unix shell scripting based on the requirements. Analysis of business requirement, preparing technical design documents based on functional requirements. Interaction with the stakeholders to understand the requirements. Worked closely with the onsite team to understand the business requirements and applying the business rules to make them up to the Data Warehouse. Utilized a range of transformation components including filter, router, sorter, expression, aggregator, union, sequence generator, lookup, and joiner. Provided 3rd Line of support for Informatica code and schedules already in production. Created the staging area and loading raw data to cleanse it over there.Performed column data mapping between source & target database. Experience in creating the Reports using Actuate Reporting tool.

Client : Deutsche Bank Germany | DB Reconciliation Project
L2 Support & Incident Lifecycle Management. Handled Severity 1 and 2 incidents. Provided 24x7 support for production operations (incident fix, change/service request, project, and databases). Automation of daily manual task. Troubleshoot issues related to ETL load failures using Informatica session and workflow logs. Scheduled and Monitored jobs using Control-m. Monitored Production jobs/Workflows for ETL daily runs in production. Prepared SQL Queries. Involved in all kinds of production support activities including DR, Fail over, Incident management, etc. Hands-on in build and deployment activities. Involved in change management activities like providing estimates, etc.