Business Analyst

Business Analyst

OBJECTIVE

The purpose of this position is to analyze the Sales, Inventory & Operations Planning (SIOP) business process and needs and recommend and implement technology solutions, and support the back-end systems for the forecast process.

Key to this role is the development and administration of the Sales, Inventory & Operations Planning (SIOP) Database and corresponding Oracle and Manufacturing Resource Planning (MRP) applications. Generating the technical option forecast, maintaining the planning %s within Oracle. Support data flows (imports/exports) to support multiple systems. Perform data discrepancy analysis and implement solutions. Must possess skills in order to maintain, administer and build databases and data structures based on the needs of the business.

RESPONSIBILITY

Administration of the Information Technology (IT) Solutions supporting Sales, Inventory & Operations

• Administer Sales, Inventory & Operations Planning (SIOP) database. Generate data extracts from database. Generates Monthly Sales, Inventory & Operations Planning (SIOP) Reports. Perform functional testing at the database and extract level (e.g., must understand how data is written to the database and subsequently extracted). Design, develop and implement Sales, Inventory & Operations Planning (SIOP) data warehouse, Oracle, and Manufacturing Resource Planning (MRP) processes to match the Resource Planning (ERP) software's core functionality. Develop/Administer tools to be used by the Sales, Inventory & Operations Planning (SIOP) Team to streamline current process. Perform data discrepancy analysis and implement solutions. Entering NAO Heavy forecasts into SAP. Support Item Maintenance.

SIOP Key Performance Indicator Reports

• Develop and maintain SIOP KPI reports including pulling data from proper systems, validation of data accuracy and integrating automating updating where required.

Information Technology (IT) Partnering

• Partner with Information Technology (IT) staff. Liaison between Information Technology (IT) and Sales, Inventory & Operations Planning (SIOP) Teams. Manage all aspects of technology and application development projects of varying sizes in support of assigned clients.

Key Support of the America’s Sales, Inventory & Operations Planning (SIOP) Process.

• Update Forecasts in Sales, Inventory & Operations Planning (SIOP) Database. Support Demand Class Scheduling Project. Support Heavy Business. Support Compact Business. Support Attachment Business (Compact & Heavy). Support Portable Power Business. Lead root cause analysis on data issues. Support the Annual Operating Plan (AOP). Support the Long Range Plan (LRP). Support month end SIOP activities. Support the daily SIOP reports. Support SIOP data flows in/out of database to support multiple systems.

Generating Option Forecast

• Generate technical Option Forecast for North America Supplied Options. Generate technical Option Forecast for North America Products supplied out of Dobris Plant. Perform Root Cause Analysis on Option Forecast gaps. Administer the North American option forecast. Work with Product Management on developing forecasts for new Options. Maintain the planning %s within Oracle.

Special Projects

• Assist other areas where needed to support credit rebills, consignment, documentation needs, and other special requests.

KNOWLEDGE / EDUCATION / EXPERIENCE

• Education Required: Bachelor’s Degree in Business Administration

• Experience Required: 2+ years

• Must have an understanding or ability to learn the Sales, Inventory & Operations Planning (SIOP) Process, Business Structure, Enterprise Resource Planning (ERP) Systems and BOM Structure

• Project Management experience

• Effective Communication and presentation skills

• User of Lean Six Sigma Tools

• IT Development and Database administration preferred

• Product Knowledge a plus

• Understanding of Bill of Material Structure, Material Requirements Planning, and the Global Sales, Inventory & Operations Planning (SIOP) Process a plus

• Ability to use MS Office (incl. Microsoft Access), VBA Programming, Toad for SQL access to Oracle Databases, Advanced Oracle User.

• Travel Required: < 10%

All your information will be kept confidential according to EEO guidelines.