SUMMARY

• Around 8 years of experience in Oracle Applications (E - Business Suite) R12/11i on Analysis, Design, Development, Testing, Implementation, Version upgrades, Data conversions and Customizations.
• Strong knowledge of development tools such as Oracle Developer (Forms 10g/9i/6i and Reports 10g/9i/6i), PL/SQL, Workflow Builder and BI/XML Publisher.
• Extensive experience in oracle application modules which include General ledger (GL), Project Accounting (PA), Accounts payable (AP), Accounts Receivables (AR), Vertex Tax, Purchasing (PO), iProcurement, Inventory (INV), Order Management (OM and Sys admin.
• Excellent knowledge of Multi-Org components.
• Involved in review and analyze current and future business process in order to develop project Oracle Projects RICE objects
• Good Knowledge on Development skills in developing RICEW Components in the domain of Oracle Applications E-Business Suite.
• Good Technical experience in Order to Cash (O2C), Procure to Pay (P2P) life cycles and Quote to Cash (Q2C).
• Developed/customized (personalized) Oracle Forms and reports using Form Builder, Custom.Pll, Discoverer and XML Publisher.
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), user training manuals, test procedures document preparation.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Knowledge in Oracle Application Framework (OAF) customizations.
• Good at development of Conversion, inbound and outbound interfaces Programs using PL/SQL, Interface tables and Oracle Standard API's.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Experience in debugging, UAT testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Well versed with client server environment and tools like TOAD, SQL*Loader and SQL* Navigator.
• Substantial development experience in creating stored Procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and Exception handling.
• Used Workflow to customize existing processes by adding new notifications.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions.
• Experience in SQL*Loader and Oracle APIs to load external data into Oracle database.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Expertise in database Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, rebuilding indexes, rebuilding indexes and also used the Explain Plan and SQL Tracing, TKPROF.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR's for several P1 issues.
• Ability to work hard as an individual and in a team to achieve desired results and ability to work under pressure in coordinating multiple tasks in the work environment.
• Excellent in quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business Suite (EBS) R12 / 11i

Oracle ERP Financials: Accounts Payables (AP), Account Receivables (AR), General Ledger (GL), Project Accounting (PA), Cash Management (CM) and Fixed Assets (FA).

Oracle ERP Manufacturing: Inventory (INV), Work in Process (WIP), Bill of Materials (BOM).

Oracle SCM: Order Entry/Order Management (OM), Oracle Purchasing (PO), Shipping (WSH)

Oracle Service: Trading Community Architecture (TCA)

Tools: Oracle Enterprise Manager, PUTTY, TOADSQL*PLUS, Win SCP, SQL Developer, File Zilla, Tortoise Subversion, Forms 10g/9i, Developer, Workflow Builder, BI/ XML Publisher, JIRA and Flex Deploy

Database: Oracle 11g/10g/9i.

Operating systems: Windows XP/NT/VISTA/2000/98 UNIX, Sun Solaris.

Languages: C, SQL, PL/SQL, HTML, Java, Shell Scripting, XML.

Office Tools: Microsoft Word, Excel, Outlook, Access

Document Methodologies: MD70, MD50, Unit Test Planning, Code Review Checklist

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

Oracle Technical Consultant

Responsibilities:

• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Worked on Order to Cash life cycle (O2C) implementation and integrating modules.
• Debugged the OE ORDER IMPORT MAIN PVT API to identify how a GL date is populated while creating a receipt.
• Developed PL/SQL package to move direct debit mandates from Customer DFF to Bank Account Uses DFF.
• Written Ad-hoc SQL Queries to list supplier information such as name and site details.
• Worked on workflow builder to customize seeded workflow messages for Order Management.
• Developed an Outbound Purchase Order Interface to send information to outbound system.
• Developed an Outbound Supplier information Interface to send information to outbound system.
• Customized the PO Approval workflow to show the distribution lines on the PO Approval notification.
• Customized PO Approval workflow to meet the following business needs.
• Decrease in Price will now require Manager Approval.
• Split Shipments where the overall quantity is not increased will not require Manger Approval; a buyer will be able to approve this change.
• Worked on LCM Pricing Attributes Extension
• Developed custom Daily Rates interface to identify and delete duplicate daily rates
• Developed Direct Debit Block outbound interface to identify and derive customers whose receipts are reversed due to non-sufficient funds.
• Developed new BI Publisher reports as per the client requirement, such as
• Internal Material Requisition Report
• Supplier VAT Invoice Confirmation Report
• Receivable VAT on Export Report
• Custom Reversed Receipt Report
• LCM Category Codes Report
• Received Lot older than the Current-Last Lot Report
• Unapplied and Unresolved Receipts Report.
• Customized/Modified existing reports as per client requirement, such as
• Open PO Report to include locally sourced inventory items by the external supplier
• Open Transactions in GL Account Report to in corporate additional information like ABO Number, Invoice GL Date, Order Date, Transaction Class, Functional Currency, Exchange Rate Details, CR and DR in Entered Currency details.
• AR Installments Report to in corporate additional invoice details, payments information including adjustments applied to the respective installments and to exclude intercompany invoices from report.
• Customizations to report like deriving dynamical from lookups and legal entity identifier, modifying the data template definition to change the default output type etc.

Environment: Oracle E-Business Suite (EBS) R12 (PO, INV, AP, AR, GL & OM) Oracle 11g, SQL, PL/SQL, Reports 10g

Confidential, Cleveland, OH

Oracle Technical Consultant

Responsibilities:

• Worked on Oracle E-Business Suite (EBS) using PL/SQL, SQL*Plus, Workflow Builder, Application Object Library, Forms and Reports.
• Used the features of BI Publisher such as Sort, Group, Total, Subtotals to make data intense operations happen at the template level.
• Customized Seeded Reports(Financial) in Oracle Applications like: Aging Detail and Summary Reports - Oracle ReceivablesManual Credit Memo Report - Oracle ReceivablesPurchase Price Variance Report - Oracle PurchasingInvoice Aging Report - Oracle PayablesAccrual Reconciliation Report - Oracle Purchasing, etc.
• Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE.
• Involved inCustomer Conversionto load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables usingTCA APIs.
• Created custom built forms with Oracle applications using template.fmb and customized/personalized forms using Custom.pll.
• Forms Personalization in AR, Pricing and OM using Oracle Application Framework Personalization and forms Personalization
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU TOP on forms server of client.
• Developed custom report (OM) to pull the order details placed for checks and related transaction details
• Worked on custom API to generate error, data files and import data from legacy system to ERP system.
• Developed AR Credit memo andAR Customers forms.
• Involved in implementing Payables, Receivables modules in Multi-Org set up including designing, testing and maintaining interfaces from legacy system.
• Transferred Custom Concurrent programs, executable, request groups, profile options using Oracle's FNDLOAD utility.
• Converted flat files from Excel to Data files and developed the SQL*Loader program to load the data to staging tables for Order Import program to import orders. Wrote packages to validate and populate the interface table.
• Development of custom XML publisher and RDF reports in Purchasing (PO) and in Account Payable (AP) modules.
• Technically proficient in writing Procedures, Packages, Functions, Triggers, views, records, constraints, synonyms, indexes and other database objects using SQL and PL/SQL for validating the data loads.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Tuning the SQL statements for optimal performance.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO)
• Had track of source code additions and changes and versions using version control software.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Environment: Oracle E-Business Suite (EBS) 11i/R12 (GL, AP, AR, PO, CM and OM), Oracle 10g/9i, SQL, PL/SQL, Forms 10g/9i, Workflow Builder, BI/ XML Publisher.

Confidential, Chicago, IL

Oracle Technical Consultant

Responsibilities:

• Developed new Reports and customized existing Reports in the OM, AR and AP module according to the client’s requirements.
• Developed a Custom Program to validate and Import Sales Order from legacy system into Oracle Application using order processing API.
• Worked on Payables Open Invoice Interface in AP.
• Worked with users through all Software Development Lifecycle (SDLC) phases.
• Developed supplier Conversion to load vendor details from legacy system into Oracle Applications base tables.
• Created custom forms with control block and auto populating data to Control blocks at run time using PRE, POST-Query triggers.
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.
• Worked with API's and Conversions like Item Master, BOM, Item-Category, On-hand quantity, Journal Import, Customer and Sales Order etc.
• Developed UNIX Shell scripts to archive inbound/outbound files and report outputs.
• Worked on Customized standard forms through custom.pll.
• Material Transaction Report using XML Publisher.
• Developed standard reports in OM.
• Customized the Order Header level and Line level Workflow (WF) processes to add the custom activities.
• Created Materialized Views to hold the extracted and calculated data for Reporting purposes.
• Expertise in writing Challenging Codes using SQL, PL/SQL and UNIX Shell Scripts.
• Created new custom folders and value lists in discoverer admin layer.
• Involved in bug analysis and fixing process.

Environment: Oracle E-Business Suite (EBS) 11i (OM, AR, AP, BOM, INV), O2C, SQL, PL/SQL, Reports/Forms 10g/9i, TOAD, Discoverer, Oracle 10g/9i, XML Publisher.

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed data extraction programs using UTL FILE packages.
• Involved in writing all the complex DDL, DML Statement.
• Performed Data base SQL Optimization using Explain Plans and Trace Plan to improve performance.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Partitioned the fact tables and materialized views to enhance the performance
• Responsible for running the Open Interface to import data from OM interface tables into the base tables
• Customized existing discoverer OM line report to add new columns as per specifications.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Used Bulk Collect feature to improve performance.
• Extensively used SQL Query, joining tables, SQL function in Quires.
• Involved in SQL LOADER scripts to process the daily/ weekly and monthly batch processing and other special data loads.
• Involved in database development by creating PL/SQL functions, procedures, triggers, packages and materialised views.
• Created UNIX Shell scripts for automating the execution process.

Environment: Oracle E-Business Suite (EBS), oracle 9i, SQL, (OM, INV), SQL*Loader, Developer, PL/SQL.