SYSPRO Applications Specialist
hace 3 días
Camberley
Job Title: SYSPRO Applications Specialist • Team: Working within a team of IT professionals, comprising IT Support, IT Developers and Systems Administrators., • Reports To (job title): Development Team Lead, • To plan, support, maintain and develop the Company's SYSPRO ERP system, and associated applications, ensuring optimum usage of the system and serving as a technical lead on projects involving implementation and maintenance of ERP-related applications, databases and reports., • Travel Required? Yes ? No ?, • Travel to regional offices, suppliers and seminars to meet key stakeholders, review performance, identify operational improvements and to develop understanding of best practice and on-going developments in IT Support., • To perform day-to-day system administration functions for Syspro and related application and database infrastructure, • This includes testing and application of system patches, measurement and maintenance of system performance, security of data through role configuration etc., • Troubleshoot and resolve day-to-day and complex technical problems with Syspro and related applications, including database applications and server problems, liaising with colleagues and escalating to vendor as appropriate., • Managing the support and development relationship with the vendor to maintain required levels of coverage and proactive implementation/development of additional functionality, • Develop/implement changes to the Syspro environment to support business process changes and efficiency improvements., • To function as the lead specialist on projects to enhance or test ERP systems and applications to meet changing business needs., • Maintain system documentation for Syspro and the wider ERP infrastructure., • To manage the Syspro software configuration, the testing and debugging of ERP functional modules and the maintenance of Syspro database tables., • Develop and maintain reports, spreadsheets and external integration pieces to support business reporting requirements., • Identify, design and implement ancillary functions to enhance core Syspro functionality using established toolsets where necessary., • Identify and evaluate new features and functionality which may be of benefit to the business., • Develop and maintain DataSwitch integrations with other systems. Essential • Expert Technical Knowledge of ERP systems, • Microsoft SQL server database administration, • SQL queries, view and stored procedure design., • Knowledge and understanding of database schemas., • Experience of database reporting tools, • Evidence of supporting large-scale business process change projects., • Expert in use and development of Excel functions, macros and data connections, • Working knowledge of C#, ASP.NET framework/.NET core, • Excellent knowledge of VBScript/VBA, • DataSwitch development and administration, • Experience of managing others, • Familiar with standard concepts, DB best practices and procedures within the particular field., • Experience of managing suppliers and 3rd party or outsourced contracts., • Competent in using Office 365, • Power BI, • JavaScript, • Expert technical knowledge of Syspro 8, • Experience of Crystal Reports, • Experience of writing business requirements documentation.