BI consulting & development services, DWH migration

Client
Leader in the Consumer Credit Market
Country
Romania
Industry
Insurance
Cooperation Model
Time and Materials

Business Need

Our client needed us to analyze and optimize its current systems and reports, as well as create new BI reports by extracting, processing, and analyzing data from multiple sources supporting the decision-making process regarding General Analysis Specifications. The client needed various types of reports, some required by the public authorities others covering internal projects.

Solution

In order to meet clients’ requirements, we provided maintenance services and optimized the code of existing reports. One of the projects included migrating the DataWarehouse from SSAS2K5 / SQLVCLK5 / SQL2K12 / SSAS2KS to SSAS2016 and providing dashboard reports on the new SQL 2016 infrastructure. We were also responsible for the research and implementation of new technologies, standards, and trends in Business Intelligence.

Key Benefits

We helped keeping up-to-date the infrastructure standards required by the BNP Paribas Group in order to improve operations in Central and Eastern European markets;

We seamlessly ensured ease of delivery for all reports required by ANAF (National Agency for Fiscal Administration);

We helped optimize current reports by migrating packages and creating new reports on the SQL 2016 infrastructure.

Technologies

Business Intelligence Data Integration Data Warehouse Reporting Services SQL Server 2012 / 2016 SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS) Visual Basic / C#

Team/Duration

1 FTE
1 YEAR