Oracle ASCP Advanced supply chain planning Techno Functional consultant

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

Job Description

Must Have Technical/Functional Skill

• Oracle EBS R12.2 Advanced Supply Chain Planning (ASCP)
• 8+ year experience Techno/Functional 70/30
• Experienced with EBS Source Transactions and Fixed Data in the Process Manufacturing Domain
• Experience with Collections and troubleshooting of Custom Collection Programs (Jobs)
• Experience with Demantra to ASCP for Forecast Publish
• Experience with ASCP to APCC for Plan Outputs
• Experience with Unconstrained, and Constrained Supply Plans, Plan Options and Plan Parameters
• Experience in IO desired
• Experience in one ASCP implementation or support client is a must
• Need to be proficient in PL/SQL, Oracle BI Reports, Interfaces & OAF

Roles & Responsibilities

• Design, develop, customize, and support Oracle EBS R12 applications in VCP (ASCP, IO)
• Build and maintain interfaces, conversions, extensions, reports, and workflows (RICEW components).
• Support and maintenance of existing integrations, use of ServiceNow, and experience.
• Develop and optimize solutions using Oracle SQL, PL/SQL, Forms, Reports, XML Publisher and OAF.
• Provide functional/technical guidance during requirements analysis, solution design, and implementation phases.
• Collaborate with business users to translate business needs into scalable functional/technical solutions.
• Troubleshoot and resolve complex technical issues; ensure system performance and stability.
• Support system upgrades, patching, migrations, and data conversions.
• Prepare and maintain functional and design documentation and assist with unit and integration testing.
• Working with third-party teams and coordinate until resolution.
• Ensure that incidents and tasks are closed on time as per defined SLA.

Salary Range

$130,000-$150,000 a year

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancin g.

Qualifications

BACHELOR OF COMPUTER SCIENCE