Summary:

Over 15 years of functional and technical experience in Oracle Applications. This encompasses various phases of implementation, conversion and upgrading including project management, business analysis, programming development, full life cycle implementations, customizations, training, and production support.

Skills Summary

Methods Oracle AIM Methodology Oracle Forms

Techniques and Oracle Tutor Oracle Reports

• Tools Noetix Views SQL Loader
• Oracle Discoverer Visio
• SQL, PL/SQL XML
• Oracle Workflow Axure

Oracle Applications General Ledger Oracle Trade Management

Knowledge through Accounts Payable Cash Management

Release 11.5.10 Accounts Receivable Application Developer

• iReceivables System Administration
• Purchasing Oracle Pricing
• Order Management Advance Collections
• Oracle Shipping Oracle Alert
• Industry Experience Banking Manufacturing
• Telecommunications Insurance
• Retail Travel
• Food Chain

Professional Experience

Sr. Business Analyst

Perform production support on a day-to-day basis. Gather business requirements, write functional documents and perform functional testing for small enhancements to the existing Oracle applications and custom systems. Created a prototype for a fuel tendering system utilizing Axure and then presented first to senior management and then to the subject matter experts in the business. Work with the development team to explain the prototype so development can begin prior to the functional specification being written.

Sr. Functional Analyst,

Part of the Business Improvement Team, the main responsibilities are production support, requirement gathering, release management, help business with testing, identify and recommend process improvements. Lead all meetings regarding business requirements BR030 , functional designs MD050 , process flows BP090 and obtain sign-off on all documentation. Production support was primarily in Advance Collections, Billing, Customer Master and Accounts Receivable.

Senior Application Developer /Analyst

• Converted all AR, Customer, and OM data from a company we acquired.
• Extracted all AR, Customer, OM, GL, and Payables data for a company who acquired us.
• Production support for GL, AP, AR, OM, Trade Management and Pricing. Issues such as AutoInvoice errors, Auto Lockbox processing, AP check processing, AP and AR end of month issues, OM and Shipping issues with scheduling and deliveries, Interface issues with the EDI team and regular day- to-day processing issues.
• Implemented Internal Sales Order, Mass Scheduling, developed Ecommerce Interface into Order Import, Setup defaulting rules, Order Types, Freight Charges, Picking Rules, and Ship Confirmation Rules in OM.
• Devleoped a custom workflow for Order Line approval based on a reason code in OM.
• Implemented settlement by check for TM.
• Implemented PO matching and developed the Payables interface from a Logistics company for AP.
• Defined new Transactions Types, modified Auto Accounting, setup new customers for Lockbox, resolved tax issues, and customized a Commercial Invoice and Pick Slip.
• Implemented a nightly batch from all modules to Auto Post into GL. Setup new sets of books and calendar.
• Changed an existing calendar from fiscal to calendar.
• Wrote a custom form to upload files onto the server.
• Loaded other companies who not using Oracle into the GL interface and then consolidated.
• Develop a program to perform automate pricing and inventory cost updates.
• Customized workflow for account generation in Oracle Trade Management, Order Management, and Invoice Price Variance.
• Customized reports, modify existing reports, gathered requirements, wrote documentation and trained users.

Senior Consultant

• Created a nightly batch process between HR and AP banking information for employee expense reimbursement. The batch process compares banking information for employees who are already setup as suppliers where their banks have been pre-noted in HR. If the banking information is different in AP than it is in HR, it will create the necessary banks or bank accounts, inactivate existing bank accounts, flag the supplier for ACH payments and flag the new bank as the primary on the supplier site.
• In an Oracle hosted environment, Customized the Purchase order, Invoice, Agings, AR Registers and Sale Order Document. Responsible for all custom reporting which included Sales Analysis, Commissions, and Profitability reports.
• Trained a group of people on Discoverer.
• Wrote several flexible reporting extracts for GL which couldn't be done in FSG's across multiple sets of books to be downloaded into excel. Row sets were created using values sets holding the natural accounts in the values.
• Customized the AP check
• Developed a custom NACHA formatted ACH file generation process.
• Created a custom form to input summary Purchasing information, validating vendor and user creation information and wrote reports against the data.
• Wrote several HR reports using Discoverer.
• Developed a gl extract for their expense software Concur.
• Wrote a package to read a flat file and import AP invoices utilizing the Invoice Import. Checked to see if the vendors existed. If they did not, it created vendors utilizing the vendor API.
• Created matrix and tabular reports in Discoverer for HR costing elements 401k, Disability, etc and headcounts.
• The client is implementing Services and Projects and was in need for new Invoice formats. In addition, was responsible for all custom reporting utilizing Oracle Reports 6i and creating views and packages for the Discoverer team which included Commission, Project and Events, Contracts, and Service Request reports.
• Created a sales tax extract using ZIPsales Returns Guidelines in order to create monthly and quarterly sales tax returns.
• Modified the Purchase Order, Pack slip, Check Print and Aging report within their existing modules and aided in some AR setup for grouping rules.
• Creating reports in Oracle Discoverer for Oracle Internal Control Manager ICM . This includes writing several views and functions for a Risk and Control report, Statistical Report for Evaluation and Certification and a Deficiency report.
• Trained several users in Discoverer and creating views.
• Created a Daily Shipment report, Open Sales Order report, Warehouse Inventory report, a Sales Order to be Closed report and completed an already started Batch Ticket Report for Process Manufacturing.
• Responsible for all custom reporting utilizing Oracle Reports 6i for Oracle Applications 11.10 within GL, AP,FA, and PO. This included major customizations in the Purchase Order, Expected Receipts report, Non-PO Accrual report, Positive Pay, Invoice Register and other custom reports specific to this client.
• Created packages to default the buyer on requisitions, and various functions to aid in the report writing.
• Created a package for the Standard NACHA formatted ACH file. Created several reports to help with bank setup issues.
• Worked on a gross margin data warehousing project. The data was extracted on a monthly basis and stored into tables once the transactions had been passed to GL.
• Responsible for training a college graduate with no work experience on SQL, PL/SQL and Reports 6i. Once that was accomplished, spent a couple of days with the more experienced people performing a generic training on Reports 6i and had one-on-one time to answer individual questions on things they were having trouble with. In the meantime, helped with tuning a sql statement and custom reporting.
• Meet with users to gather issues and new requirements on their current version of Oracle Applications 11.5.5 in order to decide if the company should perform an upgrade or reinstall Oracle Applications to version11.5.9. In addition, made recommendations on how to improve their business processes.
• Performed a telecommuting contract, responsible for all custom reporting using Oracle Reports 6i in a new install of Oracle Applications 11.5.9. Custom reporting included the Commercial Invoice, Accounts Receivable Invoice, Pick and Pack Slips, Customer Statements, Survey reports, Sales reports, and CRM reporting. In addition created functions in PL/SQL, queries, tuned existing queries and made recommendations to setup changes in several modules.
• 3I was bringing their France office onto Oracle Applications and needed a custom global Invoice in a multi-language environment for US, Spain, and France.
• Create custom reports such as, the Pick Slip, Pack Slip w/bar-coding, Dunning Letters, AP Check Print, Purchase Order, Receipt Register, and a couple of MRP reports and Inventory reports which were all developed in Oracle Reports 2.5. In Oracle Reports 9i, created many Sales and Financial reports.
• Created new packages, defined Alerts, tuned existing programs, wrote PL/SQL and helped with production support.
• Created new printer drivers for both character and post script when necessary.
• Setup, Develop, test, and document electronic payment programs to produce Oracle Applications AP vendor payment data files using the Barclay's Bank IDC format. Programs were developed for nine sets of books covering six countries and integrated into Oracle Applications as supported custom applications. This was accomplished in SQL Plus.
• Primary responsibility to support AR Billing system
• Helped functional uses solve issues with matching unidentified cash from Lockbox and EOM procedures
• Upgraded from R9 to R10.6 SC which consisted of approx 600 customizations.
• Functional training in PO requisitioning
• Trained in difference between character and GUI with Menus and responsibilities
• Chaired a weekly steering group to co-ordinate, discuss and implement solutions for post migration support.
• Primary responsibility to support AR Billing system
• Helped functional uses solve issues with matching unidentified cash from Lockbox and EOM procedures
• Upgraded from R9 to R10.6 SC which consisted of approx 600 customizations.
• Functional training in PO requisitioning
• Trained in difference between character and GUI with Menus and responsibilities
• Chaired a weekly steering group to co-ordinate, discuss and implement solutions for post migration support.
• Implemented a multi-org full life cycle of Oracle Receivables. Involved Project Scoping, gathering and documenting requirements, GAP analysis from their legacy system, setup, month end procedures and daily process flows.
• Documented Revenue recognition and AutoAccounting processes or ease of client understanding.
• Developed and documented standards for a fully automated interface process flow. It involved, automatically emailing and paging responsible parties when a file is inaccurate, header/trailer records didn't balance, sql loader failed or any other technical cause for failure.
• Customized all aging reports, dunning letters, and other receivable reports.
• Wrote item import and AutoInvoice interfaces.
• Function lead for Oracle Receivables which entailed writing current and future baseline documents, requirements, project scoping, GAP analysis, Reporting Analysis, EOM procedures, Setup, Training and implementation.
• Wrote the GL interface for conversion
• Trained in Dunning Letters and Collections
• Custom reporting for budget analysis between GL,AP PO.
• Technical team lead guiding 5 other technical consultants in an Oracle Managed project.
• Task included conversion of invoices and customers, Vertex, setting up AR, defining coding standardizations, data mapping and gathering business requirements.
• Wrote extracts for customer information using an 833 EDI format and acknowledging and 824 format which contained a legacy customer number
• Wrote extracts for invoicing using a 810 EDI format and acknowledged with an 824 EDI format. The acknowledgement was used to reverse and close the existing invoice. AR was used for recognizing revenue only no receivables .
• Trained in Dunning Letters and Collections
• Custom reporting for budget analysis between GL,AP PO.
• Functional lead for Oracle Receivables. Defined business requirements and implement the business rules for setup.
• Worked closely with the lockbox conversion team to help guide them functionally and technically.
• Successfully implemented a R9.4 to 10.5 migration of Oracle Applications. Coordinated the application of approx 100 patches, the re-application of 200 customizations and performed the full auto-install function.
• Performed many of the interface customizations, including requisition import, invoice import, revenue import and a custom item import.
• Designed and implemented interfaces between the ship board inventory system AMOS-D and the Oracle Applications.
• Lead person in designing, developing, training and implementing the migration from a VAX 8700 to Oracle Applications R9.4.
• Developed a custom Order Entry, Distribution and Sales Marketing system using Oracle forms 3.0, SQR, and PL SQL.
• Lead person in the Antidump Rose case of 1994 Ecuador and Columbia.
• Analyzed, developed and maintained complex applications for various business needs. This involved user requirements, prototyping and solution definition.