Kossigan - Consultant SAP BW

SAP BI Consultant

duration : 2,5 months
Ver. SAP BW 7.x, BI4, HANA
Training and Demo platform
• SAP ECC6/SAP Netweaver 7.3
• SAP BI4 IDT, WEBI, Design studio, Cristals report using BICS connection, Analysis
• SAP HANA studio : Create Tables, views, BW Datasource with DXC connections
Data Model: create attribute views, analytic views, calculation views,
Importing a BW InfoProvider into SAP HANA as analytical model,
• hana optimized infocube , composite and transient infoprovider
• Design studio : Create applications using Bex queries on SAP BW/Hana system

SAP BI Consultant

duration : 34 months
Ver. NetWeaver BW 7.0, 7.3 BI4, ECC6.0

Project ONE: Implementation of SAP ECC and BW7x, BI.4
SAP ERP: PP, MM, SD, QM, FI, CO, COPA.
Rollouts of the solution to several Manitowoc regions (Europe, APAC, America, China…)

BW Technical Lead and development: FI, CO, COPA, QM.

Functional requirements analysis, define BW technical specifications
Provide technical guidelines for the data modelling and development
Develop Datasources, DSO, cubes, BEX and WEB queries and process chain
Manage and follow up the offshore BW development team members.
Coordinate the development activities of the offshore team.

SAP BW/BI Business Analyst: FI, CO, COPA, QM.

Collect functional requirements from end/key users, Finance and Quality team.
Organize workshop and gap fit analysis, requirements analysis.
Define BW functional specifications. Provide technical guidelines for the data modelling.
Gap fit analysis for new countries deployment and for enhancements.
Provide testing data, data load, organize unit testing and UAT.
Write user guide for delivered reports, organize training, knowledge transfer and support to end-users.
Rebuild with Design Studio and WEBI some existing WAD reports for Finance and Quality management teams.

ETL:
• LO cockpit extractors used : 2LIS_02*, 2LIS_03*, 2LIS_04*, 2LIS_05*, 2LIS_06*, 2LIS_08*.2LIS_11*, 2LIS_12*, 2LIS_13*, 0FI_GL*, 0FI_AP*, 0FI_AR*, 0CO_* , COPA generated DataSource…
• Datasources enhancement, Append structure, and user-exit
• Built customised datasources based on database tables or views (master data, Standard and customised Master-data extractors
• Reorganisation of the setup tables, Init /delta loading
• Talend Datasource based on external source system ( Oracle DB, Web database…)

SAP BIW Consultant

duration: 10 months
Ver. NetWeaver 7.0 BI, ECC5

BRIDGE Project: OTD - On time delivery indicators
The goal of these indicators is to measure ability of Schneider Plants and Distribution centers to deliver on time their customers.

SAP ERP Functional areas : Purchases, Sales, Deliveries, Shipments.

Participate in functional and technical analysis in SAP and BI for the implementation of the targeted functionality.
Participate in deliverables for OTD - On time delivery indicators
Analysis, modelling and BW development: infobjets, Datasources, DSO, cubes and multicubes, BEX and WEB queries and process chain.
Preparation of go-live plan for new BW dataflow
ETL:
• LO cockpit extractors used : 2LIS_02*, 2LIS_11*, 2LIS_12*,2LIS_08*.
• Datasources enhancement, Append structure, and user-exit
• Built customised datasources based on database tables or views (master data, Standard and customised Master-data extractors
• Reorganisation of the setup tables, Init /delta loading

Project ERP & BI for Customs of an African government:
Preparation phase

• Modules procurement, Finance et RH.
• Identification of main business processes
• Deliverables and project documentations
• Methodology for Business intelligence tools evaluation.

SAP ERP, SAP BI, BO and COGNOS : Demo Platform installation

• SAP ECC6/SAP Netweaver 7.0 and Business Objects XI 3.1 integration
• SAP ECC6/SAP Netweaver 7.0 and Cognos 8 integration
• Crystal reports, WEBI, Xcelsius, Cognos report studio.

Philip Morris International (PMI Lausanne, Switzerland)

Three (3) projects as SAP BW Consultant, Duration: 32 months

BI OPS - Global BI System: PPTT project (PMI Lausanne, Switzerland)
BW Consultant Ver. 7.0 BI, R/3 4.6, ECC5, ECC6

PPTT project:

Product Project Tracking Tool (Finished and semi-finished goods)
SAP ERP Functional areas: purchase, production, stock level and movements, BOM and MRP data
Oracle GIPS: Product management project (Product Project)
• Improve the obsolescence management process for the Product Project
• Increase the efficiency of the Product Project, Support proper product closure activities
Participate in functional and technical analysis, Participate in implementing deliverables
Modelling and BW development: infobjets, Datasources, DSO, infocubes and process chain
ETL:
• LO cockpit: Activation of the LO extractors (2LIS_03*, 2LIS_O2*, 2LIS_04_P_MATNR), Datasources enhancement, Append structure, and user-exit
• Built customised datasources based on SAP tables (master data, BOM / MRP data)
• Built Datasources based on Oracle database view (DB Connect)
• Reorganisation of the setup tables, Init /delta loading
• Connection (DB connect) between SAP BI7 and Oracle system (GIPS)

FGCT Project:

Finished Goods Component Tracking and Tracing Project
SAP ERP Functional areas: purchase order, production order, stock level and inventory movements
Regions deployed: Latin America, Asia Pacific, Eastern Europe, Western Europe
• World-wide Finished Goods Component tracking tool deployment (4 SAP ERP systems)
• Full forward and backward tracking (component <-> Finished Goods )
• Defected product or component identification, finding supplier's batch/stock/customers...

Participate in functional and technical analysis in SAP and BW, Participate in deliverables.
BW development: Datasources, DSO, cubes, BEX and WEB queries and process chain
Jump target from BW queries to SAP ERP Report ( tcode BMBC, me23n, ME2L)
ETL:
• LO cockpit: Activation of the LO extractors (2LIS_03*)
• Creation and enhancement of datasources, Append structure, user-exit, CTBW
• RFC connection between SAP BI7 and 4 SAP ERP systems


SAP P1 Project: Duration: 16 months

Stabilisation of Western Europ BW (PMI Lausanne, CH)
BW Consultant Ver. BW 3.5, R/3 ECC5
Analysis, modelling and BW development in finance, controlling, purchasing, production, inventory areas.
ETL:
• Activation and enhancement of the LO cockpit extractors (2LIS_02*/03/04*/ 05*)
• FICO Datasources: 0FI_GL*, 0FI_AP*, 0FI_AR*, OCO_PC_ACT*, 0CO_OM_CCA*
• Datasources based on SAP tables or views, Classification datasources (CTBW tcode)
• Reorganisation of the Setup tables, Init /delta loading

BW Consultant Ver. BW 3.5, R/3 4.6

Duration: 21 months
Core System Project: sales data, purchasing and inventory data

Sales dataflow: sales, deliveries, and invoicing providers and queries
Modifications of dataflows - purchases and stocks: cubes and bex queries
Analysis modelling and development BW:
Creation and modification of infobjets, ODS, cubes and multicubes, BEX and WEB reporting
ETL:
• LO cockpit: Activation of the LO extractors ( 2LIS_03*, 2LIS_O2*, _11*, _12*, 2LIS_13*)
• Customised Datasources, enhancement, Append structure and user-exit.
• Reorganisation of the Setup tables, Init /delta loading

BW Consultant

Ver. BW 3.0B, R/3 4.6 2 projects
RMD Project: Stock Flow and general ledger Duration: 4 months
• Reporting on raw materials purchasing carried out by Arcelor Purchasing
• Analysis, modelling and design of BW dataflow

Architecture Project: Flows MM FI CO Duration: 3 months
• Rebuild BW architecture (TBI project), integrate a new R/3 project (BOSS project)
• Analysis modelling and BW development: Master data, providers, queries and process chain

BW Consultant

Ver. BW 3.0B, R/3 4.6c Duration: 10 months

Training Landscape R/3 & BW-SEM Project Manager
Installation of the training systems for project TANGO :SAP purchase process, BW-SEM
• Installation of the training Landscape R/3, BW-SEM, Hardware sizing for BW/SEM
• Creation of procedure for creation/copy and refresh of the R/3 and BW-SEM systems
• Creation of training data and roles on R/3 and BW-SEM
• Creation and modification of BW flow for training needs
• Sytem monitoring, dump and error analysis during traning and data loading

BW Consultant

Ver. BW 2.1c (MM, SD, FI/CO, PP) Duration: 9 months

Responsible for exploitation and loading of the data; analysis and design BW
• Daily data load monitoring, dump analysis, User Support , Maintenance of BW dataflows
• Preparation of go-live plan for new BW dataflow
• Creation of a procedure for BW systems post refresh activities
• Reorganisation of the Setup tables, Init /delta loading