SUMMARY

• A technology driven professional with 3+ years of experience with mainframes.
• Generated codes to read (query), update and delete entries from DB2/VSAM files.
• Experience developing both batch and online COBOL programs.
• Well versed in creating Functional and Technical specifications for Mainframe applications
• Strong commitment to deliver quality applications within aggressive project timelines as individual contributor,
• Strong exposure in Design and implement proof of concepts, solution/architecture planning and custom demos
• Conversant with all Phases of Project Life Cycle including software quality standards and configuration management and change management.
• Worked extensively in development, conversion, production support and maintenance and enhancement projects.
• Designed DB2 database tables and have worked along with DBAs to create and alter DB2 tables.
• Executed queries using SPUFI and DB2i utilities.
• Well versed in all the stages of the software development cycle (SDLC), namely design, specification, coding, debugging, testing (test plan and test execution), integration and system testing, documentation.
• Have good knowledge on Xpeditor, File - aid.
• Worked in CIS team to resolve incident requests and service requests.
• Performed Daily Health Checks to ensure system availability.
• Have thorough understanding and good hands-on experience working on databases such as COBOL, JCL, DB2 and VSAM.
• Proficient in analyzing and translating business requirements to technical requirements.
• Worked on dynamic production support environments.
• Strong passion to learn, ability to adapt, and commitment to perform with excellent communication skills
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Languages: COBOL, SQL

Operating Systems: Z/OS, MVS/XA, and MVS/ESA

Databases: DB2, VSAM

Tools: /Scripts: TSO/ISPF, FILE-AID, QUALITY CENTR, JCL, and XPEDITER

OLTP Systems: CICS, QMF, and SPUFI

Hardware: IBM S/370 S/390 and Z/OS 390

Others: MS Excel, MS word, MS Visio, Stored Procedures, IDCAMS, PROCS, Remedy, Changeman

PROFESSIONAL EXPERIENCE

Mainframe Developer

Confidential

Responsibilities:

• Generated codes to read (query), update and delete entries from DB2/VSAM files.
• Wrote queries using SPUFI to extract data from various DB2 Views for reporting purpose.
• Performed Daily health checks to ensure system availability.
• Worked on Remedy Incident Management tool to resolve incident requests and service requests.
• Created production version of jobs using JCL and procs.
• Worked on file aid tool to compare, edit and browse the datasets.
• Resolved abends using ABEND AID.
• Developed COBOL - CICS programs which has MQ series calls.
• Creating e-form and change ticket with in time.
• File handling like sequential and generation data groups. Involved in preparing test plans for Independent Unit testing and System testing.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Performed Peer review and log any issues and track till it is closed.
• Worked on getting approvals to move changes to production.
• Provided support during production implementation day.
• Resolved production abends with in SLA time limit.
• Monitored first batch cycle after production implementation.
• Fixed post production defects and preparing route cause analysis documents.
• Provided regular updates to the client and ensure high quality timely delivery.
• Successfully implemented a project using COBOL, CICS and DB2 for improving performance of the existing system which resulted in performance improvement of about 22% to 24%.
• Documented and coded client requirements and prepared high level design and technical design documents.
• Hands-on Experience in creating automated Jobs, Batches and scheduled DTS Packages using REXX scripting.
• Delivered and monitored data during Annual Billing process for the UK based Confidential energy and utility project which recorded billing of about 800 million for the year 2014.

Environment: COBOL, JCL, DB2,SQL, VSAM, CICS, TSO, ISPF, SPUFI, Remedy, File Manager, Abend AID, Changeman, Z/OS, MVS, REXX, IBM Utilities, IBM Debugger, MQ Series.

Associate Mainframe Developer

Confidential

Responsibilities:

• Worked on the analysis of old programs and to give the technical solution to avoid more calls to database in order to reduce the CPU time in the process.
• Prepared technical Design Documents related to the service request (SR) as part of the maintenance.
• Provided Maintenance and enhancement activities of the application.
• Worked on modification of existing COBOL-DB2 programs.
• Created production version of job using JCL and PROCS.
• Generated maintenance reports for the updated database by COBOL programs using CICS user interface and SQL query inputs.
• Monitored System testing of programs.
• Provided Mainframe Level-2 production support for project maintenance and support activities.
• Modified the database structure, as necessary, from information given by application developers and to maintain proper record of all minor fixes and changes.
• Involved in fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends.
• Accomplished tasks that involved migration of data (specific to the requirement) through servers from one environment to another using SMFT and BACS tools.
• Provided database query fixes using SQL queries with respect to the client requirements.

Environment: COBOL, JCL, DB2, SQL, VSAM, CICS, AORTA Platform, IBM debugger, TSO, ISPF, SPUFI, QMF, Z/OS, REXX, File-AID, ABEND-AID.