Technical Consultant Resume

SUMMARY

Having 3.3 Years of Experience in Oracle Applications11i and Release12 as a Technical Consultant.
Having good experience in Confidential components.
Good Exposure in Procure to Pay (P2P) and Order to Cash (O2C) Cycles.
Experience in programming with Oracle tools such as PL/SQL, SQL, SQL*Loader, UTL FILE Packages.
Experience on XML/BI - Publisher Reports
Developed XML/BI-Publisher reports through PL/SQL Procedures
Having good experience on Developing Interfaces and Conversions.
Having good experience on Developing D2K Reports.
Experience in working with Custom Reports and developing the interfaces in PO, AP, OM, AR, GL and INV Modules.
Experienced in PL/SQL Coding like Cursors, Packages, Collections, Stored procedures and Functions.
Versatile team player with excellent presentation, communication and inter personal skills.
Good Exposure in Preparations of AIM documents like MD70, CV60 and TE20.

TECHNICAL SKILLS

ERP: Oracle Applications 11i and R12

MODULES: PO, AP, GL, INV, OM, AR and AOL Objects

GUI Tools: ReportsBuilder6i/10g, FormBuilder6i/10g,XML/BI-Publisher Reports, Workflow Builder

Languages: SQL, PL/SQL

Confidential Components: Reports, Interfaces, Conversions and Extensions

Front End Tools: Toad, SQL Developer, SQL*PLUS, WinSCP.

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Responsibilities:

Developed XML reports as per the client requirement.
Developed interfaces and conversions in various modules
Customized existing reports as per the client requirement.
Developed the Reports and schedules the programs as per Client business activity.
Worked on SQL*Loader program.
Developed payables open interface
Developed new workflow based on client requirement.
Developed Sql queries to obtain specific information as per requirements.
Defining Executables and Concurrent Programs to attach the parameters.
Creation of Value sets in various Modules of the application
Written stored procedures, functions and triggers by using PL/SQL.
Worked on Creation of Request Sets.
Worked on Personalization of Forms as per Client requirement.

Confidential

Technical Consultant

Environment: Oracle Apps 11.5.10 (AP, PO, OM and GL) Oracle 10g, Reports6i

Responsibilities:

Designed, developed a package for item conversion and tested as per unique business requirements.
Customized reports to client’s specific needs.
Developed reports using XML/BI- publisher.
Registration of concurrent programs, parameters for custom reports specific to Applications.
Wrote package to validate data before loading into the corresponding interface table.
Customization of PO reports in Oracle Applications.
Responsible for the development of Custom Reports.
Used SQL*Loader control programs and PL/SQL validation procedures to execute along with Order Import Interface (OM) programs to support the interface requirements.
Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
Developed AP Suppliers Interface.