Deployment BI 4 & Reporting WEBI – BEX
In installation of BO server et development of WEBI queries
SAP Business analyst and BEX designer
investigated reliable information throughout dashboards and financial reports necessary to elaborate strategic decisions
Analyzed and focused on gathering information(data , business rules)
Developped and simplified BEX report creation process to fit the webi reports
Trained keys users in order to be autonomous
Designed Multiprovider and InfoCUbe and BEX queries
Customized Multiprovider to allow the use of navigational attributes with the webi report
Developed routines with ABAP and enhance mapping transformation
Developed over 25 webi queries and 8 analysis for OLAP reports
Activated Datasource for PP & MM& FICO modules
Responsibilities
Responsible for updating all web reports template for all the developers in the Nestle world using SAP WAD and JavaScript. Also responsible for giving recommendations to developers to create web reports using JavaScript or the command wizard .
- Enhance web template with JavaScript to replace command wizard
o To test input variable
o To change an event dynamically
o To switch DPs
o …
- Generated standard and costumed reports using BEx Query Designer and web application designer
- Extensively used calculated and restricted key figures, structures, cell definitions, variables and conditions for the queries.
- Creating BSP function call from the JavaScript code (Web template)
- Developing ABAP program
- Modifications of existing web report using interface table for WAD 3.5
- Developing new Dashboard reports( xcelsius)
- Created the high level documentation to present to the business user
- Analyzed the business requirements by involving in daily meetings with the business users.
Responsibilities
Techno-Functional BI4 - BOXI 4
- Create DASHBOARD 4 report with MSAS, ORACLE v11, Essbase
- Integration SAPBO PCM 7.5 to XI4
- Migration of UNV universes to Unx, and reports from 3.1 to 4
- Configuration of BI Mobile platform for iPad
- Set up the BI 4 environment for Java Stack SAP Nweaver
- Analyse and use of LCM (LifeCycleManagement) to promote reports
- Analyse de la performance et du monitoring
- SSO configuration with BI4
- Create connexions with UDT and IDT for AIX et Windows for :
- bics , MS sql server , MS Analysis Services , Oracle , Essbas
- Excel Access Txt
- POC BPC 10.0 for IFRS
- POC PCM : Data loading from BW 7.3 to PCM via DataBridge
Responsibilities
Responsible to design and maintain UNV universe, generate 39 webi complex reports. Also to enhance the BW data modelling
- Interacted with Business Users and Business Analysts to gather
and document the Requirements and translate these to Technical
Specifications for Designing Universes.
- Elaboration de 39 rapports WEBI
- Lifecycle (Requirement gathering through) of Business Objects
Reporting.
- Building and managing Universes, creating Complex, Ad-hoc
Reports and/ or Charts using WEBI 3.1 : like Gross Margin,Account
Query,Aging,Balance Sheet,Income Statement,
Bad Debt and Payment Reports in response to user needs from
multiple Bex Query
- Expertise in using BEX query as, MDX to generate reports.
- Improved the performance and reduced the coding of MDX with
the use of @functions ( @select, @prompt, @where).
- Exported the universe to the Repository to make resources available
to the users
- Trained end users to use various functionalities of Business
Objects (webi) and provided technical support.
- Performed specific extractions from flat file and BW according to client requirements
- Enhancements on Accounts Receivables (AR) cube 0FIAR_CO2.
The DSO analysis (Days of Sales Outstanding) deals with the payment history of customers. It returns general information on the outstanding debts of a customer for a certain period in relation to the average daily business volume of the customer in question.
- Tailored Transfer Structures, Communication Structures, and Update Rules using routines and Start Routines to optimize performance.
Responsibilities
Responsible for doing detailed analysis, gather requirements, map requirement, write functional specification for the configuration, on Accounts Receivable Area general Ledger area and asset area.
- FI-GL : General ledger
Define global parameters
Create local and group chat of account
Assign a company to a local chart of account
Defining tax account
Création d’une structure de bilan et de compte de résultat
Define the balance sheet structure
- FI-AR : Accounts receivable configuration
Create customer group account
Define document type
- FI-AA : Asset account
Create chart of depreciation
Create asset class
Integration with the general ledger
- Update Data (Master Data and transactional data)
Using LSMW to update
Customer master data ,GL Account
Open items and clearing value
- BPC
SAP ECC 6 side
Financial Consolidation Preparation
- CO-CCA : cost center configuration
Define controlling area
Create number range for CO
Define the cost center group
Create and define a transfer of primary cost to cost center / orders
Créate distribution
Create periodic reposting
Cretate assessment
Create periodic reposting
- CO-OM-OPA : overhead costs order
Create order type
settle...
Responsibilities
Responsible to identified SAP Business content data sources and installed the standard InfoObjet InfoCube for both Master data and Transaction data. Also responsible for creating reports to analyze billing and cost center using webi
- Created Universes by defining connections and retrieving data
From Database
- Created New Classes and User Objects in designing the universes.
- Exported the universes to the Repository to make resources
available to the users.
- Created and modified the WEBi Reports for various financial
using the Universe as a main data provider.
- Extensively used Calculations, Variables, Drill Down and Slice and
Dice for creating WEBI Report
- Published reports using Info View, and trained users for ad-hoc
reporting.
- integration between BO XI and Netweaver BI 7
- Created 15 rapports via CR 2008 with SAP InfoSets
- Gathered Business Requirements and Conducted Gap Analysis to
Install Business Content.
- Created the BI objects like DSO’s, Cubes, Multiproviders
depending on the data and reporting requirements.
- Created the transformations, DTP’s and error DTP’s to handle the errors during the data load.
- Developed data loading strategies for master data, transactional data and delta uploads.
Deployment BW to UK 4 & BW Split Reporting & Provide an P&L to manage the double currency GBP and EUR
0/2014 to now
Contexte SAP
Role
SD FI CO
SAP Business analyst and BEX designer
Analyzed the business process integration to elaborate and establish the sales orders and Billing reports
Used the same process to established the montly sales , the margin , brand, doors analyze , etc
Investigted on composed value in COPA to provide a P&L with the derivation, and analyse the expense and the purchase ….
Developed reports routines with virtual characteristics and ABAP
Developed the stocks extractors 2LIS_03_BX, 2LIS_03_BF,2lis_03_UM
BW server configuration
Customization and enhance the BI authorization AND roles
Designed new BW flow to manage P&L
Update and optimize the process load with maintain operation mode and instances
Developed process chain to automate the initialization and delta updating of the data
Implemented security ans authorization objects
Implemented ODS and 3 infoproviders and 2 multiproviders to develop the p&l reports
BEX front end tools
Designed BEX report with query Designer
BO server configuration
CMC Administration
Configured the APS and DSL Bridge to improve the report performance for WEBI
Enhance the WDSL bridge to optimize the performance of webi report
Configured the life Cycle manager to promote objects from dev to qa and production
Scheduling /publishing the web reports on daily basis to the users inbox.
Resolved and established performance tuning and troubleshoot technical administrative error and issues
CONFIGURED End to end tracing
Configured erformance and load testing on Jmeter
etc
BO & BEX front end tools
Created new reports using WEBI with bics CONNEXION to the user requirements
Designed the business , connexion , and foundation layer with IDT
Configured the BICS connexion on the CMC
Explored the variables values on bex reports in WEBI repots
Created webi report with merge function to join 2 or 3 BEX queries
Created jump query with the OpenDocument
Created graph query
Designed BEX report with query Designer
Designed alerts query and sceduling query