Self-motivated professional with diverse experience delivering timely, profitable results which consistently exceed expectations. Proven capabilities in understanding complex business requirements, establishing trust with customers and developing high-impact, user-friendly applications within familiar Microsoft Office environment. Technical proficiency with MS Office Automation, utilizing expert VBA/SQL/ADO skills and mastery of object-oriented programming relational database design and development concepts to create superior business solutions. Adept at leveraging full power of application object models and VBA language, including logic flow constructs, dynamic embedded SQL, public private properties, collections, arrays, event sinks, binary operations, enumerations and user-defined types to maximize functionality and performance.
Professional Experience
Application Developer Consulting
Confidential
MS Office Automation/Access/Excel/VBA/SQL/ADO
Developing AOP data gathering and reporting application utilizing standardized Excel user input templates and Access data storage.
Systems Analyst
Confidential
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 and 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 and 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 Lab Process Analysis application for national sales force to automate creation of customized PowerPoint presentations based upon customer laboratory analyzer usage data captured in Excel.
Developed comprehensive pricing database, utilized by Marketing, Inside Sales and Contracting Departments, eliminating the need to rely on unreliable pricing data from disparate sources.
Awarded 40,000 in unscheduled, discretionary bonuses for exceptional performance.
Elected Molecular Diagnostics Internal Support Partner of the Year by national sales force.
Application Developer Consulting
Confidential
Access/VBA/SQL
Developed application for statistical and trend analysis of health insurance claims.
Confidential
Access/VBA/SQL Remote
Developed application for evaluation and prioritization of global mining sites.
Confidential
Excel/VBA/SQL Server
Developed application to advise corporate customers of optimal rate plans based on historical usage.
Confidential
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 and 10,000 lines of VBA.
Confidential
MS Office Automation/Access/Excel/VBA/SQL
Developed application to aggregate and monitor worldwide manufacturing environmental impact data.
Visual Basic 6/SQL/Oracle/Toad
Maintained and enhanced existing Supply Chain application.
Confidential
MS Office Automation/Access/MapPoint/VBA/SQL Server
Developed application to maximize job scheduling, tracking and billing efficiency.
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.
Database Analyst
7
Confidential
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.
Senior Caseworker
Confidential
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 Dept.
Privacy Policy
