SUMMARY

• 7 years of experience working with Fortune 100 companies delivering Oracle solutions.
• 7 years of experience in the Oracle Applications 11i Implementation, Customization, and Supporting Projects.
• Strong programming knowledge in creating Procedures, Functions, Packages, Triggers, Reports and registering them as Concurrent programs and other database objects using SQL and PL/SQL.
• Experience in developing XML Publisher & Discoverer reports.
• Good exposure to P2P and O2C cycles.
• Responsible for understanding and analyzing the provided RICE component specifications and developing solutions by using Developer 2000 and PL/SQL
• Good exposure to Oracle Application Implementation Methodology (AIM 3.0)
• Good Technical &Functional Knowledge on Modules like Oracle Payables, Oracle Receivables, Order Management, Oracle Purchasing, Oracle General Ledger.
• Experience in designing, developing the Inbound and Outbound Interfaces in Oracle Release11i which includes AP, PO, AR, OM, INV, GL modules.
• Good Debugging skills and good at using Exceptions and Error Handling.
• Experience in Performance Tuning using Explain Plan, TKPROF, and Trace Analysis.
• Good communication skills, Analytical and problem solving Skills, Efficient Team Player, Openness for help, willing to travel, Optimistic attitude and Enthusiastic.
• Preparation of Test plans, Test data and execution of test cases to ensure application functionality meets the user’s requirements

TECHNICAL SKILLS

ERP: Oracle Applications 11i (AP, GL, PO, AR, OM, INV, FA), Oracle Release 12, AOL, Sys Admin.

Languages: SQL, PL/SQL, C, Java, Html

GUI Tools: XML Publisher, Discoverer, Reports 6i, Forms6i.

Tools: & utilities: TOAD, SQL * Loader, SQL * PLUS, Data Loader, SQL Developer, Putty, Workflow Builder

RDBMS: Oracle 8i / 9i/10g

Operating Systems: Windows 98/XP/2000 and UNIX

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Responsibilities:

• Worked on coding of interfaces, RDF Reports and XML Reports.
• Designing of Technical Documentation like MD070, cv060.
• Auditing of Test Cases of AP, PO, OM and AR modules.
• Creating and Debugging of Packages and Procedures & Functions.
• Designed table Scripts, File loader Scripts to move objects from one instance to other.
• Worked on PO Conversion to upload legacy systems data into Oracle 11i database
• Worked on Inbound Release Creation and Cancellation.
• Developed Release Outbound Interface.
• Developed PL/SQL Package to send automated mail to Suppliers using smtp connection.
• Designed VAT 515 Excel Upload Program using PL/SQL package.
• Developed Purchase Order Impex Report using xml publisher.
• Designed AR Daily Sales Report using Discoverer
• Customized PLA Report
• Developed Form ARE1 Report following the steps of standard Form ARE1 Report.
• Designed Payable Voucher Report using xml publisher
• Developed Central Excise Duty Payable Report in Discoverer for Excel format.
• Designed Price Break Details Report in Discoverer for output format in Excel
• Designed Inv Job Work Register Report using Custom table.
• Designed Cost Reduction Report using rtf Template.
• Developed Kanban Card label Report where Barcode was incorporated.
• Designed TKM Parts Shelf Label Report where no of Labels per page was fixed.
• Developed TKM Physical Inventory listing Report (PDF) in xml template where no of lines per page was fixed to 40.
• Designed TKM Detail pending Del note Report using rtf template.

Environment: Oracle Applications 11.5.10.2, Discoverer, XML Publisher, Forms 6i, Reports 6i, Toad, Modules - AP, PO, AR, OM, Unix Scripting

Confidential

Technical Consultant

Responsibilities:

• Worked on coding of interfaces and Reports.
• Designing of Technical Documentation like MD200.
• Auditing of Test Cases of AP and AR module.
• Debugging Packages and Procedures.
• Involved in launching Confidential -support central cases and interactions with DBA’s and Clients
• Worked on TRL Tax Reporting Ledger Interface to upload legacy systems data into Oracle 11i database and ftp to the Corporate Tax Server.
• Developed Inventory Outbound Interface capturing Item and other information.
• Developed Purchase Order Outbound Interface to write data into flat file through UTL Package.
• Involved in Coding of different Packages and Procedures required as per client
• Written different SQL scripts to move the source objects from an instance to other and for varied purposes.
• Designed Request Sets and Concurrent Programs for uploading data into the Value Sets
• Developed Invoice Matching Report prior to PO Wise
• Developed Report to show PO’s in Pending Status by vendor wise.
• Customized AP Payment terms report.
• Worked on Item Categories details with Cost Report.

Environment: Oracle Applications 11.5.10, Forms 6i, Reports 6i, SQL * Loader, SQL Developer, SABRIX - AP, SABRIX-AR, Modules-AP, PO, AR, OM, Unix Scripting

Confidential

Technical Developer

Responsibilities:

• Preparation of Technical Documentation.
• Performed Functional and Sanitary testing for AP module.
• Testing - unit testing & integration testing.
• Preparation of SQL Loader scripts.
• Involved in Client meetings.
• Worked on Suppliers & Supplier Sites Conversion.
• Developed Payables Outbound interface to write approved Invoices into flat file using UTL Package.
• Customized Invoice Aging Report.
• Developed Move Order Report.
• Customized Invoice Register Report
• Customized a Payables form to accept invoices dated between 25th and the end of the month.
• Adding the Triggers in Form Level, Block Level and Item Level.
• Attaching Calendar to Date Fields.
• Updating who columns.

Environment: Oracle Applications 11.5.10, Forms 6i, Reports 6i, Sql * Loader, Toad, Modules-GL, AP, PO, Unix Scripting

Confidential

Programmer

Responsibilities:

• Developed Reports as per client requirement.
• Developed Forms as per client requirement.
• Developed PL/SQL Packages, Procedures and Functions.
• Tested the objects and matched them with the desired results.

Environment: Forms 6i, Reports 6i & Oracle 8.0