SUMMARY:

• Senior Programmer Analyst - INFORMATION TECHNOLOGY
• Application Development / Production Support - Confidential, Retail, Oil & Gas, Food
• Distribution, Automobile Distribution, Telecommunications, Chemical Companies, Waste Management, Health Care
• Outstanding background of application development and production support. Skilled in:
• Application Development Documentation Production Support
• Application testing Application Implementation Systems Analysis
• Design Specifications Requirements Definition COBOL

SKILLS:

Abend Aid

Access

ASP

CICS

C

COBOL

DATA JUNCTION

DB2

Endeavor

Easytrieve

Expediter

FOCUS

IDEAL

Java

Librarian

COBOL

Microsoft Visual Studio 2008

Microsoft Visual Source Safe

MVS/JCL

NET EXPRESS

ORACLE

PERL

PLI

PL/SQL

POWERBUILDER

QMF

TSO/ISPF

Microsoft SQL/SERVER 2005

MVS JCL

SPUFI

UNIX

VISUAL BASIC

VSAM

TECHNICAL SKILLS:

VB.NET ORACLE DB2

ACCESS SQL/SERVER UNIX

MVS WINDOWS LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Stafford, TX

Programmer/Analyst

Responsibilities:

• Production support for Nelnet (Student Loans) Applications.
• Confidential COBOL, NETEXPRESS, GMC PRINTNET T, WINDOWS, SQL SERVER, VB6 and VB.NET are some of the tools and software used in this support role.
• Includes making enhancements to existing applications.
• The VB applications access SQL SERVER DB.
• Created SQL queries to extract and manipulate data.
• Modified Stored Procedures. Modified VB6 and VB.NET applications.
• Provided help in worksheet for running queries and scripts

Confidential, High Point, NC

Contract Programmer/Analyst

Responsibilities:

• Production support for manufacturing applications. ORACLE 11g (PL/SQL, FORMS), TOAD, ASP.NET, AS400 COBOL and LINUX are some of the tools and software used in this support role. Includes making enhancements to existing applications’
• Coded PLS/SQL programs to extract and manipulate data from ORACLE DB.
• Also created ORACLE FORMS to extract and manipulate data.
• Created Stored Procedures that were executed by the ORACLE FORMS.
• PL-SQL query writing
• Troubleshooting queries
• ORACLE (PL/SQL, STORED PROCEDURES, TRIGGERS,SQL*PLUS)
• Provided end-to-end development of PL/SQL applications,
• Have successfully completed Linux Foundations course.
• Have successfully completed Oracle 9i SQL course and successfully passed the Oracle certification exam.
• Have successfully completed Oracle 10g Database Administrator course and successfully passed the Oracle certification exam. Oracle Certificate Associate.

Confidential, Houston, TX

Migration Specialist

Responsibilities:

• Was part of a team that migrated applications from a mainframe environment to an ENTERPRISE SERVER environment.
• Mainframe COBOL to Confidential COBOL. DB2 to SQL/SERVER. JCL to bat files.

Data Solutions Specialist

Confidential

Responsibilities:

• Converted data from clients from one format to another using VB.NET, SQL/SERVER, DATA JUNCTION, NET EXPRESS, Confidential COBOL, Micro focus MFEEE, ASP.NET, VISUAL STUDIO, BODS (SAP BusinessObjects Data Services) and bat files in a window environment.
• This reformatted data was then further processed using GMC PrintNet.
• Eventually this reformatted data was use to print and send mailings for the clients.

Confidential, Greenville, SC

Senior Developer

Responsibilities:

• Maintained production support for the datawarehouse and mainframe reporting applications.
• ORACLE (PL/SQL, STORED PROCEDURES, TRIGGERS,SQL*PLUS), COBOL, TSO/MVS, ABEND AID,DATACOM, IDEAL, Expediter, Endeavor, Librarian, FILEAID, UNIX and TOAD were some of the tools and languages used on this project.
• Provided end-to-end development of PL/SQL applications,
• Provided help in worksheet for running queries and scripts
• Maintained production support for the datawarehouse and mainframe reporting applications.

Confidential, Fort Worth, TX

Contract Programmer/Analyst

Responsibilities:

• Created detail design for enhancements to the Regulatory Report System for an independent Oil & Gas company. ORACLE (PL/SQL, STORED PROCEDURES, TRIGGERS,SQL*PLUS), Confidential COBOL, UNIX and TOAD are some of the tools and languages used on this project.

Confidential, Green Bay, WI

Contract Programmer/Analyst

Responsibilities:

• Customized the Virtual Labor Management System (VLM).
• The VLM software is 3rd-party software that schedules personnel at the Confidential Retail stores.
• ORACLE (PL/SQL, STORED PROCEDURES, TRIGGERS,SQL*PLUS), Confidential COBOL and UNIX are some of the tools and languages used on this project.

Confidential, Fort Worth, TX

Contract Programmer/Analyst

Responsibilities:

• Enhanced the Volume Management System (VMS).
• This involved analyzing the existing system to determine what changes needed to be made and the documenting this.
• Also coded Oracle Stored Procedures and Oracle Triggers for the online VMS system (POWERBUILDER) that would validate the data from the online screens.
• ORACLE (PL/SQL, STORED PROCEDURES, TRIGGERS), Confidential COBOL, UNIX and INFOMAKER are some of the tools and languages used on this project.

Confidential, Houston, TX

Contract Programmer/Analyst

Responsibilities:

• Expanded the Vehicle Identification Number throughout all of the applications in the Confidential environment.
• DB2, VSAM, TSO/ISPF, CICS, FILEAID and COBOL were some of the tools and languages used to complete this project.

Confidential, Houston, TX

Contract Programmer/Analyst

Responsibilities:

• Converted the HR/Payroll system from Enpower to PeopleSoft.
• The backend of the system was Oracle and the front end was PeopleSoft.
• Worked mostly with PL/SQL during the conversion.
• Confidential Cobol was also used in an UNIX environment. Also worked with TOAD software.

Confidential, Oklahoma City, OK

Contract Programmer/Analyst

Responsibilities:

• Designed and developed an ORACLE database to track the distribution of products
• Part of a team effort to decommission applications that were being retired as part of the Year 2000 compliance.
• I developed PL/I programs to convert MVS data files to UNIX files to be loaded into ORACLE tables to be accessed via CRYSTAL REPORTS.
• I wrote MVS/JCL to execute the PL/I programs and wrote UNIX scripts to load the ORACLE tables.
• As part of the project, I converted Access applications to Visual Basic applications.

Confidential, Houston, TX

Contract Programmer/Analyst

Responsibilities:

• Converted COBOL-DB2 programs on the mainframe to Confidential COBOL-ORACLE programs on the UNIX.
• I converted MVS/JCL to UNIX scripts. This was done because Burlington was going from the mainframe to client server. The programs were part of the HR application.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Made enhancements to the PREMAS PLUS application. This system allows users to track oil and gas volumes from the well heads to the market. Price Water wrote this system.
• The PREMAS PLUS was developed from the mainframe application, PREMAS. The mainframe application, PREMAS was a COBOL, CICS and DB2 application.
• The PREMAS PLUS application was a Confidential COBOL, GUPTA SQL WINDOWS and ORACLE client server application.
• I developed and enhanced UNIX scripts. From the CICS screens I developed and enhanced GUPTA SQL WINDOWS screens.
• I converted data from the DB2 databases to ORACLE databases.

Confidential, Houston, TX

Contract Programmer/Analyst

Responsibilities:

• Made enhancements to the SRS (Security Request System).
• The mainframe SRS system was written using COBOL II, APS and DB2. EASYTREIVE was used for file extraction and reporting.
• This system allows users to send security requests online (this includes approvals).
• I made enhancements to the HRS (Human Resource System).
• Made enhancements to the RMS

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Made enhancements generated by Confidential standards to the Gas Allocation System (GAS).
• This system allocates gas that flows through the Confidential pipelines.
• The GAS system was a mainframe COBOL II, DB2 and POWERBUILDER application. EASYTREIVE was use for data extraction and reporting.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Assigned to production support on the Volume Allocation System (VAS), Gas Measurement System (GMS), Gas Storage Management System (GSM) and Consolidated Measurement System (CMS).
• These systems allocate and measure gas that flowed through the Tenneco pipeline system.
• Made enhancements to existing systems.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Worked on Physical Design for the Human Resource System.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Developed, tested, and implemented programs for the on-line Security Request System.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Developed, tested, and implemented interfaces between OS/MVS and AS/400 applications such as accounts payable, accounts receivable, etc.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Developed, implemented and supported billing reports using APS AND DB2.
• Created DB2 tables for testing purposes.
• Used Millennium and Viewprint to develop reports for the Dunn & Bradstreet accounting systems (Accounts payable, Accounts Receivable and General Ledger).
• Supported purchasing system.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• converted and implemented an Overtime Equalization System from FORTRAN to COBOL.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Designed, developed and implemented a system to track Medicare claims, which resulted in cost savings for Confidential in that it denied invalid and fraudulent claims.

Confidential, Houston, TX

Programmer/Analyst

Responsibilities:

• Updated and supported a Lab Tracking System for a grease plant. This allowed the user to improve the quality of the products being produced at the Confidential Grease Plant.

Confidential, Houston, TX

Programmer Analyst

Responsibilities:

• Developed, implemented and supported a Gas Plant Accounting System.
• I designed, developed, implemented and supported a system to send 1099 tax data to the IRS through electronic means.