• Work on various Financial Data analysis and issue validation work-streams as part of the Union Bank operations transition to US Bank.
• Analyze SQL code/processes that have been implemented to resolve various issues documented in various BRDs for multiple initiatives.
• Evaluate and implement appropriate risk-reducing controls/countermeasures to manage any issues and risks.
• Review and Coordinate with Stakeholders to understand their current processes and identify remediation/solutions for various Adverse Customer Impact incidents that are transitioned to US Bank.
• Assist with control testing activities, such as:
• testing approach and reviewing with various work-stream leads/managers.
• test of design and operating effectiveness of controls.
• and documenting testing results to process owners and work-stream leads/managers.

Responsible for building ETL towards implementing VDOT (Virginia Department of Transportation)' construction Datamart.
● • Lead Design and development of ETL Parallel and Sequencer jobs to process data from VDOT applications to their technical data zones such as Raw, Stage and ODS using IBM Datastage 11.7.
• Discuss with Stakeholders, review the BRD and document the requirements necessary to build ETL pipelines for Construction Datamart.
• Work with the team to design the data models ensuring the Tables structures are defined to include required keys, Database
relationship integrities are setup across the tables to be able to retrieve optimal results from the SQL queries.
• Define Best practices, standards, procedures and processes to facilitate optimized ETL development.
• Unit test and deploy the IBM Datastage jobs and workflows from DEV to other environments.
• Document Test plan and Test cases to perform Integration testing in the QA environment with the VDOT team.
• Work w

CRH is the primary customer centric application which is increasingly being used by business processes for credit decision, customer
segmentation & profiling, risk scoring, bankruptcy automation etc.
● • As a Product Manager/Owner manage personnel both on-site & offshore, plan and coordinate delivery of multiple data analytics initiatives catering to over 100 users.
• Developed User stories, Managed Product backlog and prioritized them based on changing requirements.
• Participated in Scrum meetings, Daily Standup calls, Backlog refinement and sprint retrospective sessions.
• Ensured the integrity and delivery of these CRH Data analytics initiatives with respect to resources, their bandwidth, forecasting their availability for future efforts, respect to time, SLAs, budgets for on-time and on-budget delivery, scope, change, risk and resources.
• Define Technology strategy and draft a 5-year road map to align with Business strategy.
• Lead and co-ordinate the execution of various

Responsible for leading ETL and Linux servers' architecture, Infrastructure design & Support activities and providing solutions to various Lines of Business such as, Consumer markets, Capital markets, Deposits, Card services, Global wealth & Investment mgmt., Full spectrum Lending & Home Loans
● • Provided ETL architectural and design solutions to various Lines of Business that are newly Onboarded to the ETL environments, with IBM Infosphere DataStage versions 9.1/11.3 and Informatica Power Center 9.6.1/10.1
• Managed End to End life cycle from Designing, Developing, Administering and Production support of various projects involving IBM Infosphere DataStage and Informatica.
• Lead and executed extensive POCs for multiple versions of IBM InfoSphere DataStage and Informatica that involved new builds and new environments setup.
• Lead and execute DR Exercises that involved the participation of various application teams. Prodded application teams to meet the deadlines and requirements

Responsible for providing IBM InfoSphere Datastage support and Design solutions to various Lines of Business.
● • Built New IBM InfoSphere Datastage 9.x Environments on Linux/zLinux that includes installation and Configuration of IIS, WAS, Fix Packs, LDAP, various database and setting up users. Applied upgrade patches, fix packs when and as required on the newly build environments.
• Onboarded application teams from IIS versions 8.1 to 9.1 Linux environments. Decommissioned applications from older versions.
• Execute DR Exercises that involved the participation of various application teams. Prodded application teams to meet the deadlines and requirements, with meetings and follow-ups to ensure a successful Execution.
• Mentored new resources in getting them up to speed with their day-to-day roles and responsibilities.
• Monitored and Maintained ETL Application servers using Geneos.
• Performed ETL code migrations across various environments using istools and iDeploy.
• Supported

Responsible for implementing several critical projects such as PeopleSoft ERP system implementation, PeopleSoft Enterprise Performance Module, General Ledger and Profitability Data mart, Account Payables Data mart, Budgeting Data mart, Management Reporting Application, Server to Parallel extender IBM InfoSphere Datastage ETL Jobs conversion, Mortgage and Insurance Reporting Data mart, Countrywide to Bank of America and Merrill lynch to Bank of America transition projects.
● • Extensively performed Requirements gathering, System analysis, and Design and Development of ETL solutions for various
projects.
• Interacted with Business users and Functional teams to develop Functional and Technical documentations required for several
projects, based on LLD.
• Designed Parallel jobs, Job Sequencers, Batch jobs and Server jobs, based on the technical specifications.
• Performed Performance Tuning of the DataStage Parallel jobs using Performance Statistics. This also involved interacting wi

Responsible for Business Objects and IBM InfoSphere Datastage Development activities for the PeopleSoft EPM implementation Project.
● • Developed Business Objects Drill down reports from PeopleSoft EPM for the implementation of Loan Level Prototype.
• Developed Datastage interfaces to facilitate the data movement from Legacy systems to PeopleSoft Financials (Oracle tables) using IBM InfoSphere Datastage.
• Performed Datastage upgrade from 7.5 to 7.5.2 environment. This included migration and stabilization of DataStage projects.
• Performed data analysis and design, and created and maintained large, complex logical and physical data models, and metadata
repositories using ERWIN.
• Troubleshooting and Performance tuning of various ETL processes.
• Involved in the coding and performance tuning of SQL statements.
• Helped QA team to understand Business requirements and coordinated with them in expediting the QA processes such as
Integration testing, Unit testing, performance testi