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.