Wrishin Bhattacharya

• Oracle Integration Subject Matter Expert at IBM's Oracle Global Center of Competence, leading a pioneering project to develop a next-generation GEN AI Portal using Oracle APEX.
o Architected the portal's backend infrastructure leveraging advanced PL/SQL and Python for seamless data processing and response generation.
o Championed prompt engineering and integration with Business Requirement Documents (BRDs) using Cohere LLM models, optimizing document generation accuracy and efficiency through AI-driven insights.
• Integration Technical Solution Architect for a leading European Automobile organization's (Belgium HQ) Order Management and Supply Chain Management (automobile parts) system implementation.
o Collaboratively designed integration architecture solutions to precisely align with client's business objectives, leveraging industry best practices and domain expertise.
o Spearheaded the design and development of algorithms for predictive shipment arrival/departure times (ETA/ETD), enhancing logistics planning and delivery efficiency.
o Architected and implemented a Virtual Trucking System (VTS) for real-time fleet management and route optimization, leading to streamlined operations.
o Delivered comprehensive logistics integration solutions using Oracle Fusion SCM and Oracle Transportation Management, encompassing Inbound/Outbound logistics, route planning, load balancing, and AS400 integration.
o Ensured seamless end-to-end integration by implementing OIC (ICS, PCS) and VBCS to connect upstream and downstream systems.

• Oracle Integration Consultant for a diversified mining company (Kingdom of Saudi Arabia) in the gold, base metals, mining, and infrastructure industry.
o Strategically designed and delivered best-in-class integration processes for Shared Services and Business Operations, aligning with their evolving business goals.
o Leveraged cloud-based ERP and Oracle Transportation Management to design optimal integration solutions based on performance, data volume, and client needs.
o Delivered high-performance, real-time integration solutions between Oracle Transportation Management (Inbound Logistics), Oracle Procurement Cloud, Oracle Financial Cloud, and Oracle EBS R12, utilizing OIC (ICS, PCS), VBCS, and web services for seamless data exchange.

• End-to-End Application Integration Solution with Upstream and Downstream Systems using Mulesoft as Middleware platform, using Mule4
• Leading a team of 7 developers for delivering application Integration solutions
• Leading a team of 5 members to deliver reporting requirements for rollouts specific to US, Canada and India
• Developing complex OBIEE reports on Oracle Fusion Project Portfolio Management
• Developing complex OBIEE reports on Oracle Fusion Financials Receivables, Payables, General Ledger, Fixed Assets etc
• Technologies used: SQL, Oracle Fusion BI Publisher Reporting (OBIEE), Mule4
• Industry Experience:
• Pharmaceutical: PPD; Travel & Tourism: Hilton Global Vacation; Manufacturing: Aveva

• Identification of project scope and value by system Blueprinting
• Review of capabilities and limitations of Oracle Cloud Integration options and determine the integration requirements that are best fit for these options, based on performance and data volume and client requirement
• High performance, Real-Time Web-service (SOAP) based critical integration designs and development between Oracle Transportation Management, Oracle CX Cloud, Oracle SX Cloud, Oracle Taleo and Oracle EBS R12
• OIC Integration with Oracle EBS REST interfaces using SOA Gateway
• Implementing and setting up Oracle Procurement & Spend Analytics
• Oracle Supplier Sourcing Cloud and OTM cloud OBIEE Reports Development
• Process and test automation using OATS in highly agile structure
• Integrating AS/RS (Automated Storage/ Retrieval System) with Oracle EBS with Real-time data sharing
• Strongly coupled integration of Oracle EBS and SAS for dynamic, robust reporting using advanced analytics
• Using the capabilities of SAS to identify emerging issues early to prioritize them and resolve them early for lower cost and increased production yield with reduced scrap and rework rates
• Usage of predictive modelling to uncover hidden patterns and correlations that may lead to failures using SAS
• Capturing real-time customer feedback from external and internal sources to provide design suggestions or early warning of warranty and recall issues using Perceptual Quality Analysis
• Reducing unplanned downtime and eliminate unnecessary maintenance by predicting the likelihood of a failure in advance to perform orderly, planned maintenance and avoid costly line stoppages using High-Performance Analytics
• Experience in being Single point of contact in Client location for Oracle Fusion AP, AR, FA and GL module Techno-Functional Support
• Helped client in improving existing business processes by introducing ICS and OTBI Reporting
• Critical support during financial closure and audit in AP, AR, FA, and GL modules
• Offered friendly and efficient service to customers, handled challenging situations with ease.
• Proved successful working within tight deadlines and fast-paced atmosphere.
• Finance: Yes Bank, IFMR Capital (Northern Arc Capital); Oil and Gas: Waqood (Qatar Fuel); Manufacturing: Hindalco Industries
• Technologies used: PL/SQL, SQL, JAVA, PYTHON, SHELL SCRIPTS, JAVASCRIPT, GROOVY SCRIPT, Oracle EBS: OAF, Oracle Workflow, Oracle BI Publisher Oracle SOA 12c; Oracle Cloud: OIC, Oracle SOA CS, OBIEE, OTBI, Smart View Reporting, Oracle Analytics Cloud.

• High performance, Real-Time Web-service (SOAP) based critical integration designs and development between 3rd Party vendors like, Dun & Bradstreet (D&B), Google Maps using Google API, JPMC (J.P Morgan Chase) and Oracle EBS R12
• Implementation of Supplier Hub Framework including regular enrichment of supplier related details (Supplier Details, Supplier Site, Supplier Transaction etc.)
• Developing data conversions on various modules including Oracle EBS R12 SCM, Finance, Projects
• Implementing integrations including AR Lockbox and interfaces including Payroll File processing into Oracle EBS using the Payables Invoice Import Interface plus checks and payment creation
• Development of BI Publisher reports on modules including Inventory, Projects, Purchasing and EAM
• Development of critical interfaces like Cost Factor Maintenance and Invalid Bank Accounts Update.

• Worked as trainee in the organization as part of Fresher Training Program.
• Worked closely with engineers on projects.
• Prepared standard reports and documentation to communicate results to senior management.
• Shadowed senior engineers to learn ways to implement methodologies.