Senior Data Engineer
SSIS, SSRS, SSAS, T-SQL, Data Modeling, Data Warehousing, Data Architecture, API Integration, Tableau, ETL
Our Client, a multi-billion dollar Hospitality conglomerate, was seeking to create a custom data mart to integrate a newly implemented Learning Management System (LMS) with their Enterprise Data Warehouse (EDW). Our consultant successfully created the data model, created custom ETL processes utilizing SSIS, and integrated the web-based LMS to the company’s EDW via API Integration. In addition to being delivered on-time and on-budget, this project allowed the company to replace the LMS’ out-of-the box reporting capability with it’s own robust, custom reporting which allowed managers to track training progress in real-time- a new capability for the company.