ERP Systems Developer & Support

An exciting opportunity has arisen for a ERP Systems Developer & Support to join our busy Transformation Team.

The purpose of the team is to make the best and most efficient use of ERP systems to make the business processes optimised and to allow growth without major additional recruitment. This is achieved by the team through systems integration, OE developed user facing software, background processes and SQL data extracts.

Taking a key role in the design, installation, testing and maintenance of software systems, this role will help OE Electrics be more efficient across all areas of the business. Working closely with the ERP Systems Manager to achieve strategic goals., 1. Develop and deploy software solutions from designs provided by ERP Systems Manager in order to support business objectives.

2. Managing, developing, maintaining and upgrading all installed systems and infrastructure, including back up and redundancy (obsolete) strategies.

3. Having a deep understanding of the technical architecture, including code, to act as an escalation point to (1st line) ERP support and ensure any developed solution are thoroughly considered and complementary

4. To offer exceptional support to all internal customers on any systems related queries ensuring quick, professional and knowledgeable response and work with 3rd parties as necessary

What's in it for you?

• Competitive pay
• Christmas shut down period
• Contributory pension
• Free onsite parking & electric car charging points
• Onsite gym & classes
• Free hot drinks
• Employee Assistance Programme
• Chocolate Fridays!, Bootstrap

jQuery

Entity Framework

Power BI (Fabric) API

Graph API

Additional:

jQuery Validation

Linq

Landscape

SAP Business One is our ERP system. It is used by all element of the business including:

Finance including banking

Stock management

BOMS and production

Sales orders and quotes

Complaints (using service system)

Purchasing

MRP

CRM (via web front-end)

A third manufacturing execution system (MES) is in use (Lynq) and integrated to SAP to allow for the planning of production orders using drag and drop functionality.

We have separate SAP systems for UK, US, German, Australian and a system for OE group consolidations, running on premise on SQL database

We use the Boyum product extensively to enhance the capabilities of SAP and also make use of SPTN and SPPTN for data control and validation.

We make extensive use of SQL stored procedures for data retrieval from SAP into our web front-end to SAP and into Excel (purely for reporting purposes).

PowerBI is in use for analytical reporting but this not part of the developer role currently. All the data is SAP driven.

We have developed numerous software solutions that provide a web front-end to SAP and that run various background processes to update data automatically. These solutions are written in combinations of SAP DIAPI, T-SQL, .net (VB and C#), BPA, html and Javascript

The OE web front-end is only used by OE employees or suppliers, it is not a web commerce system, and the priority is on the easy and efficient processing of data from, and to the SAP system.

The web front-end loads data from the SAP database and allows user update which is then written back to the server with detailed updates to SAP done within DIAPI processes. The system is in use throughout the group company locations updating the appropriate company systems.

We have a small footprint in Azure which is used to store documents for access from the OE web front end to SAP for remote access.

There is a warehouse management system (currently from a third party) which uses handheld scanners integrated to SAP using DIAPI solutions. This system is due to be replaced with either a different third-party product or an internally developed solution.

OE added functionality

Inter-company processing

Automates the creation of downstream documents in the appropriate company database from source documents i.e. sales order in US creates sales order in UK system, sales invoice in UK creates purchase invoice in US etc. This creates a fully automated system where possible to avoid re-keying of documents.

OE1

This is the web front-end to SAP which contains the following elements

· CRM Used by all sales people to record and manage sales opportunities.

· Third party updates i.e. logistics partners

· Access to production documentation by shop floor operatives

· Warehouse Stock Replenishment reports

· Stocktaking routines

· Shopfloor Data Capture

This may be extended in the near future to include WMS.

Forecasting

Data is used from the sales opportunities system in order to create potential forecasts for use in MRP by purchasing. This effectively provides integration between sales opportunities and purchasing to allow for the planning of long lead time items.

OCR

Allows for the automatic creation of sales orders from purchase order pdf (currently via a third party)

Master data synchronisation

Users and item master data is all controlled from the UK system and synchronised to the other company systems

OE Group consolidation

Summarises individual OE company data to the group level

Sales order firewall

Sales Orders cannot be released unless they meet a strict and detailed criteria which is controlled via complex Boyum rules.

Automatic creation of production orders once sales order released

Once sales orders are released the production order is automatically created and issued to production for planning and release to shop floor

Despatch consolidations

Web-based system to consolidate multiple sales orders onto one delivery

Process credit card payments

Integration with Barclaycard to receive payments from customers which is allocated to ledgers automatically.

Do you have experience in SQL?

Salary: competitive market rate, In house designed and built kitting solution to allow the automatic creation of Pick Lists in kits to improve picking efficiency.

Shop Floor Data Capture

Built on top of the kitting solution, allows the capture of times in each route stage for each kit of a Production Order.

Job Types: Full-time, Permanent

Pay: £35,000.00-£45,000.00 per year

Benefits:

• Company events
• Company pension
• Cycle to work scheme
• Free fitness classes
• Free parking
• On-site gym
• On-site parking
• Sick pay