$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
EPM / BI Developer / Architect
Robert Angel
,
Newcastle Upon Tyne
Experience
Other titles
Skills
I'm offering
Specialties: PBCS, Hyperion Profitability and Cost Management, Hyperion Essbase, Hyperion Planning and Budgeting, OBIEE, ODI, Oracle database (pl/sql), Oracle e-Business Suite.
Innovative and experienced technical consultant with a consistent record of successful delivery for a vast portfolio of clients from sectors including retail, marketing, financial services and public sector.
• Analysis, design and development of budgeting and planning solutions, profitability, reporting Essbase databases and Management Information Systems and key performance indicator dashboards - 5+ years
• ODI ETL / Data Migration very large scale solutions for major clients
• Superlative systems experience, specialising in Oracle e-Business Suite 11i / 12.1 (PO, GL, AP, INV, AR, CM) and Bespoke Solution Development; includes system implementation and upgrade, systems analysis and development, extensive API experience - 10+ years experience
• Proven leadership skills; - project management, developing and motivating teams
• Strategic Business Management and Planning in highly complex large scale organisations
• Business case, technical and functional specifications; presents at executive level
• Process re-engineering and change control with a consultative approach to ensure realism and buy-in, coupled with the relentless application of drive and creative intelligence
• Extensive supply chain re-engineering and e-business experience as the technical lead for Leeds Teaching Hospitals multi award winning Department of Supplies
• Full systems lifecycle experience – investigation, analysis, software design, software development, testing, implementation, training and review for major system developments
• Qualified Accountant (ACCA) with extensive post qualification experience in enterprise systems, change management, statutory and management accounting, large scale (£10m+) budgeting experience
Innovative and experienced technical consultant with a consistent record of successful delivery for a vast portfolio of clients from sectors including retail, marketing, financial services and public sector.
• Analysis, design and development of budgeting and planning solutions, profitability, reporting Essbase databases and Management Information Systems and key performance indicator dashboards - 5+ years
• ODI ETL / Data Migration very large scale solutions for major clients
• Superlative systems experience, specialising in Oracle e-Business Suite 11i / 12.1 (PO, GL, AP, INV, AR, CM) and Bespoke Solution Development; includes system implementation and upgrade, systems analysis and development, extensive API experience - 10+ years experience
• Proven leadership skills; - project management, developing and motivating teams
• Strategic Business Management and Planning in highly complex large scale organisations
• Business case, technical and functional specifications; presents at executive level
• Process re-engineering and change control with a consultative approach to ensure realism and buy-in, coupled with the relentless application of drive and creative intelligence
• Extensive supply chain re-engineering and e-business experience as the technical lead for Leeds Teaching Hospitals multi award winning Department of Supplies
• Full systems lifecycle experience – investigation, analysis, software design, software development, testing, implementation, training and review for major system developments
• Qualified Accountant (ACCA) with extensive post qualification experience in enterprise systems, change management, statutory and management accounting, large scale (£10m+) budgeting experience
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Full time contractor
Available
My experience
2017 - ?
job
PBCS Architect / Developer
CallCredit Information Group.
Role developing Planning and Budgeting Cloud Services(PBCS) for budgeting, forecasting and actual reporting purposes. Developing data integrations with PBCS to / from Oracle Fusion Financials and Oracle HRMSBuilding forms, reports, smart view templates, task lists, business rules, smart pushes, developing epmautomate scripts and Java programs to automate backups and other scheduled business tasks, building web reports, end user analysis, troubleshooting, putting in place business continuity plans, developing associated business processes, training end users, development of end user collateral. Building new applications for modelling driver driven budgeting and forecasting, linked to final chart of accounts analysis. Building ETL to provide IFRS15 usage matching of contract to service usage, Oracle database development (VM) including pl/sql.
Oracle database, Processes, Oracle Database development, Web, Development, Developer, Cloud services, Service, Pl/sql, Sql, ETL, Cloud, Database, Forecasting, Training, Oracle, Java
2017 - ?
freelance
Independent Contractor trading
Angel Applications Ltd.
2017 - 2017
job
Architect Analyst
South Yorkshire and Humberside Police.
and Developer
Role Data warehouse development using ODI to populate star schemas related to vulnerable persons. Migrating business critical information systems from Business Objects to OBIEE, developing over 10 large scale subject areas in OBIEE repository and associated end user reports and dashboards, business analysis and
Role Data warehouse development using ODI to populate star schemas related to vulnerable persons. Migrating business critical information systems from Business Objects to OBIEE, developing over 10 large scale subject areas in OBIEE repository and associated end user reports and dashboards, business analysis and
Business Analysis, Data Warehouse, Developer, Analyst, Development
2016 - 2017
job
information Architect
Oracle.
Oracle has #100 of the fortune #100 as customers and is the #1 IT provider of enterprise scale hardware and software in a wide range of highly competitive markets.
Information Architect role delivering large scale Business Intelligence projects for financial sector and military intelligence including; Cloud solutions, ODI ETL development, OBIEE, OBIA, Big Data, Business Analysis, use cases and user stories, agile scrum leader.
Information Architect role delivering large scale Business Intelligence projects for financial sector and military intelligence including; Cloud solutions, ODI ETL development, OBIEE, OBIA, Big Data, Business Analysis, use cases and user stories, agile scrum leader.
Scrum, Business Intelligence, Business Analysis, Oracle, Big Data, Agile, Cloud, ETL, User stories, It, Hardware, Development, Software, Enterprise
2015 - 2015
freelance
Lead Oracle Business Intelligence Consultant
Fujitsu.
Fujitsu is the leading Japanese information and communication technology (ICT) company offering a full range of technology products, solutions and services. Approximately 162,000 Fujitsu people support customers in more than 100 countries.
Lead Consultant role delivering a large scale Business Intelligence project (£25m deal, 50000 users) for central government departments including; ODI ETL development for e-Business suite data cleansing and load to API, VM, OBIEE / OBIA Financials HR and payroll, GoldenGate, VPD.
Lead Consultant role delivering a large scale Business Intelligence project (£25m deal, 50000 users) for central government departments including; ODI ETL development for e-Business suite data cleansing and load to API, VM, OBIEE / OBIA Financials HR and payroll, GoldenGate, VPD.
Business Intelligence, API, Oracle, ETL, Technology, Support, Development
2012 - 2015
job
Business Intelligence Architect
Peak Indicators.
Peak Indicators is an SME solely specialising in Oracle Business Intelligence Solutions, an Oracle Gold Partner that is an Official Oracle University Trainer, providing consultancy services to a variety of clients.
• OBIEE Development / Data warehousing
◦ Leading large scale multi-million pounds Business Intelligence implementations, upgrades and long-term development projects
◦ Creation of a data warehouse / ETL processes from Oracle e-Business to provide a sound platform for OBIEE based on Oracle e-Business and other legacy database sources
◦ Building advanced reports, sophisticated dashboards
◦ Modelling repository business models and presentation layer from star schemas, RDBMS, XML and flat files, Essbase metadata management / Shared Library
◦ Upgrades and patching
• Recruiting, mentoring and developing teams
• Client facing roles as project lead analysing and delivering BI solutions to clients including health, retail, multi-national leisure corporations, banks and financial services
• Managing teams of analysts and developers in delivery of OBIEE and associated datawarehouse managed services
• Leading end user workshops to extract functional requirements
• Extending OBIA functionality in repository and in associated ETL
• Developing SQL for inclusion in informatica ETL in conjunction with informatica developers
• Developing ETL to load Essbase and star schema for OBIEE reporting
• Creating training courses, pre-sales and technical presentations for OBIEE, pl/sql, EPM / Essbase
• Keeping technical skills abreast of the latest developments
• Troubleshoot Production issues, identify root cause and migrate fixes
• Develop reporting standards and best practices to ensure data standardization and consistency
• Perform data cleansing and data auditing as necessary to ensure data quality
• Define and develop physical and logical data models to support departmental and functional reporting needs
Lead Architect: RBS: Hyperion Profitability and Cost Management; £5m project delivering 3 HPCM models for management accounting and statutory / taxation requirements with OBIEE dashboard reporting and ODI ETL as a key part of the banks cost cutting programme
Lead Architect: An Post:: Installing and configuring Essbase 11.1.2.3 Prod and Dev environments, migrating 96 large scale Essbase retail databases to Essbase 11.1.2.3 with ODI ETL, documentation
Lead Architect: CH&Co: Developing two Essbase cubes based on JDE SQL feeds for data and metadata, delivering workshop demonstration sessions, training users, advising on best practise, documentation
• Developing Hyperion / Essbase as a major new income stream for Peak Indicators
• Hyperion Essbase / Hyperion Planning and Budgeting Development / Hyperion Profitability and Cost Management
◦ Import and interfacing hierarchical metadata BSO / ASO
◦ Advanced Form development
◦ Developing multi-stage Profitability and cost allocation models
◦ Business Rule development to create phasing functionality, percentage based changes on data ranges, export data to ERP, combine scenarios and extract differences
◦ Modelling budgets, forecasts and long term plans
◦ Performance tuning extremely large scale Essbase cubes
◦ Import of actuals, export of budgets to interface into ERP on an incremental basis
◦ Embedding calculations in dimension members for forecasting, variance analysis, average cost per unit etc
◦ Data form, menu and task list design, MDX queries, MAXL scripts, business rules
◦ Creation of mass data validation routines to raise the quality of budgetary input
◦ Integrating Essbase into OBIEE 11g for superior reporting functionality
◦ Creating reports using financial reporting studio, SmartView and OBIEE 11g
◦ Hyperion and Essbase healthchecks
◦ Migrating and upgrading Hyperion solutions
◦ Leading analysis workshops and UAT processes
• Developing Essbase and Hyperion training courses
Lead Consultant international Project Experience in the following sectors; -
• Healthcare / Pharmaceutical Industry
• Retail Sector
• Supply Chain
• Banking / Financial services
• OBIEE Development / Data warehousing
◦ Leading large scale multi-million pounds Business Intelligence implementations, upgrades and long-term development projects
◦ Creation of a data warehouse / ETL processes from Oracle e-Business to provide a sound platform for OBIEE based on Oracle e-Business and other legacy database sources
◦ Building advanced reports, sophisticated dashboards
◦ Modelling repository business models and presentation layer from star schemas, RDBMS, XML and flat files, Essbase metadata management / Shared Library
◦ Upgrades and patching
• Recruiting, mentoring and developing teams
• Client facing roles as project lead analysing and delivering BI solutions to clients including health, retail, multi-national leisure corporations, banks and financial services
• Managing teams of analysts and developers in delivery of OBIEE and associated datawarehouse managed services
• Leading end user workshops to extract functional requirements
• Extending OBIA functionality in repository and in associated ETL
• Developing SQL for inclusion in informatica ETL in conjunction with informatica developers
• Developing ETL to load Essbase and star schema for OBIEE reporting
• Creating training courses, pre-sales and technical presentations for OBIEE, pl/sql, EPM / Essbase
• Keeping technical skills abreast of the latest developments
• Troubleshoot Production issues, identify root cause and migrate fixes
• Develop reporting standards and best practices to ensure data standardization and consistency
• Perform data cleansing and data auditing as necessary to ensure data quality
• Define and develop physical and logical data models to support departmental and functional reporting needs
Lead Architect: RBS: Hyperion Profitability and Cost Management; £5m project delivering 3 HPCM models for management accounting and statutory / taxation requirements with OBIEE dashboard reporting and ODI ETL as a key part of the banks cost cutting programme
Lead Architect: An Post:: Installing and configuring Essbase 11.1.2.3 Prod and Dev environments, migrating 96 large scale Essbase retail databases to Essbase 11.1.2.3 with ODI ETL, documentation
Lead Architect: CH&Co: Developing two Essbase cubes based on JDE SQL feeds for data and metadata, delivering workshop demonstration sessions, training users, advising on best practise, documentation
• Developing Hyperion / Essbase as a major new income stream for Peak Indicators
• Hyperion Essbase / Hyperion Planning and Budgeting Development / Hyperion Profitability and Cost Management
◦ Import and interfacing hierarchical metadata BSO / ASO
◦ Advanced Form development
◦ Developing multi-stage Profitability and cost allocation models
◦ Business Rule development to create phasing functionality, percentage based changes on data ranges, export data to ERP, combine scenarios and extract differences
◦ Modelling budgets, forecasts and long term plans
◦ Performance tuning extremely large scale Essbase cubes
◦ Import of actuals, export of budgets to interface into ERP on an incremental basis
◦ Embedding calculations in dimension members for forecasting, variance analysis, average cost per unit etc
◦ Data form, menu and task list design, MDX queries, MAXL scripts, business rules
◦ Creation of mass data validation routines to raise the quality of budgetary input
◦ Integrating Essbase into OBIEE 11g for superior reporting functionality
◦ Creating reports using financial reporting studio, SmartView and OBIEE 11g
◦ Hyperion and Essbase healthchecks
◦ Migrating and upgrading Hyperion solutions
◦ Leading analysis workshops and UAT processes
• Developing Essbase and Hyperion training courses
Lead Consultant international Project Experience in the following sectors; -
• Healthcare / Pharmaceutical Industry
• Retail Sector
• Supply Chain
• Banking / Financial services
Sales, Processes, MDX, Calculations, Workshop, Tuning, Production, International, BEE, Health, Development, Data quality, Support, Workshops, Banking, Pharmaceutical, Design, Pl/sql, Management, ETL, Mentoring, Data Warehouse, Database, ERP, Forecasting, XML, Training, Retail, Oracle, Business Intelligence, Sql
2004 - 2012
job
Leeds Teaching Hospitals -Director
Finance Systems.
(Leeds Teaching Hospitals has; - 15,000+ staff, 5 sites, £800m budget)
• Hands on project management of a wide variety of financial systems implementation, customisations and upgrade projects including; -
◦ OBIEE and associated data warehouse, dashboards rolled out to over 800 end users
◦ Oracle e-Business 11.5.9 (AP,PO, GL, INV)
◦ Oracle databases 11r2, 10g, express, 9i
◦ Oracle software development of Forms, reports, workflow and pl/sql packaged procedures to extend Oracle e-Business 11.5.9 functionality
• Managing 3rd party software providers to deliver on various projects including; -
◦ Document Archiving solutions, Data warehouse projects, RFID projects (http://www.gs1.org/docs/healthcare/case_studies/Case%20study_Leeds%20Teaching%20Hospitals_Technical_Nov09.pdf), Financial System implementations and data migration
• Analysis, design and development of OBIEE Management Information Systems and associated data warehouse ETL procedures
• Oracle Upgrade - migrating customisations and interfaces, UAT scripting, support and coordination, training users, system configuration
• Technical representative and financial change resource, delivering a rolling programme across the Trust to deliver efficiencies, yield recurring savings and raise effectiveness
• Hands on project management of a wide variety of financial systems implementation, customisations and upgrade projects including; -
◦ OBIEE and associated data warehouse, dashboards rolled out to over 800 end users
◦ Oracle e-Business 11.5.9 (AP,PO, GL, INV)
◦ Oracle databases 11r2, 10g, express, 9i
◦ Oracle software development of Forms, reports, workflow and pl/sql packaged procedures to extend Oracle e-Business 11.5.9 functionality
• Managing 3rd party software providers to deliver on various projects including; -
◦ Document Archiving solutions, Data warehouse projects, RFID projects (http://www.gs1.org/docs/healthcare/case_studies/Case%20study_Leeds%20Teaching%20Hospitals_Technical_Nov09.pdf), Financial System implementations and data migration
• Analysis, design and development of OBIEE Management Information Systems and associated data warehouse ETL procedures
• Oracle Upgrade - migrating customisations and interfaces, UAT scripting, support and coordination, training users, system configuration
• Technical representative and financial change resource, delivering a rolling programme across the Trust to deliver efficiencies, yield recurring savings and raise effectiveness
Management, RFID, Http, Express, Software, Development, PDF, Workflow, Implementation, Support, Pl/sql, Design, Scripting, ETL, Teaching, Data Warehouse, Budget, Training, Software development, Oracle, Project Management, Sql
2002 - 2004
job
Data Coordination Manager in ICT
NHS Shared Financial Services.
Managing the migration of 20+ NHS Trusts on to a shared financial system to a very tight timescale; managing external IT contractors to deliver Oracle customisations; recruitment and development of IT staff, Managing in-house development team, Managing large scale IT budgets, Managing IT projects
Oracle, Recruitment, It, Development, Manager
2001 - 2002
job
Oracle Financial Systems Manager in Corporate Finance
unknown.
Managing Financial Systems Office, External / internal audit liaison, Development and implementation of procedures, e-procurement project work, Oracle interfacing and bespoke solution development utilising PL/SQL / forms / reports
Sql, Oracle, Audit, Procurement, Pl/sql, Finance, Implementation, Development, Office, Audit, Manager
1998 - 2001
job
Lead Accountant
Leeds City Council.
Accountant
1987 - 1990
job
Library Automation Scheme Project Manager
Becketts Park Library.
Project managing the data migration work for population of a country wide database.
Project Manager, Database, Automation, Manager
1983 - 1987
job
Computer Programmer
Systime.
Development of complete financial systems for solicitors, travel agents and hotels using 3GL computer languages.
Development
My education
1997
-
1999
Leeds Beckett University
Association of Chartered Certified Accountants, Accountancy, Finance, Management, IT
Association of Chartered Certified Accountants, Accountancy, Finance, Management, IT
Robert's reviews
Robert has not received any reviews on Worksome.
Contact Robert Angel
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Robert directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark