Customer Background
The customer is a renowned healthcare technology company in the United States. Over the years, the company has provided software solutions to an array of hospitals, clinics, research centers and other medical institutions. The business provides information management services on their native tool in United States.
Business Requirement
As the business underwent significant expansion, the customer wanted to reduce the maintenance hassle and focus on core functionalities in their databases. They approached Intellinez for a secure migration of their legacy system data to the Azure cloud. Subsequently, our team performed a deep system understanding before scoping out a relevant solution.
Approach
After series of requirement gathering and solution scoping, we finalized a Refactoring Database approach for migration’ to meet the customer requirements. The following key points were identified as areas of focus
- Reduce maintenance overhead for the infrastructure
- Secure transition to cloud without impact on current processing
Following the Azure Cloud Adoption Framework benchmark from Microsoft, we devised the roadmap to achieve the milestones. Post discussions, the below system architecture was proposed and locked to identify business outcomes.
Implementation
Diligently following the migration benchmarks from adoption framework guide and the business requirements as above, we executed the project as follows:
Strategy
- Identified multiple databases with unpredictable peaks of loads
- Plan secure transition to cloud as per expected business outcomes
Plan
- Finalized Azure SQL Elastic Pool to accommodate varying databases
- Pre-allocated a provisional database for fixed amount of resources
Ready
- Created a provisional Azure subscription and create new users
- Provided RBAC to all the users as per scoped requirement
- Created an Azure SQL server
Adopt
- 5 databases are migrated as elastic pooled databases to Azure SQL Server
- 2 databases are migrated to the same SQL Server as standalone databases
- Delegated permissions to business applications/users required to connect to the database
Abstract Insurance service providers operate in a highly competitive environment wherein customers and stakeholders expect on-demand settlement of claims. Despite digitization of processes, the insurance industry is prone to delay in grievance handling and claims processing resulting into rise in frauds and a dissatisfied consumer. One of the unresolved bottlenecks here is the errors in
Customer Background The customer is a renowned healthcare technology company in the United States. Over the years, the company has provided software solutions to an array of hospitals, clinics, research centers and other medical institutions. The business provides information management services on their native tool in United States. Business Requirement As the business underwent significant
Interest-Centric UI is revolutionizing the way small businesses in the US manage 401k plans for their employees. One of our clients needed to improve their user experience in a new mobile interface adapted to support a variety of devices. This required a mobile-friendly application that would support and enhance credibility with customers, clients, and influencers. They wanted to improve the existing web application with a new look and feel that could scale efficiently on across mobile devices. The challenge for Intellinez was to provide an exceptionally immersive experience while driving additional data and analytics, resulting in a higher rate of user engagement.
A multinational company wanted to benefit from using data warehouse services, advanced analytics, data mining, and reporting, by migrating from an on-premise Oracle-based platform into a scalable cloud data warehouse solution. The solution to be migrated had two terabytes-sized Oracle databases. Advanced analytics queries were in many cases timing out and underlying infrastructure had to be optimized for OLAP rather than OLTP.