-
Hawke's Bay District Health Board
- Business Intelligence Analyst/Developer
2017 - maintenant
- Support the delivery of relevant KPIs, including MOH targets, internal targets, quality and safety indicators, service plan and project KPIs, population health indicators and other HB health sector measures.
- Support the Business Intelligence team produce high quality reporting by providing an effective information management service.
- Champion the presentation of data analytics.
- Development of Business Objects universes and other semantic layers to provide an information management platform to enable reporting.
- Deliver quality data warehouse design solutions, ETL build and management for delivery of consolidated data warehouse information into the HBDHB environment.
-
CAPGEMINI
- Business Intelligence Consultant
SURESNES
2008 - 2016
2 years Business Intelligence Expert - SIMMAD (DEFENCE)
iAéro data warehouse fed with consolidated data from French military aircraft: logistics, maintenance, flight data among
other operational information. Due to rapid data growth in its iAéro data warehouse and a strong reporting development
demand, SIMMAD required a complete review of its Business Intelligence technical architecture and processes.
* Health assessment of current database modelling, data flows & reporting solutions ;
* Improving data modelling, ETL workflows and reports ;
* Migration to a multi-server architecture to deliver more maintainability, flexibility, scalability and data quality capability
* Migration of BusinessObjects XI3 to BI4 & PostgreSQL to SQLserver 2012 ;
* Development and Release process implementation ;
* Workflow monitoring reporting development
* BusinessObjects & ETL expertise
Technical Environment: SQLserver, PostgreSQL, BusinessObjects BI4 & XI3, Pentaho Data Integrator, Mantis
3 years Business Intelligence Project Manager - AGENCE DE SERVICE ET DE PAIEMENT (FRENCH ADMINISTRATION)
ASP is a government entity responsible for the payment (40 billion EUR p.a.) and follow-up of financial transactions made to
sustain numerous projects in Agriculture, Employment & Professional training.
* Coordinating and managing Capgemini consultant team (6 consultants)
* Business Intelligence Project Management in a multi-project environment
* Conception, development and release follow-up and review
* Quality insurance process implementation ;
* Participation in Steering Committee
Technical Environment: Oracle 10g, BusinessObjects XI3, Informatica PowerCenter, Talend OS, $U, Mantis
6 months Business Intelligence Project Manager - LVMH (LUXURY GOODS)
The division PCIS (Perfume & Cosmetic Information and Services) required dashboards for the operational monitoring of the
On Time / In Full logistics indicators.
* Management of the Capgemini development team (4 consultants)
* Project inception (business & technical scope), project and quote management
* Data warehouse modelling & data flow conception ;
* Implementation Quality Insurance processes with HP-QC to improve the delivery quality and the release follow-up
Technical Environment: Oracle, Datastage, Cognos, SAP, HP - Quality Center, Mantis
12 months Data warehouse Team Leader - CDiscount (E-BUSINESS)
CDiscount is the leader in French E-Business (turnover: 1.5 billion EUR p.a.)
* Data warehouse team management (9 developers) ;
* Project management in a multi-project, dynamic and competitive environment
* SDLC implementation to comply with CDiscount release procedures
* Data warehouse modelling and technical conception ;
* BusinessObjects expertise
Technical Environment: MS SQL server, Talend, Datastage, BusinessObjects XI-R2 and XI3, Mantis
6 months Business Intelligence Expert - EDF (ENERGY)
EDF needed to implement new KPI in the data warehouse to monitor the security and safety of their nuclear plants.
* Data flow technical conception ;
* Universe and report development with BusinessObjects ;
* Informatica & BusinessObjects expertise ;
* Planning and development coordination
Technical Environment: Informatica PowerCenter, Business Objects XI-R2, Oracle 10g
Other CapGemini consulting activities:
Drafting applications in response to various calls for tender with the CapGemini team, including the successful renewal of
the Agence de Service et de Paiements contract in 2009, 2011 & 2013 (300k EUR p.a.)
-
LANDSBANKI
- ETL Expert
2008 - 2008
The project aims were to create and populate the Exposure Data Mart (EDM) which will provide the input for risk exposures to the Basel 2 project.
• Design and implementation of enhanced product DataMart populated from 15 source systems
• Design and development of new counterparty DataMart using the standardized Common Customer View
• Provide technical guidance on Data Integrator
Technical Environment: Business Objects Data Integrator XI, Oracle, SQLserver
-
INFOSYS AUSTRALIA
- Business Intelligence Architect
2003 - 2007
1 month Business Intelligence Architect - GAPBUSTER (MARKETING)
To maintain its leadership in a very competitive market, GAPbuster needed a complete business processes and underlying
technology overhaul. The objective of the Infosys team was to conduct a process and application landscape assessment to
identify enhancement opportunities enabled by outsourcing and technology enhancement initiatives.
* Health assessment of current reporting, multidimensional and mining solutions
* Assess operational sources and data quality in the various data sources
* Prepare high-level functional architecture and high-level gap analysis to help define the strategic roadmap
* Recommendation for the implementation of a centralised data warehouse supported by Microsoft Business Intelligence
toolset to deliver more maintainability, flexibility, scalability, data quality and integrity capability
* Deliver a high level architecture document including a detailed planning (Development cost: $600kAUD)
Technical Environment: SQL server, Microsoft Business Intelligence Office 2005, PowerBuilder
2 months Business Intelligence Consultant - NATIONAL AUSTRALIA BANK (BANK)
The CSCM (Customer Strategy & Cross Marketing) project aim was to provide an integrated approach to sales opportunity
management through 4 key dashboards designed for local, regional and state sales leaders and relationship bankers
throughout Australia: Growth & Run Off Report, Portfolio Performance Forecast & Pipeline, Financial Performance and
Portfolio Insight.
* Perform audit of data requirements and associated data sources for the required portals
* Identify tools of choice and create prototypes using Business Objects XI (WebI, Crystal Excelsius)
* Perform the usual unit, system and UAT testing and rectify problems
Technical Environment: Windows NT, Teradata, Business Objects XI
2.5 years ETL Expert - NATIONAL AUSTRALIA BANK (BANK)
IMS (Institutional & Market Services) needed a new data warehouse (Wholesale Data Warehouse Enhancement) to migrate
all 45 interfaces feeding the current warehouse to flow into the new XML Data Store, allow reporting on revenue generated
from the Lending, Transactional Money Markets & Foreign Exchange lines of business, and feed the GDW (Global Data
Warehouse) Credit Risk Engine which will provide the input for risk exposures to the Basel 2 project.
* Develop WDW ETL jobs (~300) to agreed specifications ;
* Elaborate system requirements and design for each system
* Execute unit, integration and system testing and document results
* Contribute to the review and redesign of implementation processes to deliver improved WDW team productivity ;
* Provide technical advice on Data Integrator
Technical Environment: Business Objects Data Integrator 6.5 & XI, XML, MQSeries, Autosys, SQLServer, Sybase
-
DP EUROPE - GROUPE ALTRAN
- IT Consultant
2000 - 2003
18 months Business Analyst & Technical Program Coordinator - FAT (WORKPLACE ACCIDENT ADMINISTRATION)
Technical coordination of the largest project at the FAT (“Claims & Attestations”) in the context of the implementation of the Network LEA (Liaison Electronique secteur Assurance). The FAT needed to build a reliable system based on a complex platform (S/390-VM/VSE, CICS, NT, Lotus Notes, MQSeries, MQSI) to enable reception, control, storage, treatment and automatic emission of electronic messages covering various activities from policies to national security numbers and claims.
• Development of business requirements and solution design for the workshop “Claims & Attestations”
• Development supervision and test follow-up
• Architecture prototyping (system process specification, database modelling, workflow standardization)
• Development of business requirements of Document Management & Data Glossary system (Lotus Notes)
• Technical program coordinator: Insurance companies (AXA, AGF, Fortis AG), Social Security public services.
• Risk management, project planning and status reporting
Technical Environment: Windows NT, S/390-VM/VSE, CICS, DB2, Lotus Notes, MQSeries Integrator, Cobol, XML
12 months Project Management - CAAMI (PUBLIC HEALTH CARE)
Project Leading and Business/System analysis of a large scale system to enable reception, treatment and automatic emission of electronic messages concerning hospitalisations and insurability data within the 12 regional offices of the CAAMI (for the CareNet network of health insurers & hospitals in Belgium).
• Development of business requirements and solution design
• Process reengineering of the application Hospitalisation to fit the new CareNet environment
• Follow up, guide and coordinate the development team across the whole SDLC
• Technical supervisor: system administrators, external consultants, service providers (gateway)
• Project coordination: end users, administrative personnel, doctors
Technical Environment: Windows NT, Informix, SQL, Visual Basic, COM Components, TCP-IP
-
DP EUROPE - ALTRAN (CONSULTING)
- Business Analyst & Technical Program Coordinator
2000 - 2003
Technical coordination of the largest project at the FAT (``Claims & Attestations)'' in the context of the implementation of the
Network LEA (Liaison Electronique secteur Assurance). The FAT needed to build a reliable system based on a complex
platform (S/390-VM/VSE, CICS, NT, Lotus Notes, MQSeries, MQSI) to enable reception, control, storage, treatment and
automatic emission of electronic messages covering various activities from policies to national security numbers and claims.
* Development of business requirements and solution design for the workshop ``Claims & Attestations'' ;
* Development supervision and test follow-up ;
* Architecture prototyping (system process specification, database modelling, workflow standardization)
* Development of business requirements of Document Management & Data Glossary system (Lotus Notes)
* Technical program coordinator: Insurance companies (AXA, AGF, Fortis AG), Social Security public services. ;
* Risk management, project planning and status reporting
Technical Environment: Windows NT, S/390-VM/VSE, CICS, DB2, Lotus Notes, MQSeries Integrator, Cobol, XML
12 months Project Management - CAAMI (PUBLIC HEALTH CARE)
Project Leading and Business/System analysis of a large scale system to enable reception, treatment and automatic
emission of electronic messages concerning hospitalisations and insurability data within the 12 regional offices of the
CAAMI (for the CareNet network of health insurers & hospitals in Belgium).
* Development of business requirements and solution design
* Process reengineering of the application Hospitalisation to fit the new CareNet environment
* Follow up, guide and coordinate the development team across the whole SDLC
* Technical supervisor: system administrators, external consultants, service providers (gateway) ;
* Project coordination: end users, administrative personnel, doctors
Technical Environment: Windows NT, Informix, SQL, Visual Basic, COM Components, TCP-IP
-
SOCIÉTÉ GÉNÉRALE
- Data warehouse Administrator
PARIS
1998 - 2000
* Data warehouse and Business Objects administration and maintenance ;
* Migration of BO v3 to BO v4 then of BO v4 to BO v5 ;
* Administration and maintenance of SQUAD (Simple Query for Users to Access MIE Data) management: Migration
process of the data of the central system of the bank (MIE) to a dynamic database (Sybase).
* Development of reports and applications aiming at the management and the dealing room
Technical Environment: UNIX, NT, Sybase 11, SQL, PowerBuilder 6.0, BusinessObjects 3, 4, & 5, BusinessQuery 5
-
DASSAULT AVIATION
- Analyst Programmer
Saint-Cloud
1997 - 1998
Participation in the development of the SAPACE military simulator analysing the survivability of a fighter entering into hostile
territory.
Technical Environment: Unix, Silicon Graphic, RS6000, Fortran, GL, Motif