usha accenture resume

Usha
Technical Consultant—Oracle Apps

Summary:

• Having 4+ years of IT experience with around 4 years of experience in Oracle Applications 11i & R12.

• Hands-on work experience in Forms, Reports, Data Conversions, XML Publisher and Oracle Workflow.

• Knowledge on Procure to Pay and Order to Cash business cycle.

• Extensively worked on HRMS, INV, PO, AP, OM, AR, GL Modules.

• Having good knowledge on Workflow.

• Extensive experience in Application Development using Oracle SQL, PL\SQL, Forms and Reports and other related Technologies.


• Good exposure on Oracle AIM.

• Good team player with excellent analytical, technical, interpersonal and communication skills.


Education

B.Sc Computer Science from Bharathidasan University, Trichy.



Technical Skills:

ERP Package Oracle apps 11i / R12 (PO/AP/OM/AR/INV/GL/HRMS)
Databases Oracle 8i/9i
Database Tools PL/SQL Developer,TOAD 8.5,9.7,SQL* loader,appLOAD
Programming Languages C, C++,Java
Reporting Tools D2k forms,Reports,Discoverer 10g
Operating Systems Windows XP / 2000 / 98







ORACLE APPLICATIONS PROJECTS:

Project : TEMPO
Environment : Oracle Apps R12 (INV, OM, PO,AR, AP, GL,HRMS)
Role : Technical Consultant

Responsibilities:

• Requirement gathering for custom objects development
• Worked on HRMS BG Absence Duration Fast Formula
• Involved in Item Conversion and Purchase Order Conversion using open interfaces

• Involved in development of custom reports.
• Worked in Employee Payment Method creation and updation using APIs.
• Developed following XML publisher reports.

• Accounts Payable Trial Balance Report
• Employee Offer Letter Report
• Employee Confirmation Letter
• Invoice Register Report
• India Creditor Ledger Report
• Involved in MD70 Preparation for the custom objects.
• Done form personalization to populate “Custom Reference” column in Receipt Form.


Project : CEL
Environment : Oracle Apps 11.5.10.2 (INV, OM, PO,AR, AP, GL)
Role : Techno Functional Consultant

Responsibilities:
• Developed various custom reports in INV, Payables, and Receivables.
• Creating Value sets in various Modules of the application.
• Developed CEL Employee Details Report.
• Developed CEL Project wise Details Report.
• Developed CEL Return to Vendor Invoice details Report.
• Developed CEL GRR Supplierwise Report.
• Customization in CUSTOM.pll to make the process in receipt form to inspect all items.
• Preparation of Technical Design Documents
• Done a Form Personalization to make user should enter the task number for a particular organizations for subinventory transfer in inventory module.



Project : MWC
Environment : Oracle Apps R12 (INV, OM, PO,AR, AP, GL,PA)
Role : Technical Consultant

Responsibilities:
• Developed various reports in INV, Payables, receivables and GL
• Handled various production issues
• Coordinated with Oracle support for the raised SR
• Worked in form customization.
• Worked on Project Supplier Invoice workflow customization
• Done Self Declaration Report
• Preparation of Technical Design Documents


Project : appLOAD
Environment : Oracle 11.5.10.2 (AR,AP,GL,INV,PO,OM,HRMS)
Role : Technical Consultant

Responsibilities:
• Involved in analyzing and testing of Oracle Open Interfaces for data conversion of various modules.

• Involved in analyzing and testing of Oracle Standard APIs for data conversion of various modules.

• Creation of Data templates as per client requirements.
• Involved in creation of data validation and conversion procedures.
• Involved in creation of technical documentations.
• Involved in UAT and production support.




Project : GLOBAL PROTOTYPE INVENTORY REQUISTION SCHEDULING (GPIRS)
Role : Technical Consultant
Environment : Forms and Reports 6i / 10g

Responsibilities:

• Involved in Pre Migration Process.
• Involved in Post Migration Process.
• Involved in Form Customization and Report Development.
• Involved in Identifying And Fixing The Bugs.
• Involved in Technical Document Preparation After Migration.