EXPERIENCE SUMMARY

• Having over 10 years of experience in Mainframe Technologies, worked on entire Software Development life Cycle and has Team Leadership skills
• Strong experience in application development maintenance using SEI-CMM level 5 standards
• Implemented SOA on Mainframe by developing Service Layer programs, Presentation Layer programs and Messaging Copybooks
• Worked on Schedulers such as Jobtrac, TWS, ZEEKE, CA7 and CONTROL-M
• Worked on Configuration Management Tools like SCLM, Endevor, Changeman, Panvalet and PVCS
• Used APA(Application Performance Analyzer), Strobe for Performance analysis of Programs
• Was a Critical player in Application Upgrade of Sungard Omniplus 5.5 and LMD application used for Claims Team
• Experienced in using Omni script, a Scripting language from Sungard Business Systems
• Worked in Maintenance of Comp view, XICS, AFD and Meta File software used for Reports and Confirms Printing in Cobol Programs
• Experience of working with Databases like DB2, VSAM and IMS DB
• Extensively used Debugging tools like Expeditor, Fault Analyzer, Abend Aid, Omegamon and Dumpmaster
• Built Custom REXX Routines for the Project needs and to enhance productivity
• Worked on Programming Languages Easytrieve and DYL280 and worked on report generation using QMF
• Used SDF for Map Design involving Complex Screens and Developed Online Programs involving CICS, DB2
• Having experience in batch cycle development, Production support, SLA tracking, Escalations and contingency planning
• Made Extensive changes to MQ Series Programs
• Worked on Data Migration and Regression Testing using File-Aid, COMPAREX utility and REXX Screens
• Used BMC Tools to Load, Import and Copy Databases in DB2
• Involved in Server Consolidation, Changed FTP and NDM Parameters and worked on Service id Set up
• Has experience in Developing Stored Procedures
• Involved in Development and support of various Distributed applications

• Having good experience in Core Banking domain
• Worked for Defined Contributions and Policy Admin System, which takes care of 401K, 403B, 457, IRA and Annuity Processing. The application loads Daily feed of NAV AUV Prices of Mutual Funds and generates Trade files that provide total units to be bought or sold. The application also processes Feed from Brokerage Companies Ameritrade and Pershing that do Real Time Trading on Behalf of Customers.
• Worked for Home Loan Origination and Loan Processing Application
• Worked for Underwriting and Claims System
• Worked for Disbursement system for student loans

Masters in Computers

TECHNICAL SKILLS

Operating Systems

MVS OS-390, AIX for RS/6000, Windows Operating systems

Languages

Cobol, JCL, Easytrieve, DYL280, REXX, SQL

Databases

VSAM, DB2, and IMS DB

Special Software

CICS, MQ Series, Expeditor, Omegamon, File-Aid, File Manager, SYNCSORT, Abend-Aid, Endevor, SCLM, Changeman, TWS, ZEEKE, Jobtrac, Omniscript

PROJECT DETAILS

Client: Confidential,NY ,Lead Technical Analyst OCT/09 - Till date About the Project

Confidential, is the most widely deployed core banking System for HSBC with implementation in 53 countries. HUB is functionally rich, tightly integrated ‘bank in a box’. OHCB project aims at converting HUB into a Service Oriented application to meet One HSBC architecture. Developing various applications as part of Integration using HUB as base helps in adding extra functionalities aiming at latest business scenarios.

Roles, Responsibilities and Tasks:

• Involved in Development of CAMP application which stands for Customer Activity Monitoring and is used in Anti Money Laundering
• Worked on Development of Core Banking work stream Fees Interests. This involves development for Charge code and Fee Plan
• Developed Data Extract aggregator, used to generate multiple Interface files in a Single run using Global Extract Driver principles. This process reduces Batch cycle duration
• Document concepts used in OH Cards that uses principles from VisionPLUS, which is a Credit Card Processing Software. These concepts are used in development of Aggregator
• Involved in Data Modeling exercise to map AS/400 iseries files to DB2 tables. This also involves preparing Entity-Relationship model and documenting data mapping spreadsheets
• Analyze RPG programs that were developed in AS/400, prepare Specs and take care of Developing Cobol programs to meet the same functionality
• Prepare HLD and Functional Specifications document and get them approved by Architecture team
• Change SMPT and SMFT files to declare Transactions, Map transactions to Cobol programs similar to PCT entries, Register maps and Programs similar to PPT entries and Declaring valid PF keys for each map
• Carryout development for WSS/SSC changes to set up new application id. With the SOA architecture, all transactions will be grouped as Inquiry, Maintenance or Add transactions. Based on the transaction type and the application id, the xctl program will call appropriate driver program for a transaction
• Develop ESA Worksheets that will be ported to Mainframe and converted to message layer copybooks. Each business functionality will have request and response copybooks for Inquiry, Maintenance or Add process. These copybooks pass data between maps and service layer programs
• Carryout development to convert data stored in DB2 in UTF-8 format to EBCEDIC format. This is to store the special text characters entered on screen in DB2 tables
• Development of Cobol programs that handle scrolling logic on front end maps
• Used various CICS techniques like CEDF, CEBR , CEMT and Expeditor tool to verify the proper population of data and files

Environment: IBM OS-390, AS/400 iSeries operating system, Cobol, JCL, VSAM, DB2, CICS, MQ series, REXX, Expeditor, FILE Manager, Endevor and TWS

Roles, Responsibilities and Tasks:

• Application Upgrade from Omni 5.02 to Omni 5.5. This involved rigorous Development phase, Requirement walkthroughs and Issue fixes
• Scheduling of Batch Cycles in new test regions and monitoring Production and Test Cycles
• Preventive Maintenance to proactively analyze application programs and suggest improvements
• Worked on Batch Cycle Optimization activities. This is to reduce Batch cycle duration and meet SLAs with enough buffer
• Changes to run Critical Updates in the Batch Cycle in Concurrent mode and thereby reducing Batch Cycle execution time
• Data Migration Testing using Tools and custom Scripts. This was carried out as part of Omni 5.5 upgrade
• Supporting Distributed applications such as Plan Install, Charge tool, Omnicash Client reporting, Relius Government forms and Data Transfer Facility. This includes Issue resolution and enhancements to these applications.
• Application changes as part of Server consolidation exercise there by reducing the total number of Intel, UNIX, Novell servers maintained by ING USFS.
• Migration from Endevor to SCLM, ZEEKE to TWS for Infrastructure optimization and Cobol to MF Cobol for Linux upgrade of Omni environment
• Involved in VSAM to DB2 migration as part of Ultimate Statements project
• Developed Omni Script routines and carried out changes to VBA code
• Carried out Year-end support for the 5.02 as well as 5.5 versions of Omni successfully
• Involved in project for SSN Masking on confirms and reports
• Developed programs that send daily feed to ETL application
• Development of Ameritrade and Harris direct SDBO project
• Involved in Plan Install, Plan Discontinuance and ACES to Omni plan Migration for various 401k and 403b plans
• Discontinuance of 457 plan for Commonwealth of Massachusetts, CMA plan and ISP plan, which is 401k plan for ING employees and former Aetna employees
• Carry out Plan Re segmentation exercise to equally distribute data in VSAM database
• Changes to FTP Jobs so that the final files will be having Timestamp in their names and thereby store multiple versions and access the files based on index from Document Archive
• Development for File split and merge for ING and CITISTREET merger. All interface input files will be split to send copies to Mainframe Omni and Linux Omni based on Plan set up in either environment and the outbound files will be merged in similar manner.
• Schedule Quarterly cycles for NCOA change of Address received from USPS
• Worked on Auto enroll project for State of CT and San Fran plans
• Worked on Data Depersonalization project where Sensitive Customer information will be depersonalized before copying when data is copied from Production to Test regions
• Generation of 5500 reports for all Plans at the regular year end or at a specific date noted as Plan year end date

Environment: IBM OS 390, Windows NT/ 2000, Cobol, JCL, VBA, Crystal reports, VSAM, DB2, MS Access, Omni script, CICS, MQ series, REXX, Fault Analyzer, Expeditor, Omegamon, FILE AID, ENDEVOR, SCLM, TWS, Omni plus product from SunGard Business Systems

Modernized New Business System (MNBS) supports the Data capture and underwriting of Prudential individual life insurance products. MNBS focuses on Life Insurance applications and the information required for issuing new life Insurance business. MNBS Maintenance is a large enhancement, production support and Core maintenance project which was developed with the objective of reducing the maintenance cost of the then existing New Business System.

Roles, Responsibilities and Tasks:

• Involved in the Development of Universal Life to Variable Universal Life Conversion
• Add a new variable insurance product, SVUL-II. This also involves fixing pending high priority production problems, Incorporating requisite changes for stream unification
• Development of Special cycle for processing feed from various HMO systems
• Construction and Development as part of Bi-monthly Code releases. This also involves Carrying out Impact Analysis, Preparation of Tech Specs, Walkthrough of Tech Specs and Post implementation support.
• Member of Tech efficiency team that monitors various test environments and sets up Test environment for Code releases. Also involved in Periodic monitoring of Production region and Storage space
• Used IDCAMS utility to create /copy VSAM Files from production
• Development of Tools to avoid Production Issues and for Performance Improvements
• Document Best Practices and Lessons Learnt and prepare action Items based on these points
• Automated tool development to delete GDG versions exceeding three for a Dataset. This also involves altering existing GDGs. The tool is developed as part of Infrastructure optimization
• Involved in Enhancements of Feed from MNBS to Admin System Vantage-One

Environment: IBM OS 390, Windows NT/ 2000, COBOL, JCL, DB2, VSAM, CICS, Expeditor, FILE AID, CHANGEMAN, Jobtrac