Successfully implemented projects

NETLINK has a sound technical and business knowledge in different business sectors like banking, telecom and industry. Here is a selection of successful projects over the past years:

Organization/IT:

  • Consulting, project management and quality assurance

  • IT strategy development, business analysis, proposal of target scenario, business plan modelling

  • BI management, data governance, vendor management, subsidiary coordination in corporate groups

Sales:

  • Group-wide sales reporting for industry group: data mart for analysis of inquiries, offers and or with plan/actual reporting on various levels (employee, department, subsidiary), cross selling

  • Banking pre-calculation for risk adjusted pricing: web-based tool for pre-calculation of bank and leasing product for client managers, with live calculation in the data warehouse.

Controlling and Finance:

  • Financial controlling cube: OLAP cubes based on Microsoft Analysis Services for financial planning and reporting, on single business level and aggregated (bank balance sheet, business sectors, profit centers, countries)

  • Monthly reporting of corporate group: replacement of manual excel packages of subsidiaries to holding by a DWH solution with data delivery interface and calculation of financial KPIs

  • Project reporting industry group: calculation of profit contribution scheme and KPIs of customer projects, comparison with sales pre-calculation

Risk Management:

  • Credit risk data mart with MS SQL: calculation of risk figures (e.g. expected and unexpected loss) on single business level, Risk cube (MS Analysis Services) and data preparation for simulations and analyses with SAS

  • replacement of Access tools for risk management by DWH solution¬†

Steering:

  • Integrated DWH for banking group which provides controlling view (SAP SEM Banking Profit Analyzer) and risk view (statutory reporting and risk management) on single business level

  • calculation of KPIs for dashboard application of corporate group

Production:

  • Productivity reporting: group wide combination of time and project activity recording of employees, calculation of KPIs, development of reports

  • Project manager reporting: combination of data from different ERP system modules (e.g. activities, inventory management, procurement) and manually gathered information (e.g. forecast data) for reporting of actual project costs and plan/actual analysis

Inventory Management:

  • Stock turnover analysis: analysis of stock transactions with acquisition and sales prices for annual inventory valuation

Human Resources:

  • HR data mart: OLAP cube for group HR department: upload of excel packages with raw data from subsidiaries, calculation of group-wide HR figures and reports