We provide IT Staff Augmentation Services!

Oracle Resume

5.00/5 (Submit Your Rating)

Los Angeles, CA

Professional Experience:

  • Over 7 years of experience in Design, Development, Conversion, Customization, Interfacing and Implementation of business applications using Oracle Applications R12/11i, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, Developer 2000/6i.
  • Proficient in all phases of Oracle Applications implementation with major focus in Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Purchasing, Order Management (OM), SCM, INV and PA modules.
  • Extensive experience in full life cycle implementation, upgrade and post-production support of Oracle Financials and Supply Chain Management (Release11i, 11.0.3 and 10.7).
  • Extensive knowledge of Business Processes across the E- Business Suite, Order to Cash (OTC) and Procure to Pay (PTP).
  • Expert in Trading Community Architecture (TCA) and involved in importing customers into Oracle AR using TCA API’s.
  • Proficient in writing Stored procedures, Packages, Triggers and functions using SQL, PL/SQL and Performance Tuning of SQL queries, stored procedures and reports.
  • Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and UTL File.
  • Strong Experience in designing, developing and troubleshooting developing Reports, Interfaces (Inbound & outbound), Customization and Extensions (RICE) in Oracle Applications.
  • Proficient in developing Forms and Reports using Oracle Forms 10g/6i/4.5, Reports 10g/6i/4.5, Discoverer 4.x/9i/10g and XML Publisher with sound understanding of Application Object Library (AOL).
  • Hands-on Experience in developing New Forms and customizing Standard Oracle Forms using TEMPLATE.fmb and CUSTOM.pll
  • Involved in Accounts Receivable Invoice Conversion and loading Receipts information using Auto Lockbox Transmission.
  • Extensive experience with multi-org architecture and multi-reporting currency (MRC).
  • Worked with UNIX shell scripting to automate the execution of the batch processes.
  • Experienced in Oracle Workflow Builder 2.0.3 / 2.6.2, Oracle Workflow API, table Structures and Workflow BG Engine and Worked on customizing standard Oracle Workflows.
  • Solid working knowledge in analyzing and understanding the source/existing/legacy system business functionality and preparing the functional and Technical Design Documents using AIM Methodologies.

.

Technical Abilities:
Oracle Applications: R12, 11.5.10/11.5.8/11.5.4/11.5.3
Oracle EBS Modules: GL, AP, AR, OM, PO, CM, INV, WIP, BOM, WSH
Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Discoverer 4i/9i, Developer 2000/6i/9i/10g, Workflow Builder
IDE: TOAD, PL/SQL Developer, Eclipse, NetBeans
Language : C/C++, JAVA, PL/SQL
Database : Oracle 10g/9i/8i
Database Tools: TKPROF, SQL*PLUS, SQL*LOADER, APEX
Scripting Languages: UNIX shell scripting
Version Control: PVCS, VSTS, MKS, Clearcase
Operating Systems: UNIX, Linux, Windows NT/2000
Web Standards: JSP, Servlets, HTML, Java Script, XML, XSL/XSLT
Others: Apache Tomcat, SOAP

Professional Experience:
Confidential, Mar’2012-July’2012
Los Angeles, CA
Oracle Techno-Functional Consultant
The project involves working with a centralized ticketing system to which end users would send in Heat tickets or Service requests. Heat tickets mostly involve fixing production issues while service requests were specific changes to be made to existing functional implementations of processes or reports already present.
Responsibilities:

  • Customize AP Invoice Approval Workflow according to the following specifications,
    • Incorporate a rejection flow for all sub-approval processes involved based on the type of invoice submitted for approval.
    • Check for validity of the rejection reason entered by the corresponding invoice approver.
    • Modify the workflow package corresponding to the workflow to implement a procedure which does the rejection reason validation.
    • Modify the Notification recipient from a single user to a list of users generated dynamically based on the cost-center associated to a particular invoice.
    • Modify the workflow package corresponding to the workflow to implement a procedure, which finds all users associated with a cost center. Create a Ad-hoc role and assign all users to that role and in-turn store it into a newly created workflow attribute.
    • Modify the subject information for the message template associated to the rejection notification sent out to the invoice preparer to include specific invoice related information as per end-user requirements.
  • Analyze the workflow package associated with GL Batch Approval Workflow and find the procedure which retrieves the user information for a particular batch submitted for approval. Identify the custom hierarchy table involved in the procedure implementation to fix a fault finding a user currently not found in the Delegation LOV in web-notifications Delegation function web-page.
  • Modified a concurrent program that identifies duplicate invoice entries in interface tables and deletes the invoice whose particulars are submitted by the user as inputs to the concurrent program. The modification eliminates multiple invoice information being retrieved based upon the supplied input parameter values.
  • Modified a currently existing SQL*PLUS report that generates header level information to include line level information and spool the output to a “.CSV” file.
  • Using Oracle GRC hid sensitive tax payer related information being displayed in Form field related LOV’s in AP, AR and PO Inquiry functional menu related forms.

Environment: Oracle EBS 11.5.2 PO, AP, GL, PA, Oracle Database 11.2.0.1, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Reports 6i, Forms 6i, Workflow 2.6.3, Smarterm, IBM AIX 6.0
Confidential,Lancaster, OH AUG’2011-FEB’2012
Oracle Technical Consultant

Confidential,is a leading designer, manufacturer and marketer of high quality glass products for consumers as well as the Foodservice. Anchor Hocking\'s product lines include drink ware, stemware, serve ware, dinnerware, bake ware, storage, candle, craft, and floral and home decor products.

Modules: Inventory, Order Management, General Ledger, Project Accounting, Accounts Receivables, Purchasing.

Responsibilities:

  • Performed business requirement gathering and high level solution design for implementing Oracle Order Management, Accounts Payables, Project Accounting
  • Conducted multiple workshops for demonstrating the prototype of the system to illustrate preliminary business process flows, discuss high level fit-gap analysis, gather detailed business requirements and identify detailed gaps.
  • Developed PL/SQL Inbound interface programs in Oracle Accounts Payable module (worked on Invoice formats of FedEx Air and ground, Enterprise Partner)
  • As part of the Conversion of Project Accounting designed and developed the programs to convert, Projects, Tasks, Budgets, Agreements and funding, Events and Cost
  • TCA APIs are used to load parties and customer data into Oracle Receivables.
  • Designed and developed invoice interface to load Invoices from legacy system into Oracle Payables. Data is loaded into Stage tables using the concept of External tables, validated and processed into Oracle Base tables.
  • Developed Sales Order Import conversion program to load open legacy orders into Order Management.
  • Technical Design and build of Revenue Recognition Interface which will call ar_revenueadjust_pub.earn_revenue API to amortize revenue for Invoices which has unearned revenue amount based on the inbound data from a 3rd party system.
  • Developed a custom Inventory Adjustment Program in INV module to synchronize on hand quantities in Oracle Applications and on hand quantities in the warehouse.
  • Performed migration of Purchase Requisition and Purchase Order using SQL Loader and Oracle Interfaces.
  • AP Invoices migrations to 11i using Payables Open Interface
  • Worked with Process Order API to create new orders
  • Customized standard Oracle reports such as AR Invoice Detail, PO Printed Purchase Order Report and Customized ‘PO Printed Purchase Order Report’ according to the business requirements.
  • Developed Discoverer End User Layers to develop Month End Parts ordered report.
  • Migrated reports to Discoverer Portal, Discoverer Plus and Discoverer Viewer.
  • Created workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop in 4i.

Environment: Oracle Applications 11i, Discoverer 4i, Forms 6i, OWB, TOAD, BI Publisher.



Confidential,Rochester, NJ JUN’2010-JUL’2011
Oracle Technical Consultant
Confidential,is a technology and services enterprise. The Company develops, manufactures, markets, services and finances a range of document equipment, software, solutions and services. The Company operates in more than 160 countries worldwide. Xerox markets and supports document management systems, supplies and services through a variety of distribution channels worldwide.

Responsibilities:

  • Involved in upgrading Oracle Applications from 10.7 to 11i.
  • Developed custom program to validate and load the PO documents from Mass200 into Oracle.
  • Purchasing interface table. Used Purchasing Document Open Interface program to load the data into Oracle base tables.
  • Customized Workflow’s for Approval of Requisitions Created from iprocurement Portal.
  • Worked on API’s for renewing the PUNCH-CARDS for the iprocurement portal for buying online.
  • Developed a custom Wrapper & did the necessary validations in getting the data from the Banks into oracle tables with the help of Auto Lock Box Interface in AR.
  • 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 Interface tables and then populate the Oracle Base tables by calling Payable invoice Import Program.
  • Worked on Pick Release, Pick Conform, Move Order API’s in INV.
  • Worked on OM / Shipping – Order Booking, Release Sales Order, Shipment - Transaction, Ship Confirm etc.
  • Configuration of Key Flex Fields, Descriptive Flex Fields, Lookups, Transaction Types, Item Categories.
  • Worked on Modifications of several standard workflows in Oracle.
  • Extensively used AOL and System Administrator modules for Creation of users and creation of roles and responsibilities, assigning various customers to users, set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields Registered concurrent programs, request groups for reports and concurrent requests.
  • Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering the developed and customized reports.

Environment: Oracle Application 10.7 & 11.5.10.2 E-Business Suite, OEM, SQL*plus, imp/exp, SQL, pl/sql, SQL* loader, Forms and Reports 6i, XML Publisher, Toad, Excel Code, Discoverer 4i



Confidential,Carlsbad, CA Jul’2009-May’2010
Oracle Apps Technical Consultant
The project involved implementation of Oracle Applications development in AP, GL, PO, AR, FA, PA, OM and INV.
Responsibilities:
Interfaces/ Conversions
  • Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
  • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
  • Responsible for running the Open Interface to import data from OM interface tables into the base tables.
  • Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
  • Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production
  • Used cross-validation and value set features while implementing descriptive flex fields extensively to capture additional information in standard as well as customized forms.
  • Worked on Custom.pll to customize the forms to meet the client requirements.
  • Worked on coding Flexfield in Forms and Reports.
  • Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
  • Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
  • Responsible for running the Open Interface to import data from OM interface tables into the base tables.
  • Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.

Reports

  • Developed parameterized reports using Discoverer Plus in Order Management
  • Developed various xml reports like Award Audit Trail Report, Delegation of Authority Audit Report using XML Publisher.
  • Designed XML publisher reports. These are configured to generate output in PDF formats.
  • Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
  • Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
  • Involved in development of Discoverer reports like PA account information report, AR aging report etc.
  • Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer

Environment: Oracle EBS AP, PA, AR, OM, BOM, PO, INV, GL, PL/SQL, SQL*Plus, SQL*Loader, TOAD, reports builder, forms builder, Solaris, PVCS, Rational Clear Quest.



Confidential,Daytona Beach, FL Nov’2008-Jun’2009
Oracle Techno-Functional Consultant

Confidential,has become one of the leading authorities on Building Science. The Environments For Living program has consolidated the most advanced techniques of applied Building Science for the benefit or America\'s builders. Today, MCS has grown to be one of the largest residential subcontractors by being involved in over half of all new residential construction.
Responsibilities:

  • Responsible for the architecture and design of the company’s multi-national Oracle Applications release 11i project. Implementation included US, Canada, United Kingdom, France, Germany, Austria, Australia, Hong Kong, Mexico and Costa Rica.
  • Involved in Set up of the multi-org architecture, 24 General Ledgers and 18 Fixed Assets and upgraded from Oracle 10.7 and 11.0.3 to 11i.
  • Resolving technical issues, guiding the client on various technical setups, Oracle apps technical methodologies to enable client to achieve strong technical foundation for apps project, to achieve high performance and to establish systematic standards and procedures.
  • Documented Technical design documents (MD70s), Coded and prepared migration scripts for Reports.
  • Implemented FA tax books with the new 11i features that allows going live in the middle of the fiscal year. Performed the user acceptance test and the Quality Assurance phase of the project.
  • Designed and developed Outbound Interface Program using Oracle’s Shipping Execution Public API to load pick-released orders into external system.
  • Customization of reports in Oracle Financials and Oracle Order Entry modules including PO Summary, Open Requisition PO Reports, GL Accounts Summary.
  • Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
  • Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields, coding Flexfields in Forms and Reports, implementing Cross Validation Rules, Security rules, working knowledge of Global Descriptive Flexfields, registration of Forms.
  • Developed a customized workflow for the PO Approval Hierarchy.
  • Worked on Custom.pll to customize the forms to meet the client requirements.
  • Developed SQL Applications for extracting the data from the Oracle tables.
  • Created user defined Exceptions while Handling Exceptions.
  • Worked on QP Price Formula pub API in QP.
  • Worked on Freight Costs Public API in WSH.

Environment: Oracle Applications 11i, GL, OM, INV, BOM, PO, AR, AP, WSH Windows NT, UNIX, SQL*Loader, PL/SQL, SQL*Plus.



Confidential,Richmond, VA Sep’2007-Oct’2008
Oracle Technical Consultant

Confidential,is one of the top suppliers of packaging for the international music industry, keeps in pace with the music business’ explosive evolution from LPs to cassettes to compact discs. The scope of this project involves implementation of Oracle Order Management, Financials modules 11i and migration of legacy Configurator to Oracle Configurator.
Responsibilities:

  • Involved in Conducting the performance tuning of applications through SQL*Navigator, SQL*TRACE and TKPROF utilities.
  • Used UNIX Shell Scripts and developed PLSQL procedures to extract and load data for month-end batch processing.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Customized various reports as per customer requirements such as Open Sales order report, Min-max report with historical usage and range of suppliers, item-vendor report, PO/items expediting report, Open sales orders reports etc.
  • Worked on rebuilding the interfaces and customizations on Accounts Payables and Purchasing Modules. E.g. Payables Open Interface (for two different sources), Purchasing Receiving Interface, GL Extract outbound and PO outbound programs.
  • In the GL module, designed and developed packages for Journal Import Interface to import journals information into the system. Developed PL/SQL package to validate and insert the validated data into interface tables.
  • In the OM module, designed and developed Interface Programs for Importing Purchase Orders using Import Standard Purchase Orders.
  • In the INV module, designed and developed Inventory Purchasing requirements Report in extension of inventory min-max report. This report gives all item information including minimum, maximum, on hand, available, reorder as well detail level of supply /demand type, supply/demand quantities, projected on hand and other useful information.
  • Used Discoverer 4i to access information from organization database for analysis and Reporting to extend the functionality and capability of the End User.
  • Developed screens using Forms 6i - to enter new business data using billing form, to input information for facultative processing, to view policy on-line, to reinsure a policy implementation of fine grain access control.
  • Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers, Parties, Customer Accounts, Party sites using TCA architecture .

Environment: Oracle Applications 11i OM, INV, BOM, PO, AR, AP, Windows NT, UNIX, Forms 6i, Discoverer 4i, SQL*Loader, PRO*C, PL/SQL, SQL*Plus.

Confidential,Hyderabad, IND Jun’2006-Aug’2007
Oracle Developer

Confidential,specializes in the delivery of dual-shore services in the areas of Offshore Software Product Development, QA/testing and KPO. Value Labs works on the remote execution model right from inception and have perfected the process of onsite-offshore interaction.
Responsibilities:

  • Designed & Implemented automatic error handling and recovery processes for table data loads and to make sure that dependency of the “order” of table loads was maintained.
  • Coded processes for automatic export and import of data in tables using Oracle Export/Import utility.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Performed complex data manipulation using foreign functions written in C and PL/SQL language.
  • Responsible for developing technical specifications from business requirements
  • Involved in trouble-shooting production database problems and report problems.
  • Designing and developing the module functionality using Pro*C, Embedded SQL, PL/SQL stored procedures and functions.
  • Analyzed the requirements and created a logical model of the Oracle database and represented the entity hierarchy and relationship using ER diagrams.
  • Optimizing transactional database queries using Hints, to improve processing speed.
  • Involved in creating Queries for Business Objects to produce reports, Generating XML flat files from select queries, developing SQL*Loader scripts to load data into tables, and working with the Production Support team to fix many high priority bugs.
  • Used Advanced Explicit cursors Concept like FOR UPDATE, WHERE CURRENT OF Clause.
  • Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
  • Wrote Unix Shell scripts for the relevant work.

Environment: UNIX OS, Oracle 7.X/8i, Oracle SQL, PL/SQL, Java, JavaScript, Pro *C, HTML, XML.

Confidential,Hyderabad, IND Jul’2005-May’2006
Oracle Developer
Responsibilities:

  • Created database objects such as tables, views, indexes, sequences using Oracle8i.
  • Developed PL/SQL stored procedures, functions and packages in TOAD 8.0
  • Created PL/SQL program units to include DML, DDL statements using dynamic SQL.
  • Fine tuned procedures for maximum efficiency in various schemas across databases using Oracle Hints, execution plan.
  • Optimized and tuned PL/SQL subprograms to reduce the loading process.
  • Trapped errors such as INVALID_CURSOR, VALUE_ERROR using exception handler.
  • Developed row level and statement level triggers for auditing tables in PL/SQL.
  • Created partitions on the tables to improve the performance.
  • Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
  • Generated sequences that can be shared by multiple users to generate unique integers.
  • Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
  • Wrote complex queries involving multiple-joins to generate user reports.
  • Participated in the ongoing process enhancements and modification requests.
  • Used UTL_FILE package to check if the flat file existed before the SQLLDR script was executed, and also to check the log file to find the number of bad row inserts.
  • Developed scripts in UNIX for daily backup.
  • Coordinated with the offshore support team in resolving critical issues.
  • Tested, installed, documented and provided on call support for the applications.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, TOAD 8.0, UNIX, Shell programming.

We'd love your feedback!