SUMMARY:

• Confidential is an IT consultant with more than Nineteen years dedicated to data processing on IBM Mainframe based systems. He is proficient in Mainframe Application Design, Development, Maintenance, Testing and Production Support.
• He specializes in JCL, VSAM, DB2, SQL, CICS, COBOL and Easytrieve.
• He is skillful in database design and data modeling and has good knowledge of database concepts and SQL programming. He has good experience in retail, banking and Healthcare services industry business processes.
• He has good skills in requirements gathering and impact analysis methodologies.
• He is very good at onsite and offshore coordination and is well suited for technical and project management roles. He has good knowledge of SDLC/PLC processes and is well experienced in handling projects in both waterfall and agile methodologies. He is Scrum Master Certified. He is well experienced in Unit, Functional and Integration Testing.

TECHNICAL SKILLS:

Technologies: IBM Mainframe, Unix, WebJavaTools: Cobol, CICS, JCL, SQL, Easytrieve, Focus, Perl, Shell, REXX, CLIST, DB2 Stored procedures/subroutines, SAS, Hogan - CIS, SOAP-UI, XML, Web Services, SDF, File-Aid/RDX, Xpeditor, Spufi, QMF, Platinum, Connect-direct, CA-Scheduler, CA-7, CA-JobTrac, Changeman, Endevor, Panvalet, CA-InterTest, SAR, Remedy, NDM, FTP/SFTP, Syncsort, IBM WebSphere MQ Series, EDI, X12, 834, Scrum, Visio, Access, Excel, Word, PowerPoint, Agile, HP Quality Center/ALM

Databases: DB2, IMS DB, Informix, Oracle, MS-SQL

PROFESSIONAL EXPERIENCE:

Confidential

Senior Developer and Tech lead

Responsibilities:

• Understand the development and testing effort by analyzing the requirements of project.
• Define the Strategy for development and testing
• Prepare logical and physical design documents
• Perform impact analysis for any change or addition of functionalities to existing system
• Development and unit testing of IBM Mainframe applications
• Modification of existing programs and development of new programs
• Create detailed program specifications
• Keep track of the new requirements/change in requirements of the Project.
• Code migration and Implementation
• Execution of SQL queries to extract data from DB2 tables thru SPUFI/QMF
• Use DB2 utilities to load/unload data from DB2 tables.
• Code new COBOL-DB2 programs in CICS and batch
• Update existing COBOL-DB2-CICS programs based on the requirements
• Provide expertise to the team on using Arrays, printers, index, SEARCH, INSPECT, DB2 CURSORS, INNER and OUTER JOINS, VSAM KSDS processing, CICS pseudo-conversation, Error handling in batch and CICS Cobol programs
• Create new JCL (JOB, PROC) and update existing JCLs
• Use Syncsort and IDCAMS for manipulation of VSAM and sequential files in batch
• Monitor database growth and do performance tuning of DB2 using EXPLAIN or Platinum
• Run DB2 utilities REORG, RUNSTATS
• Use XPEDITOR for both CICS and batch COBOL programs to test or debug
• Create ad hoc reports as per the requests from clients
• Attend defect meeting
• Attend daily standup meeting for Agile projects
• Fix defects and update in HP Quality Center
• Coordinate the tasks with onsite and offshore team
• Discuss the requirements/design for the projects with offshore
• Perform functional testing
• Perform integration/end-to-end testing
• Attend Go/No-Go meeting
• Document lessons learned after each project
• Create data for downstream data warehouse applications
• 24/7 Production support for Confidential system and resolve production abends
• Analyze the existing functionalities and programs for production issues and recommend fixes
• Create system flowcharts using VISIO
• Technical expert and lead for the mainframe development team
• Project management activities
• Pharmacy Benefit Expansion
• National Group Term
• PartD EOB
• NCPDP D.0
• Annual Notice of Coverage - Evidence of Coverage (ANOC EOC)
• Exchange Confidential Administration and Financial Management (EMAFM) for Affordable Care Act/Obamacare
• PartC EOB
• Member Level Rating (MLR)
• Medicare PBM Migration (MPM)
• Small Group Expansion (SGE)

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, SPUFI, QMF, SYNCSORT, File-Aid, IBM WebSphere MQ, Xpeditor, Changeman, SAR, CA-JobTrac, EDI, Message Broker, SOAP-UI, XML, Web services, HP Quality Center/ALM

Confidential

Project Lead, Senior Developer and support

Responsibilities:

• Attend regional Confidential committee meeting to represent Confidential IT.
• Gather requirements from different facilities during Confidential committee meeting
• Analysis and implement changes to the existing system according to the client’s requirement.
• Coding and review the code/tasks done by team members.
• Modification of existing programs and development of new programs
• Create test plan, unit, system and integration testing and support user acceptance testing
• Maintain test matrix, log test results and get the defects or failure rectified by coordinating with the team.
• Code migration and Implementation
• Create ad hoc reports as per the requests from users
• Onsite technical lead and coordinate the tasks with onsite and offshore team
• Discuss the requirements/design for the projects with offshore
• 24/7 Production support for Confidential system
• Design the new Confidential system to use KPHC data directly instead of KP-ADT legacy data from IMS and DB2 databases.
• Created the data model for new Confidential
• Develop / Enhance the Confidential programs to use KPHC data directly.
• Create process to convert and load history data from old databases (IMS and DB2) to new tables
• Coordinate implementation/switching of brokers with enterprise team
• Support the switching of each facility from old Confidential (dependency on KP-ADT legacy) to new Confidential that handles KPHC data directly.
• Created the Gap analysis for the Confidential system as part of Confidential Enhancement Project
• Gathered requirements for the Confidential Enhancement Project
• Designed and coordinated the Confidential Enhancement Project
• Confidential -HL7 Project to eliminate dependency on KP-ADT legacy
• Confidential Enhancement Project

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, IMS, SQL, SPUFI, QMF, SAS, Easytreve, SYNCSORT, File-Aid, Xpeditor, Changeman, SAR, CA-JobTrac, Platinum, IBM WebSphere MQ, Message Broker

Confidential

Senior Developer

Responsibilities:

• Analysis, development of the existing programs and development of new programs according to the client’s requirement.
• Review the code/tasks done by offshore
• Create DB2 stored procedures/subroutines to be used by front-end interfaces
• Modification of existing programs and development of new programs
• Modify CIS-Hogan programs
• Unit testing and migration of code system testing environment
• Implementation
• Extract data from CIF, AIF and ADF components of CIS-Hogan
• Create ad hoc reports as per the requests from customers
• Onsite technical lead and coordinate the tasks with offshore team
• Discuss the requirements/design for the projects with offshore
• Weekly reporting of onsite and offshore status to the client
• Status report to CSC management
• Sales Experience / Branch Reporting Project
• Compliance reports
• WAMU-Providian credit card integration Project
• Automation of NAICS Code
• Office of Foreign Assets Control (OFAC) reporting
• Sales Referral Tracking Project
• Anchor Relationship Pricing Project
• CDB-DLZ secure FTP (SFTP) transmission to Informatica server
• Solicitation and Privacy Reporting
• RTP scalability Project
• Small business CRM Project
• CICS-Web conversion

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, SPUFI, QMF, Easytreve, SYNCSORT, File-Aid, Xpeditor, DB2 Stored procedures, MQ series

Confidential

Senior Developer

• Enhancement of the existing programs and development of new programs according to the client’s requirement.
• Development, testing and implementation
• Develop additional features as required by the client
• Perform production support and maintenance
• Improve application performance
• Develop documentation of existing and new modules
• Perform quality assurance and testing
• Participate in team meetings
• Create report based on adhoc request from client

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, SPUFI, QMF, Easytreve, SYNCSORT, File-Aid, Endevor, Panvalet

Confidential

Project Lead

Responsibilities:

• Impact analysis and prepare the functional and technical design for the NvDM elimination.
• Define strategy and planning for the project.
• Lead and coordinate the project at offshore
• Track the project status daily and report status on weekly basis
• Development and review of code
• Unit, system and integration testing
• Validate test results
• Review the work done by offshore before delivering to the client
• Implementation
• Post implementation support
• Participate in team meetings
• Oversee problem solving on existing modules, functionality and programs
• Get the clarification, doubts cleared with the clients for offshore

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, REXX, CLIST, SYNCSORT, File-Aid, Xpeditor, Endevor, Panvalet, Unix, Perl, Shell

Confidential

Technical Lead and application support

Responsibilities:

• Enhancement of the existing programs and development of new programs according to the Business Partner’s requirement.
• Implementation of developments or fixes.
• Support the service center for Point of sales
• Review the work done by offshore before delivering to the client
• Provide production support for POS
• Analyze the programs to fix the problems related to production abends
• Technical lead at offshore
• Attend team meetings
• Oversee problem solving on existing modules, functionality and programs
• Get the clarification, doubts cleared with the clients for offshore
• Monitor the production jobs and their performance
• Improve application performance, if required

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, REXX, CLIST, SYNCSORT, File-Aid, Xpeditor, Endevor, Panvalet, Unix, Perl, Shell, IBM WebSphere MQ

Confidential

Application developer and support

Responsibilities:

• Enhancement of the existing programs and development of new programs according to the client’s requirement.
• Handle daily, weekly and monthly reports
• Test plan preparation, testing and test results verification and implementation.
• Design for new requirements
• Review the work done by offshore before delivering to the client
• Support the service center for Field sales access and Finance
• Provide production support for Revenue accounting systems.
• Participate in team meetings
• Oversee problem solving on existing modules, functionality and programs
• Get the clarification, doubts cleared with the clients for offshore
• Monitor the production jobs and their performance
• Improve application performance, if required

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, REXX, CLIST, SYNCSORT, File-Aid, Xpeditor, Endevor, Panvalet, Focus, Easytreve

Confidential

Developer and Tester

Responsibilities:

• Study of impact assessment results.
• Identify impacted components
• Coordinate with onsite to clarify doubts
• Code conversion
• Baseline, regression and timeline testing
• Review the code conversion done by other team members
• Conduct Automation testing using CA-InterTest validate the output results and compare the regression and timeline output with baseline
• Documents the test results
• Participate in team meetings
• Send weekly status report

Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, DB2, SQL, SYNCSORT, File-Aid, Xpeditor, Endevor, Panvalet