Dennis Hatcher

Partnership; 51-200 employees; Computer Software industry

December 2005 – July 2009 (3 years 8 months)

--Developed a PDMA Part 141 compliant application using Visual Basic.NET 2005 and SQL Server 2005 that allows pharmaceutical sales representatives to enter samples dropped off to a prescriber and to obtain an electronic signature using the Microsoft.Ink capabilities on a Tablet PC. The app is a thin client that utilizes ClickOnce technology for deployment and any upgrades that are published. Prescriber demographics are downloaded to the Tablet by consuming a web service written in Visual Basic that will queries a SQL Server 2005 database and returns the data as XML. After the transaction is recorded, the application encrypts the signature/sample data and then posts the data back to the central servers using the web service. Once processed, the data is then available to the Corporate Home Office through a series of SQL Server 2005 Reporting Services reports and through a Server 2005 Reporting Services report model for any Ad-Hoc reports. Other Server 2005 Reporting Services reports are available to the field representative through the Sales Force Automation website written with ASP.NET and Visual Basic.

--Developed a series of Excel reports that utilized data visualization through a series of charts using Visual Basic. These reports are customized for each geographical territory, district, region, and a national report. These reports were later modified to include the data in table format as well.

--Designed and developed a data mart that platforms IMS Xponent Plan-Track data using SQL Server 2005 as a backend and SQL Server 2005 Integration Services for ETL. I then designed the Business Objects Universe for the Web Intelligence front end. I also trained internal users in Business Objects in order for the QC team to verify the data load routines.

--Maintained two SFA websites that implement ASP.NET with Visual Basic code-behind, as well as designed and maintained an e-Delivery website that was also written is ASP.NET with Visual Basic as the code-behind.

Privately Held; 201-500 employees; Marketing and Advertising industry

January 2005 – December 2005 (1 year)

--Developed various MS-SQL stored procedures for various functions pertaining to NAA's Customer Service application, automated report applications, and billing packages.

--Authored a set of class libraries (using the namespace NAA) in Visual Basic.NET to standardize common functions for the future generation of NAA applications in which I was developing.

--Designed and maintained several MS-SQL DTS packages to transform data from various telephony application's log files and data, downloaded from some of NAA's partners, to be inserted in to MS-SQL tables or into MySQL tables using linked servers.

--Wrote a variety automated applications to pull data from log files or downloaded files and process the data for reports that will be used by management.

--Designed a generic automated application template in Visual Basic .NET for any future applications that NAA needed to run at a specified time, process data, generate any logs or reports needed, email the reports, and terminate after processing.

September 2004 – January 2005 (5 months)

--Looked into FMI's use of technology and how it could be utilized to a greater efficiency.

--Designing an enterprise database solution (SQL Server and Visual Basic .NET) to expedite to flow of information throughout the organization.

--Prepare client's data and created output for production.
Setup layouts for cut sheet printers.

Privately Held; 1-10 employees; Information Technology and Services industry

July 2004 – September 2004 (3 months)

--Development of Visual Basic .NET, MSDE registration application for a Teknaspan client.

--Maintain various client's computers and servers throughout the greater Philadelphia area.

--Consulted clients on greater network efficiency, buying computers, and answering various questions that might arise throughout these decisions.

January 2002 – June 2004 (2 years 6 months)

--Completed Internet Application using West-Wind Web Connect that allows members to place, receive, track orders, and view account information. This was an application built upon a legacy FoxPro database.

--Re-designed Florists' Interlink business application using Visual Basic .NET and MS SQL Server 2000.

--Generated Crystal Reports for the Management Team to view real-time statistics of the day's transactions

--Developed interface for Windows Mobile 2003 application for Interlink's sister company, Red Goose Deli, for an order entry system using Visual Basic .NET Compact Framework.

--Managed various projects as the business systems evolved and as new technology became available.

--Researched new technologies in order to offer the best and most efficient tools on the market in order to help Florists' Interlink to be productive and successful in today's market.

--Enhanced and tested applications based on Florists' Interlink business rules using existing FoxPro database, migrated said database to MS SQL Server 2000.

--Controlled Windows NT 4.0 server and LAN domain, upgraded to MS Windows 2000 Adv. Server. Instead of using the built-in migration tools to migrate the Windows NT4 PDC into Windows 2000, I recreated the organizational structure in the new Active Directory server in order to 'clean up' the structure.

--Maintain two Web domains, one web server, two fax servers, three websites and one proxy server.

--Customized Panasonic PBX and Voice Processing System.
Troubleshoot workstations used in office.

April 2001 – August 2001 (5 months)

Debugged Tiger's custom built software and updated the Visual Basic 6.0 code as deemed necessary.