Bill G.

## BIO **BACKGROUND SUMMARY** Over 25 Years Database Developing and Management Experience.  Application developer for over 15 years. Demonstrations of Effectiveness **Total Enforcement** (Consulting) – Led teams and Developed Middle tier and Data Access Tier along with All SQL Server Data Objects for this Application which is used to manager Police Department records.  This application designed with multiple Police departments input, manages all aspects of a police Department’s Blotter items such as arrests, Cases, Impounds and Personnel.  This highly scalable application handles both the small 10 officer departments to 5000 multi node locations both remotely and on a LAN/WAN. This highly scaleable application uses the following technologies: *VB.Net, [login to view URL], SQL SERV 2000, XML, Web Services, FoxPro, MS Access, EXCEL* **Federal Direct/Lawn Doctor** (Consulting) – Developed web and windows application that allows franchisees to log on and define and track mailing campaigns.  The user is able to upload and/or purchase mailing lists on line to be used to define a mailing campaign based on zip codes, house hold incomes, lawn sizes and certain other demographics.  Once the order was taken a windows application tracked the manufacturing process by interfacing with legacy applications as well as updated the web site real time as to the orders status.  Technologies used included: *ASP.Net, VB.Net, [login to view URL], MS SQL Server 2000, MS Access, Excel, Oracle, .DCOM* **PCI**(Consulting) – Developed Application for Mass mailer to track effectiveness of mailing campaign based on List Source and demographics defined by each program manager.  Application reads barcodes of returned mailings and matches with customer supplied lists. This Industry Specific Application was designed using the following technologies: *VB.NET, .Net Classes, OCR Ascent Capture, MS Access, EXCEL* **Look No More**(Consulting) – Converted Business Objects and Data Tier of MS Access/ASP Application to SQL Server/VB.NET application.  This shrink wrapped application tracked all manufacturing aspects of a business from Ordering of Vendors and Customers to Product specs and Interface with Intuit QuickBooks.  The Shrink wrapped Application was built with the following technologies :*ASP, Asp.Net, VB.NET, [login to view URL], Crystal Reports, SQL Server 2000* **Cliffco Mortgage Bankers**(Consulting/Hosting) – Developed Intranet call center application using List queues to properly distribute call field.  Technologies Used: *Asp.Net, VB.Net, MS SQL Server 2000, MS Access* **MSW LI (**Consulting Hosting) Designed and maintained Member data driven Web Site.  Site Highlighted travel opportunities as well as allowed members to plan and book trips.  Technologies used for this Web site included : *Asp.Net , VB.Net , MS Access, MS SQL SERVER 2000* **BKGCompany****NY**(Consulting)– Moved Existing Reporting and Manufacturing Database application from their existing Visual Basic, IIS, dBase IV to VB.NET, ASP.Net and MS SQL 2000. Crystal [login to view URL] was the primary Reporting tool used.  This application reports on client order status as well as production status of the entire Knitting, Sewing Dyeing and Finishing Departments. Management reports as well as Invoicing and Order follow-up are accessible on their Intranet.  The Enterprise application was built with the following technologies: *ASP.Net, VB.Net, [login to view URL]*, *Crystal Reports,* *Java, JavaScript, HTML/DHTML/CSS, SQL Server 7/2000, and Windows 2000, COM+, COM, DCOM,*