
Senior .Net and SQL Developer, Expert SSIS architect
Kansas City, Missouri Area

Senior .Net and SQL Developer, Expert SSIS architect
Kansas City, Missouri Area
I am a senior level software developer with nearly ten years of experience. I specialize in internet applications and ETL systems. I have built systems of varying size with the largest being a system that produces $25m in rebate checks annually. I am an expert in .Net and SQL technologies including Integration Services.
I am working on my Masters of Science in Information Security from James Madison University. My goal is to work for the Department of Defense in some way (directly or as a contractor).
HTML / DHTML / CSS / XML
JavaScript / VBScript
ASP / ASP.Net / Cold Fusion
.Net Architecture
C++ / C#
Visual Basic / VB.Net
COM / ISAPI / DLL
Delphi
Strong OOD Skills
Strong Optimization Skills
MS SQL Server (2000, 2005) / Transact SQL / SSIS
Stored Procedures / Functions / Extended Stored Procedures
Access
Windows Workstation Series (9x, XP)
Windows Server Series (NT, 2000, XP)
MS Office / Visio / StarTeam / VSS / Visual Studio
Computer Hardware / Printer Repair
(Public Company; Computer Software industry)
November 2007 — Present (9 months)
■ Fully documented old system for synchronizing Servicing databases across the enterprise. (GUID Sync) This included Visio flow charts of the process and documentation about the inner workings.
■ Wrote a prototype replacement system for GUID Sync that would reduce the over and under matching using SSIS. This included writing several custom SSIS Dataflow components for Address cleanup.
■ Provided ongoing support for old GUID Sync issues while management deliberated how to proceed in replacing the old system.
■ Was part of a team to design a more robust and error free replacement of the Image Extract solution.
■ Lead an effort to evaluate several ASP.Net Component suites for use across the enterprise.
(Computer Software industry)
November 2007 — May 2008 (7 months)
(Public Company; 51-200 employees; Marketing and Advertising industry)
October 2005 — 2007 (2 years)
■ Created automated system for Datacore client H&R Block to process check fulfillment on the Send-A-Friend program. This system processes over $25 million in checks per year. The system was created under budget and made a profit for Datacore.
■ Created several custom SSIS Dataflow components to allow all Datacore developers to use complex data processing tasks easily. At the time of creation the components saved Datacore $74k per year.
■ Took an 11 hour process and recreated it as an SSIS component. The new execution time was 8 minutes. This allowed Datacore to meet a key timeframe for data processing for one of it’s clients.
■ Worked with a team of people to audit Datacore’s business processes in an attempt to streamline day to day operations.
(Government Agency; 501-1000 employees; Government Administration industry)
March 2001 — October 2005 (4 years 8 months)
■ Worked with team to deploy Tidemark, a database application designed to capture and report on Development data. Tidemark replaced multiple other systems and provides a central location for the data. Tidemark spans almost all Departments, each of which had systems that Tidemark replaced.
■ Created several ASP.Net (VB.Net and MS SQL Server) applications to interface with Tidemark’s data and provide advanced features for scheduling, assigning to inspectors, and reporting on building inspections as well as advanced copying of building permits.
■ Developed innovative ASP.Net (VB.Net and MS SQL Server) application to automate the Development Review Committee (DRC) process, a time consuming and complex process, which resulted in elimination of excess paperwork, enhanced productivity and coordinated communication among five (5) departments.
(Government Agency; 11-50 employees; Government Administration industry)
June 2001 — February 2002 (9 months)
■ Performed analysis of user needs to develop innovative Intranet from the ground up resulting in increased overall productivity.
■ Developed and optimized an automated solution for cleaning and importing large flat files into MS SQL Server. Reproduced existing paper reports on Intranet using the imported data.
■ Re-designed and re-developed existing insurance rate calculator to provide enhanced usability and efficiency for the end user.
■ Created solution to consolidate firewall log information received from the firewall via email.
■ Provided training and technical support for Technology Services personnel resulting in ability to effectively enhance and update Intranet, importing solution, and insurance rate calculator.
(Computer Software industry)
December 1998 — June 2001 (2 years 7 months)
■ Developed ISAPI DLLs in Delphi to add advanced features and optimization to an E-Commerce solution.
■ Directed efforts to optimize DLLs which resulted in enabling 20x more simultaneous users.
■ Debugged E-Commerce site (with multiple pages over 1000 lines of code) developed with Cold Fusion to provide enhanced performance and stability.
■ Helped direct development solution for importing flat files.
M.S., Information Security, 2007 — 2009 (expected)
1998 — 2002
SQLTeam.com