Dan Lampkin Email & Phone Number

Venice, FL, US

Brentwood, Tennessee

Franklin, TN

• Incorporate other application logic and functionality into the SQL 2008R2 database to overtake operations of other teams and departments and to reduce the load from these areas to increase the number of charts reviewed.
• Perform duties as a Team Leader in a matrixed environment to assist the Data Team Director with overall responsibility on the SQL planning and development
• Light Access 2007 and 2010 development. Access is used as a data director/manager.
• Managing resources and training new employees and contractors

Roswell, GA

- Database development and Administration in SQL Server 2005- UI development and maintenance (C#)- Interfaced with all levels of staff and outside vendors for issue resolution- Various aspects of server administration

Franklin, TN

Medicare / Medicaid Data Analyst for Optum (United Health Group)

Franklin, TN

- Assess patients to determine their need for Restorative Therapy, reducing falls by almost 30%- Facilitate the highest level of functioning in various areas of life for patients- Patient documentation in a Unix based system- Pass meds to the Geriatric population at NHC

Greater Nashville Area, TN

- Passed meds to a population of over 1200 prisoners using Allscripts- Provided general medical aid- Electronic patient documentation in Allscripts- Provided emergency service to prisoners

Duluth, GA

- Managed all aspects of the SQL Server backend, development and administration- Imported and staged client data to map and import data into our SQL back end.- Managed / maintained all aspects of the C# web service to connect the UI to the backend- Managed small team of internal and external consultants and various projects- Assisted in administration of.

- Maintained Claims Management System with customization in the SQL backend- Maintained C# utility to import client data into the database using DTS and custom sql objects

Franklin, TN

- Maintained and troubleshot SQL Server objects and data in a heavily data driven environment- Developed / maintained VB.Net applications to assist clinicians providing healthcare services

Franklin, TN

- Maintained SQL backend tables, stored procedures, triggers, views, user-defined functions- Assisted in troubleshooting slow performing processes to tune the SQL code- Created a system to build the database with versioning to keep track of object modifications

Redmond, WA

Developed SQL objects and jobs to integrate and stage large volumes of worldwide data, including Unicode data, from disparate legacy and 3rd party systems, giving the ability to purge legacy systems from use. Developed utilities in C# to build test scenarios for SQL jobs, taking the Severity 1 bug count from over 400 to less than 20 department-wide within.

- Created web-based system for schools to track fundraising orders and accounts receivable using SQL Server 7, VID 6.0 and VB 6.0, allowing teachers and staff to fully manage their accounts online- Developed online marketing campaign system using Windows 2000, SQL Server 2000, DTS, VB6, COM+, IIS 5 and multiple third-party applications- Worked with team in.

- Designed installation manuals for franchise customers that, in conjunction with streamlining and automating the setup and configuration process, saved approximately $25,000 yearly per customer- Installed proprietary systems in truck stops across the US allowing them to 1) fully automate the fuel billing process, 2) reduce the number of credit card.

Wichita, Kansas Area

- Maintained and serviced B-1B aircraft- Worked as liaison between supply and maintenance to assure aircraft mission worthiness, initiated supply cost savings of $250,000 yearly for B-1 Maintenance Squadron- Worked as a liaison between commanding officers and the flightline to ensure aircraft worthiness and war readiness status

Bs/Cs, Computer Science

Nursing Certificate, Licensed Practical Nurse