Membership Autorenewals

2009 – 2023 internal Internal / Not public

Online application services and management area to handle annual membership renewals.

Context

Internal management system for handling automatic renewals of memberships and subscriptions, built on .NET Framework 3.5 - 4.8 with ASP.NET MVC front-end.

Architectural Decisions

ASP.NET MVC used for improved separation of concerns and testability. Integrated with existing membership database for seamless data access.

Challenges

  • Autorenewals was a new business process requiring careful planning.
  • Designing a user-friendly interface for managing complex renewal rules.
  • Automating notifications and daily payment processing for renewals.
  • Provide a complete management UI for sales team to manage enroll/unenroll processes.
  • Ensure end to end logging for verifying when users enrolled and/or unenrolled for any legal challenges.
  • Safely storing user payment information with integration to the associations PCI processes.

Outcomes

  • Succesfully implemented daily automated process for determining which memberships to renew, processing that payment, updating membership records and notifying the member of payment with receipt.
  • Deployed a web-based interface for the sales and management teams to manage the enrolling and unenrolling process for the member.
  • Increased membership retention across the association.
  • Integrated enrolling process into the member join application as well as the member portal.

My Role

Sole Architect, Developer, Trainer and maintainer for the application and its attached infrastructure throughout the entire lifetime of the project. Met with executive, director and management teams to plan entire process and what tools would been needed for managing the process. Developed the application from inception to deployment. Maintained contact with management and end-users to gather feedback and implement improvements.

Notes

The internal management application was developed as a stand-alone application. After 2 years, it was integrated into the Call Center application so the sales team would not need to switch between different applications to serve the member's needs.

Tech Stack

.NET Framework 3.5 - 4.8 ASP.NET MVC C# Microsoft SQL Server