David John Dros Email & Phone Number

Grand Island, Ny

• Manage and support cGMP manufacturing and laboratory information systems for the Bio Production Group of the world leader in serving science with annual revenues of over $40 billion.• Support the validated and non-validated production systems for formulation manufacturing (MES – POMS) and R&D / QA laboratories (LIMS – Sample Manager) by resolving access, incident and change requests in timely way in order to enhance user experience and drive process improvement through innovation and automation.• Understand and convert functional requirement requests from manufacturing (MES) and R&D / QA Laboratory (LIMS) systems to technical specifications and design develop digital and paginated report solutions utilizing modern cloud based reporting tools such as Power BI.• Manage day to day administration of these systems, including users, security, updates, troubleshooting / bug fixes, external system integrations, training / documentation.

Rochester, New York, United States

Responsible for supporting the technical implementation of the Company’s Acumatica / NexVue ERP implementation and providing ongoing maintenance and daily operational support.• Responsible for data migration from multiple legacy platforms and configure respective business processes comprising of core ERP, EAM, CRM, Supply Chain functionalities into new enterprise class SaaS, cloud based application and mobile application components. Manage Microsoft AZURE SaaS development environment instance for testing and SQL Server Data Warehouse for legacy AS400 Data.• Manage day to day administration of the system including users, security, updates, troubleshooting / bug fixes, external system integrations, training / documentation become the ERP system SME and point of contact with VAR. Maintain up to date knowledge of Acumatica functionality, customization, and integrations to manage ongoing system improvements and road map upgrades utilizing Acumatica’s LMS and online training courses and certification processes.• Master the understanding of the new ERP environment and utilize acquired practical business acumen to collaborate with cross-functional teams to identify and drive initiatives that improve business processes and work-flows through utilization of the ERP and its supporting systems.• Develop reports, dashboards, KPI’s within the ERP toolset along with data warehouse analytics reporting using MS Power BI and other associated databases and technologies.

Buffalo, New York

Team leader for a corporate wide migration of multiple legacy ERP, supply chain logistics, production planning systems to enterprise class best of bread cloud solution(s) and analytics data warehouses. Working closely with solution vendor technical experts in translating current multiple process based manufacturing activities into configurable metadata. Core subject matter expert on new solutions architecture, configuration and functionality. Areas include Financials, AR/AP, Inventory /Supply Chain, BOM/Routings, QA/QC Traceability/ Mass Balancing of Raw Materials - Finished Goods etc.Assisting with business process analysis of critical activity domains and performing gap analysis evaluations and process improvement recommendations into functional specifications designs for the new systems.

Buffalo, New York

Supported then managed the software division of corporate IT department for a global industry leading OEM whose products support the oil / gas drilling and mining industries. Maintained senior developer status throughout tenure in addition to management role. Maintained, customized existing and designed/implemented new custom software applications in support of all aspects of business operations. These operational areas included, but were not limited to, sales/CRM, order fulfillment/shipping/invoicing, purchasing, manufacturing, inventory control, supply chain, data collection, accounting (AR/AP/Executive), payroll, human resources etc. • Served as IT enterprise software stakeholder in all executive decisions involving enterprise data architecture and directives • Responsible for design oversight/project management of all software development activities of departmental team • Managed personnel issues, performance evaluations, mentoring, work assignment, and review of all team activities • Collaborated with corporate network IT management and support staff to optimize and cost effectively implement integrated turnkey software solutions by exploiting existing network, intranet, and extra-net architecture and hardware resources • Responsible for all functionality of industry leading Microsoft-based solution (.Net, SQL, etc.) ERP system INFOR CloudSuite Industrial-Manufacturing (Syteline) (including but not limited to: database schema, application meta-data driven architecture, stored procedures (Transact SQL), views, triggers, Intelligent Data Objects (IDOs), extensible and scoping design philosophies, event handlers, application event system, form scripts, UET fields, Crystal Reports and SQL Server Reporting Services (SSRS) reports) • Analyzed/designed/created/implemented, utilizing Agile SDLC methodologies, 20+ feature rich MS Access/VB/SQL server applications which integrated (some bi-directionally) with ERP system (Syteline).

Lancaster, New York

• Maintained Access and SQL Server databases (Windows and Web Interface) in support of the internal corporate and enterprise management systems• Designed applications supporting consulting divisions new and continuing environmental projects such as green energy tracking initiatives and environmental data regulatory reporting • Worked closely with corporate IT applications development group to create custom windows and web database solutions for commercial and government clients• Managed custom Laboratory Information Management System (LIMS) for the company’s ISO17025 certified environmental testing laboratory in Kuwait City, Kuwait – Central Environmental Laboratory (CEL). • Created network desktop applications to interface with commercial automated data validation products ADR/EDMS by LDC and EQuIS by EarthSoft to assist and streamline internal process of managing and tracking status, validation, reporting, and warehousing of all subcontracted analytical data from all of 20+ regional offices• Developed hardware/software inventory management application for corporate IT department to assist with all aspects of inventory control, licensing, ordering for all IT related components distributed to over 20+ regional offices, and over 500+ users (system incorporated barcode, wireless scanners for inventory check in/out, integrated electronic signatures of vendor purchase requisitions, automated integration with corporate ERP accounting system’s purchase order functionality, and utilized integration with MS Outlook/Exchange to automate communications and document management)

Analytical Services Center - Lancaster, New York

• Managed all aspects of IT systems, LIMS, and related applications for a $5M+/year NECLAC approved Environmental analytical testing laboratory in Lancaster, New York and a $1M+/year ISO17025 certified environmental testing laboratory in Kuwait City, Kuwait (CEL).• Oversaw three full time software support staff and one network administrator dedicated to the laboratory facility• Served as chief architect of all design modifications and enhancements to core customized LIMS product resulting in the creation and/or enhancement of 15 custom two tier MS ACCESS database applications supporting 50+ simultaneous users (this integrated the core LIMS system resulting in turnkey solutions to custom reporting requirements such as AFCEE, Organic and Inorganic CLP, 40+ industry standard and custom Electronic Data Deliverables (EDD), quality control functions such as control charts, MDLs, DOCs, and corrective actions, proposal tracking and sales forecasting, corporate ERP integrated invoicing system, document management, paperless reports, automated integration with MS Outlook/email and network file services, and secure web based client internet access)• Continued business process enhancements and systems automation implemented through LIMS upgrades which resulted in a 50% staff reduction while increasing sales an average of $1M/year• Established VAR agreement with original LIMS vendor and designed and implemented a customized LIMS for the Central Environmental Laboratory (CEL) in Kuwait City, Kuwait which incorporated integrated custom field PDA and electronic chain of custody applications utilizing GPS and barcodes to handle the subcontracting distribution of over 50,000 samples between Kuwait and United Stated laboratories• Migrated LIMS and all related application databases to Microsoft Access 2003 versions

Analytical Services Center - Lancaster, New York

• Conducted business analysis, system requirements gathering, functional specification design, procurement and implementation of the $4M/ year analytical laboratory’s LIMS replacement project • Managed a team of eight key laboratory personnel assigned to the project through installation • Customized GUI and source code to automate key data related functions resulting in over $800K savings in the first year• Migrated VAX based system to new Microsoft Access 97 based commercial OTS LIMS products (OmegaII eLIMS/The Khemia Co.) completed within three months from receipt of source code• Enhanced core application source code to run efficiently as a two tier (client/file server) supporting 50+ simultaneous users• Modified core product to comply with Good Automated Laboratory Practices (GALP) and 40CFR part 21 with regards to electronic record keeping, auditing and electronic signatures, and added necessary components to support proper version history tracking and compliance with industry suggested practices of the SDLC (software development life cycle) • Designed automated data archiving process and dynamic multi-database connection interface which allowed application to function beyond the ACCESS 2 gigabyte size limitations (10+ gigabytes, this provided data warehouse functionality and data mining across all historical data and removed the need to upgrade to an SQL Server)• Wrote Automated Data Entry Instrument interfaces (many bi-directional) for all analytical instruments and custom bi-directional EXCEL solutions (this eliminated manual data entry throughout the entire laboratory)• Created complete backup and disaster recovery plan to ensure business continuity for laboratory IT systems

Analytical Testing Laboratories - Amherst New York

• Analyzed environmental samples per United States Environmental Protection Agency (USEPA) methodologies utilizing state of the art instrumentation and computer systems • Worked hands on with “home-grown” LIMS (AIMS) written in Microsoft FoxPro • Advanced knowledge of TurboChrom Chromatography Data System (CDS) • Performed technical project management and customer service for the analytical services division • Served as technical liaison by determining analytical service requirements based on current environmental regulations for various commercial, industrial, and governmental clients

Grand Island, New York

• Conducted analysis of raw material, in process, finished product, and stability samples for critical care injectable pharmaceutical manufacturer • Utilized United States Pharmacopeia (USP) methodologies as part of a method validation task force per FDA/GMP requirements

Harrisburg, Pennsylvania Area

• Coordinated all outside and inside sales for laboratory services • Developed marketing campaigns for the Environmental Laboratory Division (brochures, mail merges, etc.) • Prepared technical proposals in response to client requests for proposals (RFP) • Managed all customer service relative to analytical testing projects

Buffalo, New York

• Provided specialized computer programming services for automation of digital musical instruments, sound and lighting reinforcement equipment as contracted by various touring performing artists throughout the Eastern United States

Amherst, New York

• Developed and applied custom database software, spreadsheets and graphics programs in support of the analytical, consulting, accounting, and sales divisions • Responsible for telephone, written (proposal) and personal response pertaining to all aspects of inside/outside sales • Provided technical support to major local, national, industrial, commercial, and governmental clients representing the analytical services division• Managed all aspects of analytical testing laboratory operations from analyst through supervision within the metals department • Performed analysis of environmental samples via all aspects of Atomic Absorption Spectrophotometry (flame, furnace, Hydride, etc.) • Obtained and maintained the laboratory’s initial certifications from the New York State Department of Health (NYSDOH), New York State Department of Environmental Conservation (NYSDEC) and United States Environmental Protection Agency (USEPA) Contract Lab Protocol (CLP) programs • Designed a standalone “BASIC” application to automate calculations from older instrumentation

Niagara Falls, New York

• Prepared and analyzed samples in the organic, inorganic, and metals department utilizing United States Environmental Protection Agency (USEPA) methodologies