CV/Mission OFA freelance

Exemple des missions de Clive,
freelance OFA résidant dans ?

mars 2015 - juillet 2015
Dairy Crest Oracle Financial Analyser, system split for proposed sale of Dairies business.

Vodafone (Sep 2013 to Mar 2014), Oracle OLAP development with SDMC Consulting, extending systems for Cable & Wireless merger.

Between 2011 and 2013 I worked on various short-term freelance assignments for clients in Florida and Dublin, using Oracle OLAP and Express.

Cap Gemini / House of Fraser (Jan, Feb 2011) as Oracle OLAP Consultant on Business Intelligence project, using Oracle 11g (11.2.0.1.0) OLAP with AWM, developing cubes and SQL views

.
Department of Work and Pensions (May 2010 to Oct 2010), OFA Consultant on systems for several government departments, involving Business Analysis, Development and System Documentation

GE Money (May 2007 to Jul 2008), supporting and developing their very large global OFA databases. Supporting and developing their offshore teams in Mumbai, India and Chengdu, China. Performance tuning, Oracle Express (OLAP) and Express Web Agent developments, Business Analysis, report development

E.On Powergen (Jun 06 to Mar 07), developing a new Oracle OLAP based system for Electricity Demand Forecasting. The development was in Oracle 10g OLAP, using Analytic Workspace Manager (AWM), Oracle BI Discoverer, Oracle BI spreadsheet add-in and PL/SQL.
Defra (Department for Environment, Food and Rural Affairs) (Feb, Mar 06), developing a pilot implementation of Oracle Enterprise Planning and Budgeting (OEPB, based on Oracle 9i OLAP), demonstrating system capabilities.
Fujitsu UK (Nov 04 to Feb 06), OFA consultant on a very large Oracle OLAP implementation for DWP (Department for Work and Pensions), based in Manchester, Leeds, Blackpool and Newcastle. OFA 6.34 and Express 6.4

Zone Vision (Feb 04 to Apr 06), designing, developing and implementing an OFA system to run Budgeting, Planning and Actuals reporting for this Digital Media (Satellite and Cable) distribution organisation (now part of Chellomedia).

GE Housing Bank of Poland (Jun to Nov 03), Warsaw, developing a new OFA data collection and reporting system for this mortgage lending bank, mainly for providing timely statutory reporting to the National Bank of Poland.

2003 - aujourd'hui
RBS Insurance Services (including Direct Line and Green Flag) developing enhancements to their OFA systems, especially on an Allocations system.

Other assignments included Agilisys and Virgin Atlantic Airways (2002 and 2003).

As a Senior Consultant for Oracle Corporation (UK),
septembre 1996 - septembre 2002
I worked on many client projects as a specialist in Oracle Financial Analyser (OFA) and Oracle Express (now known as Oracle OLAP), and was also trained in Oracle Warehouse Builder (OWB) and Datawarehousing.

Lloyds TSB. Lead consultant in developing the OFA model for the General Efficiency Program (GEP). This project collected and consolidated Project Business Cases, and allowed forecast revisions and monitoring against actuals.
GE Capital Insurance Holdings. Lead consultant for a new OFA implementation for Budgeting, Planning and Management Reporting. Multiple currencies were supported for data entry and reporting.
Jarvis plc. Lead Consultant developing the Cost Value Reconciliation system, built within a very tight deadline by a team of up to 4 consultants. Many of the client’s requirements, such as a hierarchical approval mechanism, required customisations.
Other clients included Post Office Counters Ltd, Unilever, Aggregate Industries, Sainsburys, Freemans, Allders, Cap Gemini, Alliance and Leicester, GE Capital European Equipment Finance, GE Consumer Finance, ntl, Direct Line.
For some of these projects, such as Unilever and Jarvis, I was Project Manager with responsibility for delivering completed systems within very tight deadlines, leading small teams of very technical Oracle Consultants. At Unilever, the OFA project was a Europe-wide implementation for managing Budgets and Forecasts at plant level. At Jarvis, the project was a customised implementation to consolidate Cost Value Reconciliation data, and ensure appropriate authorisation at different levels of the management hierarchy.

Operating Systems for these Oracle-based projects have included HP Unix, Sun Solaris, Microsoft NT Server, DEC Alpha, Sequent Dynix.

As a Project Manager for Coopers and Lybrand (now Pricewaterhouse Coopers)
1989 - 1996
I had responsibility for managing all PC based Finance systems including Pensions, Partner Accounts, Budgeting and Planning, then later with responsibility for all Management Information and Decision Support systems. Team sizes depended on the projects undertaken, but normally varied between 2 and 8.

As a Senior Analyst Programmer for Tesco Stores Ltd
1983 - 1989
I worked initially as an Information Centre Analyst, supporting the earliest introductions of Personal Computers to Tesco Head Office. I then moved to the IT Development division to work on Finance Systems, and this included several multi-dimensional database systems, for example for analysing the profitability of projected new store developments, and for planning and forecasting Profit and Margin at the level of the individual store by Month.

Highlights
1979 - aujourd'hui
Wide experience in the IT industry, as Programmer, Systems Analyst, Business Analyst, Project Leader, Project Manager, System Designer,

Consultant, Developer and OLAP specialist. Since 2002 I have been working as an independent Business Intelligence Consultant (Orion Bay ltd), specialising in Oracle Business Intelligence and multi-dimensional (OLAP) technology.
Experience in many sectors, especially Financial, Utilities, Retail, Government and Insurance.
Deep specialist knowledge of Oracle OLAP technology, including Oracle 9i, 10g and 11g OLAP, Oracle Financial Analyser (OFA), Oracle Express (OLAP server), Analytic Workspace Manager (AWM). Some experience with Oracle Enterprise Planning and Budgeting (OEPB), Oracle Warehouse Builder (OWB).

Oracle Hyperion Essbase 9.3 Developer Certified Expert (November 2009)

As an independent Business Intelligence Consultant (Lightship Consulting ltd and Orion Bay ltd, since Sept 2002) I have worked on these projects: