| Overall 10 years experience in full life cycle development using CICS, DB2 and VSAM applications. Strong experience as Sr. Programmer/Developer/Analyst using COBOL, CICS, DB2, VSAM, JCL,NATURAL, EZTRIEVE, TSO and ISPF on various operating systems like OS/390, IBM 1390, ESA 9000, MVS ESA MVS-XA, UNIX, DOS and WINDOWS 2000. Involved in SQL tuning and performance. Excellent hands on experience using PLATINUM DB2 TOOLS, DB2 EXPLAIN, PRINCETON SOFTECH ARCHIVE FOR DB2. STROBE, XPEDITOR and COGEN. Primary objectives are to provide custom software development, quality assurance, production support, or related services; preferably with exposure to new skills. Languages: CICS, VS COBOL I &II, EZTRIEVE, DYL280, SAS, NATURAL, JCL, ISPF, TSO, C Software/Databases: PLATINUM DB2, SPUFI, QMF, DB2 FILE AID, DETECTOR, NDM, SAR, STROBE, XPEDITER, INTERTEST, FILEAID, SUPERC, PEGASYS, COGEN, CA-7, SDSF, MS WORD, POWER POINT, EXCEL, VISIO, ENCYCLOPEDIA SERVICES KEY 4.1, PRINCETON SOFTECH Archive for DB2 Hardware: IBM OS/390, IBM 3090, ESA-9000, MVS-ESA, MVS-XA, UNIX, DOS, WINDOWS 2000 Databases: DB2, VSAM, ADABAS, IMS DB/DC Environment: ENDEVOR, PANVALET, RATIONAL CLEAR CASE Southern California Edison, Irwindale, CA Sep 02 - Jan 03Involved in analysis, detail design document preparation, user sign off, coding several batch programs for the CSS Data Retention project. Involved in table designing. Performed unit and functional testing. The purpose of this project is to ensure an appropriate storage of critical Customer Service System (CSS) data over a timeframe. Sr. Developer/Analyst Created programs (CICS/COBOL) Created and modified programs, JCL抯 and database tables. Coded programs and screens using CICS/DB2. Performed archive and purge process using Princeton Softech Archive for DB2 tool. The pre-identified critical data, which are more than four years old, will be deleted from the CSS system and archived for pre-determined period. Performed impact analysis of different sub-systems. Interact with users to ascertain requirements and create design documents. Interacted with Production Control to create job-triggering conditions using CA7 on OS/390 environment. Technologies: IBM OS/390, COBOL, DB2, CICS, JCL, REXX, PRINCETON SOFTECH Archive for DB2, VISIO Farmers Group of Insurance, Los Angeles, CA Mar 01 - Sep 02Interacted with end users to gather requirements and analyzed them into technical specifications Sr. Programmer/Analyst During this period, participated in analysis, design, development, coding and testing of many projects for Farmer's Group like Common Agency Platform project, FPPS-SAP project, Easypay project etc. Developed Use Cases by analyzing the business transaction flows and business rules catalogue. Extensively involved in several COBOL, CICS program changes Coded programs and screens using CICS Designed scrolling screens using TSQ feature of CICS Involved in online map changes (CICS) Developed adhoc eztrieve reports, and worked on DB2 table changes and the cleanup. In the FPPS-SAP project analyzed and resolved the Premium Out of Balance Issues in Fire Policy Processing System Main file (commonly known as DRIF) and FPPS database. Developed test plan for QA Functional testing, provided post-implementation support and production validation. In the Easypay project supported production related problems. Analyzed stopped or errored accounts in various billing tables and COGEN downstream tables and processed them correctly. Used CA7 for batch job scheduling in OS/390 operating system Technologies: IBM OS/390, COBOL, DB2, CICS, EZTRIEVE, JCL, KEY 4.1, COGEN, ENDEVOR, INSYNC, INTERTEST, BETA, HIPERSTATION, RATIONAL CLEARCASE, MS-WORD, MS-EXCEL May 97 - Feb 01 Sr. Programmer Analyst, SAI Software Consultants Inc Worked as one of the main developers in the Accounts Receivable team where the system was DB2/COBOL/VSAM based. Accounts Receivable is WCOM's system of record for processing cash, adjustments, and invoices associated with direct remit, customer accounts. Involved in analysis, design, coding, unit and system testing and implementation. Interact with users to ascertain program specifications of changes and/or upgrades. Worked as a 揚roduction on-call ?(on 24 x 7 basis) for AR Legacy System and RMS, and performed status reporting and documentation. Interacted with Production Control to create job-triggering conditions using CA7 on OS/390 environment. Monitored and optimized the database performance. Maintained Collection Strategy System (CSS). Risk assessment of delinquent WCOM direct remit customers is performed by CSS. Resolved various application problems. Analyze, modify several CICS/COBOL/DB2 programs, and performed unit and system test on a large scale IBM mainframe. Prepared and modified CICS mappings Developed CICS screens Technologies: IBM OS/390, COBOL, DB2, CICS, EZTRIEVE, JCL, SYNCSORT, SAS, NDM, FILEAID, ENDEVOR, XPEDITER, STROBE, PLATINUM DB2, SPUFI, QMF, CA7. SPRINT Telecommunication, Irving, Apr 96 - Apr 97 Programmer Analyst In the IPS Field Size Analysis project prepared the Total Requirement Statement to identify report changes and other specifications. The intent of this project was to expand the fields of the MBA invoice and the Telemanagement reports that were considered critical in order to convert the remaining NAD customers to IPS. Involved in analysis, code modification, and system testing batch programs. Executed the project within the timeframe. Maintained and supported the Customer Information System for SPRINT Long Distance Division. Analyze financial data and create statistical reports (DYL280). As a part of the SES Release Testing (QA) team performed code control according to agreed procedures with the Environment team. Performed Pegasys problem management, execute regression and product test; facilitate execution issues resolution, support system test. Technologies: IBM 3090, COBOL, DB2, CICS, NATURAL, ADABAS, JCL, FILEAID, ENDEVOR, XPEDITER, SPUFI, QMF, FILEAID, INFOMAN, PEGASYS, NDM, SAR, CA7. SPRINT RPG INDIA LTD, New Delhi, India Nov 92 - Mar 96 Programmer Analyst Revenue Accounting System project supported on call activity and resolution and monitoring of problem tickets for HARI. The project comprised of four applications HARI, OPEN ITEM, High Toll and CACS. These applications are part of the Sprint mission critical billing cycle and address residential as well as commercial customers. Prepared the Total Requirement Statement by understanding the business requirements. Analyzed the programs, prepared Design statements, coding, prepared test cases for both unit & system testing, performed all phases of testing, implemented the project. Technologies: IBM 3090, COBOL, DB2, CICS, JCL, FILEAID, ENDEVOR, SPUFI, QMF, FILEAID, INFOMAN, PEGASYS, NDM, SAR. Bachelor of Science (Computer Science and Engineering ) University of Bangalore, Bangalore, India in 1992 IBM Mainframe (ES9000) Training at Ashok Leyland Information Tech., India which covered the following areas: MVS, COBOL, DB2, SQL, JCL, VSAM, CICS, CSP, IMS DB/DC, NATURAL, ADABAS Training on USE CASE DEFINITION by Cap Gemini Ernst & Young. Training on ADVANCED DB2 PROGRAMMING by MCI WorldCom. |
