Contact Us
Insurance ERP Software for Medical Indemnity Operations

Insurance ERP Software for Medical Indemnity Operations

InsurTech Case Study

DreamzTech re-engineered Apexer 3.0 for AICL, connecting member onboarding, professional indemnity policies, premiums, payments, renewals, medico-legal cases, insurer integrations and mobile operations in one governed platform.

  • Client Apex Insurance Consultant Limited (AICL)
  • Industry Insurance, InsurTech and Healthcare Risk Management
  • Platform Apexer 3.0 Custom Insurance ERP
  • Core Capabilities CRM, Policies, Renewals, Payments, Cases and Reporting

Explore Fintech Software Development →  |  Talk to an Insurance Software Expert

Build Your Custom Insurance Platform
Insurance ERP Software for Medical Indemnity Operations
Insurance ERP Software for Medical Indemnity Operations
Insurance ERP Software for Medical Indemnity Operations
Insurance ERP Software for Medical Indemnity Operations
Insurance ERP Software for Medical Indemnity Operations
Trusted By Startups, SMBs to Fortune 500 Brands
g2-gray-1.png
get-app-gray-1.png
software-advice-gray-1.png
software-connect-gray-1.png
source-forge-gray-1.png
upcity-ratings-gray-1.png

Project at a Glance

  • Client: Apex Insurance Consultant Limited (AICL).
  • Industry: Insurance, InsurTech and healthcare risk management.
  • Business model: Professional and hospital indemnity support with medico-legal services.
  • Platform: Apexer 3.0 custom insurance ERP.
  • Primary users: Employees, leads, doctor and hospital members, advocates and authorized partners.
  • Core capabilities: CRM, memberships, premiums, payments, policies, renewals, cases, documents, communications and reporting.
  • Delivery surfaces: Web platform, staff mobile app and member-facing mobile experience.
  • Key integrations: Insurer APIs, secure mail and bordereau exchange, Razorpay, email, SMS, WhatsApp and cloud storage.
  • Technology: Laravel 8, PHP 8, MySQL, Redis, Passport OAuth2, Razorpay, DomPDF, Pusher and Flutter.

Overview

AICL needed to modernize years of insurance and medico-legal operational data without breaking the relationships between doctors, hospitals, policies, payments, renewals, advocates and legal cases. DreamzTech built Apexer 3.0 as a custom insurance ERP with a controlled legacy migration, configurable multi-insurer workflows, role-based web operations, mobile applications, digital payments, documents, communications and management reporting.

The result is a connected system of record that supports the full member and policy lifecycle while preserving historical context and making recurring work easier to govern. The platform's strongest proof is architectural and operational: 24 legacy staging tables, 628 database migrations, more than 240 core tables, four insurer relationships and two purpose-built applications.

Apex Insurance Consultant Limited operates at the intersection of insurance distribution, healthcare risk management and medico-legal support. It helps doctors and hospitals access professional indemnity protection and supports members when a legal matter arises. AICL's public website reports a national footprint of more than 20 offices, more than 120,000 doctors and 24 by 7 service availability.

That operating model is more complex than a standard policy portal. AICL must coordinate members, insurers, staff hierarchies, payments, renewals, documents, communications, advocates and legal cases without losing the connection between them.

The Challenge

The central challenge was to replace a high-risk legacy data foundation while keeping historical insurance and service records usable under new business rules. The old database had inconsistent structures, weak keys and unreliable relationships across years of lead, policy, payment and case information.

  • Complex migration: Legacy tables did not align with the Apexer 3.0 domain models and required field-by-field mapping.
  • Data integrity risk: Duplicate, invalid and orphaned records could not simply be copied into production.
  • Business continuity: AICL needed to continue operating while historical records were assessed, transformed and validated.
  • Multi-insurer variation: Four insurers used different premiums, payloads and exchange methods.
  • Cross-functional workflows: Sales, member service, policy operations, finance and legal teams needed one connected record.
  • Performance at scale: Large listings and reports required predictable queries, pagination and targeted indexes.
  • Access governance: AICL's organizational hierarchy required different permissions at both screen and action level.
  • Communication traceability: Member and case messages needed to move from scattered channels into an auditable history.

Security and Governance

  • Authentication: Session-based access for the web platform and Laravel Passport OAuth2 for mobile and API use.
  • Authorization: Role-based controls apply at menu and action level across a multi-tier organizational structure.
  • Partner isolation: Third-party and member-facing API traffic uses a separate verification path from staff sessions.
  • Encrypted exchange: CKYC payloads sent to Future Generali are AES-encrypted according to the documented integration.
  • Auditability: Outbound insurer requests and responses, scheduled jobs and application exceptions are logged.
  • Historical protection: Soft deletion preserves records for traceability instead of immediately destroying them.
  • Document storage: Entity-linked files use cloud-backed storage and controlled delivery.

The Solution DreamzTech Delivered

DreamzTech designed Apexer 3.0 as a modular insurance ERP rather than a collection of disconnected tools. Each module contributes to one continuous operational chain: employee and lead, customer and membership, proposal and premium, payment and policy, renewal and reporting, with medico-legal cases and communications linked to the same member record. The build extends DreamzTech's legacy system modernization practice into a regulated, multi-insurer operating platform.

The migration followed six governed stages: assessment, mapping, transformation, relationship mapping, validation and production promotion. Twenty-four legacy staging tables covered leads, subscribers, policies, payments, cases, advocates, courts and employees. Import logic checked legacy identifiers to prevent duplicates, while rejected rows retained a human-readable error reason for correction.

A hierarchical role model supports functions from super administrator and executive leadership through operations, area, branch, sales and renewal roles. Access is governed through a menu-to-permission-to-role-to-user model, allowing AICL to control both what a user can see and what the user can do.

The insurance CRM captures a lead, assigns an executive, records activities and visits, and converts qualified leads into doctor or hospital subscribers without re-entering the same information. Management reporting can analyze conversion by leadership level, team, branch and executive.

AICL can configure service-only or service-plus-policy memberships, capture coverage and member details, monitor expiry and manage the connection to a policy. The platform prevents conflicting active memberships and can recalculate premiums when relevant profile data changes.

Apexer 3.0 supports the lifecycle from proposal and premium through payment, policy creation, approval, documents, status and renewal. Insurer-specific rules allow automated or manual premium calculation by company and member type. Renewal activity follows a governed timeline with approval, effective dates, expiry monitoring, reminders and an audit trail.

Razorpay integration supports payment links, QR payments and webhook confirmation. Field-collected cash and cheque transactions can include photographic evidence. Configurable TDS logic creates qualifying line items and supports GST and TDS clearance in the finance process.

One integration layer handles different insurer operating models. ICICI Lombard and Future Generali use live API flows for functions such as authentication, premium, proposal, CKYC and certificate retrieval. National Insurance and Reliance or IndusInd General Insurance use secure mail and bulk bordereau exchange where direct APIs are not available.

The case module connects the insured member with the assigned advocate, hospital context, documents, processing stages and closure. Cases can be classified as case, draft, notice or advice and tracked as pending, active or closed. Pre-membership and non-membership cases can follow a dedicated management approval path, while structured closure reasons improve reporting consistency.

The platform generates or stores insurer certificates, cover notes, GST invoices, service agreements and renewal notices against the correct policy, case or member. A centralized message log records email, SMS, WhatsApp and staff communications. Scheduled courtesy and legal reminders support proactive service, and inbound email replies can be linked to the original member thread.

Dashboards bring policy status, revenue, renewals, members, employees and leads into one management view. Operational reports support lead conversion, payments, policies, renewals, cases and team performance, with access aligned to the user’s role and organizational scope.

A web platform supports office operations, while purpose-built mobile applications extend relevant workflows to staff and members. The delivery model uses the same governed data core with different authentication and permission paths for employees, members and partner systems, building on DreamzTech’s custom mobile app development practice.

More than 20 scheduled tasks keep recurring operations moving between user sessions. Examples include reading insurer mailboxes, retrieving generated policy certificates, sending courtesy communications, reminding employees about attendance, notifying advocates about hearings, warning members about expired policies and distributing monthly sales analytics.

Data Migration and Architecture

Apexer 3.0 separates the historical database from the governed migration process, the application core and the integration and delivery layers so the platform can evolve without repeating the original migration risk.

LayerApexer 3.0 Capability
Legacy layerHistorical database with inconsistent keys and relationships
Migration layerStaging tables, assessment, mapping, transformation, deduplication, validation and error logging
Application coreMembers, memberships, policies, premiums, payments, TDS, renewals, cases, advocates, documents and communications
Integration layerInsurer APIs, CKYC exchange, secure mail, bordereau files, Razorpay and messaging channels
Delivery layerRole-based web application, staff mobile app, member-facing access and management reporting
Data and performanceMySQL, Redis, eager loading, pagination and EXPLAIN-driven indexes
Security and auditSession authentication, OAuth2, role permissions, isolated partner guard, encryption and centralized logs

Verified Implementation Scale

The strongest publishable proof of Apexer 3.0 is architectural and operational, not a percentage claim.

Proof PointWhat It Means
628 database migrationsThe live schema evolved through a substantial, controlled engineering history.
240+ core tablesThe platform covers a broad and interconnected operational domain.
24 legacy staging tablesHistorical entities were isolated and mapped before production promotion.
137 performance-related migration filesIndex and query tuning were treated as a continuing engineering discipline.
4 insurer relationshipsOne ERP supports multiple premium and integration models.
2 purpose-built applicationsWeb and mobile users operate against the same governed data core.
20+ scheduled tasksRecurring operational work continues between interactive user sessions.

Success and Outcomes

Apexer 3.0 gives AICL a governed digital foundation for insurance and medico-legal operations. Instead of relying on fragmented records and channel-specific work, authorized teams can follow one connected lifecycle and retrieve the context required for member service, policy operations, financial reconciliation and legal support.

Connected Operations

Leads, members, policies, payments, renewals, cases, advocates, documents and communications share one data core.

Governed Migration

Twenty-four legacy staging tables were mapped and validated before clean records were promoted.

Multi-Insurer Scalability

Four insurer relationships are supported through API and secure mail or batch patterns.

Reduced Repetitive Work

Scheduled tasks automate recurring reminders, certificate retrieval, mailbox processing and reporting.

Improved Traceability

Messages, insurer API activity, job execution and exceptions create auditable operational histories.

Faster Data Access

Eager loading, pagination and targeted composite indexes address large listings and report queries.

Role-Appropriate Visibility

Employees access the screens, actions and reporting scope assigned to their role.

Mobile Continuity

Staff and members can access relevant workflows through purpose-built mobile experiences.

Why This Case Study Matters to Insurance Leaders

Insurance modernization is rarely just a front-end redesign. Policy workflows depend on historical data, product rules, partner interfaces, payments, documents, approvals, communications and reporting. Apexer 3.0 demonstrates how DreamzTech can modernize that operating core without treating migration, integrations or governance as afterthoughts. Extend this further with DreamzTech's custom software development team, or see our software development case studies for related work.
Talk to an Insurance Software Expert

Leading Global Software Company

Trusted by Industry Leaders Worldwide

Trusted by startups to Fortune 500s, including DHL, Nestle, and Stanford - partners who rely on us for high-impact, scalable software solutions.

Book a Discovery Call

    I Consent to Receive SMS Notifications, Alerts from DreamzTech US INC. Message frequency may vary. Message & data rates may apply. Text HELP for assistance. You may reply STOP to unsubscribe at any time.
    I Consent to Receive the Occasional Marketing Messages from DreamzTech US INC. You can Reply STOP to unsubscribe at any time.
    By submitting the form, you agree to the DreamzTech Terms and Policies

    Modernize Your Insurance Operations with One Connected Platform

    Whether you need to replace a legacy policy system, build an insurance ERP, connect insurer APIs or launch secure web and mobile workflows, DreamzTech can help you define and deliver the right architecture. Or explore fintech software development to see the broader practice this project draws on.
    Book a Free 60 Minute Strategy Session

    Frequently Asked Questions (FAQ)

    Insurance ERP software is a connected business platform that brings policy administration, premiums, payments, renewals, customer records, documents, communications, reporting and internal operations into one governed system. A custom platform can also support the specialized workflows and partner integrations that standard ERP products do not cover.

    DreamzTech re-engineered Apexer 3.0 as a connected insurance and medico-legal operations platform for AICL. It supports lead conversion, doctors and hospitals, memberships, insurer-specific premiums, payments, policy issuance and renewal, legal cases, advocates, documents, communications, reporting and web and mobile access.

    The platform supports AICL employees across different organizational roles, prospective customers, doctor and hospital members, panel advocates and authorized operational users. Role and permission controls determine which screens and actions each user can access.

    It connects the commercial policy lifecycle with the service and legal-defense lifecycle. AICL can manage a doctor or hospital from lead and membership through proposal, premium, payment, policy, renewal, communication and a medico-legal case when assistance is required.

    Yes. Apexer 3.0 uses insurer-specific premium and integration rules for ICICI Lombard, Future Generali, National Insurance and Reliance or IndusInd General Insurance. API-based and secure mail or batch workflows are handled within one operating platform.

    The workflow covers proposals, premium calculation, payment confirmation, policy creation, approval, documents, status tracking and renewal. Scheduled jobs can fetch generated certificates, monitor expiry dates and send policy-related notifications.

    DreamzTech used a controlled process of assessment, field mapping, transformation, relationship mapping, duplicate detection and validation. Legacy rows were first handled through staging tables, while failed rows retained a readable error reason instead of being silently promoted to production.

    Import logic checks legacy identifiers before creating live records and validates mapped relationships. Invalid or incomplete rows remain in the migration layer with an error reason for review, supporting a more traceable cutover.

    Yes. The documented platform uses Razorpay for payment links, QR payments and webhook-confirmed transactions. It also supports field-collected cash or cheque records, approval evidence, configurable TDS handling and finance reconciliation.

    The system generates or stores policy certificates, cover notes, tax invoices, service agreements and renewal notices against the relevant member, policy or case. Email, SMS, WhatsApp and message-log activity provide an auditable communication history.

    Yes. The solution includes purpose-built staff and member-facing mobile experiences connected to the same data core. Authentication, dashboards, leads, members, policies, cases and notifications are exposed according to the user’s access path.

    Dashboards and operational reports provide visibility into leads, conversion, members, policies, renewals, revenue, payments, employees and cases. Access can be filtered by role, branch, team or executive based on the organization’s hierarchy.

    The documented controls include session authentication for the web portal, OAuth2 for mobile and API access, role-based permissions, partner-access isolation, encrypted insurer payloads, API and job logs, exception logging and soft deletion for historical traceability.

    Yes. DreamzTech can assess legacy data and workflows, define a governed migration, rebuild the platform for web and mobile use, integrate insurers and payment providers, automate recurring operations and retain auditability throughout the new system.

    The timeline depends on the number of modules, data quality, insurer interfaces, compliance rules, mobile apps and rollout strategy. DreamzTech begins with a requirements and legacy-data assessment, then proposes phased delivery, migration, testing and deployment milestones.

    Navigate

    Discuss your Project ➜

    Awards & Recognitions
    forbes-logo-white.png
    time_Logo_White
    theeconomictime.png
    Deloitte Technology Fast 50 India recognition badge
    Capterra Best Value badge
    Clutch Top Generative AI Company Arizona 2025 badge
    bronze_winner.png
    CIO recognition badge
    GetApp Best Functionality & Features badge
    softwareadvice-best-customer-support-1.svg
    capterra-best-ease-use-1.svg
    Business Innovation award badge
    India IT 2025 award badge