Ekloud, Inc.

<p>ROLE OVERVIEW •&nbsp;Act as the PeopleSoft Operations domain Subject Matter Expert (SME) for the data platform modernization program. •&nbsp;Provide deep functional and technical knowledge of PeopleSoft Supply Chain Management, Inventory, Manufacturing, Procurement, and related Operations modules. •&nbsp;Drive source-to-target mapping from PeopleSoft Operations tables to the canonical enterprise data model for Operations 360 data products. •&nbsp;Collaborate with Operations leadership (VP Manufacturing, Supply Chain Directors, Plant Managers) to validate business rules, KPIs, and operational reporting logic. •&nbsp;Support the data engineering team in building accurate, high-quality data pipelines from PeopleSoft Operations modules into the GCP data lake. KEY RESPONSIBILITIES 1. PeopleSoft Functional &amp; Technical Expertise •&nbsp;Provide end-to-end functional expertise across PeopleSoft Supply Chain Management, Inventory, Purchasing, Manufacturing (Production Management), Warehouse Management, and related Operations modules. •&nbsp;Explain PeopleSoft Operations module configurations, business unit structures, item master setups, and manufacturing process flows as implemented. •&nbsp;Identify and document PeopleSoft customizations, bolt-ons, and extensions that impact Operations data structures and business logic. •&nbsp;Map PeopleSoft Operations transactions end-to-end — from procurement through receiving, production, inventory management, shipping, and logistics. •&nbsp;Articulate how -specific business rules (plant performance calculations, BOM structures, demand planning, SIOP targets, capacity agreements) are implemented in PeopleSoft. 2. Enterprise Data Modelling &amp; Source-to-Target Mapping •&nbsp;Lead source-to-target mapping (STM) for PeopleSoft Operations tables to the canonical Operations 360 enterprise data model. •&nbsp;Document PeopleSoft record definitions, field structures, translate/prompt tables, tree structures, and SetID-based configurations for Operations modules. •&nbsp;Identify primary keys, foreign keys, join conditions, and cardinality across PeopleSoft Operations tables — including inventory, purchasing, manufacturing, and logistics tables. •&nbsp;Define data dictionaries and business glossaries for all Operations-related PeopleSoft fields being mapped to the data lake. •&nbsp;Collaborate with the Enterprise Data Model (EDM) team to validate entity relationships, resolve naming conflicts, and ensure source-agnostic harmonization. 3. Data Product Design &amp; Validation •&nbsp;Support the design and validation of 58 Operations 360 data products — including Inventory, BOM, Production, Plant Performance, Freight &amp; Logistics, EHS, Asset Maintenance, Procurement, and Retail operations. •&nbsp;Validate transformation logic, business rules, and calculated fields as PeopleSoft Operations data moves through Raw → Transform → DaaP layers. •&nbsp;Perform source-to-target reconciliation to ensure data completeness, accuracy, and consistency between PeopleSoft source and data lake targets. •&nbsp;Support UAT by providing expected results, test scenarios, and validation criteria based on PeopleSoft Operations business logic. •&nbsp;Define data quality rules (inventory balance validations, BOM completeness, purchase order integrity) specific to PeopleSoft Operations datasets. 4. Cross-System Harmonization •&nbsp;Collaborate on the PeopleSoft-to-SAP S/4HANA data merge strategy for Operations entities — defining which source masters each field (material master, plant, storage location), handling ID crosswalks, and resolving conflicting business rules. •&nbsp;Support harmonization of Operations data across PeopleSoft, SAP, and MES (Manufacturing Execution Systems) into a unified canonical model. •&nbsp;Map PeopleSoft Operations hierarchies (product, plant, warehouse, cost center) to the enterprise-wide hierarchy model. •&nbsp;Support integration with non-SAP operational systems — MES/shop floor systems, freight audit platforms, EHS compliance systems, and retail portal feeds (Home Depot, Lowe's). 5. AI Tools &amp; Modern Discovery •&nbsp;Leverage AI-powered tools (e.g., GitHub Copilot, ChatGPT, Claude, Gemini, or similar) to accelerate discovery of PeopleSoft configurations, customizations, and data flows. •&nbsp;Use AI tools to reverse-engineer undocumented PeopleSoft implementations — including stored procedures, SQR programs, Application Engine logic, People Code, and integration points. •&nbsp;Apply AI-assisted techniques for automated documentation generation, code analysis, and schema discovery to reduce manual investigation time. •&nbsp;Proactively explore how AI can accelerate source-to-target mapping, data profiling, and anomaly detection across PeopleSoft datasets. 6. Stakeholder Engagement &amp; Communication •&nbsp;Interface directly with leadership — including VPs, Directors, and Senior Managers — to gather requirements, validate business rules, and present findings. •&nbsp;Translate complex PeopleSoft technical concepts into business-friendly language for non-technical stakeholders. •&nbsp;Participate in solution forums, design reviews, sprint demos, and steering committee meetings as the domain authority. •&nbsp;Collaborate with Kloud9 data engineers, data architects, data analysts, and QA teams to ensure accurate implementation of PeopleSoft business logic in the new data lake. •&nbsp;Produce clear, comprehensive documentation — including functional specification documents (FSDs), data dictionaries, business glossaries, and entity relationship diagrams (ERDs). DOMAIN-SPECIFIC PEOPLESOFT KNOWLEDGE REQUIRED The candidate must demonstrate deep, hands-on expertise in the following PeopleSoft Operations areas: Inventory Management •&nbsp;PeopleSoft Inventory module — item master, stock management, inventory transactions, putaway, picking, shipping, and cycle counting. •&nbsp;Tables: PS_MASTER_ITEM_TBL, PS_BU_ITEMS_INV, PS_IN_DEMAND, PS_SHIP_INF_INV, PS_RECV_LN_SHIP, and related inventory tables. •&nbsp;Inventory valuation methods (FIFO, LIFO, weighted average, standard cost) and their configuration in PeopleSoft. •&nbsp;Inventory in-transit tracking, inter-unit transfers, and consignment inventory management. •&nbsp;Material movements — receipts, issues, adjustments, transfers, and their impact on GL postings. Procurement &amp; Purchasing •&nbsp;PeopleSoft Purchasing module — requisitions, purchase orders, receipts, vendor management, sourcing, and contract purchasing. •&nbsp;Tables: PS_PO_HDR, PS_PO_LINE, PS_PO_LINE_SHIP, PS_RECV_HDR, PS_RECV_LN, PS_REQ_HDR, PS_REQ_LINE, and related purchasing tables. •&nbsp;Procurement workflows — from requisition approval through PO creation, goods receipt, and three-way matching. •&nbsp;Purchase order schedules, blanket purchase orders, and buying agreement structures. •&nbsp;Vendor performance tracking, vendor scorecards, and supplier qualification data. Manufacturing &amp; Production •&nbsp;PeopleSoft Manufacturing (Production Management) module — production orders, work orders, bill of materials (BOM), routings, and shop floor control. •&nbsp;Tables: PS_PROD_ID, PS_PROD_ITEM, PS_EN_BOM_COMPS, PS_EN_BOM_HDR, PS_CM_COMP_COST, and related manufacturing tables. •&nbsp;Bill of Materials (BOM) structures — single-level and multi-level BOMs, phantom items, substitute items, and co-products/by-products. •&nbsp;Labor and overhead cost calculations, routing time, production rate tracking, and OEE (Overall Equipment Effectiveness) metrics. •&nbsp;Production tracking — production details, unplanned downtime, quality metrics, and scrape/waste reporting. Warehouse &amp; Logistics •&nbsp;PeopleSoft Warehouse Management — warehouse structures, zones, locations, putaway rules, and picking strategies. •&nbsp;Freight and logistics data — freight audit, lane routing, accessorial surcharges, standardized freight lane distances, and transportation management. •&nbsp;Shipment tracking, delivery tracking, dock &amp; yard management, and truckload capacity planning. •&nbsp;Global shipping capacity, customer shipping agreements, and logistics stop/leg detail tracking. Asset &amp; Maintenance Management •&nbsp;PeopleSoft Asset Management as applied to plant operations — asset inventory, preventive maintenance schedules, work orders, and purchase requisitions for maintenance. •&nbsp;Tables: PS_ASSET_MASTER, PS_AM_WO_HDR, PS_AM_WO_TASK, PS_AM_PM_SCHED, and related maintenance tables. •&nbsp;Preventive maintenance scheduling, condition-based maintenance triggers, and maintenance cost tracking. •&nbsp;Plant worker training records, certifications, and compliance tracking data structures. Demand Planning &amp; SIOP •&nbsp;Demand planning data structures in PeopleSoft — demand forecasts, demand planning parameters, planning BOM, and forecast consumption logic. •&nbsp;Sales, Inventory &amp; Operations Planning (SIOP) — SIOP targets, production forecasts, weekly outage tracking, and capacity planning. •&nbsp;Customer capacity agreements, climate zone segmentation, and seasonal demand patterns. •&nbsp;Retail operations — retail customer data, retail inventory, retail forecasting, and retail planned production (Home Depot, Lowe's feeds). EHS &amp; Safety •&nbsp;Environmental, Health &amp; Safety (EHS) data structures — incident management, action tracking, site details, safety &amp; quality employee inputs. •&nbsp;EHS compliance reporting data — inspection records, corrective actions, safety metrics by plant/site. •&nbsp;Quality management — quality test results, non-conformance tracking, and quality hold processing. MANDATORY REQUIREMENTS •&nbsp;12–15 years of hands-on PeopleSoft experience with deep expertise in the Operations domain. •&nbsp;Extensive knowledge of PeopleSoft schemas, record definitions, field structures, tree structures, and table relationships for Operations modules. •&nbsp;Experience with PeopleSoft query tools, SQR rep</p>


Peoplesoft SME Operations Domain

Peoplesoft SME Operations Domain

This job is no longer available

Talents

Recruiters

About