SUMMARY

• Over 10 years’ experience in Oracle E - Business Suite Applications with expertise in Order Management OM, Purchasing PO, Inventory INV, General ledger GL, Account Payables AP, Account Receivables AR, Fixed Assets FA, Projects Accounting, Costing, Billing, BOM, WIP, Oracle Quality Management, Cash Management and System Administrator.
• Expertise in Upgrade projects like 11i to R12.
• Extensive hands on experience with developing new web pages using Oracle Applications Framework (OAF).
• Experience in customizing and extending web pages using Oracle Applications Framework (OAF).
• Experience in the Implementation and Customization of Oracle Financials, Oracle Manufacturing modules and Supply Chain Modules.
• Extensively worked on RICE (Reports, Interfaces, Conversions and Extensions) Components.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2 , Oracle Forms 10g/9i/6i and Developer 2000.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Proficient in the E-Business Suite cycles of Order to Cash (O2C), Procure to Pay (P2P), Supply Chain Management (SCM).
• Experienced in Complete Software Development Life Cycle (SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Extensive experience in development of Conversions, Open Interfaces and Customization of Forms and Reports.
• Experienced in Customizing Standard Oracle Forms with CUSTOM.pll
• Experienced in Creating and registering Concurrent programs, Executables, SQL* loader scripts, Functions, Procedures, Reports using system administration responsibility.
• Expertise in writing, testing and implementation of Procedures, Triggers, Functions, Packages and design of star schema at database level using SQL, PL/SQL.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF. Used Bulk collection for query optimization.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL FILE.
• Experienced in Tuning SQL Statements and PL/SQL Procedures for enhancing the load performance of application in various schemas across databases
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Hands on Experience in BI and Reporting Tools like OBIEE, Discoverer, Reports and Xml Publisher.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Worked in various projects involving migration, conversions and customization of Oracle Applications and also integration of Financials and Supply chain modules.
• Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.

TECHNICAL SKILLS

Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Projects Accounting, Costing, Billing BOM, WIP, Oracle Quality Management, iSupplier, iProcurement, iExpens, Cash Management and System Administrator).

Developer Tools: Oracle Reports 10g/6i/4i, Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2 , Workflow Builder 2.6.3.5, OA Framework(JDeveloper), OBIEE10.1.3.x, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer, PANAYA Tool.

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux

Languages: SQL, PL/SQL, C, C++, C#, HTML, XML

RDBMS: Oracle 10g/9i/8i MS Access, SQL Server 7.x, 2000

PROFESSIONAL EXPERIENCE

Confidential, Jamesburg, NJ

Oracle Consultant

Responsibilities:

• Design and development of programs for Inter Territorial Workbench process, which involves fulfilling of Drop Ship items of sales orders of specific order types.
• Developed new code to create Ship set based on the order header DFF ship complete flag
• Modified the CUSTOM.pll code to default the Order header DFF ship complete field and Order Line’s Line type field.
• Order line Workflow Customization to apply and releasing the custom hold for the specific order types.
• Developed Price List Conversion Program for Confidential applications to load Price List header, lines and attribute details by creating staging tables and performing validations by writing PL-SQL package into theQP Open interface tablesand then toQPbase tables.
• Involved in defining the basic OM setups like Transaction type, Document sequences, Custom Hold creation and Defining DFF fields for Inter Territorial Workbench process.
• Development of BOM and Routing Conversion.
• Analysis, Design, Development and Production system support of Oracle E Business Suite application.
• Business requirements gathering, gap analysis, solution design.
• Development of the custom code, performing required setups in the ERP application, code base maintenance and migration.
• Preparation of the test scripts, testing the custom code in various instances, documents the test results, end user training.
• Design and developed Confidential Installation and Dealer Compensation report using Oracle report builder.
• Developed Shell script and PLSQL programs to email Confidential Installation and Dealer Compensation reports to Dealer as attachment after ship confirm and attach to Sales Order as a FND attachment.
• Tuning the PL/SQL programs.
• Writing one time fixes code for Production issues.
• Development of Purchase Orders creation program for Inter Territorial Workbench associated sales order lines.
• Designed and Developed Shell script to Read the Email subject and Body from lotus notes to Confidential custom table.
• Wrote COLORlynx Receipt Interface package for different validations, for processing data in order to create Receipts for COLORlynx PO’s and called the seeded import programs to create Receipts.

Environment: Oracle Applications (Order Management, Inventory, Purchasing, Accounts Payables, Account Receivables, BOM, QP), Oracle 10g, XML Publisher, Reports, Forms, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, PL/SQL, UNIX.

Confidential, Atlanta, GA

OAF Consultant

Responsibilities:

• Designed, documented Functional Specification (MD050) and Technical Specification (MD070) documents.
• Created new contractor custom region in Contractor Requisition to capture custom details in iProcurement using Oracle Applications Framework (OAF).
• Extended EO and created association to link custom EO in iProcurement using Oracle Applications Framework (OAF).
• Extended Application Module to build business logic in iProcurement using Oracle Applications Framework (OAF).
• Build Entity export and helper classes to have business validation in iProcurement using Oracle Applications Framework (OAF).
• Used PPR technics to build and behave custom region according to business requirements in iProcurement using Oracle Applications Framework (OAF).
• Developed multiple CO and extended CO to build custom login in Contractor Requisition process in iProcurement using Oracle Applications Framework (OAF).
• Done VO extensions to have custom business login in Contractor Requisition process in iProcurement using Oracle Applications Framework (OAF).
• Design and developed INT103 interface to import new and updated records from Oracle EBS for employees and SOW contractors to clarity system.
• Developed Error handling mechanism for data extraction and upload in Labor Resource Information interface.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables.
• Design and development of AP suppliers, AP invoices conversion programs using AP suppliers open interface and AP invoices open interface.
• Scheduled Payment Process and created Electronic payments using Payments Manager in Account Payables (AP).
• Extended PO Requisition account generator workflow to create charge account custom process according to business requirements.
• Worked on Oracle Approvals Management Engine (AME) for Requisition approvals - updated the Attributes, Conditions and Approval groups based on the business requirements.
• Developed MACYS Blu Invoice Report using XML/BI Publisher.
• Designed and Developed MACYS AP SUA Rebate Allocation using XML/BI Publisher.
• Designed and Developed MLO Expiring Contracts Report, MLO Contracts Status Report using XML/BI Publisher.
• Responsible for solving production problems and providing permanent solutions.

Environment: Oracle Applications R12 (Order Management, Inventory, Purchasing, Accounts Payables, Account Receivables, iProcurment), Oracle 10g, OAF(Oracle JDeveloper), XML Publisher, Reports 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, PL/SQL, UNIX.

Confidential, Summit, NJ

OAF Developer

Responsibilities:

• Provide programming, Technical and Functional assistance to team members for issues/queries related to object developed for the client.
• Interact with clients and users to understand requirements and to validate design specifications changes in upgrade instance.
• Analyzed and retrofitted OAF code, Workflow Changes and PLSQL code changes due to an upgrade from Oracle 12.1.3 to Oracle 12.2.4.
• Analyzed and fixed customizations in MES that is based on OAF.
• Modified technical and installation instruction document changes due to an upgrade from Oracle 12.1.3 to Oracle 12.2.4.
• Support offshore Oracle development team and provide assistance with code migration changes in Oracle 12.2.4.
• Design and customized oracle MES e-Signature page, to complex setfocus functionality on particular UserID MessageTextInput field in advanced table.
• Analyzed and retrofitted extended Oracle application Framework View objects (VO's), controllers (CO's) and Application modules (AM's) in Manufacturing Execution Systems (MES) and iProcurement Modules.
• Retrofitted Mobile Supply Chain Application (MSCA) Customizations in Oracle 12.2.4 Instance.
• Customized .java files to add new submit button, MessageTextInput filed and disable fields in Mobile Supply Chain Application (MSCA).
• Customized Kiosk Instance Instruction Page to Added “override” feature with e-sign. i.e. Users can edit the Quantity value only by clicking the “Override” button
• Created new OAF Override page in MES, In the new page, user should be able to see process variable, instruction details and available to enter new Quantity value with number validation.
• Customized instance instruction controller to add wrap functionality to MessageTextInput field in MES.
• Retrofitted Personalized oracle iProcurement shopping cart, Review and submit page due to an upgrade from Oracle 12.1.3 to Oracle 12.2.4.
• Retrofitted Customized Purchasing and Requisition Workflows in upgrade Oracle 12.2.4.
• Supported Steady state enhancement production support team.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.

Environment: Oracle Applications R12.1.3 and R12.2.4 - (MES, PO, OM, iProcurement and MSCA), Oracle 10g, Workflow Builder 2.6.3.5, OA Framework, XML/BI Publisher, Reports 10g, Forms 10g and SQL Developer.

Confidential, Tacoma, WA

Oracle Techno Functional

Responsibilities:

• Support Oracle Deployment and provide assistance with critical functions performed by the Deployment Control Teams.
• Interact with clients and users to understand requirements and to validate design specifications
• Involved in Key flex fields, Calendars, currencies and set of books set ups in purchasing.
• Performed system-wide setup tasks such as configuring concurrent managers and printers.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes.
• Designed Order Management queries to Count Orders by Order Types, Order Source.
• Coding SQL queries to extract data from Oracle application tables and converting data into flat files using UTL FILE.
• Modified Setups in Order Management (defining transaction types, defaulting rules) and Inventory to accommodate the To-Be processes.
• Developed custom interface program to load inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Created PL/SQL package to consolidate multiple invoices (orders) to print on a single invoice based on the PO number in order to mimic the original customer PO.
• Configured alerts for Procurement to alert Planner if a purchase order is not received by the requested date.
• Developed Price List Conversion Program for business applications to load Price List header, lines and attribute details by creating staging tables and performing validations by writing PL-SQL package into theQP Open interface tablesand then toQPbase tables
• Imported Service Contracts data from Legacy system to Oracle throughOKS APIs. This process includes loading data from flat file to temporary table using theSQL * Loader, validated the temporary table data and moved to the Base tables.
• Expertise in OA Framework Extensions and new builds.
• Design and develop TAG reports like Confidential Final Assembly Label report, TAG3 Print Glass Label report, TAG1 FAB(DFT) Corner Cleaner report etc.,
• Responsible for design, develop and Support WINIG Interface.
• Review, repair and modify software programs/Code to ensure technical accuracy and reliability of programs.
• Provide support for bug fixing and any further enhancements
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.

Environment: Oracle Applications R12 - (INV, OM, WIP, BOM, ASCP, CM), Oracle 10g, Workflow Builder 2.6.3.5, OA Framework, XML/BI Publisher, Reports 10g, Discoverer 10g, Forms 10g and SQL Developer and TOAD.

Confidential, Mount Prospect, IL

Oracle Apps Techno Functional

Responsibilities:

• Designed, documented Functional Specification (MD050) and Technical Specification (MD070) documents.
• Worked on Order import using Order Management OE ORDER PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
• Was involved in Set ups of Order Management and Pricelists for different Order Cycles, Order Types, RMA types with various classes.
• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into OM Interface tables.
• Developed PL/SQL procedure to load all legacy system Items into Oracle Inventory with Open Item interface. Import and validation were performed using PL/SQL package.
• Developed PL/SQL Packages to validate data for BOM Interface to import BOM into Oracle base tables from the legacy system.
• Developed interface to populate WIP move interface tables and to submit concurrent request to perform WIP move transaction.
• Extended the Messages window in the Oracle Application Object Library(AOL) to edit iReceivables messages according to the business requirements.
• Involved in Oracle Quality Management System (QMS) the complete end to end Audit process including: Audit Planning, Audit Execution, Audit Reporting and Audit Follow-up.
• Created FPGEC Enter and Update a new application, Enter post- exam, exam cancellation Pages using Oracle Applications Framework (OAF).
• Generate and print FPGEC Certificates pages in FPGEC using Oracle Applications Framework (OAF).
• Developed OAF Pages that calls PLSQL packages using OracleCallableStatement.
• Customized Colour of the items using CSS class in Oracle Applications Framework (OAF).
• Extended and personalized the OAF pages to Created Backorder requisitions using OAF and Workflow.
• Extended and personalized existing AP HOLD Notification Viewmoredetails Page Using Oracle Applications Framework (OAF).
• Created new page to display the Address details of the delivery to location of the Requisitions Using Oracle Applications Framework (OAF).
• Extended View Object (VO) and Controller Object (CO) of the Select Source Page Using Oracle Applications Framework (OAF).
• Created New Contract Request page and Contract Request search form which contains all basic searches and Advance searches, Notes and Attachments Using Oracle Applications Framework (OAF).
• Developed OAF Pages that employs the concept of SPEL for implementing the PPR (Partial Page Rendering) using JDeveloper.
• Migrated OAF Page Personalization’s and Customizations from development to production instance.
• Developed custom invoice workflow process using oracle workflow builder. This includes the notification and custom work list approval processes.
• Developed Oracle Workflow with I-Expenses to automatically route expense reports for approval, and enforce reimbursement policies.
• Developed custom workflow for sending oracle workflow notifications.
• Developed and fixed the issues of INV Shipping Manifest Report using Report 10g and XML/BI Publisher.
• Developed and fixed the issues of INV Pipe Manifest Report using Report 10g and XML/BI Publisher.
• Responsible for developing various views and PL/SQL scripts for Discoverer Reports.
• Created ID card, Address Label and Certificate reports using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report by using XML/BI Publisher.
• Responsible for solving production problems and providing permanent solutions.

Environment: Oracle Applications R12 (Order Management, Inventory, Purchasing, Accounts Payables, Account Receivables, Oracle Quality Management, BOM, WIP), Oracle 10g, OAF(Oracle JDeveloper), XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, PL/SQL, UNIX.

Confidential, Atlanta

Oracle Techno Functional (Team Lead)

Responsibilities:

• Designed, documented Functional Specification (MD050) and Technical Specification (MD070) documents.
• Provide programming, Technical and Functional assistance to team members for issues/queries related to object developed for the client
• Read and review design document of requirements for project needs for business progression.
• Interact with clients and users to understand requirements and to validate design specifications.
• Worked on the Order Import Open Interface and developed a custom interface which will send PO information to an external system.
• Implemented Order Discount Hold system and developed reports for holds placed and released.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked on Loading bank statements, reconciling bank statements and posting to General Ledger in Cash management module
• Responsible for cash reconciliation in Cash Management.
• Created Confidential Invoice List Page which contains the list of Category Names, Count of Invoices and Confidential Invoice Details Page which contains list of invoices, view, comments and edit buttons Using Oracle Applications Framework (OAF).
• Created Confidential Invoice entry Page which contains Invoice Header, Distributions and Comments sections buttons Using Oracle Applications Framework (OAF).
• Created Confidential Invoice Search and Advanced Search Pages which contains all basic searches and Advance searches, Notes and Attachments in Oracle Applications Framework (OAF).
• Personalized Supplier Quick Update page in Payables using Oracle Applications Framework (OAF).
• Personalized Supplier Address Book to add message styled text and message text input Items in using Oracle Applications Framework (OAF).
• Developed OAF pages that employ DML operations insert, update, delete, SPEL Simplest Possible Extension Language, PPR Partial Page Rendering and Independent and Dependent LOV’s.
• Developed custom invoice workflow process using oracle workflow builder. This includes the notification and custom work list approval processes.
• Customized the standard Workflow to meet the business requirement.
• Developed custom Workflow using Oracle workflow Builder to notify Approvers about the payment requests submitted.
• Generated Order submission summary and Detail reports and Order submission summary by email Report using XML/BI Publisher.
• Involved in developing new reports and customizing standard Oracle reports using Discoverer 10g, Reports 10g and XML/BI Publisher.
• Created Materialized views in an external system on Purchase order data, Requisition data and Vendor data in Oracle Payables.
• Modified the Print Statements report and Invoice report as per the formats/layout of the client using Reports 10g.
• Replicated the Manual Process of PO Shipment Allocations to Invoice Lines using PL/SQL Code.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Fixed many Production Issues and also modified existing objects to in corporate the new enhancements.

Environment: Oracle Applications R12 (Accounts Payables, Account Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Advanced Pricing, BOM, WIP, Cash Management, System Administrator), Oracle 10g, OAF(Oracle JDeveloper), XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, PL/SQL, UNIX.

Confidential, NY

Oracle Apps Consultant

Responsibilities:

• Analyzed legacy system and prepared Functional (MD050), Technical (MD070), Conversion Mapping (CV040) documents.
• Developed / Extended / Personalized / Deployed Apps Pages using Oracle Application Framework (OAF).
• Migrated OAF Page Personalization’s and Customizations from development to production instance.
• Implemented VO and CO Extensions in OAF Pages using JDeveloper.
• Implemented the concept of Train with 5 OAF Pages with navigation bar.
• Extended View Object (VO) and Controller Object (CO) of the Select Source Page Using Oracle Applications Framework (OAF) in iProcurement.
• Personalized in Hiding/Displaying/Disabling/Re-ordering Attributes on iSupplier pages using Oracle Applications Framework (OAF).
• Extended iProcurement Shopping Cart Page to added available quantity and Backorder flag fields using Oracle Applications Framework (OAF).
• Personalized iProcurement Review and Submit Page using Oracle Applications Framework (OAF).
• Created new page to display the Address details of the delivery to location of the Requisitions Using Oracle Applications Framework (OAF).
• Extended the View Objects and personalized the Requisition page and Requisition details page to display Only Approved PO numbers to the Requisition Using Oracle Applications Framework (OAF).
• Extended and personalized the iProcurement pages to Created Backorder requisitions using OAF and Workflow.
• Extended and personalized existing AP HOLD Notification Viewmoredetails Page Using Oracle Applications Framework (OAF).
• Extended iExpense Approver LOV View Object Using Oracle Applications Framework (OAF).
• Created New Contract Request page and Contract Request search form which contains all basic searches and Advance searches, Notes and Attachments in iProc Using Oracle Applications Framework (OAF).
• Extended P-Card holders and approvers Workflow to Remove ‘More Information’ and ‘Reassign’ buttons.
• Customized the AP Invoice Hold Notification Workflow, The objective of this customized workflow is to send notification to appropriate stakeholder(s) after a specific hold is placed on AP invoice.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Imported Requisition Details (Requisition Import) using SQL * Loader and PL/SQL. Wrote programs to insert update and validate values into the PO REQUISITIONS INTERFACE ALL and PO REQ DIST INTERRFACE ALL table for each requisition line.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Developed an Outbound interface program to transfer the data from oracle PO base tables into the flat file.
• Routed the PO Requisitions for approval using Approval Management Engine (AME).
• Worked with Cash Management Bank Reconciliation, Cash Forecasting and Cash positioning with Bank wise details reports.
• Developed RTF Template using XML/BI Publisher to develop Invoice Report.
• Developed and fixed the issues of INV Shipping Manifest Report using Report 10g and XML/BI Publisher.
• Developed and fixed the issues of INV Pipe Manifest Report using Report 10g and XML/BI Publisher.
• Customized the standard AP Check Print Report in Account Payables using XML/BI publisher.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Reports 10g.
• Worked extensively with Application Object Library (AOL) by registering OAF forms, reports, creating value sets, lookups, key flex fields, descriptive flex fields.
• Facilitate Integration testing and User Acceptance testing for each module of redesign.
• Preparing Technical Designs, Test Plan and Installation Guide documents.
• Provide programming, Technical and Functional assistance to team members for issues/queries related to object developed for the client.

Environment: Oracle Applications R12 (General Ledger, Accounts Payables, Account Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Cash Management, iSupplier, iProcurement, iExpense), Oracle 10g, OAF(Oracle JDeveloper), PANAYA Tool, XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, PL/SQL, UNIX.

Confidential, Tampa, FL

Oracle Apps Consultant

Responsibilities:

• Designed, documented Functional Specification (MD050) and Technical Specification (MD070) documents.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable (AR) by using Customer Interface.
• Design and development of AP suppliers, AP invoices conversion programs using AP suppliers open interface and AP invoices open interface.
• Defined Auto-Lockbox and Transmission Format and ran standard Lockbox program to transfer receipts into Oracle Receivables.
• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program (AP) and populated the base tables.
• DevelopedOA FrameworkPage to view rejected and cancelled Invoices fromAccount Payables.
• Unit Testing of allOA FrameworkPages
• Extended and personalized the functionalities of existing pages usingOA Framework.
• Extended View Object (VO) and Controller Object (CO) of the iSupplier pages Using Oracle Applications Framework (OAF).
• Extended View Objects for displaying more columns in iSupplier using Oracle Applications Framework (OAF).
• Involved in developing new reports and customizing standard Oracle reports using Discoverer 10g, Reports 10g and XML/BI Publisher.
• Created Materialized views in an external system on Purchase order data, Requisition data and Vendor data in Oracle Payables.
• Utilized FND REQUEST API to submit concurrent Program from Oracle Report after Report Trigger.
• Involved in Creating and registering Concurrent programs, Executables, SQL* loader scripts, Functions, Procedures, Reports using system administration responsibility.
• Conversion of Oracle Reports to XML/BI Publisher Reports like AP Check Printing Report and AR Invoice Report.
• Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Designed and developed Forms using Forms 10g as per the business requirements, provided Zoom functionality using CUSTOM.pll.
• Customized the Order Header level Workflow, which will send a notification based on the data mismatch between order header level and order line level.
• Customized the Work Flow for Credit Memo Request approval in AR through Workflow Builder.
• Customized the Journal Line Report in Oracle General Ledger and Invoice Aging Report in Oracle Payables.
• Modified the Print Statements report and Invoice report as per the formats/layout of the client using Reports 10g.
• Designed and developed ad-hoc Oracle Discoverer workbooks and reports and also trained the End Users.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.
• Involved in registration of concurrent programs, executables, creation of Responsibilities, request groups, menus, value sets, request Sets, Forms, functions in System Administration & AOL.
• Interacted with the end users to gather desired requirements, analyzed the requirements, and finally, developed and implemented various PL/SQL and Oracle Application routines to fulfill those requirements.

Environment: Oracle Applications R12 (General Ledger, Accounts Payables, Account Receivables, Fixed Assets, Projects Accounting, Costing, Billing), Oracle 10g, OAF(Oracle JDeveloper), XML Publisher, Discoverer 10g, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL*Plus, SQL*Loader, TOAD, PL/SQL, UNIX.

Confidential, Columbus, OH

Oracle Apps Consultant

Responsibilities:

• Developed SQL*loader script and PL/SQL script to load and validate Customers data into Oracle Receivables
• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files into OE HEADERS IFACE ALL AND OE LINES IFACE ALL.
• Developed PL/SQL programs using Toad, temporary tables, views as part of OAF customization and development.
• Registered new forms and also different concurrent programs for reports, PL/SQL packages, SQL loader Programs
• Customized Standard Oracle Applications forms in Order Entry by implementing logic in CUSTOM.pll
• Registered newly created forms with Oracle
• Involved in customizing the forms for adding extra information through DFF’s.
• Developed custom workflow for sending oracle workflow notifications.
• Generated Order submission summary and Detail reports and Order submission summary by email Report using XML/BI Publisher.
• Revised Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with onsite functional team to build technical extensions
• Developed Order Management, Inventory, Receivables, Shipping, and Warehouse Management, Pricing queries to compare summary information of the standard and custom reports using Reports 6i.
• Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared the workbooks with the designated users only.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.

Environment: Oracle Applications R12/11i (11.5.10) (Order Management, Inventory, Purchasing, General Ledger, Accounts Payables, Account Receivables), OAF(Oracle JDeveloper), Oracle 10g, OBIEE 10.1.3.4.0 , XML Publisher, Discoverer 10g, Reports 6i, forms 6i, Workflow Builder 2.6.1, Windows 2000/NT, SQL*Plus, SQL*Loader, TOAD, PL/SQL, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.
• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
• Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables. Created user defined Exceptions while handling exceptions.
• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment: Oracle 8i, Reports 4i, Discoverer 4i, SQL * PLUS, SQL * Loader.