We provide IT Staff Augmentation Services!

Technical Consultant Resume

SUMMARY:

  • Having 3 years of software development experience of which 3 years in Oracle Applications.
  • Experience in designing and developing technical solutions for Oracle Applications including conversions, Inbound/Outbound Interfaces, and reports development.
  • Having knowledge in development of Reports, Interfaces, Conversions and XML Publisher Reports.
  • Conversant in modules like INV, PO, OM, AP and AR.
  • Having exposure on analysis, design and development of RICE Components.
  • Conversant in writing PL/SQL stored Procedures, Packages, functions.
  • Worked with good features like XML Publisher, SQL*Loader, UTL FILE (Inbound and Outbound).
  • Having Good Knowledge on Oracle standard API’s and able to use whenever required.
  • Having good knowledge about AOL, System administration and Coding standards in Oracle Applications.
  • Good understanding of Documents like MD50 and MD70’s.
  • Knowledge on creation of Value sets, Executables, Concurrent Programs and Request sets.
  • Knowledge on MOAC and TCA.
  • Knowledge on Flex Fields.
  • Experienced on WebAdi

TECHNICAL SKILLS:

ERP Applications: Oracle Apps R12

Database: Oracle9i/10g

Languages: SQL, PL/SQL

Tools: TOAD, SQL*Plus, SQL*Loader, Reports 6i/10gXML publisher

Operating Systems: Windows.

PROFESSIONAL EXPERIENCE:

Confidential

Platform : Oracle Apps R12

Technical Consultant

Responsibilities:

  • Developed Items conversion to transfer items from BAAN ERP system to Oracle apps
  • Developed Bank and bank branch conversion using the API IBY EXT BANKACCT PUB
  • Worked on Vendor conversion to create vendors, sites and contacts in AP Module
  • Worked on Stock locator conversion to create ROW, RACK and AISLE segments
  • Developed AP Invoice Interface program(End user can enter data through webadi template)
  • Developed interface for suppliers to customer based on vendor type.
  • Developed open Purchase order details report to send email attachment to buyers based on need by date parameter
  • Developed PO Material voucher report
  • Customized AP Invoice aging report
  • Customized OM Outstanding holds report

Confidential

Platform : Oracle Apps R12

Technical Consultant

Responsibilities:

  • Analysis of the Requirements provided by the clients.
  • Creation of PL/SQL procedures, Functions and Packages.
  • Creating Database Objects like tables, views, sequences, Indexes.
  • Writing SQL queries according to customer requirement.
  • Worked on Oracle Reports
  • Responsible for developing the Interfaces.
  • Developed control files for loading legacy data into staging tables using SQL*LOADER.
  • Developed Outbound interface to extract data from Base tables to Flat file using the UTL FILE Package.
  • Involved in the Reports and Forms development and Customization.
  • Define Concurrent program, Request Sets and Executable and Value Sets
  • Post Production support.

Hire Now