Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

Shankar Saha

Oracle Apps Techno Functional Consultant
Abu Dhabi,UAE

Summary

  • More than 14 years of IT experience on Oracle Applications 11i/R12. Worked on design, analysis development, implementation and support of various commercial applications in ERP using Oracle Applications/ E-Business Suite (EBS) 11i/R12, Oracle Database 12c/11g/10g/9i.
  • Has Expertise in Financial modules (i.e. AP, AR, GL), SCM, Procurement, Application Object Library (AOL) and System Administrator modules as well.
  • Very Good Exposure in HRMS Module Technical as well as functional aspects.
  • Has hand on experience in Payroll, Self Service, PMS Module Technical as well as functional aspects.
  • Have good knowledge in Production module also.
  • Good Experience in RICE components development and Customizations. Excellent skills in development of Reports (D2K) & Interfaces (Inbound using SQL*LOADER and Outbound using UTL_FILE Packages) from various modules.
  • Developed Custom Alerts (Event based and Periodic)
  • Lot of Exposure in creating and managing Custom API and using Seeded Oracle API efficiently.
  • Good hands-on experience Creating & Managing Custom Oracle Workflow using Oracle Workflow Builder
  • Good knowledge in Oracle AME
  • Hands-on Experience using Oracle XML/BI Publisher.
  • Have Expertise on Oracle OBIEE (Oracle Business Intelligence Suite Enterprise Edition)
  • Have good experience in XML Bursting
  • Hands-on experience in OAF (Oracle application Framework). Created VO, CO Extension
  • Good experience in Integrated SOA Gateway (ISG).
  • Created Web services (SOAP & REST) for exporting and importing data into or from other ERP.
  • Have Expertise in Inbound & Outbound Interfaces for integrating Oracle with third party tool.
  • Developed Supplier Conversion, Customer Conversion, Invoice Conversion, Employee Conversion, Assignment Conversion Program for Data migration from 11i to R12
  • Has Created Company Profit & Loss Report and Company Balance Sheet.
  • Good exposure to Order-to-Cash (O2C) & Procure-to-Pay (P2P) cycles and Multi Org concepts.
  • Has Good know how on TCA architecture.
  • Created Custom Interface program for Auto Lockbox as per the client's requirement.
  • Experience in writing SQL*Loader control programs, Stored Procedures, Functions & Packages using SQL and PL/SQL.
  • Have good knowledge on Oracle HCM Cloud environment.
  • Developed new Oracle forms and Customization of seeded oracle forms by using Form Personalization.
  • Awarded by Monthly Summit Award for excellent business support, Excellent contribution in the project and for the best coordinator.
  • Expertise in System Administrator Responsibility and Application Object Library (AOL) Responsibility to application user setup, defining Responsibilities, Value sets, Flex fields, Registering Concurrent Programs, Executables, Menus, reports and PL/SQL method of submitting Concurrent programs.
  • Having very good experience in AIM documents (MD's and CV's) preparations.
  • Delivered the objects with quality measures in timeliness and accuracy. An effective communicator with excellent relationship building & interpersonal skills. Capable of working independently and as well as a part of team.

Overview

13
13
years of professional experience
4
4
years of post-secondary education
8
8

Programming Languages

Work History

Oracle Application Professional

Abu Dhabi National Hotels
Abu Dhabi , United Arab Emirates
2021.11 - Current
  • Creating Reports, Forms, Alerts, OAF Page, Interface, Custom API, Web Service, BI Reports, AME etc..
  • Creating new Report based on the requirement from the users in Finance, Procurement,Sales,SCM,Inventory,Order Management, Production, Core HRMS & Payroll, Self Service etc. module.
  • Creating BI Report using Oracle OBIEE
  • Creating Custom API for Data Migration, Interfaces etc.
  • Using AME for generating & managing custom Approval hierarchy.
  • Generating Custom Workflow using Oracle Workflow Builder for Approval & Notification process.
  • Doing Functional setups & resolving functional issues in Oracle Finance, Procurement, SCM, Core HRMS & Payroll, Self Service, PMS, OTM, Manufacturing etc..
  • Developing Forms/Reports and Unix Shell Scripts for data upload etc.
  • Did Form Customization, Personalization in Oracle Form Builder and creating, customizing and personalizing pages in OAF.
  • In ISG creating Web Services to import & export data between other ERP like Dynamics, SAP etc.
  • Working on Oracle HCM Cloud environment.

Senior Oracle Apps Technical Functional Consultant

Fujairah Building Industries PSC.
Fujairah , United Arab Emirates
2020.06 - 2021.10
  • Doing Functional setups & resolving functional issues in Oracle Finance, Procurement, SCM, Core HRMS & Payroll, PMS, OTM, Self Service, Manufacturing etc..
  • Developing Forms/Reports and Unix Shell Scripts for data upload etc.
  • Creating Inbound & Outbound Interfaces for several Third party tool like RetailPro, Weighbridge etc.
  • Created Custom Forms in Form Builder 6i,9i&10g
  • Created Custom Project Module for creating and managing Projects
  • Did Form Customization, Personalization in Oracle Form Builder and creating, customizing and personalizing new pages in OAF.
  • Developed Custom Value Sets, Custom Oracle Responsibilities
  • Developed Custom Alerts (Event based and Perodic)
  • Creating OAF pages using Jdeveloper.
  • In ISG creating Web Services to import & export data between other ERP like Dynamics, SAP etc.
  • Created a Migration and Backup tool for taking back up of the Developing Elements such as Concurrent Program, Value Sets, Alerts, Profile etc..
  • Customization of Oracle standard forms by using Forms Personalization.
  • Coded SQL* loader scripts to extract data from legacy systems to flat files by using UTL_FILE packages.
  • Created SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing of legacy data from feeder systems to Oracle Applications.
  • Developed XML templates & BI Reports as per the client requirement
  • Preparing AIM documents (MD50,MD70,MD120).
  • Working on Oracle HCM Cloud environment.

Senior Oracle Apps Technical Functional Consultant

Injazat Data Systems (Payroll Company - Raqmiyat LLC)
Abu Dhabi , United Arab Emirates
2019.03 - 2020.06
  • Creating Reports, Forms, Alerts, OAF Page, Interface, Custom API, Web Service, BI Reports, AME etc..
  • Doing Functional setups & resolving functional issues in Oracle Finance, Procurement, SCM, Core HRMS & Payroll, PMS, Self Service, Manufacturing etc..
  • Creating new Report based on the requirement from the users in Finance, Procurement,SCM,Order Management, Core HRMS & Payroll, Self Service etc. module.
  • Creating BI Report using Oracle BI Publisher
  • Doing Functional setups & resolving functional issues in Oracle Finance, SCM, Core HRMS & Payroll, Oracle Self Service etc..
  • Developing Forms/Reports and Unix Shell Scripts for data upload etc.
  • Created Custom Forms in Form Builder 6i,9i&10g
  • Did Form Customization, Personalization, creating new Pages in OAF.
  • Creating Custom API & Custom Oracle Workflow for various requirement.
  • Developed Custom Value Sets, Custom Oracle Responsibilities
  • Developed Custom Alerts (Event based and Perodic)
  • Did Customization, Personalization in iSuuplier, iProcurement module using OAF.
  • Creating OAF & ADF pages using Jdeveloper.
  • In ISG creating Web Services to import & export data between other ERP.
  • Developed XML templates & BI Reports as per the client requirement.
  • Preparing AIM documents (MD50,MD70,MD120).
  • Created a Migration and Backup tool for taking back up of the Developing Elements such as Concurrent Program, Value Sets, Alerts, Profile etc..

.Working on Oracle HCM Cloud environment.

Oracle Techno Functional Consultant

Al Abbas Group
Dubai , United Arab Emirates
2014.03 - 2019.02
  • Requirement gathering, analysis and feasibility study of new requirements/enhancements/change requests.
  • Creating new Report based on the requirement from the users in Core HRMS & Payroll, SCM, Production module.
  • Doing Functional setups & resolving functional issues in Oracle Finance, Procurement, SCM, Core HRMS & Payroll, PMS, Self Service, Manufacturing etc..
  • Creating new Procedures, Functions, Fast Formula, Oracle Report, Oracle XML Publisher Report etc..
  • Developing Forms/Reports and Unix Shell Scripts for data upload etc.
  • Worked on design, analysis development, implementation and support of various commercial applications in ERP using Oracle Applications/ E-Business Suite (EBS) 11i/R12, Oracle 10g/9i and Oracle Developer 10g/2000.
  • Creating & Managing Custom Oracle Workflow using Oracle Workflow Builder.
  • Working on Oracle XML/BI Publisher.
  • Creating & Managing Reports in OBIEE (Oracle Business Intelligence Suite Enterprise Edition)
  • Creating & Managing Approval in various module using Oracle AME.
  • Developed Report Bursting using XML Bursting.
  • Working on OAF (Oracle application Framework). Created custom OAF pages.
  • VO & CO Extension of Standard and Custom OAF pages.

. Working on Integrated SOA Gateway (ISG). Created Web services (SOAP & REST)

Oracle Technical Consultant

Mphasis
Pune , India
2010.09 - 2014.01
  • Requirement gathering, analysis and feasibility study of new requirements/enhancements/change requests.
  • Coding, testing and documentation of enhancements/change requests involving development/modification of forms/reports/PL-SQL program Units.
  • Developing Forms/Reports and Unix Shell Scripts for data upload etc.
  • Involved in the RICE Components Development and Customization of Procure to pay cycle and Order to Cash Cycle.
  • Creating a defect-free code in line with the technical design and coding standards.
  • Involved in the Package development and Customization.
  • Customized oracle SQL, PL/SQL Packages for interface programs.
  • Migration of Custom Objects (Reports, Views, Interface programs, Forms, Alerts) from 11i into R12.
  • Customization of Oracle standard forms by using Forms Personalization.
  • Developed Custom Value Sets, Custom Oracle Responsibilities
  • Developed Custom Alerts (Event based and Periodic).
  • Involved in Conversion Programs and Interfaces (IN bound & OUT bound).
  • Involved in the preparation of AIM documents (MD50, MD70, MD 120, CV40 and CV60).

Education

Bachelor of Engineering - Computer Science

Nagpur University
Nagpur, India
2005.06 - 2009.06

Skills

Oracle SQL/PLSQL

undefined

Software

Oracle EBS 11i/r12

Linux Red Hat

JDeveloper

Putty

Solaris

Timeline

Oracle Application Professional

Abu Dhabi National Hotels
2021.11 - Current

Senior Oracle Apps Technical Functional Consultant

Fujairah Building Industries PSC.
2020.06 - 2021.10

Senior Oracle Apps Technical Functional Consultant

Injazat Data Systems (Payroll Company - Raqmiyat LLC)
2019.03 - 2020.06

Oracle Techno Functional Consultant

Al Abbas Group
2014.03 - 2019.02

Oracle Technical Consultant

Mphasis
2010.09 - 2014.01

Bachelor of Engineering - Computer Science

Nagpur University
2005.06 - 2009.06

Similar Profiles

  • Sezal Thapa

    Sezal ThapaSezal Thapa

    Waitress at Compass ADNH | Abu Dhabi National HotelsWaitress at Compass ADNH | Abu Dhabi National Hotels

    View Profile
  • Ahmad AlQasem

    Ahmad AlQasemAhmad AlQasem

    Cluster IT Executive at Abu Dhabi National HotelsCluster IT Executive at Abu Dhabi National Hotels

    View Profile
  • Hammed Ishola

    Hammed IsholaHammed Ishola

    Light Vehicle Driver at Abu Dhabi National HotelsLight Vehicle Driver at Abu Dhabi National Hotels

    View Profile
Shankar SahaOracle Apps Techno Functional Consultant