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.
Involved in the migration of the billing system from Legacy to the Client/Server environment using Visual Basic 5.0 / 4.0 and MS Access 2.0. The design was modified and enhanced to incorporate the new business rules in the system. The data sent as text files from the legacy system is extracted and converted to MS Access tables by a VB routine. The complex billing algorithm was designed depending on the state, region and individual service options. The front end was designed using Visual Basic to look up each account details. A separate revenue table is created in the billing process which is used for reports. History tables are also generated for client side lookup of individual accounts.
The same application has now been developed using Oracle 8.0/7.3 database with VB. The Oracle Objects for OLE are being used instead of JET engine/ODBC. Stored procedures are being used for common processes. A dynamic script is run by SQLLoader from within VB to convert the text files from the legacy system to Oracle tables. The process and error logging is done through SQLLoader as files which are mailed to the administrator on a daily basis. Unlike Access 2.0 here the calculated data is kept in the database and so the front-end has been simplified to look up the data and not recalculate and so it is much faster. The billing procedure is done every night automatically by using the NT task scheduler.
Detailed Description
Visual Basic 5.0/4.0, OCXs, MS Access 7.0, Oracle 8.0/7.3, PL/SQL, SQLLoader, Windows NT, Windows 95
