SUMMARY

• Over 7 years of experience with Oracle Applications R12 (12.1.3) and 11i (11.5.10, 11.5.9, 11.5.8) E - Business Suite.
• Good expertise in Oracle financials modules (AP, AR, GL, CM) and manufacturing modules (OM, INV, PO), AOL and System Administrator.
• Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) process flow.
• Very good understanding of Trading Community Architecture (TCA).
• Good expertise in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experience in developing new forms with great complexity and customizing standard Oracle forms.
• Expertise in Design and Development of Interfaces and Conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Expert knowledge in Oracle Inventory, Discrete and Process Manufacturing and Oracle Advanced Supply Chain Planning (ASCP) including understanding of table structures and integration with OPM Planning.
• Expertise working with Oracle 10g/9i/8i, Developer 2000, Forms 10g/6i, Reports 10g/6i/4i, Discoverer 10g/9i/4i and XML/BI Publisher.
• Strong analytical and technical skills with good programming experience in SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting.
• Experience working on Application Object Library (AOL) and System Administration Responsibilities such as registration of concurrent programs, creations of Users, Responsibilities, Forms, Functions, Menus, Value Sets and Flex fields in Oracle Applications.
• Experience in working with on client site and off shore team.
• Exposure to all phases of the process oriented System Development Life Cycle (SDLC), including working with the business analysts and software development teams to ensure a clear understanding of the requirements.
• Expert in using UTL FILES, Export, Import, SQL*Loader Utilities, FTP, TOAD.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70) and Agile Methodologies.
• Thorough understand of source-code repositories, Version control tools and migration activities.
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through the projects from inception to completion.

TECHNICAL SKILLS

Oracle Application: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, CM, AOL and System Administration.

Application Tools: Reports 6i/10g, Discoverer 4i/9i/10g, BI/XML Publisher 5.6.3/5.6.2 , Oracle Forms 6i/9i/10g, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle JDeveloper, OA Framework.

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS.

Languages: SQL, PL/SQL, Web PL/SQL, C, Java Script, Java, HTML, XML.

Scripting Language: UNIX Shell scripts, Python, Perl.

RDBMS: Oracle 8i/9i/10g/11g, Access, SQL Server 2000, MySQL.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Oracle Financial Developer

Responsibilities:

• Developed supplier conversion program to integrate ET system with Oracle AP.
• Developed AR invoice automation to integrate ET with Oracle AR.
• Updated Oracle Inventory item on-hand quantity from legacy systems
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Extracting the data from flat file that are used for Customers, Customer Orders, Inventory.
• Worked on Customer Item Open Interface in Inventory (INV) Module.
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus.
• Used PL/SQL tables, array structures as a part of oracle collections.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed custom interface program to load Inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
• Worked on Material Transaction Conversion and Interface programs to merge the lot numbers with Item in Oracle Inventory (INV).
• Used Pricing APIs to attach pricing attributes that is derived to the Orders imported from legacy systems
• ImportedBOMdata from Legacy system to Oracle throughOpen BOM Interface.
• This process includes loading data from flat file to temporary table using theSQL * Loader, validated the temporary table data and moved to the Interface table.
• Developed WIP Job conversion, to bring in all the work orders that are created by the legacy System.
• Customized existing forms to add search criteria on descriptive flex fields.
• Fixing bugs in forms and reports previously designed.
• Created a new report to capture errors during AGIS and intercompany transactions using XML Publisher.
• Developed a shell script for download/upload the file from FTP server and to encrypt and decrypt based on the transfer.
• Developed a common generic file download program to download file from FND lobs and load data into respective tables using sql loader.
• Created new reports for secondary ledger balance reports using XML publisher.
• Customized page torender and hide fields conditionallybased on the requirements provided by user.
• Extend and personalizeexisting web pages, specificallyediting field contents, adding new itemsandraising error messages.

Environment: Oracle Apps EBS R12.1.3, AP, AR, GL, OM, PO, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports, BI/XML Publisher, JDeveloper, UNIX, SQL Loader, Putty, WinScp, TOAD, SQL*Developer.

Confidential, Greenville, SC

Oracle Technical Consultant

Responsibilities:

• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed shell scripts to migrate the conversion objects from one instance to other instance through Unix.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API.
• Converted Order Detail Report, Credit Order Summary Report and Orders by Item Report in Order management from reports 6i to BI publisher.
• Developed conversion program to load AP suppliers from 11i to R12.

Environment: Oracle Apps EBS R12.1.3, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports,AP, AR, OM, XML Publisher, UNIX, SQL Loader, Putty, WinScp, TOAD, SQL*Developer.

Confidential, Houston, TX

Oracle Application Developer

Responsibilities:

• Worked extensively on form personalization to call one form another form as per client requirement.
• Worked on form customization to modify the lov on the person form in payroll responsibility at user level to restrict some functions.
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Worked on Order to Cash Cycle, starting from enter order stage to move order stage followed by the ship confirm and updating the GL.
• Developed programs to load data from staging tables into BOM Interface tables.
• The major Customizations include the Customization of OM, INV processes, Order management Workflows, to do various checks on the Order that transition along the Order to Cash cycle,
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of database.
• Did SQL and PL/SQL programming for ODI and oracle.
• Loaded data from Sql server into to database tables using dblinks.
• Loaded data from flat files into Oracle staging tables using SQL* Loader.
• Involved in designing database, developing PL/SQL and maintaining database.
• Worked extensively on Optimizing sql queries.
• Extensively involved in table design and creating DDL scripts, performance tuning using explain plan etc.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created ODI packages, scenarios using interfaces, variables, procedure.
• Developed interface program to load Suppliers from Legacy system into Oracle base tables.
• Developed interface program to load purchase order from legacy system into Oracle base tables.
• Worked on Enterprise Asset Management module to bring the data from legacy system as per the conversion requirement.
• Worked intensively on Responsibilities, Menus, Functions and profile options to give security.

Environment: Oracle Apps EBS R12.1.3, PO, EAM, SQL, PL/SQL, Oracle Reports 10g, Oracle Forms 10g, Oracle JDeveloper 10g, UNIX, SQL Loader, PlSql Developer, Secure CRT, FileZilla, Data Loader, WinScp, Microsoft Sql Server Management Studio, Tortoise SVN, TOAD, SQL*Developer.

Confidential, Beaverton, OR

Oracle Application Developer

Responsibilities:

• Developed Customized standard Oracle Applications reports and developed custom reports in OM, BOM, WSH and INV modules.
• Worked on Discrete process Manufacturing.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program in Oracle Apps EBS R12.
• Developed PL/SQL Packages to validate data for BOM Interface to import BOM into Oracle base tables from the legacy system.
• Extensively worked on Unix shell script.
• Customized pick slip, packing list reports based on functional specification.
• Extensively worked on Forms Personalization to handle the form customizations as per Client’s requirement.
• Customized various BI/XML Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Used the Totals/Subtotals/group/sort features of BI/XML Publisher to make data intense operations happen at the template level.
• Transfers the application objects (AOL) like responsibility, request group, request set, value sets, menu, users, key flex fields, descriptive flex fields, and lookup codes using FNDLOAD.
• Involved in production support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management & Users.
• Developed materialized views in on GL.

Environment: Oracle Apps Financials EBS R12 and EBS 11.5.10.2 GL, PO, INV, BOM, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, P4V, Team Track, TOAD, SQL*Developer.

Confidential, Austin, TX

Oracle Application Developer

Responsibilities:

• Involved in customer conversion from Legacy system into Oracle Account Receivables by using customer interface with the help of off shore team.
• Involved in Auto invoice interface to load invoices automatically from Legacy systems to Oracle Receivables to interface tables.
• Involved in development on Interfaces to convert the data from the legacy system.
• Developed several Discoverer reports as per the client requirements.
• Developed reports by adding frames, repeating frames and formula columns.
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Built custom reports using Oracle Report Builder and integrated them with the application (based on descriptive flex fields) to solve the clients reporting needs.
• Involved in creating workflow and assigning alerts to the workflow.
• Built custom forms using Form Builder to fulfill business requirements of the clients.
• Customized existing forms to add search criteria on descriptive flex fields.
• Fixing bugs in forms and reports previously designed.
• Extensive use of PLSQL programming like procedures, functions, triggers & packages and used dynamic SQL in stored procedures.
• Responsible for creating value sets required for the additional parameters.
• Used SQL Loader and UTL file packages for data conversion and interfaces.
• Developed customer conversion program to load the customers from legacy system into Oracle EBS System by using the TCA APIs.
• Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.
• Developed SQL *Loader Scripts to load data into staging tables.
• Created and registered Concurrent Programs and Request Sets required for all the conversions in Oracle R12.
• Provided various validations such as purging previous data, checking for duplicate files, validating input data, updating invalid data, formatting input data and transferring data from custom staging table(s) to interface table(s) such as GL INTERFACE.
• Created some Periodic Alerts, Event Alerts in Oracle EBS R12 as per the customer requirement.
• Worked extensively on inventory turns report using BI/XML Publisher.
• Wrote UNIX Shell Scripts for copying and moving files to and from the server.
• Developed design and implementation documents such as MD070, MD120 and user documentation.

Environment: Oracle Apps Financials EBS R12 and EBS 11.5.10.2 (GL, AR, AP), PO, INV, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, P4V, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential, Upper Saddle River, NJ

Oracle Application Developer

Responsibilities:

• Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
• Design and documentation of conversion strategy to convert data from legacy system into all the financials, manufacturing and HR modules.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Personalized many Oracle standard Forms as per the Client requirements.
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version R12.
• Developed reports in Payables to send a Notification to AP/Buyer/Requestor of Invoices on Hold.
• Developed a custom OA Framework (OAF) jsp page to print shipping labels using JDeveloper 9i.
• Developed custom OA Framework pages using OAF components like: LOV, Show/Hide Region, Advanced Table, and simple Search Region.
• Developed Invoice Import Program to load Invoice and Invoice Lines into the tables in AP (Payables).
• Designed Invoice Received and Approval Hold (with 2/3/4 way matching) in Payables based on Client Specification using BI Publisher.
• Developed Open Purchase Requisitions, Blanket & Contact Notifications in Purchasing Module.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Oracle Inventory provides Customer Item Open Interface to easily import Customer Items from external systems to Oracle Applications.
• The Customer Items Interface reads each record from the interface table and adds the validated items to Oracle Inventory.
• Developed AP Invoice Interface to upload items into the Oracle Payables.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
• Involved in migrating the data into Oracle Apps from the Excel Sheets using open interface / API, Oracle utilities and third party tools (Data Loader)
• Developed various technical components like SQL, PL/SQL, Procedures, Functions, Packages, views, and materialized views, Collections for Forms, Reports, Interfaces and Conversions.
• Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.
• Developed several Procedures and Database Triggers as per Business requirement.
• Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script.
• Documented all the above-mentioned processes with MD050 and MD070 using AIM methodology.

Environment: Oracle Apps Financials EBS R12 (GL, AR, AP), PO, INV, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, P4V, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential, New Jersey, NJ

Oracle Application Developer

Responsibilities:

• Design, Development and Implementation of complex business custom extensions for Oracle Financial, Manufacturing modules.
• Designed and recommended solution for custom processes flow integrated with standard applications.
• Involved in Customization of Cancelled Orders Report, Orders Summary Report.
• Involved in Open Sales Order conversion based on client specifications.
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Developed interface program for Customer interface by using the standard API’s
• Developed Registration Scripts for moving objects from one environment to another.
• Created new responsibilities and involved in defining the required system profile options.
• Wrote custom code with validations to transfer the data from staging table to interface tables.
• Developed Customer Data Import program for data loading from different systems to oracle TCA tables.
• Expertise in Oracle Discoverer in Creating various business areas, user views, custom folders and joins for reporting.
• Developed various custom business areas by using the Discoverer for various modules.
• Created complex folders and created Item Classes.
• Migrated Business Areas/Item Classes/Hierarchies from one Instance to the other.
• Involved in Unit Testing and Performance Testing for reports.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
• Performed unit, system, integration testing with reference to interfaces to non-oracle applications
• Created and have setup Resources using public packages.
• Responsible for techno design documentation of the reports.

Environment: Oracle Apps 11i General Ledger, Order Management, Inventory, Accounts Receivables, System Administrator, Oracle 8i, Reports 6i, Discoverer 4i, SQL, PL/SQL, SQL*Loader, Sun Solaris OS 2.8, Unix Shell scripting, PVCS.

Confidential

Oracle Database Programmer

Responsibilities:

• Performed System Study, Design, Development and Implementation of the system.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using SQL*Plus Editor.
• Developed Forms like Invoicing, Delivery Order, Quotation, Stock Inwards, Stock outwards, adjustments etc.
• Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
• Fixing Bugs in Forms and Reports previously designed.
• Designed menus and responsibilities to different level of users in the organization.
• Documented the business flowchart, user manual and technical manual.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using SQL*Plus.
• Development of screens in forms using oracle at backend according to the requirements of Clients.
• Developed forms and reports as per the requirement of the system.
• Extensive use of pl/sql programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.

Environment: Oracle Applications 10.7, Oracle Database 8i, PL/SQL, SQL*Plus, SQL*Loader, Forms 4.5, Reports 2.5, Windows NT, UNIX