Data Conversion Lead – Record to Report, Procurement, and Order to Cash

Position Title:

Data Conversion Lead – Record to Report, Procurement, and Order to Cash

Location:

Albany, NY. HYBRID

Position Overview

We are seeking an experiencedConversion Lead to own data conversion for the Finance, Procurement, and Order to Cash workstreams ofProject Fusion, a multi-phase Oracle Fusion Cloud ERP deployment. This role specializes in theRecord to Report (Finance), Procurement, and Order to Cash process areas, including but not limited to:

• General Ledger (GL)
• Fixed Assets (FA)
• Projects
• Accounts Payable (AP)
• Purchasing (PO)
• Accounts Receivable (AR)
• Order Management (OM)

The Conversion Lead reviews the functional and technical designs our System Integrator (SI) partner prepares, sets the guardrails and best practices that govern conversion, and coordinates the business owners, data cleanse teams, and technical stakeholders who deliver clean, reconciled data across every mock load and the final cutover. The ideal candidate combines deep finance, procurement, and supply chain data knowledge with hands-on Oracle Cloud migration experience and strong leadership skills.

Key Responsibilities

1. Conversion Strategy, Guardrails, and Best Practices

• Define the conversion approach, standards, and guardrails for all in-scope modules, including data ownership, load sequencing, entry and exit criteria for each mock load, and go/no-go criteria for cutover.
• Establish best practices for cutover cut-off dates, open-item versus historical data scope, balance conversion, and the treatment of inactive, duplicate, and obsolete records.
• Set data quality thresholds and sign-off standards, and enforce them across the SI team, business owners, and data cleanse teams.
• Maintain a conversion risk and issue log and escalate dependencies and risks to project leadership early.

2. Review of SI Functional and Technical Designs

• Review and challenge the functional design documents, technical design documents, field-level mapping specifications, and load templates the SI partner prepares for each conversion object.
• Confirm that designs align with the Fusion configuration, including but not limited to ledgers, chart of accounts, business units, legal entities, and module-specific setup.
• Verify that transformation rules, default values, validations, load sequencing, and error handling meet the guardrails we define, and that the designs support repeatable mock loads.
• Approve or return designs with documented findings and track remediation to closure.

3. Module-Specific Conversion Ownership

Own end-to-end conversion for the in-scope modules, including but not limited to:

General Ledger (GL)

• Balances
• Chart of Accounts mappings
• Journals

Fixed Assets (FA)

• Asset registers
• Depreciation balances

Projects

• Project structures
• Budgets
• Open balances

Accounts Payable (AP)

• Suppliers
• Open payables

Purchasing (PO)

• Open purchase orders
• Agreements

Accounts Receivable (AR)

• Customers
• Open receivables

Order Management (OM)

• Open sales orders
• Agreements

Additional Responsibilities:

• Manage cross-module dependencies and load sequencing, including supplier and customer masters, ledger setup, and Projects, so that each load completes in the correct order.

4. Data Cleanse and Business Coordination

• Lead the data cleanse strategy for Finance, Procurement, and Order to Cash data, including duplicate supplier and customer consolidation, address and tax standardization, bank account validation, and retirement of inactive records.
• Work with business data owners and data cleanse teams to assign owners, set cleanse deadlines, and resolve discrepancies identified in the legacy data.
• Define data standards and governance policies that support the ERP deployment and carry forward into steady-state operations.
• Facilitate regular working sessions among business users, functional leads, the SI partner, and technical teams so that all stakeholders agree on data requirements and mapping rules.

5. Mock Loads and Cutover

• Plan, schedule, and execute multiple rounds of mock data loads, and measure each round against the exit criteria.
• Track load results, error trends, and defect resolution across rounds to demonstrate steady improvement in data readiness.
• Lead the cutover conversion plan, including the load runbook, timing, dependencies, rollback options, and go-live support.
• Optimize load performance and sequencing to minimize downtime during the final migration.

6. Data Validation and Reconciliation

• Define and execute validation and reconciliation processes that confirm accuracy, completeness, and compliance with business rules.
• Reconcile legacy source systems to Oracle Fusion Cloud ERP at the balance and transaction level, including but not limited to:
  • Trial Balance
  • Subledger-to-GL Tie-Outs
  • Open Item Counts and Values
• Coordinate business user acceptance and sign-off on validation results for each module.
• Document and report validation results and open discrepancies to project stakeholders.

7. Data Migration Tools and Technologies

• Apply Oracle Fusion migration tools, including:
  • File-Based Data Import (FBDI)
  • ADF Desktop Integrator (ADFDI)
  • REST APIs
  • SOAP APIs
  • Oracle Enterprise Scheduler Service (ESS) Jobs
• Utilize supporting ETL and data quality tools.
• Use Oracle BI Publisher and OTBI reports, along with SQL-based queries, to support validation and reconciliation.
• Stay current with Oracle Fusion Cloud ERP data migration best practices, release changes, and new tooling.

8. Documentation and Reporting

• Maintain complete documentation of conversion processes, including:
  • Mapping Rules
  • Cleanse Logs
  • Validation Scripts
  • Reconciliation Results
  • Issue Logs
• Provide regular status updates to project leadership on:
  • Data Readiness
  • Mock Load Results
  • Cleanse Progress
  • Risks and Dependencies

9. Training and Knowledge Transfer

• Train business users, data stewards, and technical teams on data standards, governance, and conversion processes.
• Conduct knowledge transfer sessions so that data management practices are sustained after go-live.

10. Oracle EBS and Fusion Knowledge

• Knowledge of Oracle E-Business Suite (EBS) modules in scope, including:
  • GL
  • FA
  • PA
  • AP
  • PO
  • AR
  • OM
• Understanding of their underlying data structures.
• Knowledge of the corresponding Oracle Fusion Cloud ERP tracks and the differences in data models between Oracle EBS and Fusion.

Qualifications and Skills

Education

• Bachelor's degree in:
  • Finance
  • Accounting
  • Information Systems
  • Computer Science
  • Data Science
  • Related Field

Experience

• Proven experience leading data conversion on large ERP deployments, preferably Oracle Fusion Cloud ERP, with direct ownership of two or more of the in-scope modules (GL, FA, Projects, AP, PO, AR, OM).
• Hands-on experience with:
  • FBDI
  • ADFDI
  • REST APIs
  • Related migration tools and methodologies
• Demonstrated experience reviewing SI-prepared functional and technical designs and setting conversion standards.
• Strong background in:
  • Data Analysis
  • Data Validation
  • Financial Reconciliation
• Experience managing multiple mock loads and at least one full production cutover.

Technical Knowledge

• Expertise in SQL, data modeling, and database management.
• Familiarity with Oracle Fusion Cloud ERP data structures and integration frameworks.
• Knowledge of:
  • Data Governance
  • Data Quality Frameworks
  • Compliance Standards
• Working knowledge of Oracle EBS data structures for the in-scope modules.

Soft Skills

• Excellent analytical, problem-solving, and organizational skills.
• Strong communication and leadership abilities to guide cross-functional teams, SI partners, and business stakeholders.
• Ability to manage multiple priorities and deliver results in a fast-paced environment.