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