Montréal, Canada / Phone: 514-***-****

_ E-mail: act6t8@r.postjobfree.com

profile

Triple SAP Certified Consultant (SAP HANA, SAP BW and SAP ABAP) holding a MS degree in Electrical

Engineering, with 19 years of IT experience, including the last 14 years in the SAP BI/BW/HANA/ABAP

arena as: BW Architect, BW Techno/Functional and ABAP programmer. Bilingual: English and French.

canadian government Security clearance

Level: SECRET

Certificate #: 95219800-0001679917

Expiry Date: February 24, 2025

SAP–PROFESSIONAL EXPERTISE

SAP HANA

Knowledge of several areas and features of the SAP HANA as follows:

SAP HANA Studio – Import/Export Functionality, Delivery Units, Data Provisioning (both initial load and

replication), SQL Console, Modeler / Administration / Development / ABAP / Debug Perspectives, Information Models, System Configuration, Catalog (Schemas), Content (Repository).

HANA Architecture – Columnar Data Storage, multi-core CPUs, Extended Application Services (XS).

HANA Data Modeling – Attribute, Analytic and Calculation (both graphical and SQLScript) Views, Filters &

Variables, Hierarchies, Restricted & Calculated Measures, Stored Procedures (both SQL and SQLScript/CE Functions) using both the UI and the SQL Editor, Decision Tables with Update/Return Values.

HANA Data Provisioning – Trigger-based replication with SAP Landscape Transformation (SLT), BO Data

Services (BODS), SAP Direct Extractor Connection (DXC) and Flat File Upload.

HANA Optimization – The following optimizations apply to statements in SQLScript and allow the dataflow to

exploit parallelism in the database:

Reducing the complexity of SQL statements, by breaking them into simpler ones.

Distinguishing between declarative logic (side-effect free functions) and imperative logic.

Understanding the Cost of Statements by employing the ‘explain plan’ feature.

Reducing Dependencies (independent dataflow graph paths) enables better parallelism.

Multi-Level-Aggregation (using results at a finer grouping for computing coarser aggregation).

Avoiding Cursors & Dynamic SQL and mixing Calculation Engine Plan Operators & SQL Queries.

HANA Reporting – Data Base Connectivity Options (ODBC, JDBC, ODBO/MDX) and interfaces to BI

client tools, such as BusinessObjects Explorer, Crystal Reports, WebI and Xcelsius.

HANA Security & Authorization – User Management, Authentication, Analytical Privileges and Roles.

SAP BW on Any DB

Multiple Full Life Cycle project implementation experience with proficiency in all areas of SAP BW that includes both backend and frontend processes. This encompasses:

Multi-Dimensional Modeling, Star Schema, Granularity, Tracking History, Frequently Changing Attributes, ETL (OLTP Extraction) Data Flow, Business Content and Custom DataSources, Generic DataSources, non-SAP Source System Integration (Flat Files), LO Cockpit Configuration, Delta Management (Initial and Delta Loads), Master/Transaction Data, Hierarchies, PSA, Transfer/Update Rules for 3.x, DTPs, InfoObjects, InfoSources, complex ABAP code at all levels of the Transformation (Start, End and Expert Routine) and at Update Rules level, DSOs (standard and write-optimized), EDW layer architecture, InfoSets, InfoCubes, MultiProviders, Display/Navigational Attributes, InfoPackages, Process/Meta Chains, Monitoring and Fixing of Data Loads, Open Hub Service (InfoSpokes), APD (Analysis Process Designer), Authorization Concept, Queries, Workbooks, BEx (Web) Analyzer, BEx Query Designer, Variables (for Characteristics, Texts and Formulas), Exceptions and Conditions, Calculated/Restricted Key Figures, Virtual Key Figures/Characteristics (using both User Exits and BAdIs), Drill through Queries (Jump Queries), RRI, Debugging Queries, Transport Management System (ECC and BW), Production Support, Performance Tuning (Statistics, Parallel Processing, Aggregates, OLAP Cache, Physical/Logical Partitioning, Compression, Indices and Query Read Mode), Functional and Technical Specs, Training Material, Documentation.

Experience with SAP BW 2.0B, 2.1C, 3.0B, 3.1, 3.5, NW 7.0/7.1/7.3.

Experience of Business Objects suite of products including: Info View, Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, WebI.

SAP BW on HANA

Knowledge of architectural simplifications and data modeling optimizations by deploying new objects like:

Advanced DataStore Object (ADSO) – next generation smart BW object for the data persistance.

Open ODS View – allows field-based modeling and analytic functionality on top of the external data structures due to different interfaces like smart data access. It combines external data with BW data.

Composite Provider – supports union/join operations and combines data from BW and HANA.

Reducing complexity and increase the agility through HANA-optimized objects:

Info Cube – conversion of the star schema into a flat data model and elimination of aggregates.

Data Store Object – delta calculation implemented in HANA and speed up of the activation process.

Data Provisioning options:

Operational Data Provisioning(ODP) Data Source through its Operational Delta Queue (ODQ) framework provides a unified concept for different sources: SLT (real-time replication), ERP extractors, HANA Views.

Smart Data Access Layer – the Logical Data Warehousing using HANA’s federation capability across various sources: Oracle, Teradata, Hadoop, ASE, IQ, MSS, DB2.

Optimized ETL Process – DSO Activation and Transformations are pushed down to the database.

Automated model generation – direct consumption (through SQL, SAP Lumira or BO Explorer) of BW data via the generated HANA views. Supports automatic synchronization of authorizations.

BW Analytic Manager – wide variety of OLAP functions generating calculation executed directly in HANA.

HANA Analysis Process (HAP) – executes HANA native functions directly on BW InfoProvider data.

BW Modeling Tools (BWMT) – integration and harmonization of BW and HANA models in one modeling environment on the Eclipse-based paltform.

SAP ABAP for HANA

Code-to-Data Paradigm – delegate data-intensive operations to the data layer (‘Top-Down’ approach) using:

Open SQL Enhancements (new syntax) & ABAP Dictionary External Views.

Core Data Services (CDS) Views including: Data Definition Language (DDL), Query Language (QL), Data Manipulation Language (DML) and Data Control Language (DCL), Associations/Path Expressions.

ABAP Managed Database Procedures (AMDP) and debugging them by creating ‘Debug Configuration’ and deploying ‘DEBUGUSER’, ‘SAPHANAABAP’ and ‘DEVELOPER’ users. Extending AMDPs using BAdIs. Creation of the Enhancement Spots and the BAdI definition (AMDP BAdI Interface).

Native SQL via object-based ‘ABAP Database Connectivity’ (ADBC) API.

Performance Optimization of existing ABAP code using: ABAP Test Cockpit (static code checks), SQL Monitor data analysis (tran. SQLMD) and SQL Performance Tuning Worklist (tran. SWLT).

ABAP Development Tools (ADT) – perspective based on Eclipse (the one integration platform).

SAP ABAP

Process/Business knowledge of several Functional Areas (Logistics, Finance, Service Management, Purchasing) as well as Technical skills in the following SAP R/3 (ECC) modules: MM, SD, FI/CO, PM, QM, PP/PP-PI, HR, EH&S, PS, LO-Cockpit with ABAP/4 proficiency in: Batch Input (BDC/Interfaces), Call Transaction, SAP standard programs (LSMW/Conversions), RFCs, BAPIs, ABAP Object Oriented Programming, Dialog Programming, SAPscript, Interactive Reporting, Function Modules and User Exits (Enhancements). Experience with R/3 versions starting with: 3.1i, 4.0x, 4.5x, 4.6x up to ECC 6.0.

MAJOR ASSIGNMENTS

Government of Canada / Department of National Defense – Ottawa, Ontario, Canada

DRMIS (Defence Resource Management Information System) Project

EIE (Electronic Information Exchange) ISCoE Project

BW Architect / Developer – SAP NetWeaver BI 7.3

September 2013 – July 2014

Reporting requirements gathering for several business processes in PM (CCV and TAPV data marts).

Designed and configured several BW objects to support the PM reporting needs for: Maintenance Notifications, Measurement Documents (Counter Readings) and Work Orders.

Designed the following PM Army reports:

Usage/Counter Readings – used by the TAPV fleet users to report on counter readings that have been raised in DRMIS. The readings are used by maintenance plans to create Notifications and Work Orders for scheduled maintenance.

Actual Hours recorded in the Work Orders – used by TAPV fleet users to report on actual hours (time recorded) spent on a task list vs. the planned hours (the duration) recorded in a task list.

Notifications by Fleet – used by the TAPV fleet users to report on Maintenance Notifications, per fleet, that have been completed within a pre-defined date range.

Work Orders by Fleet – used by the TAPV fleet users to report on Maintenance Work Orders per fleet and completed within a pre-defined date range by displaying different vehicle data.

Additionally, all the above mentioned reports serve as data collection for the PBA (Performance Based Assesment) calculations.

Debugged and fixed two Navy reports used to provide information for Units, Maintenance Plants and Functional Locations (compression of the Info Provider ’with zero elimination’ functionality was used).

Activation of Business Content for several BW objects related to WM (Warehouse Management) and DG (Dangerous Goods) Shipment functional areas.

Addressed performance issues by optimizing the ABAP code at different levels: custom extractors on the ECC side, Transformation level on the BW side (Start and End Routines).

Production support including resolving incidents, defects correction, requests for change and performance improvement activities. Debugged Meta / Process Chains, ABAP code and Queries.

Used ’Solution Manager’ to prepare the technical documentation and for production issues.

IATA (International Air Transport Association) – Montréal, Québec, Canada

CBS (Central Billing System) Project

BW Architect / Developer – SAP NetWeaver BI 7.3

April 2012 – August 2012

IATA (International Air Transport Association) provides participating airlines and BSPs (Billing and Settlement Plan) a Centralized Billing Service for their purchases. As a result, the airlines and BSPs do not receive invoices from multiple suppliers/service providers.

All external purchased transactions are consolidated by 5 regional Data Processing Centers (DPC) covering five main geographical areas of the world. As part of the integrated central billing solution, DPCs will provide IATA, on a regular basis, details of the business transactions. Four types of files will be sent to IATA: STAT (Statistical), ASRV (Additional Services), Sales and Credit Card.

Configured the entire DPC flow (from the ECC side up to the BW side) by creating four custom tables (loaded from the external files provided by DPCs), Generic Data Sources (built on tables’ views), two EDW layers: an acquisition layer (using write-optimized DSOs) and a DW layer (using standard DSOs). Designed several InfoCubes (one for each file) and a MultiProvider on top.

Migrated/Converted several DataSources, Transfer Rules and Update Rules from version 3.5 to 7.3 for the existing SD and Purchasing solutions.

Enhanced the standard extractors for SD and Purchasing with custom fields and wrote ABAP code to populate them by using BAdIs (Business Add In).

Re-designed multiple InfoCubes from the existing SD and Purchasing solution because they did not comply with the best practice standards (for example big Dimensions – sometimes 80% of the Fact Table). Also I have added a MultiProvider to the Purchasing and SD solution. Wrote complex ABAP code at the Transformation level for all three data flows: DPC, SD and Purchasing.

Created and Debugged Process Chains for each data flow and loaded the data into BW.

Designed three (DPC, Sales and Purchasing) BEx queries - for each data flow - in order to be used as data sources for the Universe creation in BusinessObjects.

Created Transports and debugged the transports errors on both sides: ECC and BW.

Developed documentation, transferred the knowledge and remotely supported the solution.

Les Rôtisseries St-Hubert – Laval, Québec, Canada

TREBUH Project

BW Architect / Developer – SAP NetWeaver BI 7.0

October 2011 – February 2012

Reporting requirements gathering and Gap-Fit Analysis for reports within the PP-PI module (Work Center, Component and Material Views) and the following applications within HCM module: ’Personnel Management’ (Benefits, Organization Management and Personnel Administration), ’Time Management’ and ’Payroll’.

Wrote two Function Modules for extracting production planning data at Operations/Confirmations level, as well as at the Component level of the Process Orders.

Configured, tested and debugged the BW objects used: Info Packages, Transformations, DTPs, DSOs, InfoProviders, MultiProviders and BEx Reports.

Using Query Designer, created two queries: ’Global Efficiency Rate’ and ’Components View’ for Process Orders using Restricted and Calculated Key Figures, Variables and complex Formulas in order to display several metrics such as ’Opening Time’, ’Standard Time’, ’Confirmed Efficiency’, ’Confirmed Scrap’, ’Effective Efficiency Rate’, by Work Center and Production Orders.

Activated several BW objects from HCM Business Content and designed the ’Headcount’ query.

Developed documentation and knowledge transfer.

Vera Bradley Designs – Fort Wayne, Indiana, US

AFS Sales Project

BW Architect / BO Developer – SAP NetWeaver 7.0

September 2010 – January 2012

Re-instated the DEV (BWD) and QAS (BWQ) environments to a fully functional state.

Full production support and troubleshooting at all data flow levels: loading from the ECC (R/3) source system through Process Chains, Transformations, Update Rules, Data Transfer Processes (DTPs), BEx queries, Universes and WebI reports.

Devised/debugged complex Universes (based on BEx queries) and WebI reports like ’Corporate Daily Flash’, ’New Retailer’, ’Period End Net Sales by Customer’ and ’Sales Open Orders Summary’.

Improved the performance of several BEx queries by creating multiple aggregates and using the OLAP cache warming technique as well as ’Reporting Agent’ and ’Broadcasting’ features of AWB.

Improved the loading performance by using highly efficient ABAP code (buffering technique, hashed /sorted internal tables, binary search).

Implemented functionality (in several Meta Chains) to trigger daily BusinessObjects reports by using an ’Operating System Command’ process type feature.

Analyzed (using Tran. DB02) and implemented strategies like deleting requests from PSA and DSO Change Log Tables in order to reduce the database size and minimize the disk space consumption.

Configured, tested and debugged BW objects used in the system landscape (DEV, QAS and PRD).

Fossil – Richardson, Texas, US

Retail Style Selling Project

BW Architect / Developer – SAP NetWeaver 2004s

June 2010 – August 2010

Conceived the architecture and configured two BW systems, Retail and Wholesale, for the Retail Style Selling (RSS) data mart.

Configured (on Retail system) the Inventory Snapshot by deploying the Analysis Process Designer (APD) functionality. Within the APD, using a Query View (based on a non-cumulative weekly Inventory Stock InfoProvider) as a Data Source and through a Transformation, loaded the data into a Direct Update DSO as a Data Target and ultimately generated an Export Data Source on the DSO in order to be used on the Wholesale side.

Configured (on Wholesale system) the Data Flow by using several InfoProviders (Watches, Leathers, Jewelry/Optical and Apparel/Footwear), DSOs, Transformations and DTPs, to capture data from four different sources: EDI, Flat Files (non-SAP data), Ecommerce and Point-of-Sale.

Improved the loading performance by using highly efficient ABAP code (Hashed Tables, buffering technique in order to reduce expensive I/O Database accesses, binary search).

Created Process and Meta Chains in order to automate the delta loading process, using the Remote Process Chain functionality to trigger a Meta Chain on the Wholesale system from the Retail system.

Enhanced and debugged four high visibility RSS queries: Fiscal Week/Period and Retail Week/Period.

Improved the query performance by creating multiple Aggregates (using Tran. RSRT and Statistics).

Wrote ABAP code to fill in several Global Variables using the User Exit: EXIT_SAPLRRS0_001.

Deployed the BW query functionality RRI (Report-to-Report Interface) to jump to R/3 transactions.

Developed ’12 Months Analysis’ query to extend the Fiscal Period for several metrics such as: ’Units Sold’, ’On Hand Quantity’, ’POS Total Amount’, ’Weeks of Sale’, ’Percentage Shares’, etc.

Tyson Foods – Fayetteville, Arkansas, US

BI Key Metrics Implementation Project

BW Architect / Developer – SAP NetWeaver 2004s

June 2008 – January 2009

Designed the architecture and configured the system for the following Data Marts:

Inventory Management (for both Catch-Weight and non Catch-Weight Materials) – (PP-PI).

Product Cost Controlling (CO-PC).

Completely re-designed the Extractor for the DataSource 2LIS_03_BF (Material Movements) in order to satisfy the reporting needs in the very special Catch-Weight environment, which requires the capture of dual units of measure for inventory tracking, where one unit of measure is typically related to weight and the other to dimension.

Created several Function Modules for all of the above mentioned Data Marts. They were dynamically called from the User Exit ZXRSAU01 (Central Distribution Mechanism).

Customized the Logistic Cockpit Data Extraction (LBWE) for Inventory and Production Planning (Shop Floor Control – Work Center, Component and Material Views).

Appended source system extractors with custom fields to extend their functionality and devised ABAP code to populate them by deploying User Exits: EXIT_SAPLRSAP_001/002.

Implemented, tested and debugged BW objects used in the system landscape design like: DTPs, Transformations, DSOs (Write-Optimized and Standard), InfoCubes, MultiProviders, BEx/Web Queries.

Devised code to fill in the Global Variables used in reporting by deploying EXIT_SAPLRRS0_001 and also implemented Virtual Key Figures/Characteristics using EXIT_SAPMRSRU_001.

Scheduled and monitored the data loads into QAS & PRD environments. Performance tuning.

Debugged and fixed several data loads issues (Master and Transaction Data).

Wrote complex ABAP code at all levels of the Transformation: Start, End and Expert Routines.

Developed documentation.

Forest Laboratories – New York, New York, US

Phase II Project

BW Techno / Functional – SAP NetWeaver 7.0

August 2007 – March 2008

Participated in requirements definition and design review sessions for the Quarterly Alignment Data Mart (assignment of a customer to an authorized territory which is a mechanism to link Rx’s to sales representatives). IMS Health Inc. (Intercontinental Marketing Services) is a primary source of Forest’s Health Care Professional and Health Care Organizational data that provides 2 data sets (Reports 98 & 52), one for US and one for Puerto Rico, on a quarterly basis. Reports 98 & 52 data is used to produce: Deciles (a ranking method based on prescriptions written during the previous 12 months, which groups HCPs into bands based on the total volume of scripts), Goal Files (data feeds to SAD – Sales Administration Department) for each alignment period and Prescriber Universe (the set of HCOs and HCPs for which Forest Labs purchases IMS prescription data).

Developed Technical Design Specifications for the above mentioned Data Mart.

Configured, tested and debugged the BW objects used in the system landscape design like: Standard and Generic DataSources, InfoPackages, Customized Transparent Tables, DTPs, DSOs (Standard and Write Optimized), InfoProviders, MultiProviders, BEx and Web Reports.

Wrote three ABAP Reports and Function Modules to calculate Deciles for each new Alignment Period at the Market/Brand/Product levels. Each program gets the data from a Staging DSO and then loads a custom Transparent Table used as a Generic DataSource to feed a specific InfoProvider.

Designed and maintained Process and Meta Chains for loading data into BW system.

Deployed Open Hub functionality (Info Spokes) in order to send data to other external systems.

Developed documentation.

Philip Morris USA – Richmond, Virginia, US

Envision Project

BW Architect / Developer – SAP BW 3.1B

February 2006 – May 2007

Designed the architecture of the following Data Marts:

Purchase to Pay

Inventory Management

Plant Maintenance

Quality Management

Purchase Deviation

Participated in requirements definition and design/design review sessions. Developed Technical Design Specifications.

Customized the Logistic Cockpit Data Extraction (Tran. LBWE) for Purchasing, Inventory, Plant Maintenance and Quality Management applications.

Appended source system Extractors with custom fields to extend their functionality and devised ABAP routines to populate them by deploying User Exits: EXIT_SAPLRSAP_001/002.

Devised a Function Module to extract Purchase Price Deviation information for a Generic DataSource using a View based on two transparent tables: BSIS and BKPF.

For a sound architecture (reliable and flexible) and to comply with the modern standards in the larger sense of CIF (Corporate Information Factory), created an EDW (Enterprise Data Warehouse) layer for each Data Mart mentioned above by deploying several ODSs, in some cases even two layers of ODSs. By taking advantage of the unique overwrite capability of the ODS, the down time for loading the Statistics Setup Tables on the R/3 source system was completely eliminated.

Configured, tested and debugged BW objects used in the system landscape design like InfoSources, Transfer Rules, Update Rules, ODSs, InfoCubes, MultiProviders, BEx and Web Reports.

Enhanced 0MAT_PLANT_ATTR and 0VENDOR_ATTR DataSources on the R/3 side and made the necessary configuration changes on the BW side to support the business solution.

For performance and flexibility reasons all queries were defined on MultiProviders built on top of the basic InfoProvider(s).

On the BW side, wrote ABAP routines at Transfer Rules/Update Rules level (Start Routine as well as characteristic/key figure level).

Debugged mass transport issues for transports having the return code > 4 on R/3 and BW systems.

Designed and maintained the Process Chains for Delta loads.

Scheduled and monitored the data loads into QAS and Production environments.

Debugged and fixed several data loads issues (Master and Transactional Data).

Applied several SAP OSS Notes to correct different problems.

Post Go-Live Production Support of ODSs and Cubes maintenance – extracting, loading, deleting and re-loading data (delta, full and initial loads). Compression of the non-cumulative Inventory Cube. Ran a SAP program to re-create the Reference Points for zero balance stocks in BW, including the creation of a special index at the database level to speed up the run time.

Analyzed and corrected different production problems as they occurred in the BW system.

For data validation purposes, deployed the BW query functionality RRI to jump to R/3 transactions.

Developed a standard template to be used internally for all Technical Design Specifications.

Developed documentation and transferred knowledge to the in-house stuff.

St. Lawrence Cement – Montréal, Québec, Canada

BW Developer – NetWeaver04 / BW 3.5

September 2005 – January 2006

Designed, maintained and debugged complex Workbooks for the Production planning reporting solution like: Global Variable Cost Variance for mineral components and for cement. Using Excel functionalities and VB code created highly graphical sheets (Main Page) in the Workbooks.

Using the BEx Analyzer and Tran. RSRT, developed and debugged several queries (deployed in the Workbooks) based on MultiProviders, for a more flexible and maintainable solution.

Wrote ABAP code to fill in the Global Variables and the Virtual Key Figures and Characteristics using the SAP user exit: EXIT_SAPLRRS0_001.

Based on BW Statistics, created aggregates to improve the running performance of the queries.

Fossil – Saverne, France

BW Techno / Functional – SAP BW 3.0B

January 2005 – July 2005

Participated in the requirements definition, data modeling and design sessions for the AFS (Apparel and Footwear Solutions) - SD application, as part of the Fossil European Data Mart solution.

Provided input on proposing, evaluating and selecting the best design alternatives in order to meet the reporting requirements and being consistent with the client’s standards and processes.

Configured, tested and debugged BW objects used in the system landscape design like: ODS, Info Cubes, Transfer Rules, Update Rules, MultiProviders, BEx and Web Reports, Process Chains.

Wrote complex ABAP routines for the Transfer and Update Rules (at Start Routine level).

Defined the pre-calculated Web reports and scheduled the packages by using the Reporting Agent functionality of the Administrator Workbench.

Created Process Chains to schedule the batch jobs for loading - from the R/3 system and flat files – Master/Transactional Data, Pre-calculated Web Templates and BW Statistics.

Maintained and debugged BEx and Web queries of the SD reporting solution like: ’Invoice Statistics’, ’Customer Order Statistics’, ’Allocated Orders’, ’Sales by Sales Rep.’, ’Top 50’, ’Selling Report’, ’Sales Manager Report (Gross, Returns and Net Sales)’, ’Sales by Sales Organization’ and ’Shipments’.

Activated several objects from the Business Content in order to speed up the delivery process. Using Transport Connection functionality of AWB, created transport requests.

Enhanced the Extract Structures and wrote code using the SAP User Exits: EXIT_SAPLRSAP_001 and EXIT_SAPLRSAP_002 in order to fill in the newly appended fields. Also devised code to fill in the Global Variables used in reporting by deploying EXIT_SAPLRRS0_001.

On the R/3 side used the Logistic Cockpit to manage the Extract Structures, Initialized the extraction process (deletion/filling of the Setup Tables), checking of the LIS Setup Log and BW Log.

Wrote two ABAP programs for data validation purposes for Billing and Sales Order applications.

Monitored the loads (Master and Transactional Data) into the QAS and PRD environments.

Developed documentation and transferred knowledge to the in-house stuff.

South Shore Industries – Sainte-Croix, Québec, Canada

BW Techno / Functional – NetWeaver04 / BW 3.5

October 2004 – December 2004

Tutoring BW (Data Modeling, Administrator Workbench, ODS objects, Business Content, OLTP Extraction, Reporting) to the employees from the IT department.

Defined the business process, modeled the data, assessed the requirements against Business Content, determined the required BW design and configured the software to replicate the business processes and analytical/reporting needs for the Purchasing application.

Created the Process Chains in order to automate the complex schedules in BW such as load into PSA, load into ODS, activate ODS data, load into InfoCube and monitored the processes.

Designed different queries based on the Purchasing InfoProvider using the following functionalities: calculated/restricted key figures, defining variables (characteristics, formulas), RRI (Report-to- Report Interface) to an ODS and R/3 transaction (MM23N) and complex calculations (formulas).

African Development Bank – Tunis, Tunisia

CDW (Corporate Data Warehouse) Project

SAP BW Architect

August 2004 – September 2004

Provided different scenarios for the overall design of the CDW Architecture to support the ADB (African Development Bank) vision of becoming a knowledge management organization, as well as acting as the primary reference source of economic data for the African continent.

Analyzed the pros and cons of a pure Corporate Data Warehouse solution versus SAP BW in the larger context of the Corporate Information Factory architectural landscape.

Analyzed and proposed solutions in the following areas: Data Extraction (SAP R/3 and non-SAP sources), Data Administration (ODS, InfoCubes) and Data Access & BI Tools (Business Explorer Suite and Third party tools – XML/A, ODBO, BAPI).

Proposed and demonstrated two BW’s functionalities: DB Connect (to load data from a DB system supported by SAP) and Open Hub Service (to export data to relational tables of non-SAP systems) for the inter-operability purposes within the framework’s architecture.

Bombardier Aerospace – Montréal, Québec, Canada

CSE (Commodity Source Enabler) Project

BW Techno / Functional – SAP BW 3.1

March 2004 – June 2004

Implemented the CSE tool to provide benefits to Sourcing, Engineering and Material Logistics by creating global visibility into vendor, part, spend and inventory data from multiple legacy systems.

Re-designed the whole solution, fine tuned the Data Model and Configuration (InfoSources, Update Rules, ODSs and InfoCubes) to better respond to the business needs and for performance reasons.

Loaded Master Data (vendor, part, contracts) and Transaction Data (PO – Purchase Order, MRV – Material Receipt Voucher) from flat files into BW. Employed different techniques to speed up the process: parallel loading (used up to 10 dialog and 3 background processes), changed settings for the ODS activation (number of parallel processes, number of data records, wait time, server group).

Designed and fine tuned the queries using the following tools to monitor the overall performance: Statistics, Workload Analysis (Expert Mode), transaction RSRT and content of table RSDDSTAT.

Wrote complex code at the Update

Contact this candidate