SUMMARY:

• Senior Software Analyst having 7+ years of experience in handling Mainframe Development and Support Projects with skill - sets across COBOL, JCL, DB2, CICS, VSAM, REXX and NDM along with knowledge in UNIX Shell Scripting.
• Extensive experience in the IT industry with experience of end-to-end implementation of the SDLC, including requirement analysis, design, development, implementation and maintenance.
• Strong functional knowledge of Utility Domain including metering, billing, payment, delinquency and mobile order processing.
• Hands-on experience in handling transaction processing in finance domain.
• Thorough experience in batch job scheduling, monitoring and maintenance through CA7 and ESP Scheduler.
• Thorough with version control tools like Changeman, Endevor and other tools like TSO/ISPF, File-Aid, QMF, XREFPLUS, CA VIEW, CA DB2 TOOLS and SPUFI.
• Demonstrated experience in creating and scheduling applications based on Mainframe, UNIX and Java on CA ESP Cybermation tool.
• Worked with business and functional teams to gather requirements, design quality solutions, and create Functional and Technical specification documents.
• Involved in Implementing Test Plans, Documentation, Production Implementation and support turnover.
• Ability to meet deadlines and handle pressure and coordinate multiple tasks in a work / project environment operated on Onshore-Offshore Model.
• Ability to work independently.
• An excellent problem-solver, able to quickly grasp complex systems and identify opportunities for improvements and resolution of critical issues.
• Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
• Received Client Champion Award for handling critical payment issue.
• Received client appreciation for various ideas implementations, which resulted in the faster execution of code in the production environment.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX and Z/OS.

Languages: COBOL, JCL, REXX, VSAM, CICS, SQL, UNIX shell scripting.

Databases: DB2, SQL Server 2008, 2012, Oracle.

Business Process Tools: MS Excel, MS Word, MS PowerPoint, MS Outlook.

Tools: Easytrive Xpeditor, TSO/ISPF, Fileaid, XREFPLUS, CA/VIEW, CA DB2 TOOLS, QMF, SPUFI, CA7 & ESP Scheduler, Connect Direct NDM, Eclipse, RAD, Visual Source Safe, Subversion, Putty, Secure Fx & CRT, CA ESP Cybermation tool, Beyond Compare, WebSphere MQ explorer, SQL Server Management Studio and Toad.

Version Control: CHANGEMAN, ENDEVOR, Visual Source Safe, Subversion.

PROFESSIONAL EXPERIENCE:

Confidential - Foster City, CA

Lead Mainframe Developer

Responsibilities:

• Build new JCLs, PROCs and COBOL modules to automate the data delivery of interchange adjustment reports based on subscription maintained by CICS online system in the VSAM files.
• Create new COBOL modules to generate reports dynamically based on different type of subscription maintained in CICS based Report Distribution Management System (RDMS) and create dynamic JCLs to NDM the reports to clients using Internal Reader.
• Setup report defination in CA View and load the delivered reports into CA view.
• Perform Unit testing, QA testing and User acceptance testing for the new reports with Clients on certification environment.
• Give knowledge transition to support team.

Environment: COBOL, JCL, PROCs, COPYBOOK, VSAM, CICS, JCL Utilities, ENDEVOR, CA View and ESP Scheduler.

Confidential

Lead Mainframe Developer

Responsibilities:

• Change the Card holder Database (CDB) capture process to capture new Pin Verification Value (PVV) with Card Sequence number (CSN) Segment.
• Modify the JCLs, PROCs and COBOL modules to extract this new segment from VIP tapes for downstream processing and to include this new segment into weekly comparison and reporting process.
• Modify the COBOL modules to include the new segment in monthly Residency Billing process.
• Perform Unit & QA Testing of capture, compare and billing process.
• Give knowledge transition to support team.

Environment: COBOL, JCL, PROCs, COPYBOOKS, JCL Utilities, ENDEVOR and ESP Scheduler.

Confidential

Senior Mainframe Developer

Responsibilities:

• Update the existing Confidential capture process to read the VIP data from new tape file.
• Create a daily process to parse both versions of Confidential capture and compare between new and old data to report issues/mismatch to VIP using new COBOL and JCL modules.
• Once both the databases are in sync, point all the downstream processing to new Confidential capture tapes and shut down old capture process.
• Modify the COBOL modules and Copybooks to add new Card Acceptor Id field into Universal segment and pass this field to downstream processes for comparison and reporting.
• Perform QA testing of comparison process with VIP and new capture with downstream processes.
• Give knowledge transition to support team.

Environment: COBOL, JCL, PROCs, COPYBOOKS, JCL Utilities, ENDEVOR and ESP Scheduler.

Confidential

Lead Analyst

Responsibilities:

• Analyse existing US domestic processing applications such as Card holder database (CDB) offline, Token Vault offline, Card Recovery Bulletin (CRB) Services, Merchant Central File System ( Confidential ) and suggest changes required for implementing these application for China Domestic processing on China specific VisaNet Interchange Center’s (VIC’s).
• Apart from above application, analyze Data and Reports distribution/delivery applications such as Report Distribution Management System (RDMS) and CA View and suggest specific changes.

Environment: COBOL, JCL, PROCs, COPYBOOKS, CICS, CA VIEW, JCL Utilities.

Confidential

Senior Software Developer

Responsibilities:

• Modify CICS based Report Distribution Management System (RDMS) to add a new validation logic to make Base II BIN field mandatory in first 6 bytes of the details field while updating or adding report subscription data for all SMS reports where destination BIN is NSPK BIN.
• Any existing data in the detail field needs be retained and right-shifted to accommodate the BIN in first 6 bytes of detail field.
• Design a bulk update process to right shift the existing data in VSAM file and update BIN information in first 6 bytes of details field of all existing NSPK subscriptions.
• Build new JCLs, PROCs and COBOL modules to extract all SMS reports subscription information from the VSAM files for all Russian subscriber BINs when the destination BIN is the NSPK BIN.
• This extract needs to be created and delivered to NSPK BIN in the generic format on a daily basis.
• Perform Unit testing, QA testing and End-to-End testing of extract creation & transmission process.
• Perform positive and negative testing on CICS based RDMS system on various environments.
• Give knowledge transition to support team.

Environment: COBOL, CICS, VSAM, JCL, PROC, JCL Utilities, ENDEVOR and ESP Scheduler.

Confidential

Senior Software Developer

Responsibilities:

• An extract report needs to be created by Hadoop file system for Base-2 & SMS Draft transaction.
• This extract file will be created in fixed length format so that all Banks can easily read the data at their end.
• This Fixed length file will be sent to MVS system.
• This extract will be further split into two parts to be processed and delivered to Banks using Report Distribution Management System (RDMS) in the TC33 format through platform every day.
• Creating New JCLs, PROCs and COBOL modules to encrypt the reports on MVS for retention and audit purpose using IBM encryption utility CSNBSYE.
• Perform Unit testing, QA testing and End-to-End testing of transmission and encryption process.
• Give knowledge transition to support team.

Environment: COBOL, JCL, PROC, JCL Utilities, FILEAID, ENDEVOR and ESP Scheduler.

Confidential

Senior Software Developer

Responsibilities:

• Gathering details of reports containing account data.
• Analyzing exist transmission and retention process.
• Creating detailed design document and test cases.
• Change transmission process of transfer of data from MVS to Linux server to Connect:Direct NDM instead of FTP.
• Creating new COBOL module to dynamically create NDM parameter file.
• Creating new NDM script to copy data to Linux server and trigger encryption process on Linux server.
• Modifying JCLs and COBOL modules to encrypt the transmitted data and reports on MVS for retention and audit purpose using IBM encryption utility CSNBSYE.
• Perform Unit testing and End-to-End testing of transmission and encryption process.
• Give knowledge transition to support team.

Environment: COBOL, JCL, PROC, VSAM, JCL Utilities, FILEAID, Connect: Direct NDM, ENDEVOR and ESP Scheduler.

Confidential

Senior Software Developer

Responsibilities:

• Analyzing existing JCLs and procedures and do impact analysis of this change.
• Modify existing COBOL modules and copybooks to capture this new field.
• Modify PROCs and reporting modules to reflect the new field.
• Transmit the modified files to ETL server for further processing.
• Perform Integration & Unit testing of all impacted modules.

Environment: COBOL, JCL, PROCs, DB2 and ENDEVOR.

Confidential

Senior Software Developer

Responsibilities:

• Create a new file triggered JCL to read a new VSS report file.
• Run the service request ID in the file against the database to get originating window source of the file.
• Copy the data in the received file to new file placing the originating window in the name of the file for ETLs to process it further.
• Transmit the new file to ETL server using Connect:Direct NDM.
• At the end of the day send an audit file containing the list of the reports processed for the day.
• Perform Unit testing and End-to-End testing of the transmission process.

Environment: COBOL, JCL, PROCs, DB2, JCL Utilities, FILEAID, Connect:Direct NDM, ENDEVOR and ESP Scheduler.

Confidential

Lead Analyst

Responsibilities:

• Gathering details of impacted applications.
• Analyzing existing JCLs and procedures and their functionality.
• Creating new procedures to in corporate the call to new software version.
• Modifying and updating run control parameters as per new version.
• Modifying JCLs to run against new procedures and run control parameters.
• Perform Unit testing and End-to-End testing of both incoming and outgoing transaction file.
• Give knowledge transition to support team.

Environment: JCL, PROCs, VSAM, JCL Utilities, FILEAID, ENDEVOR and ESP Scheduler.

Confidential - Charlotte, NC

Senior System Analyst - Technical Lead

Responsibilities:

• Requirements gathering - Involved in all the discussions with the Business during the requirements phase.
• Analysis & Architecture - Involved in analyzing the existing servers, databases residing on them and defining parameters for new servers.
• Connect with Windows server developers to ensure all required application sustainability configurations are in place for new servers.
• Connect with Vendors to deploy the application code to new servers.
• Identify batch JCLs that connect to the server and make changes to them.
• Create new mainframe security datasets to allow batch jobs to connect to servers to fetch files.
• Connect with SQL Server DBA’s to provide test data and ensure the latest copy of the database is backed up and copied over to the new server during cutover.
• Connect with Business testers to identify issues on the new platform and ensure necessary action is taken to fix them.

Environment: JCL, Windows Server, UNIX, CA ESP Cybermation tool, SQL Server Management Studio.

Confidential

Senior System Analyst - Production Support

Responsibilities:

• Perform smooth implementation of Code deployment to Production with the development team (Release Management).
• Represent Duke Energy in front of external auditors and provided detailed information to various questions raised by them.
• Designed new webpages and modified existing webpages for Duke Energy Online portal using Java scripts and web logic.
• Involved in developing forms using HTML and performing client side validations using JavaScript.
• Tested the Web Logic using Soap UI tool.
• Updated front end .Net GUI screens to point to new COBOL modules.
• Designed new SQL queries for SSRS business report and created reports using Microsoft SQL Server Report Builder.
• Provide knowledge transition to the new members of the team.
• Interact extensively with both business and vendor groups on various application/operational issue and provided/implemented the resolution.
• Did root cause analysis of reporting issues with one of the vendor and suggested a new process to business. Designed new UNIX scripts and ESP jobs for implementing the same that helped reduce manual efforts both at business and IT end by more than 50%.
• Designed a UNIX SFTP script that enabled us to transmit files to an external vendor along with email notification functionality to send names of the files that were transmitted.
• Analyzed and fixed critical payment, billing and reporting jobs to help improve the system performance

Environment: COBOL, DB2, STORED PROCEDURE, JCL, VSAM, CICS, .NET, JCL Utilities, FILEAID, QMF, SPUFI, CHANGEMAN, ENDEVOR, CA7 Scheduler, Eclipse, RAD, Microsoft Visual Studio, Visual Source Safe, Microsoft SQL server Report Builder, Windows Server, UNIX, Visual Source Safe, Subversion, Putty, CA ESP Cybermation tool, WebSphere MQ explorer, SQL Server Management Studio and Toad.

Confidential

Senior System Analyst - Technical SME

Responsibilities:

• Reversal of incorrect/double posting payments posted against accounts.
• Reversal of late pay charges created against account due to timing issues.
• Coordinating and setting up the schedule for all payment batch jobs as per in compliance with the vendor, federal and non-federal holidays.
• Coordinating with various payment vendors to ensure that large amounts of payments are easily processed after holidays/long weekends.
• Identified an issue wherein a payment was posted 5000 times against a customer’s account due to formatting issue in a file that caused huge balancing difference. Designed new SQL queries to revert all the payments and applied a fix to the posting JCL.
• Setting up automated alerts for issues with batch processing so that timely action can be taken by the support team to get vendors involved.
• Setting up adhoc on demand process to check erroneous disconnect issued for customers.

Environment: COBOL, DB2, JCL, VSAM, REXX, CICS, JCL Utilities, QMF, SPUFI, CHANGEMAN and UNIX.

Confidential

System Analyst - Technical SME

Responsibilities:

• Created XML converter application to transform mainframe flat file on UNIX servers to XML files for downstream FCS application using Java XML Parser.
• Integrating Java and UNIX based conversion process into automated CA ESP Cybermation tool.
• Setting up conversion process to run 4 wide on different UNIX batch servers to allow parallel processing of data.
• Setting up the integration of UNIX and windows based FCS server and UNIX and Mainframe to allow easy transmission of meter reading data.
• Scheduling of ESP applications and Mainframe batch jobs.
• Testing and implementation.

Environment: COBOL, DB2, STORED PROCEDURE, JCL, JCL Utilities, File-Aid, QMF, SPUFI, CHANGEMAN, UNIX, Windows Server, Java, CA ESP Cybermation tool.

Confidential

System Analyst

Responsibilities:

• Designed queries for K-10 datapull that helped Green Mountain save $700,000.
• Designed REXX modules to perform mass updates into various tables.
• Designed QMF procedures and integrated them into JCL to pull monthly count reports for the business users.
• Modified existing COBOL Module to generate monthly reporting data into new DB2 tables and designed new SQL queries to be integrated into MSRS reporting tool to fetch data from those DB2 tables and populate it in easy to manipulate Excel format.

Environment: COBOL, DB2, JCL, QMF, SPUFI and Stored procedures.