SUMMARY:

• Oracle Applications EBS Analyst/Developer with over 20 years of ERP experience resulting in technical solutions to improve and streamline business processes
• Taleo Cloud Implementation
• Oracle EBS R12 upgrade from 11i
• Multiple Oracle 11i implementations
• Kronos Upgrade from Version 6 to 8
• SAP R/3 FI implementations
• SAP BW/Business Objects DW
• Team Lead experience
• Technical/Functional Designs and Specs
• Project planning and issues management
• Functional and Gap analysis
• Oracle Framework using Jdeveloper
• Oracle Reports 6i and 10g
• Oracle Forms 6i and 10g
• Oracle Discoverer 4i and 10g
• Oracle Workflow
• Toad/SQLDeveloper
• PL/SQL and SQLLoader development
• Unix Shell Scripting
• XML Publisher
• CPA
• Accomplished Toastmaster

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Oracle Developer

Responsibilities

• Managed and developed Discoverer 10g security and folders for reporting
• Designed Discoverer views to allow for ad - hoc reporting by business users with appropriate aggregate computations
• Designed and developed multiple Discoverer and XML Publisher reports for operations and finance reporting
• Modified and managed Fast Formulas for changes in payroll computations
• Technical support for multi-org EBS installation of AP, GL, AR, PO, OM, HRMS, Payroll, and Inventory
• Implemented Taleo talent acquisition cloud solution, including using Taleo Client Connect to migrate data and create interfaces to Oracle EBS
• Implemented Positive Pay bank feeds for multiple bank accounts to JPMC
• Managed Upgrade from 11i to R12 for Oracle EBS for finance applications
• Managed Upgrade from Kronos Version 6 to Version 8
• Managed Service Requests via My Oracle Support for Oracle EBS and Taleo Cloud
• Developed iStore java enhancments as well as EBS OAF java customizations

Confidential, Phoenix, AZ

EBS Lead Analyst/Developer

Responsibilities

• Upgraded Oracle R11 to Oracle R12, focusing on the iProcurement and Finance Modules (Fixed Assets and Cash Management)
• Support and develop cash management bank reconciliation feeds for multiple banks
• Designed and developed interfaces to send indicative data to benefits providers for the Oracle HR system
• Developed Discoverer Sox reports to identify access and personnel information to auditors
• Customized EIT fields and developed API interface in Oracle to load/track additional information for employee certifications
• Designed, developed, and implemented a purchasing blanket purchase order “pre-approval” process, including process analysis, customized workflows, Oracle Framework pages, and PL/SQL
• Implemented Oracle Framework personalizations including adding additional fields to screens via VO and CO changes as required for iProcurement Catalog/cXML processing
• Developed IFRS Discoverer reporting to determine impact on accounting standard changes to leased assetsImplemented Asset Reclass and Life Change Uploads via SQL Loader and PL/SQL
• Developed multiple XML Publisher reports for purchasing, including bursting options for email delivery to different groups
• Developed Oracle Alerts for warning notifications based on specific purchasing limit criteria
• Supported iProcurement Punchout to three suppliers, including troubleshooting cXML transactions via https

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilitiese

• Implemented Oracle 11i Accounts Payable and Cash Management as lead functional and technical resource, including bank interfaces for positive pay and bank reconciliation from BAI format
• Managed interfaces and links from SQL Server database into inPowerSuite Order Management System
• Designed, developed, and implemented the General Ledger Revenue and Inventory interfaces between InPowerSuite Order Management system and Oracle 11i
• Designed, developed, and Implemented payment interfaces to Bank of America and automated cash reconciliation in Oracle Cash Management
• Designed and developed multiple Discoverer and XML Publisher reports for operations and finance reporting
• Modified 11i costing workflow to allow for multiple material accounts under FIFO (layer) costing method

Confidential, Phoenix, AZ (Independent Contractor)

Data Warehouse Architect

Responsibilities and Achievements:

• Developed project plan and resource requirements for SAP data warehouse implementation.
• Analyzed SAP manufacturing, materials management, and sales and operations planning business processes and generated process flows and data warehousing ERDs.
• Implemented and Developed ETL (Extract, Tranfer, Load) code for transfer of data from SAP BW to Business Objects data warehouse using Business Object’s Data Integrator tool
• Developed reports in Business Objects to support SAP business process

Confidential, Goodyear, AZ

Senior Oracle Analyst and Developer

Responsibilities and Achievements:

• Implemented Oracle Advanced Pricing to improve invoice accuracy and reduce deductions. Performed project planning and resource coordination. Developed Autoinvoice interface modifications, Advanced Pricing reports, and custom Advanced Pricing API PL/SQL.
• Managed upgrade to Oracle EBS 11.5.9, leading team of 10 functional users. Executed to project milestones and managed issue resolution, testing phases, and impact assessments.
• Enhanced and Developed business reporting via Order Exception, Daily Shipment, and other business reports using Reports 6i.
• Launched user Ad-Hoc reporting tool, Discoverer 4i, to streamline reporting process.

Confidential, Scottsdale, AZ

Senior Consultant

Responsibilities and Achievements:

• Led discussion with business steering committees to identify and priortize projects, and review in-progress efforts
• Upgraded System ESS Order Management System to latest release. Created project and testing plans. Supervised risk management and issue impact. Trained end users in release modifications.
• Enhanced Order Management solution to enable 24/7 order processing and 48 hour order turnaround. Designed technical/process flows and developed Unix shell scripts, Oracle Reports, and Oracle Forms to enable EDI 850 error processing and immediate pick ticketing.
• Implemented SAP R/3 (FI) Module. Completed functional and technical design documents for Accounts Receivable. Developed customer, open receivables, and credit information conversions via Business Connector. Mapped IDocs for EDI 820/823 lockbox interface.

Confidential, Saint Louis, MO

Consulting Services Manager

Responsibilities and Achievements:

• Managed Finance team of 3 individuals for an Oracle 11i implementation with a global manufacturing client, including Accounts Receivable, General Ledger, Accounts Payable, Cash Management, and Purchasing modules. Performed process modeling and design for all operating units (UK, Australia, and US). Directed all phases of testing and development, and managed workplan deliverables.
• Led Oracle CPG Trade Accounting implementation at Fortune 500 Consumer Products company with a team of 4 individuals. Performed functional GAP analysis and configuration of Trade Accounting package. Executed unit, system, and user acceptance testing and managed workplan activities.
• Developed EDI820/823 Lockbox customization to Trade Accounting package to capture deduction reason codes and improve discount calculation accuracy.
• Implemented Oracle Purchasing at a Fortune 500 Consumer Products company as technical manager of team of 5 developers. Developed technical plan and managed unit testing, system testing, and user testing. Developed PO conversion interfaces.
• Managed Finance team Release 11 multi-org implementation with a global telecommunications client. Managed team of 3 individuals, comprised of technical and functional resources. Completed high-level process flows, functional design documentation, and QA testing.