Client: Profusion.com

Problem: Client wants to sell products to customers as a private label seller.

Project: Create sign-up form for discount buyers club.

Designed and created an ASP.NET application to:

• Collect and validate customer's contact and credit card information.
• Add customer to shopping service customer database.
• Email customers contact information to site owner.
• Submit credit card transaction to Authorize.Net.
• Redirect to sellers web site so customer can view and buy products.

Client: (Confidential, Same client as below.)

Problem: Client receives medical claims data in CSV format from an health insurance provider (#1). Client needs to generate reports based on the medical claims data.

(Note: Client receives medical claims data from two (2) different sources. The medical claims data files from these sources have completely different formats therefore the two separate projects.)

Project: Create application to import medical claims data into a dataabae and create reports.

Reviewed sample CSV data files and CSV data file specifications. Asked questions and suggested changes to health insurance provider concerning problems with the CSV data files.

Currently, waiting for health insurance provider to answer questions and correct problems with CSV data files.

Project expected to be implemented in ASP.NET 3.5, C#, Linq, and Sql Server 2008.

Client: (Confidential)

Problem: Client receives medical claims data in fixed format ASCII data files from an health insurance provider (#2). Client needs to generate reports based on the medical claims data.

Project: Create Access application and SQL Server database to import medical claims data into a database and create reports.

• Designed SQL tables to store the medical claims data.
• Designed VBA code to parse and import medical claims data files into a SQL 2008 server database.
• Wrote SQL stored procedures, table-valuded functions, and scalar-valued functions to collect data for reports.
• Modify Access reports from older version of application to work with new SPs.

(Due to confidentiality reasons I am unable to publish the client's name or web site.)

Problem: ASP.NET Web Project with Poor Design and Coding

The original developers created a poorly designed and coded ASP.NET web application. I inherited the web project and receieved a list of about 50-60 bugs. I was requested to fix these bugs.

I reviewed the software and wrote a report describing the systemic design and coding problems in the software. A short list of the problems include:

• In-line code to populate drop down lists instead of custom user\server controls.
• In-line SQL statement composition leaving app open to SQL injection attacks.
• Poor database table design.
• Google Map feature not working.

See Common Design and Coding Problems in ASP.NET Applications for more problems.

Performed extensive redesign and recoding of major sections of the web project.

• Revamped many database table designs.
• Created many ASP.NET User and Server Controls to replace poorly designed code in the project.
• Redesigned poorly structured code sections.
• Redesigned Google map feature and made it work.
• Wrote code to generate XML feed.
• Revamped featured home function.
• Revamped credit card processing function.

(Due to confidentially agreements I am unable to publish the client's name.)

Problem: Client needed to extract financial information from a large number of compressed human-readable reports stored on nine (9) CDs.

Project #1: Research Compression Format

The financial reports were compressed in an unknown format.

Researched the compressed report formats, decompression methods and tools needed to decompress financial reports.

Discovered the compression format used for the reports.

Wrote an ASP.NET C# web application to decompress a single report.

The client wanted the financial data extracted from the reports and imported to an Access database. The financial reports were in human-readable format which did not lead itself to easy importing of the data to Access.

• Wrote software to walk through all report files in a folder and decompress the reports.
• Designed an Access table to store the financial data.
• Wrote software to parse the data fields from each report and write the data to Access.

Client: Provides booking and reservation systems to busineses.

Project: Create web application to:

• Update member information:
• Contact Information
• Employment information
• Emergency Contacts
• Interests
• Display "families" of members.

The project used the these Microsoft Ajax controls:

• UpdatePanel
• Ajax Tool Kit TabContainer
• Ajax Tool Kit ConfirmButtonExtender
• Ajax Tool Kit AutoCompleteExtender
• Ajax Tool Kit ModalPopupExtender

Client: Startup providing networking solutions.

Project: Create web application to:

• Allow user to enter tags, description, first name, last name, and email.

The user interface was created using Microsoft Ajax technology. The user interface allows the user to click on the data entry panel and the software auto-adds in a new records (instead of forcing the user to click on an "ADD" button).

The project used the Microsoft Ajax UpdatePanel control to display multiple records and for updating the display when the user clicked the UpdatePanel to add a new record.

The user interface with Ajax presented challenging design problems which required innovative and creative solutions.

Client: Raises awareness of Katrina and Rita disasters and the need for continued funding and assistance.

Project: Create web application to:

• Display links to resources;
• Display articles;
• Display resources for political action;
• Display book information;
• Display interview articles;

Ajax Tool Kit COntrols used in this project:

• CollapsiblePanelExtender

Client: Provides discount theater tickets to students, teachers, etc, sponsors theater workshops for students.

Project: Create web application to:

• Display trips sponsored by TDF.
• Display theater shows.
• Allow users to search theater shows.
  Extremely sophisticated search function. 

Created an administrative control panel to allow admin personnel to:

• Enter trip information.
• Enter theater information.
• Enter theater show information.

Client: Provides US Green Card services to foreigners seeking a green card to enter the U.S.

Project: Update web application:

• Convert account login area to ASP.NET 2.0.
• Add ability for users to subscribe to the service for multiple years.
• Move web site application to new server.

• Display Upcoming Titles
• Display News Items
• Display Author Web Sites
• Display Links to Reading Group Guides
• Display Awards
• Display staff bios.
• Allow users to perform simple or advanced searches for books.