1998: Designed, purchased, configured and operated first MS-Exchange and Firewall environment for all Liebherr US operations.
1999: Baan implementation Liebherr America: Coordinated all aspects of the ERP migration from legacy system. Wrote custom code to transform legacy item master data for several US Liebherr companies (5), and Liebherr Canada from legacy system into new ERP system, some of which required fuzzy logic and advanced statistical weighing treatment. Selected key users and traveled to train the key users in the areas of distribution, manufacturing and finance.
2001: Designed from the ground up, coded, implemented and hosted E-Commerce Website, with EDI interface to communicate with the local ERP system (Baan) to sell spare parts for earth moving equipment. Implemented custom local ERP interfaces to facilitate solution to print picking tickets instantly after orders received, including stock management and reordering parts from Europe- the solution also creates supply chain orders for parts not in the local warehouse. Developed additional interfaces to UPS and FedEx and coded workflows to channel the resulting tracking numbers back into the local ERP system (Baan), and display-link the data to the customer on the web at the same time. The site is still in operation and has a proven track record for 15 years now. The site processed about 270,000 orders from affiliated dealers as of 2016, resulting in several hundred millions of turnover in spare parts for Liebherr.
2002: Designed and implemented BI data warehouse from scratch, using C#, Informix and SQL Server technologies. At the time, SQL Server Integration Services (called DTS back then) was too immature and not ready for the task yet. The process involved tapping into the internal tables of the ERP system to discover the table schemes and reflectively recreate the same structures in SQL server tables (+500 tables x multiple companies), including any foreign constraints and indexes. Implemented as a windows service, the transformation of the internal field codes to human readable column names was realized at the same time. The reporting solution using SQL Server reporting services is still heavily in use to date and has provided employees across several companies to get the data they need on their on, using MS-Access via ODBC or Excel/PowerPivot. Other solutions inside the data warehouse included custom OLAP cubes and time series aggregations at the statistical level to provide easier ways to analyze the data coming from the ERP system for key users.
2012: Designed, purchased servers, built and installed highly available Hyper-V Cluster, using redundant NetApp FAS series SAN for guest OS storage. Selected and installed other NetApp SAN's in remote locations to replicate back to local data center using NetApp SnapVault replication technologies. Including a recent upgrade, the cluster has now six nodes, amounting to a total hosting capability of 576 GB in RAM, with failover.
2013: Added virtualized RDS farm to the Hyper-V Cluster. Hosting 20+ applications across four session hosts.