SUMMARY

• 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).
• Very good practice and experience in setting up and customizing Accounting Flexfield of General Ledger based on the Organization’s business setup and extension builds.
• 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.
• Involved in different phase of testing like Integration Testing, User Acceptance Testing and Unit testing.
• MSIS system integration with CME EDB system for CBOT to CME system merges.
• Responsible for team definition, project definition, logical database design, physical database design and software design, systems integration, and performance tuning.
• 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, Java scripting, Unit testing, Oracle BI Publisher, Integration Testing, Extension Builds, Reports 9i, PL/SQL.

Confidential, Seattle, WA

Oracle apps Techno Functional Consultant

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.
• MSIS system integration with CME EDB system for CBOT to CME system merge.
• Responsible for team definition, project definition, logical database design, physical database design and software design, systems integration, and performance tuning.
• 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.
• Involved in unit testing and integration testing.
• 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 R12,IExpense, Advanced Pricing, GL,AP, AR, FA, INV, PO, OM, Service Contracts, SQL, extension builds, PL/SQL, Java, TOAD, XML publisher, Unit Testing, Java scripting, Discoverer Reports, Unix scripting, Integration Testing, Jdeveloper11g

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.
• MSIS system integration with CME EDB system for CBOT to CME system merge.
• Responsible for team definition, project definition, logical database design, physical database design and software design, systems integration, and performance tuning.
• 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, Java scripting, Unit Testing, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher .

Confidential, Atlanta, GA

Oracle apps Techno 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, Integration Testing, 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