SUMMARY:

• Over 8 years of Professional experience in Oracle Applications as a Techno - Functional consultant, focused on Implementation, Upgrade and Support of Oracle Financials, Oracle Manufacturing, and Oracle Supply Chain modules.
• Extensive experience in Oracle Applications (11.X / R12) E-Business Suite Modules in Financial (GL, AP, AR, FA, CM), Oracle Manufacturing & Distribution (PO, TCA, OM, QP, INV, WSH, BOM, WIP, WMS), SCM, HRMS.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• In depth knowledge and understanding of Oracle Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports .
• Expert in developing programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Experience in Manufacturing modules like Work in progress(WIP) and Bills Of Management(BOM)
• Good Experience in Oracle Financials and supply chain modules like GL(General Ledger), AP(Accounts Payable), AR(Accounts Receivable), FA(Fixed Asset), CM(Cash Management), PO(Purchase Order), OM(Order Management), INV(Inventory),OSFM (Oracle Shop Floor Management), Install Base, Service Contracts, iExpenses, iProcurement and AOL(Application Object Library).
• Extensive Knowledge in writing Packages, Procedures, Functions, Triggers and API’s using SQL, PL/SQL, UTL file, TOAD.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Developed Open Purchase Orders report using XML/BI Publisher.
• Worked on Interface & Conversion for importing the data using the SQL Loader & PL/SQL.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12,11i

Databases: Oracle 11i/10g/9i/8i, MS-Access, Sybase, SQL server 2008

Oracle Apps Modules: Fixed Assets (FA), Cash Management (CM), Bill Of Materials (BOM),General Ledger (GL), iProcurement, iSupplier, iStore, Order Management (OM), Purchasing (PO), Project Accounting (PA), Receivables (AR), Payables (AP), AOL, Trading Community Architecture(TCA), Inventory (INV), Installed Base and HRMS, Service Contracts (OKS), Pricing (QP), Shipping (WSH),.

Operating Systems: Windows 98/2000/NT/XP/07/08,UNIX, LINUX

Languages: SQL,PL/SQL,C,C++, HTML, JAVA, UNIX

Gui: Discoverer10g/9i/4i,Oracle Forms 6i/9i/10g, Workflow Builder 2.5/2.6, AME, EDI, XML Gateway, Noetix, ADI, BI Publisher, OBIEE, Reports 6i/9i/10g, XML Publisher 2.5,.

Tools: BI/XML Publisher, Load Runner.,Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data Loader.

Web Technologies: JSP,PHP,HTML,XML

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Created Contracts Accrual Report in Discoverer based on the Stream Revenue package.
• Developed stand-alone reports according to the requirement.
• Transfer Intercompany Transactions to General Ledger.
• Collection, analysis and consolidation of users reporting requirements.
• Developed the Custom Billing Program for Contracts based on the Invoice Information.
• Worked with form personalization for customizing Oracle forms.
• Worked on preparing specification documents for the custom reports. Developed the custom reports like Purchase Order Receipt Report, Order Lines Summary Report.
• Customized the WIP Valuation XML Report which fetches only those WIP entries whose transactional records where posted to GL within the date range specified in the parameters.
• Worked on GL interface, AR Customer Interface, Purchase Order Interface.
• Defined set of book with Currency and calendar in GL
• Analyzed their present application and collected the requirements from the user. Prepared functional and technical documentations for the required objects.
• Developed new report Credit Memos in Discoverer.
• Developed the Stream Revenue Program to populate data from the base tables to the custom tables.
• Wrote Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Provided day-to-day Production support for Oracle Discoverer.
• Process and Performance plans to Bring out enhancements in the current system.
• Created the Inventory Detail report in Discoverer.
• Created new reports such as Incoming Sales and Order Report and Shipping Detail Report using reports 6i
• Manage to accurately establish the length and difficulty of tasks and projects, set reasonable objectives and goals, anticipate and adjust for problems/roadblocks and measure results against goals.
• Extensively worked in developing Functional Design Documents (MD50), Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Performed Customization of Purchase History Report in PO.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.

Environment: GL, AR, AP, PL/SQL, Reports 6i, SQL*Loader, HP-Unix, Windows NT/2000, BOM, WIP, Inventory, Oracle Applications 11i(11.5.10.2), SQL*plus.

Confidential, Newark, NJ

Oracle Applications Techno Functional Consultant

Responsibilities:

• Used flex fields and provided techno-functional support for oracle R12/11i-order management.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Used Application Object Library ( AOL) components to Register Reports and Concurrent Programs.
• Worked on items in Inventory.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Implemented Receiving Open Interface in Purchasing (PO) Module.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Imported Bills and Routings through BOM Interfaces.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.
• Implemented Daily Conversion Rates Interface in General Ledger (GL).
• Worked on customization of several standard reports in Purchasing (PO) using Oracle Reports builder such as, printed Open Purchase Order Report and Purchase Requisition Status Report.
• Developed custom Oracle Reports in GL / AP and AR modules.
• Performed Customization of Purchase History Report in PO.
• Provided day-to-day Production support for Oracle Discoverer.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the Journal import interface in Oracle General Ledger (GL).
• Performed Auto lockbox interface program to load customer’s payments information into receivables (AR) base tables by using SQL*loader and auto lockbox interface program.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.

Environment: Oracle Applications 11i, XML Publisher, Oracle10g, Accounts Receivables (AR), Cash Management (CM), Account Payables (AP), General Ledger (GL), Order Management (OM), I Expenses, AOL, Purchasing (PO), OBIEE, Reports 6i,SQL*Loader, PL/SQL, UNIX, Toad 9.0.1.8, Windows XP, forms 6i, Workflow, Discoverer 10g,.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Prepared SQL queries to identify transactions from the transactions posted to General Ledger using GL JE HEADERS, GL JE LINES, and GL JE BATCHES tables.
• Developed Custom Program for Vendor Conversion (Include Vendor, Sites, Contacts) in AP Module.
• Customers are maintained using the Trading Community Architecture (TCA).
• Developed Custom Program for Employees Conversion
• Traced the linked Sales Order and Customer Information by using the Invoice Number in Account Receivables (AR).
• Developing Reports, Customization of Reports
• Reconciliation Report for Payments Interface.
• Reconciliation Report for Invoice Interface
• Reconciliation Report for Requisitions Interface
• Reconciliation Report for Item Interface
• Created indexes to enhance the performance of the applications.
• Created flat files using UTL FILE, DBMS utility package which displays federal GL entries grouped by code combinations.
• Developed the UNIX shell scripting programs to upload flat files to FSS GL System.
• Developed various outbound process to send flat file from Oracle Applications to external system using UTL file package, FTP.
• Developed Custom outbound Interface to send the Payments file to third party system in AP Module.
• Developed custom outbound interface for New Hire Report to report Georgia state Government by-weekly by FTP in HRMS Module.
• Developed Custom outbound Interface to send the Invoices file to third party system in AP Module.
• Developed Material On-hand Quantity Interface to transfer the Material Transactions information into Legacy Flat file. Developed various Inbound process.
• Developed Requisitions Open Interface to upload the Requisitions transactions into the Oracle apps Base tables.
• Developed Purchase order Interface to upload the STANDARD Purchase order transactions into the Oracle apps Base tables.
• Developed Custom Item create Interface program to populate the Items, revisions, categories, cross-references information.

Environment: Oracle Applications 11i, TOAD, AR, AP, PO, INV, HR, UNIX, Oracle 9i, Reports 6i, PL/SQL, SQL*Plus, SQL*Loader.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Created test plans and detailed design documents for the custom components
• Involved in coding, testing, and system integration.
• Interaction with the onsite team for technical design and integration testing.
• Involved in the review of detailed design documents and unit test plans.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Responsible for creation of MD070s for AP Invoice import.
• Involved in the conversion of Purchase orders from legacy system into oracle database.
• Involved in developing custom views for creating reports using Discoverer.
• Developed custom reports as per requirement in OM, INV using Oracle Reports 6i.
• Involved in technical design, development and support for “Order to Cash” and “Procure to Pay” business processes.
• Involved in the development of TCA (Trading Community Architecture) Model.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Responsible for the architecture and process design and its interaction with the Shop Floor and Oracle for Appliances.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Developed Customer conversions Program and upload the data into Customer base tables.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Developed PO outbound interface to get the flat files from Base Tables.
• Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed Customer License Form to save the Customer’s License information.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.

Environment: Oracle Apps 11.5.8, Oracle A.I.M,Oracle 10g, Oracle R.I.C.E, Shell Scripting, Discoverer, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, TOAD, SQL*Developer, Forms(6i), XML Publisher, UNIX, Procure-2-Pay,WINDOWS XP.

Confidential

Oracle Technical Consultant

Responsibilities:

• Customization to display credit holds description Confidential the time of Order Entry and develops a CUSTOM form to display all the information about credit check Confidential one place.
• Involved in adding new descriptive flex field in Order Management to capture additional data
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Involved in the Back to back orders setups.
• Write Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Worked on technical developments as a part of Oracle Applications implementation covering the technical design, documentation and development, etc.
• Involved in attending training sessions on OM, PO, BOM and INV in 11i.
• Managing custom application development projects, customization and extension of Oracle Applications. PLSQL, Workflow, Forms and (Java, JSP, XML) & OA Framework are an added advantage.
• Design & development of reports and Forms for various modules of Oracle Apps.
• Preparation of documentation such as MD050/MD070 for Customizations.
• Involved in Data migration.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Workflow customization to auto creates PO for Low Value requisitions.
• Develop Open Purchase Orders report using XML that queries all Open PO's Confidential header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.

Environment: Oracle APPS 11i (AR, OM, QP, PO, AP, Alerts), PL/SQL, TOAD and UNIX, Developer 2000, Workflow, SQL*Loader.