SUMMARY

• More than 7 years of extensive experience as an Oracle Applications (E - Business Suite) consultant, expertise in Design, Implementation, Upgrade and Customization of Distribution and Financial modules within Oracle Applications EBS (Inventory INV, Order Management OM) Accounts Payables AP, Accounts Receivable AR, General Ledger GL, Purchasing PO, and cash management CM).
• Technically proficient in RICE (Reports, Interfaces, Conversions, Extensions) components including Implementation, Interfacing, Data Migration and Data Conversion.
• Gathered business requirements and created Functional documents, Fit gap analysis documents and prepared Test strategies and Test plans for post implementation support.
• Expertise in developing custom programs using Oracle Open Interfaces, APIs and Unix Shell Scripting.
• Experienced in developing/customizing PL/SQL Packages, Procedures, Functions and Triggers.
• Well versed with client server environment and tools like Oracle Reports, Oracle Forms, XML/BI Publisher, Discoverer and Jdeveloper.
• Experienced in Developing/Customizing Workflows to automate business events.
• Experience in Form Personalization and customization to establish custom actions to be performed by forms during run time.
• Experienced in the design of System Requirement specifications, functional designs, Business Process re-engineering, Workflow, Test plan preparation, Peer Review, Unit testing, System Integration Testing and Documentation using AIM methodology.
• Extensive experience in registering Concurrent Programs, Forms, Value Sets, Flex Fields, Messages using Application Object Library (AOL) and also working on Sys Admin activities.
• Experience in Customizations, Personalization of Forms and Reports in Oracle e-business suite applications as per requirements.
• Supported the execution of the Conference Room Pilots/System Integration Tests and the User Acceptance Test.
• Expertise in Oracle Applications R12 and Order to cash cycle and Procure to pay cycle.
• Involved in Patch Management, Service Request (SR), Instance Management, Change Control Management (CR), Risk management processes.
• In addition to excellent technical abilities, possess strong communications skills, analytical and interpersonal skills.

TECHNICAL SKILLS

Oracle Apps Modules: Accounts Receivable AR, Purchasing PO, Accounts Payable AP, General Ledger GL and Cash Management CM, Inventory INV, Order Management OM (EBS 11i, R12)

Languages: SQL, PL/SQL

Database: Oracle 9i, 10g, 11i

Operating Systems: Unix, Windows-NT/2000, HP UX RISC.

Oracle Technologies: Oracle E-business Suite(11i/R12), E-service Bus(ESB),BPEL

Java/Web Technologies: J2EE, Struts, JavaScript, Servlets, JSP, Java Beans, XML, DHTML, JDeveloper.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Oracle Apps Technical Consultant

Responsibilities:

• Modified PL/SQL Packages, Procedures, and Functions for data population and updating data as per the user requirements.
• Built interface to import closed orders from legacy system into Oracle during the conversion process.
• Handled successfully sharing the instance with other project team by conducting weekly meetings
• Designed one common solution to create invoices from six external sources systems.
• Developed the Order Import Interface using process order API to interface orders in real time from other external systems.
• Performed setups in Account Receivables, System options, Autoinvoice grouping rules, Autoinvoice line order rules and Auto Accounting.
• Build code to place the orders on hold while creating them if they fall into a certain criteria.
• Developed code to reprice the orders if they are more than 15 days old.
• Responsible for cancelling the orders if they are not shipped for more than 30 days.
• Built a custom 850 EDI Order Inbound process to follow the custom rules and validations while creating orders into Oracle.
• Developed and customized complex XML Publisher reports by communicating and interpreting end-user business requirements in Inventory and Order Management.
• Involved in developing new OAF pages from scratch in CRM module
• EO, VO, AM s created Part of OAF development.(Pint Volume Report, Toner Level Not Changing report, Premeture Toner Change Report, Sku Report, Stale Printer Report, Toner Order Failure Report, Top Printer Report)
• Creating directory structure, Business Components for Java (BC4J) components, such as Entity Objects (EO), View Objects (VO), List of Values (Lov), Pop lists, Transient View Object, Page (PG) files and Region files (RN).
• OAF PPR effectively implemented.
• Customized and developed various reports in AR, AP, GL, PO, OM modules using Reports 9i and Oracle BI Publisher.
• Responsible for developing custom PL/SQL wrappers for fixing the data issues for support team.
• Responsible for Migration of custom reports from Release 11i to Release 12.
• Personalized PO creation screen as per user requirements to prepopulate certain fields and do validation on some others.
• Created technical documents MD070’s and unit test documents (TE020’s) before migrating a component to QA and higher instances.
• Custom Programs are developed using PL/SQL and UNIX scripting.
• Developer UNIX script to get TAR files .and developed Migration Scripts using FNDLOAD.
• Commands to download and upload LDTs which used to migrate all the objects from Dev. Instance to test and production instances.
• Client interaction through meetings & presentations.

Environment: Oracle Applications Release 11i, R12 (GL, AP, AR, PO, OM), Oracle 11i, Oracle Workflows, Oracle BI Publisher, Reports 9i, PL/SQL.

Confidential, Seattle, WA

Oracle apps Techno Functional Consultant (Implementation)

Responsibilities:

• Involved in the Modules: Order Management, Inventory, WIP, shipping, Account payables, Purchasing, Receivables, IExpense.
• Involved in creating documents like (MD 50, MD70 and MD120) functional, technical and Installation documents for all CEMLIs.
• Worked on Gl Daily rates Conversion
• Worked on AP Invoices Conversion.
• Worked on Purchase Order conversion program.
• AP Invoice Conversion and AR Invoice Conversion
• Handled all Oracle Extracts and Oracle conversions to merge two systems.
• Worked on interface and conversion for IExpense to Star out bound program.
• Worked on IExpense Aggregate Spend Forms. (Aggregate Spend is the process used to aggregate and monitor total amount spent by healthcare manufacturers on individual Healthcare Professionals and Organizations).Developed aggregate Spend forms using JDeveloper.
• Extended Controllers (CO) and made personalization’s to work aggregate spend transactions from within the standard iExpense flow.
• Involved in developing new OAF pages from scratch in IExpense module.
• EO, VO, AM s created Part of OAF development.
• Worked on Compliance Tracking Audit report.
• Worked on change request for Purchase price variance discoverer report.
• Worked on change request for Item Roll Forward Report.
• Custom Programs are developed using PL/SQL and UNIX scripting
• Developer Unix script to get TAR files .and ddeveloped Migration Scripts using FNDLOAD commands to download and upload LDTs which used to migrate all the objects from Dev instance to test and production instances
• Client interaction through meetings & presentations
• Trouble shooting and Support - Assisted Client for User Acceptance Test.

Environment: Oracle Applications 12,IExpense, Advanced Pricing, GL, AP, AR, FA, INV, PO, OM, Service Contracts, SQL, PL/SQL, Java, TOAD, XML publisher, Discoverer Reports, Unix scripting,Jdeveloper11g

Confidential, Norwalk, CT

OracleApps Techno FunctionalDeveloper

Responsibilities:

• Involved in Requirement gathering and GAP analysis during the initial phases of the project
• Created a concurrent program which import purchase orders from one instance to other oracle instance by dumping standard tables OE HEADER IFACE ALL, OE LINES IFACE ALL data to load into the custom interface tables
• Developed the custom code in order fulfillment to determine the sourcing warehouse that will ship the product to the ship to location (internal and external) based on specific criteria
• Developed a consolidated view for the downstream applications to pull the pick released delivery lines data for all of the Supplies warehouses.
• Developed the PL/SQL procedures and functions to derive the COGS account only for the supplies transactions. Done forms personalization using these functions and procedure on the Misc Transaction form of Inventory Module to populate the COGS account in the account field of the form.
• Developed an application form Confidential Warehouse Restrictions containing with Triggers, Alerts, Multiple Windows and LOVs using built in features available with Template.fmb. This form allows customer to restrict the ordered items to be picked from warehouse entered in this form.
• Migrated and customized the form Confidential Supplies Default Warehouse Hierarchy from one instance to other using standard AOL functionality CUSTOM.pll library.
• Modified and migrated the materialized views, which access the tables of other instance through the DB, link and contain the ETA values of the warehouse by ground.
• Created and modified custom and standard lookups, profile options, value sets and descriptive flex fields according to the user needs.
• Developed several stored procedures, functions and packages extensively involving with the collections and records such as PL/SQL records, PL/SQL tables, VARRAYs, TABLE index by binary integer, sorting the PL/SQL Tables and reading them by using multi-set operator, reference cursors, parameterized cursors, global temp tables, DBMS SQL Package, UTL FILE package for OM, and INV modules
• In the custom view, wrote the logic to calculate the separate shipment quantity for different delivery of the same line item after they are picking released.
• Handled the data errors with appropriate exception handling and printing the corresponding SQLERRM and SQL code
• Developed custom trigger on table WSH delivery assignments and submitted DBMS JOB of executing the package to derive the values used in the custom view.
• Developed and tuned complex queries to retrieve different bin locations in the order of picking order.
• Created Miscellaneous Transactions to adjust the INV, pick releasing, back ordering, splitting the order lines, making the orders to go on hold, to test the functionality by Oracle. Used MTL SYSTEM ITEMS B, MTL PARAMETERS and MTL UOM CONVERSIONS, MTL ONHAND QUANTITIES tables.
• Created Dummy reservation API INV RESERVATIONS INTERFACE.RSV INTERFACE BATCH PROCESSOR
• Used WSH DELIVERY ASSIGNMENTS, WSH NEW DELIVERIES, WSH DELIVERY DETAILS and related tables to include appropriate left, right outer joins in the view to reduce its execution time for retrieving huge volume of pick released orders.
• Implemented Oracle Order management by loading data from flat files into Oracle Applications using conversion and interface programs
• Responsible for maintenance and tuning of my development units to enhance the speed by utilizing Indexing, Explain Plan and Hints.
• Implemented number of techniques to eliminate redundancies in the Database.
• Scripts in PL/SLQ to read file from remote server and import the lines into custom tables for Point of sale data and present the data to the users using custom forms
• Creating test scripts for user acceptance and system integration testing and suggesting design modifications, where necessary
• Documented business rules, functional and technical designs, test cases, and user guides.
• Industry: Document Services, Digital Imaging, Computer Peripherals

Environment: OracleApplications 11.5.7/11.5.10 Purchasing, OM, INV, Manufacturing Modules such as Purchasing, Shipping Execution, Drop Shipment, Internal Orders, CTO, ATO cycles,Oracle11i, SQL*Loader, Forms 6i, Reports 6i, Lotus Notes, SSH (UNIX), Windows 2000 Forms 6i, Reports 6i, Discoverer 4i, UNIX, Windows 2000, Unix, Windows XP

Confidential, VA

Oracle Apps Technical Consultant

Responsibilities:

• Involved in conversion/interface programs to validate and to load data from staging table to interface tables related to Order to Cash Cycle.
• Involved in the Modules: Oracle Distribution; Logistics like Order Management, Inventory, and receivables.
• Imported order information from legacy system to OM base tables using SQL * Loader with API’s and Interface Programs.
• Involved in importing Customers from legacy system to Oracle base tables using SQL * Loader and Customer Conversion interface.
• By using SQL * Loader program the data from third party source was moved to base tables with the help of staging tables and also API’s.
• Expertise in using UTL FILE Package in moving data from legacy system to Oracle Base tables.
• Developed and customized forms as per business requirements in Order Management and Account Receivables using Forms 6i.
• Worked on workflows in doing customizations in sending Message notifications.
• Responsible for creating concurrent program Scheduling mechanism.
• Custom report development & modified to existing ones in different modules.
• Designed and developed Pick Slip Labels report, Packing slip Labels report according to the requirement.
• Developed and customized Reports as per business requirements in Accounts Receivables, Order Management using Repots 6i and XML publisher
• Developed below XML Publisher reports.
• New Customer Sales Listing Report
• Developed Price Override Report
• Worked on iPayment Batch Traceability Report.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Extensively worked on Discoverer Admin and Discoverer Client Machine in generating reports as per the requirement.

Environment: Oracle Applications 11i (GL, AR,OM, INV), Windows, Unix, Window NT, Oracle 10g/11i, Reports 9i, Forms 9i, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher .

Confidential, Atlanta, GA

Oracle apps Techo Functional Consultant

Responsibilities:

• Developing components, testing and deploying in various instances.
• Developed inbound interface for PA Transaction Import for inbound file coming from Siebel System.
• Developed a shipper report using BI Publisher.
• Developed reports related to Sub Ledger Accounting.
• Worked on Projects Billing AR Transaction type customization. Modified the seeded package “PA CLIENT EXTN INV TRANSFER” for this customization.
• Developed inbound interface for Task import in Project Accounting.
• Worked on GL Journal Import Interface.
• Worked on AP Banks Accounts conversion.
• Developed OA Framework pages on data repository applying security’s based on Organization and supplier type
• Invoice Inquiry page to display Invoice related information
• Purchase Order page to display purchases related to invoice lines
• Payment Inquiry Page to display invoice related to payments
• Developed inbound interface for assigning planning resources to a billable task.
• Developed inbound interface for ADP data to import into GL Import interface tables.
• Developed inbound interface for Order management and PA transaction import for FSS/FTS systems.
• Involved in creating alerts in form personalization.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports.
• Developed Migration Scripts using FNDLOAD and XMLImporter commands to download and upload LDTs which used to migrate all the objects from Dev instance to test and production instances
• Trouble shooting and Support - Assisted Client for User Acceptance Test.
• Maintain Code and Documentation using PVCS.

Environment: OracleApplicationsR12,AP,GL,AR,CM,FA,PO,INV,CoreHRMS,IProcurment,Ipayments, Advanced Pricing, Discoverer 10g, pl/sql, Unix scripting, BI/XML publisher, Jdeveloper.

Confidential

PL/SQL Developer

Responsibilities:

• Requirement Analysis and Implementing Change Requests.
• Interaction with onsite team for requirements gathering.
• Worked on Service request conversion and service Contracts Conversion (Inbound and Outbound).
• Developed OA Framework pages on data repository applying security’s based on Organization and supplier type.
• Invoice Inquiry page to display Invoice related information.
• Purchase Order page to display purchases related to invoice lines.
• Payment Inquiry Page to display invoice related to payments.
• Trouble shooting and Support - Assisted Client for User Acceptance Test.
• Maintain Code and Documentation using PVCS.
• Developed custom Interfaces, for Employee and Vendor in OIC which handles Standard APIs like, creation and update of resource, sales rep, attach role, and attach membership role. Involved in designing and developing MD050 and MD070 documentation for necessary requirements.
• Preparing Technical Design Document and Migration Instructions.
• Unit test plan and unit test results document preparation.
• AOL registration of components using application developer.
• Handling 2nd line support calls (Resolving Production Issues raised by Business Users).
• Setting up of Custom Profiles, Menus, Responsibilities, and Concurrent Programs.
• Technical support during UAT phase and post production support for the issues encountered RICE components.
• System Testing and Test Plan preparation as part of system testing for migration Oracle Apps 11.5.9 to 11.5.10.

Environment: Oracle 11i (11.5.9) Financial Modules, Oracle 9i SQL & PL/SQL, Oracle Discoverer 4, Oracle Reports6i, PL/SQL Developer