|
Curriculum Vitae
Capability Matrix
|
ORACLE
APPLICATIONS
|
Capability
|
|
GL: General
Ledger
|
10+ years
experience. Implementation, training, interfaces and data conversion.
|
|
AP: Accounts
Payable
|
10+ years
experience. Implementation, training, interfaces and data conversion.
|
|
FA: Fixed Assets
|
10+ years
experience. Implementation, training, interfaces and data conversion.
|
|
AR: Accounts
Receivables (and TCA)
|
10+ years
experience. Implementation, training, interfaces and data conversion.
|
|
CE: Cash
Management
|
5+ years
experience. Implementation, training, interfaces and data conversion.
|
|
PO/INV: Oracle
Purchasing/Inventory
|
3+ years
experience. Implementation support, training, interfaces and data conversion.
|
|
PA: Project
Accounting
|
5+ years
experience. Implementation support, training, interfaces and data conversion.
|
|
OTL: Time and
Labour
|
1-year
experience. Implementation, training.
|
|
iExpenses
|
1-year
experience. Implementation, training.
|
|
Other modules
|
Experienced.
Have good knowledge of other modules as well – please call.
|
|
ORACLE TOOLS
|
|
|
Oracle
Discoverer 4i, 6i, 9i
|
5+ years
experience. Development, Reporting,
OLAP, EUL design.
|
|
Oracle Workflow
|
5+ years
experience. Oracle Applications
workflow customisations.
|
|
SQL and SQL
Loader. 8i/9i/10g
|
10+ years
experience. Advanced SQL. Extracts
and data manipulation.
|
|
PL/SQL 8i/9i/10g
|
10+ years
experience. Package design.
Interface design. Data cleansing.
|
|
OTHER
|
|
|
DataLoader, Toad
and other Oracle tools.
|
Expert. Advanced use for data manipulation.
|
|
MS Word, Excel
and Access
|
Expert. Advanced use including VBA programming. Often used
for complex reconciliation problems and automation tasks.
|
My roles in recent projects
|
Started:
|
Summary:
|
|
Sep 2007
|
Available from
1/9-2007
|
|
May 2006
|
OA 11i AP, GL
and CE. Implementing high volume AP payments for a UK government department.
|
|
August 2005
|
OA 11i AR.
Implementing high volume AR for a major telecoms provider.
|
|
January 2005
|
OA 11i GL, FA,
AR, AP, PO and CE. Adding a new business to an existing org in an insurance
business.
|
|
July 2004
|
OA 11i, GL, FA,
AR, AP and CE implementation in a medical services and manufacturing
business.
|
|
May 2004
|
OA 11i, AR, FA
and CE implementation for a public transport company.
|
|
March 2004
|
OA 11i, PA, OTL
and AR implementation in an airport.
|
|
November 2003
|
OA 11i, AR, CE
and custom application integration with AP, PO and PA in a telecoms business.
|
|
October 2003
|
Discoverer 6i.
Sales reporting EUL for Oracle Applications. Complex like-for-like reporting
in retail.
|
|
September
2003
|
Discoverer 9i.
EUL design on top of an Oracle 9i OLAP database for CRM reporting in a
telecoms business.
|
|
September 2003
|
Discoverer 4i.
EUL design for reconciling 11i AR to GL for a retail company.
|
|
June 2003
|
OA 11 to 11i
upgrade of GL, AR, AP, FA, PO and CE for a police force in a major city.
|
|
January 2003
|
OA 11i GL
implementation at group level for a public transport company.
|
|
December 2002
|
Discoverer 4i.
EUL design for 11i CE reconciliation to sub-ledgers in a retail company.
|
|
January 2002
|
OA 11i AR with
custom development on top for Norwegian tax authorities.
|
|
August 2001
|
OA 11i
integration analysis for a major UK insurance company.
|
|
September
2000
|
8i Team lead for
XML and database design for custom CRM system for a major UK insurance
company.
|
|
January 2000
|
OA 11i Interface
and data conversion lead for US leasing company.
|
|
February 1999
|
OA 11 Technical
lead for GL implementation in a bank in Hungary - owned by a US company.
|
|
May 1998
|
OA 11 GL
budgeting implementation world wide for a US financial services company.
|
I have also had permanent roles with
|
2004 - Now
|
Independent
Contractor. Working with Oracle Applications.
|
|
2002 - 2004
|
Consultant with Compelsolve/Sysao.
Working with Oracle Applications and Oracle Discoverer.
|
|
2002
|
Independent
Contractor. Working with Oracle Applications.
|
|
1998 - 2002
|
Principal
Consultant with PriceWaterhouseCoopers. Working with Oracle Applications.
|
|
1997 - 1998
|
Consultant
Electronics Data Systems (EDS) Denmark. Working with Oracle
Applications and DBA.
|
|
1989
|
Independent
Contractor. Working with Oracle Applications and development.
|
|
1989 - 1995
|
Consultant with Oracle
Denmark. Working with Oracle Applications, DBA and development.
|
|
1986 - 1989
|
Consultant with
Tektronix. Working with Unix. Unix administration and RAD tools.
|
Detailed Project Experience
Independent Contractor
|
Customer
|
Department for Work and Pensions (DWP) / Oracle
UK (contract to)
|
|
Project
|
OA 11i AP, GL and CE. Implementing high
volume AP payments for a UK Government. (May 2006 - June 2007)
|
|
Role
|
Functional Consultant AP/GL/CE and Functional
Lead for Make Payments (Invoice to Payment).
|
|
Details
|
This is a public high profile project
which will provide DWP with a high volume payments engine for pensions and
benefits with payments averaging at 3 million per day and peaking at 15
million on a single day.
My initial role was to produce functional
specifications for customisations integrating with Oracle AP, CE and GL for
the Proof of Concept (PoC) phase. The PoC phase would show that the basic
Oracle AP payment engine with some customisation could cope with the high
volumes. My main deliverables during this phase was to produce the specifications
for a GL Journal interface and a message based interface enabling the
department to deliver payment instructions via XML.
Later I was involved in the requirements
gathering and review phase from the Oracle design point of view. I was also
involved in some requirements analysis including UML, data flow diagrams and
data modelling. These proved to be valuable tools for verifying the initial
design leading to the Final Design phase.
During the requirements phase I achieved good
insight into a wide area of the overall system and this enabled me to become
functional lead for Make Payments during Final Design. Make Payments is the
process ranging from Invoice Batch over Payment Batch to delivering the
payment. Payments include cheques, payable orders, BACS and message based Faster
Payment Service (IPL/VOCA payments).
The functional lead is responsible for
the high level system design, functional design, configuration and all
functional specifications for the area. For Make Payments this included more
than 15 functional specifications where some of these specifications included
multiple interfaces.
I successfully delivered the Make
Payments design and had multiple concurrent functional authors to deliver
most of the functional specifications subject to my coaching and review
process.
|
|
Customer
|
OTE (main telecoms company of Greece) /
Accenture Italy (contract to)
|
|
Project
|
OA 11i AR. Implementing AR for a major
telecoms provider (August 2005 - March 2006)
|
|
Role
|
Functional Consultant - Financials: AR,
TCA and PL/SQL 9i.
|
|
Details
|
My role on this project was to provide
Accenture with AR/TCA expertise - to ensure the AR/TCA part of the project
would successfully integrate with the overall solution.
OTE wanted to replace their old
residential consolidated billing system with a modern combination of
Convergys Geneva and Oracle Receivables. Geneva is the customer and
convergence billing front-end application and Receivables is the collections
and back-office application feeding Oracle General Ledger (GL) through the Global
Accounting Engine (AX).
This was a high volume multiple channel
implementation where I was responsible for the Receivables part of the
architecture design, functional configuration and interfaces. This involved
knowing and mapping the functional abilities of Geneva to Receivables from
transaction level to accounting.
The implementation required complex
configuration to support the required functionality and accounting including
support for special Greek VAT reporting and special telecoms transactions like
corrections and billing embedments.
I also designed and built a TCA customer
model for OTE residential customers and implemented this to successfully work
with Receivables, Advanced Collections and CRM eBusiness centre.
Some volumes: 6 mill customers, 36 mill
bills/year and same amount of payments.
Due to the high level of integration
between the Geneva and Receivables a number of interfaces is required. I have
trained a team of junior Accenture consultants to design and code interfaces
using PL/SQL under my supervision. The interfaces used is: AutoInvoice,
Lockbox, Receipt API and TCA API. The API based interfaces is very complex
near real-time interfaces.
Custom reports were specified and sent to
an offshore development centre in India to be coded in Oracle Reports. I
designed the reports to fully support NLS and MLS using translatable report
headings based on Object Library message APIs. This enabled the reports to be
built offshore and translated locally in Greece by non-technical people.
|
|
Customer
|
CNA Insurance – Europe.
|
|
Project
|
Adding a business to an existing
installation and rollout of PO (January 2005 – July 2005).
|
|
Role
|
Functional Consultant - Financials: GL,
FA, AP, AR, CE, PO.
|
|
Details
|
CNA have already got Oracle Financials
but needed to add AR functionality and expand the overall deployment.
To successfully add the new businesses AR
had to be implemented. In order to do this the businesses to be added was
analysed and suitable application designs was decided upon. Main deliverables
was business requirements, application design and final configuration
including delta configuration of existing modules. It was possible to add the
businesses onto the existing organisation using the full abilities of AR
AutoAccounting.
Invoice preview was added using the Bill
Presentment Architecture (BPA).
Invoicing and Statements was produced
without customisation by using XML Publisher and XSLT commands where my prior
experience during an earlier Royal Sun & Alliance project came in handy.
The potential of XML Publisher is huge and can provide customised reports
from most Oracle Reports and FSG based reports without the use of technical
development resources – shifting the focus towards the functional solution.
Impact on other modules was minor due to
the shared services solution CNA operates in Norwich servicing operations in
London and throughout Europe.
PO rollout was mainly to map and
configure the use of inventory items from PO over AP to generate correct
expense to FA categories for capitalised or tracked expense items. Part of
this solution I developed a custom workflow package to manage the population
of mass additions.
FA was also prepared to handle assets by
department for decentralised asset maintenance and physical inventory.
During the implementation – production
support duties plus upgrading 11i.8 to 11i.10 and other minor projects was
carried out.
Solved several problems in the existing
implementation improving the business process of PO, AP and FA. Carried out
P2P workshops and process analysis to resolve business process issues. Also
created user guides and Excel based intelligent forms for core data
maintenance.
|
|
Customer
|
KCI International – medical services,
manufacturing and sales.
|
|
Project
|
Implementation of Financials, SCM and CRM
(July 2004 – December 2004).
|
|
Role
|
Functional Consultant - Financials: GL,
FA, AP, AR, CE
|
|
Details
|
The project is a major rollout of
Financials, SCM and CRM throughout Europe with consolidation and MRC
reporting. The purpose of this phase is to build conference room pilots
(CRP), design customisations, interfaces and data migration and create a
blueprint for the initial implementation in UK and Germany including
consolidation to a parent company.
My main objective was to configure and
manage the data migration for the Financials modules.
This included rigorous planning, change
management and control and working close together with the project manager. I
was directly responsible for handling the functional documentation and
control also including SCM and CRM and assist in the instance planning cycle
to ensure a successful cut to live. I also introduced methods for testing and
change/configuration deployment including the use of a test management tool –
Elementool.
I designed the customer model
functionally and technically – fully utilising the TCA data model and
creating a successful business to functional mapping for use in the health
care sector. The design included the use in AR, OM and CRM modules including
Sales and Service-requests where I ensured the design was consistent wherever
used.
Did the data migration functional design
and build using SQL, ADI, Toad, MS Excel, DataLoader and MS Access. I
verified and tested load programs made by the technical team. I also used MS
Access as a rapid development environment for data cleansing and validation
prior to loading the data into the Oracle database. This proved to be a huge
time and cost saver where feedback could be provided to the users without
loading data into Oracle. MS Excel was used with DataLoader to provide complex
mapping tables and fast reconciliation.
On the database side I designed SQL and
PL/SQL scripts and small PL/SQL packages to provide data fixes and to verify
data quality and reconciliation.
|
Project Experience with Compelsolve/Sysao
|
Customer
|
Manchester Airport
|
|
Project
|
Implementation of Oracle Financials
(March 2004 – July 2004).
|
|
Role
|
Functional Consultant: PA, OTL and AR
|
|
Details
|
Responsible for implementing AR, PA and
OTL. This is a medium complexity project to go live within 4 months. Main
focus for me was on PA and OTL. Did initial AR setup and workshops until did
area was taken over by another resource.
Special to this project is the use of the
PA functionality: Borrowed and Lent intercompany transactions.
|
|
Customer
|
Arriva
|
|
Project
|
Implementation of Oracle Financials (May
2004 – June 2004).
|
|
Role
|
Functional Consultant: AR, FA, CE
|
|
Details
|
Responsible for implementing AR, FA and
CE. This is a medium complexity project to go live within 3 months. The FA
system will interface with the standard transport solution Spear.
My role was primarily in the initial
stages of developing a blueprint for rollout to a number of regions.
|
|
Customer
|
Vanco – a virtual network provider
|
|
Project
|
Implementation of Oracle Financials
(November 2003 – March 2004).
|
|
Role
|
Functional Consultant
|
|
Details
|
I implemented AR, CE and did the
functional design of a custom application. The company is multinational and
multicurrency. The custom application has integration points with AR, AP, PO
and PA. The custom application is able to generate purchase orders, revenue
and billing events. The application also provide AP invoice matching by
comparing invoices with purchase orders before they enter the AP invoice
interface.
|
|
Customer
|
Pilot – Clothing manufacturing and
retail.
|
|
Project
|
Oracle Discoverer 6i sales reporting
system based on Oracle GL (October 2003).
|
|
Role
|
Developer.
|
|
Details
|
The End-user layer is complex due to
day-by-day reporting on high volume journal data with additional complexity
for Like-For-Like reporting ensuring that current data can be compared to
historic data even when shops are opening and closing within the reporting
period.
|
|
Customer
|
Wireless Data Systems – Telecoms support
and accounting services.
|
|
Project
|
Oracle Discoverer 9i OLAP reporting
system (September 2003).
|
|
Role
|
Developer.
|
|
Details
|
Complex End-User layer for reporting on
CRM statistics. The CRM data is located on a custom OLAP database and the
End-user layer had to be designed using various OLAP functions to ensure
proper analytical results.
|
|
Customer
|
Co-Operative Group – Retail sales and
banking.
|
|
Project
|
Oracle Discoverer 4i reconciliation
reporting system (September 2003).
|
|
Role
|
Developer.
|
|
Details
|
End user layer for GL reconciliation to
AR and AP subledgers. Designed an End-user layer that analyses all GL
transactions via the internal drill-down data from the subledgers.
|
|
Customer
|
Greater Manchester Police
|
|
Project
|
Upgrade 11 to 11i (June 2003 - September
2003).
|
|
Role
|
Training and Testing Consultant.
|
|
Details
|
User and super user training in: GL, AR,
AP, FA and CE.
Providing gap analysis for the upgrade on
modules: GL, AR, AP, and CE.
|
|
Customer
|
GoAhead Group – Train and Bus transport
company.
|
|
Project
|
Head Office GL implementation (January
2003 - June 2003).
|
|
Role
|
Lead Consultant for GL.
|
|
Details
|
Implementation of Oracle 11i GL and
Oracle OFA for head office consolidation and budgeting.
I was full responsible for the GL
implementation including reporting, budgeting, consolidation and
intercompany. Worked closely together with the OFA team to provide a seamless
integration in a complex environment.
|
|
Customer
|
Co-Operative Group (December 2002)
|
|
Project
|
Oracle Discoverer 4i cash management
reporting system.
|
|
Role
|
Developer.
|
|
Details
|
Complex End-User layer for reporting for
cash management (CE) and reconciliation from AR, AP and GL.
|
Project Experience as independent Contractor
|
Customer
|
Norwegian Inland Revenue
|
|
Project
|
Designing AR and GL integration strategy
(January 2002 - March 2002).
|
|
Role
|
Consultant.
|
|
Details
|
The Norwegian Inland Revenue wanted to use
Oracle 11i - AR and GL for tracking tax and returns. The system would have a
bespoke front-end and would have a business critical interface with Oracle
11i.
|
Project Experience with PricewaterhouseCoopers
|
Customer
|
Commercial General Norwich Union (CGNU)
|
|
Project
|
Oracle Migration (August 2001 - September
2001).
|
|
Role
|
Quality review and reconciliation
analysis.
|
|
Details
|
A post merger migration project in order
to consolidate the financial systems into Oracle Applications. The project
was complex due to a high number of feeding and payment systems, which would
cause interface and reconciliation issues during the migration.
The analysis phase would have to mitigate
for the above constraints and improve the current business processes and any
future mergers.
|
|
Customer
|
Royal Sun & Alliance (RSA)
|
|
Project
|
Evita 9B design and build (September 2000
to July 2001).
|
|
Role
|
Team leader for XML, database design and
database management.
|
|
Details
|
CRM project using Vectus for the
application and IBM MQSI for back-end data integration.
The Vectus application uses an Oracle
database and the MQSI database is DB2/UDB.
I was data team leader responsible for a
team of 5FTE's doing design of the logical data model, business data
definitions and XML data definitions for data integration and physical data
models for Vectus, MQSI and the XML data structures. All data structures were
documented using System Architect with additional MS Access databases for
reporting and maintenance.
The Vectus product is a framework product
with some core tables and the ability to add bespoke tables. The number of
bespoke tables is 180 making this a medium size system. The Vectus
application will support 2000 retail insurance users making this a fairly
high transactional database.
The data integration database is 20
tables supporting data mapping, data transformation and routing.
The XML data and data structures is
handled as data models with an additional MS Access database for reporting
and generation of XML examples and DTD documents for validation of test
messages. In addition to this MS Access was used to generate XML examples and
DTD validation files.
|
|
Customer
|
GE Fleet Services (GECFS)
|
|
Project
|
Global Design (January 2000 to July
2000).
|
|
Role
|
Interface and data migration strategy and
design.
|
|
Details
|
An Oracle Applications rollout project
using GL, FA, AP and AR. The target countries were Belgium/Luxembourg,
Netherlands, Spain, Portugal, Italy, Switzerland, Germany, France, UK,
Sweden, Norway and Finland. Headquarters was in Belgium where process
development took place. Interface and data migration development was done in
Manchester.
I was fully responsible for Interface,
data management and test strategy including archiving and data retaining
management. I was co-responsible for the Application architecture including
issues Euro, pan European compliance, US GAAP, multiple reporting currencies,
multiorg and Global Accounting Engine.
The interfaces were point-point using
multiple development teams depending on the legacy system.
|
|
Customer
|
GE Capital Global Consumer Finance (GCF)
|
|
Project
|
Hungary Implementation (February 1999 to
November 1999)
|
|
Role
|
Team leader for interfaces and technical
lead for data migration.
|
|
Details
|
This project was part of the global roll
out of Oracle Financials and process improvement within the Global Consumer
Finance group of GE Capital to facilitate the integration of businesses
within the GE Capital group. The project was at Budapest Bank, Hungary the
first full service retail bank within the group to have Oracle Financials
implemented.
Responsibility for the process of
scoping, analysis, design and testing and implementation of interfaces and
infrastructure components.
Responsible for the interface and
infrastructure work streams on the project. This involved responsibility for
the process of analysis, design and testing and implementation of interfaces
and infrastructure components.
Provide functional based input to the
design of interfaces to support the process improvement.
Interfacing includes extraction programs,
data transfer using Connect:Direct, Windows NT data parking lot, mapping
programs, Oracle GL journal import and reconciliation.
Assistance in the conversion of data for
the data conversion work stream.
Lead a team of 5 FTE's (client staff) to
support the delivery of the various components and managed several
subcontracting teams responsible for delivering services including
programming and data centre services.
The project achieved significant
improvements in controllership and closing time. Reduced functional and
systems maintenance. Enabled the bank to do significant organisational
consolidation and utilisation of shared services centre.
|
|
Customer
|
GE Capital Global Consumer Finance (GCF)
|
|
Project
|
Site assessments (September 1998 to
December 1998).
|
|
Role
|
Technical lead.
|
|
Details
|
Did site assessments in Czech Republic,
France and Hungary in order to provide deployment management with information
about the readiness for implementation in each country. The assessment
ensures that management; finance, system and technical gaps are identified
and addressed before the implementation team goes on-site. The assessment
also was a pre-implementation strategy including system strategy, project
organisation and resources. Each assessment had duration of two to three weeks.
Responsible for executive,
infrastructure, interface and data conversion assessment. Primarily worked
with CEO, CFO and IT management.
The site assessment provided both the
project deployment management and the local management with important
information on the current state of the business and the readiness for
implementation.
|
|
Customer
|
GE Capital Global Consumer Finance (GCF)
|
|
Project
|
Budgeting implementation and Technical
assistance May 1998 to September 1998.
|
|
Role
|
Functional and technical lead.
|
|
Details
|
Implementation of budgeting in Norway and
managing the rollout in Scandinavia, USA and UK. The implementation included
amendment to existing Excel models, Oracle ADI and Oracle OFA budget upload
and design and download of FSG reports.
Designed the worldwide budgeting
consolidation model in order to enable aggregation of budgets from country
level to regional and corporate level.
The complexity where high due to 26
period year.
Providing technical project support in
Norway, including supporting the SmartClient to NCA upgrade from the client
side.
Responsible for Norwegian budgeting
implementation and applying a global approach to the budgeting process.
Supported and managed budgeting rollout in Sweden, Denmark, UK and USA.
Responsible for preparing, testing and
education around the upgrade.
The project enabled the business to work
with budgets inside Oracle Applications and provided a solid foundation for
reporting alongside a controlled method of storage for agreed budgets.
|
Other Project Experience previous employers -
Summary
|
Employer
|
EDS Denmark
|
|
Projects
|
FLS-ITD 1998: Feasibility study of
integration between PO and a Unisys based system.
FLS-ITD 1998: Prototype implementation of
Applications for the web (Oracle Applications self-service applications version
1).
Superfos Construction 1998:
Pre-implementation analysis of implementing Oracle Projects in a tarmac
production and layout company.
Monberg & Thorsen A/S 1997-98:
Technical co-ordinator in system delivery. Ensuring deliverables from
subcontractors. Responsible for technical implementation issues. Done full
scale (90Gb) installation of Oracle Applications 10.7 with SmartClient in
development, test and production environment. Assisted in implementation of
Oracle General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets,
Cash Management, Project Accounting and Billing.
|
|
Employer
|
Copenhagen Fur
Sales
|
|
Projects
|
System Implementation and development:
Rewrote and migrated a major statistical data warehouse application, based on
Oracle Pro*C, from DEC/Unix mainframe to Windows NT. I gained an improvement
in speed of 10 times.
Technical co-ordinator and contract
management in Concorde XAL implementation project.
1995: Consultant in logistics BPR
project. Radically changing the supply chain and involved business processes.
1997: Consultant in production
development project involving automation of a manual production line.
|
|
Employer
|
Oracle Denmark
|
|
Projects
|
1990: Project management of custom
designed order entry system in Norway, Sweden and Belgium.
Oracle 1991: Technical implementation of
first Oracle Applications installation in Denmark of GL, AR, and RA. First
time solutions to set-up, business implementation and reporting issues.
Burwain Shipholding 1991: Functional and
technical interfaces design for Oracle GL.
AMIKO 1991-95: Project management,
functional design, development and implementation of interfaces between PO
and consignment stock inventory system. Custom forms and Interface design and
development to other IKEA systems.
Telecom A/S 1992-94: Design and
development of AR/RA security features.
Design and development of reports.
Implementation support in complex set-up
issues regarding accounting structure.
|
|
|
