Frank Coding

To obtain a position that allows me to utilize my extensive knowledge in web/windows application development and database management and design.

Programming Languages

• C#
• MS SQL
• JavaScript
• ASP.Net Web Forms
• Linq to SQL
• HTML

Databases

• MS Access
• MS SQL Server

Servers

• MS IIS

Tools

• Subversion
• TortoiseSVN
• JQuery
• MSBuild
• Code Smith
• Coolite ASP.Net Framework

Jun 2008 – Present Enbridge Energy Houston, TX: Senior Developer

• Rewrote an existing application used to manage and submit FERC Tariff changes.  The existing application that was written did not meet the needs of the department so a new solution was requested.  The new solution was a complete rewrite which took careful consideration for the departments requests, the major being a faster and less processor intensive packaging module.  To accommodate the department’s primary concern, the new solution was designed with a separate packaging module which ran on its own machine, allowing users to submit package’s without using their machines for the processing.  Another highlight of the project was tight integration with MS Word and the solutions to the challenges of working with the MS Word API.
• Developed a data warehousing solution for point in time reporting of FERC data. The requirement was to provide a consistent look and feel for all reports and display accurate data at all times to the end users. The existing solution used classic ASP pages and stored procedures to query the data sources real time for each request. This was unacceptable due to the fact that there was no way to provide accurate historical reports, any changes in the live system would be seen immediately causing reports run at different times for the same date to have different results. The solution was to use MS SQL Reporting Services to display the report data and use a custom C# application that ran on a timer to extract the data from the various source systems into a single SQL database. The custom application was designed in such a way that it allowed for easy maintenance of adding and removing source system queries.
• Rewrote an existing application used to manage and send FERC eNotices. The requirement was to upgrade the existing classic ASP solution to .Net. The original system fell short in many areas but most importantly was auditing. For each notice created, numerous email alerts were sent out to external users. Due to the lack of audit logging, there was never a clear answer to the question: “Why did I not get my email alert?” The replacement system was designed from the beginning to capture a log of all correspondence generated automatically and provide a simple interface to accessing this information.
• Provided support for numerous classic ASP applications that had accumulated over the years.

Jan 2008 – Jun 2008 CEVA Logistics Houston, TX: Senior Developer

• Developed and maintained a VB.Net windows service which managed automatic email updates about shipment statuses. Also developed a management page to allow users the ability to subscribe to shipment alerts in various ways.
• Developed and maintained a VB.Net web application which allowed external customers a tool to validate delivery driver’s credentials. The application provided a searchable list of drivers and a detailed view of each driver which displayed a picture and location information. Internal employees were allowed to maintain the detailed views via management pages. The application consisted of a VB.Net web site and an SQL 2005 database.
• Developed a custom framework around the .Net 2.0 Web Parts Framework using user controls. The project required a more Google web part user experience instead of the standard SharePoint layout. This was accomplished using custom web part chrome and editors. Another requirement of the project was to make future part development easier so a base class and custom web control were created to hide the complexity of web part development.

2005 – 2008 Novasys Technologies Inc. Houston, TX: Senior Developer

• Maintained and enhanced a VB.Net web application used by Harris County to track grant allocations to qualifying HIV clinics around Houston. The system was written in 1.1 VB.Net and it consisted of a three tier architecture using a web service for data access. All data was stored in a Microsoft SQL 2000 server database. Duties included troubleshooting and resolving existing bugs in the code and adding new functionality.
• Developed and maintained a VB.Net/C# web application used to collect HIV patient information and upload it to the Harris County application above. The above application did not allow the storage of client confidential information so this solution was created and sold to interested clinics promoting the fact that it could securely store client information. The system was written in 1.1 and upgraded to 2.0 in 2006. All data was stored in a Microsoft SQL 2000 server database. Duties included troubleshooting and resolving existing bugs in the code and adding new functionality.
• Created a C# 1.1 Outlook Add-in and web service solution that utilized the calendar and tasks list to perform appointment scheduling and timesheet tracking. The system was designed to compliment the above application allowing scheduling of HIV patient appointments to public/private outlook calendars. Appointment details and history was tracked in an SQL 2000 database. Several crystal reports were created to display the data.
• Rewrote an existing MS Access product that tracked bank account overdrafts. Performed 85% percent of the development and design work on the project. Re-architected and upgraded the database to a Microsoft SQL 2000 server implementation. The main application was written in C# 1.1 as a winforms front-end with separate assemblies for data access and import/export routines. The client sold this software to credit unions and banks across the United States. The initial rollout for this version was 200+ installations.
• Created a loan tracking web solution in C# 2.0. The client required detailed tracking loan status history. The tracking data collected was used to provide monthly volume reports and assist during yearly FDIC and internal audits. A feature to note was a seamless comments system that allowed loan processors to send emails via a web page to loan submitters. One the submitter reviewed the note they too would be allowed to reply to the processor via a web page which would automatically email out updates. The entire thread was captured in the database and could be view from the loan details screen.

2002 – 2005 Sterling Bank Houston, TX: Workflow Developer

• Solved a problem where a small number of image files were scanned at a higher resolution, which in turn caused a larger file size, by creating a C# application that programmatically reviewed all the files and resampled them if necessary. The application looped through an ADO.NET dataset of file pointers retrieved from an SQL database table. It used the pointer to open each file using a open source image library. Once opened, file size tests were performed and if necessary the file was resampled to a 1bit black and white tiff image. The original file was backed up before the conversion to a separate directory for easy restore. The application processed 106,195 files, it converted 6,782 files. Using this automation saved the company 452 hours of work (based on a 4 minute rescan time per file).
• Created a suite of applications using Visual Basic 6.0 that replaced and extended the current Visual Basic application for tracking paper files that have been imaged. The new application provided a workflow to track the monthly processing statistics as well as a offsite file tracking system. After the workflow was implemented a second module was designed that streamlined the auditing of scanned documents. The module interfaced with our document imaging vender’s product and displayed the scanned images to be reviewed before they were added to the system. Through the module, users were able to alter or rearrange the images in a batch. This increased department productivity by 38%.
• Using ASP pages and JavaScript created a simple tracking system for loans being processed. The system utilized an SQL database for data storage. Designed all the tables and Crystal reports which provided tracking stats for management.
• Designed a supporting application for the above tracking system which allowed management to maintain all data in the database. The application utilized VB.Net, ADO.net, and ASP.net pages. All data access was accomplished using stored procedures.
• Using VB.net created a helper application for the tracking system above that preformed emailing functions. The application used ADO.net to retrieve a dataset of email messages which it loop through and sent out. As it sent out messages, it would flag and timestamp the message as sent.
• Designed and developed a PHP application for creating coversheets as a replacement for the desktop visual basic application for creating document coversheets above. The application used a zero footprint; it utilized PHP functions for retrieving data from an MSSQL database and heavy client side JavaScript to perform the multiple dropdown filtering.
• Designed a C#/ASP.net application to automate the process of passing exception documents from the document imaging department to the exceptions department. The application allowed automatic recognition of flagged coversheets for display to the exceptions department in work queues. The system utilized ADO.net and stored procedures for database access. The database was designed in MSSQL.

2001-2002 Woodforest National Bank Houston, TX: DBA/Developer

• Maintained a visual basic application that provided IVR services to bank customers.
• Developed Crystal reports for the ATM host system that assisted in balancing over 150 ATMs.
• Created an application for balancing wire transfer requests that leveraged visual basic 6.0 and an MSSQL database.

2000-2001 Sterling Bank Houston, TX: Helpdesk Manager

• Managed 6 employees, was responsible for budgeting salaries, approving vacations, and performing quarterly and yearly reviews.

Spot a Stray

Own and operate the web site www.spotastray.com. As a solution to a personal problem, this website was developed to allow visitors to post pictures of lost and found pets as well as stray animals they may have spotted in the neighborhoods. It boosts some unique features such integration with Google maps for location aware postings and printable flyers which utilize MS Reporting Services.

Rescue Assistant

Own and operate the web application www.rescueassistant.com. After volunteering with animal rescue groups for years I have created this site to help them become more organized.