Summary
Overview
Work History
Education
Skills
Phone
Accomplishments
Certification
Timeline
Generic
ARYA RAJAN

ARYA RAJAN

Ernakulam

Summary

Oracle Applications consultant with extensive experience at GapBlue Software Labs, specializing in SQL PL/SQL development and OAF customizations. Proven track record in delivering innovative integration solutions and enhancing approval workflows. Adept at technical documentation and collaborating with cross-functional teams to drive project success and exceed client expectations.

Overview

1
1
Certification

Work History

Technical Developer

Aviat Networks
  • This project mainly includes support of Quoting and Purchasing tracks.
  • Worked on several OAF and PL/SQL extensions.
  • Designed and implemented Approval Management Engine for Quoting, iProcurement and iExpense.
  • Workflow customizations, PLSQL and OAF extensions and personalization for purchasing module.
  • Design and developed Finance Approval flows for iProcurement in AME based on different criteria.
  • Took part in Kaizen in Finance, Purchasing and Quoting modules.
  • Also part of several projects like Roxy in Quoting module which includes configurator java extensions as well as PLSQL package development, Database 19C upgrade support.
  • Designed and developed Salesforce to Oracle interface for opportunity to quote creation and also customer account creation.
  • Implemented the process successfully and worked on several enhancements after this.
  • Technical support for Noetix Upgrade in Aviat.
  • Technical support in COR file upload process.
  • Development of SOCO tool in Order Management module which allows user to update the sales orders.
  • Involved in developing PL/SQL packages for the functionalities in SOCO Excel tool.
  • Defined approval rules for SOCO in Approvals management engine and created a custom workflow for handling approval process.
  • Prepared the detailed test plans and test scripts for Purchasing and Quoting modules.
  • Executed the entered test scripts and fixed the issues raised.
  • Handled enhancements and bug fixations of iProcurement, iExpense, Quoting modules.

Technical Consultant

Exp World Pharmaceuticals
  • Project at Expworld involves R12 implementation of Oracle eBusiness Suite modules Receivables, Purchasing and iProcurement modules.
  • Created many custom functionalities and reports in order management and Financial Modules.
  • Designed and implemented Approval Management Engine for iProcurement and Quoting Approvals.
  • Developed java extensions in Quoting.
  • Requirements gathering and providing technical solution.
  • Delivery of technical objects which include Reports and custom extensions.
  • Customizations and personalization in OAF.
  • Customizations and coding for showing back approvers in AME.

Technical Analyst

Invensense
  • Project involves upgrading Oracle EBusiness Suite from R12.1.5 to R12.2.10.
  • As part of this project, custom objects are reviewed and identified the changes to be made for to comply the standards of upgraded system.
  • Custom objects include Oracle reports, Oracle forms, OAF personalization and customizations, Oracle packages and functions registered as concurrent request, interfaces to third party systems etc.
  • Modify existing custom objects in current release to comply the standards and functionalities of the upgraded release.
  • Validated the objects before the migration to UAT and PROD.

Technical Consultant

Good Technology
  • Project at Good technology involves R12 implementation of Oracle eBusiness Suite modules like Payables and Purchasing.
  • Worked on interfaces in both PO and Requisitions.
  • Developed a concurrent program for bulk create, update and delete of supplier and supplier site details.
  • Performance enhancement, SQL Query tuning.
  • Coordinating code migration.
  • Preparing Migration and testing documents.

Technical Developer

GapBlue-BOT Development
  • Developed PL/SQL packages for handling various oracle approval notifications via BOT.
  • Using this BOT, users will be able to take actions like Approve, Reject, Request more information in the notifications they received.
  • Also they can search their notifications based on category, type of notification (FYI, TO DO) etc which will make the approval process easy.
  • Also worked on inbound and outbound integration for getting Supplier details from Oracle Fusion for validating in Oracle Apex and create the invoice in Fusion using REST API if validation is success.

Oracle Fusion Techno-Functional Consultant

NetApp
  • This project was mainly a conversion of Oracle 11i reports to Oracle fusion cloud.
  • Collaborated with functional consultants to understand business processes and translate them into technical requirements.
  • Developed custom reports, dashboards, and analytics using Oracle BI Publisher and OTBI (Oracle Transactional Business Intelligence).
  • Designed and developed technical solutions using Oracle Integration Cloud to meet customer needs.
  • Documented technical specifications, design documents, and user manuals for Oracle Fusion implementations and customizations.
  • Performed unit testing, integration testing, and performance testing to ensure the quality and functionality of custom-built solutions.
  • Participated in the UAT (User Acceptance Testing) phase, providing support and resolving defects raised by the client.

Education

B.Tech - Computer Science and Engineering

Calicut University
12.2013

Skills

  • SQL PL/SQL development
  • Oracle Applications
  • Oracle Workflow
  • Integration solutions
  • OAF customizations
  • Approvals Management Engine
  • Technical documentation

Phone

+91, 9539353245

Accomplishments

  • Best employee of the year
  • Ace award

Certification

  • Salesforce administrator
  • Salesforce platform developer

Timeline

Technical Developer

Aviat Networks

Technical Consultant

Exp World Pharmaceuticals

Technical Analyst

Invensense

Technical Consultant

Good Technology

Technical Developer

GapBlue-BOT Development

Oracle Fusion Techno-Functional Consultant

NetApp

B.Tech - Computer Science and Engineering

Calicut University
ARYA RAJAN