Oracle Integration & RAG Specialist for ERP Implementations

ASHIS SHAW

Oracle Integration Cloud Consultant OIC and Workato Specialist Oracle Certified Professional ************@*****.*** +91-974******* Hyderabad, India linkedin.com/in/ashis-shaw-4454291a3 PROFESSIONAL SUMMARY

Oracle Integration Cloud (OIC) and Workato integration consultant with 3.7 years of end-to-end ERP implementation experience delivering 50+ enterprise integrations across 5 full-cycle Oracle Cloud ERP projects. Consistent track record of eliminating manual processing across Order-to-Cash, Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), and Human Capital Management (HCM) workflows. Deep expertise in B2B EDI (X12 850, 810, 856), event-driven architectures on AWS SQS and Azure Service Bus, and cross-platform integrations connecting Snowflake, Salesforce, FinancialForce, and Workday with Oracle ERP Cloud. Holds three Oracle Cloud certifications including OCI Generative AI Professional and Oracle Fusion AI Agent Studio. Hands-on experience building Retrieval-Augmented Generation (RAG) solutions on AWS Bedrock and Oracle Cloud Infrastructure (OCI). Thrives in high-ownership, delivery-focused environments where accountability and speed of execution matter. TECHNICAL SKILLS

Integration Technologies:

Oracle Integration Cloud (OIC), Workato, OIC B2B, EDI AS2, EDI X12, REST API, SOAP Web Services, XSLT, XPath, Oracle Integration Platform

Oracle ERP Cloud:

Oracle ERP Cloud, Order Management, Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Human Capital Management (HCM), OIC Adapters, Fusion ERP Adapter, FTP Adapter, REST Adapter, OTM Adapter, FBDI, Oracle ERP Data Loading Cloud Platforms:

Amazon Web Services (AWS), AWS SQS, AWS Bedrock, Microsoft Azure, Azure Service Bus, Azure Active Directory, Oracle Cloud Infrastructure (OCI)

AI and Machine Learning:

Retrieval-Augmented Generation (RAG), AWS Bedrock, OCI Generative AI, Oracle Fusion AI Agent Studio, Large Language Models

(LLM)

Programming Languages:

Python, JavaScript, Java, Oracle SQL, PL/SQL

Methodologies:

Agile, Scrum, Root Cause Analysis, Performance Tuning, Code Review, Custom Solution Design, UAT Support WORK EXPERIENCE

Staff Consultant - OIC and Integration Specialist

Apps Associates India Pvt. Ltd., Hyderabad, India

August 2022 - Present

- Delivered 50+ real-time and scheduled Oracle Integration Cloud (OIC) and Workato integrations across 5 full-cycle Oracle ERP Cloud implementations, achieving 95 to 99 percent reduction in manual processing time through end-to-end workflow automation.

- Owned the full integration lifecycle including requirements gathering, technical design, build, testing, UAT support, and production go-live across all client engagements with zero critical post-launch defects.

- Automated the Order-to-Cash cycle by building B2B EDI pipelines (X12 850, 810, 856) for 5+ trading partners, enabling fully touchless purchase order and invoice processing with 100 percent elimination of manual data entry errors.

- Designed an event-driven AWS SQS integration to process real-time payment notifications into Oracle AR Receipts, accelerating the financial close cycle with 500+ daily automated transactions.

- Architected reusable OIC integration patterns adopted across 3 enterprise projects, cutting system onboarding time by 40 percent and reducing build effort for subsequent integrations.

- Maintained 99.9 percent uptime across 15+ production integrations through proactive monitoring, alerting, and performance tuning with no unplanned downtime incidents.

- Orchestrated cross-platform Workato recipes connecting Snowflake, Salesforce, and FinancialForce with Oracle ERP Cloud, automating data synchronization across enterprise ecosystems. KEY PROJECTS

DuckCreek Insurance Integration (Workato)

January 2026 - Present

- Designed Workato recipes to integrate the DuckCreek insurance platform with Oracle ERP Cloud, automating premium billing and claims payment workflows end to end.

- Built real-time data synchronization pipelines from DuckCreek Policy and Claims modules into Oracle AR and AP, reducing claims processing turnaround by 80 percent and ensuring financial data consistency. On Lok ERP Implementation

October 2025 - Present

- Streamlined Accounts Payable (AP) processing by automating invoice synchronization from an external claims platform via SFTP, reducing manual data entry by 90 percent.

- Integrated ADP Payroll with Oracle General Ledger (GL) to automate payment posting, ensuring 100 percent accuracy in financial reporting.

- Implemented bi-directional real-time sync between Azure Active Directory and Oracle HCM Cloud, automating user provisioning for 500+ employee records with zero manual intervention.

- Built ETL pipelines to migrate data from 3 external systems into Oracle ERP Cloud with comprehensive validation, achieving a 100 percent first-pass data load success rate.

ECO Material Technologies - Phase 2

May 2025 - December 2025

- Automated shipment data synchronization from Oracle Transportation Management (OTM) to Oracle ERP Cloud, improving logistics data accuracy by 100 percent and eliminating manual reconciliation.

- Developed an Azure Service Bus integration to auto-create sales orders from MQ messages, processing 200+ daily transactions with built-in data validation.

Trajector SaaS Implementation (FinancialForce)

February 2025 - August 2025

- Built an event-driven Oracle Integration Cloud (OIC) integration using the AWS SQS Adapter to process real-time billing notifications from FinancialForce, automating 500+ daily AR Receipt creations in Oracle ERP Cloud.

- Resolved a critical ERP billing defect by engineering a custom OIC workaround for late fee calculations within the FinancialForce billing workflow, restoring 100 percent billing accuracy for all affected accounts. ZOLL ERP Implementation

July 2023 - August 2025

- Deployed 40+ Oracle Integration Cloud (OIC) integrations connecting legacy systems to Oracle ERP Cloud across Order Management, Accounts Receivable (AR), and Pricing, cutting Order-to-Cash manual processing time by 95 to 99 percent.

- Configured the OIC B2B gateway and developed EDI data maps (X12 850, 810, 856) for 5 key trading partners, achieving straight-through processing with zero manual intervention on purchase orders and invoices.

- Translated 20+ business requirements into technical specifications and delivered all integrations on schedule with zero critical post-launch defects.

CERTIFICATIONS

- Oracle Cloud Infrastructure 2025 Certified Application Integration Professional - August 2025

- Oracle Fusion AI Agent Studio Certified Foundations Associate (Rel 1) - July 2025

- Oracle Cloud Infrastructure 2024 Generative AI Certified Professional - June 2025 EDUCATION

Bachelor of Technology - Computer Science

Hooghly Engineering and Technology College, West Bengal, India 2018 - 2022 CGPA: 8.82 / 10

Contact this candidate