Phil Vachon Email & Phone Number

Larchmont, New York, Us

Jamaica, Ny, Us

Accomplished Projects:Implemented Epicor ERP 11 in the Cloud, integrating the new system directly with Avalara Tax, EPX Credit Cards, DocStar Content Management, Epicor EDA.After two years of ERP in the Cloud, the company chose to Migrate from Cloud to On-Premises, off-site hosted servers. Immediately improving Finish Good Production times and real time plant reporting, SQL Management and throughput of the core company resources. Improved ROI of IT.I am the Subject Matter Expert (SME) for the Epicor Kinetic System and all its associated Enterprise programs and connected resources.Advanced user of Data Migration Tools used during implementation of new Company with existing database. Skilled at Data Cleansing original data sets during Data Migration to build proper table sets supporting higher level transactional record imports in to ERP.SSRS - Creating over 100 Customs documents, including Finished Goods labeling, dozens of Financial reports and custom AR invoices with disclaimers attached, Automatic Emailing of Posted Invoices and Shipment Notifications to the customer. All but eliminated Consulting time and expenses.Managed the external IT Support team to improve Infrastructure (more speed to users), make more efficient Virtual Server Systems (upgrade and consolidate computing) and install Vulnerability Assessment and tracking at the PC Level with 24/7 monitoring. Reviewed vendors billing to reduce spending and improve ROI of IT.

Working as a Project Lead for Columbia University IT, installing Cisco Video Conference Rooms, Zoom Digital Classrooms and Campus Signage using Crestron Control, Bi-Amp DSP's , Shure Wireless, DaLite Screens, Panasonic Laser Projectors, Samsung Displays and more...

Jackson, Missouri, Us

• Daily activity included User / Administrator / Developer: Epicor Prophet21 (SQL ERP) for Global Distributors responsible for system modules, user rights and data management. Developed internal dashboard using custom reports offering live insight into processes not available otherwise.• IT Projects included discovering and implementing efficiencies in warehouse operations, entry error reductions, streamlining shipping and transit documentation, as well as Live Daily Reports on productions for multiple departments in Prophet21• 10 years of experience with Epicor (formerly Activant) Prophet21 system in multiple capacities.• Implement automated data exchange with CRMs, Vendors (B2B) and Web Services (B2C).• Experienced with SSMS for SQL Database management, T-SQL and ERP development.• Can provide expertise on data quality, data migration and data security in ERP.• Management of database schema, functions, tables, stored procedures, and ETL.• Lead team discussions with comprehensive presentations delivering impact and influence targeted graphics and PDF outputs. Advanced with Excel (Pivot Tables, ODBC, Lookups and Gantt Charts), Visio and MS Project.

Jackson, Missouri, Us

• East Coast Service Manager reporting to the VP of Technical Services.• Provided Tier 2 level support for customer support for Top Level Lighting Control Systems (MA Lighting) used in Concerts, Live Performances and Installation throughout the USA and abroad.• Factory trained in Wireless DMX products, Stage effects and Moving Light products, providing 24 hr. support to multiple product lines for Touring companies and vendors nationally.• Incidents used a ticketing system (Team Support) in addition to ERP service system. Member of implementation team and later developing reports and KPI's for managers and staff on Support response, customer satisfaction and trends.• After Hurricane Sandy, the company immediately set out to migrate all enterprise applications to hosted environments. The project took 10 months, starting with RFQ’s returned from vendors thru testing and training, culminating with hosted email, ERP, Support, CRM and working shared files structure.• Developed with Team Support (Bootstrap, HTML, CSS, jquery) a public, mobile-first, knowledgebase of support and troubleshooting on all company products to expedite common solutions efficiently and globally.• Setup wireless office and warehouse environments using multiple Cisco Access Points and Mac Airports.• Helpdesk Support: Provide day-to-day support to clients for network infrastructure and internal desktop systems, software, and hardware, onsite and remotely.

• Installed and Managed enterprise Network System, including Servers, Switches and Appliances.• Installed Checkpoint Firewall with interoffice tunnels, managed switches.• ISP connectivity via POTS, DSL, T1, as well as Meridian phone system on premises.• Setup office and warehouse barcode readers with multiple terminals for shipping and inventory management.• Successfully designed, managed and completed MS domain including Active Directory, Exchange 2003, Terminal Server, IIS, MS SQL, Oracle 8i, Netware 4.12 and Dbase IV.• Certified MSCE 2000 on Windows Servers, Exchange Server, SQL Server, Terminal Servers and Desktop/laptop management. • Provided day-to-day support to staff for network infrastructure, desktop systems, software, and hardware. Netware 3.11 , Windows 3.11, 95, 98, WinNT, Win2000