CV/Mission de Consultant workflow freelance

Exemple de missions de Franck,
Consultant workflow habitant ?

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 pu...