TOOLS

• Hardware: IBM Mainframe, TSO, VSAM, UNISYS 2200, CLEARPATH, IBM PC, IBM System 36, AS/400
• Software:Microsoft Office, Access, COGNOS, Oracle SQL Developer v2.1.0.63.73, Teradata SQL Assistant, Lotus 1-2-3,WordPerfect 7.0, FORMGEN, MASQ, Clipper
• Languages: SAS, COBOL, SQL, JCL, ECL, TIP
• Networks: Novell, FoxPro for Windows
• Databases: DB2, SQL, RDMS, PADS, dBASE III Plus, dBASEIV, PIMS, DMS

PROFESSIONAL EXPERIENCE

CELERITY

Confidential

Responsible to Confidential providing accurate testing data to testers which is then used to assure defect free access to all products offered to Highmark customers. Data is gathered utilizing many licensed and in-house software packages, including Oracle SQL Developer, TERADATA SQL Assistant and EXCEL, as well as TSO. Coordinate with testing teams to gather types of data for specific testing needs and organize data into EXCEL spreadsheet format for ease of use by testing teams. Other duties include the creation and preparation of daily reports using COGNOS software to interrogate SQL databases. These reports are saved in EXCEL format and manipulated to present the data to various areas of need.

Confidential

Programmer

• Responsible to IBM Inc. providing accurate reports related to the daily operations of IBM Inc. for end-users worldwide Reports are generated utilizing the SAS programming language, SQL, JCL, DB2, ODS, and TSO on an IBM mainframe platform. Work includes creating unique input files, merging files, sorting within the program, using SAS commands such as DROP, KEEP, and SET, along with PROC SQL, PROC PRINT, PROC REPORT, PROC SORT, etc. and standard macros.Use SQL calls within programs to extract data and create tables from DB2 databases, and HTML code to create EXCEL spreadsheets Provide documentation and records of procedures used for report generation to IBM for future use and analysis
• Other duties include the preparation of programs to be migrated into production by modifying the code, testing, and writing procedures for production operators Provide backup support to other SAS programmers in the performance of their daily duties, and SCLM migration support

Confidential

Customer Service

• Provided solutions to customer concerns and needs in a fast-paced direct contact call center
• Analyzed problems related to accounting, ordering, and billing, and resolving consumer concerns
• Evaluated applications and offered suggestions to improve overall performance.Analyzed company procedures and goals, developed improved criteria and met company needs

Confidential

Programmer

• Responsible for the analysis and resolution of incidents found by end-users in the daily implementation of the PACSES system, involving records pertinent to health care, welfare, Medicare, Medicaid, professional licensing, pharmaceuticals, and other information related to Pennsylvania's child support system Tracked, reconstructed, and tested to determine the cause of the problem Tests conducted in a UNISYS mainframe environment and used COBOL programming language, SQL, ECL and TIP to meet federal guidelines
• Responsible for upgrades and changes to the PACSES system involving rewrites to the source code
• Developed end user documentation, created and updated system screens utilizing the FORMGEN screen creation tool and MASQ

Confidential

Programmer

Provided consulting services to the Commonwealth of Pennsylvania, Bureau of Program Integrity, to identify, analyze, and resolve problems involving Medicare, Medicaid, pharmaceuticals, and health care claims fraud on a UNISYS platform utilizing the COBOL programming language Provided comprehensive reports extracted from the Commonwealth's data warehouse Analyzed bureau process, procedures and goals to develop data solutions to meet bureau needs Consulted with management to assess existing software and offer recommendations for upgrades and enhancements

Confidential

Programmer

Responsible for the analysis and resolution of incidents found by end-users in the daily implementation of the PACSES system, involving records pertinent to health care, welfare, Medicare, Medicaid, professional licensing, pharmaceuticals, and other information related to Pennsylvania's child support system Analysis included tracking, reconstructing, and testing to determine the cause of the problem Tests conducted in a UNISYS mainframe environment using the COBOL programming language, SQL, ECL and TIP to meet federal guidelines. Responsible for upgrades and changes to the PACSES system involving rewrites to the source code Other duties included the development of end user documentation, the creation and updates of system screens utilizing the FORMGEN screen creation tool and MASQ

Confidential

Operations Analyst/Programmer

Responsible for processing and maintenance of a residual excess asset inventory database for the Naval Sea Logistics Center Inventory included tools, machinery, medical supplies, office supplies, food stuffs, and other ship board suppliesMaintained accurate inventory of fifty warehouses located throughout the continental United States, by first identifying then adding or purging database records Served as a supplies shipment representative and process operator. Maintained and updated system user's manual