Experience

Vital Research

• United States
• Research Services
• 1 - 100 Employee

• Database Developer

  • Nov 2015 - Present

  contract/remote Skills: Relational Database Design & Development/MS SQL Server/T-SQL/Entity Framework/MS Access/MS Office Automation/VBA/ADO/DAO Design/development/maintenance of Access/SQL Server tracking & reporting databases. contract/remote Skills: Relational Database Design & Development/MS SQL Server/T-SQL/Entity Framework/MS Access/MS Office Automation/VBA/ADO/DAO Design/development/maintenance of Access/SQL Server tracking & reporting databases.



Diageo

• United Kingdom
• Beverage Manufacturing
• 700 & Above Employee

• Application Developer

  • Feb 2015 - Jul 2015

  contract (e-Biz Technologies) Skills: MS Office Automation/Access/Excel/VBA/SQL/ADO Designed and developed integrated AOP application, utilizing normalized Access data storage, standardized Excel input templates and dynamic, interactive reporting, improving accuracy and efficiency of budget-setting process. contract (e-Biz Technologies) Skills: MS Office Automation/Access/Excel/VBA/SQL/ADO Designed and developed integrated AOP application, utilizing normalized Access data storage, standardized Excel input templates and dynamic, interactive reporting, improving accuracy and efficiency of budget-setting process.



Roche Diagnostics

• United Kingdom
• Hospitals and Health Care
• 200 - 300 Employee

• Systems Analyst | Sales Support Consultant | Pricing Analyst

  • Apr 2004 - Jun 2014

  Skills: MS Office Automation/Access/Excel/Outlook/PowerPoint/Word/VBA/SQL Server/Oracle/ADO/DAO/SAP Enabled 50% reduction of FTEs required to process $40,000,000 incentive compensation budget with integrated Microsoft Office application retrieving dynamic input from Oracle, SQL Server, SAP and other data sources. Includes 100 tables across multiple normalized Access databases, 75 user forms, 20 class & basic modules, 15,000 lines of VBA. Created $100,000+ annual savings with Molecular Diagnostics Pricing Tool used by national sales force, incorporating Excel user interface with customized ribbon, Access backend and dynamically-created contracting documents. Includes 80 normalized tables, 100 class & basic modules, multiple user forms, 25,000 lines of VBA. Created interactive Excel tools for reporting and analyzing sales and pricing data stored in diverse backend databases. User interfaces utilize familiar drag-and-drop & point-and-click functionality to create custom, on-the-fly SQL statements. Developed Excel tool for U.S. System Launch Task Force to manage customer requirements throughout product launch lifecycles. Incorporates multiple access levels and subscribe/unsubscribe functionality. Adopted as best practice across multiple company divisions. Created interactive Excel Customer Add-On Pricing Guide and Contract Lifetime Value & Assay Addition Simulators to view what-if scenarios and generate MS-Word business cases utilized by corporate leadership to make informed decisions. Developed Account Profiling database to identify target accounts, forecast sales and establish product pricing upon FDA approval. Developed Process Analysis application for national sales force to automate creation of customized PowerPoint presentations based upon customer laboratory data captured in Excel. Awarded $40,000+ in unscheduled, discretionary bonuses for exceptional performance. Voted Molecular Diagnostics Internal Support Partner of the Year by national sales force. Show less



Various Clients (consulting)

• Application Developer

  • Sep 1999 - Apr 2004

  AMERICAN HEALTH NETWORK Skills: Access/VBA/SQL Developed application for statistical and trend analysis of health insurance claims. CATERPILLAR, INC. Skills: Access/VBA/SQL Developed application for evaluation and prioritization of global mining sites. CINGULAR WIRELESS Skills: Excel/VBA/SQL Server Developed application to advise corporate customers of optimal rate plans based on historical usage. GENERAL DRILLING, INC. Skills: MS Office Automation/Access/Excel/VBA/SQL Developed Access/Excel tracking and reporting application to research and monitor work orders, parts and expenses for fleet of 50 drilling rigs. User interface utilizes hyperlinks to allow drill-down analysis of data from any direction. Includes 25 normalized tables, 40 user forms, 10,000 lines of VBA. THOMSON, INC. Skills: MS Office Automation/Access/Excel/VBA/SQL Developed application to aggregate and monitor worldwide manufacturing environmental impact data. Skills: Visual Basic 6/SQL/Oracle/Toad Maintained and enhanced existing Supply Chain application. INTELEX, INC. Skills: MS Office Automation/Access/MapPoint/VBA/SQL Server Developed application to maximize job scheduling, tracking and billing efficiency. Show less



Howard W. Sams/Bell Atlantic

• Application Developer | Market Support Engineer

  • Mar 1997 - Sep 1999

  Skills: Visual Basic 5 & 6/Access/Excel/Word/SQL/Oracle/DAO/XyVision Developed application to extract and convert data from Oracle database views into normalized Access databases for customer review/population, replacing practice of providing customer data via text files. Developed rules engine to validate data and typesetting codes prior to loading of ASCII files into Oracle database, replacing practice of manual validation. Developed system to upload customer-provided data into XyVision paginated catalog files. Show less



Indiana Township Association, Inc.

• United States
• Civic and Social Organizations
• 1 - 100 Employee

• Membership Director | Database Analyst

  • Mar 1993 - Feb 1997

  Skills: DB2/Paradox/Quattro Pro/WordPerfect Developed application to automate processing of SSI awards to clients on behalf of Social Security Administration and Indiana Family and Social Services Administration. Skills: DB2/Paradox/Quattro Pro/WordPerfect Developed application to automate processing of SSI awards to clients on behalf of Social Security Administration and Indiana Family and Social Services Administration.



U.S. House of Representatives

• United States
• Legislative Offices
• 700 & Above Employee

• Senior Caseworker

  • Oct 1987 - Jan 1993

  Skills: Written & Oral Communication/Conflict Resolution Represented Member of Congress in meetings with constituents and government entities. Advocated for constituents in disputes with government agencies, including IRS, INS and State Department. Skills: Written & Oral Communication/Conflict Resolution Represented Member of Congress in meetings with constituents and government entities. Advocated for constituents in disputes with government agencies, including IRS, INS and State Department.