SUMMARY

• Over 8 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:

• Built conversion programs in Procure to Pay process (P2P) to merge data from external system into Oracle AP, AR and GL.
• Developed supplier conversion program to integrate ET system with Oracle AP as a part of P2P process.
• Developed AR receipt inbound interface program to integrate ET system with Oracle AR of O2C process.
• Developed customer conversion program to integrate Extra target system with oracle SFDC.
• Developed AP invoice inbound interface program to integrate invoices from multiple sources into Oracle AP as a part of P2P process.
• Designed and developed Revenue recognition process to improve performance and give accurate current earned, earned and deferred revenue
• Extensively worked on FNDLOAD scripts to migrate concurrent programs, value sets, Request sets, form functions, form personalization etc to various instances.
• Developed interface program to load daily rates into Oracle GL.
• Developed PL/SQL scripts to load data from external system to Fixed Assets(FA) interface tables.
• Developed BU Account Re-class automation program to create journals for re-class Accounts and BU’s.
• Developed Account description translation form for the user to update/insert account description in their local language.
• Developed an automation shell script program to FTP files from Workday to Applic8 and archiving into SFDC.
• Customized oracle standard General ledger account analysis report, FA Depreciation report, and Asset Inventory report using XML Publisher.
• Created a new report to capture errors during AGIS and intercompany transactions using XML Publisher.
• Successfully designed and implemented the Purchase Orders Open Interface. Activities involved creation of control file, porting PO HEADERS, PO LINES into the PO HEADERS INTERFACE and PO LINES INTERFACE tables and then used Import Standard Purchase orders concurrent program to port the data into the Oracle base tables as a part of P2P process.
• Developed a shell script for download/upload the file from FTP server and to encrypt and decrypt based on the transfer.
• Created new reports for secondary ledger balance reports using XML publisher.
• Created concurrent programs and attached it to a request set to run the program based on the successful completion of the other.
• Created incompatibility option at ledger level so as not to run the bu account re class program if revenue recognition program is running at that particular ledger in system administrator.
• 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, CM, PO, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports, BI/XML Publisher, JDeveloper, UNIX, SQL Loader, Putty, WinScp, TOAD, SQL*Developer.

Confidential, Philadelphia PA

Oracle Technical Consultant

Responsibilities:

• Developed Purchase order, Item conversion program to load Purchase orders in PO and Items in INV.
• Developed scripts to fetch transaction information related to Procure to Pay (P2P).
• Developed multiple custom reports in Procure to pay (P2P) like India withholding custom report to identify invoices, which are being processed and paid.
• Developed conversion program for loading Internal banks in CM and external Banks in AP and AR.
• Developed credit card interface program to create credit card and assign it to customer profile in AR.
• Developed shell scripts to migrate the conversion objects from one instance to other instance through Unix.
• Developed GL code combination program to get newccid with appropriate segments.
• Worked on customizing existing reports.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, XML Publisher, UNIX, SQL Loader, Putty, WinScp, TOAD, SQL*Developer.

Confidential, Houston, TX

Oracle Techno Functional 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.
• Worked extensively on OAF personalization to restrict the user to update the oaf page.
• Worked on OAF personalization to default values based on other fields.
• Worked on OAF personalization to remove links on workflow page.
• Worked on OAF personalization to create button exporting the contacts on Suppliers.
• Worked on Data Loader to load Source meter for Rebuild able Assets.
• 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.
• Prepared FNDLOAD scripts to migrate Concurrent Programs, Value Sets, and Personalization etc. between various environments.
• 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 Open Routing and Resource Interface for Bill of Material Interface to launch the Bill and Routing Interface program (BMCOIN) from the import Bills and Routings form in Oracle Bills of Material.
• 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.