Summary of Qualifications
•	Microsoft Certified Solutions Developer – 2002.
•	Developing with Microsoft Visual Studio for nearly 8 years.
	DotNet 1.1 and 2.0 – over 7 years developing a combination of: Desktop,
ASP.Net, Console, and Windows Service applications.
	Some experience with multi-threading in a DotNet environment.
	Developing DotNet components enabled for COM Interop for use with VB6
applications.
	Experience in developing multi-layered applications.
	Strong OOP skills.
	VB6 - 3.5 years developing Desktop and Classic ASP web applications.  
	Development of SQL - DTS and SSIS packages.
	Development of complex stored procedures.  Procedures contain try/catch
and transaction/rollback logic.
	Development of relational databases in SQL Server with key constraints
and indexes.
	Development of ASP.Net web application with Crystal Reports.  The
Crystal Reports contain conditional formatting and sub-reports.
	Worked closely with management to create complicated ad-hock queries
against very important analysis data for use with budgets.
	Experienced in utilizing MS Visual SourceSafe and Tortoise Subversion.
•	Thinking outside the box- Offered several suggestions and developed solutions
that have improved efficiency and saved company money.
•	Great team-player as well as able to work alone.
•	Supervisor of a large team in a high-volume call center.


Experience

Software Developer II
August 2007 – Present			Citi				Gray, TN
•	DotNet Console applications for data parsing
•	SQL – DTS and SSIS packages
•	Multi-threaded Windows Service - data import application
•	Report retriever - web screen scraper
•	DotNet – re-usable reporting component

Project History
•	DotNet Console applications - I currently develop and maintain DotNet console
applications for the purpose of parsing data from flat files, filtering results
and adding data to SQL server.
•	DTS and SSIS packages – I develop and maintain DTS packages for moving and
manipulating data across multiple servers.  I am currently migrating several of
these packages to SSIS.  These SSIS packages utilize: SQL Tasks, Dataflow Tasks,
and Variable Expressions.
•	Windows Service Import – I recently developed a multi-threaded DotNet Windows
Service application for the purpose of importing multiple days of information. 
Several threads are started and each thread processes a separate day of data. 
The application monitors the running threads.  Each time a thread completes, a
new thread is created for the next day to be imported.  This application runs as
a Windows Service in the background and greatly optimizes the import process due
to the multi-threading.





Citi - Project History Continued
•	Report Retriever –This application was an idea that I came up with in order to
save me and my colleagues time and effort of manually downloading files from an
Internet site.  This application accesses an SSL site, authenticates, captures
the login token and then utilizes “httprequest” and “httpresponse” objects.  The
application browses the appropriate pages, determines which files are available,
posts requests for the files, and then downloads the files.  The files are
downloaded by capturing the response stream and writing the stream to a
“filestream” object.
•	Re-usable Reporting Component – I developed a DotNet assembly that I have used
in several applications for reporting purposes.  I pass parameters to the
component such as: SPROC name, output filename, tab names (array), zip file
(bool).  The component returns a resultset and writes the results to a delimited
text file or to an Excel flat file over an ODBC connection.  If the result set
exceeds the worksheet line limit, the component adds more worksheets and spans
the data to the additional sheets.


July 2006 – August 2007		Intellithought			Kingsport, TN
Software Developer
•	Claims application stored procedures
•	Data analysis reports
•	Online credit card processor
•	Intelligent Content Manager

Project History
•	Claims application stored procedures - This project involved heavy analysis of
existing claims application.  There were many problems surrounding the
application's reporting results and much of this was due to the application using
many different stored procedures with varying logic.  I was able to combine the
logic of the stored procedures so that the reports only use 3 stored procedures
to perform the same work and it is now much easier to maintain.  Also utilized
Query Analyzer execution plan to apply appropriate indexes for better
performance.
•	Data analysis reports - I have identified and corrected multiple data
integrity issues in the above mentioned claims application.  I discovered the
data issues through testing and running ad-hock queries against the data.  I
provided reports to the client explaining the data issues and corrected the data
as requested by the client.
•	Online credit card processor - Developed ASP.Net 2.0 (C#) pages for submitting
payments online and viewing payment transactions.  The transaction viewer page
utilizes ASP.net membership to authenticate access.
•	Intelligent Content Manager – This is a FoxPro 7 application that tracks
inventions and provides reporting.  Most of what I do with this application is
maintenance.  I have tracked down and corrected multiple issues such as:
corrupted data, object reference errors, data type mismatch, ect.  I have also
modified datagrids and reports in this application to meet the client’s
specifications.
•	We currently utilize MS Visual SourceSafe as our file repository but we are
migrating to Tortoise Subversion.  I am familiar with checking out/checking in
files, getting latest version of code, running wildcard and status searches and
adding files to VSS.  I am also familiar with the basic functionality of
Subversion for checking out files and committing updates.







August 2004 - July 2006		Package Express Centers	Greeneville, TN
Software Developer
•	Management Reports
•	XML Online Tools
•	Automation System
•	Custom Download Files
•	.Net Web Services Transfer Data
•	Ad-Hock Queries on Analysis Data
•	Shipping - VB6 Application

Project History
•	Management Reports - VB.Net web application that utilizes SQL Server databases
and Crystal Reports to deliver client information in a detailed report.  The
report displays comparisons, percentages and summaries of current versus previous
year numbers.  This application utilizes stored procedures to access and format
data that has been transmitted by our clients and uploaded to SQL Server.  This
report uses conditional formatting and sub-reports and is designed in a
multi-layer architecture with the Crystal Reports being populated from a data
access class at run-time.  This report is heavily used and valued by upper
management.
•	XML Online Tools - .Net component enabled for COM Interop.  This is a
multi-component solution that offers online tools to users via XML over the
Internet.  The component guides the end-user through an online registration
process which collects user information, formats the input into an XML document,
posts the XML to a 3rd party and then reports the results.  After registration,
the user authentication information is stored in a database along with a license
key.  The license key is encrypted using the .Net Cryptography class and then
decrypted at run-time for use in authentication for using the Online Tools.  This
solution is accessed from our VB6 application through COM Interop.
•	Automation System - VB.Net console application used for running automatic
processes such as data manipulation, sending e-mail and file manipulation.  This
solution calls a stored procedure once each minute, which checks for scheduled
processes.  Scheduled processes can be scheduled in frequencies of: 1 time only,
hourly, daily and monthly.  This application is currently responsible for
searching through client folders for uploaded files.  If files have been
uploaded, it sorts the files, reads and uploads certain file data to SQL, creates
a “Processed” sub-folder and moves the files to this folder for each account. 
Certain files require that the data team be notified so the application generates
an e-mail containing the account numbers of each account that qualifies and then
sends the e-mail to the team.  This application is also responsible for moving
data from our legacy databases to SQL.  However, I have replaced most of this
functionality with Data Transformation Services and schedules SQL jobs.
•	Custom Download Files - This is a VB.Net desktop application for use in
creating custom files for our clients to download.  The files contain commands
for the software to perform client-side.  This application searches through all
of our client folders for certain types of files.  If it finds these files, it
checks for an existing client download file and edits the file by adding the
appropriate commands.  It also checks any existing download files for commands
that have already been processed.  It then creates a “Processed” sub-folder and
moves and processed files to that folder for each account.
•	DotNet Web Services Transfer Data - This solution will be replacing the
current automated process for uploading user files to SQL Server.  This solution
consists of a Web Services component and a .Net component enabled for COM
Interop.  The .Net component is integrated into our VB6 application and
references the Web Services component.  It will collect client data, format that
data into a stream and then transmit it to the Web Services component, where it
will be verified and then uploaded to SQL Server.  It will then check for any
scheduled processes that have been scheduled on the server.


Package Express Centers - Project History Continued
•	Ad-Hock Queries on Analysis Data - Ran multiple SQL queries against
confidential data provided by management.  The results of these queries assisted
management in recovering a large sum of money.
•	Shipping - VB6 Application - I have been heavily involved with the continued
development of the company’s shipping application that is distributed to our
clients.  This application performs many functions such as: complicated billing
calculations, WinInet API calls for dialing into our servers and transmitting
files, reporting, label printing, registry, ini, and file manipulation and a host
of other functionality.


May 2003 - August 2004		Metron North America		Knoxville, TN
Jr Software Developer
•	ASP.Net Client Reporting
•	Client Order Adjustments
•	Shipment Summary Reports
•	Debugged ASP and VB6 Applications
•	Daily Ad-Hock Queries

Project History
•	ASP.Net Client Reporting – Developed ASP.Net web application for the purpose
of reporting client shipment information in a detailed report.  This application
retrieved and formatted data from SQL Server via stored procedures and returned
the results in a data grid displayed in the web app.  This application required
user authentication and accepted user input for filtering the results.
•	Client Order Adjustments - This was a desktop .Net application utilized for
adjusting client orders.  It allowed the end-user to look up customer orders,
cancel or change the items ordered or reset an order that had been previously
cancelled so that the order could be re-created.
•	Shipment Summary Reports - This was a VB6 application used for reporting
shipment summary information to our clients.  This application pulled detailed
shipment summary information from SQL Server, formatted this information into an
Excel spreadsheet and then e-mailed the resulting spreadsheet to the
corresponding clients.
•	Debugged multiple ASP and VB6 applications.  These issues ranged anywhere from
things like numeric data type overflows to locating poorly formed XML that was
posted between ASP pages.
•	Daily Ad-Hock Queries - Adjusted warehouse orders and other data on a daily
basis via SQL Query Analyzer.  I was often asked to run complicated queries in
order to generate reports for management and other co-workers.  I was also
involved in tracking down very elusive data issues on SQL Server.


October 2002 - February 2003		Bredel Corporation		Tampa, FL
Web Developer
•	Company Website
•	Flash Marketing Piece
•	New Client Website

Project History
•	Company Website - Website was done in ASP.  The original website was not well
formed in terms of structure.  I rebuilt the website from scratch in a much more
manageable format.  I also created a hit counter, added e-mail functionality and
built a back link page with a graph for management to view statistics on how
users found out about their company.  I added a Flash 5 movie that I created to
the home page as well.

Bredel Corporation - Project History Continued
•	Flash Marketing Piece - This marketing piece was done completely in Flash 5. 
It consisted of doors that scaled toward the user and opened to reveal
information about each of the clients under the company “umbrella”.  This piece
also included background music and alpha (transparency) effects.
•	New Client Website - Developed new client website from scratch.  Created
template and utilized server side includes to include the template on each of the
pages.  Also created drop-down menus with JavaScript.


November 1999 - October 2002	Charter Communications	Kingsport, TN
Helpdesk Technician
•	Self-Study ASP and VB6
•	Troubleshoot Internet Issues

Work History
•	Self-Study ASP and VB6 - Utilized time between calls to study VB6 and ASP. 
Earned MCSD in March of 2002 through self-study.
•	Troubleshoot Internet Issues- Walked users through sometimes lengthy
troubleshooting procedures for cable modem, dialup and other general networking
issues.  I worked 3rd shift under minimal supervision.


February 1999 - November 1999	Kyrus Corporation		Kingsport, TN
Systems Engineer
•	Installed Software/Trained Clients
•	Troubleshoot Kyrus Software

Work History
•	Installed Software/Trained Clients - Set up small LAN (usually server and 1 to
4 workstations) at schools.  Trained users on-site for utilizing the Kyrus
software.
•	Troubleshoot Kyrus Software - Answered inbound calls and walked users through
various troubleshooting steps with the Kyrus software.


January 1998 - February 1999		PepsiCo			Winston Salem, NC
Helpdesk Technician
•	Troubleshoot Pepsi Software

Work History
•	Troubleshoot Pepsi Software - Extensive troubleshooting of Pepsi software and
Norand hand-held computers.


March 1993 - January 1998		Citi				Gray, TN
Helpdesk Supervisor
•	Supervisor of High Volume Helpdesk
•	Follett Service Technician

Work History
•	Supervisor of High Volume Helpdesk - Supervised large team of helpdesk
technicians in a high call volume environment.
•	Follett Service Technician - Extensive troubleshooting of Follett software and
other general software and hardware issues.