SUMMARY

• Highly motivated IT professional, with over 6 years of experience in application development maintenance of Mainframes Applications Extensive experience in analyzing business requirements and created Technical Specification document
• Involved in SDLC cycle - design, specification, coding, testing, integration, regression and system testing, documentation and maintenance of teh programs
• Expertise in requirement gatherings, design document preparation
• Technically proficient in mainframe skills like COBOL, JCL, DB2, VSAM
• Excellent noledge in IBM Mainframe technologies such as COBOL II, IDMS, CICS, VSAM, JCL, DB2 UDB, SQL, SPUFI, Change Man, SPUFI, IDCAMS and File-aid.
• Expertise in working with CICS environment.
• Functional experience includes being a team member and also handling teh functions of team leader as a mainframe developer.
• Proficient in creating test plans, test scenarios and test execution
• Stronganalytical, problem solving, multitasking and strategic planningskills.
• Primary contact person for monitoring and system availability.
• Tracking all teh production related incidents and working directly with client to provide them regular updates within defined SLA’s.
• Supported CICS, ORACLE andIDMSin an outsourcing environment on large MVS mainframes by reviewing, recommending and implementing processes and changes.
• Good domain noledge of Insurance, Banking & Financial services and Transportations Industries.
• Implemented large-scale, release and enhancement projects. Supported delivery of batch, customized reports expertise in Database Designing, Data modeling, Developing, Implementing, configuring, managing and troubleshooting of MS SQL Server 2008R2/2012/2014 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.

TECHNICAL SKILLS

Languages: COBOL, JCL, SQL(Mainframe, DB2), Java, T-SQL

Web Technologies: JavaScript, HTML, CSS, PHP

Tools: & Platforms: Change Man, IBM Debug Tool, Control-M, File Manager, SPUFI, DTS, IBM Fault Analyzer, ISPF, IDCAMS, MS SQL Server Management Studio(SSMS), TFS, Query Analyzer,SQL, profiler, INTERTEST, XPEDITOR

Operating Systems: Z/OS,MVS,WINDOWS 8.1/10

Database ManagementSystem: DB2, VSAM

Web Servers: Apache Tomcat 5.0

Databases: Oracle 9i, 10g, 11g, 12c, DB2, MS SQL Server 2008/2012/2014

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Mainframe Developer

Responsibilities:

• Extensive experience in analyzing business requirements and created Technical Specification document
• Understanding teh requirements from Technical Specification Design and provided teh impact analysis for existing modules enhancement
• Created High Level Design documents and Solution Specific Design documents for multiple projects
• Design and Developed code as per business requirements and executed unit test cases
• Provided SIT and UAT support
• Coordinated with project team to analyze teh problems reported and to determine teh corrective action by discussing with QA / product management group
• Documented issues reported in various phases of testing and proactively worked on code fix to avoid repeated issues in higher environments
• Reviewed teh code, test plans, test scenarios and test execution
• Prepared and executed automated test cases to verify and validate results after every deployment
• Supported code migration to higher environments
• Supported production environment me.e. Batch / Online jobs monitoring
• Provided quick resolution for production tickets/incidents
• Maintenance and/or development of Cobol and CICS programs including DB2 as well.
• Coded new Cobol and CICS programs with DB2 as a part of building teh new system.
• Coordinated with On-site and Off shore project teams
• Experience in business development, enhancements and evaluation of Insurance domain applications
• Coded newSQL, DB2/COBOLprograms to load and unload data and create reports.
• Provided assistance for optimization and performance tuning of DB2 SQL and stored procedures.
• Prepared database design documents, code reviews, definition and structure.
• Assisted in designing and implementation of backup and recovery operations for database applications.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Developed Tablix Reports, Tabular Reports, Matrix Reports, drill down Reports, matrix and drill through reports and Charts using SQL Server Reporting Services (SSRS).
• Deployed and scheduled teh reports on quarterly, monthly and yearly basis.

Environment: MS SQL Server 2014, SQL Server Data tools (SSIS, SSRS), T-SQL, C#, TFS (2012), Oracle 11g, IBM DB2 9.5.1, Visual Studio 2012, Cobol, Jcl, Vsam, DB2, REXX, Change man, Control-M, File Manager, SPUFI .

Confidential

Application Developer

Responsibilities:

• Involved in understanding teh Business Requirement Document and prepared Functional Specification Design documents.
• Developed programs from scratch and modified existing programs using
• COBOL II, PL/me, VSAM and DB2 as per teh requirements.
• Worked on customer requirement analysis, design, coding, creating test plans and testing of teh system
• Developed complex JCL for manipulating huge volumes of file data using utilities.
• Executed Unit Testing & Integrated test on teh components.
• Played a role of Code Reviewer.
• Implementing teh code changes, release validations and migrations.
• Involved in troubleshooting and resolution of issues related to teh production environment.
• This project involved gathering of requirements for teh calculation of teh ALR Factors and to
• Analyzed teh ALR system and fix any issues that are reported by business partners and also Gather requirements for updating and developing teh ALR factor Tables as per teh new requirements to remain in compliance with laws. worked on multiple Service request and also incidents and defects submitted by teh client. modified teh programs as per teh requirement also created new programs to update teh ALR factors.
• Built new tables to be used by teh actuarial team with new factors as per teh current market which were provided teh clients.
• Created teh reports and moved and submitted to teh business partners via a tool control D. fixed many out of balance issues on teh reports and teh job failure issues.
• Contributed to teh Successful implementation of teh Project and migration of teh codechanges to teh production environment and performed technical and functional checkout andthe status was successful.

Environment: Windows XP, z-OS,IBM Quick 3270, MVS,JES,COBOL,VSAM, JCL,CICS,SQL,DB2Stored Procedure, ISPF,SDSF, File-AID, BMC utilities, ABEND-AID, RDZ IBM Debugger, Endevor, FTPSPUFI, QMF, IDCAMS, Sort Utilities.

Confidential

Mainframe Developer

Responsibilities:

• Involved in full project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases.
• Involved in preparing teh technical design documents and carrying out walkthrough meeting with teh IT & Business managers.
• Modified and tested COBOL and CICS programs and JCL codes per teh requests of business departments.
• Take new scheduling requests from programmers, set upCA-7 jobdefinition, schedules, triggers and requirements.
• Monitor and ABEND resolution of MVSCA-7/CA-11batch processing.
• Creation and maintenance of mainframe execution JCL (jobs)to support system replacement project in User acceptance (UAT) and Production environments.
• Extensive coding using COBOL, JCL and VSAMs.
• Preparing System test cases and performing UAT activities.
• Gathering Signoffs from Business.
• Preparing End of schedule report and carrying out minutes of meeting with teh team. (Both offshore and onsite) at teh end of teh schedule.
• Use SQL (complex queries) to query teh database.
• Production support- this includes monitoring of system jobs, attending to special quarter- end and month-end job processing, sending ABEND reports and system availability reports.
• Respond to alerts(SMS & phone calls) per SLA guidelines.
• Extensively used debugging tools such as XPEDITOR and INTERTEST.
• Managed and coordinated teh running of theIDMSCommunity of Interest meeting to prioritize activities that were to impact theIDMSregions. Coordinated and tuned teh activities for teh 3IDMSregions.
• Coordinated all activities between Application Development, Software Support and Computer Operations that effectedIDMSapplications and system software.
• Organized and scheduled all maintenance, including fixes and preventative maintenance, to theIDMSsystem software, databases and startup JCL

Environment: Cobol, JCL, Vsam, SQL, CICS, SPUFI, TSO/ISPF, XPEDITER, Abend-AID, IBM-Utilities, Endevor,INTERTEST