IT Development Services

System Architecture

Multi-tiered, enterprise solutions. The schematic below represents a layered architecture I developed for my trading system. It features an Excel client--very commonly used by Front Office traders in many financial institutions--and a stateless C# server containing data import, analysis, statistics, data-access and COM interop layers. The database is MS Access, which limits scalability, but is acceptable for personal use with limited data-centric application demand.

Target platform is .NET 2.0, enabling among other things, use of partial classes.

 

Database Design

Oracle, SQL Server. Stored procedures, DBMS-specific languages (Pro C, PL-SQL). The table structure below is part of my latest Trading System. 3rd normal form reduces risk of redundant or inconsistent data.

 

Web Applications

Like this website: ASP .Net 1.1 platform (via subscribed hosting service), server-side Web-forms with C# code-behind, C#-coded web service for authentication against SQL Server database. Client-side javascript for fast, custom menus.