Case Study Info Portal for Investment Banking, Equity and Venture Capital Experts
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client Requirement
This system will provide an online Deal Community Platform which is a marketplace for buyers and sellers with unsurpassed knowledge and human capital management for today’s deal flow environment. It is a platform enabling Investment Bankers, Private Equity Firms, Venture Capital Firms and Lenders to connect and collaborate on deals that are in the sale or capital raising process.
It’s an online portal for the exchange of information and the discussion related to various deals. There are mainly following types of entities which play a major role in this platform: • • • • • • •
Investment Banks Private Equity and Venture Capital Firms Multiple linked Portfolio Companies Corporations Multiple Linked Subsidiaries Lenders Multiple linked Active Portfolio Companies
Investment bankers play a role of the seller to promote companies they are selling or raising capital for. The system allows investment bankers to intelligently target buyers for their deals and then to connect with those buyers and execute the deal process using this platform.
Private equity companies will list their “Portfolio Companies” which also plays a major role in Deal Matching Algorithm. They will contribute to the Deal Matching Algorithm and this will impact the Deal Matching Score for particular deals that are listed on the platform.
The core objective of the platform is the “Deal”. Investment Bank or Deal broker will push Deals into the system. They need to define Deal details such as Deal size, Geographic preferences, Industries that the Deal belongs to etc. along with the other documents and fact sheets.
IB can define various security aspects of the Deal like who can access what information and at what point depending on the Deal’s Status. They can also set Deal Sharing security settings. They can invite specific buyers by building Buyer list. Buyer list can be built by selecting known potential buyers through a quick search, adding buyers based on an existing buyer list, by reviewing Best Deal Match Scores or through an advanced search for potential buyers. Deals can also be sent to the entire group of private equity firms on the system using the “Listing Service” option.
Project
Challenges
Team faced the following challenges: •
Implementation of WCF Service that communicates with the application and layers.
•
Allowing the site to handle millions of users at the same time without slowing down with the help of load balancing.
•
Developing JSON, Ajax driven site, JQuery with compromising at the performance and execution level.
•
Aspose service implementation with the third-party control application used for creating images for any uploaded file.
various
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
features
without
Page 2 of 2
•
Harmonizing the simultaneous execution of various integrated features and options while maintaining consistent load balance.
•
Maintaining page level performance and overheads since multiple user controls are used on one page.
•
Using Singleton design to use service object in the application.
•
Creating Inbox feature module similar to that of Gmail, Yahoo! etc. in the application.
•
Creating Network Partner module similar to that of any social networking sites.
•
Using Encryption and Decryption for state management to secure data.
Technologies Used Operating System & Server Management
Development Tools & Environments
Windows OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance Microsoft Visual Studio 2010, C#, .Net, WCF, LINQ, Microsoft Visio, Java Script, JQuery, JSON, AJAX, CSS, HTML, SVN etc. SQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Database
Manpower
Project Leader
1
Developers
4
Designers
2
Quality Assurance Testers
2
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
Planning The following N-tier development approach was adopted to equip the site with numerous features and functionality mentioned below: • The Database layer containing SQL Server Database, Tables, Triggers and so on. • The Data Access layer containing the Data Access DLL responsible for accessing data from the database. • The Business layer DLL consisting of all the business logic procedures. • WCF Service layer DLL communicating between layers. • Site Administration, Inbox, Network Partners, My Firms, My Deals etc. • The User Interface layer which forms the Graphical User Interface of the website.
Architecture
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4
Development Highlights The design approach was built around Visual Studio .Net Framework (2010) and SQL SERVER 2008 due to the Deal of Companies’ nature of the application. Modules like Portfolio Companies, Deal, Firm and Messages were developed in C#.Net such that they can be executed directly from the UI layer. In order to most effectively access the database in an object-oriented context an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner. An intermediary abstraction layer was created for accessing data from the database. Triggers were used only for complex updation and deletion of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the application. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers. Web usability guidelines were strictly followed during development and the interface was made easily navigable through the judicious use of JSON, AJAX, CSS, HTML and Web Server Controls. The site was developed and fully functional within a span of 6 months.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 5 of 5