We provide IT Staff Augmentation Services!

Senior Mainframe Developer Resume

Sunnyvale, CA

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

Hire Now