nearshore@inetum.com
Nearshore Client Stories FinTech Business Analysis and Implementation of a New Data Warehouse

FinTech

Business Analysis and Implementation of a New Data Warehouse

Country: Ireland
Year: 2015 - 2016
Project scope: Multilevel Data Warehouse
Team size: 5 members
Technologies: IBM DB2, Pentaho Data Integration
Project company name: Squared Financial Services Ltd

The analysis of the existing data structures, business processes and reporting needs was only the first stage of the project. Subsequently, the new Data Warehouse was built, which laid the foundations for the Business Intelligence class system. It was fed with data from one transactional platform.

Technical analysis and design of DW models

The project began with an analysis of existing data structures, business processes and the company’s reporting needs. The job was to transform complex business requirements into a clear and coherent technical solution.

The documentation which came out of the analysis contained a business model, the design of the required reports, the design of the data warehouse in the form of a multidimensional data model and basic guidelines for the implementation of the complete analytical solution. The aim of the design of the data warehouse was to ensure that fundamentally the Business Intelligence system is able to standardize data from various sources and to collect it almost in real time. Users should get fast, flexible and easy access to consolidated information.

“The JCommerce PM managed the project very proactively, providing constant updates and addressing potential issues before they had any impact on the project as a whole. Exceptional communication, a deep focus on goals and objectives as well as excellent time management kept the project on track, at all times, and resulted in the timely delivery of all agreed milestones.”

Piotr Pryzmont, Head of IT Squared Financial Services

Implementation and deployment of DW and ETL systems

The second phase of the project was to build the Data Warehouse, designed in the previous analysis stage, and to load it with data from one source platform. Bearing in mind that in future the Data Warehouse will collect information from many different transaction platforms, the necessary mapping tables and ETL processes were designed and implemented. This facilitated an easy increase of the number of source systems of the Data Warehouse in the successive stages of the project.

The right technology

JCommerce’s engineers had to quickly adapt to use different technologies on which Squared operations are based, but were also able to offer alternative solutions if and when needed. The technical teams displayed a high level of technical knowledge and skills which were necessary to implement a solution matching the performance requirements set by Squared at the beginning of the project.

This nearly two-year-long experience proved that JCommerce is a very professional company with the ability to employ the right mix of technical and project management skills, regardless of the situation.”

Piotr Pryzmont, Head of IT Squared Financial Services

About the client

Squared Financial is a full-service broker regulated by the Central Bank of Ireland which offers an ECN-style trading model across a broad mix of Bank and non-Bank liquidity pools. Squared Financial specializes in Foreign Exchange (including CFDs) and related products. Their clients benefit from the best price and highest quality of execution for their personal trading style and strategy.

Country: Ireland
Year: 2015 - 2016
Project scope: Multilevel Data Warehouse
Team size: 5 members
Technologies: IBM DB2, Pentaho Data Integration
Project company name: Squared Financial Services Ltd

We’re here to help you

Work with the best team in Europe

Team delivery Project delivery

Exclusive Content Awaits!

Dive deep into our special resources and insights. Subscribe to our newsletter now and stay ahead of the curve.

Information on the processing of personal data

Exclusive Content Awaits!

Dive deep into our special resources and insights. Subscribe to our newsletter now and stay ahead of the curve.

Information on the processing of personal data

Subscribe to our newsletter to unlock this file

Dive deep into our special resources and insights. Subscribe now and stay ahead of the curve – Exclusive Content Awaits

Information on the processing of personal data

Almost There!

We’ve sent a verification email to your address. Please click on the confirmation link inside to enjoy our latest updates.

If there is no message in your inbox within 5 minutes then also check your *spam* folder.

Already Part of the Crew!

Looks like you’re already subscribed to our newsletter. Stay tuned for the latest updates!

Oops, Something Went Wrong!

We encountered an unexpected error while processing your request. Please try again later or contact our support team for assistance.

    Get notified about new articles

    Be a part of something more than just newsletter

    I hereby agree that Inetum Polska Sp. z o.o. shall process my personal data (hereinafter ‘personal data’), such as: my full name, e-mail address, telephone number and Skype ID/name for commercial purposes.

    I hereby agree that Inetum Polska Sp. z o.o. shall process my personal data (hereinafter ‘personal data’), such as: my full name, e-mail address and telephone number for marketing purposes.

    Read more

    Just one click away!

    We've sent you an email containing a confirmation link. Please open your inbox and finalize your subscription there to receive your e-book copy.

    Note: If you don't see that email in your inbox shortly, check your spam folder.