Oracle E-business Suite Consultant Resume
SUMMARY:
- 25+ years of I.T. Management Experience:
- Project leader for multiple Oracle ERP implementations and upgrades 11i to R12.2.3
- Oracle Financials Cloud General Ledger Certified: IZ0 - 960 Oracle Financials Cloud General Ledger 2017 Implementation Essential.
- Skilled in GL Chart of Account Design
- Skilled in the recruitment, development and management of high performance I.T. functional/technical teams.
- Experienced in developing Oracle Centers of Excellence that stress best practices and attainment of maximum Confidential .
- Led the successful implementation of an offshore India development project with a peak of 35 offshore developers and 5-10 on-shore support personnel.
- Project Manager for several acquisition absorption projects involving the purchase of firms in the 50-250 million dollar revenue range and their rapid absorption into Corporate I.T. Systems.
- Leader of custom development projects of 2-3 years duration with budgets of 5-20 million USD.
- Led high profile business re-engineering projects involving global operational areas, procurement, HR-Payroll, financials, project accounting and SCM..
- Thorough understanding of Sarbanes Oxley and its impact on I.T. and Business Groups.
- 21 years of Oracle E-Business Suite experience:
- Recently led an Oracle R12.1.3 upgrade for global footprint client with financials, manufacturing, HRMS-Payroll, EAM and Agile.
- Led an Oracle R12.1.3 implementation for Brazilian manufacturing operations of a U.S. based firm.
- Experienced in Peruvian, Brazilian and European localizations including VAT reporting areas.
- Hands-on experience in leading and hands-on configuration for 12+ Oracle Implementation/Upgrade Projects including extensive foreign operations, multi-org and multi-currency requirements.
- Have done hands-on work with absorbing legacy systems into Oracle 11.x and 12.x environments including Receivables, Payables, General Ledger, Inventory, Payroll, Human Resources, Projects and Grants conversions and custom interfaces.
- Skilled in E-Business Tax configuration for U.S. and foreign taxation requirements.
- Skilled in development and delivery using numerous delivery platforms.
- Skilled in technical and functional areas of E-Business Suite financial modules, procurement and inventory, including hands-on configuration.
- Expert knowledge of the E-Business Suite database schema, technology stack, workflow/business events, alert and production management areas.
- Experienced in developing Sarbanes Oxley compliance reporting, controls, control matrices and detailed functional test scripts.
- Strong Business Intelligence experience that includes national Confidential .
- Winner of DM Review Magazine 2007 Innovative Solutions in the Business Intelligence/Analytics category.
- Experienced in business quality improvement sciences including project leadership of business re-engineering teams.
- Skilled in the practical application of quality programs like Value Stream Mapping, Six Sigma and other TQM methodologies.
- Past presenter at national OAUG conferences.
ORACLE SKILLS SUMMARY:
- Master Level (21 years) Functional Experience in: General Ledger (including federal financials), Payables, Receivables, Fixed Assets, E-Business Tax, Cash Management, Treasury, Alerts, iSupplier, iReceivables, Project Accounting Rules, Sub Ledger Accounting (SLA), Discoverer, FSG reporting and Web ADI including development of complex custom integrators.
- Intermediate Level (5-10 years) Functional Experience in: Projects, Grants, Inventory (including in-depth standard costing configuration), Order Management, iProcurement, Payroll, Human Resources, Workflow, e-Commerce Gateway and Business Events.
- In-depth knowledge of SQL, PL/SLQ, Oracle API’s including REST API’s for Cloud and all major back-end tables.
- In-depth knowledge of standard interface flows and tables.
TECHNICAL SKILLS:
Technical Tools utilized: Oracle Workflow Builder/AME, SQL Navigator, TOAD, PVCS, Noetix Enterprise Technology Suite, MS Office, Harvest Lifecycle Manager, SQL Developer, uPerform, ePrentis
PROFESSIONAL EXPERIENCE:
Confidential
Oracle E-Business Suite consultant
Responsibilities:
- 21 years functional configuration, optimization and production support Oracle E-Business Suite (detailed in skills summary above)
- Work with clients has consisted of full implementations, upgrades and extensive business process improvement for existing Oracle implementations helping to reduce overall cost of ownership and streamlining upgrades.
- Elimination of customizations with out of the box Oracle functionality.
- Optimization of daily, monthly and year-end processes.
Confidential, Harrisburg, PA
Sr. Oracle Lead Financials Consultant
Responsibilities:
- Performed analysis of the existing Chart of Accounts and deficiencies.
- Using Confidential Software tool for full conversion of 10+ years of Chart of Accounts data.
- Working with financials area for specific process improvements centered around Oracle Financials:
- Developed Supplier Upload ADI template to improve high volume entry of new Suppliers.
- Working with Cash Management area to improve auto-reconciliation percentages.
Confidential, Athens, OJ
Sr. Oracle Lead Financials Consultant
Responsibilities:
- Performed analysis of the existing Chart of Accounts and deficiencies.
- Worked with project team to recommend and prototype a new Chart of Accounts and new GL processes
- Using Confidential Software tool for full conversion of 10+ years of Chart of Accounts data
- Used both standard balancing segment to balancing segment and split balancing modules.
- Performed extensive Excel work within Confidential conversion sheets to meet client needs and enable advanced conversion techniques to meet client requirements.
- Performed custom Payroll costing KFF conversion.
- Based on usage of tool and interaction with Confidential on this project became formal partner with Confidential
- Worked with functional Grants/Project teams on conversions, interfaces and advanced Auto-Accounting setup including usage of SLA rules.
- Utilized Oracle WEB ADI extensively to enable mass load or Grants/Project Expenditure data, lookup sets and HR Org update and additions.
- Wrote custom Purchasing conversion, using standard Oracle API’s, to convert existing Project Task distributions to Project, Task, on open PO distributions eliminating need for mass manual reentry of PO’s/
Confidential, San Antonio, TX
Sr. Oracle Grants and Project Accounting Consultant
Responsibilities:
- Analyzed current deficiencies in endowment accounting with Grants and Project Accounting
- Analyzed current deficiencies in GL Chart of Account Design
- Performed hands-on reconfiguration of Grants and Project Account to enable full endowment processing within Grants and Projects.
- Eliminated need for manual GL Journals and resulting error-prone reporting.
- Recommended a COA redesign using Confidential conversion tool to overcome numerous COA limitations.
Confidential, Miami, Fl
Oracle Project Manager
Responsibilities:
- Managed development of global E-Business Suite curriculum both Instructor led and eLearning for Oracle R12 financials.
Confidential, Evansville, IN
Sr. Oracle Lead Financials Consultant
Responsibilities:
- Re-Implementation of Cash Management, eliminated customizations.
- Implemented iSupplier with primary emphasis on supplier self-registration and self service capabilities
- Resolution of various functional and technical issues in Receivables including refund processing, receipt reversal issues, lockbox processing and month-end closing.
- Resolved issues with Projects to AP interface kick outs involving multiple issues and required patches and data fixes.
- Resolved issues with passing of supplier discounts from Projects to AP.
- Recommended standard solutions involving Business Events and Alerts to eliminate custom triggers and other custom processes in Oracle Projects.
- Resolved inability to reconcile AP, Projects and AR to GL at closing time by implementing usage of Oracle recommended reports and processes.
- Developed and implement standard Oracle recommended closing processes for all financial modules.
Confidential, Portland, Oregon
Project Manager/ Sr. Oracle Lead Financials Consultant
Responsibilities:
- Coordinated end-user acceptance testing and problem resolution
- Implemented Cloud using Oracle rapid implementation approach
- Primary emphasis was on receivables and intercompany accounting areas to determine if the client’s significant customizations were solved by new features or could be configured to work at a minimal level without customization.
- Working prototype was acceptable for financials however counterpart configuring Cloud SCM found it to be immature and unacceptable.
- Project was tabled for future consideration as SCM area matured.
Project Manager/ Sr. Oracle Lead Financials Consultant
Confidential
Responsibilities:
- Hands-on configuration of Cash Management and Treasury to support Europe, Canada and U.S. Operations.
- Custom Interface from Bloomberg FX Trading Software to Treasury
- Designed and implemented custom cross legal entity AP-AR Intercompany Settlement/Netting solution.
- Researched and resolved numerous AR interface issues with stuck invoices and developed custom alerts to notify of AR interface issues when they happened.
Confidential
Project Manager
Responsibilities:
- Enhanced existing iSupplier implementation to allow:
- Direct entry of PO related invoices
- Configured system to allow for proper default and recording of US and Canadian taxes at invoice entry time
- Configured supplier self-registration and custom workflow approvals
Project Manager
Confidential
Responsibilities:
- PM for financials, manufacturing and HRMS-Payroll implementation of 3 Operating Unit Brazilian operations.
- Managed implementation of Brazilian Tax Engine, Integrated Receiving, Synchro and Softway (third party import and regulatory reporting solutions) via sub-contracted Brazilian consulting team.
- Worked with third party vendor to convert existing uPerform material to Portuguese.
Project Manager/ Sr. Oracle Lead Financials Consultant
Confidential
Responsibilities:
- Managed complete R12 upgrade including DBA, functional leads and internal users.
- PM work included Earned Value Management (EVM) 10 step process for reporting project status.
- Conversion of 50+ multi-currency operating units and legal entities spanning Europe, Asia, South America, Australia, New Zealand and Africa.
- This project included extensive coordination with regional operating units to support overall system testing and regional specific localization testing including European VAT reporting requirements. Those operating units were located in:
- Belgium, servicing Belgium, France, Germany and Russia
- United Kingdom, servicing the UK and South Africa
- China
- Australia
- Canada
- Over 150 inventory organizations.
- Configured E-tax for 50+ Operating units and currencies.
- Development and Delivery
- Led team of 5 developers modifying and creating new material for R12 specific changes.
- Performed hand on development of material using uPerform for all financials modules including procurement.
- Delivered in financial and uPerform to global user groups during user acceptance testing sessions.
- Upgrade included iReceivables implementation
- Completed on schedule and under budget.
- “This was the smoothest, most problem free major upgrade in my professional career” Brad Hahn, Confidential Executive VP and CIO