July 2002 - October 2002

Web/Windows Order Entry

The purpose of this project was to create an incentive order web site and Windows applications for a major automotive company. Customers who purchased cars from this company with the appropriate conditions were eligible to place an order for a merchandise item. They could place this order on a web site, or via telephone. Other customers were eligible to receive a certificate for service at a dealership. For these certificates, the dealership called in to be reimbursed for the certificate redemption.

I architected the solution for this project. The design enabled the parallel development that was required because of the tight time deadline. The same web services were used to support both the Windows order entry application used by phone representatives and the web site. I personally created these web services in Delphi 6. I also created COM objects to call these web services, which were then used in the ASP based order web site.

I served as design and technical lead, advising team members how to design and implement various portions of the application including web ordering, data import, reporting, and integration with existing systems. The number of developers on this project varied between five and fifteen during the project lifetime.

I also created an OLAP cube and associated ASP based reports to show the number of orders taken by date, time, day of week, etc.

Technology

Delphi Microsoft SQL 2000 ASP
COM XML, XSD Web Services, SOAP, WSDL
OLAP UML  

Tools

Delphi 6XML SpyNUnit
Enterprise Architect