oracle application 11i


    RESUME 1

    Share
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    RESUME 1

    Post  shrikantgarud on Mon Dec 03, 2007 8:21 am

    Profile:

    Having more than 2 years of IT experience, which includes One years on Oracle Applications 11i. Currently working with Spider Systems Pvt. Ltd., Pune (Wholly owned subsidiary of iGATE Capital, USA) as Technical Consultant.

    Education/Certification/Training:

     Bachelor In Computer Application from United Institute of Management Allahabad Affiliated with V.B.S Purvanchal University Jaunpur,
    Uttar Pradesh, India.
     Advance Diploma In Oracle 8i and Developer 2000 from j-INFOTECH Mumbai, Maharastra, India.
     Oracle Application 11.5.4 – (Manufacturing & Financials)

    Technical Skills:

     ERP: Oracle Applications (GL, AP, PO, INV, OM, AR, AOL, SysAdmin)

     Database: Oracle 8i, 7.3

     Languages: PL/SQL, SQL

     GUI Tools: Developer 2000 (Forms 6i/Reports 6i), Visual Basic

     Database Tools: Toad, SQL *Loader, Workflow

     Operating System: Microsoft Windows 98/NT/2000, Linux, DOS

    Employment Details:

     XXXX

     XXXX


    Work Experience:

    Client: Offshore client for XXX
    Duration: Dec 2003 to present
    Role: Team Member
    OS/Tools: Oracle Apps 11.5.4, Oracle 8i Database, D2K (Forms 6i / Reports 6i), Workflow 2.5, SQL *Loader, Toad 7.x
    Description: As a Technical Consultant, involved in the development and customization of reports and forms, Interfaces, concurrent programs, PL/SQL API's and working on various modules of Oracle Manufacturing / Financial (PO, AR, OM).

    Reports (Development & Customization):

     Purchase listing by Vendor:
    This report is modified to get the details based on the supplier.
     List all sales order that is not delivered along with credit terms.
    This report is modified to get the details of the sales order based on
    status and credit terms.
     General Ledger Trail Balance.
    This report is modified to get the output which contain sum of all
    transaction for given set of natural account.

    Interfaces:

     Receiving Open Interface:
    is used for processing and validating receipt data that comes from sources other than the Receipts window in Purchasing. These sources can be Receipt information from other Oracle Applications or existing non-Oracle Systems, Bar-coded and other receiving information from scanners and radio frequency devices and Advance Shipment Notices (ASN) sent from suppliers. Receiving Open Interface maintains the integrity of the new data as well as the receipt data already in Purchasing.

    Work Flow:

     Customize the workflow for employee leaves request and approval to HR and Project Manager.

    AOL SysAdmin Tasks:

     Created standard menu and submenus.
     Created request groups.
     Creating various responsibilities and assigning it to users.
     Added concurrent program definitions to particular request group.
     Created Users in oracle applications with particular request group.

    Concurrent Programming:

     Used SQL * Loader utility to load data from legacy system to interface table to upload resource data in PO Module.
     Developed various Package Procedures and Host programs.


    Other Activities:

     Concurrent program definitions and executable, creating value sets, registration of forms, reports.
     Creation of Value sets of Independent/Dependent/None and table type.
     Enable/Disable Flex Fields
     Created a form with List Item, LOV, Query find using Tab canvas, worked on List Item for Status of active and inactive.
     Oracle Applications standard APIs and usage.



    Client: XXX
    Duration: 5 month’s
    Role: Team Member
    OS/Tools: Win NT
    Tools Used: Oracle 8.0 and Report (2.5)
    Description: As a Junior Programmer, involved in the development and customization of reports and forms.





    Reports (Development & Customization):

    Created and customized the reports and forms by which client can able to get the details about the parties account.

    Description: I was involved in the development and customization of reports and forms. During this period I was made to make study of the modules made for the clients and to compare them. I was also made to make some reports for the clients as demanded by them from time to time. One report, which I made, was showing the description of all the parties whose total (Credit amount) – total (Debit amount) was zero.


    Client: XXX
    Duration: 7 month’s
    Role: Team Member
    OS/Tools: Win NT
    Tools Used: Oracle 8.0 and Report (2.5)
    Description: As a Junior Programmer, involved in the development and customization of reports and forms.

    Project: Airlines Reservation:

    Reports (Development & Customization):

    Created and customized the reports and forms by which client can able to do reservation, cancellation and can also add a new flight entry and he is able to do enquiry
    About the flight.

    In this project following are the features available

     Reservation:
    In the section any new reservation process occurs.

     Reservation Cancellation:
    In the section the already reservation is to be canceled.

     Addition of new Flight Entry:
    In this section the new flight entry, which is going to, introduced first time for
    the service is added.

     Flight Details:
    In this section the detail such as arrival and departure time is shown.

    Personal Details:

    Father Name: XXXX
    Date Of Birth: XXXX
    Marital Status: Single
    Sex: Male
    Nationality: Indian

      Current date/time is Sun Nov 19, 2017 6:50 pm