SUMMARY:

• Experienced team lead, offering 12 years of exemplary performance across data warehousing projects for Finance, Electric, HealthCare - Insurance domain in various roles, platforms and processes.
• Have multidimensional technical skill set and capable of designing both tactical & strategic solutions as per business requirements using ETL Informatica, DB Procedures/Packages and Scripting as well as Scheduling tools like Autosys & Control-M.
• Strong hold on data warehousing concepts & dimensional modeling along with awareness of OLAP reporting tools-Business Objects XI R3 & Crystal Reports, Cognos
• Extensive exposure to Agile Methodologies, facilitated scrum ceremonies as Scrum Master.
• Flexible, resourceful self-motivated team lead as well as dedicated team player.

TECHNICAL SKILLS:

Primary Skills: Informatica Power Center 9.1/8.6.1/7.1.3

Secondary Skills: Business Objects XI R3, Crystal Report 2008

Scripting: Unix Shell scripting, Perl

Scheduling Tool: Autosys, Control-M, Espresso, Appworx

Process Management: Tortoise SVN, Confluence, Jira, Sharepoint, Peregrine, ITSM

RDBMS: Oracle, Sybase, Oracle Express Server, Teradata

O/S: Linux, Unix, MS Windows 95/98/NT/2000/XP

Tools: & Utilities: Erwin 4.x, Toad 8.x, Edit Plus, Notepad ++

PROFESSIONAL EXPERIENCE:

Confidential, Mason, OH

Production Support Lead

Responsibilities:

• Provided production support for eHUB Data Integration system which fetches data from flat files, legacy system as well as relational database.
• Created aggregate tables to improve the performance of reports and populated them with Informatica mappings.
• Modified existing Perl screen door process to validate the data quality for pre-staging load.
• Developed knowledge repository and transition process for support team.
• Maintained onsite - offshore team balance by having intra team periodic knowledge sharing sessions on processes.
• Actively participated in impact assessment reviews for Identifying Performance Improvement Scenarios & Bottlenecks.
• Interacted with Development team working on Agile Model, JIRA Request management, and deployment management.
• Implemented Run book process - Handover of application from deployment to support.
• Coordinated with Release management, QC, Application team during implementations for AD-HOC changes which are made with approvals.
• Developed a deep understanding of the business needs and strategic directions so that Business queries can be answered within agreed SLAs and can be pushed to Development team sprints as per priorities.
• Identified the scope of Automation to bring the Stability and Efficiency. Significantly reduced cost by implementing - Application/SLA monitoring using features of Control-M & UNIX Scripts.
• Held responsible for directing and managing work efforts on daily basis, identifying resource needs, performing quality review, and escalating - functional, quality, and timeline issues appropriately.
• Prioritized the work along with multi-tasking and understand the need of urgency.
• SPOC (Single point of contact) for major issues.

Environment: UNIX, Oracle, Informatica Power Center, Control-M, JIRA

Production Support Lead

Responsibilities:

• As a scrum master - Interacted with Development team, Product Owner & System Analysts to work with Agile Model, JIRA Request management, and deployment management.
• Held responsible for driving daily scrum calls, updating burndown charts during the spring. Identified resource needs & timeline issues appropriately.
• Conducted Sprint Review and Sprint Retrospectives efficiently in order continuous value add in Project Work.
• This role was shared developer/Scrum Master so coordinated with Release management, QC, Application team during implementations for AD-HOC changes which are made with approvals.
• Efficiently resolved issues with timely updates during major incident occurred post production.

Environment: UNIX, Oracle, Informatica Power Center, Control-M, JIRA

Production Support Lead

Responsibilities:

• Provided production support for Credit Risk Management system which fetches data from flat files, legacy system as well as relational database.
• Modified existing Perl screen door process to validate the data quality for pre-staging load.
• Actively participated in impact assessment reviews for Credit Risk application.
• Interacted with Development team working on Agile Model, JIRA Request management, and deployment management.
• Implemented Run book process - Handover of application from deployment to support.
• Coordinated with Release management, QC, Application team during implementations for AD-HOC changes which are made with approvals.
• Developed a deep understanding of the business needs and strategic directions so that Business queries can be answered within agreed SLAs and can be pushed to Development team sprints as per priorities.
• Identified the scope of Automation to bring the Stability and Efficiency. Significantly reduced cost by implementing - Application/SLA monitoring using features of Autosys & UNIX Scripts.
• Held responsible for directing and managing work efforts on daily basis, identifying resource needs, performing quality review, and escalating - functional, quality, and timeline issues appropriately.
• Prioritized the work along with multi-tasking and understand the need of urgency.
• Prioritized and engaged management in situations when prioritization was a challenge.
• SPOC (Single point of contact) for major issues.

Environment: UNIX, Oracle, Informatica Power Center, Autosys, JIRA

Onsite Coordinator

Responsibilities:

• Production support role involved service operation management, JIRA Request management, and deployment management along with coordination with offshore from work distribution perspective
• Prioritized the work along with multi-tasking and understand the need of urgency.
• Implemented Run book process - Handover of application from deployment to support.
• Written UNIX scripts to convert unstructured source files into structured delimilated files enabling the ETL Informatica to process the same without any issue.
• Developed knowledge repository and transition process for support team.
• Actively participated in design reviews for Equity application.
• Assess impact, coordinate, facilitate and test changes being made to the production environment.
• Identified the scope of Automation to bring the Stability and Efficiency. Significantly reduced cost by implementing - Application/SLA monitoring using features of Control-M & UNIX Scripts.

Environment: Unix,Oracle, Informatica Power Center, Control-M,JIRA

Offshore Team Lead

Responsibilities: -

• Coordinated with offshore activities in terms of requirement gathering, work distribution, code reviews in agile life cycle project.
• Used Informatica 8.6.1 to create mappings using transformations to move data to data Warehouse
• Create / enhance the control-M scheduling flows for the loads.
• Developed mapplets, mappings worklets and sessions for Informatica Loads.
• Created workflows, worklets and tasks using Informatica work flow Manager.
• Written & Modified UNIX Shell scripts & Perl scripts to support the critical operations.

Environment: Unix,Oracle, Informatica Power Center, Control-M,JIRA

Offshore Team Lead

Responsibilities:

• Solely responsible for completing Knowledge Transfer of various BI modules in short period of time.
• Analyzed existing mapping in Informatica, Reports in Business Objects & scripts in UNIX. Programming and provided quick fix as well as strategic solution to incidents.
• Studied entire SDLC in order to support the current projects as well as the ongoing developments.
• Took care of the production support activities and worked on both the offshore-onsite co-ordination activities in shift & weekends to daily night batches.
• Supported small Ad-Hoc changes in the Business Objects Reports with data analysis & co-ordination of development / testing with third party Vendor Resource.
• Made changes in the existing Autosys batches as per business needs.
• Troubleshoot and resolved complex incidents across different applications.
• Prioritized and resolved recurring problems & design the solution with lean approach for the same.
• Coordinated and performed Disaster Recovery test to meet the audit requirements.

Environment: UNIX, Oracle, Informatica Power Center, Expresso, JIRA

Application Developer

Responsibilities:

• Analyzed source system & designed control-m flows as per dependencies across the geographies.
• Developed new Informatica Mappings & enhanced the existing mappings.
• Unit testing & Integration testing of the mappings.
• Worked on Maintenance and enhancement of existing stored procedures.

Environment: UNIX, Oracle, Pl/Sql, Informatica Power Center

Application Developer

Responsibilities:

• Extract/Migrate data from multiple applications, Execute DML and DDL on the Oracle Tables.
• Analyzed source system & developed as well as made enhancement to Informatica Mappings
• Unit testing & Integration testing of the mappings.

Environment: UNIX, Oracle, Informatica Power Center

Application Developer

Responsibilities:

• Written Code and tested the screen door process in PERL.
• Created the mappings as per the business logic. Loaded data ETL using Informatica-7.1.3 tool.
• Made changes to the BO reports as per the user’s requirement.

Environment: UNIX, Perl, Oracle, Informatica Power Center, Business Objects 6.5