JR Beltman

As Enterprise Information Management (EIM) Architect, I design and deliver Data Migration, Data Governance, Data Quality, Data Warehouse and Analytical solutions, adding business value and driving efficiency. Please see the entries below, post-fixed with '- via Soltius NZ', for more details on the projects I worked on whilst at Soltius NZ.

Complex project restructuring the Council's SAP FXRE data. • Analyse requirements to restructure the SAP FXRE data using SAP Data Services. • Design & Implement the solution. • Create reports on data quality and data reconciliation. Using SAP FXRE, SAP DS4.2 SP8

A New Zealand farmer-owned co-operative that helps its customers to farm more productively, profitably and sustainably. • Designed and implemented a solution enabling Ballance to report on non-SAP data through BW on HANA. • Identified data sources, data structures, data owners, 3rd party support companies and stakeholders of the solution. Used HANA studio, Data Services, BW on HANA, Information Steward, Analysis for Office, Design studio, Lumira and BO Reporting.

- Upgrade of SAP BusinessObjects Business Intelligence Platform to BIP 4.2 SP3 patch 2 for evaluation purposes, enabling the organisation to make an informed decision on moving all their environments to this version.

• Implemented enhancements to Webi reports based on Bex queries. • Upgraded Business Objects Platform to 4.2 SP3 patch 2. • Extensively tested the upgraded Business Objects Platform, including client applications. • Provided support on Webi development issues. Used BIP4.2 SP3, Webi web client, Webi Rich client 4.2 SP3, IDT 4.2 SP3, Design Studio 1.6 SP3, Analysis for Office 2.3, Live Office 4.2 SP3, Dashboards 4.1 SP1, BW, Bex Analyzer and Query Builder 7.X SP5.

• Enabled thorough analysis of the vast amounts of data by configuring connections between HANA (ECC & CRM), Data Services (Designer & Workbench) and Information Steward. • Designed the HANA user and role for data analysis. • Created Attribute views and Calculation views with analytical privileges for use in Data Services and Information Steward. Used HANA SP9, DS 4.2 SP7 and Information Steward 4.2 SP7.

A telecommunications provider operating in New Zealand, offers prepaid and pay-monthly monthly mobile services as well as fixed-line phone and broadband services. • Enabled auditing by designing a 'hot pluggable' solution that creates, compares and validates Hash values between source and target data structures. • Designed a solution to automatically execute business rules, store the results and enable simple reporting. Used SAP Data Services on Linux with Netezza and Oracle databases.

A designer & manufacturer of medical devices in over 120 countries. • Architected and implemented the integration of 16 legacy Baan systems with SAP ECC & SAP APO. • Exposed data by HANA views & Universes. • Gathered reporting requirements, and created reports in Crystal, Webi and Analysis for Office. • Provided training on Data Services and HANA modeller. Used HANA Studio, Webi, Crystal, Information Design Tool, Analysis for Office, Data Services, Information Steward, BW, SAP APO, SAP ECC, SAP WMS

• Provided support & training to the in-house data warehouse team for the transition from BODS 11.6 to SAP DS 4.2.

• Architected, developed and implemented a solution to migrate the Master Data of 6 ERP systems, including JDE OneWorld and SAP ECC, to a centralized SAP MDG system. • Designed mechanism to verify the data migration results and handle deltas. • Created various reports to provide insight into the migration, the data quality and the deltas. Used SAP Business Objects Data Services 4.1 (including Data Quality & DQM), SAP ECC, JDE OneWorld, SAP MDG and Information Steward.

• Developed & trouble shooting on the Shoof Data Warehouse, based on SAP ECC data.

• Created data validation reports for the test team of a significant project spanning over 25+ data sources. • Facilitated data integration of various systems including SAP BW.

• Developed the H&S data warehouse with BODS & BW. • Sourced data from various systems for financial reporting. • Resolved issues with the BODS to Salesforce interface.

• Resolved serious issues in the migration logic just before the go-live of a major project

As BI Consultant, I designed and delivered analytical reporting and data transformation/migration solutions. Please see the entries below, post-fixed with '- via Ensior BV, for more details on the projects I worked on whilst at Ensior BV.

• Wrote reports for various departments using Crystal Reports. • Maintained and extended the data warehouse

IT Helpdesk Data Warehouse & reporting • Designed and implemented an IT helpdesk data warehouse. • Developed Universes over the DWH for Webi reporting.

• Worked as part of the data migration team, developing ETL jobs to move from legacy systems to SAP.