Our goal is to turn your data into a business
advantage by helping you see the big picture.

Case Studies

Big Data In Healthcare

Our client is using the CRM for Healthcare industry has a terabytes of data and concurrent queries were hitting the system badly. The database handling through relational database like MySQL was degrading the performance of the application. We at Ira Softwares re-designed the application to run as BIG Data application. The query system was injected using the Apache Spark. Elastic Map Reduce(EMR) service of AWS was deployed and the performance of the application increased multiple folds.


Consumer Segmentation Solution

Objective

The client is a specialized retailer with over 400 locations and a revenue of over a billion dollars in FY 2017. The client has a large customer base of around 5 million distinct clients. However, they were having trouble streamlining their marketing strategy. Customers were receiving more than 40 emails/coupons per week in certain circumstances, with offers that were irrelevant to their needs. As a result, customers were dissatisfied, and the return on investment (ROI) on their marketing activities was low.

Solution

The client had a specific goal in mind: to boost consumer engagement and improve the ROI of marketing initiatives (coupon redemptions and frequency of visits). IRA Softwares developed a sophisticated consumer segmentation solution based on machine learning algorithms, as well as a bespoke ROI effectiveness solution that answered the client's requirements. The client segmentation models developed by IRA Software indicated three main customer groups:

  1. Regular
  2. Chum Possibilities
  3. Low Engagement

There were three sub-segments in each of the aforementioned segments. This segmentation aided in the development of tailored marketing tactics for their weekend sales promotions. Multiple techniques were examined for each category using a Test & Learn methodology, taking into consideration seasonality and client preferences, among other variables. Finally, the optimum plan for each consumer category was executed.

Benefits

  1. Customer churn rate: ISO reduced customer churn in all sectors (customers moving from higher to lower segments were also considered as churn)
  2. More coupons are being redeemed as a result of personalized offers: ION has increased email coupon redemption and has increased direct mail coupon redemption.
  3. The average number of visits each quarter has increased by 30% across all categories.
  4. The average basket size of customers in the Regular and Low Engagement groups has increased by 20 percentage.
  5. Return on Investment (ROI) of Direct Mail Campaigns: Optimizing the campaign resulted in a $2 million savings and a $3 million increase in income from coupon redemption.

BRE (Business rules engine)

Objective

Every month, all of the linked insurance companies send the consulting company a large and rising number of medical, pharmaceutical, and enrolment claims data. Their existing data analysis pipeline couldn't keep up with the additional workload, and their data warehouse's capacity had reached its limit. The ETL data ingestion and reporting processes were also not performing well. As a result, they were limited in their capacity to bring on new clients and expand the firm.

IRA Softwares was hired to examine the firm's overall ETL difficulties, provide recommendations for removing bottlenecks, and dramatically enhance the firm's data analytics platform's performance and scalability.

Solution

The three deliverables of IRA Software's solution for the benefits and human resources consulting business were designed to set the firm's data analytics program for success.

To begin, IRA Software created a unique data-driven business rules engine (BRE) to assess income, medical, prescription, and enrolment claims. In order to detect illnesses, care gaps, and hospital admissions, the BRE was used to determine if a claim line satisfied a rule-based on diagnostic codes, procedure codes, location, gender, or a mix of multiple factors. Furthermore, IRA Software worked with internal personnel to optimize the existing load of the data warehouse in order to improve efficiency and reporting performance.

Finally, Tableau was added as a reporting and analysis tool to boost flexibility and shorten the time it takes for business users to offer new reports and analyses. Tableau offered end users with quick and simple access to all data, as well as self-service capabilities, allowing them to link historical data warehouse structures with newly built rules and disease diagnosis structures.

Benefits

The combination of IRA Software's unique data-driven BRE and changes to the data input and database platform areas resulted in considerably enhanced processing performance. A typical client's monthly data processing time was reduced from hours to minutes. Segal has been able to enrol additional clients and increase its company because of this better analytics platform, which is scalable.