SUMMARY

• 8+ Years of IT experience in system development, maintenance and enhancements using SDLC methodology in Mainframes technologies.
• Having extensive experience in working with mainframe technologies like COBOL, JCL, DB2, CICS, IMS DB/DC, VSAM and IDMS.
• Technical expertise with relevance to the different phases of Analysis, Design, Programming, Debugging, Testing, Implementation, documentation and maintenance of IBM Mainframe applications.
• Excellent working knowledge in Core Application design, Development, Testing and Production support. Developed complete programs which deal with CICS.
• Experience working on creating tables, developing DB2 Stored Procedures and online CICS tools.
• Strong knowledge about USA Insurance, banking domain, ADP payroll process and worked in credit card processing, Autopay processing and Claims related projects.
• Ability to write Complex SQL queries with strong knowledge of DB2.Strong knowledge about database design, normalization,DB2 stored procedures,functions,referential integrity, Locking & Concurrency, Utilities etc.
• Experience in leading a team, status reporting, metrics, estimates etc.,
• Received several accolades from Clients.
• Expert in analyzing information system needs, evaluating end - user requirements, custom designing solutions, troubleshootingand performance tuning.
• Extensively used the tools JCL, File-Aid/Data Solutions, Easytrieve and Expeditor.
• Strong experience in working JCL, Endeavor, Abend-aid, Bind and Precompile.
• Perform Impact analysis and provide solutions to user’s change requests.
• Hands-on experience in creation of test strategy, test cases and test execution in Mainframe Online and Batch environments.
• Used CA7 (Mainframe Production Control Scheduling) to schedule jobs.
• Ability to multi-task work across different applications. Diverse work experience with different functionalities of the application, with Development and Production Support projects.
• Experience working on the project built using the Agile Methodology. Involved in the estimate planning, design discussions and scrum meetings for the project.
• Extensive experience working as an onsite coordinator attending the project review meetings with Clients gathering requirements, preparing High Level Design(HLD), Low Level Design (LLD), transitioning the requirements and design to offshore for the Build activity.
• Update QMS (Quality Management System) documents like Project initiation, Project action plan, Detailed Requirements Specifications, Impact Analysis, File Specifications, System Run Chart (flow chart), Data Base Requirements, Program Specifications, Operation Manual, Program Development, Coding, Unit Test Plan, System Test plan, Inter System Test plan, Implementation plan and Post implementation check.
• Proficient in handling projects efficiently for delivering the required applications in a very systematic way and within the stipulated timeline.
• Providing post-implementation, application maintenance and enhancementsupport with regard to software.
• Addressing queries regarding System/Software including maintenance of software support.
• Undergone training in Time Management, Project action Planning, Cross culture, interacting with client, Assertiveness skills and Effective Team meetings.
• Easily adaptable to new technologies in short time and work effectively as part of team and independently
• Excellent communication, interpersonal and analytical skills with proven abilities in resolving the complex software issues.
• Brain bench certified Professionalin ‘Cobol2’, ‘DB2’, ‘JCL’, ‘CICS’, ‘VSAM’, ‘RDBMSconcepts’, ‘Software testing’ and ‘Programming concepts’.

TECHNICAL SKILLS

Operating System: Mainframes (MVS, OS390 & Z OS), UNIX, Windows

Languages: COBOL, CICS, JCL, Easytrieve, REXX, SQL, PL/SQL, XML, C, C++

DBMS: DB2, VSAM, IDMS, ORACLE Database 9i,10g,11g

Tools: IBM Utilities, TSO ISPF, Changeman, Infoman, Xpeditor, SPUFI, File-Aid, Abend - aid, QMF,CA7 (Scheduler), SQL* PLUS, SQL developer, TOAD, PVCS, OLQ, DQF, DMLO, SPITAB, DTCN, Dump Master, TOM, TWS, INFOX, BMC Administrative facility, Intertest, LIBCCF.

Domain Expertise: Banking & financial services - Credit card processing

PROFESSIONAL EXPERIENCE

Confidential

Associate - Projects

Responsibilities:

• Analyzing Business / Technical Requirements and coming up with the design flow for the areas involved in Huron application for new online modules.
• Analysis is made completely on the requirements and a document named K245 is prepared and shared for the freeze of requirements. Preparing Estimation and sizing of the new project.
• Involved in the preparation of technical specifications and test plan documents for the development of new programs having complex functionality. Preparation of test cases, test procedures and test logs.
• Created six new online programs using CICS, COBOL and DB2 to process the statementing messages entered on the online screens.
• Online Screens are developed using Basic Mapping System (BMS).
• Used Xpeditor for unit testing the source components created/modified.
• Used Changeman to check in and to modify the source components.
• Created new DB2 tables for storing the statementing messages.
• Used DB2ADMIN tool to bind the DBRM's and view the bind timestamp as well. It is also used to grant or revoke the access to the new DB2 tables.
• Creating Change Request (CRs) as and when required.
• Utilized debugging tools including File-Aid, Abendaid and Expeditor
• Peer reviews of the deliverables and ensuring the quality aspects of the deliverables.
• Implementation is processed on the Rollout phase and necessary Infoman and Changemangement records are raised for the installation procedures as required for the processes in CRS.
• Once Accountable and Transaction files received from the upstream, statementing process is performed for the generation of Statements where batch process is involved.
• Worked on small projects which is referred to as SPRINT team / projects. Involved in more than 6 SPRINT projects.
• Created a new batch jobs using JCL to execute the new batch program to generate the credit card statements to the Amex customers.
• Developing few tools using REXX to minimize the routine/redundant activities. Example: FTP tool for Parm verification and Job scheduler tool.
• Used SPUFI for extract the data from existing DB2 tables while doing system analysis.
• Coordinating with the Clients; training and mentoring new joiners.
• Knowledge Transfer to the offshore team with business functionality and the new requirements.

Confidential, New York, New York

Technical Consultant

Responsibilities:

• Development of the new batch programs using COBOL, DB2, JCL and VSAM
• Conduct JAD to review the business document with a team of business end users, application developers and technical analysts.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Used PVCS (Program version control system) tool for check in and migrate the new batch program and modified job.
• Used LFTEST tool for doing unit testing of new online and batch programs.
• Used COMPARE-X tool to compare the modified and existing source components.
• Used Code Collaborator for the for design and code reviews. This tool is very good for tracking the review comments and gets the approvals from everybody.
• Used QMF for extract the data from existing quote and policy DB2 tables while doing system analysis.
• Also performed as onsite host lead and coordinating with offshore team and get the assigned tasks.
• Worked closely with the WEB team for developing new XML tags as needed by Web from mainframe for the reports to be displayed in the front end.
• Debugging and implementing the system using IBM Debug tools.
• Scheduling of mainframe batch job using CA7. Assisting programmer with scheduling, troubleshooting problems with the scheduled jobs, migrating new clients into CA7
• Used FTP to transfer file from Mainframe to PC and vice versa.
• Involved in preparing test plans for Independent Unit testing and System testing.
• Impact analysis for requirement changes, finding affected list of programs and homogeneous implementation.
• Setting up Process to be followed from Offshore.
• Perform Peer review and log any issues and track till it is closed.
• Responsible for correct versioning of code by creating and moving the requests using Endeavor.
• Status Reporting and Responsible for the final delivery.

Confidential

Senior Member Technical

Responsibilities:

• Conducting system study & review and analyzing Business/Technical Requirements.
• Design, Coding, Construction, Testing and Debugging of application.
• Developing new modules whenever a new payroll feature is to be included in the payroll system.
• Handling & resolving high priority/severity field issues in the system.
• Involved in production support activities. Ensured the batch cycle gets completed in time.
• Also, fixed the issues within the time mentioned in Service Level Agreements (SLA).
• Work involves fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends.
• Created a new batch program using COBOL DB2 to process the weekly reporting entries present in the Reporting table.
• Modified the existing batch job using JCL to execute the new COBOL DB2 program.
• Analyzing modifications, finding affected list of programs and homogeneous implementation.
• Handling Ad-Hoc Requests.
• Developed High complex SQL queries to fetch data from database to validate the data for testing.
• Developed complex programs using DB2 stored procedures and functions.
• Created best unit test scenarios covering all aspects of the business requirement.
• Used SPUFI for extract the data from existing DB2 tables while doing system analysis.
• System involved new DB2 tables, Cobol Batch Programs managed in Endeavor.
• Analyzing output test data using File-aid, creating datasets to test, setting up JCL, and Moving modules using Endevor.
• Ensuring quality aspect of the deliverables. Managing Quality Assurance and Defect Prevention activities.
• Training the new team members and preparing the case studies to cope up with technical knowledge required for the project.
• Involved in preparing test plans for Independent Unit testing and Work package testing.
• Testing the Applications for the business requirement and responsible for delivery from offshore.
• Involved in System testing and attending to the trackers raised and resolving them in time.

Confidential

Programmer Analyst

Responsibilities:

• Analyzing, coding, testing and implementation of several enhancements, conversions and bug fixes.
• Maintenance and production support of the existing system.
• Preparing the Flow Diagram for the Areas involved in UCS Dental application, for both Online and Batch Modules.
• Documentation of the existing online and batch programs.
• Involved in getting the technical specifications, code and test plan documents reviewed by the client's regular basis to meet the quality of the deliverables.
• Created new message queues to pass the dental insurance data from different sources to claims processing system.
• Created new programs using COBOL CICS VSAM to generate the adjudication process of claims whenever the user approves the policy. These new programs use Temporary Storage Queues (TSQ) to transfer data between CICS programs and Transient Data Queue (TDQ) to trigger another transaction for processing the claims.
• Modified supporting COBOL programs to drop the message into the queue and read the messages and process accordingly.
• Used PDSE to create and browse the new VSAM file.
• Used new VSAM file to write the error weekly reports from new COBOL DB2 program.
• Used Software Configuration Management (SCM) tool for check in and migrate the new batch program and modified job.