Projects
Server Consolidation
Completed a 40-to-2 server consolidation initiative, avoiding a costly A/C upgrade, drastically improving Disaster Recovery capabilities, IT flexibility & responsiveness, while simultaneously lowering electricity costs.
[ VMware ESXi, VMware vSphere, Lenovo System x, Lenovo ThinkSystem, Veeam Backup & Replication ]
Business Intelligence (BI) Solution
Designed & implemented a Business Intelligence(BI) solution, providing best in class online data analytics tools using QlikView visualizations. Data was sourced from Sage ERP, Körber Warehouse Management System (WMS), Körber Transportation Management System (TMS), and Logistyx / e2open Ship-IT. Included API integrations with Canada Post, Canpar, Purolator, ATS, and Sameday.
[ QlikView, SQL Server, T-SQL, SSIS, .NET, XML, JSON, CSV ]
Enterprise Software Upgrade
Assumed the lead SQL Server DBA role for two major 3PL enterprise software upgrades: Accellos / HighJump / Körber Warehouse Management System (WMS), and Logistyx / e2open Ship-IT Multi-Carrier Parcel Shipping Software.
[ SQL Server, T-SQL, SSIS, ASP.NET ]
Data Processing Engine
Led the DES project, a next generation data processing engine to modernize data integration with clients.
[ ASP.NET Core, SQL Server, T-SQL, SAP XML, SFTP, EDI, Sage ERP ]
Data Center, Office & Warehouse Relocation
Handled all IT matters for multiple brand new 100,000++ sq. ft. facilities. Executed a seamless Data Center, office & warehouse relocation. Implemented a FOB-based access control system servicing 150 staff, and 20 IP-based, colour HD security cameras.
[ Georgetown relocation to new Milton facility, + additional Milton facility, + new Guelph facility, + London relocation ]
