User

DBA Developer

BMT Score
76
76%
  • Remote

Available for

About Rasool

7+years of experience in Oracle E-Business Suite as Oracle Applications Technical Consultant .
Extensive experience in Analysis, Design,Development,Testing and production support for Oracle Applications11i, R12.
Developed Technical specifications as well as test plans and test scenarios using AIM Methodology.
Experience in Implementation and Customization of RICEW/CMELI Objects
Worked onSCM and Finance modules such as PO, INV, OM, AP, AR and GL.
Experience in Order to Cash (OTC) and Procure to Pay (P2P) business flows, Have worked directly with business users to gather functional requirements and developing technical components
Developed  Data Conversion/Migrations, Inbound / Outbound interfaces code.
Worked on Oracle Reports customization and Development.
Worked on XML/ BI Publisher reports customization and Development.
Worked onOracle FormsDevelopment and Form Personalization in Oracle Applications.
Developed Oracle Workflows and customized the seeded Workflows for POAPPRV.
Strong programming knowledge in SQL,PLSQL creating procedure, Packages, Functions, Triggers and other database objects.
Experience in various development tools like SQL Developer, SQL*Loader, Oracle Forms 10g, Reports 10g, UTL_FILE Package.
Experience in WebADIProcess, LoadedCatalog Quotations data into ERP base tables.
Developed Oracle Alerts for Notifications in various requirements. 
Possesses excellent analytical and development skills 

Tech Stack Expertise

  • Tech Stack Expertise

    Oracle

    Oracle ebs,Oracle Apex

    2 Years
  • Tech Stack Expertise

    Apex

    Apex

    0 Years

Work Experience

Images

DBA Developer

  • January 2016 - January 2023 - 7 Year
  • India

Projects

Images

PO Enhancements

  • January 2017 - January 2018 - 13 Months
Technologies
Role & Responsibility
     Seagate is product based company mainly its process storage solutions for business. As part project we identified some gaps and need to do some enhancements to fulfill.This is mainly po enhancement project.
    Roles & Responsibilities:
    Enable GTM licensing in manually created inventory PO’s.
    Inventory PO’s ITA attributes are write protected.
    Personalize PO form to restrict update of ship to location in licensed lines.
    Personalize the Purchase Order Form to restrict multiple Ship to locations in an inventory PO (one ship to per PO).
    Customize the Send PO by Email Report for PO ITA Attributes values. 
     Responsible for preparing the Technical specification document.
    Workflows
    Purchase order approval workflow customization,Enhance the GTM Licenseprocess before po approval and capture the data into stage  table for gtm analysis. 
    Customized the Purchase Requisition work flow for notification subject and body changes as per business requirement.

    WebADI
    Implemented  WebADI process to Load the Quotation details  in oracle base tables.closing the old quotations after Load completed.

    Form Personalization
    Multiple Ship to Locations restricted for inventory PO’s in OU.
    Ship to location not updatable for GTM Licensed Lines
    Cancellation of purchase requisition only allowed preparer, requester and buyer if it is used in po. 
    Reports (BI Publisher):
    Add the additional PO ITA attribute filed details in Email PO Report. 
    Developed BI Publisher Report for Purchase order Price Vs Quotation price analysis .
    Alerts 
    PO ageing Alert email to requester and buyer for PO aging more than 180 days (IHQ).
    Oracle Alert email Notification for Quotation Expiration is below 30 days. 
...see less
Images

Apex Steel Implementation.

  • June 2018 - January 2019 - 8 Months
Technologies
Role & Responsibility
     Apex offers sustainable solutions in steel products ,construction supplies ,piping systems and plastics;create value additions;technology & efficiency for the construction and fabrication industry in Kenya and East Africa.This is mainly Implementation and support projects.
    Roles & Responsibilities:
    Responsible for preparing the Technical specification based on the Functional document/HLD Document.
    Involved in AOL Activities like defining Concurrent Programs, Executable, Value Sets,FlexFields.
    Involved  enable  Audit Tables 
    Responsible for writing PL/SQL Coding for API‘s.
    Responsible in development  and support for  BI Reports.
    Done the Form Personalization.
    Developing  the custom workflows Contains  tabular  information 
    Created the Packages ,Procedures, triggers and Custom Tables .
    Getting data using DB link from different instances.
    Worked with Oracle Support for application transaction  issues to resolve  
...see less
Images

Implementation And Support.

  • January 2021 - January 2022 - 13 Months
Technologies
Role & Responsibility
     Saudi Telecom Company has business in 18 districts and item are related to Home based & Enterprise based.STC implemented the ERP with workflow approval process. This is mainly implementation and Support  Project.
    Roles & Responsibilities:
    Responsible for preparing the Technical specification based on the Functional document/HLD Document.
    Involved in AOL Activities like defining Concurrent Programs, Executable, Value Sets,FlexFields.
    Involved in writing Control Files to import the data from files to tables.
    Responsible for writing PL/SQL Coding for Interfaces and Conversions.
    Responsible for the Development of the XMLReports as per the requirement.
    Created Lookups and  Nested SQL Queries, Sequences.
    Created the Packages ,Procedures, triggers and Custom Tables .
    Developed the Migration scripts.
    Prepared the Technical Design Documents and done the test plans.
    Custom Development of  Forms for Workcenter and  locations. 
...see less

Industry Expertise

Education

Education

in MCA

Bengaluru University
  • June 2009 - June 2012

Our Suggestions