Experience

AWAS

• Ireland
• Airlines and Aviation
• 1 - 100 Employee

• Oracle Financial Consultant

  • Aug 2007 - Present

  • Completed 11.5.8 to 11.5.10 upgrade, including entire process review of system and rolling out standard Financials features not already in use.• Setup new Sets of Books and operating unit for acquired company and for consolidated reporting and USGAAP/IFRS reporting.• Developed PL/SQL Data conversion programs from MS Great Plains to Oracle for initial load of acquisitions data.• Implemented Fixed Asset Module and Cash Management modules.• Created custom import/export programs for document imagin and indexing system to interface with Oracle AP.• Developed PL/SQL to create flat file formats for AP payment• Custom Development of Bank Statement interface to support 215 bank accounts from 13 different banks.• Developed custom views for use with Essbase.• Forms Personalisation developments to customer requirements, including punch outs to other applications and web pages.



Version 1

• Ireland
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Financials Consultant

  • Jul 2007 - Present

  Apart from my full time work for AWAS, Version 1 have kept me busy on short term engagements with multiple other clients, where I have advised on upgrade options, user training, system health checks and best practices. Apart from my full time work for AWAS, Version 1 have kept me busy on short term engagements with multiple other clients, where I have advised on upgrade options, user training, system health checks and best practices.



CRH

• Ireland
• Wholesale Building Materials
• 700 & Above Employee

• Oracle Financials Consultant

  • Aug 2004 - Aug 2008

  Implemented very custom version of Oracle Projects.Implemented Purchasing and Payables Modules with multiple Operating Units.Supported GL Users with reporting requirements, month end close processes and both GL Security Rules and Cross Validation rule setup.Trained users to define Mass Allocation rules.Created budget reporting and extract files to enable users to modify budget more easily.Installed and developed Discoverer EUL for all modules. Developed over 70 different reports for GL, Purchasing, Payables, Receivables and Projects use, in both Oracle Report 6i and Discoverer.



Bord na Móna

• Ireland
• Renewable Energy Semiconductor Manufacturing
• 400 - 500 Employee

• Oracle Financials Consultant

  • Feb 2006 - Aug 2007

  Implemented General Ledger and Cash Management as part of an HRMS go live project.Advised on Chart of Accounts setup and preferred structure.Prepared Test Scripts and scenarios for unit testing feeds from Payroll to Cash Management and GL.Created custom PL/SQL programs to extract Oracle GL data back to multiple legacy system. Implemented General Ledger and Cash Management as part of an HRMS go live project.Advised on Chart of Accounts setup and preferred structure.Prepared Test Scripts and scenarios for unit testing feeds from Payroll to Cash Management and GL.Created custom PL/SQL programs to extract Oracle GL data back to multiple legacy system.



Sunlife Financial

• Oracle Financials Consultant

  • 2003 - 2004

  Working on GL, specialising in customising ADI to meet business requirements. Setting up Elimination and consolidation sets. For 32 different SOB’s.Implemented the Payables, Fixed Assets and Cash Management modules, using IBM’s implementation methodology. Created Invoice Approval rules within OAM. (Oracle Approvals Manager).Trained users on above and Purchasing with iProcurement.Developed functional specifications for custom developments, including Open Interface programs, workflow customisations, custom form development and report writing (Using both Discoverer and Oracle Reports).Developed custom EUL for use by ad hoc Discoverer report users.



IKON Office Solutions

• Retail Office Equipment
• 700 & Above Employee

• Various Roles

  • Aug 1989 - Jun 2003

  Jan 2003 - Jun 2003 Inventory and Order Management Functional Consultant Upgrade of Oracle 3i to 11i, responsible for re-design of inventory organization structure.Developed Upgrade Unit test scenarios and scripts in order to facilitate a smooth upgrade from 3i to 11.5.4. This involved redesigning custom forms and reports to pick up on 11i functionality.Developed functional specifications for revised Picking and Shipping documents/labels.1999-2002 Business Analyst Specialising in the Inventory, WIP, BOM and Order Management modules.Designed mapping for data conversion process from Legacy system to Oracle.Trained users on all of above modules with company specific examples.Created standard naming conventions and design standards for BOM’s, enabling ease of use with standard Oracle functionality.Developed numerous reports, from KPI’s to Physical Inventory reports within Discoverer and administered the EUL.1989 - 1999 Variety of other roles including Inventory Analyst, Sales Order Processing Manager, Purchasing Supervisor, Inventory Controller/Buyer.