I have 12 years of SAP Business Intelligence, Business Warehouses, Business Objects and HANA professional experience gained from many industry sectors including Retail, Mining and Metallurgy, Oil and Gas, Telecommunications, Energy and Transport. I have completed full-cycle implementations, rollouts, upgrades and several support & enhancement assignments.
☑️ Design and development of various data models and ETL in CRM 360 (BW 7.4 on HANA) and BW 7.5 on HANA to support complex CRM, Retail Sales and Inventory Management business requirements such as: business partners, stores and products master data extraction, calculation and integration between internal and external systems, customer segmentation, sales statistics calculation and reporting, campaign effectiveness calculation and reporting etc
☑️ Integration between various internal and external SAP and non-SAP systems via SAPI, files, Open hub, APD
☑️ Update of CRM business partner marketing attributes via APD: nearest and home store, first transaction date, emailable status, portal and email engagement groups, chosen currency loyalty group etc. Integration with CRM High-Volume segmentation
☑️ Enhancement of POSDM sales transaction data ETL
☑️ Multiple extractors created and enhanced for ECC and CRM master and transactional data: product organic and gluten free flags, snapshot of CRM offers and target groups etc
☑️ Integration with external systems of Foodstuffs North Island, Loyalty New Zealand: extraction of POS transactions and stores master data from file data sources, usage of Open hub to generate .json and .csv files for product master data
☑️ Extensive usage of HANA views, stored procedures and user-defined functions in ETL and reporting: composite and virtual providers, open ODS views, virtual master data. Nearest store, distance to nearest and home store, customer segmentation model using k-means algorithm, generic households etc were implemented via HANA views.
☑️ Parameterization, performance tuning, enhancement and fixes in various parts of existing ETL and reporting
☑️ Multiple reports and dashboards were created and enhanced using BEx Query Designer, Web Intellingence and Design Studio: Clubcards matching Airpoints, Sales Tree Metrics per Store, Product Analysis dashboard, Retail Sales Dashboard, Retail Daily Inventory on Hand Report, Daily Article Sales & GP Report, Out of Stock Report, Vendor Review etc.
☑️ Multiple report publications were created using BEx Broadcaster and BO publications including dynamic recipients via email and exception broadcasting e.g. emailing of incorrect product attribute values
☑️ Reporting support for power users regarding BEx queries, Web Intellingence reports and Design Studio dashboards, fixes and design improvements
☑️ Design Studio training course delivery for power users
☑️ Multiple HANA views created to support article costing analysis: sales/stock by article/site/period, sales/stock by site/period
☑️ Design solution for average daily stock calculation in HANA
☑️ Manual input forms created in Analysis for Excel for allocations at site/article /GL account /period level
☑️ Reports created in Analysis for Excel to provide comparison of allocated/not allocated GL figures by articles/ sites /GL accounts
☑️ GP Article Dashboard prototype created in Lumira Designer
☑️ Various ETL jobs and transformations created in PDI to support budgeting, forecasting and reporting in Adaptive Insights:
☑️ Export of dimensions, accounts, time and versions from Adaptive Insights into text files using provided API’s.
☑️ Automatic dimensions and transactions data synchronization between Oracle Cloud system and Adaptive Insights using provided APIs, text file generation for manual upload into Adaptive Insights
☑️ Plan data integration process created for file data sources
☑️ Data sources and loaders created in Adaptive Insights
☑️ Build complex SQL views to support financial reporting in Power BI
☑️ Data sources replacement in Power BI financial data model including M query and DAX changes
☑️ Various performance improvements, simplification and parametrization of the data model
☑️ Business users support
☑️ Business data warehouse modeling and development, architecture decision-making
☑️ Building reports for SAP POS DM, SAP ERP and NTS WinCash data comparison
☑️ Building SAP SRM data based reports
☑️ SAP POS DM, SRM transaction and master data extraction using business content datasources, BADI development
☑️ Building universes in Information Design Tool
☑️ Developing and publishing Web Intelligence reports
☑️ Modeling HANA information views
☑️ Designing BEx queries
☑️ End-user support