OBJECTIVE:

• Seeking a career position as a consultant in Oracle E - Business Suite environment 11i/R12 involving Implementations/upgrade/support where I can be a part of the positive change using my ERP Skills.

SUMMARY:

• 8 years of experience in Oracle E-Business Suite,Experince in Design, Development, Implementation and Customization of business applications using Oracle Applications.
• Oracle Applications 11i, R12 using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 10g/9i/ 6i / 4.5, Reports 10g/9i/6i/2.5, Discoverer 10g/4i / 3i.
• Functional knowledge in oracle apps financials, distribution and manufacturing modules like Oracle Accounts Receivable (AR), General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), Cash Management (CM), Inventory(INV), Purchasing (PO), and Order Management(OM), iExpenses, ORDER TO CASH and PROCURE TO PAY cycles.
• Expertise in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Experience in development tools such as PL/SQL, JSP, JDeveloper, Oracle Developer suite 10g & Forms 9i/10g and Reports 9i/10g, Workflow Builder and XML Publisher.
• Experience in writing Procedures, Packages, Functions, Forms, Triggers views, records, constraints and other database objects using SQL and PL/SQL
• Expertise in RICEW - Reports, Interfaces, Conversions, Extensions and Workflow.
• Developed/customized Oracle Forms using Form Builder, Custom.pll, Forms Personalization and Jdeveloper 9i, Reports with XML/BI Publisher.
• Experience in developing and customizing Oracle reports by using Report 6i /9i/10g and Discoverer 4i / 10g and XML publisher.
• Well versed with client server environment and tools like TOAD, SQL*Loader and SQL* Navigator.
• Migration Experience working on 10g to 11i and 11.0.3 to 11.5.10 and from 11. Instances.
• Experience in modules like GL,AP,AR,OM,PO,FA,INV,BOM,IExpense,Istore, Shipping,Service Contracts, Install Base,TCA
• Strong knowledge of Application Object Library (AOL) implementation standards and Trading Community Architecture (TCA).
• Tuning of customized application including reports and backend customization by using different application tuning techniques.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement.
• Experience in developing inbound and outbound Interfaces for Oracle General Ledger(GL), Accounts Receivables(AR), Purchasing, Quoting, Order Management(OM) and Inventory modules.
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Future Business Mapping Document (BP-80) and Business Requirements Mapping Documents (BR-100) user manuals, test procedures document preparation.
• Extensive Experience in Business requirements gathering, gap analysis, software design, development, enterprise integration, data migration, conversion, interface, Fast Formulas, development/customization of forms and reports, development of custom modules and integrating them with Oracle applications, developing test plan and test cases, testing, implementation and support.
• Possess excellent communication skills, good team-management and leadership qualities and can work independently or collaboratively in teams.

TECHNICAL SKILLS:

Oracle Applications: Oracle General Ledger (GL), Payables (AP), Receivables (AR), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Inventory (INV), Bills of Materials (BOM), Inventory, IExpense,istore,iprocurement,Oracle Time and Labour,Oracel Grants, Oracle Approval management,Shipping,Service Contracts, Install Base,TCA,Project Accouting,Self Service and AOL.

Tools: Oracle Enterprise Manager, EDI, JDeveloper,TOAD, SQL*NAVIGATOR, Forms/Reports 6i/9i/10g, Discoverer 4i/9i/10g, XML Publisher,SOA Middleware,Winscp,Putty.

Operating Systems: Windows XP/2000/98, UNIX, Sun SolarisLanguages: SQL, PL/SQL, peoplesoft,Shell Scripting

RDBMS: Oracle11g/ 10g/9i/ 8i/8/7.3, SQL Server, and Ms Access

Other/Web Technologies: Java,HTML, XML,C#.Net.

PROFESSIONAL EXPERIENCE:

Oracle Apps Techno functional consultant

Confidential, Ramsey, NJ

Responsibilities:

• Actively involved in weekly status review meetings and project status meetings with users.
• Involved in scoping and designing of the project phase from the scratch.
• Worked with the business analyst to understand the businss reqirements and providing the functional specifications and technical design for the E-invoicing project.
• Analysed the gaps in the current E-invoicing solution, did research on some E-invoicing solutions that fills the gaps in the existing system.
• Involved in generation of FSG reports according to the client requirement. provided setup documents to integrate oracle with i-supplier portal,OSN.
• Worked on the invoices and purchase orders, provided extracts required . created a validation process to extract all the enabled Rule3 from the oracle cross validation rules table and for each Account.
• Fixed the validation rules to avoid duplicate invoice entries from Invoice work bench and Oracle AP invoice interface program.
• Developed and tested PL/SQL package that contains utilities to support workflow activities of Contract Purchase Agreement (a type of purchase order) approval workflow process for Oracle Contracts and Sourcing applications.
• Developed and tested PL/SQL package that contains common utility functions and procedures to support Oracle Custom application workflow activities approval.
• Worked on Purchase Order Import Interface, the interface validates the Purchasing data and inserts into Interface Tables and calls Import Standard Purchase Order program and creates the Purchase Orders
• Involved in fixing the issues in production related to GL, AP, AR applications.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Development/modification of custom reports in purchasing and payables.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements.
• Developed a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Created Forms using Forms 10g and registered them in Oracle Apps R12

Environment: OracleApplicationsR12.1.03, Oracle11g,AP,PO, GL Reports 10g,forms 10g,SQL*Loader, SQLDevloper, TOAD, UNIX, Shell scripts.

Oracle Apps Techno functional consultant

Confidential, Indianapolis, IN

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked on various financial modules (AP, PO, GL, OM and AR).
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Develop AP/AR/GL/PO reports using XML publisher(BI publisher) which include the following:
• PO requisition reports.
• AR sales profit report with cost of goods.
• GL Summary Report.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Involved in generation of FSG reports according to the client requirement.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Create Customers, contacts, relations, locations, sites and contact points like email andTuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.
• Preparation of technical specificationsdocuments from the functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
• Extraction Orders, AR Invoices, AR Receipts, AP Invoices, Customers, Banks, Fixed Assets, vendors, GL Balances, GL JNRLS etc. from 11i
• Converting the same to R12 i.e. Using Standard APi’s
• Existing Reports (80 Reports) from 11i has been converted into R12. 40 Reports has been Re-Developed using Xml publisher in R12.

Environment: Oracle ApplicationsR12, GL, AR, AP, PO,OM Reports 10g,forms 10g,SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Oracle Apps Techno Functional consultant

Confidential, Boston, MA

Responsibilities:

• Interacted with Business Analysts to gather information for developing test plans.
• Tested set Confidential and implementation of AP, AR, GL, INV Modules in R12.
• Functional Knowledge on all Financials modules and good knowledge on order to cash, procure to pay cycles, APIs and underlined tables.
• Developed AP/AR/GL/PO/INV/FA reports using XML Publisher which include the following
• PO, AP Analysis Report, AP / AR aging Reports.
• GL sub ledger analysis, account balances reports.
• Supplier analysis report showing number of PO’s raised on a supplier with required status.
• INV valuation reports
• Developed forms for custom modules which include the following:
• DSW Retail sourcing rules.
• DSW Route schedules maintenance form to meet the client requirements.
• Customization of PO requisition form to zoom in to items on hand availability form.
• Developed reports to show all cleared Invoices sorted by Invoice groups, to show all approved Journals that are yet to be posted. And customized Reports using Report builder as per the requirements.
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Workflow Customization for PO Requisition Charge Account Generator using workflow builder.
• Customization of supplier form making it only be created on approval using workflow builder and custom.pll
• Wrote custom packages to develop conversion and Interface programs.
• Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables using the standard program ‘Journal Import’.
• Interface to load all the open invoices in to Oracle Receivables.
• Development of outbound interfaces to upload the GL data to Legacy system by using the UTL FILE Package.
• Preparation of technical specifications from the functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
• Preparation of Documents for User .

Environment: Oracle Applications 11i, GL, AR, AP, PO and BI Enterprise Edition, Reports 6i, work flow, XML Publisher, Discoverer, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Oracle Apps Techno Functional consultant

Confidential, Blue Bell, PA

Responsibilities:

• Lead Technical Developer and Subject Matter Expert for supply chain management modules which includes (Order Management (OM),Purchasing (PO) Inventory (INV), (Receivables (AR), Payables (AP)and iStore
• Involved in handling Critical requests raised by Global Sys Administrators (GSA) and end-users during period closing activities and procedures.
• Interacted with business users in translating their requirements into technical model. Also took part in technical presentation for new development and business process definitions.
• Increased customer/end-user satisfaction by developing programs which helped in automation of Business processes.
• Contributed expertise in building and designing new interfaces between ERP and other Unisys systems.
• Contributed in requirements gathering and also to Use Case documents.
• Developed and enhanced the custom RICE (Reports, Interfaces, Conversion and Extension) components as part of the upgrade.
• Prepared understanding documents, MD070,, MD120 setup document, UCR and Technical design documents for the client’s requests.
• Coordinated and performed code review of deliveries from offshore team.
• Also involved in gathering functional and business requirements in Supply Chain Management modules which included Impact assessment and sizing documents till date.

Environment: OracleApplication 11i,Oracle 9i, Modules OM,INV,PO.

Oracle Apps Technical Consultant

Confidential, Carlsbad, CA

Responsibilities:

• Migration of the Data from legacy system to the new system Customized Accounting Flex Fields, Cross Validation Rules and Security Rules.
• Created an Audit report which gives the audit details of Migration of data.
• Wrote UNIX Scripts to extract custom objects from each product top.
• Designed interface programs to facilitate transfer of large volumes of legacy data from flat file to Oracle Apps modules like AP, AR, GL and FA.
• Worked on importing the period end rates for all set of books.
• Worked on GL Interface, uploaded the data and then imported the GL data for a specific period and currency code.
• Worked on the Invoice detail report which gives the vendor and their invoice details.
• Wrote procedures to extract all the SQL statements from the Database Objects like Forms, Reports and SQL Scripts.
• Developed salespersons Discoverer report.
• Created reports using Foundation tables and views and custom views
• Devised Performance improvement plans for underperforming individuals.
• Worked on supporting Receiving Transactions Interface errors in Purchasing, fixing the stuck records, investigating the issues in receiving and following up with the Receiving users at DC.
• Working on the upgrade process from 11.5.10 RUP2 to 11.5.10 RUP6. Upgrading the Custom objects, DFFs etc and testing each module.
• Designed and developed reports - PI Commercial Invoice report, PI Pick Slip and PI Pack Slip Report using XML Publisher.
• Developed Custom Pl/sql packages and procedures. Used advanced PL/SQL concepts like Objects, Bulk collect etc.
• Designed Shipping labels for PI Pick Slip and PI Pack Slip Report using Zebra Designer.

Environment: Oracle Applications 11.5.10 RUP2, 11.5.10 RUP6, GL, AP, AR, INV, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBMS 9i/10g, Unix.

Oracle Applications Technical Specialist

Confidential

Responsibilities:

• Designed and developed Requirement Analysis, Preparation of User Documentation and Preparation of Testing Scenarios, and Performing Unit testing prior to go-live.
• Implemented Accounts Payables (AP) Standard functionalities (Invoices, Payments and Credit Memo).
• Developed and implemented data-conversion program for AP Invoice and Payments.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data.
• Used Customer Interface to transfer and validate Customer data from legacy system into AR.
• Worked with Receivables Auto Invoice Interface program to load Receivable transactions.
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing
• Defining Supplier, Organization, Items, Purchasing Options and Buyers in purchasing implementation.
• Customizations of Requisition Approval, PO Approval & Auto Create Workflows
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).
• Designed and Developed the Sales Order Conversion to load historical orders and regular orders in OE. The Updated Orders will be updated back in oracle through the interfaces.
• Developed flexible PL/SQL scripts/packages for data objects creation such as tables to store and maintain legacy data.
• Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.
• Customized the Order Header level workflow, which will send a notification based on the data mismatch between order header level and order line level.
• Developed PL/SQL scripts for Item Cost Conversion, Pricelist Conversions.
• Involved in importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.
• Used Oracle Workflow Builder to define the sequence of functions as a workflow process, specify job dependencies between the mappings to ensure that jobs run in the proper order.
• Create detailed deliverables utilizing the AIM methodology (MD 50 and MD 70).
• Performed SQL tuning by using Explain Plan and Tk-Prof to improve performance of loads.

Environment: Oracle Applications 11i, GL, AP, AR, PO, OM, Costing, AOL, Oracle Workflow Builder (OWB), Oracle 10g, Windows XP, SQL*Loader, PL/SQL, Toad, XML Publisher, Forms 6i, Reports 6i.

Technical consultant

Confidential

Responsibilities:

• Developed interfaces between legacy systems and Oracle Apps
• Defined journal sources, categories for the journals, also setup set of books.
• Knowledge of Performance tuning of various queries and stored procedures.
• Importing invoice information into ORACLE Payables using SQL*Loader.
• Designed, developed, registered customized forms, tables and reports using AOL
• Developed customized Reports like aging analysis, Customer balance, and Revaluation report in AR.
• Developed Reports in OE Module i.e. open Orders by Sales Order and Line Item Report. Order Booking and Backlog Report.
• Customized fixed assets book report and Asset listing report in Fixed Assets module
• Involved in system administration responsibilities and creating Alerts and dealt with Multi Org Concurrent program registration
• Create Users and Responsibilities for Security.
• Defining New Descriptive flex fields
• Creation of Concurrent Manager and Managing Concurrent Processing.

Environment: Oracle Apps 10.7(GL, AP, AR, FA, OE, INV, PUR, AOL), Oracle 8, Forms 4.5, Reports 2.5, SQL Loader 7.1, Windows NT