Wing-kit D.

SAP BI Expert

94400Vitry sur seineÎle-de-France - France

Managerial skills:
---------------------
- Project Management
- Project Coordinator
- Team Management


Industry skills :
-------------------
Automotive, Retail (RTW), Medical


BI skills:
---------
BI functional and application architecture, data modeling (star schema), Masterdata management


Technical skills :
---------------------
SAP BW: Version 3.x, Netweaver BI 7.x
- Architecture, Sizing, Modeling, ROLAP optimization, DSO techniques
- Various type of data transfer: R3/ECC, DB Connect and Flat Files
- ABAP programming, Process chains, Authorization, Testing
- BEx and web reporting, VBA, WAD, Broadcasting

SAP ECC: MM, SD, FI, CO

Wing-kit D.
67 contacts
Since 2005

Johnson & Johnson (15 months)
---------------------------------------------
Implement financial reporting and accounting consolidation system based on SAP BW.

Job :
- International project (Belgium, Prague and United kingdom)
- Identifying the solution: Defining a SAP BW financial reporting based on JDE (sales data) and SAP (financial data) to deploy internationally with the US Team
- Conceiving and building the functional and technical architecture
- Defining and building data extractors on JDE (Oracle SQL)
- Providing queries and workbooks for reporting and training to Shared Service Center
- Coordinating 4 teams for testing phases (JDE Team, SAP Team, BW Team, Cognos Team)
- Involving in the year-end closing 2008 and the first quarter closing 2009
- Supervision of 3 people

Achievements :
- Designing a worldwide accounting consolidation system
- Building a multiple systems architecture (JDE, Cognos, SAP ECC, SAP BI)
- Dealing with several teams based in all over the world

System:
SAP Netweaver BI7, JDE, Oracle

Module: FI, CO
<============================================================================>

Peugeot SA (Citroen - Peugeot) (27 months)
---------------------------------------------------------------
Core model: Implement sales reporting on SAP BW for France, Germany and United Kingdom.

Job:
- International project (Germany, France and United kingdom)
- Identifying the solution: Defining the future Core model to deploy internationally
- Conceiving and building the Core model technical architecture
- Studying feasibility and defining Near Shore strategy (Romania)
- Responsible for overall BW support and new development activities (7 projects based on SAP BW)
- Auditing and implementing loading and authorization strategy (process chains, error handling, role)
- Providing queries and workbooks for reporting and BEx Training to key users
- Supervision of 5 people

Achievements :
- Designing a sales reporting for France and deploying this Core Model solution for all the other countries
- Building Complex architecture based on flat files : 15 DSO, 4 infocubes et 5 Multiproviders
- Cost saving for Third Party Maintenance with Near shoring strategy

System: SAP BW 3.5
<============================================================================>

Audiooptic (3 months)
-------------------------------
Cost saving: Sales and financial reporting combining SAP BW and Freeware tool (Eclipse and iReport).

Job:
- Identifying the solution: Define a low cost architecture to provide SAP BW PDF report though a custom Web Portal
- Providing a feasibility study combining SAP BW and Freeware tool (Eclipse and iReport)
- Defining and implementing technical architecture, loading and error handling strategy

Achievements :
- Dividing the project cost by 100 on BI budget

System: SAP Netweaver BI7

Module: MM,SD
<============================================================================>

Aelia (5 months)
-----------------------
Implement inventory reporting for Web browsing

Job:
- Defining key inventory indicators for reporting
- Conceiving and building the functional and technical architecture
- Providing queries and dashboards for Web reporting

Achievements :
- Simplifying and summarizing users’ requirements to deliver effective dashboards

System: SAP BW 3.5

Module: MM,SD
<============================================================================>

BearingPoint France (Internal Responsabilities)
--------------------------------------------------------------
Implement Knowledge Management Strategy within the Team.

- Responsible of the Knowledge Management Center
- Build the Knowledge Management Portal, implement Capitalization procedure, quality check procedure...
- Supervision of 3 people

Consulting and Services
Professional experience
2004 - 2004

Job:
- Auditing the needs of the marketing and the Sales department
- Conceiving SAP BW reporting to analyze the market and the firm’s products behavior (Life cycle…)
- Building workbooks with complex VBA, Training and hotline

Achievements:
- After validating the reports, it has been deployed in Spain and Italy

System: SAP BW 3.1

Module: MM, SD, FI, CO

Construction materials
2002 - 2003

Job:
- Organizing promotional events for the launch of new products (Seminar reserved for teachers, canvassing the secondary schools…)
- Establishing a Chinese-French partnership between Chung Tai Educational Press and Cabrilog
- Benchmarking of the dynamic geometry software market
- Designing graphical interface for the educational software
- Building company’s web site (Studied the existing information system, targeted the main improvement axis, drafted the conditions of the contract, Prototype proposal…)

Achievements:
- the partnership is a success, Chung Tai Educational Press is still working with Cabrilog.

Press and editorial
2001 - 2001

Job:
- Analyzing CCF standards to comply with HSBC standards (Audited the existing architecture for every department: Back Office, Middle Office, Front Office…)
- Implementing a guide for the maintenance procedures
- Optimizing the security policy (Drafted security recommendations…)

Banking
Education
Hobbies
Basket , badminton Montage Video , Photographie , Cinéma