SUMMARY:

ERP Programmer/Analyst with 25 years of experience. Areas of experience include - SQL, Oracle PL/SQL, Unix and Linux operating systems; Oracle 8/8i/9i/10g/11g/12c. Oracle Applications: Order Entry/Management (OM), Shipping (WSH), e-Commerce Gateway (ECE). Inovis/GXS's BizManager suite. Sterling Commerce’s Gentran Server for Windows NT 4.0/5.0. Creative Logistics InfoShip utilizing Progistics Connectship. Software engineering lifecycle using MIL-STD-2167A and SEI’s Capability Maturity Model. Very highly skilled at troubleshooting and systems maintenance.

EXPERIENCE:

Confidential, Durham, NC

Enterprise Programmer/Analyst

Responsibilities:

• Currently supporting stand up of new data warehouse system.
• Migrating below interfaces to the new environment. Learning, and utilizing, Informatica PowerCenter to facilitate migration.
• Converting existing reports and OBIEE dashboards to Tableau workbooks.
• Developed PL/SQL procedures, functions, views and tables to provide Sales Operations with necessary point of sale (POS), point of purchase (POP), and direct sales shipments and backlog information necessary to evaluate the effectivity of expanding a sales force from 10 to over 150 sales personnel.
• Implemented interfaces to Confidential Suite to replace spreadsheets with sales compensation software. Wrote the transactional data interfaces utilizing PL/SQL to pull data from the Order Management and Accounts Receivable modules of Oracle and transmitted to the Callidus system via SFTP Unix script.
• Wrote the data import interface to pull data files from Callidus via SFTP to be imported into Oracle database tables.
• Implemented the Zyme Data Solutions package to cleanse and track Point of Sale information from electronics distributors. Wrote the PL/SQL interface to extract EDI as well as Oracle ERP data and transmit to the SaaS application.
• Wrote the PL/SQL interface to retrieve the cleansed data from the SaaS application and store in custom database tables to be used in multiple reporting tools.
• Support and maintain the interfaces between the Oracle 11.5.10.2 and 12.0.2 versions of the ERP system and the above mentioned external systems.
• Primary EDI contact. Over 80 percent of order entry transactions are entered utilizing the EDI system.
• Maintain and create new Inovis BizManager trading partner setups.
• Maintain and write new Inovis BizMapper transaction maps to include X12 and EDIFACT transactions supporting the order to cash processes.
• Maintain and create new trading partner setups in the e-Commerce Gateway module of Oracle 11.5.10.2 and 12.0.2.
• Currently working to develop the transactions necessary to support the procure to pay processes as well.

Confidential, Yarmouth, ME

Senior Programmer/Analyst

Responsibilities:

• Design and maintain interfaces between Oracle Order Management and Creative Logistics Solutions (CLS) InfoShip software using Oracle PL/SQL, SQL Scripts, and Visual Basic.
• Interfaces extract order information from Oracle, transmit the data to InfoShip, orders are shipped in InfoShip and shipping data transmitted back to Oracle all with minimal human intervention.
• Support Oracle Applications Order Management, Shipping, Inventory control, Purchasing, Accounts Receivable, and Accounts Payable. Assist super users with troubleshooting abnormal operations and developing new processes to fully utilize system capabilities.
• Designed and implemented solution to utilize Electronic Data Interchange. Integrating Oracle Apps e-Commerce Gateway, Order Management, and Mobile Supply Chain with Gentran Server for Windows 5.0 and InfoShip creating a seamless exchange of order and shipping information between Confidential and its customers.
• Troubleshoot system issues, re-writing source code as necessary, creating new packages if needed. Write and maintain reports as requested. Extract and analyze business data for all departments.
• Successfully upgraded Oracle 11.0.3 to 11.5.9, specifically the Order Entry module upgrade to Order Management and interfaces with Creative Logistics Solutions’ InfoShip shipping software.
• Successfully upgraded Oracle 11.5.9 to 11.5.10, concentration on interfaces to third party apps and assisting with all modules.

Confidential, San Antonio, TX

Computer Programmer/Analyst

Responsibilities:

• Design and maintain interfaces between Oracle Order Management/Release Management, Gentran Server, and Data National software using Oracle PL/SQL, SQL Scripts, Unix Scripts and some Visual Basic.
• Interfaces extract EDI data from Oracle, transmit the data to Gentran where it is translated and transmitted to the customer/supplier and retrieve customer/supplier data from Gentran, re-format it to Oracle and Data National specifications.
• Write Visual Basic and Unix scripts as developer tools used by peers.
• Mostly re-formats computer readable files to human readable for testing and troubleshooting purposes.
• Integrate new customers and suppliers into the Oracle and Gentran systems creating trading partner records in both systems and, if necessary, writing trading partner specific code to handle unique situations.
• Troubleshoot system issues, re-writing source code as necessary, creating new packages if needed. Saw the need to transfer Supplier EDI data handling from Alcoa Corporate to our local systems, re-wrote the interface saving approximately $1,700 per month in excess EDI costs.
• Implement unused functionality in the Oracle Applications relating to EDI. Helped design streamlined output document definitions to implement standard Oracle functionality for outbound Shipping Schedules ( Confidential /862).
• Mapped the output using Gentran to ANSI X-12 format for transmission to suppliers.
• Successfully upgraded Oracle 11.0.3 to 11.5.8, specifically the Order Entry module upgrade to Order Management, E-Commerce Gateway and Release Management.

Confidential, Keesler AFB, MS

Senior Computer Analyst

Responsibilities:

• Designing user interface to add student records to the Technical Training Management System (TTMS) utilizing Delphi 5.
• Allows users to quickly and easily add new students to the system without requiring the startup of the main application.
• Redesigning the database and interface between the TTMS and the Confidential Training Management System ( Confidential ).
• Utilizes direct SQLNet connections between the geographically separated systems rather than transferring flat data files.
• Began analyzing existing data structures and queries to optimize the performance of the system.

Confidential, Keesler AFB, MS

Software Developer

Responsibilities:

• Supervised 27 programmer/analysts integrating the Plateau student management program into the Technical Training Management System (TTMS)
• Evaluated and helped select Commercial Off-the-Shelf (COTS) products to replace our developed software.
• Assisted in designing the Oracle database to facilitate the use of Plateau in the Confidential Technical Training environment.
• Developed six Oracle PL/SQL scripts to facilitate inputting existing courseware documents into the TTMS database.
• Supervised and assisted in the development of the interface between the TTMS and the Confidential Training Management System ( Confidential ) consisting of Oracle PL/SQL and Unix Korn shell scripting.
• Worked with customers collecting data and developing business rules for implementing resource tracking in the TTMS.
• Managed the drawdown of military personnel turning over the TTMS project to contractors.
• Developed a web based paging system.
• Wrote Microsoft Visual Basic program to accept a pager ID and text message from a web server and send it to a Confidential M-15 Paging Terminal through a serial cable using the Telocator Alphanumeric Protocol.
• Created an HTML web page front end as the user interface.
• Created a web accessed database to allow departing personnel to keep in touch with each other. Utilizing HTML, PHP, and MYSql, created a directory listing of web links, e-mail addresses, and ICQ accounts dynamically controlled by the departing personnel to maintain their personal contact information.
• Enhanced an existing administrative tool written in VBA for Microsoft Access.
• Existing program tracked personnel leave actions, vehicle registration records, and performed rudimentary database administration actions.
• Repaired numerous software defects with backing up and restoring data, data was actually being deleted.
• Added functionality to suspense and track personnel reports and award packages, schedule dental and physical exams, automatically notify personnel of required actions.
• Wrote VBS script to extract, reformat, and send data from a flat text file through E-Mail.

Confidential, Keesler AFB, MS

Software Developer

Responsibilities:

• Supervised 15 programmer/analysts developing the Course Confidential of the Advanced Training System overseeing all phases of software development from requirements analysis through Quality Assurance evaluations and delivery.
• Analyzed software requirements for the Course Development Confidential and reduced the number by 350 from over 490.
• Established only critical requirements for the transition from developed to COTS software.
• Developed the software development process for our unit. Achieved CMM Level 2, was ready for Level 3 when evaluation was canceled.
• Performed maintenance on the Course Confidential consisting of over 270,000 lines of Ada and D code.
• Designed and coded new module to in corporate a new element into an already existing hierarchical data structure.
• Troubleshot and repaired over 400 software defects.
• Supervised the development of two administrative programs.
• A program to monitor the Confidential purchasing program and a personnel performance feedback report tracking program, both written in Microsoft Visual Basic.

Confidential, Castle AFB, CA

Senior Quality Assurance Inspector

Responsibilities:

• Supervised 4 Quality Assurance inspectors.
• Performed Quality Assurance inspections on the armament systems and associated ground equipment for B-52 H aircraft.
• Performed Quality Assurance evaluations on aircraft armament personnel
• Performed acceptance inspections on contracted modifications to aircraft and armament systems prior to Confidential use.
• Prepared briefed detailed analysis reports from all inspections and evaluations performed on the Wing aircraft, equipment, and personnel.