Wilhelm Schulze-Messing Email & Phone Number

Australia

Brisbane, Queensland, Australia

Brisbane, Queensland, Australia

• Enhance current report systems and ETL to cater for multiple warehouses in different countries (AU, CA). Had to update change all SQL, SSIS, Power BI and SSRS reports to cater for this change, as the company had for decades only had the one, and a lot of code assumptions was made upon that.• Realign two code basis which was forked years ago to implement a smaller version of the main system. Over the years the code base drifted, and my task was to get them back as one, where one code base was used to deploy both systems.• Improve deployment, build process by optimizing the build YML files to reduce time building, as well as only building sections that changed on every Pull Request.• Migrate SQL Server Database (Datawarehouse) to a Hyperscale SQL Server Database. Here I used Azure Data Factory (ADF) to copy over data. It could handle incremental and full loads. This migration required minimal down time. We did a lot of tests and had to make quite a few enhancements to existing SQL to work performantly on new database. I also had to make sure, that all CI/CD still worked with the change of a few parameters. This involved some change to YML pipelines as well as Octopus Deployments with quite a bit of PowerShell changes and enhancements. • Migrate existing SSIS processes to ADF. I did this with no down time, and very few issues. I created some reusable ADF pipelines, which helped converting the SSIS processes into a smaller set of more manageable ADF processes.• Created an extraction process for Michael Hills planning systems using ADF, which eventually exports it data to files which is shipped to an Amazon eco system• Created and ADF/PowerShell/Runbook/Webhook process to update the Tabular Cube on an incremental basis or full when required. It also created the partitions needed as per config in a control table. This process was enlisted to make the processing faster, so we did not need to process the whole cube every day.

Brisbane, Queensland, Australia

• A switch over was done from custom inhouse system to Microsoft D365. All existing feeds had to be switched over by either retrofitting the new feed into the existing structures or creating new structures and changing the existing reports.• Design, develop and alter existing SSIS ETL processes into the Data Warehouse. • Create new SSIS ETL processes where new data feeds became available.• SSRS Report had to changed to any structure / logical changes made due to the migration to D365• MS Power BI reports also had to be changed, or new ones written for all the new feeds. • The integration method to D365 was through their BYOD. Here I also applied some of my programming skills to enhance and change the process using C# Azure Functions to copy the data from their BYOD structure to the ODS system.• Changed and fixed the SSAS (SQL Server Analysis Service) Multi-Dimensional Cube where it was affected by the migration.

Brisbane, Queensland, Australia

Cape Town Area, South Africa

Developed/Designed a system called INSIGHT for use in the telco/or other environment, for doing everything from Data-warehousing to Billing, in a more dynamic way. Doing away with custom development, but rather use config to drive the system. All software designed for high performance computing, to keep a near real time ODS up to date with terabytes of data. Used JAVA, and designed system to be scalable and extendible.Developed/Designed front end using Java/JavaScript/GWT for accessing the INSIGHT system, which is geared for speed, and works like a thick client but via a browser with no added plugins.Also involved in solutions and implementation for Revenue Assurance, data warehousing and fraud management.

Johannesburg Area, South Africa

Day to day operations and support for current Billing Application and data warehouse software.Traveled to various African country for new roll outs, and support.Developed a telco billing software using JAVA. Developed/Designed monitoring software using JavaDeveloped/Designed a reporting tool integrating BIRT.Integrate and support rating engine into a new billing system. Using C++Developed various decoders. Using C / C++ / Java, depending on the system.Developed interface to various vendors using, CORBA/WEB ServicesDeveloped data warehouse software using C++, Pro*C and PL/SQL.Designed Invoice, Statement and Itemized bill layouts using Version One.

Johannesburg Area, South Africa

Developed Version 1 Bill layouts for Telecoms company.Developed interface between Sage and Life Tree system.Developed migration tool for Sage application.Was contracted out to develop some software for Vas-X, which became permanent.

Newcastle Area, South Africa

Designed and developed a system for tracking steel pellets, interfacing into PLC’s.Designed and developed a system for capturing data from PLC’s like Fanuc, for the Steel Rolling plant. This system integrated with the PLC’s, gathering data about speeds, heat thickness and quality to name a few. Using VB and OracleDeveloped and designed from database to front end a Stock Application for capturing data about the incoming/used raw products for making steel. Using Oracle as the database and Centura as the front end.Train fellow colleagues on the use of object orientation.Support, existing system written in Centura/SQR/PLSQL for plant applications.Wrote reports in SQR (Brio) for identifying trends in the steel making process. From high level reports to very low level detailed reports.Support, existing systems supplied by 3rd party for Steel making models running on VMS/Windows/Oracle. Enhance/develop code in C++ for communication in different sections of the plant, for sending data about steel quality, analysis, estimated time of arrival at next process and destination of the steel.Wrote comms to a Steel Analysis machine to extract to quality of the steel using VBDeveloped Java library used by the Web for capturing data about sales and orders.