SUMMARY:

• Senior Software Developer with over 8 years of experience in Analysis, Design, Development, Testing & Production Support of systems in Informatica PowerCenter (ETL) & Mainframe.
• Experience in Banking & Retail Domain.
• Good Hands - on Experience in Onsite and Offshore model.
• Worked in every phase of Software Development Life Cycle process in a large enterprise environment.
• Strong Experience in System study, Impact analysis, Traceability Matrix, Technical design, Report generation and Post-Implementation support.
• Expertise in preparing technical specifications from Business requirements, creating Process flow diagrams, Architecture diagrams with all the existing systems/entities.
• Excellent problem-solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, have ability to meet tight deadlines and work under pressure.
• Strong experience in Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile-Scrum.
• Good knowledge in Data warehousing concepts.
• Expertise in Informatica Power Center ETL tool, Teradata & Unix.
• Developed complex Informatica mappings to load the data from various sources using different transformations like Source qualifier, Connected and Unconnected lookup, Update Strategy, Expression, Aggregator, Joiner, Filter, Normalizer, Rank and Router.
• Good knowledge in MicroStrategy BI Reporting tool.
• Expertise in COBOL, JCL, SQL, DB2, CList, REXX, TSO/ISPF, VSAM, CICS.
• Expertise in SPUFI, QMF, File-Aid, Change Man, Inertest, TWS and other IBM utilities as tools for Data manipulation and Code Management.
• Created Batch programs using COBOL, Stored Procedures, CICS Screens and JCLs.
• Worked on High priority issues during the installation of the Projects.
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6.1

RDBMS: Teradata 14.10, Oracle, DB2

BI / OLAP tools: MicroStrategy 9.4

Languages: SQL, UNIX Shell Programming, COBOL, JCL, Easytrieve, Command List (C-List), REXX

SQL Tools: Teradata Sql Assistant, SQL Developer, QMF, SPUFI

Schedulers: CA Workload Automation DE, UC4, ESP, TWS (Tivoli Workload Scheduler)

Version Control Tools: IBM Rational ClearCase, CMAN

Operating Systems: UNIX, IBM OS/390, Z/OS, MVS, MS-DOS, Microsoft WINDOWS

Debugging Tools: Informatica Debugger, INTERTEST

OLTP: CICS, CICS Transaction Server.

File Management Tool: File-Aid

Fault Management: Fault Analyzer

IBM Utilities: ISPF/PDF, TSO, DCLGEN, SDSF, IDCAMS, IEBCOMPR, IEBCOPY, IEBGENER, IEFBR14, SORT, DFSORT, SYNCSORT, IKJEFT01

Other Tools/Utilities: MS Word, MS Excel, MS PowerPoint, MS Access, MS Project

Defect/Ticket Tracking: Quality Center, Service Now

WORK EXPERIENCE:

Confidential, Jackson, MS

Informatica Developer/ Prod Support

Roles and responsibilities:

• Working as Informatica developer/Prod support to support all the modules of EDW.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Created Data Maps in Power Exchange Navigator for legacy mainframe sources.
• Reusable transformations and Mapplets are built wherever reusability is needed.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Used Teradata utilities like BTEQ, fast load, fast export, multiload for data conversion.
• Created UNIX scripts to perform operations to purge files.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Provided data to business on ad-hoc request by querying base and summary tables.
• Prepared the implementation plan and the post implementation validation docs.
• Conducted walkthroughs and documented and involved User Acceptance Test (UAT), provided training to user.

Confidential, New York

Senior Mainframe Programmer

Environment: MVS, z/Os, TSO, JCL, VSAM, DB2, IDMS, File-Manager, SPUFI, COBOL, CMAN, TWS, Quality Center, Informatica PowerCenter 9.5.1, Oracle, UNIX AIX, MS Office suite, Visual Studio.

Roles and responsibilities:

• Worked as Mainframe programmer to support all the modules of the National Registrations system and FA compensation.
• Created the Detail Design Documents based on the Functional requirements and Business Requirements.
• Coded the modules based on the Detail design documents to meet the functionality requirements.
• Designed and developed the Batch, Online programs and Stored Procedures using the COBOL Language.
• Prepared the unit test cases and created the test plan documents.
• Prepared the implementation plan and the post implementation validation docs.
• Worked on the production incident and provided the resolution to meet the SLA.
• Worked on defects that have aroused from testing phases using Quality Center.
• Involved in Unit, UAT & System testing and recording the results in the test results document.
• Reviewed the deliverables of junior team members and helped the new team members to settle into the team.
• Provided clarifications to the quality control team on the requirements and modifications done so as to facilitate their testing.
• Provided Implementation solutions/products and provided post implementation support whenever required.
• Involved in the Incident Management, Root Cause Analysis and High-Risk reviews.
• Participated in Application Development and peer code reviews on a day-to-day basis.
• Involved in the migration of legacy systems using ETL tool.
• Prepared design documents as part of migration project to carry out the tasks.

Confidential

Mainframe Developer /Prod Support

Environment: MVS, z/Os, TSO, JCL, VSAM, DB2, IDMS, File-Manager, SPUFI, COBOL, CMAN, TWS, Quality Center, MS Office suite, Visual Studio.

Roles and responsibilities:

• Worked as a Programmer to handle and maintain all the sub-modules of the Rewards system.
• Developed the error free, highly efficient code that complies with all code standards and methodologies.
• Developed new COBOL Batch and online programs that Retrieve and update details from the VSAM Files and Db2 tables.
• Defined and executed unit test cases based on the technical design/functional design in a way that is comprehensive and verifies accuracy of developed features.
• Supported the changes/applications post implementation by debugging, fixing, and participating in maintenance releases as needed.
• Performed production support activities by providing issue analysis and resolution within the specified SLA, depending on the severity of the issue.
• Ran the ad-hoc reports for the users to help them with the special projects and implementation.
• Provided Implementation solutions/products and provided post implementation support whenever required.
• Used share point to upload and organize the project documents.