SUMMARY

• Senior Oracle Application Consultant with 9 Years of experience in Oracle Applications 11i and R12.
• Extensive experience in Order Management (OM), Purchasing (PO), Inventory (INV), Shipping (WSH), Account Payables (AP), Account Receivables (AR), General Ledger (GL).
• Very good experience in Implementation projects, Upgrade projects, Support projects and Rollout projects with Oracle Applications 11i (11.5.10 and 11.5.9) and recently R12 (12.1.3).
• Very good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flow.
• Expertise in Developing Custom components like Interfaces for Order Management & Account Receivables.
• Experienced in developing RDF reports using XML/BI Publisher
• Experienced in developing Discoverer reports.
• Experienced in SQL, PL/SQL for writing and customizing program units like procedures, functions, interfaces.
• Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the Oracle Applications.
• Expertise in Developing Shell Scripts.
• Expertise in applying AOL standards and developing RICE components.
• Experienced in working on Alerts, XML bursting and Form personalization.
• Experience in developing and customizing Oracle Forms.
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization and extension of existing OA Framework pages.
• Good at creating technical reference guides, user manuals and other related technical documentation.
• Experience in handling tickets for support projects and also able to prioritize the tickets based on the SLA.
• Experience in grooming newly joined associates and guided them well which helped in betterment of project.
• Experienced in Agile methodology way of implementing project.

TECHNICAL SKILLS

ERP Oracle Applications: R12 (12.1.3) & 11i (11.5.10 and 11.5.9)

Development Tools: Reports 10g/6i, Forms6i, Discoverer 10g/9i, TOAD, Oracle SQL Developer, XML Publisher, JDeveloper9i

Packages: MSOffice

Database: Oracle 8i/9i/10g

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

Oracle Applications Techno Functional Consultant

Responsibilities -

• Requirement Gathering from the Users for change they need to improve current business process major were:
• Fixed Asset Clearing Account to streamline tracking of their asset addition and CIP projects.
• To change the Asset Categories structure as it was challenging to maintain Fixed Asset after reorganizing of the companies
• FSG Reports for more Budget oriented comparisons and maintenance.
• Worked on the configurations and setups of Accounts Receivables module - defining the Auto Invoice Options, Auto Lock Box, Auto Accounting, Revenue Recognition, setting up Transaction Types.
• Worked on the configuration of the Accounts Payable Module - defining the Payment Manager options, setting up the Payment Templates, defining the Payment Process Profiles, etc.
• Worked on the General Ledger setups - defining the chart of accounts, setting up the calendar and defining the primary and secondary ledgers.
• Developed PO Receipts Interface Program by using SQL*Loader and PL/SQL Script to load data from legacy System to Oracle base tables.
• Requirement Gathering from the Users for Financials and Project Management and related modules like Project Management, Project Costing, Project Billing, Project Contracts, Project Intelligence.
• Prepared BP040, CV040, BR100, MD050 and test cases documents.
• Conducted POC’s & CRP Sessions.
• Setting-up Project Management components like Project Types, Statuses, Roles, Periods, Resource Types, Budget and Forecast, Planning Resource List, Resource Breakdown Structure, Work Breakdown Structures and Project Templates
• Developed SQL*Loader script & PL/SQL script to Import Items, Item Categories data into Inventory Interface tables and imported into Oracle base tables using Item Import Program.
• Developed Interface for AP Invoice in AP module to load data from legacy system to Oracle base tables using SQL*Loader and PL/SQL Script.
• Documentation, Configuration and Testing of changes in business processes, reports (includes FSG).
• Preparing POC environment for Business Intelligence (DBI) for Financials.
• Developing the customized components like interfaces and reports.
• Conducting User Training and prepared user training manuals using Oracle’s User Productivity Kit (UPK).

Environment: 12.1.3 Financials and Supply Chain (OM, INV, PO, AR, AP, GL, FA, CM, Service Contracts and Install Base)

Confidential, San Jose, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in the Supplier migration from legacy system into Accounts Payables using Supplier interface.
• Worked on Open AR Invoices migration from legacy system to AR using Auto Invoice Interface.
• Designed and documented the technical specifications documents (MD70) using the available functional specification (MD 50).
• Developed UNIX Shell script to transfer files across directories.
• Developed AP On holds Invoices report using XML Publisher report.
• Created custom Reports related to Oracle AR module to allow users to get the required invoice and customer information when required using XML Publisher.
• Developed Discoverer reports.
• Developed a program to attach the Purchase order report output to the Purchase order Form attachments, So that user can view the output in the Standard Form itself
• Created Event Alerts to trigger concurrent programs based upon the action.
• Involved in extensive Testing and documentation of the objects.
• Responsible for the development of GL related programs
• Code Migration activities across the CRP environments.
• Involved in client meetings which helped me understand the clients business.
• Worked on OAF customization (VO Extension) to add a date field.
• Developed XML Publisher Reports based on the Client Requirements on OM, AR, PO and AP.
• Worked on FNDLOAD to create LDT files for the migration of code from instance to instance.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Applications 12.1.3 - (AP, AR, PO, OM), Oracle 10g, XML/BI Publisher, Reports 10g, SQL*Loader, TOAD, Discoverer 10g

Confidential, Pittsburgh, PA

Oracle Applications Technical Consultant

Responsibilities:

• Requirement Gathering from the Users for Financials and AR, AP, GL, FA, Project Accounting, Cash Management, SLA and e-Business Tax.
• Prepared BP040, CV040, BR100, MD050 and test cases documents.
• Conducted POC’s & CRP Sessions.
• Setting-up AR, AP, GL, FA, Project Accounting, Cash Management, SLA and e-Business Tax modules
• Coordinating with on-site off-site developers a team of 10 for the development of customized components like interfaces, reports and ADF pages.
• Testing customizations done to meet the requirements.
• Handling Service Request’s with Oracle Corps to identify Bugs and implement Bug fixes and up gradation patches.
• Communication and Coordinating custom components with various teams like outside vendors, Offshore team and individual contractors.
• Implemented XML bursting to send the copy of the report output as an email attachment to the user.
• Worked on Custom API to add new Suppliers, Update (either Supplier site address or Supplier name), and Delete (Deactivate) Supplier.
• Developed UNIX Shell Scripts for moving and copying files from server to client and from client to server.
• Upgraded the existing 11i XML reports to R12.
• Upgraded existing Discoverer reports to R12.
• Developed UNIX Shell Script and created soft link to it for better and easy performance which takes parameters.
• Created custom Reports related to Oracle AR and OM modules using XML Publisher and PL/SQL procedures.
• Worked on Data migration for Customers and Item master using standard API’s.
• Created Control files, SQL loader scripts and validation programs.
• Created few Event and Periodic alerts upon the requirement.
• Worked on Form personalization on standard forms by creating special menus on which by clicking submits the concurrent program.
• Involved in extensive Testing and documentation of the objects.
• Worked on performance tuning of discoverer reports and XML Publisher reports.
• Involved in client meetings which helped me understand the clients business.
• Developed XML Publisher Reports based on the Client Requirements.
• Worked on FNDLOAD to create LDT files to migrate the code from instance to instance.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Application 11i/R12.1.3 (AP, AR, GL, PO, OM), Reports PL/SQL, SQL* Loader, Discoverer 10g/11g.

Confidential, Collierville, TN

Oracle Applications Technical Consultant

Responsibilities:

• Worked on Supplier data migration using Supplier interface.
• Worked on AP and AR open invoices migrations.
• Developed an OM interface program which creates the Sales order in the Oracle system based upon the Customer and Item data provided by the legacy system.
• Developed an Automated sales order creation program which covers the complete O2C cycle. Creating the sales order, does Pick release and ship confirm and creating invoice using Auto invoice program.
• Developed XML Publisher report which restricts for only 9 lines for each page.
• Implemented Barcode functionality in the Packing slip report
• Developed UNIX Shell Scripts for moving and copying files.
• Developed EFT payment format Program for Banks for Payables, which generates the Text Output in the pre-defined format and send it across to the bank server through FTP.
• Created few Event and Periodic alerts upon the requirement.
• Worked on Form personalization on standard forms.
• Involved in extensive Testing and documentation of the objects.
• Developed Oracle Form using Master detail relationship.
• Customized Reports, Flex fields and Registered with AOL.
• Involved in creating concurrent programs, Value sets, lookups and request sets.
• Involved in handling support tickets.
• Proactively used to assign tickets and work on them based upon the SLA.
• Created few SR’s and co-ordinated with Oracle support closely to get issue resolved.
• Worked on performance tuning of few concurrent programs using PL/SQL procedures.
• Involved in client meetings which helped me understand the clients business.
• Developed PL/SQL stored procedures and functions.
• Developed the MD70 documents for the objects handled.

Environment: Oracle Apps 11.5.10, Manufacturing Modules OM, INV, PO, Oracle Financials AP, AR, GL, Order Management(OM), Inventory (INV), XML/BI publisher, Reports 6i, Oracle SQL Developer, Windows XP, Oracle 10g, SQL Loader, SQL Plus.

Confidential

Oracle Financials and Project Accounting Techno-Functional Analyst

Responsibilities:

• Production Support of ERP Oracle 11i modules involved in Procure to Pay cycle (like i-Expense, i-Procurement, Purchasing, Payables, Approval Management Engine (AME)) and Project Accounting. Includes debugging and providing solutions technically (includes workflows and interfaces) as well as functionally.
• Providing and implementing process improvement solutions (like Re-Configured Expense setup and AME rules as per the changing business requirement and major Organizational changes. Major achievement in reducing 98% of process related bugs in less than 1 year).
• Handling Service Request’s with Oracle Corps and Confidential internal team members to identify Bugs and implement Bug fixes and up gradation patches.
• Implemented Purchasing and Payables module in roll out of new business entities. (Prepared BR100, test cases and configured the two modules along with i-Expense and i-Procurement, used data loader for migration of data from other systems.)
• Represented ERP Team for Confidential ’s Rebranding Project and coordinated all the changes required in Oracle 11i.
• Enhanced XML Reports for printing invoices against agent commission payable, PO and AP Invoices etc.
• Worked on interlink between Project Accounting, Fixed Assets, Inventory and Order Management, Project Management and General Ledger with Purchase Orders, i-Procurement, i-Expenses and Account Payables.
• Preparation of Technical specification documents, coding and testing for change requests including Workflows, Discoverer Reports, Alerts, Interfaces etc.
• Responsible for maintaining i-Procurement, i-Expenses and AME as lead includes personalization of OA pages, maintaining Stores, Catalogues, AME rules, I-Expense Rules, I-Expense Templates.
• Supporting One Bank Solution interface for payments
• Involved in Month-end support for close and reconciliation for AP and PO modules
• Prepared impact analysis for critical issues
• Resolved issues that occurred in the production, including communication directly with Top Level Management.
• Worked with the business to develop updated business policies based on issues resolved.
• Pro-actively involved in troubleshooting various issues.
• Interacted with Oracle Support to resolve critical issues through SR/TAR
• Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.