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 the programs
• Expertise in requirement gatherings, design document preparation
• Technically proficient in mainframe skills like COBOL, JCL, DB2, VSAM
• Excellent knowledge 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 the 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 the 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 knowledge 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 the requirements from Technical Specification Design and provided the 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 the problems reported and to determine the 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 the 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 i.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 the 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 the 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 the Business Requirement Document and prepared Functional Specification Design documents.
• Developed programs from scratch and modified existing programs using
• COBOL II, PL/I, VSAM and DB2 as per the requirements.
• Worked on customer requirement analysis, design, coding, creating test plans and testing of the system
• Developed complex JCL for manipulating huge volumes of file data using utilities.
• Executed Unit Testing & Integrated test on the components.
• Played a role of Code Reviewer.
• Implementing the code changes, release validations and migrations.
• Involved in troubleshooting and resolution of issues related to the production environment.
• This project involved gathering of requirements for the calculation of the ALR Factors and to
• Analyzed the ALR system and fix any issues that are reported by business partners and also Gather requirements for updating and developing the ALR factor Tables as per the new requirements to remain in compliance with laws. worked on multiple Service request and also incidents and defects submitted by the client. modified the programs as per the requirement also created new programs to update the ALR factors.
• Built new tables to be used by the actuarial team with new factors as per the current market which were provided the clients.
• Created the reports and moved and submitted to the business partners via a tool control D. fixed many out of balance issues on the reports and the job failure issues.
• Contributed to the Successful implementation of the Project and migration of the codechanges to the 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 the technical design documents and carrying out walkthrough meeting with the IT & Business managers.
• Modified and tested COBOL and CICS programs and JCL codes per the 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 the team. (Both offshore and onsite) at the end of the schedule.
• Use SQL (complex queries) to query the 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 the running of theIDMSCommunity of Interest meeting to prioritize activities that were to impact theIDMSregions. Coordinated and tuned the activities for the 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