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 teh 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 wif 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 wif 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 teh PO Approval process, Order/Line Flow to send user notifications based on teh 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 training 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 wif 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 Solaris

Languages: 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 wif users.
• Involved in scoping and designing of teh project phase from teh scratch.
• Worked wif teh business analyst to understand teh businss reqirements and providing teh functional specifications and technical design for teh E-invoicing project.
• Analysed teh gaps in teh current E-invoicing solution, did research on some E-invoicing solutions dat fills teh gaps in teh existing system.
• Involved in generation of FSG reports according to teh client requirement. provided setup documents to integrate oracle wif i-supplier portal,OSN.
• Worked on teh invoices and purchase orders, provided extracts required . created a validation process to extract all teh enabled Rule3 from teh oracle cross validation rules table and for each Account.
• Fixed teh validation rules to avoid duplicate invoice entries from Invoice work bench and Oracle AP invoice interface program.
• Developed and tested PL/SQL package dat 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 dat contains common utility functions and procedures to support Oracle Custom application workflow activities approval.
• Worked on Purchase Order Import Interface, teh interface validates teh Purchasing data and inserts into Interface Tables and calls Import Standard Purchase Order program and creates teh Purchase Orders
• Involved in fixing teh issues in production related to GL, AP, AR applications.
• Migrated custom interfaces on teh Oracle AR and Oracle AP from oracle 11i to R12.
• Worked on Oracle Order Import API to validate and load teh PO information to teh interface tables.
• Development/modification of custom reports in purchasing and payables.
• Customized teh existing workflow by adding notifications at teh 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 teh requirements from teh user and understanding their business model.
• Worked on various financial modules (AP, PO, GL, OM and AR).
• Defined teh 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 teh following:
• PO requisition reports.
• AR sales profit report wif cost of goods.
• GL Summary Report.
• Customized seeded reports as per teh requirement like Customized teh 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 teh client requirement.
• Involved in writing interface program to load teh data from external systems into Oracle purchasing (PO) interface tables.
• Create Customers, contacts, relations, locations, sites and contact points like email and Phone using seeded API’s
• Customization of PO Approval workflow process to ensure teh notification is send to next in hierarchy if teh first approver doesn't respond using workflow builder.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized teh PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets wif concurrent programs to run in stages depending on teh 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 teh 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 teh 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 wif 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 teh 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 wif required status.
• INV valuation reports
• Developed forms for custom modules which include teh following:
• DSW Retail sourcing rules.
• DSW Route schedules maintenance form to meet teh 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 dat are yet to be posted. And customized Reports using Report builder as per teh requirements.
• Teh PO Approval Workflow is used to approve new documents as well as approve revisions to teh 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 teh Journals data from Legacy to Oracle applications GL base tables using teh standard program ‘Journal Import’.
• Interface to load all teh open invoices in to Oracle Receivables.
• Development of outbound interfaces to upload teh GL data to Legacy system by using teh UTL FILE Package.
• Preparation of technical specifications from teh functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
• Preparation of Documents for User training.

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 wif 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 halped in automation of Business processes.
• Contributed expertise in building and designing new interfaces between ERP and other Confidential systems.
• Contributed in requirements gathering and also to Use Case documents.
• Developed and enhanced teh custom RICE (Reports, Interfaces, Conversion and Extension) components as part of teh upgrade.
• Prepared understanding documents, MD070,, MD120 setup document, UCR and Technical design documents for teh 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 teh Data from legacy system to teh new system Customized Accounting Flex Fields, Cross Validation Rules and Security Rules.
• Created an Audit report which gives teh 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 teh period end rates for all set of books.
• Worked on GL Interface, uploaded teh data and tan imported teh GL data for a specific period and currency code.
• Worked on teh Invoice detail report which gives teh vendor and their invoice details.
• Wrote procedures to extract all teh SQL statements from teh 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 teh stuck records, investigating teh issues in receiving and following up wif teh Receiving users at DC.
• Working on teh upgrade process from 11.5.10 RUP2 to 11.5.10 RUP6. Upgrading teh 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 Training 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 wif data.
• Used Customer Interface to transfer and validate Customer data from legacy system into AR.
• Worked wif 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 teh Sales Order Conversion to load historical orders and regular orders in OE. Teh Updated Orders will be updated back in oracle through teh 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 teh Order Header level workflow, which will send a notification based on teh data mismatch between order header level and order line level.
• Developed PL/SQL scripts for Item Cost Conversion, Pricelist Conversions.
• Involved in importing teh Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating teh data using PL/SQL Script and Creating Orders using Order Import Program.
• Used Oracle Workflow Builder to define teh sequence of functions as a workflow process, specify job dependencies between teh mappings to ensure dat jobs run in teh proper order.
• Create detailed deliverables utilizing teh 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 teh 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 wif 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