Client: Sells membership management software services to clubs, gyms, etc.

Project: Develop administrative web pages.

I worked as part of the TriSystems, Inc development team providing software services to Booking Plus.

The existing system was a poorly cobbled together mess of poorly designed database tables and poorly designed software.

The challenge was to understand the existing system, design and develop new administrative web pages that fit within the existing system without breaking the database and software.

Due to the numerous challenges encountered and problems solved on this project I understand C# and ASP.NET to a far greater depth than the average .NET developer. I'm sure I could write several "How To..." articles on C# and .NET.

• Server Controls

  I designed numerous sophisticated server controls.

• DataGrid - Sophisticated Use

  DataGrids supported opening subforms within the DataGrid form.

• Database Workarounds

  The previous developer created poor database designs. This necessitated creating sophisticated workarounds when updating and inserting records in the database.

Project Length: 12+ months (concurrent with other projects).

Software Metrics:

• 40+ User Controls (ASCX)
• 10+ Server Controls
• Numerous Web Pages (ASPX)

Tools: C#, ASP.NET, Sql Server, Html, JavaScript

Client: Non-profit for the communications industry.

Project: Design and develop a web application for Namic's Mentoring Program.

Namic provides a mentoring program to individuals in the communications industry who desire to improve their skills to achieve career goals. The web application allows Namic to match potential candidates with mentors and to track their progress during the mentoring session.

The previous version of the software and database for the mentoring program was poorly designed. The web application contained many bugs which made the application unusable.

I interviewed Namic staff to determine their goals and wrote a detailed project specification with Use Cases and project objectives. I then designed and developed a new database and web application to meet those objectives. The result is a working application.

• SQL Server Stored Procedures

  I created 170+ SQL Server stored procedures to access the database. All database access is through the stored procedures.
  

• Server Controls

  I created a set of Server Controls to handle asking questions and collecting answers in a uniform manner.

• Matching Algorithms

  I designed a set of complex stored procedures to match candidates to potential montors. The stored procedures computes a score based upon eight criteria.

Project Length: 6+ months (concurrent with other web projects).

Software Metrics:

• 43 User Controls (ASCX)
• 10 Server Controls
• 33 Web Pages (ASPX)
• 71 SQL Database Tables
• 170+ SQL Server Stored Procedures

Tools: C#, ASP.NET 2.0, Sql Server, Access, Html.

Client: Assists non US residents in applying for the US Green Card.

Project: Original developers botched project delivering a non-working application. We completely redesigned and created new application and database tables from scratch. Handles online applications, credit card processing, uploading of photos. Almost 100,000 applications processed (17-Mar-2004).

• E-Commerce

  E-Commerce support for processing credit cards. Designed to prevent excessive submissions which reduces client's transaction fees.

• Credit Card Fraud Filters
  • Country filters checks for countries with a high incidence of fraud.
  • Credit number filters checks for bad credit card numbers.
    
• Multi-Language Support

  Multi-language support for six languages: English, French, German, Italian, Portuguese, Spanish. Flexible software design allows for easy addition of new languages.

• Discount Code

  Customers can receive discounts by keying in discount codes at credit card payment time.

• Search Engine Sales Tracking

  Client can track sales from different search engines.

Project Length: 36+ months.

Software Metrics: 263 ASP files, several dozen database tables.

Tools: ASP, Sql Server, Access, Html.

Credit Card Payment Gateways: VeriSign, Ginix, EPoint, SmartPeople

Client: Dr. Mead provides relationship workshops to singles on how to find the best mate.

Project: We designed and created a web application that allows users to rate potential mates to determine compatibility. Includes online credit card processing.

Tools: C#, ASP.NET, Access, Html

Credit Card Payment Gateways: Concord EFS.

Client: Writes and publishes a print magazine on advertising in the financial arena.

Project: We designed and created web application and Access front end to display articles, register readers, interface with Paypal for subscription signup to print edition, display industry firms profiles, etc.

Tools: C#, ASP.NET, Access, Html.

Credit Card Payment Gateways: PayPal Magazine Subscriptions

Client: Provides high quality transportation to busy executives.

Project: What is the closest airport to a given zip code.

I created a C#, ASP.NET 2.0 application to screen scrape airport codes from a web site and output the airport codes to a new spreadsheet.

Tools: C#, ASP.NET 2.0

Client: Sells Banner Ad Management Software named Central Ad

Project: We created a web application to manage and display ad banners.

Tools: C++, Html.

(See "Search for Capital and List Capital Sources")

Client: Provides financial advice to businesses.

Project: We created a web application that allows capital sources to create company profiles of the type of capital they provide. Entrepreneurs search database to find financing for their business.

Tools: PHP, MySql, Html.

Credit Card Payment Gateways: PayPal

Client: Publishes newsletter listing job networking and career development events to about 2,500 subscribers in New England.

Project: We designed a web application that allows event organizers to input their profile, contacts, and event information for publication in the newsletter. Password-protected.

Tools: C#, ASP.NET, SQL Sever

Client: Publishes a directory of local NY Hampton restaurants and food purveyors.

Project: We designed a web application with these features:

• Displays restaurant information by category.
• Use of ASP.NET DataGrid for paging through listings.
• Search Engine Optimization: Dynamic generation <meta> tags using keywords about each food purveyor.
• Recent additions listing on the front page.
• Administrative interface for adding, editing, and updating purveyor information.

Tools: C#, ASP.NET, SQL Sever