Data architect

Gottfried EBONGUE mbcs

Tel: **(**) 797-***-**** (mob)

Email: *********.*******@*****.***

Data Architect

I am a highly experienced IT professional. As an architect I

can put all the experience I have gathered in different IT fields into

work. I have designed solutions from requirements to implementation

(Business, Data, Application, etc.)

Professional skills

Enterprise and solution architecture Certification ISEB. (TOGAF, ZAchman,

ADM

APICS Certification (American Production and Inventory Control Society)

ITIL Certification (Information Technology Infrastructure Library)

SAP Business Intelligence 7.0 (BI, star schemas, ETL, dimensions, facts,

KPIs

Project management/planning, UML, GANTT...

Work experience

2010 - 2013 Celesio group UK (AAH Pharmaceuticals, Lloyds pharmacy)

(Coventry Head office)

Risk assesment of all the 200 applications of both business units

(AAH and LP) in order to harmonise all the business units accross Europe

(ONE IT project)

Design of highly complex solutions (cloud, interfaces, VPN, remote

authentication

Information Architecture: Enterprise map, Data flux diagrams,

Enterprise context diagram, data entities dispersion mapping.

As a data architect I did put in place governance principles to

improve the design and the tidyness of existing

databases.

Member of the design/architecture committee reviewing all the project

conformance to policies

-Processes design as a general approach

-Solution design: I design solutions by producing a High level design

that contains requirements, data flows, aplication integration,

business processes, infrastructure; that gives me a holistic approch

of the entire application landscape.

-Recommendation of architecture principles in order to improve general

efficiency (SDLC)

-Analysis for the upgrade of 72 Access 97 DB to Access 2010 including

their transfer to Sap if relevant, or into the mainstream apps

(Business intelligence mainly)

-Design and implementation of DW and BI requirements (sales by

planogram)

-IT servers consolidation

-Implementation of TOGAF methodology

-Enterprise data modelisation

-Data sources mapping

-Process led MDM

-Enterprise architecture and Data governance

-EA Tool specification(assessment of Troux, Aris, Sparx enterprise

architect)

-Data architecture policies review

-Modelisation/integration of Solution

-interface mapping

Environment: Aris (software AG), Mars (in house development on

Oracle), Iteraplan, Oracle, SQL, Unix, ERwin, Linux, Windows, Java,

other specialised applications (compass, Storespace SAP,

Microstrategy

2000 - 2010 REMPLOY Ltd LONDON/BANBURY

Enterprise Architecture (ADM a customised version of TOGAF) knowledge

of zachman

Precursors: requirements gathering/ stakeholder management

Business architecture: referral system mapping (swim lanes diagrams)

Data architecture: please see data analysis and design below plus

administration of the baan data model (optimisation normalisation)

SQL statements written as part of the ERP environment (for Informix

querying) :it takes a perfect knowledge of the database to write SQL

statements that don't draw on resources too much. Developers code

monitoring for optimisation purpose.

Software/ applications architecture: integration into a SOA system

between Northgate and Baan via Biztalk. Administration of a tightly

coupled environment (ERP).

Design of the single source of truth data process with an IBM

consultant.

Master Data Management policy in regard with the items management

(logical/physical companies)

Design for NFRs: Integration project

Data warehousing (Business Intelligence)

Regular Data archiving according to regulation and storage for 5

years.

Requirements gathering and building of key performance indicators

according to the specifications given by users.

Daily, weekly and monthly KPIs produced through batch jobs that

extract, transform, load and distribute the data to users and

managers. Data being extracted from diverse applications.

(Test Manager on the Biztalk integration project : Writing of test

scripts and organization of tests session for the fND government project

(Process modelling and context diagrams drawings usability project

(Conceptual, logical, physical data modelling

(Specification of Non Functional Requirements in order to integrate

messages between applications

(Strong exposure to distribution, manufacturing, logistics and

finance modules

(Integration / administration biztalk 2009 between nothgate(HR) /BAAN

(SOA (Biztalk), Master Data Management-items Data flow (BaaN)

(Change control board

(Tools: Sharepoint, visio

(Service level agreements

(Information and system security

Internal Applications consultant:

(Supply chain, distribution, manufacturing...

Data modularity management (data domains)

DATABASE ADMINISTRATION

( Centralised management of all the company sites (2nd and 3rd level

support)

( Upgrades projects management (test plans, validation, etc

( Data base monitoring

( Troubleshooting

( User administration (CRUD privileges management)-DATA SECURITY

( Batch Jobs administration and monitoring

( System resources monitoring

( INFORMIX logs monitoring and maintenance.

( Tools Scripting

( SQL and other programming languages

( Production of documentation in sharepoint repository

Environment: IBM p-series, AIX(UNIX), windows, Informix(RDBMS),

cyberquery(BI), Nazdaq, MS-Office, Baan 4c4 Infor ERP...

1999 CMG France

Technical and functional Consultant

(Responsible of several accounts (implementation

-maintenance)

1998/1999 TRANSICIEL

Consultant (ABB)

(Migration and programming in preparation of the conversion

from the French franc to the Euro

(Comparison of software versions

(Development and specifications writing

1997 BULL ELECTRONICS

(Migration from triton 3.1 to Baan Ivb3

(Programming

1991/1994 CRATI

( Analysis and programming for health care insurances

companies

Education

1996 Honor degree in Supply chain management (ISERPA-France)

1993 Higher Degree in Information Technology (CNAM-France)

1990 Bachelor degree in Information Technology

1988 Economics science university of Rouen- France

Miscellaneous:

Books, films, Internet, sport, news, fire marshall...

Fluent in French and in English

Contact this candidate