We provide IT Staff Augmentation Services!

Oaf Developer Resume

San Francisco, CA

SUMMARY

  • 7 Years of Oracle Applications experience - specialized in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design and implementation.
  • Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces, user .
  • Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
  • Experience in Oracle and other utilities such as TOAD, SQL*Loader, Data Loader, WinSCP and Putty.
  • Strong experience in customizing applications using OAF, Java and ADF.
  • Have very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, Forms Personalization's respectively.
  • Experienced in writing Programs using PL/SQL, and have knowledge on Report builder10g.
  • Involved in Design and Development of Custom Forms in Oracle applications as per client requirements using Form builder10g.
  • Have Strong experience on RICEcomponents.
  • Experience in designing and development of Conversion Programs to load data into R12 in Oracle Applications with effective validation logic and Error handling mechanism .
  • Experience in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
  • Worked on Inbound and Outbound Interfaces to load the data from Legacy systems to R12 using PL/SQL and SQL* Loader and UTL FILE package and vice versa.
  • Areas of emphasis include Purchasing(PO), Inventory(INV), Accounts Payable(AP), Order Management(OM), Bill Of Materials(BOM), Warehouse Management System(WMS).
  • Worked with BI Publisher Reports.
  • Strong knowledge in Procure To Pay(P2P) and Order To Cash(O2C) Cycles.
  • Hands on Experience in OAF.
  • Experience in various development tools like SQL Developer, Toad, SQL*LOADER, Oracle Jdeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i.
  • Have also worked on EBS applications like Credit Risk Management and Beneficiary Management ERP.
  • Hands on Knowledge on ADF and have worked on a POC using ADF.

TECHNICAL SKILLS

ERP: Oracle Applications R12 (AP, PO, INV, OM)

Languages Known: SQL, PL/SQL

Programming: Core Java, OAF,ADF

GUI Tools: Reports 10g, Forms10g

Tools: & utilities: SQL * Loader, SQL * PLUS, TOAD, Putty, ETL (SSIS), Outwit Operating Systems All MS-Windows Versions and UNIX

RDBMS: Oracle 9i/10g, MY SQL, MS SQL

Scripting Language: Html, Java Script, Jquery Mobile

Web Services: Using XML Gateway

PROFESSIONAL EXPERIENCE

OAF Developer

Confidential, San Francisco, CA

Responsibilities:

  • Gather the requirements, analyze and design the technical document.
  • Worked on setting up Jdeveloper environment for custom application.
  • Worked on different framework components such as Sub tab, partial page rendering, advanced table, export button in building the smart application.
  • Worked on framework reports to create the reports based on the client requirement.
  • Worked on Hgrid in creating the Hierarchy tree for the Organization.
  • Conducted detailed review and analysis of requirements of external custom applications.
  • Worked on validation of extended EO of Address region to include additional fields values in the address region attributes.
  • To design the Custom Screens using OAF and implement the client specific functionality.
  • Worked on different BC4J Components for customizations. Extended AM(Application Module), VO(View Objects) and modified the CO(Controllers).
  • Created migration packages to migrate into different environments by creating install UNIX shell script.
  • Worked on adding more fields in expenses review screen of Quote Management module.
  • Maintained detailed technical documentation during all phases of SDLC lifecycle.
  • To do the Custom Reports.
  • To customize the OAF Pages using personalization.
  • To implement the import scripts.
  • To migrate the development changes to production.
  • Worked on VO Extension.

Environment: Oracle Applications R12, Oracle 10G, PL/SQL & SQL plus, BI Publisher, OAF

Senior Technical Consultant + OAF Developer

Confidential

Responsibilities:

  • Import Orders into R12 using Order Import standard Interface - Designed and developed the interface for Orders that loads data into R12 OE Standard tables.
  • Import Customers into R12 using Customer Import standard Interface - Designed and developed the interface for Customer details that loads data from 11.5.10 into R12 Oracle Receivables.
  • Created Tables, Views, Synonyms, Sequences and Indexes.
  • Implementation - Involved in implementing Inventory, WSH, BOM Purchasing, Order Management and Receivables modules in Multi-Org set up, Wheeling division which includes designing, testing and maintaining interfaces from legacy system.
  • Developed SQL * Loader programs to load data from flat file to stage tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.
  • Developed interfaces to load Items and Bills of Material (BOM) coming in flat files from Main Frame.
  • Developed custom reports using XML publisher.
  • Developed an interface to populate data from legacy system to Order Management base tables.
  • Worked on Outbound Programs for orders and shipping, which picks data based on released status.
  • Worked on Order Import interface, to load all the legacy orders in booked status in Oracle.
  • Implemented the Payables Open Interface. Activities involved creation of Loader File, importing Invoices into the interface tables using SQL*Loader and then using Payables Open Interface to import the data into the Base tables.
  • Developed PL/SQL Program to Populate PO Requisition Interface table to import Requisitions.
  • Developed custom interface program to import items from the legacy system to Oracle Inventory by creating staging tables.
  • Developed Migration Scripts using FNDLOAD commands to download and upload LDT’s which is used to migrate all the objects from Dev Instance to test and Production Instances.
  • Responsible for Preparing Technical Design Document (MD70) based on the Functional Requirement specifications (MD50).
  • Registration of Concurrent Programs and Request Sets in AOL and System Administration.
  • Worked with oracle on various bug related issues.
  • Responsible for transition and to User.

Environment: Oracle Applications 11.5.10 SQL, PL/SQL, Reports 10g, SQL*Loader, Forms, XML Reports

Technical Consultant

Confidential

Responsibilities:

  • Designed and developed custom workflow in order entry to keep track of the sales order and sending the notifications when the order is fulfilled.
  • Advise in the development of test scenarios so that appropriate integrated testing is conducted
  • Participate in system testing and resolution of system issues
  • Provide applications knowledge in evaluating and improving current business processes.
  • Work with customers in establishing the appropriate expectation and response time
  • Provide timely feedback to external and internal customers via phone, e-mail, or other form of communication.
  • Support the requirements gathering and validation activities.
  • Support the technical development process to include application configuration.
  • Support the development and documentation of a solution that meets the documented business process and client requirements.
  • Assigning workflows for different transaction types at header and lines.
  • Setting profile options based on the requirements.
  • Adding new customers and updating customer ship to locations.
  • Providing production support related to Order management, Advanced Pricing and Shipping modules.
  • Responsible for the entire order flow from order entry until shipping.
  • Created order management holds through which responsibilities the hold can be applied and released.
  • Defining shipping methods and freight carriers as required.
  • Responsible for creating new attachments and defaulting attachments during sales order creation at various constraints.
  • Maintain defect entries, club them and try to recognize frequently occurring defects, plan systematic approach to minimize and ultimately eliminate those defects.
  • Creating various custom lookups and creating value sets.
  • Working closely with the Business System Analysts in completing the functional requirements document

Environment: Oracle Applications(EBS) 11.5.10, Oracle 10g, SQL, PL/SQL, Reports 10g, SQL*Loader, Forms, XML Reports, BI Publisher, OAF

Associate Technical Consultant

Confidential

Responsibilities:

  • Fine Tuned Conversions and Interfaces.
  • Writing SQL queries according to customer requirement.
  • Understanding customer issues.
  • Analyzing logs and providing remedy to customers.
  • Preparing Unit test.
  • Coding of Forms and functional testing.
  • Writing custom packages and using API’s to develop the interface Programs.
  • Developing Custom Reports in Oracle Applications as per as customer requirements.
  • Preparation of installation Documents.
  • Post Production support.
  • Looking after performance issue.
  • Creating SR with Oracle In case any issue in the product .
  • Helping the users when stuck with transaction flow.
  • Doing the patch impact analysis.

Environment: Oracle 10g, SQL, PL/SQL, Reports 10g, SQL*Loader, Forms, XML Reports

Hire Now