SUMMARY:

• Over 7 years of experience as an Oracle Applications R12/11i (E Business Suite) Technical consultant, with expertise in Oracle Financials modules (General Ledger GL, Account Payables AP, Account Receivables AR, Fixed Assets FA, CM, SLA) Manufacturing modules ( Order Management OM, Purchasing PO, Inventory INV, Shipping WSH) & Federal Financials FV.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Extensive experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Involved in upgrading the system from oracle applications 11i to applications R12.
• Experience in Oracle Application Framework (OAF) applications , customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment .
• Developed custom forms in various modules using Oracle Applications Framework (OAF).
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Experience in Application System Administration activities like managing concurrent managers, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Developed Interface/Conversion (inbound and outbound) Programs using Open Interfaces and API's . Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client's requirements.
• Worked on EDI transactions (837, 835 & 810).
• Experience in design, analysis, development, testing and implementation of applications in Oracle E - Business Suite R12/11i, Oracle 11g/10g/9i/8i, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Oracle Discoverer 11g/10g/6i/4i, XML Publisher 5.6.3/5.6.2 , Work Flow Builder 2.6, OAFramework.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Experience in SQL* Loader, Oracle API’s and UTL FILE Packages for data conversion and interfaces.
• Excellent programming skills in stored procedures and Oracle (PL/SQL including Triggers and Functions) and expertise in database Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan, TkProf and SQL Tracing .
• Exposure to UNIX shells scripting.
• Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Developed and oversaw scoping and testing strategy and reporting on both financial and technology SOX compliance projects.
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.

TECHNICAL SKILLS:

ERP: Oracle Applications R12/11i, Order Management (OM), Purchasing (PO), Inventory (INV), General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Advance Pricing, Costing, Shipping(WSH),IBY, AOL, System Administration and TCA.

Application Tools: Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/6i/10g/11g, XML Publisher 5.6.2/5.6.3 , Work Flow Builder 2.6, OA Framework, Jdeveloper 9i/10g, Autosys.

Database Tools: TOAD, SQL* Loader, SQL* Plus, SQL* Developer

Languages: SQL, PL/SQL, XML

Web Technologies: HTML, XML

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

Operating System: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Co-ordinated project upgrade of R12.1.3 from 11.5.10
• Worked on various interface issues between various financial modules.
• Differences between R12 and 11i instances have brought up various issues with the upgrade. Worked grouping various issues and assigned to various teams and achieved more timely and economical solutions.
• Resolved issues in the upgrade process example designed checks format for local and International translations.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Oracle PL/SQL as part of customer MDM project.
• Worked on developing Customer Account update, Customer Profile updates Conversion in AR.
• Developed Conversion Programs to import Customers into Oracle Order Management using TCA API’S.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Designed and Developed and to send Outbound Interface the Order details for a given customer.
• Implemented Lockbox Interface: Used SQL*Loader to import receipt data into Interface table in Accounts Receivable after defining Lockbox and Transmission Format, and used Lockbox interface form to transfer data into Oracle Receivables.
• Worked on OAF Personalization's and form Personalization's.
• Developed and customized reports like Aging report, Inactive Item Report, Cancelled Sales Order Report Min-Max Planning report and cancelled purchase orders using Oracle Reports 10g.
• Created a Report for End Users to get the vendor and its site information.
• Configured the End User Layer (EUL) with the necessary grants & database privileges, created ad-hoc queries, granted scripts & report access from Discoverer Administrator.
• Designed and developed various interfaces and integrations such as Customer Master Data synchronization with Oracle AP/PO, Sales-force integrations with Oracle Quotes and OM with Oracle ERP.
• Customized existing custom Oracle reports to replace plain text output to PDF format using XML Publisher. Worked on XML Publisher bursting to send PDF reports via email.
• Responsible for customizing Workflow for orders by adding custom Holds for certain customers and added payment terms for the customers.
• Customization of AR Invoice Approval workflow.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle E-Business Suite R12, UNIX, Reports 10g, Forms 10g, SQL*Loader, TOAD, OAFramework.

Confidential, Baltimore, MD

Oracle Apps Techno-Functional consultant

Responsibilities:

• Analysis for the type of technical changes required for upgrading from 11i to R12.2, like table name changes, code changes etc. related to existing custom reports and interfaces.
• Participated in R12 upgrade project( HIGLAS ) - upgrading from 11.5.10.2 to R 12.2
• Analyzed the new features in Release 12, performed impact assessment and set up the Environment with a view to upgrading to R12.
• Worked on the customization of customer OAF page to replicate the changes that in 11i.
• Developed custom OA Framework pages using OAF components like: LOV, Show/Hide Region, Advanced Table, and Simple Search Region.
• Developed custom business logic in BC4J components like View Objects (VO), View Links (VL), Entity Objects (EO) and Application modules (AM) using Jdeveloper.
• Developed Supplier conversion for loading the vendor information from Legacy System (BAAN ERP System) to Oracle ERP system.
• Developed an interface program to import the invoices by the Payables Open Interface import and match them with the PO.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Developed new programs to integrate the data from Oracle to BO system to generate reports for business users.
• Worked on CUSTOM.PLL extensively to customize the functionality provided by standard forms as per client requirements.
• Remediated RICEL components with the help of Panaya Tool as part of Initial Upgrade process.
• Worked on the HCRs (HIGLAS Change Request) involving several SDLC tasks including requirements gathering, review meetings, business rules and scenarios, functional design, development, configuration, testing and .
• Prepared Code Migration Scripts to move upgraded/Developed objects from one instance to other instances.
• Worked with performance tuning using Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages, Procedures and Reports.
• Developed and oversaw scoping and testing strategy and reporting on both financial and technology SOX compliance projects globally.
• Involved working with the testing team to write Test Cases and System Testing scripts.
• Prepared BR 100 documents regarding setup changes and performing the configuration changes in several development, test and production instances.
• Prepared MD70, MD120 using AIM Methodology.
• Developed UNIX Shell scripts to run the interface program and to archive the data.

Environment: Oracle E-Business Suite R12, Unix, Reports 10g, Forms 10g, SQL*Loader, TOAD, OAFramework.

Confidential, Cleveland, OH

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in Procure to Pay (P2P) & Order to Cash ( O2C ) business flow.
• Debugged the custom interface between Project Accounting PA and Receivables AR .
• Customized page (OrgCreatePG.xml) to render and hide fields based on the ‘Show More Details’ button.
• Worked on validation of extended EO of Address region to include additional field’s values in the address region attributes.
• Worked on integrating the Contact region with the existing Customer Create page which has only Organization and Address Region.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• View Object extension for several OAF pages to display a new custom attribute column in the LOV
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into oracle purchasing (PO) using SQL*Loader and PL/SQL validations
• Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.
• Designed and Developed the Item Import, Item Assignment and used the Standard Interface Program to import.
• Developed new programs to integrate the data from Oracle to BO system to generate reports for business users.
• Customized existing standard PO Exception Report, Requisition without Purchase Order Report in Purchasing.
• Customized Collection Aging Report, Material Adjustment Report, and Inventory Item Cost across Inventory orgs, slow moving inventory report and On-hand Details Report using Discoverer 11g.
• Customized Journal Entries Report and Billing History Report in Account Receivables using XML/BI Publisher.
• Customized the Printed Purchase order report in Purchasing (PO) to meet the client’s requirements using Report 10g.
• Working with the users and fixing the issues related to SIT testing.
• Performed System Administrator functions such as defining Users, functions, responsibilities, concurrent programs, flex fields, Value Sets, Profile Options, registering forms in AOL and also the post clone tasks.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Responsible for Fixing Performance issues using the Explain Plan, TK PROF, SQL Analyzer and SQLT.
• Developed UNIX Shell scripts to run the interface program and to archive the data.

Environment: Oracle E-Business Suite R12, Unix, Reports 10g, Forms 10g, Discoverer 11g, SQL*Loader, TOAD, OAFramework.

Confidential, Portland, OR

Oracle Apps Technical Lead

Responsibilities:

• Responsible for Accounts Receivable Technical Support, which includes any day-to-day technical problems such as Invoicing, Customer Interface. Also involved in the technical tasks such as customizing/trouble shooting the existing Reports or Interface Programs.
• Develop OAF pages of Bill of Material and Crushing.
• Developed the Insert, Update, and Delete OAF Screen using JDeveloper 10g.
• Working on OAF, Jdeveloper 10g and customizing forms, Report 6i and managing the custom interfaces and integration between the Financial, Project Accounting and legacy systems.
• Worked on OAF Personalization and Form Personalization.
• Developed new OAF pages through Jdeveloper.
• Worked Extension of VO and CO.
• Worked on developing Customer Account update, Customer Profile updates Conversion in AR.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Worked on Technical Document and development of Sales Contract Conversion.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables AR, Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Report Builder.
• Developed Receivable label report which included barcode designing in it using XML/BI Publisher.
• Developed Project Actual to Budget Detail Report for PA using XML/BI Publisher.
• Order Details screen - Created an Order detail report in XML Publisher and integrated the Report in OAF. Worked on objects of OAF extension based on the small changes required by the client.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.
• Managing Offshore-Onsite Coordination and performing Tech Lead role.
• Involved in developing and Review of AIM (MD050, MD 070) documents for (AP, GL, OM, PO and AR) module implementation/development.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.

Environment: Oracle E-Business Suite R12/11i (AP, AR, GL, PA, OM, PO, INV,WIP), XML/BI Publisher, Reports 10g, Discoverer 11g, Forms 10g/4.5, SQL*Loader, TOAD, OAFramework.

Confidential, San Jose, CA

Oracle Apps Technical consultant

Responsibilities:

• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Imported the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in General Ledger (GL) using Journal import.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Developed Sales Order conversion in Order Management (OM) to import Sales Orders from Legacy system using SQL * Loader.
• Worked on Shipping APIs for updating base tables when shipping is done by third party shipping.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Designed and developed the Account Receivables (AR) extension called Balance Forward Billing process for preferred customers wishing consolidated bills at site level based on the predefined payment terms on the Bill to Locations.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Worked on Inventory (INV) in defining a New Item in inventory and there increasing the On-Hand Quantity.
• Customized AR Aging reports in Accounts Receivables (AR) and Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed Credit Packing Slip Details Report and Open Item Details Report using XML/BI Publisher.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the calendar feature, WHO columns, defining DFFs etc.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various developed custom PL/SQL Packages.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.

Environment: Oracle 11i (General Ledger GL, Account Payables AP, Account Receivables AR, TCA, Inventory INV, Order Management OM), Oracle 11g, TOAD, PL/SQL, Forms 6i/10g, Reports 10g, XML/BI publisher 5.6.3, SQL*Loader, Shell Scripts.

Confidential, Hightstown, NJ

Oracle Apps Technical consultant

Responsibilities:

• Involved in complete Procure to Pay (P2P) and Order to Cash (O2C) life cycle.
• Created loader file, porting invoices into the interface tables using SQL*Loader and then using Payables Open Interface to import the data into the actual tables, designing and development of custom interfaces on the Oracle AR and Oracle AP.
• Worked with Invoices such as Credit Memo, Debit Memo, Expense Invoice, Recurring Invoice, Pre-Payments and Interest Invoice in Accounts Payables Module (AP).
• Developed Purchase order Interface to upload the STANDARD Purchase order transactions into the Oracle apps Base tables.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using XML/BI Publisher.
• Converted Supplier Payment History Report in Account Payables from Report 6i to BI Publisher.
• Developed Credit Packing Slip Details Report and Open Item Details Report using XML/BI Publisher.
• Customized various Standard reports like Purchase Order Summary, Purchase Orders Outstanding, Purchase Order Detail Report, Invoice Detail Report using XML publisher.
• Using SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents using AIM Methodology

Environment: Oracle Apps 11.5.10 Oracle 9i, Forms 6i, Reports 6i, Discoverer 4i, Work flow builder 2.6.

Confidential

Oracle Apps Developer

Responsibilities:

• Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Payables (AP), Inventory (INV), Receivables (AR) and General Ledger (GL).
• 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.
• Experience in importing PO Headers, PO Lines from legacy system to Oracle Purchasing through Purchase Order Open Interface (PO).
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventory modules.
• Extensive use of PL/SQL programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
• Developed several new forms using TEMPLATE.fmb & customized standard forms through Custom.pll.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL *Loader.
• Participated in performance tuning using Explain Plan and Tkprof

Environment: Oracle Apps 11.5.10 Oracle 9i, Forms 6i, Reports 6i, Discoverer 4i, Work flow builder 2.6.