M’Hamed - Assistant à maîtrise d'ouvrage SAP BI

Experiences

From 07.2015-till now BNP Paris Bas Fortis - Business Analyst SAP BI /FI ReadSoft
 Defined the requirement KPI BI for the performance analytics ReadSoft
 Testing team coordination
 Defined and executed E2E test scenarios via HP ALM Quality Center
o BI Reporting: Universes/ BeX queries/WeBi Reports
o O2C Order to Cash : Master data, SD, FICO, reporting, authorizations
o I2P/P2P : Master data, IDOCs, ReadSoft, workflows, FICO, reporting, authorizations
 Gathered blueprint requirements for Payments and Bank processes and systems
o GCOA Global Chart of Accounts, house banks, bank sub accounts
o Accounting schemes, document types, number ranges
o Payment methods, payment blocks, payment terms, tolerances
o Transactions and authorization profiles
 Tested the automatic payment program F110
o SEPA and non SEPA credit transfers, SEPA mandates and direct debits, cheques
o Accounting postings to general ledger and sub ledger
o Payment medium files (ISO 20022 XML, CFONB320 et MT103)
o Payment advices sent to vendors and customers by email
o Spools printing and job logs
o SWIFT reference data (BIC, IBAN, national identification codes)
 Tested EBS Electronic Bank Statements in CAMT053 format and bank reconciliation on FEBAN
 Tested E2E Interfaces with banking organizations
 Improved customizing and specific developments
 Trained Key users:
o Prepared training materials : user guides, exercises and PowerPoint support
o Delivered training, coaching and assessment
o On-site live support
 Go-Live and production support
o Managed tickets and change requests
o Led weekly meeting with Key users via WebEx

10.2014- 06.2015-Decathlon– SAP BI4.1/BW HANA Solution Architect
 Provide a SCM solution for the retail Decathlon in France
 From BI IP Cubes aggregated to WeBi Reports
 From Real Cubes optimized on HANA to design Studio Reports 1.3
o Product, Piloting and purchasing area
o Business plan, Alert Stock and Synthesis
 Technical Environment: BI7.4, Query Designer, query Analyzer, Web intelligence, Design Studio

05.2014-10.2014– EY BeNe – Finance Audit IT (FAIT) Advisory
 The purpose of the EY Data Collector (EY DC) is to ease the download of General Ledger journal
entry data from client ERP systems and import into EY/Global Analytics & Audit Analytics
Modules (AAM) for review.
 Running the EYDC on a client's ERP system does neither require the EY auditor nor the client's
personnel to be IT-experts, is easy, fast, safe and very cost effective.
o Data Extraction ,Data Collect & Decrypter
o Transformation & loading data for the analytics result
 Technical Environment: GL-JE and Inventory BI Data modeling, Eagle Bi Analytics

03.2014 -04.2014- KONE- SAPBPC on HANA data integration, testing & migration
 Illustrate the following key data management functions on a SAP BPC NW 10.0 on SAP HANA
platform.
 We are providing a practical approach to implementation planning and consolidation solution:
o SAP ECC Data Structure
o SAP HANA Data Model
o SAP HANA Data Integration
o SAP HANA Data Mapping
o SAP BW Data Transformation
o SAP BW Data Load Scheduling
o SAP BPC Data Quality Check
o SAP BPC Data Validation
 Technical Environment: SAP HANA, BW, ECC, SAP BPC 10 NW, Design Studio

12.2013 - 02.2014 - EY Saudi Arabia SAP BOBI4 & HANA Architect
 Taking the functional and non-functional requirements and proposed solution that will be able to
meet the requirements.
 Work with the design team to realize the architecture by providing suggestions on design
options.
 Review and validate the design decisions taken by the design teams.
 Work with client architecture teams in - validate the non-functional requirements -discussing and
providing inputs on architecture options.

12.2013 – 06.2014- EY BeNe- SAP BI4 architect & HANA SPOC
 Provide a common vision in the EMEA HANA Market Helping for the RFP & RFI.
o Designs overall system and solution architecture, system integration, and implementation strategy to
deliver an integrated solution which meets customer needs.
o Communicates the system integration vision and strategy during meetings and presentations to
appropriate parties. Ensures that the technical aspects of the program are accepted by the
stakeholders.
o Leads major proposal efforts and creates strategies to win business in new markets or current
accounts.
o Serves as a technical expert for clients in system architectures to eliminate gaps and inconsistencies
in the initial and new system architectures. Ensures the technical component of the solution aligns
with the client's business goals and current/potential standards.
o Identifies existing & potential issues and design matters in overall system and solution architecture;
implements solutions to ensure that best practices and processes are followed and enhanced.
o Researches technological advancements to ensure that solutions are continuously improved,
supported, and aligned with industry and company standards.
o Provides leadership and work guidance to less experienced personnel.
 Technical Environment : SAP HANA, SAP BOBI4 Webi/Analysis/Design studio

03.2013 - 12.2013- MIVB-STIB- SAP BOBI4-BW/MM module
 This project at MIVB consisted in IS-Retail ERP Implementation and a SAP BI 4-based reporting
on top of BW Data Warehouse.
 I completed the Full Life Cycle BI implementation as the BI Analyst & BI Solution Architect. I also
took care of the testing activities and follow up as well as the Go-Live support.
 After I deepened the reporting business requirements, I set up the reporting solutions for the
following business processes :
o Purchasing, Stock Movements, Stock Holding based on MM
o Urgent Order and notifications based on WeBi report.
 Main focus was on Stock & Sales reporting, including Like-for-Like Analysis.
o SAP ECC6
o SAP Data warehouse BW 7.3
o SAP BI4 Reporting Layer
 Technical Environment : SAP BW, SAP MM & SAP BO WeBi.

11.2012 - 03.2013-SAPPI south Africa- SAP BW Analysis authorization for HR payroll
 The main objective is to guarantee a secure authorization structure.
 The HR-reports should not be executable by unauthorized users. This system should not lead to
redundant data or inflation of workbooks and queries.
o Create reporting objects ,Create roles ,Create variables required for authorizations ,Create the profile
users ,Assign authorization profiles to users ,Validate authorization concept ,
o Test user roles and authorization design
o Refine User Roles and Authorization Design
 Technical Environment : SAP BW, SAP ECC & BeX Explorer

09.2012 - 02.2013-SAPPI Fine Paper Europe- SAP BI4& HANA on ECC
 Adaptation of the Analytics views by modifying the Attributes and Calculation views.
o Creation of Advanced Analysis reports on top of SAP HANA 1.0
o Complete from scratch HANA modelling, development and pre/post go live support for a Supply chain
management dashboard on operational data (SAP ECC system).
o BI4.0 reporting on HANA views, using IDT and Dashboard designer and advanced analysis for Excel.
 Technical Environment : SAP HANA Studio, SAP ECC,SAP BO Advanced analysis for Excel,Design
Studio
11.2011 - 08.2012- RealDolmen- SAP BI4 & BPC10 Data validation
 Development of universes based on underlying Ms SQL tables for direct analysis using context,
joins and cardinalities
o Development of universes, Creation of WeBi reports
o Creation of WeBi Based on the logical universe ,Correction of existing WeBi to adapt to new change
request ,Creation WeBi report based on PMCC core HR/FI/Productivity ,Troubleshooting of existing
universe, WeBi in case of problem with report data
 Testing scenarii and testing execution follow up.
 Technical Environment : SAP FI, SAP IDT Universe, SAP BO WeBi, SAP BPC MS

10.2010 - 10.2011- Cetelem BuyWay- SAP FI Data Extraction & validation
 Direct Extraction:1 entity (GL, AP & AR) + 1 plant (inventory)
 Batch Extraction: Multiple companies (Entities GL, AP, AR) or multiple plants (inventory)
 Simple operation mode: Pre-defined dataset
 Advanced operation mode: Customizable dataset
 SEPA and Electronic Bank Statement configuration
 P2P configuration
 Technical Environment : SAP FI AR/AP, ETL Data Analysis, Single Euro Payments Area
(SEPA),P2P, Repot Painter

06.2009 - 10.2010- Lafarge- SAP BI & BW/BOBJ
 Developing data warehouses / data-marts and dimensional data models
 Use of data modeling tools
 Use of SAP Business Objects, BOBJ, ( WeBi, Xcelsius, Universe Design)
 Accessing data within SAP ERP and SAP Business Warehouse
 Use of data load (ETL) and data quality
 Setting up the tests scenarios and test execution
 Technical Environment : SAP FI, BW,BO, ETL Data services

10.2008 - 04.2009- AND Technologies-SAP Trainer
 Giving a BW training 305-310
 Developing a technical prospection for the training area
 Technical Environment : SAP BW,BO

06.2003 – 09.2008- Flora Holland-- SAP Competency center Support
 The competence center offers technical and functional end to end support on tailored BI and EPM
solutions for more than 150 farms:
o On demand/critical period application support
o Application maintenance and management
o Testing
o Coaching and training
 Technical Environment : SAP FI P2P, Repot Painter, MM, SD, BW & BO Universe