Wing-kit D.
SAP BI Expert
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
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
2004 - 2004Job:
- 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
2002 - 2003Job:
- 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.
2001 - 2001Job:
- 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…)
