Eric H. Email & Phone Number

Frederick, Md, Us

Supported contract activities for technical configuration documentation (TCD) development and maintenance. Also supported contract maintenance of multi-user front-end/back-end equipment databases. Integral part of collaborative developer team that maintains and enhances VBA based automated Microsoft Visio technical configuration documentation (TCD) application through full software development life cycle (SDLC). Supports dozens of end-users and hundreds of varied diagrams, as well as… Show more Supported contract activities for technical configuration documentation (TCD) development and maintenance. Also supported contract maintenance of multi-user front-end/back-end equipment databases. Integral part of collaborative developer team that maintains and enhances VBA based automated Microsoft Visio technical configuration documentation (TCD) application through full software development life cycle (SDLC). Supports dozens of end-users and hundreds of varied diagrams, as well as linked and automated Microsoft Excel data repositories for equipment and configuration data. Developed test plans and software documentation to support new releases of TCD code modifications. Designed VBA code to automatically upgrade VBA code in older workbook template versions. Assisted with management and maintenance of SQL Server back-end/Microsoft Access front-end database application for government IT assets. Managed database structure, user access, server maintenance and exception reporting. Show less

Fort Detrick, Md

Key player in the MMESO program from its inception. Built overarching MMESO data functions, objects and operations flow from scratch. Program leader and significant contributor in building and refining the standardization process flow.• Lead and provided functional oversight to a team of Data Analysts to ensure high-quality, continuous delivery of complex data-driven standardization actions. • Designed, developed, implemented, and managed program-wide data structure, schemas, databases,… Show more Key player in the MMESO program from its inception. Built overarching MMESO data functions, objects and operations flow from scratch. Program leader and significant contributor in building and refining the standardization process flow.• Lead and provided functional oversight to a team of Data Analysts to ensure high-quality, continuous delivery of complex data-driven standardization actions. • Designed, developed, implemented, and managed program-wide data structure, schemas, databases, ETL processes, data feed specifications, governance, quality assurance checks and data related process flow through database application automation. • Designed and developed enterprise reporting using Microsoft Access/VBA and SQL based queries to meet contract deliverables and provide executable information to varying audiences. Dashboard reports in PDF format were distributed to all stakeholders to assist in conversion to standardized products and reducing expenses. Resulted in a 25% increase in standardization incentive agreement compliance rates in the first year and $300M+ in cost avoidance for the DoD over 10 years.• Converted a previously manual labor and data intensive market research process into an automated input/output platform within a Microsoft Access/VBA database application. Facilitated and expedited the research process by providing clear review, input, and data consolidation pathways. Allowed users to more efficiently review/enter/modify data, reducing market research process timeframes by 33%. Progressively enhanced database application to include end-to-end standardization process flow, including automated Excel workbook and Word doc build for formal leadership approval, minimizing copy/paste and formatting errors while shortening the document build time from hours to minutes.• Collaborated with analysts across the program to gather requirements for further process efficiency.• Streamlined standardization candidate reviews with Access/VBA database application Show less

Fort Detrick, Md

Developed and implemented data architecture, automation, analyses and reporting processes to standardize National Stock Numbers (NSNs) for medical supplies used in deployed military assemblages across all military services. • Collaborated with technical, functional, and geographically diverse stakeholders to build and refine process/framework for standardizing military assemblage NSNs for medical supplies.• Established a central, automated MS Access/VBA database application by… Show more Developed and implemented data architecture, automation, analyses and reporting processes to standardize National Stock Numbers (NSNs) for medical supplies used in deployed military assemblages across all military services. • Collaborated with technical, functional, and geographically diverse stakeholders to build and refine process/framework for standardizing military assemblage NSNs for medical supplies.• Established a central, automated MS Access/VBA database application by consolidating deployed medical assemblage component data from various DoD systems resulting in increased facilitation and reduction in standardization review time from weeks to days.• Reduced assemblage NSN line items by 75% across all service platforms, increasing service supply commonality, reducing clinical care variation and removing need for clinician training at the point of care. Implementing automation and continuous process refinement allowed for expedited market research and introduced methods to capture more comprehensive inclusion of clinician feedback in identifying preferred products/product equivalencies. • Created an enterprise solution through manual ETL process consolidating and migrating disparate regional product and pricing databases into a central automated MS Access/VBA database application. • Consolidated all market research and subject matter expert feedback data into a recommendation document dashboard utilized for briefing officers and medical stakeholders at all organizational levels.• Reviewed the mission/data/processes and provided recommendations to improve accuracy of data and user experience for several military health systems. Recommendations lead to several fixes in system coding, along with systems enhancements to improve data accuracy, as well as user accessibility and function. Show less

Frederick, Maryland, United States

Developed and maintained complex multi-user Microsoft Access database applications to facilitate the production and modification of medical equipment handbooks used by deployed personnel in the U.S. Army. • Streamlined the previously manual and tedious process of building and publishing medical equipment handbooks by designing and developing a fully integrated, VBA automated database application to allow users to more efficiently enter and update handbook information. Implementation of the… Show more Developed and maintained complex multi-user Microsoft Access database applications to facilitate the production and modification of medical equipment handbooks used by deployed personnel in the U.S. Army. • Streamlined the previously manual and tedious process of building and publishing medical equipment handbooks by designing and developing a fully integrated, VBA automated database application to allow users to more efficiently enter and update handbook information. Implementation of the application reduced the typical timeframe for building new handbooks to days instead of months and reduced the typical timeframe for more complex handbook data/structure modifications to hours instead of days.• Recognized by division stakeholders as the go-to for ad-hoc data and automation projects due to extensive system/data knowledge.• Simplified the process of searching for and attaching medical equipment item photos/images to existing handbook documents by organizing all photos into a single storage point with specific file nomenclature. Allowed images to be viewed in a user interface and displayed in handbook update outputs, saving hours of manual work attaching images to the documents. • Consolidated the previously manual process for validating staff timecards by building a fully integrated, automated database application that allowed users to more easily enter all relevant timecard information into a single location while facilitating the supervisor validation process for those timecards. Show less

Sterling, Virginia, United States

Managed all information technology related operations and supported dozens of office products sales and merchandising employees. Wide array of responsibilities including database design, development and administration, report development and distribution, desktop hardware and software support, LAN and WAN equipment support, server hardware and software administration, IT equipment/software evaluation and procurement, and local EDI administration. • Consolidated several databases from… Show more Managed all information technology related operations and supported dozens of office products sales and merchandising employees. Wide array of responsibilities including database design, development and administration, report development and distribution, desktop hardware and software support, LAN and WAN equipment support, server hardware and software administration, IT equipment/software evaluation and procurement, and local EDI administration. • Consolidated several databases from varying platforms into a single fully integrated, automated Microsoft Access database encompassing the end-to-end process of the division’s retail merchandising and warehouse distribution operations.• Migrated Microsoft Access databases with sales transaction data, planogram maintenance and IT equipment into SQL Server databases, allowing for faster query performance of large datasets.• Developed a fully automated Microsoft Access database that ran several daily/weekly/monthly processes, also created and automatically distributed daily/weekly/monthly business critical reports.• Developed an automated order creation routine to process similar repetitive orders for different customers through an EDI interface, saving hundreds of hours in manual user data entry time. • Streamlined process for identifying product mix adds, deletes and changes to multiple merchandising customer systems by building a database application that automatically submitted product updates into the customer’s online systems. Saving hundreds of hours in manual user data entry time.• Developed automation to download, store and organize product images and product dimension data from product image vendor, reducing marketing brochure build time by 75%.• Planned and executed network switch/router/cable replacement, along with rewiring, in order to increase bandwidth and shorten response time for external/online applications.• Provided quarterly briefings about all IT operations to executive leadership team. Show less

Frederick, Maryland, United States

Designed and developed Microsoft Access database architecture and automated front-end application using Visual Basic and VBA to report collections metrics and for leadership to track attendance for credit card collections representatives. Metrics and data visibility helped reduce hold times an average of 5 seconds for auto-dialer outbound collections calls by better aligning dialer call pace with available representatives. Underlying application/reporting data mined from Oracle databases using… Show more Designed and developed Microsoft Access database architecture and automated front-end application using Visual Basic and VBA to report collections metrics and for leadership to track attendance for credit card collections representatives. Metrics and data visibility helped reduce hold times an average of 5 seconds for auto-dialer outbound collections calls by better aligning dialer call pace with available representatives. Underlying application/reporting data mined from Oracle databases using SQL*Plus and SAS. Show less

Bachelor Of Science (B.S.), Business Administration

Associate'S, Banking And Financial Management