Are you a Syspro Specialist with min five years experience in a manufacturing and production environment?Our client is requiring your expertise to join their dynamic team using your Syspro functional financial, distribution and manufacturing experience.REQUIREMENTSMatric or Equivalent5 – 7 years Syspro application administration with MS SQL Server administration and developmentSyspro, SQL server, SSRS experience integrate Syspro with other databasesExcellent technical and non-technical communication and problem-solving skillsEnd to end project management and issue resolution experienceStrong understanding of financial and production conceptsDUTIESReporting to the IT and the Financial ManagerDay to day user support of the Syspro application and MS SQL 2005 Server databaseSupport of Syspro production environment including Application Server, database and client PCsMaintain a suitable helpdesk solution with timeous responseResponsible to oversee and attend to helpdesk requests from users across all departmentsMaintain a suitable helpdesk solution with timeous responseOversee and attend to helpdesk requests from users across all departmentsEnd User SYSPRO SupportTroubleshooting SYSPRO related problemsCreate and maintain customized reports using MS SQL, SYSPRO reporting services and EXCELMaintaining SYSPRO Documents formats using Crystal DesignerInvolved in setting up business processes and proceduresDocumenting and administration of SYSPROTraining of Staff on Syspro Processes and ProceduresExperience in Barcode Printing, Barcode Design, scanner set up and operations etc.Basic technical experience with regards to PC’s, scanners and printersUsing Syspro functional experience including financial, distribution and manufacturing modules to manage the job portfolioAd Hoc reporting and development as needed including Syspro and SQL ServerEnd user training at all levels with version upgradesMake up training/reference manuals for Syspro ERP modules in useWork directly with accounting department and production control staff to streamline processes and correct impediments.Perform function of SQL 2005 database admin, SQL backups, user security and database maintenanceWrite complex queries using T-SQL combining data from multiple companies and ServersOptimize T-SQL code and stored proceduresSQL Server Reporting services (SSRS) to write reports not possible using Syspro Report Writer, users can print reports or export to Excel or PDF format
