ThinkAI

QSC learns the truth about its data, thanks to Think AI and Power BI
Audio equipment manufacturer QSC was experiencing a backlog in reporting and data requests, with limited resources to support the company’s needs. QSC found it difficult to secure data appropriately, and the cost of further extending its existing Oracle licensing was prohibitive. QSC ultimately wanted to enhance the productivity of the people who leverage and interact with its corporate information. Think AI provided QSC with a solution focused on cost-containment, standardization, and productivity through a centralized, cloud-based Microsoft Power BI program that now delivers applications to support executive scorecards, sales metrics, revenue management, and inventory-management dashboards.

Think AI, QSC, and Microsoft Power BI, and Azure Data Warehouse
 

Customer challenges
QSC requested a business intelligence (BI) assessment that could result in enhancing the productivity of the people interacting with its corporate information.  The manufacturer had limited resources to support its reporting needs, and it was facing a backlog of requests. QSC also found it difficult to secure data appropriately. It needed a new mechanism for generating reports so that users who are external to the company could still securely consume them when needed. In addition. The cost of extending its existing Oracle Discoverer tools licensing was prohibitive.

Partner solutions
Think AI created a self-serve data model using Power BI to capture data from multiple sources into a centralized enterprise Azure Data Warehouse, which became a single source of truth. The solution provider then secured multiple types of information in different queues by using Power BI workspaces. This enabled QSC executives to have their own workspace where they can see more confidential data, while each department has its own separate workspace where it can see department-related data.

Customer benefits

This solution provided the client with fully baked self-serve data analytics on demand, secured and personalized for each department. Within each department, Think AI also created security layers so that one manager can’t view the data for another manager. The solution is also more cost-effective, with QSC paying less for Power BI than for its previous Oracle Discoverer licenses. Further, because QSC was already using Microsoft technology, including Microsoft 365, the complete solution was easy to roll out.

Because the solution combines all of QSC’s available data sources into a centralized enterprise Azure Data Warehouse, the company can now rely on a single source of truth.
Self-serve Power BI data analytics is now standard for each department, and security is personalized for each role.
By adopting a cloud-based data infrastructure, QSC no longer needs to maintain servers and backups, reducing total cost of ownership.

Migration from SharePoint On-Premise to SharePoint Online for a National Property Trust Company
Business Challenge
The client had significant customizations in their SharePoint 2010 environment. They were using Custom/Visual Web Parts and Event Receivers, which they wanted to replace with the new SharePoint Online tools. Since Microsoft no longer supports SharePoint Server 2010, this client needed to make a move to a newer platform that was supported well.

Migrating to a new platform was daunting, but they wanted to do it in an organized manner with no downtime issues. They had very complex customizations created in Web Parts, Event Receiver, and Site Structure that support critical business processes, which necessitated a well-thought-out conversion plan.

The Solution
The Think AI SharePoint team decided to utilize ShareGate migration tool as it provides a user-friendly UI as well scheduled migrations and good migration speed, ShareGate also handled O365 throttling effectively plus any incremental migrations, which was key for this successful migration.

The second aspect of the Migration was the SharePoint complex customizations. Think AI decided to utilize the following features for SharePoint online in order to maintain the client’s existing customizations:

SPFx Web Parts for SharePoint 2010 Visual Web Parts
Power Automate flows for SharePoint 2010 event receivers
Client
The client is a leading diversified finance company with a core focus on the real estate and infrastructure sectors. They engage in originating, acquiring, financing and managing commercial mortgage loans as well as other commercial real estate debt and equity investments.

Document Management Using Custom Share Point Solution
Southland EDC implements a Custom Microsoft SharePoint Solution for Effective Document Management

Business Challenge
Southland EDC receives numerous documents from its clients, often very large in size and containing multiple pages. These documents are usually separated by barcodes that were being managed using an outdated tool

The tool was unable to identify barcodes present in the files.
The users had to manually create folders, as the tool lacked the robustness of automatic creation.
The process of reading bar codes could not be scheduled ahead of time and needed to be triggered manually.
Unavailable for use via the Internet
Poor performance and inefficient
The Solution
Think AI developed a custom SharePoint Online application

Easily accessible over the Internet without limitations of a physical location.
Provided the ability to accurately recognize all the barcodes for the large number of loan documents received.
Also provided the ability to batch process the files in the background, significantly reducing wait time.
Automatically created folders for each loan and kept content well organized, thus minimizing the need for manual labor.
Client
Southland EDC is a non-profit Certified Development Company chartered to assist the small business community of California and has done so since 1980. Its mission is to be a helpful resource through the U.S. Small Business Administration’s 504 loan program to local small businesses in fostering job creation and job retention.

“We are very excited about this product and look forward to putting it to full use. I want to personally thank all of you for all the effort that went in to making this solution happen. Your professionalism, knowledge and response time made it easier for Javier to communicate our needs and achieve the final outcome. Thank you very much!”

Maria Mata, Southland EDC

Engagement Summary
Think AI was hired by Southland EDC to develop a custom application in Microsoft SharePoint to manage, search, split and maintain scanned large PDF files received by the organization on a regular basis. Think AI’s goal for this project was to deliver a cloud-based service to Southland EDC to help with document management.

Think AI’s customized configuration of Microsoft’s SharePoint technology would help Southland EDC in managing its content seamlessly using the Internet. Removing the limitations of a physical office location, saving time and boosting company productivity were some of the challenges that Think AI had willingly undertaken through this project.

Business Value
A cost-effective replacement of existing BMI solutions available in the market. The custom solution was built on top of Microsoft’s default SharePoint functionality and also included the ability to manage multiple role-based permissions.

A Southland EDC employee usually averaged 60 hours a month to manually run the split function on files, verify for accuracy and organize them into folders. Think AI has now automated the outdated and inefficient file splitting process. Employees, just upload documents to a designated folder and the rest of the steps are completed automatically, at a scheduled time of the day.

Streamlining The Health Care Supply Chain And Improving The Patient Experience
Healthcare Company uses Dell Boomi implementation from Think AI to help physicians provide better care, while lowering operational costs.

Challenge
Healthcare Client wanted to simplify the claims management process for its customers.
Traditional middleware or hand coding often required complex processes, significant manual labor, and painstaking repetitive data entry.
Without any integration technology, processes were further impaired by piles of error-prone paperwork.
Healthcare organizations have seen a growing, critical need for data integration tools that can deliver the right information at the right time while adhering to HIPAA regulations.
 

Solution
Offered cloud-native integration that works in a variety of real- world healthcare scenarios.
Boomi offers a small footprint of it’s runtime engine, which signals when data is ready for retrieval by different applications.
Securely and cost-effectively moves data regardless of format to any endpoint, allowing facilitation of healthcare interoperability.
Business Value
Reduced costs through increased efficiencies and automated manual processes
Enhanced patient experience with greater data interoperability, minimizing errors and duplicate data entry
Streamlined workflow and improved billing accuracy
Offered Healthcare providers access to a complete view of the patient record from the EMR
Simplified diagnosis-driven protocols, dispensing, and billing so physicians could prescribe the most appropriate treatment

Streamlining The Health Care Supply Chain And Improving The Patient Experience
DJO Global Uses Dell Boomi Implementation From Think AI To Help Physicians Provide Better Care, While Lowering Operational Costs.

Challenge
DJO Global wanted to simplify the claims management process for its customers.
Healthcare organizations have seen a growing, critical need for data integration tools that can deliver the right information at the right time while adhering to HIPAA regulations.
Traditional middleware or hand coding often requires complex processes, significant manual labor, and painstaking repetitive data entry.
Without any integration technology. processes are further impaired by piles of error-prone paperwork.
Solutions
Offered cloud-native integration that works in a variety of real- world healthcare scenarios.
The small footprint of the Boomi runtime engine, which signals when data is ready for retrieval by different applications.
Securely and cost-effectively moves data regardless of format to any endpoint, allowing facilitation of healthcare interoperability
Business Value
Reduced costs through increased efficiencies and automated manual processes
Enhanced patient experience with greater data minimizing errors and duplicate data entry
Stream lined work flow and improved billing accuracy
Healthcare providers having access to a complete view of the patient record from the EMR via MotionMD
Simplified diagnosis-d riven protocols, dispensing and billing so physicians can prescribe the most appropriate treatment.
Client
DJO Global manufactures durable medical equipment (DM E) for musculoskeletal health, vascular health, and pain management, including knee and hip replacement implants and conservative care products. The company’s mission is to deliver state-of-the-art medical devices and services that allow people to live life to the fullest despite physical challenges. D3O is an excellent example of the type of Thought Leaders Think Al collaborates with and by combining synergies Think Al and DJO were able to develop an innovative solution to influence and exact a positive change.

“In tegroting patient data from the EMR into Motion MD helped DJO realize a material improvement in the speed of transactions as well as improved financial results at clinics.”

Mike Peters, Chief Information Officer, DJO Global

Solution
For DJO Global. Think AI’s Boomi solution, with its low- code integration platform, offers cloud-native integration that works in a variety of real-world healthcare scenarios. The small footprint of the Boomi runtime engine, which signals when data is ready for retrieval by different applications, was instrumental in DJO Global’s selection process. Boomi securely and cost-effectively moves data regardless of format to any endpoint. This allows DJO Global to facilitate healthcare interoperability.

Now, healthcare providers (DJO’s direct customers) can rein in healthcare costs and improve patient health while providing a more efficient and patient-centric clinical experience. And, equipped with Think AI’s Boomi solution, DJO Global is able to easily share data between MotionMD and hundreds of EMRs and other applications while reducing errors that cause claims to be rejected by insurers.

Business Solution
Easy to install and manage. Think AI’s Boomi implementation has delivered tangible benefits to DJO Global’s operations, demonstrated by:

Reduced costs through increased efficiencies and automated manual processes
Enhanced patient experience with greater data interoperability, minimizing errors and duplicate data entry
Streamlined workflow an improved billing accuracy
Powering DJO Integrator, a DJO Global interface that shares patient EMR data with MotionMD
Healthcare providers having access to a complete view of the patient record from the ER via MotionMD
Simplified diagnosis-driven dispensing and billing so physicians can prescribe the most appropriate treatment