A national leader in the dynamic North American energy supply, logistics and services enterprise. From petroleum products to CNG, LNG, specialty in chemicals and renewable fuels, their expertise spans all channels of transportation fuel and energy services.
- The Client had 2 complex Supply Chain System.
- System 1 (Legacy) : LTL and FTL Orders
- System 2 : DEF Orders
- The Client required a single Report Portal to see all kind of Orders.
JKT has provided a SSIS and SSRS Solution through this BI Merge Project.
- SSIS Solution to migrate their LTL & FTL transactional data and Master Data
- SSRS Solution to migrate their Legacy SSRS Report and create new SSRS Report and Dashboards.
- Implement ANA and DLP Logic in our Reporting Solution.
- Power BI Solution to create User Interactive Dashboards.
- Created Decision Support System through DW Project based on migrated data and existing Entinuum Data.
- The Client uses new BI Report Portal to access all kind of report show DEF, LTL and FTL data.
- BI Merge Reports will use ANA Module to handle Report Permission.
- BI Merge Reports will use Data Level Permission.
- Due to that It was too easy to create Decision Support System (Data warehouse and AS Solution) for our Client.
- Data mining solution based on our DW as future enhancements.