SUMMARY:

• 12 years of IT experience in development, conversion, enhancement, testing and support of mission critical business applications using formal software engineering methodologies.
• Application maintenance and production support Analyst with Substantial experience in upgrades, conversion, migration, Agency compensation and Life Insurance Administration.
• Involved in Development, Maintenance and Managing of various Applications using Mainframes.
• Expert in using technologies COBOL, JCL, VSAM, DB2, IMS DB, CICS, EASYTRIEVE.
• Having expertise in both online and batch applications using VSAM as well as DB2.
• Good Knowledge in writing programs using web enabled online programming with COBOL, CICS and websphere MQ.
• Good knowledge in writing and using stored procedures using COBOL and DB2.
• Expert in using IBM and third party tools like Endevor, File Aid, File manager, Xpeditor, DB2ADM, Abendaid, Zeke, Xrefplus and SAR.
• Well versed in Incident Management, fixing batch job failures in Production and pre - production environments, handling tickets, prioritizing production issues, resolving production issues within SLA.
• Exposure to the full cycle of software development including Requirements Analysis, Program Design, Development, Unit testing, System Testing, Integrated Testing, Maintenance and Documentation
• Performed Technical Project Lead activities which involve - Understanding of the business requirements, estimating, planning and scheduling the tasks to deliver against time. Task allocation, monitoring & control, reviews.

TECHNICAL SKILLS:

Languages: COBOL, JCL, PL/I

Databases: DB2, IMS DB, VSAM

OLTP: CICS

Reporting: CA-Easytrive

Tools: SPUFI, QMF, DB2ADM, XPEDITOR, ENDEVOR, FILEAID, File Manager, Zeke, SAR, ABENDAID, XREFPLUS, DB Visualizer, Oracle data Studio

Utilities: DFSORT, SYNCSORT, ICETOOL, IEBGENER, IEBEDIT, IEBCOPY, ISRSUPC, IDCAMS, IKJEFT01, DSNUTILB

PROFESSIONAL EXPERIENCE:

Confidential

Technologies Used: COBOL, JCL, VSAM, DB2, Exadata

Responsibilities:

• Creating automated tool to convert any copybook into a comma delimited fields with numeric editing characters.
• Creating automated jobs that generates comma delimited file for any given input copybook and file.
• Creating automated tool to generate DDL query in EXADATA for any COBOL input copybook.
• Loading data from comma delimited file into Exadata using SAS routines.
• Updating statistics with record count and has total for each segment of VSAM files.
• Validating the data in each phase of data extraction to make sure data migration done without errors.
• Preparing compliance pages to understand each stage of the data extraction process.
• Giving field level explanation to the modeling team on request basis.
• Involved in the conversion of 500 segments of policy level KSDS files and 1200 types of factors tables from RRDS files.

Confidential

Technologies Used: COBOL, JCL, VSAM, DB2, CICS, Easytrieve

Responsibilities:

• Attending BRD meetings to understand the business requirements.
• Analyzing the requirements and preparing high level design documents.
• Estimating the work by supplying all the metrics to the estimation model.
• Involving into request assignments to the team and monitoring in all the stages of SDLC.
• Conducting weekly status meetings to know the status of each request handled by team member, preparing minutes of meeting, finding solution for hurdles, giving directions and motivation to get error free deliverables without schedule deviation.
• Making root cause analysis for the common defects and updating the review check list to reduce these defects from future request.
• Taking care of code migrations and coordinating the SIT and UAT testers to make sure the testing is done on time.
• Migrating production data into test region and setting up complete test batch cycle on need basis.
• Involving into code reviews to check functionality, standards and performance.
• Reviewing unit test plan, test results and supporting documents to make sure testing is done accurate.
• Maintaining proper documentation for each request handled by the team to have no issues in internal audits and also participating internal audits for other projects.

Confidential

Technologies Used: COBOL, JCL, VSAM, DB2, CICS, Webspehere MQ, Easytrieve

Responsibilities:

• Writing programs and JCL’s to convert data from VSAM files into DB2 tables based on the rules given in data mapping excel sheets.
• Proving test results on direct mapping fields with file comparison ISRSUPC and converted fields with screen shots.
• Converting COBOL programs and JCL procedures to replace VSAM code with corresponding DB2 tables.
• Changing the file, library, accounting info, class and other parameters according to new subsystem.
• Conducting regression testing to prove the output of each converted program is same as VSAM system.
• Developing and testing COBOL DB2 stored procedures.
• Making the necessary program changes both in online and batch programs.
• Fine tuning every SQL query with performance tuning techniques.
• Implementing checkpoint logic on mass update DB2 programs to improve performance.
• Setting up test data in SIT and UAT databases when requested by corresponding testers.
• Preparing technical specification document with clear technical approach.
• Preparing unit test plan with all possible test cases.
• Involving into peer reviews and updating review logs.
• Involving into code migrations in all the stages of Endevor.

Confidential

Technologies Used: COBOL, JCL, VSAM, CICS, Easytrieve

Responsibilities:

• Attending BRD meetings to understand the requirements of enhancement requests.
• Analyzing existing modules to identify impacted elements and preparing analysis document.
• Preparing technical specification document with clear technical approach.
• Preparing unit test plan with all possible test cases.
• Making changes in existing programs or writing new programs with proper coding standards.
• Preparing test data, executing test jobs and preparing unit test results with supporting documents.
• Involving into peer reviews and updating review logs.
• Involving into code migrations in all the stages of Endevor.
• Working in primary on call support for production and pre-production cycles.
• Scheduling and monitoring batch jobs in Zeke and providing 24/7 on call support.
• Tracking all the production related incidents via Service Desk tickets and working directly with client to provide them regular updates within defined SLA’s.
• Fixing the recurring abends with permanent solution to make the application stable.
• Fine tuning the programs to reduce cycle time.
• Involving in production data change requests to fix error records in the production.
• Assisting SIT and UAT testers in preparation of test data from production.

Confidential

Technologies Used: COBOL, JCL, VSAM, DB2, IMS DB, Easytrieve

Responsibilities:

• Understanding the report specification given by the customer.
• Coordinating with BA or application lead to understand the business terms.
• Writing adhoc programs to extract data into delimited files from various applications.
• Converting extracted delimited files into excel sheets and sending to customer.
• Involving into peer reviews to send accurate reports by reducing errors.
• Making recurring reports into batch reports to reduce manual effort.
• Updating adhoc search logs to get the reference code for future requests.