ERP Programmer

Essential Duties/Responsibilities:

• Analyze existing SQL based software and operational procedures to evaluate effectiveness, and develop new features, reports, and data views to improve production and workflow.
• Respond to user requests for creation of, or modification to, data views, reports, and forms.
• Develop SQL queries and reports to identify and expose exceptions and data entry errors.
• Identify need for and write email alerts for SQL based ERP software for specific data based events.
• Develop interfaces between various SQL based applications.
• Create test transactions and run tests to find errors and confirm that programs and modifications meet specifications.
• Analyze, install, and test upgrades of internally or externally developed application programs and modifications to maintain system after implementation.
• Monitor performance of system solutions after implementation.
• Respond to the needs and questions of Sage MAS500 and network users concerning operation of software and hardware, and access to resources on the network.

Requirements: (education, experience, certifications)

• Bachelor’s degree in computer science, information systems, related field.
• 5-7 years of relevant experience.
• Good basic understanding of operational business flow in an ERP environment.
• Understanding of typical data structure and tables used in ERP systems.
• Experience with Network/Server Technologies such as:
• Microsoft Windows Network
• Windows Server 2005 & 2008
• SQL Server 2005 & 2008.
• Strong skills with Crystal Reports.
• Proficiency with developing Tables, Views, triggers, and stored procedures in SQL Server 2005
• Ability to interpret instructions furnished in written, oral, diagram, or schedule form.

Preferred experience in some or all of the following:

• Basic accounting principles
• Visual Studio 2005
• MAS500
• OnBase
• Experience with MS Access and Visual Basic
•  Excellent interpersonal and communication skills to work patiently and efficiently with all users to resolve problems.
• Strong problem-solving and time management skills