Oracle ASCP Techno Functional consultant

Oracle ASCP Techno Functional Consultant

Cambridge, MA | 8 - 23 years of experience | Final date to receive applications: 03-Aug-2026

We are seeking an experienced Oracle ASCP Techno Functional Consultant to support and enhance our supply chain processes. The role involves both functional and technical responsibilities across Oracle EBS R12.2.

• Oracle EBS R12.2 Advanced Supply Chain Planning (ASCP)
• 8+ years of Techno/Functional experience (70/30 split)
• Experience with EBS Source Transactions and Fixed Data in the Process Manufacturing Domain
• Collections troubleshooting and Custom Collection Programs (Jobs)
• Integration between Demantra and ASCP for Forecast Publish
• ASCP to APCC Plan Output integration
• Unconstrained & Constrained Supply Plans, Plan Options, and Plan Parameters
• At least one ASCP implementation or support client experience
• Proficiency in PL/SQL, Oracle BI Reports, Interfaces, and OAF
• Design, develop, customize, and support Oracle EBS R12 applications in VCP (ASCP, IO)
• Build and maintain interfaces, conversions, extensions, reports, and RICEW components
• Support and maintenance of existing integrations, including Service Now
• Develop and optimize solutions using Oracle SQL, PL/SQL, Forms, Reports, XML Publisher, and OAF

• Provide functional and technical guidance during requirements analysis, solution design, and implementation phases
• Collaborate with business users to translate business needs into scalable solutions
• Troubleshoot and resolve complex technical issues to ensure system performance and stability
• Support system upgrades, patching, migrations, and data conversions
• Prepare and maintain functional and design documentation, assist with unit and integration testing
• Work with third‑party teams, coordinate until resolution, and close incidents and tasks within SLA

• Bachelor of Computer Science (or related field)
• Strong Oracle EBS R12 ASCP domain knowledge
• Proficiency in PL/SQL, Oracle SQL, and OAF
• Experience with interfaces, reports, and XML Publisher
• Problem‑solving skills and a customer‑focused mindset

$120,000 - $150,000 per year

• Discretionary Annual Incentive
• Comprehensive Medical & Health coverage (Medical, Dental, Vision, Disability, Pet Insurance)
• Family support including Maternal & Parental leaves
• Insurance options:
  Auto, Home, Identity Theft Protection
• Convenience & Professional growth:
  Commuter benefits, certification and training reimbursement
• Time off:
  Vacation, sick leave, holidays
• Legal & Financial assistance:
  Legal assistance, 401(k) plan, performance bonus, college fund, student loan refinancing

Cambridge, MA

Technology

Functional Consultant

415760