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.
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.
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.
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.
Microsoft Windows Communication Foundation