SUMMARY:

To obtain a position with an established organization that will positively challenge and grow my Oracle and IT skills. I have over 12 years of functional and technical experience with Oracle Applications E - Business (EBS) ERP, including Financial, Inventory, Warehousing modules and the Procure to Pay process.

TECHNICAL SKILLS:

• 12 years experience with SQL & PL/SQL and Database development
• Oracle 11g SQL querying - case, nested queries, union, Explain Plan, grants, DDL statements, aggregate functions, connect by/prior, with, rage, etc.
• PL/SQL coding - packages, functions, procedures, cursors, exceptions, bulk DML
• Database design - tables, sequences, synonyms, indexes, custom schemas, normalization
• Very familiar with underlying Oracle Tables and APIs including Purchasing Document Open Interface (PDOI), Receiving Open Interface (ROI) & Requisitions interfaces; APPS, FND; APPLSYS, PO, INV, WMS, PA, AP, FA and other APPS schemas
• BI Publisher (formerly XML Publisher) (10+ years experience)
• Oracle Workflow, Stat 5.6, Toad, SQL Developer, Oracle Reports & Forms 6.0 &10g
• APEX 5.1 (10+ years experience - since it was called HTMLDB 1.6 )
• Oracle Applications Personalizations - both in Forms and OAF jDeveloper/OAF/Java development for iSupplier customizations

PROFESSIONAL EXPERIENCE:

Confidential, Le Mars, IA

Systems Analyst

Responsibilities:

• Provide functional, analytical, and technical support (currently the ‘go-to person’) for Oracle Purchasing and also procurement modules iSupplier, iProcurement, Advanced Pricing for Procurement (QP), Mobile Applications for Procurement Approvals and Receiving, WMS (LPN based), and Inventory (Lot controlled) INV modules, Mobile Apps (MSCA), OTM and 3rd party software integration
• Communicate proficiently with and gather specifications from functional users; in turn design, develop and thoroughly test solutions for them, be it via canned functionality, custom applications, enhancements, forms, reports or ad-hoc reporting as well as maintenance of existing objects
• Daily production support and troubleshooting including research and SR creation on My Oracle Support/MOS (formerly Metalink) and testing of any recommended patches or solutions
• Monthly Patch Cycle testing and documentation
• Train and mentor junior team members
• Manage and prioritize workload based on current business needs and projects
• Able to work independently with minimum supervision or equally as well in a team setting
• Projects while on the Inventory Logistics team have included:
• Provide support, documentation, and company-wide training in support of transitioning to a NoPO/NoPay process, so that more users were trained in entering Indirect Requisitions and Receiving in of their own product instead of manually approving and coding invoices after the purchase was already made. iProcurement implementation, training and documentation so that approx 50 of our sales personnel can now requisition specific merchandise products directly, eliminating the need of spreadsheet tracking and workload on procurement personnel
• BI Procurement evaluation (OBIEE) and building custom BI Procurement dashboards for our users
• Setups, Workflow Customizations and testing to implement Purchasing Approvals for Requisitions and Purchase Orders using the Employee-Supervisor hierarchy
• R12 upgrade - from 11.5.10 to 12.1.3 in Nov 2011
• Oracle Transportation Management 6.1 implementation, including customizations to the Sales Orders, POs and AP SOA interfaces iSupplier portal implementation and customizations, including the start of using ASN receipts for our warehouse which greatly reduced receipt times for our warehouse personnel; 4 new custom OAF pages including the Java behind them to display Inventory levels, inventory & forecasted weekly demand, and a page to be able to submit their SMI orders based on those demands which then created automated Requisitions and PO Releases.
• Build and maintain PO and Receiving integration with other systems using the Receiving Open Interface (ROI) for automated receipts including lot and LPN information and RTVs; Purchase Document Open Interface (PDOI) and Requisitions Interface/Import.
• PO Report to custom Print PO w/Terms & Conditions and Buyer’s signature and making use of attachment features to automate emails to suppliers from Oracle and display supplier-specific T&C on the PO
• Workflow Customizations - Familiar with/have customized the PO Create Documents, PO Approvals, Requisitions, PO Supplier Change, Supplier ASN and MTL Transactions Reasons workflows.

Programmer Analyst

Confidential

Responsibilities:

• Provide functional, analytical and technical support for Oracle Financials Suite - Internet Expense OIE, Fixed Assets FA, Projects PA (including implementation), Accounts Payables AP, General Ledger GL, Oracle Purchasing PO and Receiving RCV.
• Meet with and gather specifications from functional users; design and develop custom applications, forms, reports and ad-hoc reporting for end-users; maintain existing database objects and reporting.
• The ‘go-to’ person for Projects, Fixed Assets and Purchasing. Secondary support for AP and iExpense.
• Some of the projects I worked on while in this area included developing several FA interfaces for Mass Additions, Retirements (using Fa Retirement Pub), Asset Update and Distributions History (using FA Asset Desc Pub & FA Transfer Pub packages), Custom XML Publisher reports, Planned Depreciation and Budgeted Assets exports to be used for Hyperion Planning.
• Daily troubleshooting and support of production issues and tickets
• Evaluate and learn new technologies, i.e. Oracle Discoverer and Application Express; and then determine how to best apply to business needs.
• Provide training, standards and documentation for end-users and other developers.

Access Programmer

Confidential

Responsibilities:

• Develop & maintain business applications for different areas of company using Access 2000-XP.
• Assist users with questions or problems they have on Access databases.