Improving operational efficiency through a SaaS based web application

Improving operational efficiency through a SaaS based web application
Trigent was very conscientious about ensuring both the architectural and operational security of the application, along with its operating environment.

About the client

The customer is a market leader providing Gift Administration Software solution to charities, foundations, banks and asset manager to help administer gift annuities, charitable trusts, pooled funds and several other types of planned gifts. The customer had been providing the software as a Windows application, in a licensed model over a decade. Trigent's association with this customer has lasted for over 10 years and a development effort of over 16000 person-hours. We continue to maintain and support the application through a dedicated 24X7 team.

Business need

The existing software used outdated technologies that were reaching the end of their life cycle. Its monolithic architecture made incremental development difficult and expensive. In addition, there were several pending enhancement requests to provide additional reporting flexibility, improve ease of use and to better integration with allied third party services.

The proposed solution was to re-write the entire application as a web based, SaaS enabled application capable of running in three distinct modes to meet their customer needs.

  • Stand-alone, web-based application running behind the client's firewall.
  • Hosted application that is available to customers SaaS model.
  • Service bureau model in which the company hosts and manages the application and data, providing back office and compliance reporting services.

It was required that these three configurations be derived from a single code base. It was also important that the application be truly multi-tenant and scalable with increasing number of clients. In addition, several new functional enhancements such as workflow and task management and document storage were developed and integrated to the existing solution.

Solution

Trigent and the client worked together on a reliable development and roll out schedule for the new software version to ensure a smooth transition to thousands of existing licensed clients. Migration of clients to the new hosted system need to be coordinated with their fiscal year end processing and tax filing. The window of opportunity for the roll out was very small, and if missed, the roll out would be delayed by a year, severely impacting new revenue stream.

Careful project planning, scheduling and verification were highlights of this engagement. Adding complexity and challenge was to deploy the still emerging SaaS technology components in the Microsoft stack and making judicious decisions about timing and order of deploying these technology.

Some highlights of how we executed the project are presented here:

  • A detailed Discovery phase to understand the business and technology components of all systems. This helped us work out the risk assumptions and verify the critical areas.
  • The Subject Matter Experts (SME) and Technical Architects from both the customer's side and Trigent's side were extensively involved during the Discovery phase at which point a flexible SOA and design was drawn up.
  • These "two teams working as one" approach paid enormous dividends in the later stage of "going live".
  • An iterative mode of project development was planned so that features could be delivered early on and fine-tuned in subsequent iterations.
  • Exhaustive release management procedures were defined, documented and followed to keep individual releases and defects under control.
  • Detailed requirements were documented by both the customer and Trigent for various modules. Wireframes and PPT's were used to illustrate and agree on the User Interfaces.
  • An independent testing team interactively tested the application and reported all issues.
  • Client benefits:
    • SaaS enabled web application supported in all three configurations which helps to attract many smalle customers at lower price points
    • Flexible SOA and design which helps in integrating with several related third party applications
    • Flexible reporting framework which makes custom reporting easy and which does not require a re-deployment
    • Improved application performance and reduced code redundancy during the re-write
    • Reduced TCO for the customer and his customers by virtue of a hosted model

    The following are the salient features of the solution: Security, Multi-tenant Efficiency, Configurability

    The other benefits of the application: Client on-boarding, Volume, Growth

  • Technology Stack
    Technology stack:
    • IIS Windows 2000/2003 Server
    • MS Visual Studio, using ASP.Net, C#.Net
    • Ajax 1.0 from Microsoft MS SQL Server 2005 with Reporting Services
    • Microsoft Azure