SUMMARY:

• 10 years of experience in analysis, design, development, testing and maintenance in the field of Mainframe application development using IBM Z/OS system..
• Strong exposure in COBOL and JCL developing job flows, schedules and batch processing.
• Good experience developing CICS modules/transactions for real - time application scenarios.
• Worked on exposing an existing CICS module as webservices with CTS DFHLS2WS.
• Expertise in working with DB2 for z/OS 8.0/9.0/10 databases and in writing triggers, COBOL stored procedures and native stored procedures.
• Expertise working with IMS DB/DC database.
• Working knowledge on Datastage 9.1 ETL tool. UNIX shell Scripting Job scheduling .
• Strong experience working with Waterfall as well as Agile based Mainframe application development.
• Participated in requirements analysis, reviews and working sessions to understand the systems and system design. Experience in designing Low level and High-level design documents.
• Created, presented Estimates, proposals and gap analysis documents to client leader ship.
• Extensive experience with Sort Utilities like DFSORT and SYNCSORT and ICETOOL.
• Strong Experience with usage of IBM DB2 Utilities for LOAD, UNLOAD, FASTLOAD.
• Created new tools using REXX language, integrated them with CLIST.
• Scheduled batch flows using the CA7 scheduler, Datastage Sequencer jobs using AUTOSYS.
• Strong experience in VSAM file processing and Message Queue (MQ) processing
• Experience in version control tools like ChangeMan and Endevor.
• Experience in tools like PLAT, BMC, IBM Datastudio to evaluate the performance of a query using EXPLAINS.
• Experience writing technical specifications for IDMS Logical Record Facility.
• Worked with IDD, ADSA, ADSO, ADSC, MAPC, DMLO, DDDL, OLQ and OLP.
• Expertise MF tools like TSO/ISPF, FileAid, FileAid for DB2, SPUFI, PDSMAN, and SDSF.

TECHNICAL SKILLS:

Languages: COBOL, Ezetrieve, REXX

Platforms: Windows 9X/ 2000/XP/7/8, zOS, MVS

Database: DB2 V8.1/V10, Microsoft SQL Server 2005/2008/2012 , IMS DB/DC RDBMS concepts, CA IDMS

Utilities: DF SORT, SYNCSORT, ICETOOL, IBM Utilities for DB2, NDM/FTP, VSAM

Tools: TSO/ISPF 5.9, SPUFI, FileAid 9.1.0, PDS MAN, CA7, Xpeditor, SAR, SDSF, JCLPREP, Endevor, ChangeMan, Expeditor, MainframeExpress, IBM Debug tool, HP Quality Center, IBM Datastudio

ETL Tools: IBM - Datastage 8.5/ MS SQL Server SSIS/DTS packages

DB Tools: File-Aid for DB2, PLAT, BMC, QMF, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Senior Mainframe Developer

Responsibilities:

• In AGILE, helped the team in planning the sprint by identifying modules and creating stories.
• Created COBOL-DB2, COBOL-IMS modules, insert/update or delete from DB, JCLs to execute the modules.
• Coded native stored procedures using IBM Datastudio to support our application UI to interact with DB2 database.
• Extensively used BMC and IBM Datastudio to do EXPLAINS on stored proc queries to understand the access path and optimized the queries accordingly.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used DB entities Views, Indexes and DB concepts like Triggers to handle & maintain data.
• Used Endevor tool to maintain the COBOL modules, JCLs, parms and procs and for promoting the same to higher environments.
• Used IBM FaultAnalyzer to debug the COBOL modules and perform the unit testing.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Used CA-7 as the scheduler tool for all the batch flows inside the application.
• Created Ezetrieve codes, Sort utilities like SyncSort and IBM DB utilities using JCL and framed the job flows for batch processing of application data.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint

Confidential, Newark, DE

Senior Mainframe Developer

Responsibilities:

• Served as an onsite co-coordinator for the application mentoring the 5 member offshore team.
• Responsible for Requirements gathering, Impact analysis, Project estimation, scheduling and tracking the deliverables.
• Managed the Change Request procedures for the identified bug fixes and served as the point of contact for all the enhancement installations.
• Served as 24/7 On-call support for both mainframe and mid-range incidents.
• Mentored the offshore team and gave them technical guidance and helped them understand the business.
• Responsible for the root-cause analysis, incident research and ticket resolution.
• Analyzed COBOL-DB2 modules as part of incident research and identified the issues and fixes.
• Over saw the code development and responsible for all the deliverables and interactions with the client.
• Worked extensively with VSAM files and used COBOL modules to read/write.
• Created a Job monitoring tool using REXX language using SARBCH utility for pulling the job details from SAR and then create a report to LoB.
• Used Endevor tool to maintain the COBOL modules, JCLs, parms and procs and for promoting the same to higher environments.
• Used SharePoint as version control tool for the project documents.
• Extensively used Compass, a commercial cash management tool which is being used in our cash vaults.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Used CA-7 as the scheduler tool for all the batch flows inside the application.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint

Confidential, Jersey City, NC

Senior Mainframe Developer

Responsibilities:

• Served as an onsite co-coordinator for the application mentoring the 8-member offshore team.
• Responsible for Requirements gathering, Impact analysis, Project estimation, scheduling and tracking the deliverables.
• Designed the database for the application. Created logical and Physical data-model
• Coded native stored procedures to support our application UI to interact with DB2 database. Translated all the requirements into SP Calls and designed the application.
• Used IBM Datastudio extensively to develop, test and deploy the native stored procedures.
• Extensively used BMC and IBM Datastudio to do EXPLAINS on stored proc queries to understand the access path and optimized the queries accordingly.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used Endevor tool to maintain the COBOL/CICS modules, JCLs, parms and procs and for promoting the same to higher environments.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Used CA-7 as the scheduler tool for all the batch flows inside the application.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint

Confidential

Mainframe Developer

Responsibilities:

• Served as an application lead programmer, maintaining 6 developers and responsible for deliverables from Offshore team.
• Created COBOL-DB2, COBOL-IMS, CICS modules wherever required to apply business rules and format data.
• Created a COBOL-DB2 module and exposed it as web-service using CICS transactional server capabilities.
• Executed Ezetrieve codes, Sort utilities like SyncSort and IBM DB utilities using JCL and framed the job flows for batch processing of application data.
• ChangeMan to maintain COBOL modules, JCLs, parms & procs, promoted to higher environments.
• Used SharePoint as version control tool for the project documents.
• Created Native Stored Procedures that can be executed by Web service APIs to fetch or insert/update data from the DB.
• Used BMC tool EXPLAINS to analyze the queries and optimize them to yield performance.
• Used Q-Rep setup to maintain DB copy on a different MF LPAR as part of disaster recovery process.
• Created a FileCompare tool using REXX to compare up to 5 files on a given key. The tool will take file names and key positions as input.
• Created DTS & SSIS packages using MS-SQL Server-2000 to access data from vault servers.
• Used SQL Server Management studio from the MS SQL server 2008 to query databases.
• Created and maintained code review checklists for MF part of the application.
• Created Integration testing scripts and executed the tests and documented the test results.
• Did POC on the available dataclas parm of the MF Datasets and has shown huge DASD savings.
• Played the DP Anchor role for Defect Prevention, tracking defects, root cause analysis.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint

Confidential

Mainframe Developer

Responsibilities:

• Created high level and low level design documents from the requirements documents.
• Worked as a team to develop a database for the application, logically grouped the data in the form of tables, defined columns in tables, defined constraints, created and executed DDL statements.
• Used Mainframe LPARs with a good exposure to TSO and ISPF.
• Created JCLs to frame the job flow to develop various modules with in the application.
• Created COBOL-DB2, CICS transaction programs to format data, apply business cases, insert, Update, delete into DB.
• Used ChangeMan as the version control tool for COBOL modules and the JCLs code
• Prepared Unit test scripts and unit tested the COBOL-DB2 modules & mainframe job flows.
• Used the IBM Load and Unload utilities. Handled very high volumes of data for batch processing.
• Used File-Aid for DB2, QMF and SPUFI for accessing DB2. Created DCLGENs and used.
• Used VISUAL EXPLAINS tool to analyze and optimize the performance of an SQL query.
• Created DB2 Stored Procedures using COBOL for manipulating & fetching data for the web server.
• Created COBOL codes for accessing, reading and editing the VSAM datasets.
• Created Ezetrieve codes for file comparison and data manipulation and formatting activities.
• Used SyncSort as well as DFSORT utility for data sorting.
• NDM and FTP file transfer protocols B/W mainframe LPARs & between mainframe & UNIX servers.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint