Resume of Business Intelligence Lead

Title
Business Intelligence Lead

Primary Skills
business intelligence,data warehouse, master data, ETL, oracle, SQL, SQL server, OLAP, Reporting, Modelling, Kalido

Location
United Kingdom-London (will consider relocating)

Posted
Apr-10-08

Summary:
I am an experienced Business Intelligence professional. I
have designed, implemented , supported and managed enterprise data warehouses for
multi-national companies such as Unilever, BP (British Petroleum) and KBR
Inc. I am experienced in master data management, ETL processing, data
integration, data warehousing and reporting on management information.

Objective:
To move toward strategic positions regarding designing and implementing Enterprise Information Systems that bring business modelling to the foreground of information management, closing the gap between business and IT.

Experience:
KBR / MWKL UK Data Warehouse Technical Lead: April 2006 --Current -Consultant
Data warehouse technical lead for a data warehouse/Master Data solution providing reporting to KBR, MWKL and Shell for a 12 Billion dollar 'Gas to Liquid' refining project
• Technical owner of the data model and managed all aspects of the Data Warehouse Environment
• Review of the early dimensional model and recommended improvement actions for the model and architecture
• Data architect responsible for the continued modeling/design, extensions and implementation, driven by a flexible business model.
• Reconciled and Integrated data from multiple sources into a single analytic data mart to address complex queries serving users a full picture for the first time from one trusted data mart.
• Architecture of the server/software stack-multiple environments. Move to a High Availability so-lution with Oracle RAC. Dev, UAT and Production Instances
• Scheduling/Management of Development to Production moves
• Business Analysis of requirements with business analysts / users and creation of the business and data models/maps
• Replacement of the current snapshot process which was complex, difficult to maintain /extend
• Collision management of subject area sub-developments -- change impact analysis
• Lead the Architecture and design the file definitions that load the data, the data marts and the production schedule.
• Source system database analysis to select correct data as required in support of model design
• Optimize performance of data warehouse. Operational section vs. Analytical Section
• Incorporated Data Quality processing into the design of the model and ETL processes
• Resolving ongoing master data issues with the business and source system owners regarding data quality/process and the impact of these on the warehouse.
• Introduced exception reporting and specification of source to target data maps
• MDM(Master Data Management) for reference data --monitoring data, processes and workflows
• Subject areas(dimensions) of data model include plant, documents, organization, suppli-ers/customers, time, accounts payable, location, status, indicators, person (not exhaustive)
• Design of advanced Model structures -- super/subtypes, unbalanced hierarchies etc
• Participated in team investigating use of SOA as an architecture
• Production of Business Cases, business analysis and process flow for MDM
Core Technologies: Oracle 10g - Oracle Ware House Builder - Kalido Data warehouse - SQL
- Kimball Method - Fast Radar/OLAP -- SQL Server 2005

BP Plc UK - Senior Data Warehouse Analyst: July 2005 -March 2006 -Consultant
The Business Intelligence and Global Standards Programme (BIGS) is a strategic transformational project within the BP Lubricants SPU, providing the infrastructure to enable SPU global strategy and its value deliv-ery. It was implemented in 30 countries.
• Focus to ensure that the business requirements are supported by the model and that best practice design concepts are maintained
• Delivered the data-warehouse implementation of the Global Data-Warehouse Instance. This data-warehouse federation results in 30 countries delivered from regional instances, also includ-ing all other countries from multiple data feeds being reported on from the data warehouse.
• Extension of the existing Model for plan and forecast data model to integrate financial data. De-livered the data-warehouse part of the implementation of the European Regional Instance. Data analysis on source system. Multiple iteration's of data extraction logic. Issue resolution in the extracts and meta-data in order to fulfill the requirements of the data model.
• Master Data validation and incorporation into reference data -- hierarchies and validity
• Design and optimization of the transaction and reference data loads into the warehouse.
• Lead Data Warehouse designer of team implementing Turkey regional instance In-Country.
• Issue resolution with the business team to ensure business requirements are understood, aligned with and supported by the data model.
• Extended dimensional model while maintaining global model.
• ETL design mappings /source to target
• Participated in Global Standards Change Management Meetings for change impact assessment
• Maintenance/Change/migration of the data model.
• Full life cycle project implementation --Dev/UAT/Prod
Core Technologies: Oracle 9i/10g - Informatica ETL - Kalido Data warehouse - SQL
-Kimball Method - Business Objects

Unilever Best Foods UK- Data Warehouse Analyst: Jan 2004 -- July 2005 -Consultant
A European Data warehouse was developed for the provision of regional European Data warehouse solu-tion for finance and sales data in Unilever European Information Management centre.
• Part of Pan European team that has rolled out a sales and finance Data warehouse solution based on a European data model to 6 countries in 2004.
• Project resource for extension of the data warehouse to incorporate country historic data as well data from companies acquired by Unilever
• Environment installation/management
• Maintenance of the European data model, star schema and hierarchies.
• Development of interfaces between data warehouse and user applications. (OSA/ OFA)
• One of team members responsible for internal consulting on change requests and business re-quirements. (Development/design of Data marts /star schemas and dimensional data models)
• Gap analysis on the impact / feasibility of integrating Supply chain data into the data warehouse.
• Lead Design of the data model for the pilot for the integration of CRM data (Siebel CRM)
• ETL and Data Warehouse development.
• Proof of concept on SQL Server Analysis Services for data-marts. Star schema and data model.
• Team lead for Sarbanes Oxley process compliance on architecture and security across 3 teams in Information Management centre.
• Daily loading, maintenance, tuning, testing of the data warehouse.
• Full life cycle project implementation --Dev/UAT/Prod.
• Team spread across the UK and Netherlands
Core Technologies: Oracle 10g -- Business Objects data Integrator - Kalido Data warehouse -- SQL
- Kimball Method -- SQL Server 2000 -- SAP R3 as Source

EmailVision UK- Senior Solution Consultant- Data Services: Jan 2001 - Dec 2003
E-Mail Vision is a Web Based ASP solution across Europe, which provides Database Marketing solu-tions to the Direct Marketing Industry delivering targeted content for household names.
• Designed and implemented the companies first Global reporting system across 3 countries through use of ETL, a Data Warehouse, Data model, hierarchy, OLAP and Data Ana-lyzer/Excel/Web /SQL Server
• Created a new revenue stream from client data mart design/Integration and OLAP\(Analysis Services) reporting via a data warehouse.
• Primarily responsible for the analysis and project management of both integration and customer intelligence solutions for London, Paris and German offices. Lead 3 person team
• Team lead for the development of solutions as according to client and internal requirements.
• Developed/implemented multiple client data solutions and procedures to ensure that client data is incorporated into E-mail Vision's own Web based ASP solution using both procedure and technical tools. Developed fully automated process and procedure enabling upload, extraction and hygiene of client data.
• Worked with Account Mangers and Clients to ensure that these data solutions meet client data and business rules requirements while fitting into the ASP solution.
• Technical consultant/analyst on client projects to advise and set out project scope and design
• Ensured that the 24hour turnaround time on daily (non project) Sla's are adhered to. .
• Custom integration for household name clients (Blue Chip) into and out of the ASP solution (ETL-SQL Server DTS)
• Full responsibility for production ETL and Data Warehouse Server
• Consulting/Analysis for both client and internal Account Managers on data, integration and cus-tomer intelligence requirements. Customer facing role.
• I was able to reduce reporting times on key accounts from days to minutes.
• Team spread across UK, France and Germany
Core Technologies: Oracle 8i -- SQL Sever DTS ETL - Kalido Data warehouse - SQL - Kimball Method
- Analysis Services/OLAP -- SQL Server 2000 -- Linux/Windows

Australian High Commission UK- Junior DBA: Nov 1999- Dec 2000
Australian High Commission (Department of Immigration) issues visas for all travel to Australia, ensuring that all government laws and regulations are upheld.
• Maintained the London database as London's onsite resource for a global immigration data-base.
• Handled IT relationship with outsourced Australian IT provider while maintaining the net-work and resolving network and database issues. On site responsibility.
• Project lead for upgraded website (coding and information architecture) in readiness for the Olympic Game's. This enabled funding for the updating of the design of the website.
• IT resource for a new office space -- extension of the network --Windows NT and UNIX
Core Technologies: Oracle 7i - SQL - Kimball Method--Unix AIX -- NT Server and Client

Lombard Leasing UK -Project Accountant: June 1999- Nov 1999
Lombard is the Leasing arm of Natwest Bank.
• Project Accountant employed by IT projects looking after group of 8 companies totalling £800,000s.
• Financial and management accounting.
• Responsible for data analysis of successful automation project reducing 'Income report' gen-eration from 5 days to a 1 day. Data Analysis and Automation of numerous reports. Ex-cel/SQL/Hyperion Financials

Accountant -1996 -- 1999 : South Africa
Multiple Accounting Positions employed as an accountant for a Sports retail chain as well as being a articled clerk for a Chartered Accounting firm.
Responsibilities for P&L, balance sheet, audit and tax and Management Reporting

Education
University of Natal - Durban - South Africa
Bachelor of Commerce (1990-1992) (Business Administration / Law)
Bachelor of Law (1993-1994) (Contract / Business Law)
Microsoft Systems Engineer (MCSE NT4 - 1999)

Certifications
University of Natal - Durban - South Africa
Bachelor of Commerce (1990-1992) (Business Administration / Law)
Bachelor of Law (1993-1994) (Contract / Business Law)
Microsoft Systems Engineer (MCSE NT4 - 1999)


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in United Kingdom-London »
View all resumes in United Kingdom »

View other Business Intelligence Lead resumes