SUMMARY

• Having Over 7 years of professional experience as Oracle Applications R12/11i (E - Business Suite) Technical Consultant with expertise in Oracle Financials modules(GL, AP, AR), Manufacturing Modules(BOM,INV,PO,SHIPPING,OM) .
• Good knowledge on business flow’s in Procure-to-Pay, Order-to-Cash cycles.
• Technically proficient in RICEW (Reports, Interfaces, Conversions, Extensions, workflows) Components.
• Proficient in Design and the Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Well Versed with Oracle Database Constructs to include: Database Triggers, Stored Procedures, Functions, collections, records, views, materialized views and Packages using PL/SQL.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Expertise in System Administration in oracle application activities to include user setups, defining responsibilities, request groups, value sets, registering, menus, forms, reports, Concurrent programs and providing support to apps users for any technical and functional issues.
• Solid Knowledge and understanding of AOL/FND architecture and Applications.
• Customized existing forms appearance and incorporated new functionalities. Developed new forms using Template.fmb as per client specifications. Very good experience in creating and personalizing custom built Forms using custom.pll and template.fmb.
• Experience using project management tools such as AIM Methodology, Microsoft Project and Visio.
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Hands on Experience in developing Workflows using workflow builder and customized various standard Oracle Workflows. Few of them are PO Approval, INV Approval, OE Headers, OE Lines and others.
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specification.
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template and Oracle Reports data template.
• Experienced in Developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV060) and Migration documents (MD0120).
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Good working experience with Service Desk (Assigning Tickets and entering work log and tracking the status of a Defect and update Service Desk).
• Possess strong technical skills and business knowledge coupled with product knowledge in Oracle E-Business Suite.
• Interact with people at all levels and also have Onshore/Offshore Co-ordination. Possess excellent communication and problem solving skills, and work ethics.

TECHNICAL SKILLS

ERP: Oracle Applications EBS R12, 11i

Databases: Oracle Database 9i, 10g, 11g

Languages: SQL, PL/SQL, Java, HTML, JavaScript, XML, UML

ERP Processes: Order-2-Cash (O2C), Procure-2-Pay (P2P)

Technical Applications: Oracle Workflow, AOL and SYSADMIN

Financial Applications: GL, AP, AR

Supply Chain Applications: PO,OM,INV

Manufacturing Modules: BOM

Reporting Tools: Developer 2000, Discoverer, and XML Publisher

Development Tools: TOAD, SQL*Plus, SQL Developer

Operating System: Windows, UNIX

Version Tool: PVCS

Other Tool: Visual Source Safe,WINSCP,PUTTY

Multimedia: Flash, Adobe Photoshop, Dream Weaver

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Developed custom interface program to load data from external system into AP Interface tables and create AP invoices.
• Involved in the development of RICE components in Oracle Inventory, Purchasing, Account Payables, and General Ledger.
• Created loader file, porting invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface Import to import the data into the actual tables.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid AP Invoices and for populating the AP interface tables and called the seeded import programs to populate the base tables.
• Designed, Documented (prepared MD70 Technical Specification Document) and developed Conversion process for Suppliers, Supplier Sites, Master files, Open Purchase Orders, and Reports.
• Developed Extracts in PO, GL module and the extracted files are sent via SFTP to other systems using the UNIX Shell Script.
• Developed SQL*Loader scripts to load data from Legacy systems into custom staging tables.
• Loaded the data into the MTL SYSTEM ITEMS-INTERFACE and then the standard item import was executed to load data into the Oracle Inventory.
• Developed Inventory “Items Conversion” & “Items Category Conversion program” to load Inventory data from into interface tables.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Involved in the Setup of Payments Terms, Batch Source, Payment Methods, Transaction Types and others set ups required for conversion of Customers and Invoices.
• Customized Reports in OM, Inventory Module.
• Involved in troubleshooting errors, fixing the bugs and fulfilled the new business requirements.
• Created UNIX Shell Scripts for automating programs, data loading and interface process in Custom and Oracle Applications.
• Authored UNIX scripts to download LDT files for many components, such as concurrent programs, requests sets, forms, functions, request groups etc.
• Interacted with Business Leads to resolve any issues during the production, development and enhancement phases.
• Worked on physical data modeling and involved in developing database by PL/SQL, functions, procedures, triggers, packages and materialized views, used tables, objects, error handling, shell scripts of UNIX for execution process.
• Used SQL Loader and UTL file packages for data conversion and interfaces.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Used EXPLAIN PLAN, ANALYZE, HINTS, Indexes to tune queries for better performance and also e.
• Wrote UNIX Shell Scripts for copying and moving files to and from the server.
• Extensively worked on FND LOAD utility for migrating objects between different instances. Download various LDT files for components such as concurrent programs, requests sets, forms, functions, request groups and uploaded to other instances.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Used Forms Personalization created a special trigger in sales order for booking according to user requirements.
• Used Custom.pll to make KFF/DFF mandatory and restrict updating based on order line status, item categories, flex fields and quality plan.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Zoom feature is enabled using custom.pll, and whenever user in Quote order form clicks the zoom button. It displays the discount amount calculated for that order basing on the pricing attributes of that order.
• Developed Application Development Framework Model components (creation, configuration, and tuning of entity objects, view objects, application modules, bindings and data controls).
• Performed UNIT testing on the codes developed and provided extensive support during the user acceptance and regression testing phases of the project.
• Followed (MD50) functional documents and written the technical (MD70) specifications for Interfaces and Reports.

Environment: Oracle Applications EBS R12/11.5.10 INV,OM, BOM, WSH,(GL, AR, AP, PO), SQL, PL/SQL, Oracle Forms 10g/6i,Reports BI/XML Publisher, UNIX, SQL* Loader, TOAD, SQL*Developer.

Confidential, Columbus, OH

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Worked on Order import using Order Management OE ORDER PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data and populated the data into base tables.
• Developed PL/SQL scripts to load order data from external system to Supply Chain Module( OM) interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL)
• Developed Customer Interface in Receivables worked with various HZ tables, Interfaced data from the Flat Files into Interface tables of Oracle Receivables using SQL*Loader, Validated and imported the data into AR base tables using Oracle standard Customer Import Program.
• Involved in designing of Conversion/Interface Implementation Strategy for Accounts Payables and Accounts Receivables.
• Developed a program to generate positive pay file for each bank account using PL/SQL and send it to the bank using a shell script in Payables (AP).
• Used Import Standard Purchase Orders and Receiving Transaction Process interface programs to create purchase orders and receipts in Oracle Purchasing
• Designed bank statement reconciliation with Accounts Payable and Accounts Receivable transaction as part of Cash Management Implementation.
• Involved in processing of Bank Receipts using Auto Lockbox. Defined and customized Auto Lockbox in AR.
• Involved in Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.
• Customized the PO Receipts form using custom.pll for dynamic generation of locator while receiving Purchase Orders.
• Customized the existing forms with descriptive flex fields.
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client.
• Converted Order Detail Report, Credit Order Summary Report and Orders by Item Report in Order management from reports 6i to BI publisher.
• Modified existing reports by creating additional joins. And Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Created output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Created Staging tables to load legacy data, generated Control files and SQL*Loader scripts and registered them as concurrent program for data loading into the staging tables.
• Developed design and implementation documents such as MD050, MD070.
• Extensively worked on Service Center ticketing system to identify assigned issues. Used version control and Code migration software as of when required.

Environment: Oracle Applications 11.5.10, Oracle 10g, Forms 6i, Reports 6i, XML Publisher, SQL*Loader, TOAD, UNIX, PLSQL, SQL Plus.

Confidential, Los Angeles, CA

Oracle Apps developer/Technical Consultant

Responsibilities:

• Involved in system study, requirements analysis and design documentation.
• Prepared technical specifications document (MD70) based on the functional requirement specifications (MD50).
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables.
• Performed Extensive Application tuning for Procure to pay business process.
• Developed and implemented AP Invoice interface. This involved importing data from the legacy system into staging tables using SQL*Loader, validating the data using PL/SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Involved in Development and Implementation of Customer Interface using TCA APIs, to bring customers into Oracle AR which are created in Legacy system, on a Daily basis.
• Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Designed and developed Bill and Routing Interface by dumping the data files into the BOM base tables.
• Used Standard Import Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing.
• Imported the customers into Oracle Receivables using the CUSTOMER IMPORT form with in oracle applications.
• Imported customer data into Oracle Receivables tables using TCA APIs.
• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, collections, records, views, materialized views and Packages using PL/SQL.
• Worked on building Business Areas, Discoverer Workbooks and Parameterized reports using Discoverer.
• Created business areas, custom folders, summary folders, hierarchies and item classes in Discoverer Administration edition.
• Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared the workbooks with the designated users only.
• Creation of new custom reports and customizing of existing reports using Oracle XML Publisher.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP, and PO modules.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Oracle Reports Builder 6i.
• Designed and customized reports like New Customer Setup Report and Contract Price List Report using Discoverer 10g.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer
• Involved in the tuning of 11i applications (includes PL/SQL, SQL scripts) using Explain Plan and TK Prof.

Environment: Oracle Applications 11.5.10, Oracle 10g, Discoverer, Reports 6i, XML Publisher, SQL*Loader, TOAD, UNIX, PLSQL, SQL Plus.

Confidential, San Clemente, CA

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Implementation of Oracle Accounts Payables to its integration with PO and GL.
• Worked towards Future business flows, Identification of Gaps, Workarounds in order to provide an Integrated Procure to Pay (P2P) business flow.
• Developed Custom Programs to load Data item into Interfaces in Account Receivables (AR).
• Performed Setup steps, defined various Descriptive Flex fields for Financial Modules AP, AR, GL.
• Responsible for changing existing forms and reports of Customized Account Receivables (AR).
• Creating and Approving AR Invoices.
• Define user responsibilities, set up custom menus based on user responsibilities during Procure to Pay (P2P) implementation.
• Worked as a liaison between the Key Users and Headquarters in order to understand corporate requirements.
• Involved in purchase order to insert data into interface tables and validating the data.
• Developed new forms for single and multiple table and blocks, made use of menus, alerts, attributes and libraries to make interface user friendly.
• Involved with Production support and troubleshooting at different stages of the project.
• Data migration from Legacy systems - APIs and Open Interfaces.
• Analyzed e-Business Suite system configuration and development changes using Gap analysis.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists).
• Provided Tier III technical support to work on complex problems of diverse scope and will assist in troubleshooting and fixing system and application problems.
• Worked on assessing XML publisher reports for batch reporting needs.
• Developed a XSL template for customizing the AR Sales profit report using XML /BIPublisher and distribute the offer document generated from XML Publisher.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data and Customer Bank data.
• Wrote technical design documents MD-70 for conversions, extensions, interfaces, and reports.
• Involved in troubleshooting issues including creation/follow-up of Oracle service requests (SRs). Conducted quality reviews of code developed by other development staff.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.

Environment: Oracle Applications 11.5.10, Oracle 10g, Reports 6i, XML Publisher, SQL*Loader, TOAD, UNIX, PLSQL, SQL Plus.