PROFESSIONAL SUMMARY:

• Oracle Apps Techno Functional Consultant with proven experience in Oracle EBS Application Releases R11.5.10.2, R12.0.6, R12.1.3 and R12.2.4. Significant customer - facing experience in delivering custom enterprise solutions to Confidential , Qualcomm, Confidential , Almac etc. Having around 9 years of experience in the IT Industry in implementation, upgrade and customization of Oracle e-Business Suite Applications.
• Functional experience in configuration, setup, unit and integration testing of various Oracle Application Modules and customizations for meeting gaps in client requirement and application.
• Expertise in RICEW component design, development and having good functional and technical exposure on different modules of Oracle Application like General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets, Project Accounting, Cash Management, Order Management (OM), Purchasing (PO), Inventory (INV), Advance Pricing, BOM, WIP, I-expenses, I-Procurement, I-store, E-Commerce Gateway, Oracle Mobile Applications Framework, Service Contracts, Web ADI and Oracle Alerts.
• CRM functionality setups, business process, end to end transaction processes, client requirement FIT GAP analysis with Oracle seeded functionality, identifying the customization areas needed to meet client’s requirements.
• Experience in developing ORACLE APEX applications.
• Good knowledge on End to End functional setups required for Order to Cash, Procure to Pay and Demand to build business process Setups.
• Experience configuring the Sub Ledger Accounting SLA set ups
• Period close and Quarter close experience.
• Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like BRD100, MD.50, MD.70 and TE.20
• Good Expertise in TCA (Trading Community Architecture).
• Experience working with large multisite enterprise resource planning (ERP) systems and cross functional teams.
• Experience in developing self-service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.
• Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions and Integration
• Extensive experience in conversion of legacy data into Oracle Applications developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.
• Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.
• Extensive experience in developing custom forms using forms 6i/10G. 
• Extensive experience in customizing the forms functionality using Form Personalization, Logical apps rules and Custom.pll
• Extensive experience in developing custom reports and customizing standard reports using reports 6i /10G. 
• Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Expertise in Oracle XML Publisher and Discoverer reports.
• Knowledge on UNIX Shell Scripting and OBIEE Reports.
• Knowledge on Oracle XML Gateway and EDI.
• Good Expertise in developing applications using SQL, PL/SQL, Advanced level of PL/SQL concepts, Database Triggers, Stored Procedures, Oracle 11g/10g/9i/.
• 2 R12 upgrade experience
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD 
• Experience in customizing Workflows using Workflow Builder 2.6.3
• Experience in working with ITG Kintana/ HP PPM change management and PVCS migration tool.
• Good functional and development expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle P2P and O2C modules.
• Exposure to data support on Multiple Environments like UAT, SIT, CAT, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board
• Received many appreciations, certificates, prizes from client for identifying and fixing the production issues.

TECHNICAL SKILLS:

Oracle Apps Modules: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets, Project Accounting, Cash Management, Order Management (OM), Purchasing (PO), Inventory (INV), Advance Pricing, BOM, WIP, I-expenses, I-Procurement, I-store, E-Commerce Gateway, Oracle Mobile Applications Framework, Service Contracts, Web ADI and Oracle Alert.

Database Tools: TOAD, Oracle SQL Developer

Other tools: Clear case, Kintana, QC, JDeveloper, Winscp, Putty, Secure CRT, SQL*Loader, Service Now, HP PPM, CVS, Data Loader.

Languages: SQL, PL SQL, JavaScript, HTML, XML, Shell Script, Core Java

Databases: Oracle 9x/ 10.0.2.0/11 g

Operating Systems: Windows-98/2000/NT/XP, MS-DOS, UNIX/HP-Unix

Knowledge: Oracle Forms 6i/10g/11g Builder, Oracle Reports6i/10g/11g Builder, BI/XML Publisher, Oracle Discoverer, Oracle Workflow, Advanced Level PL/SQL concepts.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Techno Functional Consultant 

• Presently working on Oracle R12 Account Receivables module as a techno functional analyst for project “Abacus”, Goal is to interface the invoice, receipts and service contracts with third party system from oracle and vice versa.
• Prepared Proof of Concept document for implementation of Oracle APEX and set up development instance from scratch.
• Worked on Setups required for AR Auto Invoice, AR Lockbox process.
• Developed Oracle APEX application for Error Handling Report which makes business user to rectify the error records using APEX application for updating and deleting the existing records.
• Worked on preparing design for revenue recognition process.
• Developed SOA Web Service for integration between AQ tables of Oracle System push the data to third party system.
• Developed API for implementing the design functionality of revenue recognition process.
• Working in an Agile Scrum way, comprising of 2 weeks of each sprint. Each sprint features completion of development, analysis, unit testing, technical design document and overall flow document for the scope of the sprint followed by the Demo at the end. 
• Interpreting customer business needs and translating them into application and operational requirements.
• Working with cross-functional teams to gather requirements design the process and implement effectively.
• Developing new reports and modifying existing accounting reports in Discoverer. 
• Functional work includes oracle application setups such as lookup, accounting rule, receipt class, payment methods.
• Development work in PL SQL core programming, Oracle applications concurrent programs, DDL and DML scripts for new and existing objects such as tables, views, packages, procedures, form personalization.

Confidential

Oracle Techno Functional Consultant

• Interact with business users regularly on ongoing support issues and provide accurate solutions.
• Involved in Implementation of end to end functional setups required for O2C business process Setups, New inventory org creation and related setups.
• Configuration of CRM foundation related all setups like Employee, Resource, role types, roles, role assignments etc.
• Good Exposure on process and setups related to AR Intercompany Transactions.
• Performance tuning of slow running programs and applications.
• Developed Sub Ledger Reconciliation Report using XML Publisher.
• Modified SLA Definition as per client's requirement and resolve problems with SLA. 
• AR Receipts adjustment upon cancellation of Orders.
• Period End activities for various financial modules.
• Reconfiguration of Legal Entity, Operating Unit and Inventory Setup related to specific Organization.
• Implemented Setups of IR/ISO sales order, Back 2 Back sales order, RMA sales order and Drop Shipment process.
• Created Inter Company price list for Inter Company transactions in Order Management and Inventory application.
• Analyzing the Clients requirements and implement the same in ERP system.
• Implementation of function and technical design and setups for Electronic Data Interchange (EDI) 850 E-commerce gateway process.
• Developed the XMLP reports using xml publisher reporting for multiple EBS modules like OM, Purchasing, Shipping, Accounts receivables, Accounts Payables, project Accounting etc.
• Extensively worked on preparing end 2 end test scenarios, test scripts on different applications to help the users for better understanding the application.
• Involved in System testing for Order Management seeded functionalities
• Created Materialized View for GL Account Analysis Report.
• Worked on OAF Personalization of Supplier, Customer, and Bank and Branches OAF pages.
• Prepared PL/SQL package for to generate payment format file for CITI bank.
• Developed Mobile Application to release hold for an Orders using Oracle Mobile App Framework.
• Worked on CUSTOM.pll to make all forms read only which are accessed from Inquiry responsibility.
• Using XML bursting created commercial invoice report which will be emailed to intended user automatically.
• Configuring the setup for batch invoices and batch payments, multi-currency invoices
• Worked extensively on reprice of items by customizing Order line standard Oracle Workflow.

Confidential

Oracle Techno Functional Consultant

• Worked on AR receipts, Employee and Supplier Conversions.
• Developed the PL/SQL package for AP/AR/PO Attachment Conversions.
• Worked on fixing the defects raised during CRP2 and UAT.
• Development of Interface for loading GL Daily Rates
• Worked extensively on fixed assets conversions.
• Involved in AR Setups like Auto Accounting Rules.
• Development of Historical Data tables which are specific to the organization.
• Involved in functional support of production issues in oracle AP and AR modules wherever required.
• Created category sets, category codes, default category sets for the various items in Inventory application.
• Resolved the critical issues on Shipping Execution while Ship Confirming the Sales Order.
• Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups.
• Creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
• Item Upload conversion from legacy to Oracle ERP system.
• Created setups to import Freight Costs entered at shipping into Account Receivables module
• Created Automated process to assign Item categories for an item in bulk.
• Worked on automation process of applying holds on sales order upon booking which have new items.
• Developed package for Item Attributes Interface which updates missing attributes for items.
• Perform system testing to verify the application integrations.
• Reprice the order line price by customizing standard order lines workflow.
• Debug the issues related to Oracle service contracts.
• Good knowledge on system and user defined Order Management Holds and Hold Sources.
• Troubleshooting and fixing the defects of Discoverer report which are having the issue.
• Development of new discoverer report as per the requirement.
• Responsible for migration of developed components to production
• Support post production timelines and issues
• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per the requirements.
• Analysis of Function Design Document and preparing Technical Design Document.

Confidential

Oracle Techno Functional Consultant

• Responsible for technical specification design, development of the code, unit testing the program based on six-sigma analysis and project execution.
• Involved in designing, executing test cases and defect reporting
• Involved in preparation of test cases for RICEW components related to Order to Cash flow.
• Good Exposure on process flow of Intercompany Transactions.
• Test cases uploading using Quality Center.
• Involved in test cases Review (Audit).
• This Project includes both Support and Enhancements (Incident and Problem Management Activities)
• Involved in AR setups such as Transaction Source, Transaction Types, Receipt Classes, Auto Accounting Rules, Receipt Sources, Payment Methods, Customer Profile, Payment Terms, Auto Invoice. Successfully created all kinds of Transactions and transferred transaction to GL.
• Involved in setups related to AP Payment formats.
• Having good exposure on AR LOCK BOX setups like Receipt Source, Receipt Class, Payment method, transmission format and Process.
• Extensively worked on Price Upload, Item
• Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups as per business needs in Order Management module.
• Upload, Automated process to create / update the Items, Prices in Oracle.
• Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the required setups.
• Worked on RMA Process, importing EDI orders, and Credit Memo process in Order Management, Account Receivables Modules.

Confidential

Oracle Technical Consultant

• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per the requirements.
• Expertise in Setups related to creating New inventory orgs, Intercompany transactions and creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
• Preparation of migration and shell scripts.
• Testing - Unit testing & Documentation.
• Developed Cost of Sales GL report.
• Developed Generate AR Billing Detail package.
• Developed Multiselect Parameter form.
• Developed custom program to interface all custom data to AR Interface table.
• Developed Item Conversion to import item details from legacy system to Oracle System.
• Gathering business requirements.
• Developing the RDF files, XML Reports as per requirements of user.
• Development of Lydall US Sales Order Acknowledgment report.
• Development of Lydall US AR Invoice Report.

Confidential

Oracle Technical Consultant

• Responsible for Development and Customization of Reports and Interfaces between legacy system and Oracle Apps.
• Preparation of SQL Loader scripts.
• Developing of Interfaces as per client requirement.
• Defining Concurrent Programs, Executables.
• Worked on Open Notifications report.
• Developed Manual Approvals details Report.
• Developed Matching information Report for Purchase order.
• Developed PO conversion to upload the Purchase Orders from Legacy system to Oracle apps system.
• Developed AP Vendor Extract Interface to extract supplier details from Oracle apps to Legacy system.