Guillaume DENIZOT

Guillaume DENIZOT

3 rue de la Fraternite

74000 ANNECY, FRANCE

Phone: 0033 (0) 6-71-21-20-88

Email:

Web:

Born on 28.08.1980, single, French citizen.

Summary

Thanks to a double graduate IT / Businessand a 7-year experience of link between users and ITon ERPenvironment, I’ve acquired strong technical and functional knowledge.I can hold asaBusiness Intelligenceconsultant / developer participating to all steps of a BI project (understand needs, write specifications, develop and help users for tests…)with wide business skills.

Work experience

Since 04/2004
Sopra Group
(IT services)
Annecy (74, France) / Business Intelligence Consultant / Business Object developer (from March 2011):
Environment : international joint-venture (dermatology). ERP MOVEX M3 / Oracle.
Actions done:
-Understand business process and BI needs ;
-Write / analyze / amount functional and technical requirements ;
-Understand upstream data architecture and supply (ERP, database) : develop view, table, PL-SQL procedures and function ;
-Maintain and update BO universes / develop BO reports ;
-Help users for tests.
Tools: MOVEX M3, Oracle, Business Object WebI XI 3.1 / Designer. SQL/PLSQL.
IT Business Analyst (1 year):
Environment:industrial group (stainless steel). SAP SD. 400 users.
Actions done:functional support to users (sales, shipment, invoicing).
Tools: SAP SD.
ERPconsultant / ITBusiness Analyst(6 years) :
Environment: industrial group (stainless steel). Internal ERP / AS400. 18 international companies (heterogeneous data), 400 users.
Actions done:
-Business trip in subsidiaries: analyze process and organizations, understand needs, set up ERP feature. Administrate and customize an ERP. Maintain data consistency (databases updates);
-Warrant the optimal use of systems: training and functional support to users (sale, shipment, invoicing, inventory, production, purchase);
-Link between users and IT: understand bugs and upgrade needs, cure / upgrade systems correspondingly to requirements (rephrasing needs, validation of specifications, tests). Advise for IT project linked to an ERP (functional design of a datawarehouse / Business Intelligence, electronic document management, electronic data interchange).
Tools:ERP / AS400 / RPG3– PHP 4 / MySQL / SQL – SAS user.
05/2003-09/2003
SNCF
(rail transportation)
Paris (75, France) / IT project manager (internship, 5 months):
Objective: technical and economical analysis for transferingDEFRAIL data (management software of rail track failure, 300 users) from local database to a single national database.
Actions done:analysis of existing system (mapping of software, data and processes), analysis of profitability (volume measurement, analysis of costs (250 k€) and return on investments, design of logical and technical architecture…), start of requirements(targeted system data and processes modelling).
Tools: MEGA modelling, COCOMOmethodtoamount project costs.
05/2002-08/2002
Chaix bank
(HSBC company)
Avignon (84, France) / IT auditor (intership, 4 months):
Objective:design and implementation ofan IT quality indicator.
Actions done:auditof all systems used by IT users (customers, agencies, head office users), analysis of non-quality acceptable values by system, design of a global indicatorand its components for IT quality, design and programming of tools to measure this non-quality with management of another trainee(1 month).
Tools:Word, Excel / VB, Lotus Note, TOP/X (tool forAS400 information capture).

Education and training

2003/2004 Master in Company management(DESS CAAE)– cum laude

Institut d’Administration des Entreprises, Dijon (21, France)

2002/2003 Master in Advanced Information Systems(DESS SIA)– magna cum laude

Institut d’Administration des Entreprises, Lyon (69, France)

2000/2002 Bachelor in Mathematics and IT– magna cum laude

Institut Universitaire Professionnalisé, Avignon (84, France)

1998/2000 Two-year degree in IT

Institut Universitaire de Technologie,Dijon (21, France)

Worktraining RPG3 programming. Supply Chain. Accounting.SAP SD.

BO XI 3.1 / BI 4. QlikView.

Languages English: read, written, spoken (work level: email/phone exchanges with users).

German: school level.

IT skills

Modelling: MERISE, MEGA, UML.
Databases / ERP: Access, Oracle, MySQL – SQL / PLSQL. ERP, MOVEX M3 and SAP SD knowledge.
Programming:C++, Perl, PHP 4, Java, VBA, RPG3.
Systems: AS400.
Software: Business Object WebI XI 3.1 / Designer.Hummingbird and SAS knowledge. /

Functional skills

Field of expertise: production, purchase and forecast, sale / shipment / billing, inventory, accounting.
Field of activity: industry (dermatology and metallurgy) in international environments, bank, rail transportation.

Additional information

Sports: triathlon (several participations to Annecy’s and Aix-Les-Bains’s triathlons, responsible for triathlon activity in my company works council). Swimming (several participations to crossing of Annecy’s lake). Running (10 kmand half marathon). Ski. Former table tennis player (15-years pratice, level 25).Member of a football team (FSGT – leisure championship).

Trips to foreign countries.Concerts. Cat owner. Subscriber to anEnglish magazine.