Over twenty years of rigorous experience as System Architect and developer in the Financial Services, Multi-Media, and communications applications. Thorough in .NET, Visual Basic/MS Access/Visual Interdev, SQL Server, MySQL and Oracle environments. Strong in server based development using stored procedures and triggers. Sound foundation in Windows architecture and systems programming. Conversant with relational database design methodologies and tools. Work experience involves extensive development in all aspects of the software development cycle. Excellent team and communication skills.
Designed and developed a Intranet solution for Global Broking Tracking System. This system is used to obtain premium flow to carriers. It is useful to the business placed by Marsh in terms of being able to provide benchmarking information about the business placed by Marsh and to provide a method of tracking performance of GB employees as well as the groups/companies with which Marsh did business. It can also track mid-term changes to policies. As the Lead Architect, my responsibility was in designing the system. The system implements ASPs written in Visual Interdev 6.0. The business logic and data access objects are handled by a COM middleware written in Visual Basic 6.0. Some amount of presentation layer logic is also written as COM objects to speed up lengthy executions. This middleware provides specific objects, properties and methods to be used by the ASPs and is run through the Microsoft Transaction Server which takes care of connection pooling to efficiently use limited number of connections. I have also done a fair amount of IIS administration for this project. I have set up the complete web site, created packages for the COM middleware and set up identity/transaction support for the package/components. Remote Scripting and DHTML have been widely used to optimize user interaction. Login security is enforced to prevent unauthorized users to either login or view/change information at different levels of the system. The web system is run on IIS 4.0/NT and the backend is Oracle 7.3/Unix. Some reporting has been designed for MS-Word in which the data is brought into a macro from an ASP through XML. Then it is put in a DOM and used to populate the Word document. On the back end, wrote stored procedures which were called by the middle tier and also ran as batch processes every night to take care of expiring policies. A separate SQL Server system was also used for testing purposes to check the feasibility of changing the database to SQL Server from Oracle. COM+ has been used on this test platform with the intention of migrating the project to Win2K.
Detailed Description
Visual Basic 6.0, Visual Interdev 6.0/ASP, Active X COM/COM+, OLE DB for Oracle, ADO 2.5, Oracle 7.3, PL/SQL, Win NT/95, IIS 4.0/PWS, MTS, DHTML, Remote Scripting, XML, SQL Server 2000
