Saving an ERP from month-end reporting.

Role: BI Developer
Corporate IT
PGG Wrightson.

Achievements:

  • Design and Development of an operational data store (ODS) and Power BI data model to support operational reporting and dashboards from JD Edwards EnterpriseOne ERP (JDE E1).

Responsibilities:

  • SQL Database design and development (tables, views, functions, and stored procedures)
  • ETL development (Wherescape Red, Microsoft Dynamics 365)
  • Tabular model design and development (SSAS, Power BI)
  • Operational reporting from JD Edwards EnterpriseOne ERP for Accounting, Payables, Receivables, Procurement, Distribution Centres (SSRS, Power BI)
  • Human resources reporting and analytics from Payglobal (SSRS)

Technology:

  • JD Edwards ERP
  • Microsoft SQL Server database engine (MS SQL), Integration Services (SSIS), Analysis Services (SSAS), Report Server and Power BI Service (Power BI).

Outcomes:

  • Achieved near real-time performance to supply fresh and accurate data within 15 minutes of a new record being created.

2017

Updated: