Financial Reporting and BI solution





Objective

Design and End to End solution to digitalize the recording and processing of the monthly sales & cost numbers of different entites. Process and reconcile the numbers againt accounting numbers and send over to digital dashboard for management reporting and decision making.

Client

Sigvaris Management AG - global market leader in the manufracturing of medical compression garments with offices across the world.

Features

  • Workflow based system allowing Controller to manage the product and Entity hierachy for business Intelligence setup.
  • Process Data to SQL DWH
  • Digital Dashboard and advance reporting using PowerBI
  • Reconciliation of Numbers with Accounting system
  • Respopnsive Design, targeted at mobile devices including iPhone, iPad and safari web Browser

Impact

Reduced the monthly process time from 1.5 weeks to less than 2 hours.

Technologies Used

  • ASP.NET
  • MVC
  • C#
  • AngularJS
  • Bootstrap
  • Azure SQL & DWH
  • PowerBI