Oracle Developer

Steven P. Moses

**** ***** **. ********, **. ****8 - 303-***-**** - ********@***.***

Objective

Senior Oracle Apps Developer/EDI Analyst

To apply my extensive Information Technology expertise to a position that will be both challenging and rewarding

Summary of Work Experience

• Twenty eight years of diversified computer systems integration experience.

• Nineteen years of relational database management system (RDBMS) analysis, design, development, support, diagnostics, and test including ten years of client-server development using PL/SQL, Oracle Developer/Oracle Designer development tools

• Extensive experience in Oracle Apps E-Business suite which includes: Manufacturing (BOM), Inventory (INV), Order Management (OM/ONT), Shipping (WSH), Purchasing (PO), Receivables (AR), Payables (AP), and Electronic Commerce (EC) modules as well as many custom interfaces. Have created and integrated many complex custom enhancements using Oracle Forms, Oracle Reports, stored functions/procedures/packages, workflow, alerts, SQL, Unix and Windows host scripts and custom interface table sets/extensions

• Was heavily involved in Oracle Apps upgrades from 10.7 SC to 11.05 to 11i and Oracle RDBMS upgrades from 7.3.4 to 8i to 9i to 10i

• Six years of Electronic Data Interchange (EDI) installation, configuration, map development, test, and support using EDIOPEN and Inovis Trusted Link Enterprise (TLE). Implemented a complete, professional, high integrity TLE-based EDI system integrated with Oracle Apps from scratch. (including Mapping Workbench, Operations Center, batch files)

• Three years of Data Warehousing including Business Objects reports development and scheduling, and Data Integrator Extract, Transform, and Load (ETL) development

• Two years of TIBCO EAI installation, configuration, development and test using Business Connect, Business Works, Oracle and File Adapters, Hawk, (EDI.X12 / RosettaNet)

• Five years of Novell NetWare network design, implementation and management including the integration of Windows and Macintosh computers

• Seven years of Field Engineering Support Services experience providing design, test, integration, troubleshooting, and customer interface services for a wide range of computer hardware and software products

Education

• A.A.S., Electronics Technology, Trinidad State Junior College, Trinidad, Colorado - 1981

• A.A.S., Computer Technology, Trinidad State Junior College, Trinidad, Colorado - 1982

• Introduction to Oracle, Oracle Forms 4.5, Oracle Reports 2.5, Oracle Database Administrator (DBA)

• Oracle Apps - Manufacturing Module Technical Foundation

• Oracle Apps - Order Entry

• Oracle - Advanced PL/SQL

• Inovis TLE EDI Mapping/Advanced EDI Mapping

• Business Objects – Data Integrator

• Data Warehousing Fundamentals – Richard Kimball

• TIBCO Business Connect 3.5

• TIBCO Business Works 2.x

• Introduction to JAVA and HTML

• UNIX Operating System

• Hyperion EssBase

• Formal Novell NetWare - System Manager, Advanced System Manager and Macintosh for NetWare training

• College-level courses in Data Communications, Pascal Programming and Interpersonal Communications

• DOD-certified in Electro-static Sensitive Device (ESD) handling, soldering and wire-wrap

• Wide array of technically-oriented classes, seminars and industry training

Security Clearances Held

• DOE Q (inactive)

• DOD Secret (inactive)

Employment History

Iomega Corporation (Roy, UT) - Oracle Systems Analyst, 1998 – Present

• Provide system, process and database analysis, development and refinement using Oracle Developer/2000 front-end development tools in global Oracle 10.7 and 11.03, 11.5.9, and 11.5.10 (11i) Apps environments

• Have acquired extensive experience in Oracle Apps Manufacturing, Inventory, Order Entry, Shipping, and Finance modules from both a technical and functional perspective

• Functioned as a technical lead in Oracle Apps upgrades from 10.7 to 11.0.3 from 11.0.3 to 11.5.9 and from 11.5.9 to 11.5.10 (11i) and in a TIBCO upgrade from 1.x to 2.x

• Developed Order Management 3PL interface to/from 3rd party logistics partner (Modus)

• Transitioned Order Management 3PL interface to new 3rd party logistics partner (Globalware)

• Provide Electronic Data Interchange (EDI) platform development and support using Inovis Trusted Link Enterprise (TLE)

• Currently migrating EDI platform from Harbinger EDIOPEN to Inovis Trusted Link Enterprise (TLE)

• Negotiated substantially reduced Value Added Network (VAN) rates

• Developed numerous complex PL/SQL programs, stored packages, procedures, internal and external interfaces, custom forms and reports using Oracle Forms 4.5/6i and Oracle Reports 2.5/6i

• Developed a PL/SQL application to bill customers for non-returned products on Advance Ship RMA’s that generates upwards of $300,000/year in income and returned products. As part of this effort, coordinated with UPS to acquire UPS tag usage data via EDI and integrated an Advance Ship Mapping System into Oracle

• Developed and integrated into Oracle Apps, a custom Bank of America EDI Accounts Payable checks and wires system for the US and Europe, utilizing EDI 820/831 and EDI 824 responses with associated forms and reports and alerts for reconciliation and error advisories

• Developed and integrated a Budget Import Workbench into Oracle Apps allowing automated load from a text file produced by a 3rd party tracking tool (EssBase), pre-validation of cost centers, cross-mapping, and automated load to the GL Budget Interface for subsequent processing by the Oracle Budget Loader program. This project reduced redundant data entry tremendously

• Developed and integrated an Accounts Receivable Import Workbench into Oracle Apps allowing automated load from a text file produced by a variety of sources, pre-validation and approval of credit memos, and automated load to the AR Interface for subsequent processing by Oracle AutoInvoice. This project reduced redundant data entry tremendously

• Developed numerous complex electronic interfaces for outsourced manufacturing, shipping and receiving partners including Solectron, Venture Mfg, Banta, and Modus Media using custom tables, stored packages, procedures, and TIBCO (EDI.X12/RosettaNet)

• Developed custom extensions to the Oracle Service module to extract serialized product data from outsourced partner system and update Oracle Service accordingly

• Developed and integrated into Oracle Apps, a Custom Functionality Tracking System to provide Configuration Management capability as well as automated creation of project migration instructions for subsequent use by the DBA’s

• Developed and integrated into Oracle Apps, a Responsibility Ownership System to provide Configuration Management and security for Oracle responsibilities and the users’ possessing them

• Used TIBCO Business Works 2.x including Designer to develop numerous processes including use of Business Connect 3.5. Possess a strong knowledge of these tools from installation, development, test, and support standpoints

SCIENTECH, Inc. (Ogden, UT) - Systems Analyst, 1995 – 1998

• Provided process and database analysis, development and refinement using Oracle Developer/2000 front-end development tools

• Developed complex Oracle Forms 5.0/Reports 3.0 development for the USAF’s Integrated Missile Database (IMDB) as a subcontractor to Battelle. Was part of Battelle’s effort to achieve SEI CMM Level II certification

• Worked as a lead developer on the USAF’s Command Core System (CCS) as a subcontractor to BDM in a client-server environment using Oracle Forms 4.0/4.5 and Oracle Reports 2.0/2.5 front-end tools

• Wrote a database attribute tracking application in Microsoft Access

• Performed numerous technical and performance studies

• Trained Junior Developer’s on the USAF Command Core System in development techniques, and site standards

• Wrote numerous internal white papers, technical reports and database application user's guides

Belfort E&ES, subsidiary of SCIENTECH, Inc. (Albuquerque, N.M) - Systems Analyst, 1994 - 1995

• Provided process and database analysis, development and refinement, Network Management, Computer Support, technical writing, and training

• Developed numerous custom relational database applications for internal and DOE customers using Paradox and MS Access. Among these were: an ES&H Regulatory Compliance Tracking System, a DOE Tiger Team Finding Tracking System, a Travel Commitment Tracking System, a Purchase Commitment Tracking System, a Hardware/Software Tracking System and a Cost Reporting System

• Developed skills in creating positive working relationships with demanding DOD, DOE and private sector customers.

• Attended the Paradox Developer's conference on two occasions, the Microsoft Access conference and the Oracle Developer's conference.

UNC Analytical Services Inc. (Albuquerque, N.M) - Computer Specialist, 1990 - 1993

• Provided process and database analysis, development and refinement, Network Management, Computer Support, technical writing, and training

• Designed, purchased, installed, tested and managed a Novell NetWare Ethernet network (LAN)

• Installed and implemented corporate e-mail capabilities

• Installed and configured server-based Windows 3.1 as well as numerous DOS and Windows applications. Worked with Palindrome Network Archivist and Cheyenne ArcServe file server backup software

• Developed numerous custom relational database applications for DOE customers using dBASE IV including a Radiological Assistance Team (RAT) Training Tracking System

• Provided hardware and software support services

• Evaluated, acquired, installed, tested and maintained a wide array of computer, data communications and peripheral hardware

• Was the Deltek Accounting System technical point of contact for over three years. Attended the Deltek user's conference

• Supported the Macintosh and Windows operating environments and many applications including WordPerfect, Word, Quattro Pro, Lotus 1-2-3, Excel, Paradox, dBASE IV, Access, Freelance Graphics, Harvard Graphics, PageMaker, Canvas, MacDraw, ProComm Plus, cc:Mail for DOS, cc:Mail for Windows, cc:Mail for Macintosh, cc:Mail Mobile, and cc:Mail Router

• Attended the Comdex computer convention on numerous occasions

• Trained local and field employees in DOS, Windows, WordPerfect for Windows and cc:Mail for Windows

Unisys Corporation (formerly Sperry) (Various Locations) - Field Engineer, 1985 - 1990

• Provided field engineering, systems integration and test, technical writing, programming, procedure development, computer support, and training services as necessary. Was part of an eight man tiger team based in St. Paul, MN providing on-call technical support services to field-site customers throughout the U.S.

• Acted as a technical liaison to the Air Force Communication Nodal Control Element (CNCE) communications shelter

• Spent one year in Orlando, FL. as part of the Hardware/Software Integration Test (HSIT) process, six months at Fort Huachuca, AZ. for the Follow-on Test & Evaluation (FOT&E) effort and three years at McClellan AFB, Ca. providing system support for the Software Maintenance Facility (SMF)

• Authored numerous computer and system troubleshooting manuals

Sperry Corporation (Various Locations) - Field Engineering Assistant, 1982 - 1985

• Provided field engineering, systems integration and test, technical writing, programming, procedure development, computer support, and training services as necessary

• Performed Configuration Management and expediting duties for field-sites

• Was part of a three man team which installed and tested Sperry hardware and software on the FAA's Automated Radar Traffic System (ARTS-IIIA) update project at numerous airports throughout the U.S.

• Gained familiarity with a variety of test equipment including logic analyzers, breakout boxes, frequency counters, oscilloscopes and multi-meters

• Received formal training and became DOD-certified in Electro-static Sensitive Device (ESD), soldering and wire-wrap techniques

• Trained junior Technicians and Field Engineering Assistants in proper hardware and software troubleshooting techniques for a variety of Unisys products

• Authored numerous computer and system troubleshooting manuals

References

Many references available upon request

Contact this candidate