Senior Programmer Analyst Resume
Dayton, OhiO
Education
MS, Mathematics
Hardware/Software
Hardware: VAX-ALPHA, VAX-4000, VAX-2000, Mainframe IBM-370, IBM 4331, IBM 7026-6MI, IBM Compatible PC's, Client/Server.
Operating Systems: OPEN-VMS, VAX-VMS, UNIX (SCO_SV), AIX, Windows NT, Windows 2003, Windows (Professional)/XP/98/95/3.1, DOS/VSE, MS-DOS, PC-DOS
Databases: Oracle 7/8, Corvision, MS Access, Visual FoxPro / FoxPro, Clipper, Dbase III Plus, Fox Base
Languages: VAX-BASIC, VAX-COBOL, SQL, PL/SQL, ZQL, C, SQL*LOADER, Dev-2000, Visual Basic, Perl, HTML and JAVA
Applications: Pharmacy Benefits management System (HDS),Cellular Phone Billing System, Order Processing System, Electricity Billing System, Accounts and Finance information system , Line Losses system and New Application Procedure System
Tools: DCL, DEC-FORMS, CMS, DEC-RMS, TPU, DEBUGGER, FMS, Datatrieve(DTR), KORN-SHELL, C-SHELL, JCL APPLIX, STARTEAM, ORACLE FORMS , ORACLE REPORTS, ORACLE LOADER, SUPPORT MAGIC, TEL-NET, ANIMATOR, BROWSER , VI, TEXT-PAD, FTP, TOAD
Experience
May 2008 Feb 2009 Confidential
Worked as senior programmer in Express Scripts (Pharmacy Benefits Management (PBM) Company), the company works for health insurers and employers including DOD which hire ESRX to manage prescription drug benefit plans for their members and employees. Worked on VAX COBOL based Home Delivery System (HDS), main duties were analysis, development and modification of existing system, creation of test case and testing. Worked on OPEN-VMS, VAX-COBOL, DEC-Forms, DEC-RMS, CMS, MMS, DCL (.COM files procedures) , RTL_Routine, FTP, TPU, DEBUGGER and Datatrieve DTR along with Micro Soft office 2007 Prof (OUTLOOK, WORD, EXCEL, and ACCESS)
Sep 2007 Apr 2008 Confidential, NJ
Worked as senior programmer in financial company which provides administration for variable annuities and number of Insurance Companies like Allianz, Genworth, AIG … Worked on Premium Processing System which is based on OPEN-VMS, DEC-RMS, VAX-BASIC, SQL, PL/SQL (ORACLE), worked on SQL (DDL, DML) developed / modified queries to insert / update and extract the table's data. Created / modified tables, index, sequence and views. Worked on PL/SQL, developed/modified packages, procedures, functions triggers and cursors, also worked on Accent R database and DCL (.COM files procedures) in DEC-VAX /VMS environment. Main duties were development, break fixing, testing, code walk through and documentation. Worked on VAX-APLHA OPEN-VMS, BASIC, ORACLE database, SQL, PL/SQL, RMS, DCL, LOTUS NOTES, and VSS.
Nov 2002 Sep 2007 Confidential
Worked as a senior developer on a COBOL / Oracle based Cellular Phone Billing application in client/server environment. Responsibilities included analysis, technical spec design, development, testing, data review, code walk troughs and creation of test cases.
Worked on development & modifications of COBOL based work order and POS programs.
Worked on sequential, indexed sequential and Relative data files.
Worked on Unix Shell Scripting (Korn-Shell), developed / modified shell scripts for lock boxes payment system and automation of back ground jobs and other procedures to make files available for process.
Provided Production Support 24 X 7 to resolve day-by-day issues including bug fixing.
Also worked as a team member on a migration project of cell phone billing from COBOL to ORACLE, worked on development / modification of SQL quires for insert, update, delete the records from tables.
Worked on SQL* Plus to prepare the reports,
Worked on PL/SQL, developed / modified packages, procedures, functions, triggers and cursors.
Created tables and views for testing,
Wrote flat file extract programs and control file (ctl) scripts to load the data into tables through ORACLE loader.
Worked on UNIX (SCO_SRV), AIX, APPLIX, STARTEAM, TEL-NET, VI, TEXT-PAD, TOAD, SMART FTP and Microsoft Office (OUTLOOK, WORD, EXCEL, ACCESS).
Jan 2000 Nov 2002 Confidential
Worked on the Order Processing System (OPS). Provided production support and resolved day-to-day user problems. Worked with the users, gathered requirements, performed analysis, modified/enhanced CORVISION database and VAX-BASIC programs. Also made changes in screens, menus and reports programs and procedures (.COM). Worked on DEC/VAX, VAX-ALPHA, Windows NT, OPEN-VMS, DEC-RMS, CMS, FMS, DEC-FORMS, DCL, FTP, TPU, DEBUGGER, RTL routines, Microsoft Office (OUTLOOK, WORD, EXCEL, and ACCESS) and Support Magic.
Aug 1990 Sep 1999 Confidential, Hyderabad
Participated in design and development of program modules and test plans for batch and online functions of major electrical application.
Designed and developed a major accounting application to properly handle billing, collections and receivable in large water and power organization. The application was implemented in five different electrical distribution companies.
Worked on ORACLE - 7 and developed data entry forms and reports. Worked on SQL, PL/SQL, ORACLE Forms, ORACLE Reports, wrote SQL queries, packages, procedures, functions, cursors and database/ forms triggers. Created UNIX scripts (K-shell), which executed the stored procedures and then established ftp connection to a remote computer. Optimized queries. Used SQL*Loader. Converted an accounting system from VAX-BASIC and VAX-C to ORACLE 7. Transferred the data from a legacy BASIC application and wrote completely new programs, using PL/SQL, ORACLE Forms and ORACLE Reports. Designed databases applying standard normalization methods and designed indexes to optimize query efficiency. Developed procedures to govern database modifications to ensure data integrity.
Modified the billing system written in VAX-BASIC and provided 24/7 production support to different sites. Interfaced with users and management at five electrical companies to successfully insure that the requirements of each site were met. Used CMS to maintain the programs history. Wrote command procedures in DCL (.COM) to automate the system. Used DEC/VAX, Windows NT, OPEN-VMS, RMS, DCL, TPU, CMS, FMS, DATATREIVE, DEC-FORMS and DEBUGGER.
Designed technical & test documentation.
July 1988 Aug 1990 Confidential
Worked, maintained and implemented a VAX-BASIC based electrical billing system. Reviewed and approved technical system change documents, including software specifications and requests for application & database modification. Developed programs to perform data collection, editing, and processing on VAX machines, used VAX/VMS, DCL, TPU, FMS, RTL routines, DEBUGGER. Also worked on several Y2K projects and provided 24x7 on-call system and production support.
Sept 1986 July 1988 Confidential
Responsible for analysis, development & implementation of the Electrical Line Losses System and electricity billing system worked on VAX-BASIC, worked on DCL, TPU, RMS, and FMS.
Provided day to day support to BASIC based data entry system which transferred data from PC to VAX.
Performed systems analysis, detail design, development, enhancements, modifications, and unit and system testing for an electricity billing system used IBM COBOL II worked on IBM-MF 4331 JCL, DOS/VSE.