Talent's Information
-
Location
Bengaluru, India
-
Rate
$13.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
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
-
Oracle
Oracle ebs,Oracle Apex
2 Years -
Apex
Apex
0 Years
Work Experience
DBA Developer
- January 2016 - January 2023 - 7 Year
- India
Projects
PO Enhancements
- January 2017 - January 2018 - 13 Months
-
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.
Apex Steel Implementation.
- June 2018 - January 2019 - 8 Months
-
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
Implementation And Support.
- January 2021 - January 2022 - 13 Months
-
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.
Soft Skills
Industry Expertise
Education
in MCA
Bengaluru University- June 2009 - June 2012
