Let’s work together
Want to discuss potential opportunities? Pick the most suitable way to contact us.
Book a call+370 5 2 780 400
info@ba.lt
Progress OpenEdge solution for the US medical billing and management service provider
Data is one of the most valuable currencies of today’s digital world. And companies winning at the data game can secure their spots among top industry leaders. Yet, enabling smooth data analysis, monitoring, and reporting processes is a solid task.
Statistics from Precisely’s report shows that only 18% of data analytics experts are satisfied with the comprehensibility of the data landscape/architecture as a whole. Also, 26% of business managers lack the flexibility to extend data requirements.
Therefore, we are delighted to share a case study about the new Professional Billing, Inc. (PBI) data warehouse (DWH) solution, which significantly increased data processing efficiency, enabled better data insights, and cut IT-related costs.
Situation
PBI is a privately-owned company that offers tailored medical billing and technology solutions to healthcare providers, including physicians. The company was established more than three decades ago with a commitment to flexibility and customisation and has since become one of the leading providers of medical billing and practice management services in the United States.
The existing client’s DWH solution was ineffective, wherefore, maintaining both Tableau and PostgreSQL on-premises was a significant resource-intensive task. Also, due to its reliance on a Progress-based legacy system, PBI’s infrastructure was overly complicated, unable to support effective reporting and monitoring, lacking in flexibility and scalability.
PBI looked for a reliable technology that could solve mentioned performance challenges and streamline the data analysis, reporting, and delivery processes. This is where Baltic Amadeus stepped in and proposed an efficiency-driven and cost-effective solution for PBI’s reporting and DWH.
Solution
Baltic Amadeus pulled off an entire project in one month – from situation analysis to solution development, testing, and complete data migration. The project was divided into two equal parts – internal medical billing and management application as well as DWH and reporting solution created in the Microsoft Azure cloud.
On the application side, our team used Progress OpenEdge database trigger logic to track and store database changes. Then, the database configuration was adjusted to have a separate broker for SQL-only connections. In addition, users and permissions were created for SQL connections, and SQL Stored Procedures were implemented for processing and deleting records.
On the Azure side, we used Progress OpenEdge ODBC Driver to connect to the Progress Database and data required for reporting was taken from Progress Database and stored in Azure SQL Database. Our team used the Azure Data Factory to update the DWH incrementally, utilising change tracking tables. Meanwhile, processed records were marked and deleted by a separate process. Finally, the DWH was made available for fast, in-memory performance for Power BI and other client databases.
Added value
The brand-new DWH implementation optimised resource usage, removing obsolete code and reducing half of ETL processes. These improvements significantly cut solution maintenance costs.
Thanks to the solution’s flexibility, scaling resources is now easier during peak and off-work periods. Moreover, PowerBI allows users to generate reports more conveniently and access data faster.
Furthermore, the project eliminated unnecessary data management processes by fully caching and partitioning data in Power BI, resulting in improved data processing, querying, and quality. The solution also reduces unneeded data copies and provides a single point of truth.
Other projects
Reliable marketplace platform for used car trading
Unified IT systems for the debt company
Solar energy trading solution for the international energy company
Progress OpenEdge development and system testing services for a Swiss company
Optiwork
AWS-based automated reporting and billing solution for the US transportation company
Clever Transco LLC
Azure-based solution that cut infrastructure costs by over 4 times
ProMark
Data/API Hub solution for the international ferry service provider
TT-Line
Security assessment and InfoSec training for a global media company
Internews
Infrastructure and data migration assessment for agricultural retail provider
Lytagra
Upgraded analysis platform boosted paid user base by 43%
Börsdata
In-depth penetration testing for a specialised Lithuanian bank
General Financing Bankas
Mobile app for the fastest-growing payment solutions provider in Lithuania
ConnectPay
Mobile app development for the largest insurance company in the Baltics
Lietuvos Draudimas
Boosted sales performance for the leading digital services company in the Baltics
Bitė
Highly rated mobile app for Baltic digital services company
Bitė
Efficiency-driven ordering and billing system for large-scale military training
WilNor Governmental Services AS
High-performing eCommerce platform for one of the largest pharmacy providers in the Baltics
EUROAPOTHECA
AWS-based mobile banking solution for the financial institution
LCCU
Fully automated and scalable leasing solution for DNB Bank
DNB BANK
Ensured IT security & GDPR compliance for the international web hosting provider
Hostinger
Convenient daily banking solution for credit unions
KREDA
Mobile banking app for DNB bank
DNB bank
Performance monitoring solution for the global shipping company
Shippersys
Custom Business Intelligence solution for a global maritime company
Shippersys
Crisis management system for Norway’s educational institutions
Akershus County
eCommerce platform for the global maritime Enterprise Asset Management provider
Star Information Systems
Innovative eCommerce solution that enhanced customer experience for electricity consumers
UAB Technologijų ir inovacijų centras
Web and mobile applications for preschools to ensure children’s safety
FamWeek
Fully upgraded communication platform for the Norwegian telecoms company
SIMCOM AS
eCommerce reservation platform for the Norwegian Aviation Museum
Norwegian Aviation Museum
Data visualisation solution that highly increased business productivity
UNIPARK