HomeWorksAccounting & TaxationGST Suvidha Provider

GST Suvidha ProviderA Robust Data Platform for Enterprise Taxation & Analytics

Problem Statement

The client was developing a GST (Goods & Services Tax) Filing System which would help accountants to file the GST for their companies. They wanted the system to be:

  • Secure: involved highly confidential financial data.
  • Performant: to handle over 3000 concurrent users.
  • Scalable: sudden influx of requests on last day of filing.
  • Safe & Available: To support audits & compliances.
  • Flexible: to operate on SAAS as well as on-premise installations.
  • Accurate & Precise: Paramount for financial calculations.

Solution Design & Implementation

  1. Design Highlights
    • Built for scalability, security, and portability to run independently in client environments.
    • Followed a SaaS model with a master database to manage dynamic connection strings for tenant-specific databases.
  2. Performance Optimization
    • Routed database requests via the master database, enabling load distribution across multiple SQL Server instances.
    • Added load balancing for reporting using Transactional Log Replication to separate transactional and reporting workloads.
  3. Robust Security Framework
    • Implemented role-based access control (RBAC) for deployment, testing, operations, and support teams.
    • Allowed client-specific logins with granular permissions while monitoring all logins for security.
  4. Comprehensive Monitoring
    • Built a monitoring solution using DMVs, logs, extended events, and Windows Performance Monitor.
    • Monitored metrics like database growth, deadlocks, query performance, tempdb contention, and wait stats.
  5. Infrastructure Overview
    • Managed a 6-server setup (3 primary + 3 replication) with over 1,200 databases delivering consistent performance since day one.

Technology Stack

  • Microsoft SQL Server
  • Microsoft T-SQL

Key Expertise

  • Database Architecture & Development
  • SQL Server Performance Tuning
  • Database Administration
  • Database Governance
  • HA-DR (High Availability & Disaster Recovery) Planning

Challenges

  • High Data Volume
  • Highly Concurrency Requests
  • Data Security

Results

Here’s what we achieved with the new system:

  • Increased productivity of accountants by 30% in calculating, verifying and filing GST against government portals.
  • The system serves 800+ large corporations with over 300+ listed companies on BSE.
  • We have achieved 99.99% uptime throughout the year with 0 database server issues during filing.
  • 1200+ databases operationally online; hosted across 2 geographical regions to cover for Disaster Recovery.
  • 2TB+ hot data already being managed & growing every day.
  • 0 security incidents noted till date.
  • All hot data database requests served within <3 seconds for quick filing.