Oracle Sap
Resume:
Donna J. Bretz
Home Phone 440-***-****
Summary
I am a senior programmer analyst with experience on RS6000, NT, HP3000 and
HP9000 computers. I have been working with Order Management and EDI in
multiple environments since 1992. I have worked with several Order
Management and Distribution systems and EDI/XML packages. I have designed
the EDI environment for Oracle and SAP ERP systems. I have experience in
documenting business requirements and designing applications, enhancements
and EDI interfaces. I have experience with Oracle and Sybase databases and
I am currently learning SQL Server 2008. Since being laid off, I have been
working with Visual Basic 2008.
Professional Experience
2/07-10/09 EDI Analyst, CTG
* Created new EDI maps and setup trading partners using TLE and
TLW/BizManager
by Inovis and new events in BizLink
* Created new EDI, XML and any-to-any maps, codelists and setup trading
partners
using Gentran NT and GIS; limited experience with Gentran Basic
6.0(mainframe)
* Experienced with the following X12 transaction sets:
210 (Carrier Invoices), 211 (Bill of Lading), 810 (invoice),
820(remittance
advice), 846(Inventory Advice), 850(purchase order), 855 (PO
acknowledgments),
856 (ASN) maps 857(Shipment and Billing Notice), 880 (Invoice) and
996(File
Transfer)
* Created XML to SAP IDoc and SAP IDoc to XML maps for the 856,
940(Shipping Order
Release), 943(Stock Transfer Shipment Advice), 944(Stock Transfer Receipt
Advice), 945(Shipping Notification) and 947(Inventory Adjustments and
Transfer)
* Created gap analysis for EDI transactions including SAP interfaces with
Menlo
Logistics' distribution system
* Enhanced Perl script reports
* Provided daily EDI production support
* Created and executed test plans for EDI and XML documents and reported
issues
to the developers
* System tested maps for software upgrade from TLW to BizManager
* Training for Business Process Modeler
* Modify existing COBOL programs
* Modify JCL using the SCLM utility
5/99-1/07 Sr. Programmer/Analyst, Invacare Corporation
* Supported EDI, XML, Order Management and Shipping transactions in the
Oracle
environment
* Limited PL/SQL experience in customizing Oracle packages
* Worked with Oracle Support to resolve service requests
* Designed Open Application Group (OAG) XML documents for purchase orders,
acknowledgments, advance ship notices, invoices and credit memos,
remittance
advice and lockbox
* Created test plan for all XML and EDI documents and reported issues to
the
developers
* Designed the interfaces between EDI/XML and Oracle applications and
documented
the business rules for the new application environment
* Used Visio to document new EDI environment
* Created Oracle SQL queries to provide ad hoc reports using Toad and
SQLPlus
* Designed and created new audit and control processes between Oracle and
the third
party EDI vendor
* Created new application interfaces and maps for outbound 850 (Purchase
Order),
860 (Purchase Order Change), and inbound 864 (Transaction Text)
* Created new maps for the following: 210 (Carrier Invoices), 214 (Shipping
Status), 810 (Invoice), 850 (Purchase Orders), 855 (Purchase Order
Acknowledgment), 860 (Purchase Order Change) and 867 (Sales Tracing)
using
Inovis' TLE versions 4.1.4 and Version 5.0.
* Designed and developed the Auditrac interfaces for the new EDI
environment
* Created extracts that loaded Oracle databases used by the web
applications
* Documented business requirements and return on investment for proposed
new
projects
* Application development using COBOL, IMAGE and Oracle databases for the
HP3000
environment
* Limited shell scripting experience on RS/6000
2/96-5/99 Sr. EDI Programmer/Analyst, RELTEC Corporation
* Defined and designed EDI transactions for SAP conversion and worked with
SAP
consultants
* Converted existing maps from EDITRAN/EDIMAP (HP3000) to GE's Application
Integrator (HP9000/UNIX) for the Lorain Products Division using SAP IDocs
for
the following transactions: 810 (Invoice), 850 (Purchase Order), 855
(Purchase
Order Acknowledgment) and 860 (Purchase Order Change)
* Created and executed test plan for conversion to SAP and reported issues
to the
developers
* Converted existing maps from three divisions to a new release, assumed
responsibility for daily production and new development (new customers
and new
transactions)
* Used Visio to document new EDI environment
* Documented new application system flow
* Documented business requirements for proposed new projects
* Created new EDI transactions including 820 (Remittance Advice), 852
(Balance
Adjustment), 856 (Advance Ship Notice w/Bar Coding) & 861 (Receipt)
* Created new EDI maps for customer invoices and acknowledgments for
Powercom
* Worked with customers and vendors to determine requirements
1/92-2/96 Sr. Programmer/Analyst, Lorain Products Division of RELTEC
Corporation
* Designed and wrote enhancements for the SATCOM Order Management System,
BOM
costing & other applications using COBOL, TurboIMAGE, KSAM, CISCO and
VPLUS/3000
* Documented new applications
* Documented business requirements for proposed new projects
* Provided user support for Inquizitive/Quiz
* Wrote conversion programs for AMAPS manufacturing to load Sybase database
for
Powerman
* Created new EDI transactions: 143 (Product Change Notice) and 856
(Advance Ship
Notice) (maps and application interfaces)
* Enhanced existing EDI transactions (850, 855 and 856)
* Created custom maps for new EDI customers
Experience prior to 1992 available on request
Education
1985 Bachelor of Arts, Walsh College
Mathematics and Computer Science
Contact this candidate