oracle application 11i


    RESUME 2

    Share
    avatar
    shrikantgarud
    Admin

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

    RESUME 2

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

    EXPERIENCE SUMMARY

    • Having 2 years of total IT experience as an application developer and database administrator. I was Involved in business application
    analysis and coding.
    • Currently working as a Technical Developer on Oracle Applications 11i 11.5.4 with XXX For Offshore client.
    • Currently involved in Interface Development, Form customization, report customization, PL\SQL packages and procedures, Workflow and Discoverer Reports.

    TECHNICAL SUMMARY

    • Oracle Applications 11i (11.5.4)
    Modules: GL, INV, OM, PO.
    • Workflow 2.5.
    • RDBMS Oracle 8i/9i.
    • Discoverer 4i.
    • Forms 6i.
    • Reports 6i.
    • Windows NT.
    • UNIX, LINUX.
    • SQL, PL\SQL
    • SQL Loader

    EDUCATION/CERTIFICATION

    • Oracle9i Certified Database Associate (OCA).
    • Oracle9i Database Administration Certified Professional (OCP) with an aggregate of 83%.
    • Qualified exam of PL/SQL Programming Units.
    • Currently doing Masters Diploma in International Trade from Symbiosis Center of distance learning.
    • M.COM In Human Resource Management From Banaras Hindu University in year 2001.
    • B.COM from Udai Pratap College in year 1999.


    Project Summary
    XXXX March 2002 to till.

    As a Technical Developer, was involved in the development and customization of reports and forms, interfaces, concurrent programs, PL/SQL API’s, Oracle Workflow 2.5, Discoverer 4i.

    Employer: XXXX
    Client: Offshore Client for XXX
    Role: Technical Developer.
    Modules Worked On: GL, INVENTORY, PO, OM.

    Interfaces
    • General ledger budget interface for uploading data from legacy system through SQL Loader and extracting data to legacy system through
    UTL_FILE package.
    • Developed an interface to import journals from external systems with validations and without validations of their code combinations.


    Forms Customization
    • Applications of key flex field for items in form.
    • Launching concurrent program for reporting of replenished consumable items from form.
    • Launching workflow for routing level of Quantity On Hand from form.
    • Application of descriptive flex fields for details of vendors on existing fields.
    • Enabled attachment in the form for additional information of items.

    Reports
    • Developed an inventory report to get top n items used by a particular sub
    inventory using date hierarchy to get information on yearly, quarterly, monthly and daily basis.
    • Developed a discoverer report to get inventory value of all items organization wise and sub inventory wise.
    • General ledger report for particular account with its respective code combinations.
    • Discoverer report on actual transactions made weekly for particular items.
    • Customized an existing report of order management of discounts offered for particular item (OEXPRPRS).
    • Customized vendor service performance report (POXRVRVD).
    • Discoverer reports for fast moving items based quantity transacted weekly and monthly.

    Workflow
    • Status notification of replenished items, which are below minimum quantity level.
    • Developed a workflow for notification of goods in transit.
    • Notification for --reasons non-payments of dues by customers.
    • Notification to concerned person for special arrangement to pick up heavy items from dock.
    • Developed a workflow to notify concerned authority for expiration of vendor quality certificate in advance.
    • Notifications to make arrangements for bulk items receiving.


    Concurrent Programs
    • Request set of inventory transfer into various departments subject to their receipt and its report respectively on weekly basis.
    • Weekly status of vendor performance for their quality standards.
    • Regular upload budget using Sql Loader.

    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.

    PREVIOUS EMPLOYMENT HISTORY

    XXXXX JUNE 2001 TO FEB 2002.

    Order Processing System.
    Client: OFFSHORE for XXXX

    Environment: Oracle 8, Developer 2000.
    Role:
    - Was responsible for extracting data through UTL_FILE package from system for analysis and design.
    - Requirement Analysis and Designing the system.
    - Coding, Testing, Implementation of System and user Training
    - Writing sql queries for reporting.
    - Writing pl/sql packages and function for application of required and routing of information.


    DBA Activities

    • Taking hot and cold backup of all existing data files of database on Unix as well as NT environment.
    • Taking backup of control file.
    • Database creation manual as well as with Oracle DBCA.
    • Enabling and disabling user session trace and analysis of output after truncating it through TKPROF.
    • Using export and import utility for transferring objects between databases as well as taking backup of important tables.
    • Database networking using both host naming and local naming on TCP protocols.

      Current date/time is Sat Sep 23, 2017 5:30 pm