Oracle Developer

Bhavin Bhatt

678-***-**** *.*****@*******.***

Summary:

•10 years of IT Experience in the development, design of technical business process components for Oracle Applications implementations and upgrades.

•Implemented Data Conversions, TCA and EDI Interfaces at the implementation of Oracle 11i. •Development of SQL, PL/SQL Procedures, Functions, Packages and Triggers, and UNIX Shell Scripts and SQL*Loader for Automated Procure to Pay Process and Order to Cash project level delivery for customization and custom processes.

•worked on ODI enterprise edition for database mapping and Data load operation to maintain data integrity during upgrade.

•Used Oracle warehouse builder and Oracle golden gate for during data migration and upgrade from legacy system.

•Utilization of canned Oracle stored procedures and API to enhance the functionality of the custom process, worked on XML gateway and EDI interface to load business transactional data to Oracle applications.

•Customization of Oracle Forms and forms Personalization with forms6i. • Experienced with Agile Oracle Product life cycle management

•Customization of Oracle Forms, custom forms in forms 6i and forms Personalization in Oracle 11.5.10. Experienced with Data Extract Transform and Load (ETL) via Oracle plsql packages and SQL loader.

•Workflow Builder for Business events and Business process customization with RICEF development.Testing efforts related to system integration test with manual and automated testing, creation of test plan and Test scripts.

Skills:

Oracle Apps Modules

Account Payables (AP), Inventory (INV), Oracle Purchasing (PO) and iProcurement, Order Management (OM), Accounts Receivable (AR).

Oracle Apps Technical

Oracle Application Framework (OAF), Oracle Discoverer 10g, Oracle Workflow builder, Oracle XML Publisher/BI Publisher

Oracle Application Desktop Integrator, Application Object Library (AOL), API’s and Interfaces.

Tasks

Assisted for scope, schedule and transformation of low level information to General format of business requirement. Requirement gathering of Technical Details related to project tasks. Documentation with Oracle AIM methodology.

Databases & Tools

Oracle 9i / 10g /11g, MS Sql Server, Oracle Forms 6i, Reports 6i, TOAD, Oracle SQL Developer, Workflow Builder 2.6, JDeveloper 10g/11g, web ADI and Desktop ADI. SRS, PVCS, QTP,

Languages

SQL, PL/SQL, XML, Shell scripting, java2, HTML, JavaScript

Utilities

FNDLOAD, SQL*Loader, Database Export, Database Import

Experience:

UPS August 2013

Senior Application Developer

Developed technical components and plsql programs updates based on business differences observed and noticed by business users

oCreation of new program to utilize functionality of Oracle Standard APIs for value set validation and new definition of concurrent programs.

Maintained details within design requirement document and technical design document for business functionality validation

Maintaining inventory item availability via move order API on Oracle application for order to cash life cycle to get for the corresponding item on the order before the order will be placed.

Maintained business process with plsql packages for commercial invoice process for international transportation

PlSql packages, procedures and functions updates for move orders process, part numbers availability fuctionality

PlSql programs to maintain manufacturing parts process for customers based on customized item DFF.

PlSQL program development for item conversion process to determine serial control or lot control parts.

Modification of any custom technical components such as XML template definition updates, views and table scripts.

Validated technical objects before any release, upgrade or technical refresh efforts take place by checking database objects definitions.

Modification of Oracle components such as forms and Custom API with Oracle forms developer 10g and PL/SQL developer tools

Managing technical components to release technical package to deliver it for scheduled release timely.

College of American Pathologist Feb 2013- May 2013

Technical Developer for EBS Support

Provided Oracle Support for Printer set up with the verification of Print queue and User acceptance and production deployment for support ticket related to print style set up.

Worked on Oracle Technical development in PL/SQL for production support automation to validate interface data for Auto Invoice program with the request set implementation.

Worked on Oracle alerts for employee expenses that approver action is not completed for defined time period.

Worked on data extracts in PL/SQL for Oracle EDI outbound Gateway for Purchase Orders and invoices to send PO advice to supplier in 824 standard

Used Oracle Data integrator to perform Extract Load and transform operation between legacy system database and oracle 11g.

performed Data mapping for data integration purpose between legacy database and Oracle database.

worked on order import with plsql api with Order header and order line workflow for Orders inbound interface to load them with booked order status for customer accounts.

maintained data integrity with Oracle Data integrator enterprise edition 11g between modules by transforming source health data to load them to Data format for Big Data database on destination server.

Morgan Stanley, GA May 2012- July 2012

Oracle Applications Consultant

Help desk ticket support to update Oracle BI publisher report, Oracle Desktop ADI reports setups for printing on the printers. Support for business related operational issues for Custom business process forms.

Oracle Technical development with pl/sql for GL interface journal data extract for Oracle GL.

Worked on Oracle data integrator to load inbound data for invoices coming from selected inbound feeders for Oracle applications.

worked on different task of repository development on OBIEE for BI answers on OBIEE analytics, maintaining updates to Business model layer on OBIEE and deploy the updates of reports via OBIEE enterprise manager.

Caterpillar Inc., TN August 2011- Feb 2012

Oracle Applications Production support Consultant

Large data volume of Accounting Transactions interfaced to Oracle r12 by handling conversion from legacy system for history data for balances and by month activity per currency.

Shell script to load data files for Accounts and its detail description according to the Operating units of the business with concurrent programs of pl/sql.

Utilized Web ADI features for Oracle GL transactions. Oracle 11g data export and import utility for Oracle custom schema objects.

used xml gateway functionality from Oracle applications to load XML data for purchase orders and puchase invoice receipts to be able to load in Oracle base tables.

Experienced with R12 implementation with RBAC and MOAC concept based on responsibility and user profile level set ups

used Oracle Data integrator enterprise edition 12c to maintain developed database code to deploy them during upgrade from SQL server to Oracle application.

Sourcefire, MD July 2008 - Jun 2011

ERP Developer for implementations and customer support

Discoverer Administration Edition, Created various business areas, user views, custom folders reporting in Inventory, Order management, AR, AP, Install Base and GL.

Worked on Oracle HTML Quoting Print Quote XML publisher, XSL transformation with XSL designer.

Designed shipment notification process in plsql program and Product Activation process in Oracle purchasing receipt interface process for Oracle iSupplier implementation and install Base implementations.

Worked on PLSQL API to get the inventory item availability, unavailable item to be requested via requisition, with oracle api Purchase order can be added and received the item for inventory on hand.

Oracle Customers contacts conversion for Oracle Customer support

Oracle inventory item master maintenance with custom processes master item import processes.

Initiated project efforts for partial page rendering and page personalization with OA framework customization.

Reports development in SQL and PlSQL program with report 6i tool and formatted with XML publisher for iProcurement and payables.

HHS, MD Dec 2006-Jun 2008

Technology Consultant for RICE development

Designed Purchase Order interface in PLSQL for PO creation, update and delete while maintaining the reapproval processes.

Developed shell script to push or to pull the data files from shared server location.

Fixed AP Agreement Listing Report issues on the production, Exported tables and created backups.

Worked on Oracle Application framework to update page layout for self service web application in Expense confirmation

Developed functional specifications for custom objects (RICE), Develop custom forms to upload datafiles.

Performed Unit testing and System Integration testing.

Schnitzer Steel Industries, OR Mar 2006-Oct 2006

Oracle Applications Developer.

•Suppliers Conversion with Suppliers Open Interface Import and supplier’s sites open interface import for all the operating units in plsql program

•Invoice Conversion and its Payment Batch with check printing report and print queue customization.

•Worked on Outbound Bank Notification Program Interface to notify banks for daily check payments in plsql program.

•Experienced with Agile Oracle Product life cycle management

•Developed Inbound Statement Interface to load the statement that was forwarded by bank to company and reconcile them into the Oracle Cash Management with Auto reconciles standard Program.

Williams, OK Apr 2005 – Dec 2005

Oracle Techno-Functional Consultant

•Experienced in Report 6i with AR Custom reports such as 12 Month Customer Receivable reports, Collections by collector Report, Billing and Receipt History Report, Count by types Report.

•Developed plsql program to invoke Custom AR Dunning Letters and Universal Aging Report that utilizes SQL querry, Custom Reports such as PO Expediting Reports, PO Totals by months report and other reports to conclude the PO.

Education:

MSEE, California State University Sacramento, May 2005

Contact this candidate