SUMMARY

• 10+ Years of IT experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications inBanking and Insuranceindustries.
• 8 years of experience in Informatica production support projects. 4 years of experience in leading the data warehousing support projects, providing ETL best practices, training and mentoring the team members.
• Specialist in supporting large EDW Production environments. Involving activities such as identifying technical debts, working with LOB on setting up OLA/SLA, driving daily triage meetings, Incident management, change management, Release management, System health check tracking, maintaining CPU utilization, File System space and Table space.
• Strong knowledge on Change, Incident, Problem and Release management.
• Experienced in designing data validation rules, error handling concepts, test scenarios write up, Debugging skills and Performance Tuning.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Metadata Manager), Power Exchange as ETL tool on Netezza, Oracle, DB2 and SQL Server Databases.
• Experience inUNIX shell scriptingto perform a data load.
• Experienced in all phases of System Development Life Cycle (SDLC) such as strategy analyzing, designing, coding, testing, support and documentation of software products.
• Strong experience in the scheduling tool CA workstation.
• Strong Experience onWorkflow Manager Tools - Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows.
• Extensive use of Informatica Debugging in mappings and used Session Log File to trace the errors when loading into targets.
• Excellent analytical skills, oral and written communication skills. And a self-motivated team player with excellent problem-solving skills and ability to quickly learn new technologies and tools.
• Identified Technical debts, documenting the RCA and estimating the effort of addressing the debts.
• Designed a dashboard reporting framework using Informatica PC, Visual Basic and Tableau, to track the OLA/SLA misses by application & category, Param file value changes, long running Informatica jobs and Netezza sequence value growth, Table size growth (sudden spikes), Data Validation metrics and Job Failure Incident metrics by category. This Dashboard is being reported to the Management through the Tableau reporting tool.
• Lead the Triage meetings, Incident management, Release Management, reviewing and approving the hand over documents, ensuring the implementation tracker to be up to date.
• Documenting the Risk and Defects. Coming up with the mitigation plan and severity of the defects. Identifying the impact to the business.
• Negotiated with the business and project managers on the OLA and SLA, based on the existing application capacity. Worked with the DA and Development team in setting up the load start time and estimating the SLA.
• Ensuring the ETL Standards and security policies are met. Handling the Document repository, approving the version control requests.
• Involved in Performance tuning of sessions, mappings, ETL procedures, processes for better performance and support integration testing.

TECHNICAL SKILLS

ETL Technologies: Informatica Power Center 10.4.0/10.2.0/10.1.1/9.6 , Power Exchange.

Databases: Netezza, DB2 and Oracle.

Database Tools: Aginity, IBM Data Studio, TOAD and Control Center.

Scheduling Tools: ESP and Control-M.

Operating Systems: UNIX and Windows.

Languages: SQL.

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

Production Support Lead/Specialist (L2/L3)

Responsibilities:

• Manage and collaborate with a team of 10 to maintain production applications where we maintain 10k jobs for Truist Bank.
• Involved in performing regular system audits to ensure accuracy of the various environments and applications along with monitoring Autosys batch processes and performing troubleshooting using Power center logs, UNIX scripts and Database SQL processes.
• Identified Technical debts, documenting the RCA and estimating the effort of addressing the debts.
• Designed a dashboard reporting framework using Informatica PC, Visual Basic and Tableau, to track the OLA/SLA misses by application & category, Param file value changes, long running Informatica jobs and Netezza sequence value growth, Table size growth (sudden spikes), Data Validation metrics and Job Failure Incident metrics by category. This Dashboard is being reported to the Management through the Tableau reporting tool.
• Worked with the INFA admins and the DBA in periodically tracking the file system space usage and ensuring the load on the system is distributed.
• Involved in the design discussions with the architects and the development, to estimate the impact to existing applications. Providing sign-off for the designs and the code to be implemented in Production.
• As part of tuning, I reviewed the Cache size, memory allocation percentage based on the RAM usage and DTM buffer size. Analyzed the Joining strategies, CDC requirements and Write thread types.
• Lead the Triage meetings, Incident management, Release Management, reviewing and approving the hand over documents, ensuring the implementation tracker to be up to date.
• Documenting the Risk and Defects. Coming up with the mitigation plan and severity of the defects. Identifying the impact to the business.
• Negotiated with the business and project managers on the OLA and SLA, based on the existing application capacity. Worked with the DA and Development team in setting up the load start time and estimating the SLA.
• Ensuring the ETL Standards and security policies are met. Handling the Document repository, approving the version control requests.
• Involved in Performance tuning of sessions, mappings, ETL procedures, processes for better performance and support integration testing.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and resolving the issues as part of production support.
• Performed debugging by checking the errors in the mapping using Debugger utility of the Designer tool and made appropriate changes to generate the required results.
• Documenting the resolution for known issues and responsible for updating and maintaining the same in the SharePoint.
• Handling Federal and Internal audits along with the Senior Management. Taking responsibility for addressing the Audit findings and coming up with a mitigation plan.
• Tracked the Infrastructure related issues by categories, arranging calls with the Technical support teams and reported the status to the management team.
• Lead the Infrastructure related bridge calls, coordinate and lead the bridge calls during On-Call Support issues.
• Performing Code review and support during the deployment.
• Remain calm under pressure and ensure IT management and business stakeholders are kept fully updated on progress of critical issues.
• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.
• Escalate issues and remediation steps effectively and in a timely manner.

Confidential

ETL Developer/Production Support

Responsibilities:

• Designed high level design and developed ETL mappings to migrate the data.
• Examining the Requirements provided by the Clients, preparing the Design Documents and the Test Cases for the Interfaces that are to be developed based on the requirements.
• Creating Mappings/Mapplets, Sessions, Workflows/Worklets, UNIX and BATCH scripts for the various business and design requirements.
• Preparing Unit Test Plan Document, Unit Testing Document, SIT plan Document, System Integration Testing and confirming all requirements within a narrow deadline. Providing UAT support.
• Writing SQL queries for System integration testing and verification of production data.
• Perform peer review for the Informatica code and validate design standards and performance issues.
• Monitoring the production jobs and resolving production failures within the stipulated time frame.
• Optimizing the Mappings, Sessions, Workflows and SQL Queries to improve the load performance.
• Migrating Informatica objects from one environment to another environment.