Brian Phelps Email & Phone Number

Writing

• Initiated a multi-million dollar cloud based ERP implementation to replace a legacy BBx application, involving all facets of a multinational, multi-currency food manufacturing and distribution company• ERP project management departmental interaction and training – production, MRP, warehouse (Vocollect voice WMS), transportation (Verizon logistics), purchasing, order entry, accounting, payables, receivables, inventory control, marketing, quality control, supply chain, distribution, IT, CRM, HR, Executives• Extensive Data Mapping of existing ERP; ETL and conversion into the new VAI ERP application; involved hundreds of tables, thousands of fields, and millions of records• Revised warehouse inventory case dimension (TiHi) data using Cubiscan equipment and software• Saved massive amounts of time with workflow automation by developing distributed sales Credit Memo application to automate paper-based process; resulted in 25,000+ submissions over 8 years• Supported company’s retail grocery store – SQL based Point of Sale (POS) application, food scales hardware and software, product pricing, reporting and analysis, self-checkout installation, Shopify eCommerce order taking support, PCI compliant Verifone pin pads, Toshiba checkout lane hardware, upgrades• Implemented a cloud-based survey application (SmartSurvey), collecting and analyzing nearly 100,000 submissions; tracked customer food product mix performance and quality control measures for incoming and outgoing food product shipments• Implemented company wide Web Conferencing, using the Zoom Video application (prior to Teams)• Provided 24/7 remote user and server support using RDP and TeamViewer applications• Involved with EDI configuration, administration, and conversion – food related 810/855/856/875/880 formats• Microsoft SQL Server 2012/14/16/19/22 administrator – POS, Warehouse Voice application, Reporting; included linked servers using Linux, IBM DB2, and SQL server; agent jobs, stored procedures

Pennsylvania, United States

• Led local incident management/Help Desk team, responding to data and technical support requests• Led local reporting / BI / Data Analytics team that produced reports and data extracts for all stakeholders of the healthcare organization; analyzed KPIs to provide required and timely information for management decisions• Installed, maintained, supported company network infrastructure -- LAN, WAN, TCP/IP, wireless, telecom, servers, Cisco routers & switches, Microsoft Windows Server and Desktop operating systems, Active Directory, printers, scanners, and software applications for a multiple branch office PA network• Administered Microsoft SQL Server to support extensive database reporting and data needs; included migration, upgrades, coding, backup, ETL, reporting, and Oracle database integration• Produced goodwill through frequent interaction with representatives of 13 counties, the State of Pennsylvania, vendors, consultants, auditors, and all levels of corporate management• Managed multiple departments, with responsibility for employee hiring, performance reviews, training, departmental capital/operating budget functions, and addressing behavior of problem employees• Responsible for physical building security access and adherence to HIPAA security requirements• Managed, supported, and utilized Business Intelligence applications, including SQL Server, SSIS, relational databases, SAP Business Objects & Crystal Reports platforms, query and programming tools, and analytical and validation techniques used for continuous production improvement• Employed extensive research and analysis of behavioral, D&A, physical, and pharmacy healthcare information from multiple sources to provide capabilities not previously available• Ensured adherence to contractual data reporting deadlines and file submission schedules were prepared and followed; met statutory requirements of Federal, State, and County entities, avoiding $millions in penalties