Oracle Agile PLM Data Extraction

I need an experienced engineer who has already worked inside Oracle Agile PLM (E6) to pull out Product data and Document data cleanly and reliably so that I can load it into Siemens Teamcenter. The engagement is entirely about safeguarding data integrity—I am willing to trade speed for absolute correctness. The work involves: • Understanding the E6 database schema, metadata tables, and file vault structure • Writing repeatable PL/SQL / SQL Plus queries or custom Java-based utilities that can scale to the full production volume • Exporting BOMs, items, revisions, attributes, attachments, and related files in a format Teamcenter import tools will accept (XML, CSV, JT, bulk-load packages, etc.) • Logging, error handling, and reconciliation reports that prove every record in Agile has an exact counterpart in the export set • A short knowledge-transfer session so my internal IT team can rerun the process for dress-rehearsal loads and the final cutover Acceptance criteria 1. 100 % record-level parity between Agile E6 source and the extracted data set, verified by checksum or row counts. 2. All files linked to Document data delivered with the correct folder structure and naming conventions expected by Teamcenter. 3. Scripts/utilities parameterised for environment variables (DB connection, date ranges, log paths) and handed over with commented source. If you have solid experience with Agile APIs, Oracle stored procedures, and Teamcenter import workflows, I would like to see a brief outline of your proposed approach and a timeline estimate.

Project ID: 40391720