Lead/Senior Datastage with Design Experience

Role: Lead/Senior Datastage with Design Experience

Location: Peoria, IL

Duration: 1+ Year

Consultant Deliverable

Comments

Proposal Templates

Templates will be inclusive of Proposal Estimate, Scope and Assumptions as applicable.

Project Risk Assessment

Information utilized to update or change tickets.

Project Requirements Documents

Requirements Documents will include the following details:

• Define as-is process (written/visual)

• Define to-be process (written/visual)

• New inputs/outputs

• Logic Change

• Source and Destination Connectivity Detail

• Communication Protocol

• Trading Partner Names

• Transaction Types

Data File Creation/Modification

Data File creation/manipulation that meet the requirements outlined in the Requirements Documents above.

1.1.1. Consultant Roles and Responsibilities

Should project scope need to be increased or re-calculated, the Consultant will provide a flexible and scalable team pursuant to the Change Control Process in Appendix A.

table 3: team members

Team Member

Team Member Qualifications

Data Designer

• 5 Years Datastage and Supply Chain EDI Experience

• Has extensive knowledge using DataStage ETL tools (Datastage v8.x or 11.x) and various database platforms

• Experience with Caterpillar EDI project design and development is highly desired

• Familiarity and/or experience in any Caterpillar Business Area that leverages EDI

• Familiarity with AIAG Supply Chain EDI model

• Familiarity of extracting data from various data sources and loading to Teradata, Oracle, and DB2 RDBMS

• Knowledge and Understanding of Caterpillar EDI Environment

• Understanding of Caterpillar SI mapping naming structure

• Deep knowledge of Caterpillar IDOC/APP structures

• Understanding and knowledge of Caterpillar EDI Design Patterns

• Excellent communication/interview skills to extract detailed EDI integration requirements from non-technical integration requesters, as well as ability to effectively collaborate with Caterpillar EDI Subject Matter Experts.

• Ability to read and understand Caterpillar EDI Guidelines based on X-12 and EDIFACT EDI Standards.

• Ability to determine the difference between X12 Standards Requirements and Caterpillar Implementation Requirements

• Ability to use SIMON and Sterling Integrator to research and determine current EDI capabilities of internal and external trading partners

• Ability to read, understand and document Mapping Requirements using Caterpillar Mapping Requirements Specifications (MRS) documents.

• Work closely with Caterpillar EDI Subject Matter Expert to make sure all designs adhere to approved design patterns as well as Caterpillar EDI Integration Patterns.

• Obtain Solution Design approval from Caterpillar EDI Subject Matter Experts before submitting any and all EDI solution designs.

Data Design Lead or Specialty Data Designer

• 5+ years of experience working with IBM Integration products

• Knowledge of the following products and how to apply them in various business scenarios:

o IBM BPM (both ESB side and Workflow side)

o IBM ODM (Business Rules)

o IBM DataPower

o IBM IIB

o IBM MQ

o Denodo

• Strong verbal and written communications to document detailed integration requirements from business partners, non-technical integration requesters, as well as ability to effectively collaborate with other Subject Matter Experts.

• Ability to lead and guide the development work to meet the designs and requirements

• Desire and ability to understand Caterpillar business

• General knowledge of the following IT concepts:

o SOA (Web Services)

o API Management

o Data Integration

o Data Virtualization

table 4: scope of support

Support Type

Description

Data Project Assessment, Design and Development Coordination Services

Data Design Team will be responsible for gathering internal client requirements and creating Project Requirements Documents for data projects and solutions, creating Project Risk Assessments, creating Design Documents including Visio or flow diagrams, updating Project Folders (LAN Drive) with all required deliverables and supporting documentation, obtain design review/approval from Architects/Functional leads, and deliver / present the designs to development team for execution. The same resources may be employed to execute development activity as required by Caterpillar.

table 5: implementation approach

Phase

Action Items/Activities

Engagement Kickoff

• Verify Scope of Service / Deliverables

• Identify quality requirements and develop quality plan

• Confirm engagement governance model

• Review and refine standard engagement status report

Deploy On-Site Support Team

• Consultant will be responsible for all HR functions for its personnel including onboarding, oversight, termination, and recruitment of replacement personnel, as necessary.

• Integrate Supplier resources with internal operating rhythms and processes

On-going Support Service Improvement

• Provide continual Service Improvement/Optimization approach for team members

• Monitor status of Continual Improvement metrics against benchmarks

• Provide Quarterly Business Reviews

• Provide Process Review