Migration specialist, Tailor Made Solution, UX
The strength of codeblue lies in the passion shared by the company’s founders and in the many years of experience that each of them has brought into this venture. We design and adapt our IT solutions to individual customer needs so that the final product provided by us would be a value that will help in creating a business in a modern and agile way.
We start our work with a detailed business, functional, process and system analysis. We design solutions based on the latest trends and experience gained in many industry companies, and thus in hundreds of implemented projects.
We precede the delivery of solution by building prototypes to gain confidence that the selected concept will meet the customer’s expectations and will not disappoint him in operation.
We have grown up on many design methodologies and looking at the solutions we provide, we follow the main idea: ‘makeITeasy’, so we create IT solutions in the easiest way to implement.
BNP Paribas, Cshark, Future Processing
"Give them some trust because they’re the experts."
The team at codeblue assisted with a data migration during a bank merger. They transferred all of the historical data, creating ETL tools to make it happen. They also analyzed key pieces of the data.
"Give them some trust because they’re the experts."
Jan 7, 2021
The team at codeblue is now a trusted development partner for the bank. Their team transferred millions of records within a few days, creating an efficient solution. They're communicative, transparent, and hardworking.
A Clutch analyst personally interviewed this client over the phone. Below is an edited transcript.
Introduce your business and what you do there.
For the last five years, I’ve been the senior project manager at BNP Paribas Polska, one of Poland's top banks. I’m responsible for mobile banking and providing historical data for digital systems like mobile banking or internet banking.
What challenge were you trying to address with codeblue?
We needed additional help with data migration.
What was the scope of their involvement?
There were two parts of our cooperation.
We started our cooperation in 2019, a specific time for BNP Paribas, because it was the year we had an IT merger with Raiffeisen Bank Polska. BNP Paribas purchased Raiffeisen, and we were focusing on the operational merger. I was given the responsibility for migrating all the historical data from Raiffeisen bank to PNP Paribas.
Our digital banking, both mobile and internet, served this historical transaction data to Raiffeisen customers.
We felt that we needed some additional support in this area since we had an external vendor already. Once I was given this responsibility, I felt that the vendor didn’t have enough knowledge and the speed that we needed because there was a strict deadline to migrate all the data and have the operational merger by the end of November 2019.
We focused on analyzing and creating the ETL tools that helped us migrate all the data from Raiffeisen to BNP.
In BNP Paribas, we have MSSQL databases, and Raiffeisen was operating on Oracle databases, so we needed a company that had the skills, knowledge, and experience in those two technologies.
The team at codeblue started with detailed analysis and creating all the data and created a tool that would automatically, in an efficient way, extract data from the Oracle database and transform it into the format and apply some additional business rules that we could migrate this data to MSSQL. We started with the analysis, and then we moved onto creating this ETL tool that was part of this migration.
When the ETL was ready, we went through the test cycle, and we are tweaking the solution. We are sure that once the migration day comes, we will be fully ready from the business logic point of view and the performance point of view because the data flood was quite huge; it was one and a half billion records.
What is the team composition?
We started with around six people. It was a code team that included an architect, a system analyst, a business analyst, two developers, and two testers.
At the moment, we have our own testers. We’re only using about three or four of their analysts and developers, depending on maintenance.
How did you come to work with codeblue?
It was through a reference. Since we weren’t happy with our current vendor, we were looking for skilled database experts. We found that codeblue had key knowledge in Oracle and MSSQL.
After we started talking to them, we quickly realized that they had great skills and a great attitude. They were a perfect fit for us to give them a try and for them to support us in our migration efforts.
How much have you invested with them?
It was roughly $500,000.
What is the status of this engagement?
We onboarded codeblue at the beginning of July 2019. They came on permanently in January 2020, becoming fully responsible for developing and maintaining the transaction history solution for the digital channels.
We’re still cooperating with them today.
What evidence can you share that demonstrates the impact of the engagement?
With the ETL and migration engine, we are looking at the efficiency and how many records they were able to migrate as well as how many errors. We were impressed because, in one day, they were able to migrate one and a half million of the records without a single error. That was the main success metric in the first half-year when we were working on the migration.
We had to ensure that when the bank opened after the weekend, all the data was there and is of proper quality, and users could start logging into the system, and the data would be available there.
The bank, as well as myself, as the person responsible for this migration stream, were very pleased with the performance of codeblue so we proposed a permanent contract to them within the bank to become one of our vendors responsible for further development, our historical database, and solution, and basically further development and maintenance of that solution. We are cooperating with codeblue in this database solution that supports all the bank's electronic and digital channels.
Later on, when they became our vendor, we simply measured performance based on their sprints and the percentage of user stories delivered since we switched to an agile approach. They’re able to deliver a majority of the time. There are times that there may be a little bit more and times where there might be a little bit less, but almost every sprint delivery is 100%. Those are the main metrics I am using at the moment when we are in the space of development and maintenance.
How did codeblue perform from a project management standpoint?
I am mainly in contact with the analysts since the person responsible for the analysts is also the manager of the developers. Of course, before COVID-19, we were working together in the office, and I had daily contact with the whole team. Sometimes developers are specific, but the developers from codeblue are excellent communicators; even when I didn’t understand some specific terms or approach, they were always helpful, explaining them to me.
On a daily basis, I have a proxy manager on the codeblue side, and I don’t have any issues with communicating on a daily basis and planning work and getting some feedback. They’re great compared to others I’ve worked with. The codeblue team are great communicators and helpful people.
What did you find most impressive about them?
We had a huge success with the migration, which triggered us to bring them on permanently. We knew how challenging migrations were in the past. We had a lot of errors and delays, but here, we were very impressed with the ETL solution. There were no errors in extracting, transforming, and loading the data into the BNP system. It was a very hard task, and they fulfilled it perfectly.
Are there any areas they could improve?
I would like to have one or two more developers to speed up the process. We’re talking about it with them, but they’re currently running other projects for other customers, as far as I know. I’m hoping that when they’re finished, we can have more resources because the transaction migration database is not the only one.
We are taking care of our digital banking and other databases, so we need the extra support. Hopefully, in 2021, that will happen.
Do you have any advice for potential customers?
Banking is a little bit specific, but I think it might apply to other companies to give them some independence in choosing the best solution.
Give them some trust because they’re the experts. Some customers might already have a vision in mind, but let them review it and let them challenge it. They might come back to you with even better solutions.
Have some trust in their skills as I think it would be a good start at the beginning for other companies to get the most out of them.