Request Expert

Expert has specialized in the development of Windows and Web-Based business applications. He primarily develops in C#.Net, Visual Basic.Net and ASP.NET. His systems have connected to various back-end database including Access, SQL Server, Oracle, VAX RDB and VAX RMS. He has an expertise in relational database design. Since 1989, he has designed and developed numerous relational databases. The databases have included Access, SQL Server, Oracle and VAX RDB. Expert bought his first PC compatibles back in 1985 and has used personal computers practically every day since then. He has specialized in software development on personal computers since 1995.

Upon completing the Client/Server Development Certification Program, he has specialized in Microsoft Visual Basic ever since. He is knowledgeable with every version from 3.0 to .Net and has developed a wide variety of desktop, client server systems and web applications using practically every aspect of the language, including classes and collections, custom DLL and user control.

Expert has used many third-party tools including Crystal Reports, Active Reports, Infragistics Grid, Wise Installer, Install Shield, Spread OCX. He has developed on Windows 95 through Windows 2003 since their inception. He can advise clients on the use and tuning of Windows; however, he does not claim expertise in the internal workings of Windows. Expert has an expertise in relational database design using SQL. Since 1989, he has designed and developed numerous SQL databases. The databases have included Access, SQL Server, Oracle and VAX RDB. He has worked on Microsoft's SQL Server database since 1996. His experience has included managing databases and writing complex stored procedures.

Expert has over 30 years experience designing, developing and supporting business application software. He can function as a project leader, systems analyst and programmer/analyst depending on the needs of the client. He is experienced in all phases of the development life cycle. These include systems analysis; functional and technical design; coding; unit testing; system and acceptance testing; documentation; installation; and training. He can provide individual or group technical training.

He is comfortable working in all application areas. He is especially experienced in the following application areas: banking, order processing, inventory, financial, securities, advertising, direct mail, manufacturing, medical and sales.

Expert was recently brought in to convert his client, a major job matching company, from one source control system, Source Safe, to another, Perforce. He administered Perforce and training and support about 175 users. His goal was to simplify the administration of Perforce. While the Perforce administration initially took almost full-time, he began working on a two-fold plan to simplify the process.

The first part was writing additional documentation. The documentation supplied by vendor was inadequate to meet the client's needs, so he developed additional documents. These included an Installation Guide, Getting Started and Tip & Tricks. When a user had a question, he could point them to one of these documents.

The second part was to automate the process of administering the product. He replaced a series of complex command line procedures with a simple and easy to use Windows based menu. The technical tools we used were Perl, Visual Basic and ASP. After six months, the Perforce administration was taking just a few hours a week. An in-house person who does not need a technical background now does it.

He designed and developed a Windows-based application that processed customer comments made on the Client’s web site. Tracked the comments, linked them to customers and automated the sending of email. This application was developed with VB.NET and SQL Server. This client is in the process of converting a Dry Cleaning application from Progress to Visual Basic .NET (Windows-based). He acted as a consultant on .NET and Visual Basic best practices. This includes restructuring the projects, developing custom control and reducing the number of lines of code. The database is MySQL.
Designed, created and implemented a system that allows the client to maintain its clients and proposals. The system allows the client to print proposals and labels and sort and select by various fields. This was a Windows based project written in Visual Basic .Net with an MS Access database.

The second phase was adding faxing capability to this application. The application allows the user to fax proposals automatically, generating a cover page and faxing a document on a schedule to multiple recipients.
Developed a web-based intranet contact management system. The product was written in ASP.NET with Visual Basic code behind. The database was MS SQL Server. Also used the Infragistics grid.
Managed source code for a major internet company. Part of a team that converted the source control system from Source Safe to Perforce. Duties included training and support of about 180 users in the use of Perforce. Developed tools to automate the process of administering and using Perforce.

Benefits to the Client:

Source code is now better organized. It is easier to resolve conflicts among the development groups.

The next administrator will find that the tools that were developed will make managing Perforce much easier.