Case Study - Building Data Hub for a Financial Services Client

kisspng-goal-bullseye-computer-icons-business-mission-stat-goal-icon-5b4c3eb718cad7.9102785415317234471016

Client and Business Goals

The client is a Colorado based financial services company. Client wanted to migrate their 2 existing portals.For one portal, existing database migration is from Mongo DB to SQL Server 2017. They also want to add some new functionalities in the application.

This involves redesign of SQL Server data model from existing Mongo DB data model, by adding relationships among tables.

For other portal, existing database migration is from Oracle RightNow to SQL Server 2017 & application migration is from PHP to AngularJS & NodeJS. They also want to add some new functionalities in the application.

This involves creation of SQL Server data model from existing Oracle RightNow (ORN) data model, by aligning relationships among tables in sync with ORN.

Their is a need to redesign GUI screens and change complete look & feel of the application and also support multiple browsers over multiple devices like iPhone, iPad, Android phones etc.

Solution Description

For the first portal migration, we first did data model change and translated all MongoDB calls in the application (backend Node.js code) and replaced all such calls with SQL Server stored procedure calls and migrated existing data into Production.

We created Selenium automation (using Hybrid framework) scripts for testing the entire functionality in QA environment. We also integrated test scripts with Jenkins for continuous deployment.

For the other portal migration, database is recreated in SQL Server by aligning to existing data model in ORN. Application code was migrated from PHP to AngularJS including new UI development and addition of support to other devices .

We then created data migration scripts using NodeJS CRON jobs and SQL procedures (combinedly) and finally migrated production data from ORN to SQL server.

Applied Technologies

Angular, Node JS, Twig templates, Express JS, Jade, JavaScript, PHP, Slim framework, Cake PHP, Docker, SQL Server, Oracle RightNow, Selenium (with Hybrid framework), Rest Assured framework for API testing, Jenkins

Case Study - Farmers' Debt Redemption Project

kisspng-goal-bullseye-computer-icons-business-mission-stat-goal-icon-5b4c3eb718cad7.9102785415317234471016

Client and Business Goals

The client is a Government of Andhra Pradesh owned company that was started for the purpose of reimbursement of crop loans taken by farmers of Andhra Pradesh.

Each farmer’s loan is reimbursed based on the type of the crop sown, acreage and the loan amount taken by the farmer.

Solution Description

Sreeb team incorporated the said requirements into its application so that the reimbursement process is done in a smooth and efficient manner.

The officials of the client, the officials of banks from which farmers took loans and members of Sreeb team ensured smooth processing of reimbursement of crop loans.

Applied Technologies

Microsoft Windows Communication Foundation