Oracle Solution Architect

About

Oracle Solution Architect / Technical Lead (Onshore)

Key Responsibilities

• Lead Oracle Cloud (SaaS/PaaS) implementations, integrations, and support.
• Design and develop integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, and middleware tools.
• Create technical design documents, data mappings, and perform code technical reviews.
• Develop and customize BI Publisher (BIP), OTBI reports, dashboards.
• Manage Oracle Cloud environments including ATP database administration, user roles, and security.
• Collaborate with functional teams for end-to-end testing, UAT, and quarterly patch impact analysis.
• Implement integrations for Manufacturing (WIP, BOM), Order Management, Inventory, Fixed Assets, and Projects, Financials (AR, AP, GL).
• Support ERP integration with third-party systems like EDI (OpenText), Macpac (Legacy ERP), PLM Aras, Pay Trace, Bill Trust, and banking systems (like BMO).
• Should have knowledge of BICC (Business Intelligence Cloud Extract).
• Perform migration activities across OIC instances and maintain GitHub repositories and Oracle SFTP servers.
• Ensure compliance with audit requirements and maintain version history documentation.

Project Required Responsibilities and Knowledge Required – Manufacturing & Supply Chain

• Have knowledge of Oracle Manufacturing processes including Work in Process (WIP), BOM, and job creation.
• Develop and maintain integrations for Order Management (OM), Inventory (INV), and Procurement (PO) modules.
• Have knowledge of Advanced Pricing, item attributes, and product lifecycle updates for manufacturing operations.
• Implement technical solutions for Contract Manufacturing, Drop Ship, and RMA processes.
• Have knowledge of Supply Chain orchestration for B2B and B2C order flows, fulfillment, shipment, and delivery.

Required Skills

• Excellent problem-solving, documentation, and client interaction skills.
• Excellent communications skills to handle audience during Onshore presence.
• Technical Expertise: SQL, PL/SQL, Oracle Integration Cloud (OIC), VBCS, OTBI/BIP, AIP Database.
• Process Knowledge: Oracle Manufacturing, Supply Chain, Order Management, Financials.
• Strong experience in Oracle Cloud ERP customizations and integrations.
• Proficiency in BI Publisher and Oracle Cloud methodology.

Experience

• 16+ years in Oracle Applications (Techno-Functional).
• Hands-on experience with Oracle Cloud implementations, ERP integrations, and automation projects.
• Worked with global clients across industries (Tech, Manufacturing, Hi-Tech).
• Should be able to travel to Client Location in USA during required Project Phases.