Tek08564

Oracle - 8 + Year


MCA - Computer Science

Highlights

Over 8+years of IT experience in Software Industry. Having 8 years of experience in Oracle Integration Cloud, remaining experience on Oracle SOA Suite and databases like Oracle.




  • Rich experience in designing and building Integrations (ICS), processes (PCS) and applications (VBCS) using Oracle Integration Cloud.

  • Expert in designing end to end integration flows between various systems (Oracle and Non-Oracle) and implementing them in Oracle Integration Cloud.

  • Worked in multiple Oracle ERP Cloud end-to-end Implementation projects as an Integration Specialist and Fusion Technical Principal Consultant.

  • Expertise in building Scheduled FBDI Automation integrations with Callback functionality in OIC.

  •  Designed Integrations to connect SaaS and On-Premises applications using connectivity agents in OIC.

  • Built Integrations using Business Event Subscription to achieve data sync between applications.

  • Developed integrations to connect multiple Oracle Cloud applications such as Oracle ERP Cloud, HCM Cloud, and Sales Cloud etc.

  • Designed and built integrations to connect cloud applications from different vendors such as Salesforce and Oracle ERP Cloud.

  • Expert in lifecycle management of OIC Components, fault handling and encryption in OIC, migration of OIC Components using packages, lookups, versioning and cloning of integrations.

  • Good experience in designing Outbound flows using Oracle Integration Cloud.

  • Rich implementation experience as an Oracle Fusion Technical Principal Consultant in ERP and HCM Cloud Implementation Projects.

  • Good experience in using Standard Data Loaders – FBDI, SDL, HCM DL and HSDL to load bulk data into ERP Cloud

  • Good knowledge of HCM specific concepts such as HCM Extracts, HCM Data Loader, Fast Formulas, and Workflow Approvals

  • Developed BIP Reports (using RTF layouts with bursting features) and OTBI analysis and dashboards.

  • Possess strong analytical & troubleshooting skills and can deliver in fast-paced environment.

  • In-depth experience in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation, and design reviews.


Skills
Primary Skills
  • OIC

Secondary Skills
  • PL/SQL
  • SQL
Other Skills

Operating Systems         :   Windows Family and UNIX
Middleware Tools            :  SOA Suite, OIC
RDBMS                           :  Oracle 19c
Web Technologies           : SOAP, REST, JSON, XML
Test Management Tools  :  SOAP UI,POSTMAN.
 

Projects

OIC & ERP Cloud Implementation Project (17 months)

    Project Description:



    Implementation of OIC , ERP and HCM Cloud.



    Roles and Responsibilities:




    • Built Scheduled Integration to automate the data load into HCM Cloud using HCM Data Loader service.

    • Designed and built FBDI automation integration in OIC to automate the load of GL Journals feed from BPM System to ERP Cloud daily.

    •  Built Callback Integration to upload the log and output files to SFTP and send notification email to user about Import status

    • Build Scheduled Integration to get the files from CS server and placed into SFTP server.


IT Consolidation– OIC & ERP Cloud Implementation Project (19 months)

    Project Description:



    Implementation of OIC , ERP and HCM Cloud.



    Roles and Responsibilities:




    • Designed and built FBDI automation integration in OIC to automate the load of GL Daily Rates feed from Core Banking System to ERP Cloud daily.

    •  Built Callback Integration to upload the log and output files to SFTP and send notification email to user about Import status.

    • Developed Business Event Subscription Based integration in OIC to send AR Invoice to Tax Authority for SDC signature and capture it back in AR Invoice in DFF attributes.

    • Built Integrations in OIC to connect Salesforce CRM System with Oracle ERP Cloud.

    • Built Scheduled Integration to automate the data load into HCM Cloud using HCM Data Loader service.

    • Developed custom payment file formats to generate feed of supplier payments from ERP AP Cloud and send it to Core Banking System.


OIC, ERP and HCM Cloud Implementation Project (19 months)

    Project Description:



    Implementation of OIC, ERP, HCM Cloud and EBS Payroll.



    Roles and Responsibilities:




    • Designed and build Complex AR Self Service extension using VBCS, PCS and Integrations in OIC.

    • Developed AR Self Service app user interface using VBCS,PCS, and it had around 10 complex pages to create/update/view/delete invoice requests etc.

    • Complex multi-layer & conditional approval process is designed in PCS with email notification, escalation and expiration features. Invoice requests submitted via this VBCS app needs to go through this complex approval route.

    • Once invoice request is approved, it needs to be sent over to ERP cloud and created as AR Invoice/Credit Memo and status of invoice also needs to be updated back on VBCS app as approved.

    • Designed and built FBDI Integration in OIC to load the Invoice Request in ERP Cloud on demand.

    • Built Callback Integration to upload the log and output files to SFTP and send notification email to user about Import status


Total Gas and Petrol (20 months)

    Project Description:



    The ESB service receives contract request from CRM, containing customer and contract details. The service is built to transfer the contract details from CRM based on product models configured in ESB rules and send contract details to HGZ.



    Roles and Responsibilities:




    • Study of Business and Functional requirements specification documents and identified test scenarios.

    • Worked on Functional requirements & business requirements to prepare test cases for system testing.

    • Preparing Report on Monthly basis.

    • Involved in testing for different interfaces.

    • Reprocessing the files for commission tool interfaces

    • Involved in Marvel tool, to manage the tickets for each one in the team

    • Worked on Different RFC’s.

    • Involved to Deployed Java Services using console deployment.

    • Maintained the test logs, test reports, test issues, defect tracking by using HP ALM.

    • Attended the daily Project status meetings.


Trade Automation (35 months)

    Roles and Responsibilities:




    • Design, develop and deploy Business process Orchestrated in BPEL and Mediator using JDeveloper and Oracle SOA Suite 12c.

    • Involved primarily in develop BPEL process.

    • Analyze the requirements and subsequently development of the integration module.

    • Integration and development of Oracle Mediator module.

    • Have worked on Oracle File adapter and Database adapter. Set up and configured them as well.

    • Design and development business process using BPEL PM and JDeveloper.

    • Implemented Oracle Mediator and integrate with BPEL.

    • Development BPEL process that contains exception handling to capture remote faults and binding faults.

    • Worked with fault policies to handle technical faults.

    • Worked with Error Handling Framework to handle faults.


Awards

Certifications:

  • OIC Certification

Similar Talent

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating
  • Inventory Management
  • Logistics and Distribution
  • OTM
  • GTM

View

Key Skills - Self Rating
  • ERP
  • IBM AS/400

View

Key Skills - Self Rating

View