Oracle ASCP Techno-Functional Consultant | EBS R12 Expert

Tata Consultancy Services; Cambridge (MA); On-site; USD 130,000 - 150,000; Full time

Benefits offered by this job

Discretionary Bonus

Medical Coverage

Parental Leaves

Insurance Options

Commuter Benefits

Training Reimbursement

Vacation & Holidays

Legal & Financial Assistance

Job summary

Tata Consultancy Services in Cambridge, MA seeks an experienced Oracle EBS R12 ASCP specialist with 8+ years' techno/functional background. You will handle ASCP forecasting, data conversions, and framework integrations, designing and supporting RICEW components.

Proficiency in PL/SQL and Oracle BI Reports is required. Responsibilities include building interfaces, optimizing supply plans, and guiding requirements analysis while collaborating with business users to deliver scalable solutions.

Qualifications

• 8+ years of Techno/Functional experience (70/30).
• Experience with Oracle EBS R12.2 ASCP and source transactions.
• Experience with ASCP to APCC for plan outputs and forecast publishing.

Responsibilities

• Design, develop, customize, and support Oracle EBS R12 applications in VCP (ASCP, IO).
• Build and maintain interfaces, conversions, extensions, reports, and workflows (RICEW).
• Develop and optimize solutions using SQL, PL/SQL, Forms, Reports, XML Publisher and OAF.
• Provide guidance during requirements analysis and solution design.
• Collaborate with business users to translate needs into scalable solutions.
• Troubleshoot complex issues and ensure system performance and stability.
• Support upgrades, patches, migrations, and data conversions.
• Prepare functional/design documentation and assist with testing.

Skills

Oracle EBS ASCP experience

Demantra to ASCP

IO/Constrained planning

Troubleshooting custom collections

PL/SQL proficiency

Oracle BI Reports

Interfaces & OAF

Education

Bachelor of Computer Science

Tools

PL/SQL

Oracle BI Reports

Interfaces & OAF

SQL

Forms

Reports

XML Publisher

Job description

Tata Consultancy Services in Cambridge, MA seeks an experienced Oracle EBS R12 ASCP specialist with 8+ years' techno/functional background. You will handle ASCP forecasting, data conversions, and framework integrations, designing and supporting RICEW components.

Proficiency in PL/SQL and Oracle BI Reports is required. Responsibilities include building interfaces, optimizing supply plans, and guiding requirements analysis while collaborating with business users to deliver scalable solutions.