Customer Service System

Summary: Acquired an acute ability to listen to users and technical staff to advance effective solutions. Highly skilled at absorbing new data quickly for effective communication and application.

Languages, Skills, Tools and Operating Systems:

• Visual Basic (ver. 3.0, 4.0, 5.0, 6.0)

• COBOL(many versions) including imbedded SQL

• DB2/SQL, SPUFI, QMF

• IMS DB/DC, CICS, VSAM, flat files

• IBM Debug, Endevor, File Manager, File Manager DB2, EASYTRIEVE, XPEDITER, FILEAID, TABLEBASE, FILESTAR, MFS, BTS

• MS Word, Excel, Access, Visual Basic for Applications(VBA), Powerpoint, MS Project

• IBM: z/OS, OS/390, MVS, z/VMS, AIX, z/VM, zVSE, AS400/iSeries.

• VAX: VMS

• IBM Mainframe JCL, TSO, ISPF, Clist, Rexx

• Used many SDLC versions to document and control development of new systems and changes to existing systems.

Professional Experience:

Jun 11 to Present

Computer Science Corporation(CSC); Raleigh, NC

• Assisting in developing the Medicare Medicaid Information System (MMIS) for the state of North Carolina. This is a new IBM Mainframe DB2 Claims control and processing system with a web browser user interfaces(UI).

• Participating in requirements gathering meetings with state representitives, documenting results for state and CSC verification.

• Developing technical and user specifications for Cobol/DB2 and Web User Interface functions.

• Developing programs using the Endevor source control system.

• Performing unit testing with IBM Debug, File Manager, File Manager DB2 for online and JCL/Proc batch processes. Creating unit test documentation for CSC and state verification.

• Performing system testing and creating test documentation for CSC and state verification.

• Assisting in user acceptance testing.

Aug 10 to May 11

Galileo Networks; Los Angeles, CA

• Conducted interviews with stake-holders to determine scope and feasibility for an automated method of evaluating proposed vendor rates.

• Documented and presented the results to management.

• Developed business specifications based on the scope and feasibility document.

• Wrote the technical specification document for the new vendor rate evaluation system.

• Coded and implimented the Vendor Rate Evaluation System in MSAccess/VBA and Oracle PL/SQL.

• Developed a user guide on how to use the evaluation and reporting system.

Mar 03- Mar 09

Healthnet, Woodland Hills, CA

• Single-handedly recovered screen generator technology for the company when all expertise was lost. The screen generator was used to develop and maintain online screens for the claims system. I learned and documented the generator’s functions and used it to develop screens for new requirements.

• Maintained and redesigned CICS VSAM Claims Payment Control System.

• Designed and created a MSAccess data repository for user access and developed downloads from legacy provider, claims and payments systems. Developed many MSAccess/SQL queries per user requirements.

• Wrote new and made modifications to existing COBOL programs on VAX and IBM.

• Assisted in conversion of a legacy VAX system to AS400/iSeries. Lead design meetings to clarify user requirements. Performed Technical Lead functions and provided project management reports using an Excel dashboard.

• Used HIPAA forms and guide lines for data transfer control.

• Documented migration process in MS Word with table of content and indexing.

Jun 96 – Mar 03

WellPoint Health Networks, Blue Cross of California, Thousand Oaks, CA

• Modified COBOL programs for an IMS online/batch claims disability system.

• Developed specifications to automate the manual process of handling disability claims.

• Converted COBOL check printing programs from Xerox to IBM printing technology. Lead user requirements meeting and developed the business specifications.

• Used MSWord templates to document changes per Jordan methodology. Assisting in creating test cases for user acceptance testing (UAT).

• Created many downloads from a legacy system into Excel and MSAccess for user availability. Developed many MSAccess/SQL queries for users.

• Wrote Remote Procedure Calls (RPC) using COBOL for the IMS online Provider Pricing System for access from the client/server environment. Assisted in writing the client application for the Provider Pricing System in Visual Basic 6.0. Developed many SQL queries for the application.

• Assisted is designing the Leased Network Claims client/server system. Used IBM’s ERP software to design the connections of the manual and automated functions of the system. Wrote Visual Basic and COBOL programs to interface with EDI input and FileNet imaging system. Wrote claims processing and security programs for the system in Visual Basic 6.0 and DB2. Used Erwin data modeling and SQL Server to map and create database structures. Used HIPAA data formats for transferring and receiving claims.

• Modified online and batch COBOL programs for the IMS online Dental System.

• Created mainframe online interface, using COBOL programs, between the IMS online Membership databases and the Voice Recognition Unit (VRU) System for routing customer service calls.

• Managed Year 2000 conversion projects for the IMS online Dental and the CICS online Claims Processing Systems. Converted antiquated programs to the latest version of COBOL while correcting Year 2000 date bugs. Assisted in creating UAT test cases and documenting results of testing.

• Participated in on-going testing of the VRU System.

• Rewrote many COBOL CICS programs for the Claims Processing System.

• Modified COBOL programs for the IMS online Pharmacy System, the IMS online Pharmacy Billing System and the Pharmacy Rebate System.

• Developed specifications and documented the IMS online Group-Rebate system using the Jordan methodology.

Jun 95 – Jun 96

Kaiser Permanente, Pasadena, CA

• Maintained the CICS/COBOL/Telon Membership Contract System.

• Developed an interface between a mainframe legacy system and a client server application.

• Created many downloads from a legacy DB2 system into Excel and MS Access for user availability. Developed many ad hock SQL queries and downloads for users.

Jan 95 – Jun 95

EMI Music Distribution, Woodland Hills, CA

• Maintained an EDI purchase order and billing system. Created a Visual Basic application to report partner company status.

• Made corrections and modifications to the online Order System and online Promotions Reporting System.

Jul 94 - Jan 95

Blue Cross of California, Woodland Hills, CA

• Performed analysis on new provider supplied data and developed COBOL programs to prepare the data for updating to the IMS online Provider System.

• Performed analysis on new customer data and developed COBOL programs to prepare the data for updating to the IMS online Membership System and its multiple VSAM and TABLEBASE ancillary databases.

• Maintained the IMS online Claims System.

Jun 93 - Jul 94

Verizon, Thousand Oaks, CA

• Assisted in converting their California customers from a legacy billing system to a new IMS DB2 Customer Service Billing System; this required massive ongoing enhancements to the new billing system.

• Designed and created a DB2/SQL interface system to extract, reformat and pass customer service request data from the legacy system to the new billing system. The interface required adaptations to changes in the legacy and new billing systems. This interface system provider users with an online method of controlling data conversion and exception handling.

Feb 93 - Jun 93

Marshall Industries, El Monte, CA

• Provided post-implementation support for a DB2/SQL online order entry and inventory system. Developed and modified batch and report programs.

• Designed and installed a new ISPF-based programmer workstation.

Jul 92 - Jan 93

ARCO Products Company, Los Angeles, CA

• Modified the online ADF/IMS/DB2 Customer Management System.

• Developed COBOL DB2/SQL subroutines to enable ADF transactions to access DB2 databases.

• Maintained the ISPF-based Programmer Workstation System.

Jan 92 - Jul 92

Verizon, Thousand Oaks, CA

• Assisted in converting Continental Telephone’s computer systems to Verizon’s legacy system. Converted Assembler, PL1 and old COBOL programs to the latest version of COBOL.

Sep 91 - Dec 91

UNOCAL, Los Angeles, CA

• Assisted with the installation of the CICS/DB2/SQL Tesseract Personnel Management System.

Sep 90 - Sep 91

Lockheed Aeronautical Systems Company, Burbank, CA

• Enhanced the COBOL IMS/DB2/SQL online Tesseract Personnel Management System. Managed the project in its final stages of testing and installation. Used the SDM70 methodology for documentation of the system.

• Developed ISPF-based data entry and edit panels, inter-company transmit functions and system configuration reports.

• Provided ad hock analytical data to users with SAS from the IMS/DB2 system.

Jun 90 - Sep 90

Security Pacific Bank, Glendale,CA

• Assisted with the conversion of the Bankcard System to new third party software for faster online transaction response.

• Developed COBOL programs that used third party software utilities for faster database access.

• Performed maintenance on the COBOL IMS online Loan Origination System.

Aug 84 - Jun 90

Lockheed Aeronautical Systems Company, Burbank, CA

• Installed the IMS/DB2/SQL online Tesseract Personnel Management System. Managed the requirements gathering, analysis, design, development, system testing, user acceptance testing, implementation and production support phases of the project. Documented each phase using the SDM70 methodology.

• As a key member of the Quality Assurance Group, conducted pre-installation quality assurance reviews. Developed the system change methodology used at Lockheed by analyzing methodologies such as SDM70, Jordan and military specifications.

• Developed an ISPF based source change control system for controlling production installations of application software.

• Used third party software (Sage's APS) to develop and implement programs for the IMS online PARTS System.

• Analyzed the current operations of the IMS online PARTS System. The source code had degenerated due to poor source control procedures and inconsistent handling. Rewrote 80% of the source code (COBOL, ADF, MFS) to meet upgraded user requirements.

• Provided ad hock analytical data to users with SAS out of the Tesseract and PARTS systems.

Sep 83 - Aug 84

ARCO Petroleum Products, Los Angeles,CA

• Assisted in the implementation of the large IMS online Product Order and Tracking System.

• Created the technical specifications for the Product Ordering and the Delivery Scheduling subsystems. Developed the online ADF transactions for these subsystems.

Mar 83 - Sep 83

Gibraltar Savings and Loan, Burbank, CA

• Made major enhancements to the IMS online Loan Data System.

• Maintained and installed IBM software for the company.

Sep 82 - Feb 83

Blue Cross of Southern California, Woodland Hills, CA

• Maintained the COBOL IMS online Membership System.

Aug 80 - Aug 82

Lockheed California Company, Burbank, CA

• Designed, developed and implemented additional components in COBOL of the IMS online PARTS System.

Sep 78 - Aug 80

Senior Programmer/Analyst, Lockheed California Company, Burbank, CA

• Maintained the IMS online PARTS System with COBOL programs.

Jul 77 - Aug 78

Programmer, Bekins Moving and Storage, Glendale, CA

• Maintained the IMS batch Storage Information System using COBOL.

Contact this candidate