Franck - Chef de projet SAP BW
Ref : 121014J001-
69 LYON
-
Chef de projet, Consultant (53 ans)
-
Freelance
CAREER
Since March 2013 SAP Expert consultant and project leader as a freelance
From 2007 to 2013 BI Manager at Kalydia (French IT Consulting and Services company)
• Manager of 5 consultants
• Responsible for budget
• Expert consultant, team leader, project leader
• Response to Request For Proposal, commercial offers
• Pre-packaged technical offers
• Technology watch, seminars
From 2001 to 2007 SAP Expert consultant and project leader as a freelance
From 1997 to 2001 SAP Senior consultant at AXISSE (French IT Consulting and Services company)
SAP PROJECTS
Since March 2015 Firmenich - Geneva
Expert BW7.3/BO4.1
• I developed the BW architecture for QM, PP, SD, MM and FI reports.
• I developed Webi reports on top of Bex Queries.
• I created BI-IP interface for managing FTE (Full Time Employee) and to be used in BO Analysis.
• I made an analysis for upgrading to BW on HANA.
October 2014 – February 2015 Groupe Casino
Expert BW7.0
• Legal evolution of the reporting for conventions and intercompany flows.
• LSA architecture and BEx queries.
• iviews.
• Autorizations.
June 2014 Kingfisher - Lille
Senior BI consultant - Audit
• Review the existing solution for:
o BODS (Business Object Data Services)
o HANA Model
o BO Universes
• Estimate the risks
• Give recommendations
March 2014 – September 2014 Groupe Soufflet
Expert BW7.3/BI 4
• P&L and Margin architecture and reporting.
• VBA in workbooks.
• CRM interface.
• Planning, specifications, development and tests.
November 2013 – March 2014 Industrie agro-alimentaire - Valence
Expert BW (7.3)/BI 4
• Webi BI 4 reports on BEx queries.
• BO authorization on CMC.
April 2013 – November 2013 Retail industry - Geneva
Expert BO/BW (7.0). Remote consulting.
• Reporting on Energy saving certificates.
• I developed the BW architecture and BEx queries.
• I created universes on top of BEx queries with Universe Designer.
• I developed BO reports with Webi Rich client XI 3.1.
• POC Dashboard.
• Activation of the administration cockpit.
• Responsible for: Process chains, transport, tests, documentation, release in production.
December 2012 – March 2013 SwissLife - Paris
Expert BW (7.0)
• I specified regulation reports for the finance department.
• I developed the architecture and queries.
• I published iviews in the Enterprise Portal.
• I assisted users during user acceptance tests.
• I wrote the documentation.
April 2010 – November 2012 Groupe Panzani - Lyon
Team lead BW (7.0) – Expert Integration SAP BW/BO – Workflow expertise
• I managed the BW team: weekly meeting, planning.
• I gathered the reporting needs during workshops. Top-down approach.
• I wrote the Business Blue Print, functional specifications and the documentation in English.
• I developed the architecture and the queries for sales department (sales statistics, service level…) and finance department (COPA, Net sales, Net outcome…).
• I created Promotions reports (calendar, POC TPM).
• I generated Universes on top of Bex queries using the integration kit and Universe Designer.
• I created Webi reports for sales statistics service levels reports and promotions using Webi Rich client / BO XI 3.1.
• I broadcasted the reports with the Central Management Console (.pdf and .xls format).
• I solved performance and integration problems between SAP and BO.
• I used advanced functionalities of API and VBA in workbooks.
• I optimized response times of queries.
• I developed reconciliation queries between SAP ECC and SAP BW to check data consistency.
• I maintained SEM-BPS application for prices.
• I developed Open Hub interfaces and export datasources for SAP APO.
• I trained the key-users and end-users.
• I maintained the BW and BO application post Go Live.
• I activated MM workflows for the purchase orders.
January 2010 – March 2010 Entremont - Annecy
Senior BI-IP consultant (7.0) – Integration SAP BW/BO
• Upgrade expert between BW2.1 and BI7.0.
• Upgrated modules: CO-OM, CO-PA, SCM, CRM, PP, HR.
• I provided post go-live support for monitoring data loads and data integrity.
• I developed Webi reports on top of universes generated from BEx queries (use of Universe Designer & Webi Rich client / BO XI 3.1).
November 2009 – January 2010 Biomerieux & Sanofi - Lyon
Senior BI-IP consultant (7.0)
• I was responsible for the finance, controlling and production planning areas.
• I gathered the reporting needs during workshops with the American offices. Bottom-up approach.
• I elaborated the general architecture in BW and the BEx reports for the Cognos interface.
• I wrote the functional specifications in English.
• I made a prototype for an IP application to simulate changes in production planning.
May 2009 – November 2009 CFF - Paris
Senior BI-IP consultant (7.0)
• I implemented two IP applications for accounting adjustment (amount input and commentary input in FI-GL infocubes).
• I developed specific IP functions (manual input, mass input, copy).
• I set up the STS (Status and Tracking System).
• I developed BEx queries and WAD for IP applications.
• I configured the roles, worksets and iviews on the Enterprise portal.
• I elaborated the process chains.
• I wrote the functional and technical specifications.
• I tested the integration phase and deployed to production.
• I provided post go-live support for monitoring data loads and data integrity.
• FI-GL reporting / Virtual cube (via DDIC table).
June 2008 - April 2009 POMONA - Paris
Senior BI architect (7.0)
• I was responsible for the logistics and controlling areas.
• I gathered the business requirements for MM (delivery, transport, warehouse management), CO (PCA, CCA, COPA) and FI (FI-AP, FI-AR) during workshops.
• I made the conception of the general architecture.
• I wrote the functional and technical specifications.
• I made the development of extractors, datastore objects, info-providers, queries, WAD, portal iviews and worksets.
• I was the technical expert for: Inventory management, APD, virtual key figures.
• I advised on the BI best-practices.
• I managed and trained junior BI consultants.
May 2008 - June 2008 Ed (groupe Carrefour) - Paris
Senior BI consultant (7.0)
• I advised on the BI best-practices.
• I made the development of extractors, datastore objects, info-providers for CO (PCA).
• I implemented the statistics business content.
• I participated in the activation of the cockpit administrator.
• I participated in the activation of the authorizations.
• Assistance during the go-live.
• I improved the queries performances.
April 2008 SAP France - Grenoble
Senior BI consultant - spot consulting (7.0)
• I solved an OSS message sent to SAP in high priority by a customer regarding the extraction of duplicate sales document items.
October 2007 - March 2008 GDF - Paris
Senior BI consultant (7.0)
• I was responsible for the finance asset management area.
• I gathered the business requirements for FI-AA during workshops.
• I wrote the functional and technical specifications for the extraction and the retraction.
• Transformation from key figure model to account model.
• I made the conception of the general architecture.
• I was the technical expert.
• I managed one junior BI consultant.
September 2007 TERREAL - Paris
BI consultant - spot consulting (7.0)
• I installed the Sales and Distribution business content for invoicing.
Septembre 2007 ARCELOR - Paris
BI consultant - spot consulting (7.0)
• System audit
February 2007 - August 2007 EDF - Paris
Senior BW consultant (3.5)
• I gathered the business requirements for inventory management during workshops.
• I wrote the functional and technical specifications.
• I made the conception of the non-cumulative and snapshot architecture.
• I made the development of infosets, ODS, cubes, multicubes, master data, infosources, transfer rules, update rules, start routines, infopackages, process chains, queries.
• I performed unit testing and integration.
• I installed the business content for stock.
• I managed one junior BW consultant.
August 2006 - January 2007 SFR - Paris
BW consultant (3.5)
• I gathered the business requirements during workshops.
• I wrote the functional and technical specifications.
• I made the conception and development of generic extractors, ODS, cubes, master data, transfer rules, update rules, start routines, queries for the reporting on payment delays and rejection (Industry solution RMCA).
• I developed reports with Query Designer and Web Application Designer.
• I used BAdi and user-exit for specific report variables and virtual characteristics.
• I developed test scenarios.
• I performed unit testing and integration.
March 2006 - July 2006 ALCATEL - Strasbourg
Junior BW consultant (3.0)
• I optimized an extractor on the stock (creation of datasource, transfer rules, and update rules).
• I created process chains to refresh statistics, delete PSA and compress cubes.
• I coded an update rule routine to retrieve information from master data tables.
• I improved performance of queries on cubes with high cardinality dimensions and on MultiProvider with sequential processing.
• I used BEx Analyzer.
• I designed and deployed Aggregates to improve query performances.
September 2005 - February 2006 THALES
Senior workflow consultant (part-time)
• I gathered the requirements, specified, designed, developed and tested 2 workflows related to MM: Validation of the purchase requisition and the purchase order.
• I configured validation strategies and roles.
• I developed the smartform for the PO.
May 2005 - March 2006 BNP-PARIBAS
Senior workflow consultant (part-time)
• I gathered the requirements, specified, designed, developed and tested 7 workflows related to MM: Validation of the contract, the purchase order and the invoice/Controlling the available budget for the contract and the purchase order/Archiving of the contract document and the invoice document via Archive Link.
• I configured validation strategies and roles.
October 2004 - May 2005 Outsourcing project – UNEDIC
Technical project leader - Senior workflow consultant
• Upgrade from 46B to SAP R/3 Enterprise.
• I added new functionalities to purchase order workflow.
• I maintained MM workflows. I was the workflow administrator.
• Developments: Report painter, Transaction Events, BADIs, field-exits, user-exits, sapscripts, validation and substitution rules and interfaces. I organised the team activity.
April 2004 - October 2004 Outsourcing project - AIR FRANCE
Technical project leader - Workflow expert
• I participated to the settlement of the outsourcing project (hardware, software and consultants).
• I dispatched the correction and evolution requests to the team.
• I ensured the technical feasibility of projects.
• I reported the activity of the team weekly.
• I was the workflow expert.
• I was the back-up of the project manager.
July 2004 - August 2004 BSI - BRITISH STANDARD INSTITUTE
Senior technical consultant - spot consulting
• I developed sap script and ALV.
March 2003 - January 2004 Outsourcing project AGORA - TOTAL
Integration team leader for one of their biggest SAP project in France
• I managed the team (7 technico-functional consultants) that supervised the system activity in production (CATT massive testing, database size and number ranges control , dumps solving, performance indicators, transport requests validation, archiving, technical support and expertise).
• I planned resources and timeline.
• I wrote specifications for security developments.
• I organised meetings to centralise the technical activity of the functional and BW teams.
• I was the contact person for SAP France.
October 2002 - February 2003 Template Light project - TOTAL FINA ELF
Team leader - Workflow expert
• I managed a 3 developers team responsible for producing reports, standard modifications, sapscripts and LSMW on an international project (Germany, Turkey, Hungary…).
• I used GUIXT tool for the Madagascar roll out.
• I gave advice for workflow developments.
March 2002 - September 2002 Performance team - TOTAL FINA ELF
Senior consultant - Workflow developer
• I wrote and controlled the program characteristics and the recommended performances guidelines.
• I studied and improved SAP and specific programs (index, SQL trace, run time analysis, OSS notes, algorithm, system parameters…).
• I developed a workflow for the validation of transport requests (tasks, methods, attributes…).
December 2001 - March 2002 SIRIUS project - SCHNEIDER ELECTRIC
Consultant
• I wrote functional and technical specifications for reports, sapscripts (bare code labels) and production information structures.
• I was responsible for testing the developments.
October 2001 - November 2001 BOURJOIS-CHANEL
Analyst MM/PP
• I participated to the upgrade from release 4.5B to 4.6C. I did the functional and technical tests (SAP transactions and specific programs).
October 2000 - May 2001 DATA MEDIA
ABAP consultant
• I added new functions to the sales orders screens (telesales).
• I developed an interface and an interactive report for FI.
• I created sapscripts, queries, and ABAP list viewer reports.
• I participated to the Data Migration.
• I settled the sales information system.
June 2000 - August 2000 L’OREAL
SAP senior technical consultant
• I participated to the upgrade from release 3.1I to 4.6B (transactions debugging, problems
Solving, OSS notes search and application, programs maintenance).
November 1999 - May 2000 FREESBEE
ABAP consultant
• I developed an Interface for the hot line.
• This set of programs allows to display and change information on the customers: general
• Information, bank data, internet consumptions, billings.
• I created BAPIs to allow customers to change these data on line.
• I coded the sapscript for the invoices sent by Email.
January - September 1999 L’OREAL
ABAP developer
• I developed programs to calculate transportation costs and to create the flow: sale order
/invoice / purchase order automatically from a file.
• I maintained an EDI program and also created various sapscripts.
OTHER EXPERIENCES
May - September 2001:
• Around the world trip
September 1997 - October 1998 CARDIF (subsidiary of the PARIBAS bank)
IBM Mainframe Consultant
• I developed and maintained application programs in COBOL within an insurance project.
England / Kent 1996 HUYCK Ltd (BTR Paper Group).
• Contract as a Material Development Engineer
SAP SKILLS
BW/BI 6 full project life-cycles
BO 3 full project life-cycles
BI-IP 2 full project life-cycles
SAP HANA Training within SAP France, audit and upgrade
Management 4 full project life-cycles as a project leader
Junior BI consultants management
ABAP 4 full project life-cycles
Workflow 2 full project life-cycles
SD/MM
FI/CO
PP
EDUCATION
Engineering Degree with honours at Lille University School of Engineering in France
One-year Degree required before Doctoral Studies in Electronics with honours at Lille
University of Sciences and Technologies in France
Two-year University Degree in Mathematics/Physics with honour, class standing: top 10% at Grenoble Joseph Fourier University in France
COMPLEMENTARY TRAINING
SAP BW BW310, BW360, BW370 (Integrated Planning), DBW70E (Delta SAP BI), SAPBO (BO /SAP Integration), Inventory management (non-cumulative and snapshot), BI 7.0 Upgrade seminar, BW362 (SAP HANA for BW), HA300 (SAP HANA - Implementation and Modeling)
SAP R/3 ABAP/4, Basis Components with SAP training centre
IBM Mainframe
LANGUAGE
French native
English fluent
PROGAMMING SKILLS
SAP BW:
Data modeling
Generic extractors, infosources, update rules, transfer rules, transformation, routines, master data, infosets, DSO, cubes, multicubes, aggregates, infopackages, DTP, process chains, data loads, datamarts, retraction, APD, Open hub, functional and technical specifications.
Query Designer, Web Application Designer, restricted and calculated key figures, virtual characteristics and key figures, non-cumulative key figures, text variables, iviews, worksets, roles, authorizations, performance.
Workbook, API, VBA
User-exit, Badis coding, Proxy/PI integration
Integrated Planning applications, aggregation level, filter, specific IP functions, sequence. SEM-BPS
Universe Designer, Webi, Crystal Reports, Xcelsius. Proof Of Concept BI4 (Dashboard).
HANA-Optimized DSO and InfoCube, HANA Models, LSA++
Workflow:
I developed specific MM workflows for the validation of the purchase order, contract, purchase requisition and invoice: Events, steps, tasks, object type, methods, object oriented ABAP, validation strategies and roles.
SAP R/3 ABAP/4:
I developed sapscripts (confirmation order, packing list, customs documents, invoice ...), smartforms, batch inputs, reports, dialog transactions, interfaces, conversions, validation and substitution rules, user-exits, field-exits, and business transaction events, BAdis, queries, IDOCs, infos structure, workflows, Object Oriented ABAP, GUIXT scripts, report painter, tables and specific programs within MM/PP/SD/FI projects.
I trained consultants to CATT and performance.
I have two years experience in management.
IBM Mainframe: COBOL, TSO/ISPF, CICS, DB2, SQL
Others: Excel, Word, VBA, Fortran, Turbo-Pascal, US GAAP