Education & Certifications:

• Master In Computer Applications, Indira Gandhi National Open University (IGNOU) INDIA
• B.Sc in Computer science, Nagarjuna University (Guntur] AP INDIA

Employment History:

Confidential, Washington DC 
Jun 11 – Present
Sr. Oracle Functional Consultant
Confidential is afederal agencywhich holds primary responsibility for enforcing the federal securities laws and regulating thesecuritiesindustry, the nation's stock and options exchanges.

• Execution of Unit test plans and verification of the test results thereby ensuring quality delivery.
• Involved in designing some of the modules in the TRACR project
• Coded Main and Sub programs for PL/I, ASM COBOL, DB2 and CICS modules which contain ASM Interface to pass output data to Unix FTP files.
• Created new online CICS/IMS_DC screens using SDF/MFS methodology.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Newly coded REXX JCL, PROC and Control Cards for running batch applications
• Prepare and run Embedded SQL queries on the database to verify data using SPUFI, QMF.
• Used Expeditor for the debugging the large code with multiple subprograms and logged / tracking defects in Quality Center.
• Worked on CF systems DEVLT on online CICS and DB2.
• Worked on Online xped and batch xpeditor jobs.
• Worked on DB2 platinum to check date entries.
• Defect (SR/PL) analysis and resolution for live and system test defects.
• Root cause analysis of system test and oncall production abends
• Fixing the code for the live defects raised by Testing team and the BSD's.
• Responsible working on UNIX commands and creating korn shell scripts
• Coded Programs for the Enhancement projects that come from clients usingCOBOL and DB2.
• Estimate upgrades to the Recovery Software System.
• Retrieval of backup tapes
• Responsible of creating the directories in UNIX and save the files on these directories coming from mainframe application through FTP
• Extracting information from IMS database and creating the online screen using IMS DC
• Working with Rapid Deployments (RD) like RD520 and RD352 etc which come for rate changes and changes in SAS Notes.
• Experienced in using ISPF tool for working with panels
• Involved in creating test scenarios based on use cases base on the new features incorporated in then version.
• Used to lead the bug triage meetings for bug resolutions.
• Worked with NDM Connect Direct for the transmission of files from one region to other like Test to Production and Vise versa.
• Experienced in using SORT, SYNCSORT, IDCAMS, IEBGENER, IEFBR14 and many other utilities
• Experienced in using RACF tools for giving authorization for different datasets for BSD’s
• Used FTP for transferring the files in between and documenting then into word

Environment: IBM OS/390, COBOL, CSF, DB2, JCL, CICS, VSAM, REXX, CA-7, TSO/ISPF, Endevor, InfoPac, EFT, EDI/EDIFACT, ANSI X12 transaction sets, ACH, PEP+, EditPlus, Gentran, PRC, SPUFI, QMF, SQL, FILE–AID, ABEND–AID, Testbase, XPEDITER, Panvalet, Lotus Notes, MS-Office, MS-Word, MS-Excel, PowerPoint.

Client : Confidential, Saint Louis MO
Aug 2010 to June 2011
Development/Maintenance and System test/Production support
IBD Phase -2 (Insured Bank Deposit)
As a Sr Programmer Analyst Roles and Responsibilities:

• Understanding Technical Requirements of APAR shipment from IBD team.
• Preparing Retrofit note for each shipment APAR or SR-release notes from Vinner team
• Worked on CLONE Business user test environment on DB2 and IDMS
• Promote all APAR, SR shipment into CHISD development regions.
• Performing retrofit each fun level CHIS-US code changes
• Performing checkout testing of each APAR or SR shipment
• Preparing Detailed design and Specification documents of all SR/PL business requirements.
• Conducting reviews on SR/PL’s, Detailed designs, UTPs and UTRs along with client.
• Coding and development as Per the Low Level Design.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Attending SR/PL/Release Project meetings along with client and sharing the same to other team members.
• Worked on CF systems DEVLT on online CICS and DB2.
• Worked on Online xped and batch xpeditor jobs.
• Worked on DB2 platinum to check date entries.
• Defect (SR/PL) analysis and resolution for live and system test defects.
• Root cause analysis of system test and oncall production abends
• Giving 24X7 system test and oncall Production support CHIS-US.
• Performing review checkout test results of each shipment (SR/PL’s) for both Host Mainframes and frontend JAVA.
• Unit Testing on Service Request’s (SR), Problem Log’s (PL) and evaluating the test results for test plans and test cases and prepare the test result summary report.

Environment : COBOL, JCL, IMS-DB/DC and DB2 and IDMS.
Tools : workbench, Changeman, SCWB, Lotusnotes, Vantive, Quality center, BMC, File aid, Comparex, QMF and SPUFI.

Confidential. Saint Louis MO
Client: American Telegraph & Telecom (AT&T) 
Mar 08 – July 10
Project Name: UB1_ICBS (Interexchange Carrier Billing System) 
Sr. Mainframe programmer Analyst 
Confidential is among the Fortune 50 companies whose subsidiaries operating under the SBC brand, provide a full range of voice, data, networking, e-business, directory publishing and advertising, and related services to businesses, consumers and other telecommunications providers.
ICBS application handles the following systems:

• ICBS (Interexchange Carrier Billing System—Casual User)
• IBBS (Invoice Billing-Billing System)
• IDB (Invoice Derived Billing—AT&T only).

An interexchange carrier (IXC) is a telephone company that provides connections between local exchanges in different geographic areas. IXC provides inter LATA service as described in the Telecommunications. They're commonly referred to as "long-distance carriers." IXC includes AT&T, MCI, Sprint, and others.
Responsibilities:

• Understanding the Overall functionality and Business requirements for Interexchange Carrier Billing System
• Understanding the SFAD and Technical Requirements
• Preparing Detailed design and Specification documents for business requirements.
• Conducting reviews on SFAD, Detailed designs, UTPs and UTRs along with client.
• Coding and development as Per the Detailed design.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Attending FAR/Status/Recovery/ Project meetings along with client and sharing the same to offshore team.
• Defect analysis and resolution for live and system test defects.
• Investigated the code for the BSD Queries and giving them solutions for fixing the code to get rid of defects
• Created JCL's for the recoveries that must be done for usages with invalid data and the usages that were rated incorrectly.
• Fixing the code for the live defects raised by Testing team and the BSD's.
• Responsible working on UNIX commands and creating korn shell scripts
• Coded Programs for the Enhancement projects that come from clients usingCOBOL and DB2.
• Experienced in using SORT, SYNCSORT, IDCAMS, IEBGENER, IEFBR14 and many other utilities
• Experienced in using RACF tools for giving authorization for different datasets for BSD’s
• Used FTP for transferring the files in between and documenting then into word
• Create test ware using only the business/functional and technical requirements as input
• Creating the Packages in CHANGE-MAN for all the PMT's.
• Experienced in using ABEND-AID tool to debug the code
• Experienced in using SPUFI tool for executing queries in DB2
• Experienced in using IBM Utilities for getting the usages as per the BSD’s requirements for further testing
• Expertise with Analysis and Design to create specification doucuments with using MS office suite( MS- WORD, MS- EXcell and powerpoint).
• All executable statements must be tested using EXPEDITOR, expected results documented
• Experienced in working with REXX tool for creating JCL's and for weekly and monthly recurring jobs
• Involved in 24/7 production call support.
• Worked with Quality Center for testing mainframes projects.
• Worked on ATT internal installer STAR.
• Coordinate with EPAS IBM Brazil team to fix all production issues and EFIX and and system test issues.
• Worked on DB2 capacity planning and management
• Coordinate with Offshore for all Defect, ADHOC, Requirements etc..
• Preparing Requirement Tractability Matrix for all BR TR and FR

Environment: MVS/ESA, Z/OS, COBOL, DB2 8.0, IMS DB/DC, JCL, CICS, FILE-AID, CHANGE-MAN, SPUFI, CLIST, ISPF, VSAM, FILE-AID, SQL, XPEDITOR, NDM Connect Direct, ABEND-AID, CA7, RACF, EASYTRIEVE, REXX, SAS, FTP, SAR, QUALITY CENTER,SMP, E installation, Rexx VISIO and UNIX. 
Tools: Changeman, NDM, Vantive, Quality center, File aid, Comparex, BMC, RD trac, QMF and SPUFI.

Confidential.
March 2006 to Feb 2008 
Maintenance and System test and Production support
Journals Taxes & UAS (JTAU and CASH)
Client : American Telegraph & Telecom (AT&T) USA
Team size : 6
Description: Journals application is responsible for accumulating and reporting financial transactions which occur within the CRIS/CABS Billing system. These transactions involve not only SBC revenue but also include other billing entities for which we have billing contracts.
Taxes Used for calculating the taxes paid on a telephone bill. There are many different types of Taxes. Besides Federal and State taxes, It track many different local taxes from many different areas. In addition to Taxes, the Taxing programs track Surcharges also.
UAS maintains all information related to uncollectible portion of account amount due by carrier, irrecoverable, un associate salvage cash that has been identified by the CRIS system and outside collection agency expenses.
Cash process includes miscellaneous updates to the customer data base and balance due updating. Each transaction record contains common information of at least a billing account number or service order, batch date, batch item number, total transaction amount, entity code.
Responsibilities:

• Gathering business requirements, preparing functional and technical specifications by understanding business requirements.
• Developing many modules in TRACR2 and TRACR.
• Preparation of unit test plans.
• Execution of Unit test plans and verification of the test results thereby ensuring quality delivery.
• Involved in designing some of the modules in the TRACR project
• Coded Main and Sub programs for PL/I, ASM COBOL, DB2 and CICS modules which contain ASM Interface to pass output data to Unix FTP files.
• Created new online CICS/IMS_DC screens using SDF/MFS methodology.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Newly coded REXX JCL, PROC and Control Cards for running batch applications
• Prepare and run Embedded SQL queries on the database to verify data using SPUFI, QMF.
• Used Expeditor for the debugging the large code with multiple subprograms and logged / tracking defects in Quality Center.
• Conducted disaster recovery DR exercise on all region datasets and environment.
• Developed optimized coding on REXX, unit testing and quality documents and tested PL/I, COBOL, IMS_DC , VSAM, DB2, JCL jobs and programs.
• Created test plans as per business and user requirements. Responsible for manually testing the entire application for system process functionality and business logic.
• Responsible for Quality of the Product and Co-coordinating with Users during User Acceptance testing.
• Worked on various region data center relocation on full billing cycle.
• Follow up with the Production run and checked the derived result with the post production team.
• Preparing Detailed Designs, Specification Documentation for the work request
• Understanding the Overall functionality and Business requirements for Interexchange Carrier Billing System
• Understanding the SFAD and Technical Requirements
• Preparing Detailed design and Specification documents for business requirements.
• Conducting reviews on SFAD, Detailed designs, UTPs and UTRs along with client.
• Coding and development as Per the Detailed design.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Extracting information from IMS database and creating the online screen using IMS DC
• Working with Rapid Deployments (RD) like RD520 and RD352 etc which come for rate changes and changes in SAS Notes.
• Experienced in using ISPF tool for working with panels
• Involved in creating test scenarios based on use cases base on the new features incorporated in then version.
• Used to lead the bug triage meetings for bug resolutions.
• Worked with NDM Connect Direct for the transmission of files from one region to other like Test to Production and Vise versa.
• Experienced in using SORT, SYNCSORT, IDCAMS, IEBGENER, IEFBR14 and many other utilities
• Experienced in using RACF tools for giving authorization for different datasets for BSD’s
• Used FTP for transferring the files in between and documenting then into word
• Create test ware using only the business/functional and technical requirements as input
• Creating the Packages in CHANGE-MAN for all the PMT's.
• Experienced in using ABEND-AID tool to debug the code
• Experienced in using SPUFI tool for executing queries in DB2
• Experienced in using IBM Utilities for getting the usages as per the BSD’s requirements for further testing

Environment: MVS/ESA, Z/OS, COBOL, DB2 8.0, IMS DB/DC, JCL, CICS, FILE-AID, CHANGE-MAN, SPUFI, CLIST, ISPF, VSAM, FILE-AID, SQL, XPEDITOR, NDM Connect Direct, ABEND-AID, CA7, RACF, EASYTRIEVE, REXX, SAS, FTP, SAR, QUALITY CENTER, VISIO and UNIX. 
Tools: Changeman, NDM, Vantive, Quality center, File aid, Comparex, BMC, RD trac, QMF and SPUFI.DITER, Panvalet, Lotus Notes, MS-Office, MS-Word, MS-Excel, PowerPoint.