Summary






I have gained over 10 years of hands-on experience in Oracle ERP 10.4.1 to 12.0 development/setup and upgrade using Oracle AIM ; Application Support and testing .I are involved in more than 4 full lifecycle implementations single and multi organisation instances. My experience covered diverse modules Financials, SCM, ASCP, CRM, Manufacturing ODM and OPM, HRMS, Self-Service Web based Applications and cut across many business areas such consulting, constructions and infrastructures, oil and gas, chemical, environmental, defence, financial services, retail, education, public sectors and telecommunications.
Involved in both global and localised implementation rollouts in the UK, Switzerland, Austria and pseudo-Spain ; Elicited/captured business requirements from business process owners and translated these business requirements into functional specifications ; Prepared GAP and FIT analysis ; conducted CRP. Prepared documents for future enhancement and improvement.
Gathered and embedded GRC issues such local Statutory Regulations or Taxing Authorities requirements, Business Practices and Risk assessment ; and international accounting conventions or agreements like New UK GAAP, US GAAP, SOX, Basel II, IFRS, Intrastat which impact on the operations of the organisation ; Gathered reporting requirements from all the stakeholders both local and external .I have a considerable Change or Project Management experience.
Functional
As an accountant by profession, my primary area of experience is the financials. My professional acumen enhanced the practical understanding of the setup or functions or problem solving or support of the core financial modules GL, Payables, Receivables, Fixed Assets, Cash Management, Tax, Purchasing ; and other modules with integration points with the financials modules .I complement my roles with users mentoring, training and knowledge transfer.
Pre-ERP practical experience in financial accounting and management commercial and public Sector, auditing, reporting, production of statutory financial statements and management accounts ; management Accounting Budgeting and Budgetary Control, Business Performance Analysis and Review of KPI, taxation and taxing regulation ; and bookkeeping.
Local Government and Public Sector Finance
I am conversant with the Local Government Finance Act 1988 and 1992 Amended, National Procurement strategy ; Office of Public Sector Financial Regulations ; European Communities Finance Act 2008 ; Implementation of IFRS in Public Sector Capital Projects ; Statement of Recommended Practice and Financial Accounting Issues or SORP ; Corporate Governance and Accountability ; LG Financial Planning and Budgeting ; Public Private Partnership PPP and Public Finance Initiative PFI ; Whole of Government Accounts WGA ;
Testing upgrade and rollouts global or localised
Developed testing strategy and approach critical and non-critical ; Identified test cases and use cases ; developed test scripts and created test data with all possibilities ; UAT or CAT.
Oracle Business Intelligence Siebel Analytics, BI
Involved in full life cycle OBIEE implementation business requirements gathering, business analysis, solution designs, development server and application architecture and testing ; design, develop and test new reports/ dashboards and ETL processes ; Focus on the Presentation Layer - Dashboard, Answers, BI Publisher ; Server installation and configuration OC4J ; working across the BI Administration Tool environment physical, business model and mapping and presentation layers ;
Technical
I have a relative insight of the Oracle Applications Architecture database tier, application tier, desktop tier and application technology layer, Rapid Installation processes and patching/tuning and upgrade. Basic knowledge of SQL and PL/SQL ; data migration, data modelling, data warehouse or data mart and ETL ;
Core Financials Modules or Quasi Financials modules
Oracle Modules Period Period Last Used
Years Years
R12 11.5.10
GL, AR, AP, CM, FA, AGIS 1.5 8 2009
Procurement and SCM Planning>
Purchasing 1 5 2009
iProcurement and iExpenses 1 0.5 2009
ASCP and Collaborative Planning 1 0.0 2009
Sourcing and Procurement Contracts 0 0.5 2008
iSupplier Portal 0 0.5 2008
Public Sector
GL, AR, AP, Purchasing and Grants 1 1 2008
Assets Management
EAM 0 1 2008
System Administrator's : supported end-users and applications optimisation duties Setup applications super users, configure new responsibilities, users ; implement functions security ; Setup printers and printing parameters ; Manage profile options at all levels ; define concurrent manager and define reports set ; Setup audit trail ; administer ICM.


Employment

December, 2008 -  June, 2009
Reporting Analyst

Appraisal of oracle financial system s scalability/enhancement in line with the current business processes/practices and optimisation focusing on GL, payables and projects.
Consolidation review Oracle Consolidation processes rules, mapping definitions, automated reconciliation procedures ; security and cross-validation rules ;
ADI and FSG created new group reports, reconciliation of FSG reports to non-designated sub-group and ad-hoc report templates based on the reporting requirements of the UK groups and parent company Grupo Ferrovia S.A; reports and data cleansing ; prepare VDD report from Oracle for Assets-Held-for-Sale ; created tax reporting templates ;
Auditors - Liaising with Group Auditors PWC regarding the reconciliation of Oracle vs Statutory Financial Statements of designated Groups and non-designated legal entities ;
iProcurement revamp the catalogue content management, requisitioning, purchase order creation, receiving orders and approval processes ;
Fixed Assets carried out maintenance and adjustments mass depreciation, financial information, reclassification, units of production volume and capacity, unplanned depreciation, revaluation, reserve and mass change ; physical inventory reconciliation ; and period end processing ;
Cash Management loading, importing, validating, reviewing and correcting bank statements ; importing bank statements with auto-reconciliation program and entering bank statement information manually ; reviewed FTP process of transferring bank files ; deleting bank statements from interface tables.
OBIEE part of a team of Functional and Technical architecture : Participate in requirements gathering, documentation, delivery and testing ; Provide hands on design and support for Oracle OBIEE environment, SIEBEL Analytics, Informatica ETL, BI Answers and Dashboards ; develop and maintain technical project plans, documentation and application architecture blueprints diagrams, install and configure all components of OBIEE ;

iExpenses setup : enabled project expenditure types/classes ; defined expense report templates ; defined financial options expenses clearing account ; multiple currency setup ; defined expense report option pay groups, payment terms, apply advances, automatic creation of employees as suppliers, 3 - way matching criteria, assign signing limits ; defined and assigned controls receipt notification rules set, mileage rate schedule ; define responsibilities and OIE profile options in System Administrator ; customise project expense report account generator ; defined workflow notification performers for users and approval purposes ;
Projects Costing Accounting review expenditure entry, burden and allocations, transactions and budgetary controls, adjustments on multiple types of expenditure, resource sharing administration, asset capitalisation, auto accounting, project maintenance and ad hoc reporting ;
Oracle eAM Replace Maximo eAM with Oracle eAM ; re-engineered business processes and procedures with the industry standards compliance and in conjunction with the ground maintenance managers ; Installation and configuration of eAM, establishment of integration points with Oracle Inventory, Spares, BOM, HRMS, Cost Management, Quality and WIP ; Purchasing, iProcurement, iSupplier, MRO for the high and complex maintenance culture of the organisation ; prepare the

iSupplier - Portal : gathered information on PO collaboration ; shipment notices ; invoices and payments ; inventory management ; supplier management ; PO acknowledgement ; ASN and ASBN ; invoices creation ; Security and Responsibilities internal and trading partners users, security attributes, e-signature functionalities, deliverables ; Vendor registration and profile management ; portal user interface customisation ; portal workflows notifications, function activities, messages, lookup types
AGIS and AME - Define the Intercompany Account pages Transacting and Trading partner setup pages ; create Intra-company balancing rules ; define Intercompany organisation page ; define Intercompany Transaction Types pages ; define intercompany periods ; Invoice option pages ; Intercompany system options ; performed AME setup for Intercompany ; defined Accounts rules in SLA for Intercompany ; Balancing Segment ;

November, 2007 -  August, 2008
System Analyst

Business Case configured Holding company and 16 Subsidiaries with disparate legacy systems and COA variations ; Secondary ledger is required for multiple representation, as the Holding company is owned by a major European Bank ; Reviewed SoBs in line with GRC process control and users access ; MOAC ;
Modules implemented - version12.1 GL, Payables, Receivables, Fixed Assets, Cash management, Tax, HRMS, Payroll Processing UK, Balance Scorecard, Financial Analyser, Reporting/upload tools ADI, FSG, Report Writer and Discoverer ;

Lead in BR100 Application System Setup : defined accounting flexfield ; legal entities ; ledger - primary and secondary 4Cs ; completed mandatory accounting options ; assigning primary ledger to Responsibility ; Data Access Sets : defined profile option ; Open/Close : first period opened ;
Lead in BR 110 Flexfield security rules and cross validation ; Setup Administration tasks : users profile/preferences, set systems options, audit trail ;

Sub Ledgers : Lead/assisted in setup activities and Configuration of Sub Ledger Accounting : ABM, Post accounting program, TAB, Open account bal. listing definitions ; Tax Content Services to configure complex landfill tax rules or rates.

Tax - setup tax content, tax determinations, tax rules, lookup codes, operating units, users, profile option values ; setting up the regime to-rate taxes, statuses, rates, recovery rates, jurisdiction, rules, tax reporting codes, fiscal classifications, tax profiles, registration, configuration options ; tax reporting extracts tax reporting ledgers and VAT or landfill tax reports

Purchasing setup : personnel ; Approval assignments and approval groups ; Organisation purchasing options, receiving options, financial options, SOB ; requisition templates, lookup codes, line and documents types, freight and shipping, payment terms, accounting period types, calendar, Control purchasing periods, open/close periods ; Items templates, attributes, catalogue groups, categories, item types, status codes, container types, constrains ; UOM ; Users Support : month end processing ; create requisitions, Quotations and RFQ ; PO ; Receiving ; Load items ; Reports and Advance Pricing ;
iProcurement assisted in the setup documents sourcing agreements and quotations ; catalogue content and management catalogues, stores, local content, extract data from oracle purchasing, load catalogue data, defined catalogue mapping, defined classifications and suppliers domains, set up search related options, manage images, defined realms, setup non-catalogue request templates ; Users support shopping, checkout, requisition tracking and management, desktop receiving, Fixed Assets setup : ledger primary ledger, accounting flexfields, calendar period types, calendar periods, assign primary ledger to Fixed Assets Responsibility ; Assets category flexfield ; location flexfield ; Asset key flexfield ; system options ; fiscal year ; calendars ; Journal entry sources ; Book controls ; Depreciation methods ; Prorate convention ; UOM classes ; Asset categories ; Users support manual additions, mass additions, CIP additions, depreciation, retirements, inquiry and reporting, tax accounting ;
OBIEE Translate functional requirements into technical specifications for design of Data Marts/Data warehouses and ETL mappings ; Create analytic solutions using Interactive Dashboards, Oracle Answers, Interactive Reporting and BI Publisher, Advanced Analytics, Scorecards, Standardized/ Ad-hoc reporting ; Define standards for measuring, monitoring, reporting and analysis ;

Testing : deployed the system onto the Test Environment ; Setup the ticketing system to log and track bugs ; Created functional test data based on the TE. 40 test scripts and compile test report/metrics on E2E test activities ; used the train-trainers strategy superusers for the delivery of training. Delivered Journal and Workflow approval processes.
User Support : Transferred knowledge : accounting cycle : Customers/Suppliers master data management and entering transactions ; month-end processing procedures and reporting. Used Balanced Scorecard to customise KPI ;
Close project : produced project deliverables with screenshots and metrics. Project base-lined and discussion of future enhancements or upgrade.

Teamsolve Consultancy
January 2007 October 2007 Senior Oracle Financials Consultant and seconded to lead the 11.5.10 rollout for Staffordshire County Council

Carried out Financial Health Check based on the Accounts and Audit Regulations 2003 are made under section 27 of the Audit Commission Act 1998 ; Corporate Governance
Gathered requirements and used corporate Sprint methodology to carry out business processes re-engineering ; carried out a cost and benefits analysis regarding the proposed implementation of Oracle Advanced Collections module for Customer and Debts Management ; Embedded the National Procurement Strategy in the P2P cycle ; Bill-to-Collect B2C ; Interface third party or middleware applications with the payables and receivables, Duplicate Payments Finder software package for Investigation and Recovery and ePayments Electronic card payment ; external fee-paying clients using Oracle Financials ;
Public sector Financials 11.5.10 GL setup accounting flexfields, account structure, project tracking in GL, period types, calendars, transactions calendars, SOB, journal sources, journal categories, suspend accounts, inter-fund accounts, statistical accounts, transactions codes, CENTRA, opening or closing accounting periods, functions security
user support define budget versions, budgetary control and time intervals ; funds check ; month-end processing ; interface invoices to Receivables ; creating multi-funding projects or disbursements based on SORP ;

Grant Module setup additional Encumbrance types ; financial options in purchasing, payables and OFA, the Encumbrance parameters ; SOB and enable Budgetary control ; billing cycles/extensions ; agreement or event types ; budget entry methods ; resource lists ; project types or templates ; costs types, labour and burden ; events revenue or billing ; accounts generator for flexfield code combinations ; projects related distribution sets ; awards or award purpose codes and lookups
Mapping for Whole of Government Accounts WGA in line with Government Resources and Accounts Act 2000 ;

June, 2006 -  December, 2006
Oracle eAM System Analyst and Assets Management downstream and upstream

Business case : Installation and configuration of eAM, to establish integration points with Oracle Inventory, BOM, HRMS, Cost Management, Manufacturing Scheduling, Quality and WIP ; *Procurement, iProcurement, MRO for the Upstream, midstream and downstream infrastructures.
Elicited industry specific processes and best practice procedures of facilities and Production maintenance ; reviewed plant architecture documents in order to identify, track maintainable assets and classified them into groups ;

Conducted interview to gather preventive maintenance forecasting or scheduling synchronised with production schedules ; maintenance plans ; predictive maintenance based on usage, inspections readings ; work safety and compliance ;

Defined organisations : inventory, purchasing and maintenance ; defined assets/ asset genealogy, inventory items, departments, resources, routings, maintenance BOM, work requests/orders, lookup codes, SSM, setup users from HRMS and assigned responsibilities via system administration ; mobile devices/wireless maintenance user workbench ; Reports : failure analysis, activities cause, work order cost, material issue request pick list, maintenance downtime, weekly schedule ;
Fixed Assets CIP assets additions adding and capitalising a CIP asset ; acquire and build CIP assets ; modifying cost of CIP assets, reversing CIP assets,
ICI Imperial Chemical Industries Chemical, Paint and Adhesive manufacturing

September, 2005 -  June, 2006
Oracle Financials Enhancement Consultant

Business Case : Process Manufacturing Upgrade to 11.5.10 GL, Payables, Purchasing, Receivables, Asset, Cash Management, Inventory, Purchasing, Cost management and upgrade of new Database for future applications upgrade and enhancements.

Segments - Configured the spare flexfield segment future and add additional segment values.
New functions - Identified new user interfaces, functions changes and menu/function options, re-arrangement, reduced downtime, planned timing, pre and post verification of data, upgrade historic data.

Manage the downtime activities, assisted the DBA in patching and tuning ; Extract pre-upgrade financial reports and compared with post-upgrade ; verified inventory cycle count balances, bar-coded items/ non-inventory items, warehouse implications.

Setup 2 new values under the segment company due to acquisition, SOB, profile options, flexfield security rules, cross validation, sequences, tax options.

Review standard Oracle Workflows and complete process work flows specific to the item and inventory functions that support manufacturing and engineering business.
Coordinate and communicate the standard workflows and processes throughout the manufacturing and engineering business to help maximize efficiencies gained through Oracle. Familiar with ASCP.

Purchasing user support notifications ; requisitions ; PO, receiving ; RFQs and Quotations ; supply base ; items ; accounting ; personal profiles and advance pricing ;

January, 2005 -  August, 2005
Oracle Financials Functional Consultant

Business Case : Setup customer groups, new financial items and produced GAP analysis on reporting requirements.

Gathered business requirements : membership and trading for secondary markets, central counterparty for SETS, competitive clearing and global security products.

Review FSA compliance reporting requirements against oracle Treasury standard reports and other third party application interfaces.

March, 2004 -  November, 2004
Oracle Financials Solution Analyst

Business Case : Discrete Manufacturing Order Management, Inventory Assignment/Allocation, Shipping, Billing and all related Order Entry to Shipment Execution through Customer Service processes and Foreign Trade Zone FTZ procedures.
Gathered and document business requirements on OM procedures for managing Orders *entering, managing approvals, updating, managing holds, cancelling, purging, closing orders, picking, staging, packing, order consolidation, loading and shipping, the translation of requirements into Oracle E Business system configurations and set-ups.
Configuration and set-up of outbound Logistics and shipping related information, Shipping Parameters.
Inventory setup and user support
Purchasing - played key role in the setup personnel ; approval assignments and groups ; organisations purchasing options, receiving options, financial options, organisations, SOB ; line types ; document types ; lookup codes ; accounting period types, calendars, control purchase periods, open and close periods, payment terms, items ; UOM.

March, 2000 -  February, 2004
Oracle Accountant

Business Case : Superuser End-user in General Ledger, Receivables, Payables, Asset, Order Management, Shipping Execution, WHM and Inventory.
Primary duties included completion of the accounting Cycle : GL Open or close accounting periods, Enter and post Journals, policy on journal reversals ; import data from Sub Ledgers ; create/define
Running the TBI interface procedure and supervised the billing activities.

July, 1999 -  January, 2000
Oracle Test Analyst

Business Case : UAT of University s Student Systems
Testing - Run test scripts run regression test and manage defects from identification to closure.
Review business requirements and specification walkthroughs.

Establish test data, test risks, test plan, scope and approach ; Record, track bugs uncovered during the execution of test scripts, provide timely and accurate status defects information and appropriate metrics to facilitate QA Reporting. Report dashboard information, open issues, risks analysis.

1996 -  1999
Certified Accountant

1993 -  1996
Financial Accountant

1992 -  1993
Grant Income Officer

1989 -  1992
Accountant

Education

Skills


SAP FICO with MM, PP, PS, PM, SD and Logistic Execution, Solman user experience. Reporting or Uploading or Migration Tools FSG, Reports Writer, ADI, Web ADI, Dataload ; Assisted implementation modules Quality, Order Management, Shipping Executive, WHM ;
EDI Gateway and Oracle Payments ;
ENGAGEMENTS HISTORY BAA British Airports Authority and Grupo Ferrovia S.A Spain Airports operators, Heathrow, duty free shops worldwide, properties and infrastructures support services. The Group has 91 Legal entities and 189 Adjustment entities New UK GAAP, IFRS and Consolidation entities.


Miscellaneous

Sage 500 ERP, Sage Line 100 and 50, Sage Payroll, QuickBooks, IRIS, MYOB, TAS payroll, TAS, Accounting, AuditMan, Winline ERP 7.1, Office Excel, Word, PowerPoint, Access ;