YMCA - Winston-Salem , NC
Enrollment system
• Built an ASP.NET / SQL Server 2000 enrollment system.
• Worked with a database design team in major overhaul
of an existing SQL Server database.
• Created a very large intranet web application to replace
a Windows application.
• Designed a cookies based system for the saving of state.
• Use of JavaScript to embellish web forms.
Included giving phones and DOB "masks" and providing
fields with focus requirements as requested by the client.
• Wrote a code generator to help build input forms
from given database fields.
• Other elements used in project: Triggers,
stored procedures, SQL scripts (data maintenance).
DTS Reports made from generated HTML that print
neatly for envelopes.
Flow Automotive
In 2003, updated an automotive site with complex searching and near real-time auto data
• ASP.NET (VB.NET), SQL Server 2000
Cookies, Caching (via the ASP.NET Cache object
and output cached pages), user controls,
overloaded methods, web services, OOP, and email
components, XML parsing and writing (including XPATH)
• Designed a system allowing end users
(from the multiple dealerships at Flow) to upload vehicle
images for their location into a SQL Server 2000 database.
These were the vehicle images displayed on the
Flow Automotive website.
• Wrote a program to extract vehicle data and images
from SQL Server. By email and FTP, the data was sent to
AutoTrader and CarFax daily.
• Designed and built a leads management system.
Site visitors sent form based email.
Using SQL Server and Exchange, the program ran at a
specified time interval sending tracked email between the
customer and business.
• Designed and built a SQL Server based roles management
system where hundreds of employees' roles are managed
via an ASP.NET interface.
• Created Traffic Manager - a web based system for tracking
all customer traffic. Traffic includes purchase/trade vehicle
information, customer information and events
(needs analysis, demo drive, etc…) over time.
Users access Traffic Manager with different levels of
permissions (see roles management above).
LLBLGen was used for much of the middle tier.
The Microsoft Data Access Block and some third party
components (such as a pop-up calendar) were used.