| Category: | Consultant | | Location: | Netherlands, | | Type: | project contract, full time employee, part time employee, freelancer | | Homepage: | | | Education: | | | Experience: | Paul Gale
Senior Business Intelligence Consultant
E-Mail: pgale@pagabv.com Mobile: +31 65 192 4141/+44 7523 410009
Linkedin: http://nl.linkedin.com/in/paulgale/
Personal & Professional Profile
I am an experienced BI Consultant with management and hands on development experience. My BI skills and understanding of DW Architectures and concepts (Inmon, Kimball, Data Vault) are excellent. I have worked with most databases (MS SQL Server, Oracle, Sybase, Teradata, MYSQL). My experience with Business Objects, Microsoft SQL Suite, SQL and ETL knowledge is very good.
I have worked extensively with SSRS and SSIS, occasionally with SSAS delivering successful projects. I have also delivered successful BODI projects. In addition I have project management experience and a good understanding of Agile and Waterfall. I have worked with OS such as VMS, Unix, Linux and Windows which provides me a wide ranging understanding of IT support and delivery. In addition I have an ITIL background and have worked not only with several service management tools but also as an ITIL consultant.
My biggest strengths lie in problem solving, analysis and my ability to deliver successful projects, be they hands on development, training, project management, management/leadership, or just communication. I am calm, intelligent and strong minded yet friendly and open minded.
My IT career began as a programmer and throughout my career I have consciously tried to maintain and update my skills, ensuring I still have a good understanding of programming in a number of languages and am more than capable of reading/ modifying code.
I have always been customer focused, worked in a number of countries, been self sufficient on site whilst ensuring my parent company was kept up to date. I took on various responsibilities including supporting the EMEA indirect sales channel (pre and post sales support).
I am a good communicator at all levels, enjoy gathering business requirements and scoping projects whilst always retaining good business focus. I have a good understanding of IT's role within businesses and good process knowledge across a number of domains.
For recommendations see my View Paul Gale's profile
Technical Skills
Systems/OS: Microsoft Windows, Linux, Unix (Solaris, AIX), VAX VMS
Technologies: AD, LDAP, HTML, XML, JSON , ETL, ITIL
Programming/Scripting Languages: Pascal, VB, C#, Java, PHP Perl
Tools: Nagios, Kasaye . Google Apps, Microsoft Office, Open Office/Libra Office, ClearOS. PHP. Perl, SQL (Oracle, MS SQL Server, Sybase, Teradata), Business Objects XI , Data iET Enterprise, Marval, Priox
Methodologies: Inmon. Kimball Data Vault , DSDM , ITIL
Work Experience
ITRIS B.V
(Period: Oct 2013 to Present)
Senior Business Intelligence Developer/Architect
Job Type: Contract
Assisting ITRIS to determine the content, functionality and architecting solutions for their Data warehouse, Business Intelligence environments using SAP BusinessObjects Data Services and Oracle, integrating with content and business process management software to calculate complex financial risk ratings.
Acknowledge BV
(Period: March2012 to Aug 2013)
Business Intelligence Consultant
Job Type: Contract
Acknowledge BV acquired Priox after which I continued to work on the BI model and support Priox's existing customers.
I undertook internal training of Acknowledge's staff to enable understanding of BI concepts and build reports against the Priox BI DM. I also worked on a SQL Service consolidation project for Stichting Groenhuysen one of Acknowledge's customers
I also worked on a Management Information Data Warehouse for Acknowledge which integrated a number of sources, such as service delivery, financial and support systems.
Priox BV
(Period: Jan 2010 to February 2012)
Shareholder & Director
Job Type: Shareholder
One of my main roles was to build a BI Module for the Priox Service Management Application, I took the approach of providing a ready platform for BI, which would support the customers reporting tool(s) of choice. The goal was to overcome many of the issues associated with BI adoption and provide the customers with a powerful analytic reporting platform that could be extended.
I designed a Star Schema around ITIL Service Management (SM) in general not the Priox Application directly. This provided a generic data mart. This allowed for the loading of data from other SM tools, protected the model from changes in the source database This was important because Priox's data model is not fixed, it depended on the customers configuration.
The problem was how to develop a single ETL process that could adapt to the customised source database schema. A star schema was chosen because its understood easily by most if not every reporting tool on the market and provides a powerful dimensional report model even on the simplest of tools.
The complete SSIS package consists of around 5 separate ETL packages (steps), the first part of which writes its own SQL based on Priox's system tables, this maps the customised schema to a standard data model. Life events are built from both changes in the main tables and re-constructed from historical records so that the DW does not miss any life-cycle events.
The ETL also calculates elapsed time between events based on the SLA's service windows associated with the call, i.e. work patten Monday till Friday from 09:00 – 17:30. Multiple service windows are supported. The ETL process could calculate the elapsed time between around 32000 events in around 50 seconds.
Whilst working on this project I also investigated and did some pilot projects on loading data from various IT Infrastructure Monitoring tools such as Nagios and Kaseya. The BI module is now being used by several companies in NL and one in the UK.
Harvard Technology Partners & Priox
(Period: January 2009 to February 2012)
Job Type: Freelance
I worked with both HTP in an advisory capacity on business intelligence related issues on a number of their start-up projects within the Netherlands. With Priox, a Dutch Based company providing solutions in the service management arena I worked on integration BI/BPM solutions.
ABN AMRO
(Period: November to December 2008)
Job Type: Freelance
Acted as ABN AMRO’s interface between multiple outsourced parties and managed the installation of Business Objects in a complex environment.
Ensior BV
(Period: October 2002 to December 2008)
Job Type: Shareholder & Director
I helped develop the company to the position of being one of the best-known true BI consultancy companies in the Netherlands. My responsibilities and involvement encompass many areas of the business, from HR to sales and marketing. I have played a key role in the development of the company’s strategy, especially adding value in regards to emerging trends and technologies. I took on a key role in the development of the junior consultants, resulting in the HR role becoming my responsibility, including recruitment where I have successfully developed a culture that helped encourage employee retention and attract new employees as well as introducing and developing a performance pay system. I have also been involved in technical projects and trouble-shooting throughout the company’s growth, as well as doing hands on technical work for customers.
Project managed a highly complex and difficult project but delivered it on time and within strict budget constraints. (AFM –semi-government/banking , Discovery Health - telco, Dutch-Tone – telco)
Delivery of solutions across the BI life-cycle from initial consulting, through architecting and data modelling to development and implementation. (ABN-AMRO - banking, Vodafone - telco, BuZa – government)
Designed and documented a disaster recovery plan for ensuring business continuity.
Actively contributed to the development of a new BI solution, which reduced errors and time taken to get reports to key people. This improves a company’s efficiency resulting in direct bottom line savings.
Cooperated in the development of USPs and the formation of a go-to-market strategy working with external consultants
I played a key role in the planning and development of Service Analytics solution. A rapid DWH reporting and dash boarding solution that integrates with most of the common service management tools.
I introduced a company-wide performance pay system, to reward employees, aid employee retention and protect the company against increasing pay demands.
4C Consulting BV
(Period: October 2000 to September 2002)
Senior Consultant
Job Type: Perm
I worked with customers both as a consultant and in the delivery of fixed price solutions. I was responsible for many aspects of the project life-cycle, from project management to hands on technical development. My primary function was to analyse the customer’s need and requirements and develop/implement solutions.
Implementation of Amdoc’s Clarify within an ITIL environment. This system was crucial to the support of the company’s main systems and was a key factor in improving both internal and external customer satisfaction.
Development of an application to import/export classes/objects between Clarify systems, which generated new primary key/foreign keys yet maintained referential integrity even across different database systems.
Coaching and supporting junior consultants and various project staff.
Applix BV
(Period: August 1995 to October 2000)
Various Roles
Professional Services Director (Two years) Responsibilities
I was responsible for the day-to-day operations of a 16-person department, development of policies, procedures and budgets. My primary focus was to improve customer satisfaction by focusing on delivery and quality.
Successful implementation of a methodology based around DSDM
Visiting customers on site to provide help and advice with the primary goal being to meet customer expectations
Instigated regular meetings with other managers and team members to discuss possible improvements
Service Desk Manager Responsibilities
I was responsible for the day-to-day operations of the service desk, development of policies and procedures with the goal to help improve customer satisfaction. A key aspect of this job was support and coaching of the support staff. I believe I played a key role in professionalising this department, with the result being customer retention, therefore retaining the maintenance revenue and in some cases increasing new licence revenue.
Helped develop a procedure and communication plan for both internal and external customers
The development of both internal and external service level agreements (SLAs), which played an important part in managing customers’ expectations.
EMEA Role, Distributor and Sales Support Responsibilities
A strongly commercially focused role, technical responsible for the support of the indirect sales channel. This job required flexibility and the requirement to work alone, with a high degree of responsibility, supporting both the Applix EMEA sales manager and the distributor not only in the acquisition of new customers but also in the retention of existing customers.
Honoured by being invited to the Applix presidents club four times, this club was primarily for sales rep’s that exceeded their targets. Despite having, no official sales targets I was invited on the basis of my outstanding contribution to the revenue achieved.
Successfully help developed and implement various proof-of-concepts that were instrumental in gaining some of Applix’s biggest contract
Investigated and solve distributors problems
Early Career Summary
Consultant and systems Engineer SALCOM BV, Amerfoort, The Netherlands 1993-1995
Software Developer SALCOM UK, Harbourne, West Midlands 1989-1993
Engineer Ansell Jones – Walsall, West Midlands 1987-1989
Engineer Jury Engineering – Bentley, West Midlands 1995-1987
|
| |
