Gien-Hua WANG
Certified SAP BW 3.5 and SAP Abap consultant Mobile (L): +352 691 37 03 04
2 am Weischbaendchen E-mail:
L-5842 Hesperange Nationality: Belgian
Luxembourg
LinkedIn: http://www.linkedin.com/in/gienhuawang
Professional experience
06/2009 – 08/2009SAP R/3 Enterprise
SAP ECC 6 / Deloitte Tax Management Consulting – Brussels (Belgium)
Tax Services provider
· Abap performance tuning and technical improvement of a bespoke VAT/Intrastat reconciliation tool (FI, SD, MM) /
06/2007 – 12/2008
SAP BI 7.0
SAP R/3 4.6C / DSM – The Netherlands
Chemical industry – subcontractor for Deloitte Consulting Belgium
· SEM-BPS project: implementation of an Inter-Company Reconciliation project by means of BPS. All BPS exits were used (BPS variable exit, planning function exit, characteristic relationship, BPS and BW variables mapping)
· Project includes BW work: Data Transfer Process, InfoPackage, Transformation, start routine in Transformation, Abap routine in Transformation Rules, Process chains, creation of InfoObjects, data modelling, InfoCube virtual characteristic, Bex variables exit
· BPS role description: 75% technical, 25% functional
· BW role description: 60% technical, 40% functional
· SEM-BCS: data transfer and custom tasks BAdI's
· R/3: generic extractor for FI, ALV reports, FI validation rules, SAP standard modification on search help and search help exit for Consolidation transaction Type
· Training: documentation writing and support /
05/2006 – 05/2007
SAP BW 3.5 / EDF – Paris (France)
France Utilities company – subcontractor for IBM France
· Data modelling: functional specifications definition, update and transfer rules for Info Providers loads
· Process chains
· Data warehousing: master data loads
· Bespoke interfaces: Abap using BEx queries results /
04/2006
SAP 4.6C / Valeo – Paris (France)
Automobile OEM equipments maker – subcontractor for Accenture France
· Module: SD
· Tools: Idoc, ALV reporting, interactive reporting /
03/2006
SAP 5.0 / Hospitalor – Paris (France)
Non profitable association – subcontractor for ACA
· Module: SD
· Tools: smartforms /
04/2005 – 02/2006
SAP 4.6B & 5.0 / Groupe Danone – Paris (France)
· Modules: SD, MM, FI, PP
· Tasks: technical developments and maintenance
· Tools: SAPscript, JetForm, BAPI, interfaces (Idocs & flat files), user-exits, dialog programming /
01/2005 – 02/2005
BW 3.1 / SAP Academy Business Information Warehouse (SAP Belgium)
· BW305: Reporting & Analysis
· BW310: Data Warehousing
· BW365: BW Authorization
· BW330: BW Modelling
· BW315: Reporting Management
· BW340: Data Staging
· BW350: Components Extraction /
12/2004
SAP 4.6B / Assurances Groupama – France
Insurance company – subcontractor for SOPRA Group
· ALV reporting /
10/2004 – 11/2004
SAP 4.6C / Antalis – France
Paper industry
· Data migration for material consumptions (MM)
· Programs maintenance after Go-Live (MM, SD) /
11/2003 – 09/2004
R/3 Enterprise / Masterfoods – France and Germany
Food industry – subcontractor for Unilog-Logica CMG
· MM Classification: reports using Object Oriented Abap (dynamic table creation)
· On-site technical support for German rollout: SD, MM, FI, PP
· Idocs maintenance, SAPscripts, Smartforms, user-exits
· Printer configuration for barcode printing
· Handling Units Management: user dialogs programming
· Interface developments (MM-SD) /
09/2003 – 10/2003
R/3 Enterprise / Ajinomoto Foods SA - France
Food industry – subcontractor for IntelliGroup USA
· Offshore developments coordinator (MM, SD, WM)
· Automatic payment transaction (FI): bespoke modifications for domestic and international medium exchange (DME)
· Sapscript (FI, QM, SD)
· Interface design (weighbridge interface with SAP) /
08/2003
SAP 4.6C / Glaxo Smith Kline - Rixensart (Belgium)
Biological and pharmaceutical industry – subcontractor for Atos-Origin
Abap technical consultant – SAP QM module
· SAP standard adaptation
· Batch input /
02/2003 – 07/2003
SAP 4.6B / Altria Group Inc. - Philip Morris Products SA – Neuchâtel (Switzerland)
Tobacco industry
Technical consultant
· User exit for WM (palletization)
· SAP standard modification
· SAPscript
· ALV reporting
· Factory Leaf Project: bespoke interface programming (MM, PP, CA). The results are used as legal declaration to Swiss authorities in order to determine tobacco taxes /
11/2002 – 01/2003
SAP 4.6C / Altria Group Inc. - Kraft Foods International - Brussels
Food industry – subcontractor for Axxon UK
Technical support for the Benelux roll-out
· Bespoke FI interfaces creation
· ALV reports developments in FI, MM, PP and SD /
02/2000 – 09/2002
SAP 4.5B / Bridgestone-Firestone Europe - Brussels
Industry: tyres manufacturer.
· SAP Specialist, ABAP Technical Consultant, dedicated to the Bridgestone Firestone European SAP Competence Center department
· Use of numerous ABAP development tools such as SAPscript, CATT procedures, Batch Input, Direct Input, Call Transaction
· Recurrent work with authorization concepts, SAP jobs, dynamic program variants set up, SAP events, user-exits
· Programs analysis and performance tuning
· Autonomous on OSS and OSS notes implementation
· Interactive reporting, expertise in ABAP and SAPscript ‘debug’ mode
· Technical support for EURO conversion and upgrade from 4.0A to 4.5B
· Customer specific ABAP programs maintenance in the framework of the subsidiaries centralization on SAP platform, in cooperation with the projects teams
· Regular dialogues with SAP users in order to resolve their day-to-day problems
· Trainer for junior consultants and internal employees /
09/1999 – 05/2000
SAP 3.1I / Entreprise des Postes et Télécommunications Luxembourg
Public Postal Service.
· Initial Data Migration (SAP MM project) planning and strategy as SAP Technical Consultant
· Go Live follow up and final modifications of specific dialog programming created for this user
· Tuning of specific reports after the Go Live period /
07/1999 – 08/1999
SAP 3.1I / Laminoir de Dudelange
Steel industry, Arcelor Group
· Customer data exchange interfaces maintenance, IDOC (occasional interventions) /
10/1996 – 05/1999
HP3000 / CLT-UFA S.A.
Leading European radio and television network. Currently known as RTL Group.
· Analyst developer, Corporate IT department
· Development and maintenance of the “Audiovisual Broadcast Rights” application through Speedware development tools (Reactor and Designer)
· Achieved testing and reprogramming of the application for Y2K compliance /
06/1995 – 09/1996
IBM AS/400 / Bank Of China Luxembourg
Financial sector.
· IBM AS/400 operator
· Acquired the technical know-how necessary to analyze, track and detect any hardware-related problems in the PC field
· Recommendation and definition of the best-suited hardware for a given use
· Installation, configuration and maintenance of Windows 95 and Windows NT operating systems
· In charge of the AS/400 and PC daily data backups /
02/1992 – 05/1995
HP3000 / HP1000 / Yves Rocher Luxembourg
Industry: cosmetics
· Maintained the logistics application maintenance written in COBOL
· Managed the implementation of an automated quality control for the conditioning process inside the Luxembourg production unit
· System administration of the HP3000 and HP1000 systems (data backups and workload management)
· Successive positions in the company:
o Analyst-Programmer/Analyst (09/1994 – 05/1995)
o Analyst (04/1994 – 08/1994)
o Analyst-Programmer (04/1993 – 03/1994)
o Programmer (02/1992 – 03/1993)
The IT department consisted of up to 7 employees, necessitating flexibility in the everyday work. Although not being predestined for this quite requiring technical position, I proved to be able to adapt quickly to any new situation and learned essential competencies including managing workload, effective prioritization and customer liaison skills. /
Studies
September 1990 / Master’s degree from the “Institut Catholique des Hautes Etudes Commerciales” in Brussels (ICHEC). Economics with EDP specialisation.Languages
French, mother language.
English, fluent.
Dutch, conversational.