1) Responsible for designing the architecture and building all three tiers of an Extranet Application. The client tier is built with Visual Basic ActiveX Documents hosted in Internet Explorer. Reports are generated using ASP scripts. The middle tier uses Windows NT, IIS and COM Business Objects. The Database Tier includes Oracle, DB2 and Teradata. This application has a user base of 200 clients, contains 90,000 lines of code, 98 VB modules, 65 ASP scripts and 37 PL/SQL stored procedures.
2) Provided business analysis and built the user interface using Visual Basic for a 3-tier reporting tool. Technologies include Orbix COMet to communicate with a CORBA middle tier connecting to a Teradata database tier. This application has a user base of 1000 clients, contains 26,000 lines of client code and 82 VB modules..
3) Designed and built a Deferred Query Server that runs as an NT service. A client application submits Oracle and Teradata queries to the server. The server parses the queries, submits them to the appropriate database server, processes the result set, converts it into a standard database and notifies the client of the progress.