Dipl.-Ing. Ido Strum

• BW – Modeling & reporting in the areas of Utilities, sales+ simulation. • BW- Modeling and reporting in FICA Areas + Dunning. • Project for Placards of Tel Aviv Municipality – Including 16 different data sources some generic. • Working with BO - Data Service.

Design and Architecture with implementation of MM Inventory and purchasing with nonstandard enhancements as storage location. BW authorization, BO authorization- security access, CMC, Privileges,BO – WEBI, Design Studio reports. SAP ME ,BO design with Information design tool, enhancements with custom fields from SAP ME and SAP ERP. PP- Production planning all standard model and reporting with enhancements and calculation of queue quantity and Classification as example.

Design and Architecture with data service and BW for bank analyzer (AFI) Infrastructures using frequently start & end routine ETL Method for BT's and FT's SDL for all different templates as derivatives, securities etc ,for the RDL in bank analyzer,Export data for external tools, Working with Sap HANA STUDIO attribute, analytic and calculation views and from BW transient, virtual, composite providers,Hana modeling and reports with bank analyzer. Modeling&reporting in the area of CO PS HR SRM and planning IP

Design and Architecture with implementation of COPA Model in BW 7.3 using new functionalities. The Model consolidates SAP and Non Sap data, reporting created with drill through to Invoices. Design and implement CRM model (Opportunities) with planning model (BPS). Created crm - bw models - snapshot scenarios covering history in BW.

Requirements from CFO and transferred them into SAP BI solution, contribution model which enabled analysis of profitability by materials customers and countries, Built weighted average cumulative contribution reports, Created a model&report for operational daily production quantities. Built consolidated budget report between two different BW'S System BAZAN&CAOL, Analyzed business requirements in the area of CO actual, budget and forecast, and built reports for actual/Budget/forecast comparison.

BW implementation according to ASAP methodology Modeled Asset Accounting, FI-GL, GL AR AP Mechanism, HR, Inventory Management (MM), 0MMPUR (Purchasing). Project included gathering business requirements from key financial users and making comparisons with AS400 system, bringing the same data into BW. The purpose of the project was to define all costs by vendors with the same logic as in the AS400 applied. I designed the architecture (extractors, enhancements, DSO'S., cubes and multi).

Working in the area of BI IP Concerning Material usage planning. Modeling with Inventory management. Responsible for the data in BW for BCS workbench.

Project (FI & EC-CS) : Reconciliation between Consolidation system and FI System: I worked directly with the ZIM accountant. Implemented GL, AR, AP Info cubes with ODS'S (delta) Mechanism and FIGL. Implemented consolidation Info cube (EC-CS) Created authorization concept and authorization objects, maintaining authorization – roles, profiles for users.

I analyzed the business processes of Real Estate in R3 (tables, fields) and the requirements of the users, providing solutions based on SAP – BW (3.5) tools. Enhanced the B.C extractor (0RE2) to meet the requirements. Built the central report of RE. I established the statistics cubes and reports.

Analyzed and mapped clients’ business requirements, such as reports in XL, Macros and V.B.A. Built queries and workbooks in BW- Bex and WAD for users Checked the data in all stages r3,rsa3,psa,rules,data target, bex

Designed universes and SQL queries and reports in Business-Object Built Excel worksheets construction, including pivot tables, macros- V.B.A for economists and accountants. Budgeted construction and submission of control reports to the C.F.O.,

Analyzed financial reports Tested business plan and auditing, Created reports for the Ministry of Finance and the Ministry of Absorption. Created statistic market survey of the Israeli dairy sector.