• 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.
• Legal evolution of the reporting for conventions and intercompany flows.
• LSA architecture and BEx queries.
• iviews.
• Autorizations.
• Review the existing solution for:
o BODS (Business Object Data Services)
o HANA Model
o BO Universes
• Estimate the risks
• Give recommendations
• P&L and Margin architecture and reporting.
• VBA in workbooks.
• CRM interface.
• Planning, specifications, development and tests.
• Webi BI 4 reports on BEx queries.
• BO authorization on CMC.
• 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.
• 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)
• 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.
• 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.
• 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).