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