Architect and developer of Terminal Position Automation Datamart. This datamart provides a reporting environment for propane shipment and consumption for the entire midwest. Railcar and trucks automatically report shipments while customer contracts and lift is captured. Customer invoicing is transmitted along with contractual data from JD Edwards Accounting system. Datamart is 100% automated to provide business representatives with a clear propane inventory view and calculated future shipment and lift.
Development of ETL to pull vendor agriculture data into the enterprise data warehouse. SSIS packages developed to populate 8 dimension tables and 4 fact tables. ETL developed to allow clean data into the Data Warehouse while non-conforming data written to processing error log for manual intervention.
Development of an SSAS cube reflecting daily agriculture commodity position reporting. SSAS cube supports the business hierarchy, commodity, future and present positions via date dimension. SSIS packages populate the dimension and fact tables daily, along with cube processing each night.
Development of ETL in ODS to view refined fuels customer contractual commitment to actual lift and invoice for compliance purposes. Data pulled from JD Edwards and Microsoft CRM. Reporting provided in SSRS.
Development of SSIS ETL as well as SSRS reports with the credit processing group. Maintenance MVC coding for business and client credit card processing applications.
ETL support of the eDocs invoice application. This application sits on top of the corporate ODS instance and integrates data from JD Edwards and Microsoft CRM.