I consider myself a Software Engineer even if for the past 22 years my work was a combination between Business Intelligence/Data Analytics topics (Data Warehousing, Data Management, Report development), ERP implementations (Data Migration, Data Management, system administration & configuration, feature evaluation, release management) and other roles (IT Analyst, IT Services Manager, Consultant, Project Manager, IT Manager, etc.).
ERP support during & post implementation • integration & configuration Invoice capture (incl. Subscription Billing), SAF-T Norway, VAT reports, etc. • evaluation various features: Subscription Billing, Courses, Recruitment management, Task management, etc. • configuration various features Trade Agreements, Performance appraisal • management of Batch jobs, Users & permissions • configuration of new companies in Dynamics 365 F&O, HR • Data Management: metadata management, data quality assessment, reference & master data management (Products, Customers, Vendors, Trade Agreements, Standard Prices, etc.) • data migration of all master and transactional data in scope • master data harmonization & configuration validation • Project Management
Data Warehousing • 1x Data Lakehouse based on Azure Synapse & serverless SQL pool with Dynamics 365 F&O, HR, CRM and HubSpot data • 4x solutions for Data Migration • 2x solutions for Data Quality • 2x in-house developed data warehouses with SQL Server, SSIS/DTS Data migrations • 3x from Oracle e-Business Suite to Dynamics 365 F&O • 3x from Oracle e-Business Suite to Microsoft AX 2009 (incl. 1x HR module) • 1x from AX 2009 to AX 2009 (carve-out migration) • 2x from IFS-iV to Oracle e-Business Suite • 1x from AX 2009 for third-party solution
Software Development • Office/Desktop/Web App. incl. database development & modeling in SQL Server, Oracle, MS Access • COM+ components • 1x web-based BI solution (SQL Server, COM+, XML, T-SQL, ASP) • reports, dashboards, KPIs & metrics, data visualizations (Power BI, SSRS/paginated reports, Oracle Discoverer/Designer, T-SQL & PL/SQL) • Data processing tools incl. MS Office Add-ins, macros, etc. • 4x infrastructures for Data Migration & Quality Assessment with SQL Server, SSIS/DTS, T-SQL & PL/SQL
IT Operations • SQL Server 2000 to 2022 & Azure SQL Server administration incl. for Microsoft AX 2009, SharePoint, Data Warehouses • Support for various BI & planning tools (incl. data warehouses) • Support for Microsoft AX 2009 & Dynamics 365 F&O, HR • Support for AD/Azure-AD, Office 365, SharePoint 2010/Online • Support for the integration of ERP Systems with 3rd-party systems • Support the Business with data analysis: Finance, Procurement, Sales, Production, Inventory, HR, IT
Hobby areas • Systems Engineering • Knowledge Management • Mathematics & Science • Strategic Management • Software Engineering
The posts published in here come from my blogs, contain no code (see the SQL Reloaded or R Language for code-based posts) and most of them have a length of about 600 words (cca. 3 minutes read).