Chilli Mint Mail
Email Campaigns and Subscriptions Service
Commercial web project to create/store/modify and send emails to a managed list of subscribers. Application offers excellent services to hold and maintain subscribers database by various criterias. Software allows customers to create different email campaigns including email, fax and sms facilities. The other important side is comprehensive reports to monitor emails views, clicks, sharing to social networks, displays and clicks from Facebook/Twitter, data overlays to maps, visualization of email links clicks, integration with google maps.
Other parts of project are 4 windows services that send emails and analyze of non-delivered emails, collect statistics, synchronize data. Very important points of application - is a high workload on DB since it operates with huge subscriber’s database (millions of records). To achieve best results in performance different best practice were used, vertical/horizontal partitioning, indexes/queries optimization, full-text indexes, indexed views, latest MS SQL 2008 Server features. To provide the latest statistics 3 windows services were developed to collect statistical information offline and provide it with the first user requests in milliseconds delays. The commercial components is connected with different user accounts and payment per different services.
|Technologies:||MS Visual Studio 2008-2010, MS SQL 2005-2008, MS .Net Framework 3.5-4.0, C# 3.5-4.0, ADO.NET, LINQ to SQL, ASP.NET Ajax, CSS, XHTML, Jquery, Paypal integration, FAX and SMS services integration, Google Maps API, SOAP|
|Client:||Chilli Mint Labs Ltd, United Kingdom|
|Dates:||2008 - 2012|