SUMMARY:

• 6+ years of experience in analysis, design, development, testing and maintenance in the field of Web technology application and client server environments.
• Strong exposure in COBOL and JCL developing job flows, schedules and batch processing.
• Expertise in working with DB2 8.0/9.0/10 databases and in writing triggers, COBOL stored procedures and native stored procedures.
• Participated in requirements analysis, reviews and working sessions to understand the systems and system design.
• Strong experience in working with full life cycle (SDLC) of Development of Mainframe based applications.
• Experience in designing Low level and High level design documents.
• Created and presented Estimates, proposals and gap analysis documents to client leader ship.
• Proficiency in developing “DataStore” applications which will receive from Upstream, load, maintain and send data to downstream applications.
• Designed and Developed various mainframe programs using COBOL and Easytrives.
• Design, Development of mainframe job flows using JCL.
• Extensive experience with Sort Utilities like DFSORT and SYNCSORT and ICETOOL.
• Strong Experience with usage of IBM DB2 Utilities for LOAD, UNLOAD, FASTLOAD.
• Experience in creating new tools using REXX language and integrated them with CLIST to invoke them using line commands.
• Proficiency in scheduling the batch flows using the CA7 scheduler.
• Strong experience in VSAM file processing and Message Queue (MQ) processing
• Experience is version control tools like ChangeMan and Endevor.
• Designed and coded a job monitoring tool using SARBCH utility for pulling the job details from SAR and then create a report to LoB.
• Strong experience in DB2 tools like PLAT, BMC to view and edit the properties of DB2 components, evaluate the performance of a query using EXPLAINS.
• Experience in MS SQL Server 2005/2008 and in creating DTS/SSIS packages for extracting the data from the databases present on various servers.
• Extensively used Compass, a commercial cash management tool.
• Expertise in using common MF tools like TSO/ISPF, FileAid, FileAid for DB2, SPUFI, PDSMAN, SDSF.
• Worked on Multiple operating systems like Windows - 2K, XP and 2007.
• Proficiency in Application Documentation using MS Office tools and version control using VSS and Sharepoint.

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, RDBMS concepts

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, SDSFJCLPREP, Endevor, Changeman, IBM Debug tool, HP Quality Center

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

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

Domain: Consumer and Retail Banking

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Mainframe Developer

Responsibilities:

• Served as an onsite co-ordinator 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.
• Executed Easytrieve codes, Sort utilities like SyncSort and IBM DB utilities using JCL and framed the job flows for batch processing of application data.
• 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.
• Created DTS packages using MS SQL Server 2000 for accessing data from various vault servers.
• Created SSIS packages using MS SQL server 2008 for extracting data from various vault databases.
• Used SQL Server Management studio from the MS SQL server 2008 to query databases.
• Created stored procedures to access MS SQL server DB and extract/insert/update data.
• 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, REXX, Easytrieve, SyncSort, DFSort, Native Stored Procedures, Changeman, Xpeditor, BMC Explains, CA-7, Compass, MS SQL server 2008, DTS and SSIS Packages, MS Visio, Quality Center, Sharepoint

Confidential

Mainframe Developer

Responsibilities:

• Assisted the onshore team for requirements gathering by participating in JAD sessions.
• Responsible for preparing the project estimates and high-level design for the identified requirements.
• Prepared the low level design document by logically designing the job flow to satisfy all the requirements.
• Served as an application lead programmer, maintaining a 6 person development team and responsible for all the deliverables from Offshore team.
• Created COBOL-DB2 modules wherever required to apply business rules and format data, insert/update or delete from DB.
• Executed Easytrieve codes, Sort utilities like SyncSort and IBM DB utilities using JCL and framed the job flows for batch processing of application data.
• Used Changeman 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.
• Mentored the team and peer reviewed the code modules and had the ownership of the application at offshore.
• 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 DB entities like Views, Indexes and DB concepts like Triggers to handle and maintain the data.
• Used Q-Rep setup to maintain the DB copy on a different MF LPAR as part of disaster recovery process.
• Used IceTool, Join Keys concepts in Syncsort utility to compare data chunks in a more efficient manner.
• 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 and maintained code review checklists for MF part of the application.
• Created Integration testing scripts and executed the tests and documented the test results using Quality Center tool.
• Supported performance testing team on the data setup and oversaw the performance testing process and responsible for giving the sign off from the development team.
• Did a PoC on the available dataclas parameter for the MF Datasets and has shown huge DASD savings.
• Creation of cards for scheduling the jobs on the CA-7 scheduler.
• Responsible for production implementation and install verification, preparation of installation documents.
• As a DP Anchor, responsible for Defect Prevention activities within the team like tracking the defects, doing the root cause analysis for the defects, identification and execution of action items to prevent the same defect from occurring again.

Environment: COBOL, DB2, JCL, Easytrieve, 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 the tables, defined the 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 programs to format the data, apply business cases and then insert, Update or delete into database.
• Used ChangeMan as the version control tool for COBOL modules and the JCLs code
• Prepared the Unit test scripts and unit tested the COBOL-DB2 modules and mainframe job flows extensively.
• Extensively used XPEDITOR as the debug tool to test the code modules.
• Used the IBM Load and Unload utilities for the bulk load and extraction of data. Handled very high volumes of data for batch processing.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used VISUAL EXPLAINS tool to analyze and optimize the performance of an SQL query.
• Created DB2 Stored Procedures using COBOL for manipulating and fetching data for the web server calls made from front end application.
• Used File-Aid, PDSMAN for accessing the MF datasets.
• Created COBOL codes for accessing, reading and editing the VSAM datasets.
• Created Easytrieve codes for file comparison and data manipulation and formatting activities.
• Used SyncSort as well as DFSORT utility for data sorting.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Created a REXX tool for automatially replicating the jobs from one environment to another (Eg: DEV to SIT).
• Created custom ISPF Panels for the User Interface of the REXX tool, which will capture the user inputs for the tool to work.
• Used Quality Center to maintain the test scripts, execute, capture and log the test results. Used the same for defect tracking as well.
• Supported performance testing team for the data setup activities.
• Created the cards for setting up the job flow in the CA-7 scheduler.
• Created the Changeman packages for JCLs, parms and procs and supported the implementation activities.

Environment: COBOL, DB2, JCL, Easytrieve, REXX, SyncSort, DFSort, Stored Procedures, Changeman, Xpeditor, Visual EXPLAINS, PDSMAN, ISPF Panels, CA-7, Quality Center, PLAT, SPUFI, FILA, FILD, QMF

Confidential

Mainframe Developer

Responsibilities:

• Created High level Design documents by analyzing the PL-SQL code.
• Created Low level Design documents from the HLD for the mainframe back-end system.
• Used VSS as the version control tool for maintaining all the Project documents.
• Translated the design into logical piece of code by coding COBOL-DB2 programs.
• Created and executed bind jobs.
• Used Endevor to create, stage, and deploy COBOL packages into Test as well as Prod environments.
• Created Mainframe jobs using JCLs to execute code modules and framed the job flow to satisfy the given requirement.
• Prepared the Unit test scripts and unit tested the COBOL-DB2 modules and mainframe job flows extensively.
• Extensively used XPEDITOR as the de-bugging tool while unit testing the COBOL-DB2 modules.
• Prepared System test cases and supported the integration testing for data setup requests and result validation.
• Extensively used QMF, File-Aid for DB2, IDCAMS Utilities and IBM Load and unload utilities while working on data setup requests.
• Used CA-7 for scheduling the job flows in System testing and UAT environment.
• Preparing End of schedule report and carrying out minutes of meeting with the team. (Both offshore and onsite) at the end of the schedule.
• Created and maintained the defect tracker and tracked each and every defect and review comment to closure.

Environment: COBOL, DB2, JCL, Endevor, Xpeditor, CA-7, IBM Load and Unload, File-Aid, File-Aid for DB2, IDCAMS, QMF.