Nippon India: Serverless Reporting and Analytics on AWS

Executive Summary:

Nippon India Mutual Fund’s Oracle-based reporting was costly to run and still depended on manual report generation. Rapyder moved the workload to AWS cloud modernisation services: Athena for queries, Lambda for processing, Glue for ETL, and EventBridge with SNS for scheduling and alerts. The new pipeline removed Oracle and hardware overhead, cut manual reporting effort by almost 90% and scales with demand.

About Customer:

Nippon India Mutual Fund (NIMF) was established as a trust under the Indian Trusts Act, 1882, with Nippon Life Insurance Company as Sponsor and Nippon Life India Trustee Ltd as Trustee. Registered with SEBI since 1995 and formerly known as Reliance Mutual Fund, it was renamed Nippon India Mutual Fund in September 2019. NIMF was formed to launch schemes under which units are issued to the public, contributing to the capital market and allowing investors to invest in diversified securities.

Problem Statement:

Nippon India Mutual Fund’s reporting relied on Oracle-based stored procedures, with high licensing costs and complex server management. Manual report generation caused delays and errors, while scaling the infrastructure to meet growing analytical needs was difficult and expensive. The business needed a simpler, cost-effective reporting approach without compromising accuracy or timeliness.

Industry:

Industries, BFSI / FinTech

Offering:

Offerings, Data Analytics

Business Challenges:

1. Oracle reporting cost: Reporting and analytics relied on Oracle-based stored procedures, carrying high licensing costs and complex server management.
2. Manual report delays: Manual report generation led to delays and errors in getting insights to the business.
3. Scaling difficulty: Scaling the existing infrastructure to meet growing analytical needs was challenging and expensive.
4. No efficient path: The overall approach lacked a cost-effective, scalable and efficient path forward for reporting.
5. Complex data management: Data management needed simplifying without sacrificing accuracy or timeliness.

Solution Implemented:

1. Serverless migration: Moved reporting and analytics to a serverless architecture, eliminating expensive licensing and hardware costs tied to the Oracle-based approach.
2. Athena queries: Used Amazon Athena for serverless data querying, allowing analysis without managing any underlying infrastructure.
3. Lambda processing: Used AWS Lambda for serverless data processing, executing code in response to events across the pipeline.
4. S3 storage: Stored data securely and scalably in Amazon S3, ensuring reliability in both retrieval and storage management.
5. Glue ETL: Deployed AWS Glue as a metadata repository and ETL service connecting Amazon S3 with Amazon Athena, automating data discovery, cataloguing and transformation.
6. Event orchestration: Orchestrated workflows and scheduled report generation with Amazon EventBridge, automating tasks based on events within the AWS environment.
7. SNS notifications: Configured Amazon SNS to send timely notifications and alerts, integrating with other AWS services for automated report generation and distribution.
8. Cost controls: Implemented resource tagging and rightsizing techniques to maximise cost savings across the new architecture.
9. Ongoing optimisation: Established ongoing processes to monitor and optimise resource utilisation over time.

Technology Stack:

• Amazon S3
• AWS Lambda
• Amazon Athena
• AWS Glue
• Amazon SNS
• Amazon EventBridge

Business Benefits:

1. Eliminated licensing and hardware costs – Moving to a serverless architecture removed expensive Oracle licensing and hardware overhead entirely.
2. Almost 90% less manual effort – Automated report generation and simplified management processes reduced manual effort by almost 90%, increasing operational efficiency.
3. Dynamic resource scaling – Storage and processing scale dynamically with demand rather than requiring upfront capacity planning.
4. Prompt, precise reporting – Automated pipelines ensured timely and accurate reporting, enhancing decision-making across the business.
5. Greater business agility – The modern cloud-based approach enhanced overall business agility and competitiveness.

Key Takeaways:

• Serverless querying – Serverless querying can remove both licensing cost and server-management work.
• Scheduled reporting – EventBridge and SNS turn scheduled reporting into a pipeline with built-in notifications.
• Ongoing cost controls – Tagging and rightsizing are what help preserve savings after the migration.