Profile Summary:

• Overall 7 years of experience in IT industry and extensive experience as an Oracle Applications Consultant.
• Experienced in Reports, Interfaces, Conversions, Extensions, Workflow RICEW Customization and new development.
• Extensive experience in Oracle Applications Financial, Procurement and Distribution modules including Oracle General Ledger, Oracle Payables, Oracle Receivables, Fixed Assets, Cash Management, Purchasing, Order Management, and Inventory, Procure-to-Pay PTP and Order-to-Cash OTC .
• Experienced in Upgrade, Implementation and Production Support of Oracle Applications 11i/R12.
• Expertise in Application Object Library AOL , System Administration, Alerts and Trading Community Architecture TCA .
• Extensive experience in the customization of Oracle based systems: design, development, testing and implementation of relational database management systems using Oracle 8i/9i, Forms 6i/9i, Reports 6i/9i and other Oracle tools under UNIX and Windows platforms.
• Extensively worked on design and development of interfaces and data migration using SQL Loader, Oracle open interfaces, database triggers, procedures, interface tables
• Hands on Experience in Oracle Discoverer which includes report developments, discoverer administration, configuration of discoverer and End User Layer EUL .
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers and other database objects using SQL and PL/SQL. Also experienced in SQL-tuning for better performance.
• Involved in different phases of project life cycle including blue printing gap analysis to customizations, development configuration, testing, validation set up documents and end user training.
• Good Knowledge in Service Oriented Architecture SOA and Application Integration Architecture AIA . Worked on integration of Oracle Applications with other systems B2B using BPEL.

Technical Skills:

• ERP : Oracle Applications 11i e business suite, Oracle Applications 12i/R12.
• Modules : AP, AR, GL, PO, INV, OM, iExpenses, BOM, WIP
• RDBMS : Oracle 10g/9i/8i/8/7.x, MS access
• GUI : Forms 6i/9i/10g, Reports 6i/9i/10g, XML Publisher, TOAD, Discoverer 4i/10g
• Languages : SQL, PL/SQL, C, C , VISUAL BASIC 6.0, BPEL
• OS : UNIX, Windows 95/98/ME/XP, MS-DOS, MAC
• Educational Background:
• Bachelor of Technology in Electrical Electronics, JNT University, India

Professional Experience:

Confidential

Oracle Applications Techno-functional Consultant

Responsibilities:

• Developed the interface program to import item quantity Open Transaction Interface into Oracle Inventory using SQL Loader, PL/SQL package.
• Developed custom PL/SQL packages to import Bill and routing information for creating BOMs.
• Developed a custom program to interface the legacy Lodestar Open Invoices into Oracle Receivables AR using standard interface program 'Auto Invoice Master Program'.
• Installed Implemented Oracle Discoverer 10g and developed EULs, Business areas and created reports for OM and Service Contracts.
• Developed the interface program to send all employees' data in the organization to a third party vendor using BPEL and SOA.
• Developed financial reports, such as income statements and balance sheets, based upon data in general ledger
• Design custom financial reports to meet specific business needs.
• Developed custom XML publisher reports such as Employee Status Change report, Address and Phone Change Report.
• Created setup documents MD-70 for Customer Interface and supplier Interface.

Environment: Oracle Applications R12, Financial Statement Generator FSG , Oracle Applications 11i, Oracle 10g/11g, SQL Loader, TOAD, Discoverer 10g/11g, Oracle Workflow Builder 2.6, Forms10g, Reports10g, BI Publisher, UNIX.

Confidential

Oracle Applications Techno-functional Consultant

Responsibilities:

• Designed and Developed the interface program to load the Invoices from a legacy system into Oracle Payables using SQL Loader, PL/SQL package and Payables Open Interface Import Concurrent program.
• Developed the interface program to extract the Merit and ROI details for all the employees in the organization using PL/SQL package
• Developed custom oracle 6i reports for expense reports created by the employees and also for the approved expense reports.
• Developed a custom process to rollback all the timed out transactions when an instance is cloned in Manager Self Service.
• Developed custom forms to maintain data that is used to control the approval rules in AME.
• Developed a master-detail form to maintain data for the AME pre and post approval rules as defined by the business.
• Developed Discoverer 10g reports such as Personal Information Change Report, Job Changes Report.

Environment: Oracle Applications R12 GL, AR, OM, INV, Install Base, Service Contracts, Telesales, Knowledge Base , Oracle 10g, SQL Loader, TOAD, SOA, BPEL, Discoverer 10g, Oracle Workflow Builder 2.6, JDeveloper, Forms10g, Reports10g, BI Publisher, UNIX, Shell Scripting.

Confidential

Oracle Applications Techno-functional Consultant

Responsibilities:

• Gathering requirements to upgrade different customizations from 11.5.7 to R12
• Developed on the service contracts conversion from 11i to R12
• Working on a RICE element to update location code from one system into another system as it is required for the merger.
• Gathering requirements to upgrade custom reports from 11.5.7 to R12.
• Designed and developed GL Daily rate interface and Fixed Assets mass additions Interface.
• Designed and developed custom tabs on e-Business center form in Telesales to enter Customer attributes.
• Migrated lot of XML publisher reports in AR,OM,AP from 11.0.3 to R12
• Developed few form personalizations on the sales order form so that order will be placed on certain holds like Discount Hold, Credit Hold.
• Created email alerts when ever orders get booked, shipped, placed on hold for the business users with the Order Number, Order Amount details.
• Designed and developed custom XML publisher reports in OM, AP and AR modules.

Environment: Oracle Applications R12 GL, AP, AR, OM, INV, Cash Management, FA , Oracle 9i, SQL Loader, TOAD, SOA, BPEL, Discoverer 10g, Oracle Workflow Builder 2.6, JDeveloper, Forms6i, Reports6i, XML Publisher, UNIX, Shell Scripting.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Designed and developed the iExpenses interface program to download transactions from citibank server and to load them into Oracle AP .
• Designed and developed the Payment Manager Interface program AP to upload the Payment batches information to the Wells Fargo bank server.
• Customized 'Service Contracts' form to change the status from entered to submit when contract has been submitted.
• Designed and developed custom reports using Discoverer 10g in PO, FA, OM modules as per the user requirements.
• Worked on the functional and technical documentation of Discoverer 10g Reports.
• Developed and designed a custom interface using SOA/BPEL to bring in Daily Foreign Exchange rates from rates provider into Oracle GL.
• Customized standard reports such as Min-Max Planning Report, Item Definition Summary report, Sales order acknowledgement report, Comprehensive order detail report in INV and OM modules.
• Developed a custom program to interface receipts Cash and Miscellaneous into Oracle AR using standard API 'AR RECEIPT API PUB'.

Environment: Oracle Applications R12 GL, AP, AR, iExpenses, SLA, FA, PO , Oracle 9i, SQL Loader, TOAD, SOA, BPEL, Discoverer 10g, Oracle Workflow Builder 2.6, JDeveloper, Forms6i, Reports6i, XML Publisher, UNIX, Shell Scripting.

Confidential

Oracle Apps Developer

Responsibilities:

• Gathered the requirements by talking to the user group and translated the requirements into detail technical and functional specifications.
• Prepared BRS Business Requirement Specifications document that gives the comprehensive details about the requirements.
• Created source to target data mapping document.
• Actively involved in database design and prepared design document.
• Involved in physical data modelling and created scripts.
• Created PL/SQL stored procedures, functions, packages and sequences .
• Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.
• Prepared Unit test cases and participated in unit testing.
• Prepared system test cases and participated in system testing.

Environment: Oracle 9i, SQL Plus, PL/SQL, Oracle Reports 6i, Oracle forms 6i, SQL Loader.