PROFESSIONAL SUMMARY:

• 10+ years of professional IT experience in ETL Data warehousing technologies (Informatica, Datastage Ascential, Microstrategy tools).
• Also worked on IBM mainframes platform, which involves Development, Enhancement and Maintenance of Application software using COBOL, DB2, JCL, VSAM and CICS.
• Excellent expertise in Analysis, Design, Development, Testing, Implementation and Maintenance of Data Warehousing, BI and Reporting using Datastage, Informatica 8.5, Informatica 9.1, and Microstrategy tools on Healthcare, Financial Banking and Retail domains.
• Excellent expertise in Analysis, Design, Development, Testing, Implementation and Maintenance of Mainframe platform (COBOL, JCL, FOCUS, EXPEDITOR, SDSF, FILE - AID, CA-7, OS/390, TSO/ISPF, SPUFI, DB2V8.0, PERIGRINE VERSION CONTROL SYSTEM) on Retail domain.
• Extensive experience in Business Analysis, System Design, Development, Testing, Implementation, Maintenance, and Quality assurance as Developer, and Project Lead.
• Hands on experience on all the ETL tools - Microstrategy, Datastage, Informatica (Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager), Control-M, Tivoli etc.
• Excellent expertise in FOCUS language.
• Well experienced in 24x7 and On-Call Production Support for most critical applications.
• Excellent exposure in Onsite and Offshore Coordination, Programs, Defect Prevention, Documentation, Process change management.
• Expertise in developing, testing, and maintaining mission-critical applications in various functional areas like Healthcare, Financial Banking, Reinsurance and Retail systems.
• Involved in System Performance Monitoring, Tuning and Testing/Quality related activities
• Proficient in writing Test Plans, Test Scenarios, Test Cases and documentation of test results.
• Proposed various suggestions to improve system performance and reduce manual intervention.
• Expertise in handling production issues and providing faster recovery solution. Got several Appreciations from Hallmark, Target, Ameriprise, and Anthem Project Managers/Clients.
• Good experience in Relational databases and SQL queries.
• Involved in preparation of Daily, Weekly Status Reports as a team lead at Offshore and Onsite.
• Involved in all phases of SDLC cycle which includes High level and Low level design, Coding, Unit Testing, System testing, Installation, Maintenance, Enhancements, Performance improvement.
• Involved in Quality related activities such as Code Walkthrough, IQA and Final Inspection.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Very good knowledge on SDLC, Quality procedures, Defect Management, Process Management, Improvement methodologies, Software processes & Standards.
• Ability to work both independently as well as with a team. Have led a team of 6 or more people on multiple instances to deliver projects successfully & on time.

TECHNICAL SKILLS:

ETL Tools & Utilities Informatica: Power Center 9.X/8.X, Power Exchange 9.X/8.X, Ascential Datastage 7.5.1A, Microstrategy, SDSF, FILE - AID, CA-7, TSO/ISPF, SPUFI, PERIGRINE VERSION CONTROL SYSTEM, ABEND AID, Peregrine Service Center, Teradata SQL Assistant 7.2

Data Modeling Tools: Data Mart, Dimensional, Snow Flake, Star Schema, Microsoft Visio

Databases: DB2, Relational Databases, IMS, Teradata, VSAM

Operating Systems: OS/390, Windows XP, Windows Vista, Z/OS

Languages: COBOL, JCL, SQL, CICS, UNIX and FOCUS

J ob Scheduling Tools: CONTROL-M, Tivoli Workload Scheduler, Mainframe CA7

Reporting Tools: MICROSTRATEGY, FOCUS Domain Knowledge Healthcare, Retail, Financial Banking, Reinsurance.

PROFESSIONAL EXPERIENCE:

Confidential, Wallingford, CT

Informatica - Tech Lead

Responsibilities:

• Primary Point of contact for Benefits and Blue Exchange (BnB) Applications. Coordinating with several internal/external vendors to ensure smooth maintenance of 270/271 EDI transactions.
• Resolving the production issues in ACES BnB System within the SLA as per the priority of the issue.
• Working on Projects & SSCRs (Small System Change Requests) and deploy the changes in the scheduled monthly releases. Follow the Release Management timelines strictly to complete each phase of the SDLC.
• Participating in the business meetings to understand the business/functional requirements of the Projects & SSCRs (Small System Change Requests) and convert them into Technical requirements.
• Coordinating with Offshore team to ensure they understand the requirements and complete the changes as per the timelines of the Release Management.
• Facilitating the weekly status meetings on Projects & SSCRs with the client to track the status & resolve any issues.
• Working on the Lights on tickets assigned in Clear quest as per the SLA to help the users complete the renewals & other activities on the of the end customers.

Environment: Informatica Power Center 9.1, Informatica Data Quality, DB2, Teradata, UNIX, XML, Power Exchange, Control-M

Confidential, Stamford, CT

Onsite Tech Lead

Responsibilities:

• Requirement gathering by working with Business analysts, Project architects, Data architects.
• Designing the project in Informatica ETL tool considering Performance, Error handling, data quality and security.
• ETL design, code, document reviews
• Data Profiling
• Bug fixing
• Coordinating testing with vendor partners
• Implementation Planning, Deployment & Production Batch Monitoring
• Coordinating with Business users for UAT
• End user documentation and Post Production Support Activities.

Environment: Informatica Power Center 9.1, DB2, UNIX, XML, Power Exchange, Control-M, Autosys.

Confidential, Minneapolis

Sr. Informatica Developer

Responsibilities:

• Requirement gathering by working with Business analysts, Project architects, Data architects.
• Designing the project in Informatica ETL tool considering Performance, Error handling, data quality and security.
• ETL design, code, document reviews
• Data Profiling and Bug Fixing.
• Coordinating testing (System Integration and Business Testing) with vendor partners
• Implementation Planning, Deployment & Production Batch Monitoring
• Working with relational databases and analyzing/enhancing SQL queries.
• Providing Status reports to Onsite Manager and Offshore Manager in weekly basis.
• Lead a team of 8 members at Offshore.
• Creating and performing Unit test plan.
• Deploying the software in Quality region.
• End user Documentation of the changes and Post Production Support.

Environment: Informatica Power Center 9.1, Oracle, UNIX, XML, Flat files, VSAM, Power Exchange, Control-M and Tivoli Workload Scheduler.

Confidential, Kansas, USA

Informatica Developer

Responsibilities:

• Providing On call Support for the application at Onsite.
• Developing/Enhancing COBOL, DB2, FOCUS and CICS programs.
• Logging the production issue in Service Center and providing recovery solution within the SLA.
• Providing permanent fix for production issues whenever required.
• Coordinating with Offshore team of 6 members and guiding them in production issues’ resolution.
• Involving in enhancement activities in the application which involves modification of existing COBOL programs or developing new programs.
• Creating Unit test plans and logs.
• Participating in daily status calls with Client Managers and explaining the production issues and its recovery solution.
• Coordinating with SQA and UAT teams (Quality teams) regarding the software developed and deployed.
• Post implementation support.

Environment: Informatica Power Center 9.1, Microstartegy 8.1.0, Ascental Datastage Tool 7.5.1A, IBM OS 390 MVS / TSO ISPF, JCL, CICS, FILE-AID, CA-7, FOCUS, DB2,Teradata SQL Assistant 7.2, Service Center.

Confidential, Minneapolis

Software Developer

Responsibilities:

• Data Profiling, Analysis and Design, Coding, Unit Testing, Integration Testing.
• Involve in Internal and External Reviews.
• Production Implementation
• 24/7 Control-M Support after the production move.
• Writing SQL statements/queries or enhancing the existing complex SQL statements for performance tuning.
• Participate in Tele cons & Team Meeting. Maintain project status between offshore and onsite.
• Post Implementation Support
• Providing data for other application teams for Product Testing.

Environment: Ascential Data Stage Tool 7.5.1A, Teradata SQL Assistant 7.2, Citrix, DB2, UNIX, Test Director, CONTROL-M