We provide IT Staff Augmentation Services!

Oracle Apps Techno Functional Consultant Resume

Sunnyvale, CA

SUMMARY:

  • Over 13+ years of IT experience including Analysis, Design, development, Conversion, Interfaces, implementation and upgradation of Oracle Applications R11i/11.0.x, SQL, PL/SQL, Oracle 10g/9i/8i, Forms6i and Reports 6i.
  • 12+ years of experience in Project Implementation/Maintenance experience in Order to Cash Flow.
  • 11+ years of experience in Finance systems analysis, solution design and deployment using Oracle applications.
  • 12+ years of experience in Experience working with Oracle Financials release 11i and Release 12.
  • 11+ years of experience in SQL, PL/SQL, TOAD, XML.
  • Having more than Eight years of extensive experience in Oracle Application Modules which include Order Management (OM),Inventory (Inv), Bill of Materials (BOM), Work in Process (WIP), General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), iExpense, iProcurement, Advanced Pricing, Purchasing (PO), Application Object Library (AOL) and System Administration.
  • Highly proficient in technical aspects of Oracle Applications namely Customizations, Interfaces or data Conversions.
  • Expertise in Cross Functional Knowledge and Support process for Finance and Manufacturing Business Applications.
  • Expertise in supporting the Quarter end and Month End closure process for Financial and Supply Chain modules
  • Extensive experience in Form personalization.
  • Work experience in OA Frameworks, SOA, Business Process Execution Language (BPEL)
  • Expertise in integrations with Oracle Application Systems.
  • Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL file etc.
  • Extensive Experience with AOL to develop Flex fields, Value sets, Forms, Reports, Concurrent programs and Menus into Oracle Applications.
  • Proficiency in Oracle Applications Implementation Methodology (AIM).
  • Extensive knowledge on workflow customization.
  • Extensive experience in developing Oracle Forms, XML Publisher and Oracle Reports.
  • Extensive experience customization of Forms and Reports.
  • Extensive experience in PL/SQL Procedures, Functions, Packages and Database Triggers.
  • Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.

SKILL:

ERP environment: Oracle Applications 11.5.8,11.5.9,11.5.10.2,R12

ERP Modules: Inventory, Order Management, Receivables, Payables, Cash Management, General Ledger, iProcurement, Purchasing, Install Base, Service Contracts, Oracle Pricing, Oracle Manufacturing, iExpense.

Front End tools: Forms 6i, Reports 6i, Remedy, Sabrix, Discoverer, Workflow 2.6,Kintana, XML Publisher

Databases: Oracle 8i/9i/10g/11g

Languages: SQL, PL/SQL, Java

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Involved in analyzing the functional documents and solution design for Quote to Order Flow.
  • Define to - be solutions using Oracle 11i standard functionality and identify RICE requirements.
  • Review the MD70 technical Solution Document with offshore for building the code.
  • Responsible for the delivery of the solution, support and fix the issues from the development to the deployment of code in production.
  • Supported Issues during UAT and QA testing.
  • Involved in completed End-to-End testing right from Siebel Quote to Oracle Invoice.
  • Involved in the design and development of the following.
  • Conversion design - Extract the data from 11.5.9 and create .csv file using UTL File.
  • Conversions from Oracle Applications 11.5.9 to R12: Item, Bom, Contact Conversion
  • Interfaces between 11.5.9 and R12:Item,ECO
  • Modified the Existing Custom Program Software Licensing, Custom.pll, header and the line zoom form to the Everest Requirements.
  • Created innovative storage and data management solutions that help the customers accelerate business breakthroughs and achieve outstanding cost efficiency. Everest is the Initiative from Confidential to Implement Quote to Order for their Business which will make easy processing of Quotes online and submissions of Quote from the Partners and end Customers.
  • The purpose of Implementing Everest is to have Quote Created in Release 12 and Gets processed validated before Creating as Order in Release 11.5.9, the Process of Order to Invoice Happens in Release 11.5.9.

Environment: Oracle Apps 11.5.9

Confidential, Sunnyvale, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Provided secures Web communications and accelerates business applications across the distributed enterprise. Company family of appliances and client-based solutions - deployed in branch offices, Internet gateways, end points, and data centers - provide intelligent points of policy-based control enabling IT organizations to optimize security and accelerate performance for all users and applications.
  • Involved in the complete life cycle implementation of Blue Store project.
  • Involved in developing the Order Import interface package to create sales order from blue store portal
  • As part of blue store implementation involved in Functional design process and Technical design process and documentation of process.
  • Involved in the Pricing Qualifiers and Modifiers setup.
  • Involved in customization of Sales order Line Workflow process as part of eFulfillment process
  • Involved in customizing the Sales order header workflow process to close the order header for every 8 hrs
  • Developed XML Publisher reports, alerts, concurrent programs as part of enhancement requests and blue store project
  • Involved in supporting the day to day production issues and analyzing the root cause of the issues.
  • Developed programs to send out the notifications using UTL Confidential package.
  • Involved in supporting the month-end and quarter-end period closing activities.
  • Designed and developed programs for the enhancement requests.
  • Extensive knowledge on OM Sales orders Drop ship process.
  • Designed and developed the email address validation through personalization
  • Extensively worked on INV, OM, PO, AP and AR modules.
  • Involved in the implementation of iExpense AME module.
  • Involved in Setup and development of Payment formats as part of Confidential roll-out.
  • Involved in code review process to ensure the Confidential coding standards are followed.

Environment: Oracle Apps 11.5.10.2

Confidential, Sunnyvale, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Implemented Oracle Applications Financial modules in 11.5.9 and upgrading the Applications to 11.5.10.
  • Developed interface program to send the AR balances to Siebel
  • Involved in fixing the bugs and testing the business process in upgradation project
  • Developed Alert to send the notification to the AP team once the payment batch is formatted.
  • Involved in fixing the production issues.

Environment: Oracle Apps 11.5.9, 11.5.10

Confidential, Sunnyvale, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Implement Product on the Oracle EBS Middle tier and configure, validate the configurations to automate the process of Payments, Receipts and Reconciliation in CM
  • Oracle Payments(Setting up new PPR via Payment Administrator)
  • Receivables(Setting up Lockbox, Transmission formats, Banks, Supplier and Supplier Sites)
  • Cash Management (Setting up Bank Transaction Codes, Bank Statement Mapping)
  • Providing support to the Customer during User Acceptance Testing
  • Training End Uses on the payments, receipt application and Reconciliation integration with oracle apps.
  • Single point of contact for Product Support
  • Product maintenance and bug fixes on Oracle
  • Design, implement and support Product enhancements.

Environment: Oracle Apps 11i/R12

Confidential, Liberty Lake, WA

Oracle Apps Technical Consultant

Responsibilities:

  • Worked in Journal Import Interface converting of legacy data in to Oracle Applications involves using of PL/SQL package and Shell Script. SQL * Loader was used to load data into custom tables.
  • Interfaced legacy system GL data using Journal Import.
  • Involved in Building Customizations and Enhancement using Reports and Forms
  • Customize Pick Slip and Open Purchase order reports.
  • Responsible for developing a custom program to make all the Confidential products as ‘RoHS’ compliance
  • Developed Custom Interface to import vendor’s information from legacy system to Oracle Application.
  • Developed a new interface program for Item and BOM conversion.

Environment: Oracle Apps 11.5.8

Confidential, Winchester, VA

Oracle Apps Technical Consultant

Responsibilities:

  • Worked on Order Management and Inventory modules in Mainframes ( Confidential ) system. They wish to migrate from Confidential to Oracle Applications 11.5.9. It’s a full cycle implementation of OM and INV modules in Oracle Applications 11.5.9
  • Designed and developed Item Interfaces, BOM and AP interface programs.
  • Worked on Invoice Report, Bill of Lading report, Pick Slip report and other custom reports.
  • Responsible for Level 1 support for supporting the production system after the go-live date
  • Worked on customizing the Order to Cash cycle and developed some custom forms for EDI transactions.
  • Involved in preparing the test scripts and conducting CRP’s
  • Created forms and reports using Oracle Forms and oracle Reports, Database triggers using PL/SQL..
  • Worked with functional experts to implement their functional knowledge into working Procedures.
  • Involved in complete life cycle of testing e.g., Unit Testing, Integration Testing, System Testing and User Acceptance Testing.

Environment: Oracle Apps 11.5.9

Confidential

Oracle Apps Developer

Responsibilities:

  • Delivers products and services for data protection, storage and server management, high availability and application performance management. Confidential migrated Oracle ERP Applications from Release 11.0.3 to 11.5.9 as a re-implementation process.
  • Developed Customer API using Confidential architecture. This is a public API that can be called from any sources that require to perform customer related operations in Oracle ERP.
  • Developed Confidential VIP Update Customer Product Program that will be used to update pricing attribute 32 in purchase base (install base). This update is done to keep the InstallBase Pricing Attribute 32 in sync with the Current VIP Agreement Level
  • Developed Sales Rep API. The purpose of this API is to provide any of the application modules with a way of determining the Salesrep that will apply for the transaction being processed
  • Developed custom reports as per the enhancement requests.
  • Involved in production support after the post go-live.

Environment: Oracle Apps 11.5.8

Confidential

Oracle Apps Developer

Responsibilities:

  • Worked on project involves Oracle Applications 11i implementation of Payroll and Human Resources Modules.
  • Created Interface to extract Employee Data along with Payroll Deductions and create a Flat file which would be sent to Legacy System
  • Developed Conversion Programs for the following entities Employee, Addresses, Phones, Contacts, Assignments, Element Entries.
  • Developed a custom report to display all active employees and termination employees from previous period.
  • Developed a custom report which will provide the information on employee gross earnings and hours worked.

Environment: Oracle Apps 11.5.8

Hire Now