SUMMARY:

• Having led projects in the Order Management, Shipping Execution, and Transportation Management modules, I have practiced several Project Management Methodologies including Agile, Scrum, and Waterfall approaches.
• However, in both functional and technical roles, I have had exposure with many modules in Oracle’s EBS/OTM Suite. My understanding of both technical and functional issues allows me to be very effective in identifying and solving complex business solutions throughout the lifecycle of a project.
• I thrive with my ability to take the user’s needs, understand the functional problem, and present both a functional and technical solution. Combining my technical background with my business knowledge and interpersonal skills, I believe can add enormous value to any project.
• I also have experience working with Oracle and have developed contacts who work with EBS and OTM.

TECHNICAL SKILLS:

Functional and Technical Experience in these Oracle EBS Modules: Order Management, Shipping Execution, OTM, Advanced Pricing, Inventory, AR, AP, Purchasing, Forecasting, OPM

Development & Configuration in OTM: creating Custom PL/SQL Packages, Views, Agents, Screen Sets, Action Checks, VB.NET Websites, SOA/BPEL, Tender Modification (XSL and XML), Pivot Tables, Reports with BI Publisher, Java

Development & Configuration in EBS: creating Custom PL/SQL Packages, API’s, Views, VB.NET Websites, XML Publisher, Personalization’s, Concurrent Requests, Pivot Tables

PROFESSIONAL EXPERIENCE:

Confidential - Saukville, WI

EBS-OTM Techno-Functional Consultant

Responsibilities:

• Worked as a Part Time Remote resource to assist Confidential Steel with Enhancements/Bug Fixes for both OTM and EBS.
• Modified PL/SQL interface code in EBS that sends data to OTM
• Did functional work with Users to define what a new Order Type should be
• See Project Confidential Enhancements Round 1 for more details

Confidential - Olathe, KS

EBS-OTM Techno-Functional Consultant

Responsibilities:

• Solved an OTM Production issue in 2 days that had existed for over a year.
• Using industry best practices, customized the base EBS PL/SQL Packages and Types that are used for interfacing with OTM. Also, customized the SOA/BPEL layer
• Created EBS API and Concurrent Program to update the Delivery Detail Weights when Item Master Weights are changed
• EBS Deliveries will now come into OTM with Special Services, which will ensure the correct Rate is chosen for that delivery
• Researched Ship Unit Optimization in OTM in order to properly rate Parcel and LTL Shipments.
• Worked directly with Users to gather requirements and solve Production Issues
• Identified multiple issues with OTM Rate Structure in Test Environment that was set up before I arrived
• Fixed Rate Structure in Test Environment to ensure Dimensional Weight was being used to Rate when needed.
• Created User Friendly Menus and Screen Sets in OTM
• Heavily Trained Confidential ’s New Hire who was new to EBS-OTM suite
• Assisted in OTM 6.3.3 Upgrade

Confidential - Boca Raton, FL

OTM Techno-Functional Consultant

Responsibilities:

• Fixed Production issues in OTM that were left by previous Consultants which included: Invoice Auto Approval, Custom Integration Issues, Fuel Surcharge Logic, Bugs with Appointments
• Worked directly with Users to gather requirements and solve Production Issues
• Created/Modified Agents, Actions, Action Checks, BI Publisher Reports
• Resolved Miscellaneous Bugs that existed in Confidential ’s Production Environment
• Created User Friendly Menus and Screen Sets, especially helped Appointment Schedulers who were struggling
• Wrote XML specs for Custom Integrations
• Heavily Trained Client’s Business Users, Technical, and Functional resources
• Assisted in 6.3.3 Upgrade

Confidential - Saukville, WI

EBS-OTM Techno-Functional Consultant

Responsibilities:

• Took over as OTM Functional and Technical Lead (Support Lead as well) as other Consulting Company left
• Fixed Production issues in OTM that were left by previous Consultants
• Implemented BI Publisher Reports in OTM
• Fixed Invoicing Rounding Issue in EBS that had existed for more than 3 years.
• Wrote Program to transfer data from EBS Planning System, to EBS ERP System, and then to OTM. Client had a separate instance of EBS for Planning.
• Trained Client’s Business Users, Technical, and Functional resources
• Continued EBS responsibilities as seen below in Project Confidential

Confidential - Saukville, WI

EBS-OTM Techno-Functional Consultant

Responsibilities:

• EBS-OTM Interface Customization and Configuration Lead on OTM Implementation
• EBS Technical Lead and relied heavily for Functional advice in other areas, including OTM.
• Using industry best practices, customized the base EBS PL/SQL Packages and Types that are used for interfacing with OTM.
• Created API’s for Splitting Orders, Auto Creating Deliveries, and mass data changes.
• Wrote custom OTM Packages/Agents when help was needed.
• Assisted in Training, Training Documentation, UPK’s, and Go Live Cutover planning.
• Worked with an Off Site Development Team.

Confidential - Wichita, KS

EBS-OTM Techno-Functional Consultant

Responsibilities:

• Functional and Support Lead of Oracle’s EBS AR, Order Management, & Shipping Execution Modules, the Oracle Transportation Management (OTM) System, and Compliance
• Developed Overall Sales/Purchase Order Lifecycle Strategy.
• Assisted in Implementing Purchasing Module
• Transferred Knowledge of AP, AR, & OM Module to new Functional Lead.
• Transferred Technical Knowledge to new Software Developers, while helping write code.
• Led Training and Regression Testing for my Functional Areas.
• Led the Go Live Cutover planning.

Confidential - Wichita, KS

Business Systems Analyst

Responsibilities:

• Functional and Support Lead of Oracle’s EBS Order Management & Shipping Execution Modules and the Oracle Transportation Management (OTM) System
• Gathered Functional Requirements from Users for new personalization/customizations.
• Lead analyst on International Address Formatting change. Existing business documents needed
• Created/updated PL/SQL packages to call EBS API’s including Create Customer Contacts
• Led OTM Training and Regression Testing
• Led the Go Live Cutover planning.

Confidential- Wichita, KS

Business Systems Analyst- Software Developer Analyst

Responsibilities:

• Gathered Functional Requirements from Users to Improve EBS/OTM Ease of Use.
• Created PL/SQL packages to call EBS API’s including the Autocreate Delivery.
• Updated business documents within Oracle’s XML Publisher (see MAN Implementation)
• Created Pivot Tables in Microsoft Excel for users to see EBS/OTM data at the same time. Favorite new Feature from the project as Users were able to see data relevant to them in one place. The Pivot Tables were based off of Custom EBS Views I created.
• Customized OTM’s Tender specific to FHR’s need. Used XML and XSLT code.

Confidential - Wichita, KS

Business Systems Analyst

Responsibilities:

• Helped create regression test strategy
• Lead OTM/EBS integration tester

Confidential - Wichita, KS

Software Developer Analyst

Responsibilities:

• OTM Technical Lead. One of three developers working on the project. Worked as a team on the EBS Code.
• Coded/Designed VB.NET Website to Attach/Search Documents in EBS via PL/SQL Procedures and Views.
• Coded VB.NET Website for Inserting/Searching Rates into OTM via PL/SQL Procedures
• Used Oracle’s XML Publisher (coded PL/SQL Packages/Procedures and created RTF’s Documents) to create these document types: BOL, Invoice, Order Confirm, Pick Slip, and Ship Confirm.
• Created PL/SQL packages to call EBS API’s including the Create/Update Locations. Used Informatica to retrieve data from Master Data system, and to call the packages.