Travis Mack

Experience

• 

  Ingenico

  Dec 1999 - Jan 2005

  IT Systems Administrator

   Complete Management of Network Servers / Desktops (30 PCs) Windows NT4, 2000, 2003 Server Administration / Upgrading SQL Server 6.5, 7.0, 2000 Administration and Programming. MS Access, Office 97, 2000, 2003 Support for users. Windows 95, 98, ME, 2000, XP Support for users. Administration of Loyalty Scheme Database with 40000 Members. Web Page Design / Webmaster for the companies Website.

• 

  Fifth Dimension

  Jan 2005 - Dec 2007

  Technical Consultant

   Managed IT Department within Cork and Dublin offices., Administered and set up Exchange 2003, Active Directory on Windows Server 2003 SBS. Installation, Troubleshooting, Upgrades, Reporting via Crystal Reports 10, XI, Report Designer and SSRS. Project Management reviewer of all ERP Upgrade plans. Firewall / WAN Maintenance & Rules. Sage Line 1000/500 Administration / Support Data Migrations from various ERP Financial and CRM systems SQL 2005 Administration and Basic Programming. Consultancy and Training provided with Clients across Ireland. Show less

• 

  Sage Ireland

  Dec 2007 - Jun 2009

  Professional Services Consultant

   Sage 200 Installation, Troubleshooting, Upgrades, Reporting via Reporting Services (SSRS), Report Designer and Crystal Reports XI Windows Server 2003 / SQL Server 2005 administration, scripting & reporting for Customers. Project management of smaller sites from start to finish. Sage CRM Administration and Programming with Reporting Data Migrations from various ERP Financial and CRM systems Project Scope Analysis/Business Analysis for multiple business solutions Presales Presentation and client demos provided to customers. SQL 2005 Administration and Advanced Programming with emphasis on Stored Procedures, Views, Triggers and cross database reporting. SQL Server Reporting Services (SSRS) - Primarily Financial Board reports - setup and delivery of the suite of reports. Consultancy and Training provided with Clients across Ireland. Show less

• 

  Bord na Mona

  Jun 2009 - Aug 2013

  Internal ERP Consultant

   Sage Line 500 Installation, Troubleshooting, Upgrades, Reporting via Crystal Reports 10, XI, ProDiver, SSRS, Oracle 9i Clients. Windows Server 2003 Administration / Maintenance. SQL Server 2008 scripting, administration & reporting (SSRS). Assisted Project manager designing ERP Upgrade Project Plans. Creation of Stored procs, Triggers, adhoc queries in Oracle/SQL2008. Data Migrations from various ERP Financial and EDI systems. Managed and Upgraded all Dot Matrix customer facing documents to Laser Print layouts with email/archive capability. Basic Project management on reporting projects. Show less

• 

  Aspera Solutions Ltd.

  Aug 2013 - Dec 2014

  Implementation Consultant

   Epicor 9, 10 Installation, Troubleshooting, Upgrades, Reporting via Crystal Reports, SSRS SQL Server 2012 scripting, administration & reporting (SSRS). Assisted Project Manager with Designing Project Plans for mid level projects. Customer facing training provided on Distribution, Manufacturing, CRM and Technical Tracks of Epicor / Crystal / SSRS. Onsite Design / Functional Specification with customers on Distribution, Manufacturing, CRM systems throughout Ireland/UK. Creation of Stored procs, Triggers, adhoc queries in SQL2008/12 Data Migrations from various ERP Financial systems into Epicor. SSRS and Crystal Document Layouts for Customer facing documentation (Invoices, Sales Orders, PO’s etc) including Document management software. Show less

• 

  Milner Browne (IIS Group)

  Jan 2015 - Jun 2016

  SAP Business One Consultant

   Consultancy with Customers primarily focused on Distribution, Production, CRM and Technical Pre-Sales, Project Scoping, Training, Workshops, User Acceptance Testing and Go-Live support providing a complete end to end customer experience. Onsite Design / Functional scoping with customers on Distribution, Manufacturing, CRM systems throughout Ireland/UK. Technical areas : Crystal Reports, SQL/HANA Queries, Marketing documents, Add-ons, Installations, Upgrades and SAP HANA admin

• 

  Aspera Solutions

  Jun 2016 - Mar 2019

  Senior Implementation Consultant

  Epicor 10 Manufacturing, Distribution consultancy.End to End implementation from Design to Go-Live.Pre-sales demos and activities to existing customers.Training workshops delivered in a Classroom environment.SSRS 2016 Reports

• 

  Milner Browne

  Mar 2019 - Dec 2021

  SAP Implementation Consultant

   Consultancy with Customers primarily focused on Distribution, Production, CRM and Technical Pre-Sales, Project Scoping, Training, Workshops, User Acceptance Testing and Go-Live support providing a complete end to end customer experience. Onsite Design / Functional scoping with customers on Distribution, Manufacturing, CRM systems throughout Ireland/UK. Technical areas : Crystal Reports, SQL/HANA Queries, Marketing documents, Add-ons, Installations, Upgrades and SAP HANA admin.

• 

  Self-employed

  Jan 2022 - now

  Freelance Consultant

  Freelance consultancy with a focus on Epicor and SAP Business One.ERP focus Manufacturing, Distribution, Stock management, CRM and Scheduling.Report focus PowerBI Tabular / Multi Dimensional cubes with SSRS and Crystal Reports.Recently I have been working on a CRM Complaints management system based in the cloud and integrated this to an on-premise ERP system. New customers, Parts and Part Batches automatically flow to the cloud so that end-users can log complaints with live information.I am also working on ERP system upgrades as a Project manager driving this from the customer side with both the end-users and the partner. Show less