SUMMARY

• Over 8 years of experience as an Oracle PL/SQL Developer with strong ORACLE PL/SQL, ORACLE Forms & Reports and also expertise in 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) Manufacturing modules (Order Management OM, Purchasing PO, Inventory INV)& Federal Financials.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Extensive experience in Order to Cash (O2C) andProcure to Pay(P2P) cycles.
• Involved in upgrading teh system from oracle applications 11i to applications R12.
• Experience in Oracle Application Framework (OAF) applications,customization ofOAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in teh 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 teh client's requirements.
• 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.
• 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 teh Explain Plan, TkProf and SQL Tracing.
• Exposure to UNIX shells scripting.
• Good working knowledge in designing technical documents using AIMMethodologies (MD50, MD70, CV40 AND CV70).
• Experience working as a mentor and also part of a team, ability to articulate and communicate ideas, problems/ solutions and user training. Managing Offshore-Onsite Coordination and performing Tech Lead role.
• 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, 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, Oracle Business Intelligence Enterprise Edition 10.x,OAFramework, Jdeveloper 9i/10g.

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

Languages: SQL, PL/SQL, XML

Web Technologies: HTML, XML

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

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

PROFESSIONAL EXPERIENCE

Confidential, Baltimore MD

Oracle EBS Developer

Responsibilities:

• Involved to design and customize AP/AR netting process to relate NPI Suppliers and Customers.
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL.
• Worked on CUSTOM.PLL extensively to customize teh functionality provided by standard forms as per client requirements.
• Remediated RICEL components with teh halp of Panaya Tool as part of Initial Upgrade process.
• Incorporated SLA in custom report in order to replace PSA tables as part of upgrade process.
• Verified all Federal Financial modules after teh Oracle Critical Patch is applied to make sure it’s working as expected.
• Developed AR Treasury Reports by using SLA, to send Transactions due information to Department of Treasury's Financial Management Service (FMS).
• Developed GL Journal BI Publisher report to display Sub-ledger details by using XLA and Data access sets Functionality.
• Built custom forms using Oracle Forms 10g Builder to fulfill teh business requirements of teh client.
• Customized existing forms to add search criteria on descriptive flex fields.
• Developed forms using ZOOM functionality dat pops up appropriate form based on teh item context.
• Built custom forms using TEMPLATE.FMB to fulfill teh business requirements like implementing teh calendar feature, WHO columns, defining DFFs etc.
• Worked with performance tuning using Explain Plan and TKPROF to improve teh performance of various custom PL/SQL Packages, Procedures and Reports.
• Involved working with teh testing team to write Test Cases and System Testing scripts.
• Worked on defects resolution for SIT.
• Prepared BR 100 documents regarding setup changes and performing teh configuration changes in several development, test and production instances.
• Prepared MD70, MD120 using AIM Methodology.

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

Confidential, Cleveland OH

Oracle EBS Developer

Responsibilities:

• Worked with Invoices such as Credit Memo, Debit Memo, Expense Invoice, Recurring Invoice, Pre-Payments and Interest Invoice in Accounts Payables Module (AP).
• Development of stored procedure dat extracts data from AR, AP and PO modules or reconciliation according to business requirement.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on teh staging table data.
• Designed and developed PO requisition interface to load PO requisitions from teh 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 teh Item Import, Item Assignment and used teh Standard Interface Program to import.
• Developed new programs to integrate teh 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 Invoice Validation Report and Discounts Available Report in Account Payables (AP) using Report 10g.
• 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.
• Working with teh users and fixing teh 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 teh post clone tasks.
• Involved in Requirement Analysis, Design and Develop custom applications inOAF. dis involves analyzingMD50(Functional Spec) and then writingMD70(Technical Spec).
• Responsible for Fixing Performance issues using teh Explain Plan, TK PROF, SQL Analyzer and SQLT.
• Developed UNIX Shell scripts to run teh interface program and to archive teh data.

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

Confidential, Portland, OR

PLSQL Developer

Responsibilities:

• Oracle Applications Upgrade - 11i to R12
• Partner with Oracle support team, business team, and other vendor parties to identify and remedy key issues introduced by upgrade.
• Test integrity of customizations to ensure no overrides due to R12 upgrade.
• Developed Packages for teh customized functionality for R12 release.
• Developed a Conversion program for creating Customer Accounts, Customer Sites, Site Uses, Profiles and Profile amount based on TCA architecture.
• Responsible for Accounts Receivable Technical Support, which includes any day-to-day technical problems such as Invoicing, Customer Interface. Also involved in teh technical tasks such as customizing/trouble shooting teh existing Reports or Interface Programs.
• 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 teh legacy system into teh Oracle Payables Base Tables.
• Performed teh whole Order to Cash Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Loaded Legacy Journals data into GL INTERFACE table using SQL*LOADER and run Journal Import in to GL tables and Integrated in oracle Applications.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• 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 dat will provide detailed contact information about Vendors/Suppliersfor 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 teh Report in OAF. Worked on objects of OAF extension based on teh small changes required by teh client.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Customized Purchase Order (PO) Form using Custom.pll for comparing teh unit price entered with teh component prices entered in teh descriptive flex fields.
• Migrate teh existing reports from Discoverer 4i to Discoverer 11g.
• 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, Houston, TX

PL SQL Developer

Responsibilities:

• Involved in design of Conversion/Interface Implementation Strategy for Accounts Payables and Accounts Receivables.
• Developed PL/SQL scripts to load Invoice data in XML Format from external system to AP interface tables.
• Developed PL/SQL scripts to load Vendor data in CSV Format from external system to AP interface tables.
• Involved in Importing teh Orders 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
• Developed teh validation program to validate data dat is inserted into Invoice Interface Tables before running teh Standard Payables Import Program.
• Involved in Item Conversion to import items, and its attributes from legacy system into oracle applications.
• Developed PO Outbound Program Full and Incremental Refresh and scheduled to run daily to send PO Data to teh Third Party System to Match against teh Invoices.
• Involved in Customer Conversion for creating Customers, and relationships into Oracle Applications using API like HZ PARTY V2PUB, HZ RELATIONSHIP V2PUB, HZ CUSTOMER PROFILE V2PUB, HZ CLASSIFICATION V2PUB, HZ LOCATION V2PUB, and HZ CUST ACCOUNT V2PUB.
• Defined Customer, Payment Terms, Transaction Type, Receipt Class, Sales Representative, Collector. Entered Invoices (Invoice, Credit Memo, Receipt, Deposit, Guarantee, Charge back), Imported Invoice information using Auto Invoice.
• Develop a Program for teh Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables.
• Customized teh Pick and Ship Delivery Option Using Forms Personalization.
• Developed some of teh Oracle standard reports like AP Invoice on Hold Report, AP Payment Register Report to Discoverer 10g.
• Customized existing standard PrintedPO Document, AP Checks, and AP Overflow Checks Reports using XML Publisher and created multi-layout reports to hide/show columns based on teh profile options of teh user.
• Implemented print logic for teh AP Checks Report using XML Publisher to print output to teh assigned printer each time teh report is ran.
• Customized teh AR Invoice Report and Developed new reports for debit memos and credit memos in Account Receivables by using XML Publisher.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.
• Involved in teh tuning of 11i applications (includes PL/SQL, SQL scripts) using Explain Plan and TKProf.
• Wrote Shell Script to copy teh Concurrent Request Output of teh Concurrent Program by teh Parent Request ID and FTP them over to teh Third Party System.
• Developed UNIX Shell Script Program to send report output through email.

Environment: Oracle Apps R12, Oracle 10g, XML Publisher, Discoverer 10g, UNIX, PLSQL, SQL Plus, TOAD.

Confidential, San Jose, CA

Oracle EBS Developer

Responsibilities:

• Performed teh whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Imported teh Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created teh Journal Entry's in General Ledger (GL) using Journal import.
• Developed item interface in inventory (INV) to import teh item information from teh 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 APIsfor updating base tables when shipping is done by third party shipping.
• Imported teh data from legacy systems into teh temporary tables in Account Receivables (AR).
• Designed and developed teh Account Receivables (AR) extension called Balance Forward Billing process for preferred customers wishing consolidated bills at site level based on teh predefined payment terms on teh 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 teh On-Hand Quantity.
• Designed and developed teh custom program to create teh customers and to update their personnel information by using TCA Architecture.
• Implemented Trading Community Architecture (TCA) to support complex trading communities and relationships within a trading community using PL/SQL.
• 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 teh unit price entered with teh component prices entered in teh descriptive flex fields.
• Developed forms using ZOOM functionality dat pops up appropriate form based on teh item context.
• Built custom forms using TEMPLATE.FMB to fulfill teh business requirements like implementing teh calendar feature, WHO columns, defining DFFs etc.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve teh 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 EBS Developer

Responsibilities:

• Involved in complete Procure to Pay (P2P) and Order to Cash (O2C) life cycle.
• Created loader file, porting invoices into teh interface tables using SQL*Loader and then using Payables Open Interface to import teh data into teh actual tables, designing and development of custom interfaces on teh 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 teh STANDARD Purchase order transactions into teh 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.
• Customized standard Invoice Print report as per client’s requirement to view teh output in pdf format using XML publisher(AR).
• 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 teh efficiency of teh SQL statements when application runs & used tools with EXPLAIN PLAN.
• Excellent analytical skills in Analysis and business requirements gathering from end users to teh 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

PLSQL 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 teh 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 teh Excel sheets to teh 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.