SUMMARY:

• Senior Programmer Analyst with Eleven years of experience in Credit Card, Health - care and Auto Insurance applications.
• Primary Technology skill set in Informatica Powercenter, Mainframes and MS SQL Server. Secondary skill set in Mid-range/Mainframe connectivity using Web-services in Service oriented architecture and Epiphany.
• Extensive experience in using Informatica Powercenter (Source Analyzer, Repository Manager, Workflow Manager, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Monitor) as ETL tool on various databases like SQL, DB2 and file systems like UNIX and Z/OS.
• Extensive experience in Mainframe Z/OS. Writing JCLs, COBOL-DB2, COBOL-IMS programs and DB2 Stored Procedures. Control M Batch Scheduling. Tools like ChangeMan, Spufi, Fileaid DB2, Fileaid IMS. MQ testing.
• Extensive experience in designing and creating Informatica Mappings, Mapplets, Sessions, Workflows.
• Expertise in creating informatica Control-M job scheduling and monitoring, PowerExchange datamaps and connection.
• Created and Executed Unix shell scripts to initiate batch informatica process and over-ride session and mapping parameters using parameters files and SQL table data.
• Expertise in writing SQL and DB2 stored procedure and queries, designing mainframe batch pre-processing for informatica.
• End-to-End execution and thorough understanding of Agile and Waterfall methodology in projects with Service oriented Architecture (SOA).
• Expertise in all forms of testing phases including Functional (Unit, SIT, UAT, Regression) and non-functional (Security, Performance), Manual and automated testing, preparing use-cases, aligning with business and development team, co-ordinating the testing timelines across the impacted teams.
• Experience in validating Collaborative apps like Donna, Cal/Any.do, Mobileday on Android and iPhone.
• Ability to drive issue resolution calls across multiple technical teams and business groups.
• Well experienced in uncovering, identifying, documenting and tracking issues and their root causes
• Experience in leading the team in Re-engineering and innovative initiatives by conducting brain-storming sessions.
• Good Knowledge of change management process, involving multiple systems; production deployment call management, change window monitoring, ticket status updating and resolution.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.x, Informatica Power Exchange 9.xOperating Systems: UNIX, Windows 7 enterprise, IOS, Andriod, Z/OS

Database: SQL Server,DB2

Database GUI Tools: SQL Server Management Studio, IBM Data studio, File-aid DB2, BMCADM

Programming Languages: SQL, UNIX, Shell Script, C, COBOL, JCL.

Scheduling Tool: Control-M

Project Management and Documentation Tools: Rally Project Management Tool, Microsoft Project Plan, Sharepoint, Clarity, Microsoft Office, Microsoft Visio, Tortoise SVN

Other Technology tools: Quality Centre (QC), Changeman, SPUFI, Putty

PROFESSIONAL EXPERIENCE:

Confidential, FL

Technical Lead

• Analyze the existing system and help business identify any gaps that conflicts with Fair Credit Reporting Act and other regulations.
• Create informatica mapping and workflow Design for ETL requirement.
• Lead the Mainframe team in building the source code in COBOL and testing online DB2 stored procedures.
• Involve in code reviews for the code built in COBOL, SQL and JCL.
• Design market independent reusable maplet that uses different kinds of expression transformations, Router, Union, Look-up, Normalizer, Sorter, joiner, filter, aggregator and access mainframe files as input and DB2 tables, XML file as target.
• Create data-maps using power-exchange to access mainframe files in informatica.
• Develop, bind and test Cobol-DB2 and Cobol IMS programs.
• Create Source qualifiers and Target definition for Flat-file, XML, CSV files and DB2, SQL tables.
• Schedule the Informatica job through control-M to run based on the schedule from business and establish mainframe-informatica process dependency.
• Create mapping documents to outline data flow from sources to targets.
• Maintain stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Develop mapping parameters and variables to support SQL override inside informatica workflow.
• Create workflow tasks like events raise, event wait, decision, e-mail, command, stop task.
• Create sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Write UNIX shell Scripts & PMCMD commands to trigger the desired informatica workflow from CTLM.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Execute the workflow and using Workflow monitor and analyze errors.
• Run the informatica workflow in de-bug mode to resolve errors.
• Work with the BIDW (informatica deployment team) to tag the changes and move the mapping/workflow/source/target from one environment to another and to production repository
• Participate in envisioning, sprint planning, user story grooming and giving story points through the tool Rally
• Create test cases in Quality Centre and execute them through test lab.
• Participate in technology transformation discussion to identify the best point-of-arrival technology for the existing system.
• Work with the Scrum team members for daily stand-up meeting and discuss impediments and updates.
• Work on Rally tool to update the user stories and sprint task progress.
• Monitor production incidents and debug and fix the tickets in the queue.

Confidential, FL

Technical Lead/QA Lead

• Participate in developing the Product Backlog with user stories alongside the Product Owner and Project Manager.
• Identified data source systems integration issues and proposing feasible integration solutions
• Created reusable Mailing alerts, events, Tasks, Sessions, reusable workletsand workflows in Workflow manager.
• Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
• Fix invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets and Workflows.
• Analysis of existing SQL stored procedures, JCLs and Cobol-DB2 programs and identify the modules that needs changes for the current requirement from business.
• Extract test data from DB2 and SQL tables and send to Data warehouse team and work with business to verify the daily reports generated.
• Build COBOL-DB2 programs and stored procedures and bind them to appropriate test regions. Use File-aid DB2 to execute adhoc queries and SPUFI for stored procedures and work with the middle-ware teams to get their build completed.
• Work on Informatica tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Create Use cases with exit conditions and work with business team and the development team to measure the probability, acceptability and dependency of mandatory test cases.
• Review the data-mapping and WSDL of Web-services and the back-end team.
• Review the GUI changes and suggest enhancements as per the Confidential standard.
• Verify connectivity with integrating system through Web services connectivity testing.
• Tag the changes and move the mapping/workflow/source/target from one environment to another and to production repository.
• Compare previous versions after deployment and monitor production execution of informatica jobs.

Confidential, FL

Technical Lead/Lead Programmer Analyst

• Work with the business partners to create the initial “impact request” statement and send it to all the systems in Confidential technology division, to receive an impact response.
• Prepare detailed design containing informatica mapping from source to target.
• Design aggregate functions like AVG, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Work on UNIX to Import parameter files into workflow manager.
• Work on session logs, Debugger, and Performance logs for error handling when we had workflows and session fails.
• Run JCL batch processing to extract data from SQL and DB2 table, send it to Data warehouse team and validate the reports with business team.
• Setup test JCLs for IMS and DB2 batch program through control M.
• Test NDM and SFTP file
• Created Data Flow Mappings to Extracted data from source system and Loading to staging area.
• Create Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Drive the Design meetings with the Informatica review team to ensure that the technical design is connected across the architecture and complete the end-to-end data mapping.
• Work with business team and use Epiphany to design and code the business rules.
• Work on share-point and clarity for project documentation and resource allocation.
• Change DB2 stored procedure for new columns added to the table and enhance for performance.
• Complete connectivity testing and make sure that integration with the back end systems is established.
• Co-ordinate a “Pilot” launch with the help of business team and ensure the project’s intended functionality is validated in Pilot server.
• Provide warranty support after implementation.

Confidential

Lead Developer/Analyst

• Detailed analysis of the requirements and provide the high-level technical changes needed to onshore team.
• Performed design of ETL components in this project. Creation of Design documents, Development and testing were my primary responsibilities.
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Created Mappings in Informatica Designer to extract data from Heterogeneous data sources like SQL, COBOL files, DB2, MS Access & Excel Sheets to load into the data warehouse with various types of transformations like Aggregator, Expression, Filter, Joiner, Lookup, External Procedure, Router & Update Strategy.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Tasks, Workflows and the Target Data.

Confidential

Lead Programmer Analyst

• Impact analysis of the system and reporting to the onshore point of contact.
• Gathering and analyzing the requirements.
• Responsible for analysis, preparation of Technical Design Document, Test Data and Test cases.
• Coding of the programs as per specifications sent from onshore point of contact.
• Unit testing and system testing of the components.
• Create Maps ad Mapsets in CICS and migrate to production.
• Configuration Controller of the team responsible for managing the Document integrity and the promotion of programs in the Client Mainframe region and maintaining the backups of all the components used in the project.
• Co-ordination with the onsite team members for requirement clarifications and issue resolution.

Confidential

Programmer Analyst

• Led the team in creating a “Stub-data” based testing approach that will not require engaging all the test support team in a complex technology system like Confidential . This saved the technology engagement cost for the teams that did not have any build impacts for any project. This approach saved around $700,000 for Confidential business annually in terms of technology costs.
• Led the team in Re-engineering initiative for Confidential by conducting brain-storming sessions.
• Awarded the TCS Gems certificate for providing a project estimate to business before the regular turn-around time.