Finance

Analysis of Financial Information

Millersoft works with multi-national companies to create massive pivot tables for easy analysis of financial information (orders/invoices/debt/purchasing). We're experience at delivering powerful ad-hoc reporting from data hidden deep in systems like; Navision, Sage (100/MM/Line 50), Oracle Financials, SAP, Lawson M3/Movex and CargoWise. We can also blend that financial information will operational data contained in CRM and telephony systems.

We have also applied our skills to the analysis of change in Bloomberg Back Office Bond files and various Credit Agency feeds in XML and JSON format.

This short video represents the outcome of a proof of concept, showing Navision invoice line items visible within within the Pentaho Analyser.

International Financial Reporting Standards

Both statutory reporting and regulation for banks has become more complex and time consuming. Some of the recent challenges include; MIFID II, PI, IRFS9, AIFM, GDPR, PECR, DPA 2018 and E-PRIVACY.

Millersoft can help introduce modern data integration and reporting practices that help meet the new banking challenges using Pentaho Data Integration (PDI).

General Data Protection Regulation (GDPR) and Data Vaults

The EU General Data Protection Regulation (GDPR) can't be met with Information Technology alone; in must cases, current business processes will need overhauled.  Millersoft can however help with the following areas;

  • Privacy by design
  • Visibility and transparency
  • Management of Personal Information (PI)
  • Right to be forgotten
  • Customer reporting and historical record generation
  • Audit

The principles of Data Vault modelling can help with all of the above, get in touch to discuss how.