Aissatou - Consultant DECISIONNEL
Ref : 120723T001-
94120 FONTENAY SOUS BOIS
-
Consultant (48 ans)
-
Freelance
Client ACMV vie
Segment: Banking and Life Insurance
Duration Since June 2012
• Build of Reports for the direction of Financial Investment.
• In Charge of Reporting on Financial Assets and Reporting of monthly closing
• Set up reporting on Portfolio of assets, on Mutual Funds gains, on Capital gains, Credit risk and liquidity Risk.
• Providing advisory on choice and integration of SAP XCelsius or SAP Crystal Report as the application for Financial Asset Dashboard.
• Build of reports with SAP Business Object XI Info view and WEBI.
Pre sales mission: Cloud solution
Duration: February to Mai 2012
Pre sale activities: Mid-size company in micro finance.
• Presentation of SAP business by design solution and the components of the offer
• Schematization of integration between On-Premise customer: SAP ECC and On demand solution SAP by Design.
• SWOT (strength, weakness, opportunity and threat) and analysis of the offer.
Pre- sale activities for SAP Sourcing on Demand:
• Presentation of the Process of Sourcing to Contract: requests for information; RFP: requests for proposal; RFQ: requests for quotation.
• Presentation of the advantage of the solution Cloud, the hosting of the solution and the TCO (Total Cost of ownership)
• Presentation of the SAP Sourcing version - Wave 7 and the scenario of implementation for the lines of business of a company.
• Schematization of integration between Contract Management and SAP SRM.
Client SCOR
Segment Reinsurance
Duration October 2010 – 2011
Project SAP One Ledger Project
• SAP BI Consultant in Reporting & ETL Team
• Modelling of SAP business Warehouse: Reporting on Financial management EhP3 architecture, installation of BI content.
• Creation of DSO, cubes, multi providers, process chain and open hub destinations.
• Participation in design phase of Omega Technical Accounting interface built with ETL Data Services.
• Delivering functional specifications of technical accounting and settlement interfaces.
• Realizing the technical specifications of the Mapping Tables generated from the ETL Data Services and stored in SAP ECC application.
• Reporting on data from SAP Financial Accounting with parallel ledger
• Creation of BEX Queries with query designer and BO-WEBI of Business Objects XI 3.1.
• Build balance sheet, income statement and cash flow reports.
• Build of SAP Business Object reconciliation report between queries based on various universes.
• Loading data from SAP Business Object Financial Consolidation via Extended Analytic tool of SAP BFC (Business Financial Consolidation).
WORK EXPERIENCE: BT France 2008-2010
Client EADS DS
Segment Aeronautics
Duration September 2009 – September 2010
Project SAP TRIO
Main responsibility SAP BW Consultant
• Responsible of Second level Support on BW Scope (1 thousand of users of France and Finland business Unit)
• In charge of reporting on PS (Project System), Capacity Planning, CO and SD report of Project Management dashboard.
• Building financial reporting on Project template that consolidates data on Turnover, Actual Cost, Margin, and Lost at completion and Provision.
• In charge of the P&L (Profit and Loss statement) reporting per Profit Centre with revenues, margin, and cost of goods sold, accruals and other expenses.
• Ensuring the enhancement of standard extractor for change request.
• Creation of generic data source and the extension of standard data source for modelling new business requirements.
Client SALINS Group
Segment Foods Industry
Duration May 2009 to July 2009
Project SAP BW project within SAP Competency Centre
• Manage the Change Request of Project Controller
• Reporting on Controlling data.
Client Pre Sales mission
Segment Retail
Duration January 2009 to April 2009
Project SAP Project BW
• Framework study for setting a data warehouse dedicated to a client of retail segment.
Technical Environment SAP BI 7.0
Mission BW Consultant
• Set up a reporting on BI V7.0 in the area of SAP Financial Supply Chain Management.
• Modelling the flow for standard reporting on Dispute Management and Promise of payment.
• Set up a demo model of standard reporting with SAP BI 7.0 in the area of SAP FI new ledger in accordance with IFRS (International Financial Reporting standards)
Client France TELECOM via IBM ( Toulouse)
Segment Telecom
Duration January 2008 to December 2008
Project GOLD PILOTAGE
• Project for optimization of Purchasing Process of France Telecom group
• Committed to area of Project Gold–Ecorp for the extraction of data from SRM (Supplier Relationship Management)
Main responsibilities BW Consultant
• Updating the blueprint document for the version G6R2 on Gold project.
Estimating the workload and costs on design, build and tests phase for new requests and upgrade of reporting.
• Updating the general design and the detailed specifications.
• Modelling of the contract flow and the vendor flow for BW restitution.
• Updating the technical specification.
• Realizing the translation into English of technical specifications dedicated to ABAP programmers located in India.
• In charge of the supervision of technical consultants based in India.
WORK EXPERIENCE: Logica Management 2005-2007
Client EDF
Segment Energy
Duration February 2007 to December 2007
Project ROD Project
• Implementing operational reporting for Engineering Directory Reporting on Inventory Management with Snapshot Business Logic and with non cumulative key figures logic
Role in the project BW Consultant
• Committed to the functional and technical specifications deliveries
• Modelling of BW flow for reporting purpose based on data from SAP MM.
• Testing in development environment.
• Realized transport order from development to quality environment.
• Committed to user acceptance test in quality environment.
• Created Process chain for optimizing the loading of master data and transactional data.
• Provided to Maintenance team, a how to process document recording the flow of loading master data for the go live of the project.
Client EDF
Segment Energy
Duration March 2006 to February 2007
Project Project "AE-EGD Analyse Economique Electricite Gaz Distribution"
• Committed to the full cycle project V1.1 and V1.2 of AEPR” Analyse Economique du Distributeur” from design to implementation
• Set up indicator for improving the process of economic activity within the framework of the annual contract of performance.
Role in the project
• Functional and technical specifications of KPI extracted from legacy system. Design of CAPEX (capital expenditure) indicators based on data from SAP CO and SAP FI modules.
• Modelling the data warehouse: creation of info objects, key figures, ODS, cubes, info source and update rules for reporting purpose.
• Running user acceptance test and delivering tests document.
Client EDF
Segment Energy
Duration November 2005 to January 2006
Project
Project SIMPA
• Project for dashboard of Purchasing directory: Setting a reporting with SAP BW
Role in the project
• Created query with the query designer and the WAD ( Web Application Designer)
• Drafted the functional specification of SAP BEX queries.
WORK EXPERIENCE UNILEVER 2004
Client UNILEVER
Segment Consumer goods
Duration of mission January 2004 to December 2004
Project Project BUSINESS UNIT FOOD SOLUTIONS
• SAP Demand Planning
SAP Context SAP APO
Role in the project SAP Analyst
• Provided interface between Marketing and Central Planning team for integrating the forecasts of sales in the process of planning.
• In charge of the consolidation of the forecast with the marketing after analysing the gap between the actual data and the planned data.
• Reporting on actual data and planned data.
PREVIOUS WORK EXPERIENCE:
Coca Cola Enterprise (Internship)
From 04/2002 to 12/2002 Logistic coordinator
Mission : Optimization of logistical flow within portfolio of clients management
• In charge of portfolio of customers of Retail.
• Follow up of replenishment of the warehouses with EWR (Efficient warehouse response) model.
• In charge of coordination of flow and provided interface between production, transport, and sales team.
Technical Environment INFLUX, EWR (Efficient warehouse response)
EDUCATION - TRAINING:
Graduate
2002 Master in Management of logistical System - (BAC+6)
ENPC (Ecole Nationale des Ponts et Chaussées)
Engineering School Paris
SAP R/3 Training
2005 SAP BW310 Data Warehousing at SAP training school
2008 SAP BW370 Integrated Planning - November 2008 at SAP training school
2011 SAP Crystal Report.
2012 SAP HANA Basic Modelling
2012 SAP Xcelsius
LANGUES :
English Fluent
French Fluent
SKILLS
• Collecting business requirements for reporting
• Functional Specifications and Blueprint document
• Reporting for Financial Dashboard and Controlling Dashboard
• Finance Reporting: balance sheet, Profit & Loss Statement, cash flow statement.
• Running user acceptance test.
• Assistance during implementation and Go live.
Technical Competencies
• Modelling SAP BW data warehouse: creation of cubes, DSO, multi provider, open hub destination
• Extraction, Transformation and Loading Data. Creation of Process Chain
• Performance Tuning.
• Creation of generic data sources. Enhancement of standard extractors
• Creation of queries with, query Designer and WAD (Web application Designer)
• Creation of SAP Business Object Universe with Universe Designer
• Creation of Reports with SAP Business Object : WEBI
• Integration of SAP BW and SAP Business Object.