Aspire Case Study
Financial Services
Folio Manager Client and Online Service
The Client
Aspire LLC – Calabasses, California
The Business Challenge
When a person deals with large amount of buying and selling of stocks, the tax paid
on them becomes an important aspect. This client wanted to implement a solution
wherein based on when the stocks are bought and sold, it suggests tax optimizing
techniques.
The Solution
The solution built for the Aspire “Folio Manager” has primarily two
parts. One of them is the Excel Smart Client application where the user can play
around with the various lots owned of a stock (what is owned of a stock –
maybe reword it). This application will show the tax consequences for the proposed
sales and buys. The second is the website portal where users can login and get their
securities data from various feeds. The Excel application is also used to view/edit
the information of different lots of a security.
The Results
- Tax optimization based on proposed sales and buys
- Scalable performance so as to handle 30000+ simultaneous users
Technologies Involved
Microsoft Office Excel 2007 (for Smart Client), .NET Framework, C#, ASP.NET, Web
Services, SQL Server 2005.