SUMMARY

• Over 10 + Years of professional experience as Oracle Apps Techno - Functional Consultant ( 60 / 40) in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications R12/11i spreading across Implementations, Version upgrades, Data conversions.
• Extensive Technical and Functional expertise in Oracle Applications R12/11i SCM modules OM, INV and PO.
• Extensive Technical Expertise in SCM and CRM Modules INV, OM, PO, Install base and service contract.
• Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle General Ledger, Accounts Payables, Accounts Receivable, Fixed Assets, Purchasing, Order Management, Inventory modules.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces and user training.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Customization) using tools like PL/SQL, SQL*Plus, Oracle*Forms 10g/6i/4.5, Oracle*Reports 10g/6i, Workflow, SQL*Loader, UNIX shell scripts.
• Extensive Industry Experience in implementing and testing Order-to-Cash (O2C) and Procure-to-Pay (P2P) Business Process flow.
• Proficient in creating menus, responsibilities and any system administrator functionalities. Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL and Adv. PL/SQL.
• Experience in creating and customizing existing reports using BI and Reporting Tools like Oracle Discoverer, Reports 10g/6i/4i and XML/BI Publisher tool.
• Experience in converting the standard Oracle reports to a more fancier reports using XML publisher
• Extensive experience in Conversions and interface coding for various modules and Performance tuning
• Expertise in preparation of AIM Methodology Documents like MD70, MD120, TE120, CV40, CV60,CV70 and CV120.
• Involved in various testing phases (unit testing, functional, integrated, volume and user acceptance) of implementation projects and Go-Live activities like Technical checkout, doing functional setups and components functionality checkout by executing couple of key test cases in existing production environment.
• Extensive experience in Implementation/Support/Upgrade of various Oracle Applications releases.
• Developed Interfaces/Conversions (inbound and outbound) using Open Interfaces and API’s. Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client’s requirements. Customized seeded forms using forms personalization and CUSTOM pll
• Performance Tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan.
• Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs and migration tool KINTANA and FNDLOAD script.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Very Good understanding with Trading Community Architecture (TCA).
• Excellent analytical, problem solving, communication and interpersonal skills with the ability to interact with individuals and teams at all levels.

TECHNICAL SKILLS

Application Technology: Oracle Applications 11i & R12

Modules: OM,PO,INV,BOM,WIP,AP, AR, eBilling and Install Base

Languages: SQL / PLSQL, C, Java

Database / RDBMS: Oracle 8i, 9i,10g,11g

Tools: TOAD, PUTTY, Win SCP, KINTANA, FTP, SQL * Loader, Data Loader, XML Publisher, d discoverer, Oracle Forms and Reports 6i and 10g,QC,Service Now, PVCS,VSS and CVS.

Operating Systems: MS Windows 2000,Windows server 2003, Unix, Linux and Solaris

Graphic tools: MS Visio

Document tools: MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Houston

Techno Functional SCM Consultant

Responsibilities:

• Provide On-Site support to the Client in resolving Cases (issue). Also create new Service Requests or if necessary in Meta-link to solve the issues by applying additional Patches if required.
• Re-designed Buyer assignment interface program to improve the performance.
• Developed GL Submit Syteline Import Journals interface.
• Technical Design Documents and reviewed other TD's.
• Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUEST.
• Solved functional based queries from user.
• Functional setups includes ( Lookups, Employee details modifications, Buyer, Sales persons )
• Profile Options Change\Update ( Some extent like Application level and Responsibility level)
• Worked on outbound, inbound interfaces and customized packages in all modules for bug fixing.
• Worked on form personalization and report customization using Report 10g.
• Worked on XML publisher reports Enhancement.
• Monitored and bug fixing on Vpay and ebilling customize interfaces.
• Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and package.
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions in database tier.

Environment: Oracle e-Business Suite 12.1.3, OM, INV, PO, BOM, WIP, GL, AR, AP,eBilling,PA, PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms 10g, Oracle Reports 10g, Data Loader, SQL loader,WINSCP,Kintana,CVS,Service Now.

Confidential, CA

Technical Consultant

Responsibilities:

• Worked on rebuilding the Interfaces and Customizations on OM and WSH modules.
• Analysis and design strategy for conversion of Legacy Data into Oracle R12 Project Accounting (PA) module.
• As an Oracle Technical consultant responsible for Enhancements and Production support of RICE components in OM, WSH with Oracle Forms 10g and Report 10g.
• Performed several setups in Inventory (INV), Order Management (OM) and Shipping (WSH) modules.
• Worked on testing the flow of Order to Cash and Procure to Pay cycles.
• Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
• Validation and code fixing of all database objects in Oracle Applications R12 OM and WSH modules.
• Customized standard Oracle Reports by adding extra field or extra parameter to sort data in a report for order and shipment Modules.
• Developed reports and data extracts in OM, WSH.
• Worked on oracle standard API using PL/SQL in Order Management and advanced pricing modules.
• Developed Finance Reports like: Comparative Sales Report, Daily Sales Report using Reports 10g.
• Performance Tuning of Custom PL/SQL Packages.
• Developed SQL queries to compare summary information of the standard and custom reports in Order Management.
• Performed SIT (System integration testing), End to End testing and supporting UAT (User Acceptance testing)

Environment: Oracle Applications EBS 10g/11.5.10/R12 (PO, OM, WSH and INV), Reports 6i/10g/11g, Forms 6i/10g/11g, SQL* Loader, OAF, QC, PL/SQL, Workflow builder 2.6, XML publisher, TOAD, Windows XP, WINSCP, Kintana, PVCS.

Confidential, CA

Oracle Applications Technical Consultant

Responsibilities:

• Technical Consultant to implement deliverables on Oracle Application11i including legacy data conversions into OM modules, custom reporting using Oracle Reports.
• Involved in complete life cycle of Order to Cash O2C Business flows
• Prepared technical and Unit Test Case (UTC) design documentation
• Developed item conversion to load data about the Items form legacy system into oracle applications by writing SQL loader scripts and PL/SQL scripts.
• Involved in optimizing the performance of database objects
• Designed Technical specs in MD 70 using Standards AIM

Environment: Oracle Applications EBS 11i (OM, INV, WSH, AR, GL), Reports 6i, Forms 6i, SQL* Loader, PL/SQL, TOAD, Windows XP, PVCS, Kintana, Winscp and QC.

Confidential, CA

Technical Consultant

Responsibilities:

• Developed RMA interface using standard API.
• Developed and Enhancement of PL/SQL Packages, Procedures, Functions for validating the RMA process from the legacy system and imported into Oracle Applications.
• Involved in Custom.pll and Form personalization.
• Tuned the reports to improve performance.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Environment: Oracle Applications EBS Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL, Forms 6i, Reports 6i, PVCS, Kintana, Winscp, SQL*Loader, QC Windows XP and UNIX.

Confidential, CA

Oracle Apps Technical Consultant

Responsibilities:

• Customization and enhancement for existing reports and interfaces in the modules of Install Base and Order management.
• Developed Contract, Status conversion.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Creation of value sets and Fnd lookups in various modules of the application.
• Performance Tuning of the complete oracle objects using TKPROF and Explain Plan.

Environment: Oracle Applications EBS Implementation Release (11.0.3), SQL, PL-SQL, Forms (4.5), Reports (2.5), Putty, WinSCP 3, FTP, Windows XP and UNIX.

Confidential, CA

Oracle Applications developer

Responsibilities:

• Involved in writing Packages and Procedures for Conversion of data from legacy System to Oracle Base tables.
• Responsible for Registering Reports as Concurrent Programs and created value sets as parameters as per the requirement.
• Created tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and triggers.
• Expertise in using SQL * Loader to extract data from flat files.
• Involved in writing Data Conversion programs for importing data from Legacy System to Custom Tables.
• Responsible for developing PL/SQL Procedures, Functions, Packages, Cursors and Triggers.
• Developed stored procedures using advanced PL/SQL Packages, Nested Tables, Index Tables, Arrays, Record Types, and Dynamic SQL.
• Expertise in using Oracle Advanced Collections like BULK Collections and Bulk Binds in improving the performance of the programs.
• Preparation of Documentation for developed objects helpful for end users.
• Interacted with Business Users in solving technical issues.

Environment: Oracle Applications Release 11.5.4, Service Contact, OM, Oracle 8i, UNIX, Forms 6i/Reports 6i, PL/SQL,, TOAD, SQL Plus,Kintana, PVCS, QC.

Confidential, CA

Oracle Applications developer

Responsibilities:

• Responsible for Registering Reports as Concurrent Programs and created value sets as parameters as per the requirement.
• Created tables, Sequences, PL/SQL Stored Procedure.
• Expertise in using SQL * Loader / External Table to extract data from flat files.
• Expertise in using Oracle Advanced Collections like BULK Collections and Bulk Binds in improving the performance of the programs.
• Preparation of Documentation for developed objects helpful for end users.
• Responsible for Customization of new forms for File upload process form using forms 6i
• Responsible for Register those forms in apps.

Environment: Oracle Applications Release 11.5.4, Service Contact, OM, Oracle 8i, UNIX, Forms 6i/Reports 6i, PL/SQL,, TOAD, SQL Plus,Kintana, PVCS, QC.

Confidential, CA

Oracle Applications developer

Responsibilities:

• Responsible for Registering Reports as Concurrent Programs and created value sets as parameters as per the requirement.
• Created tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and triggers.
• Expertise in using SQL * Loader to extract data from flat files.
• Involved in writing Data Conversion programs for importing data from Legacy System to Custom Tables.
• Responsible for developing PL/SQL Procedures, Functions, Packages, Cursors and Triggers.
• Developed stored procedures using advanced PL/SQL Packages, Nested Tables, Index Tables, Arrays, Record Types, and Dynamic SQL.
• Expertise in using Oracle Advanced Collections like BULK Collections and Bulk Binds in improving the performance of the programs.
• Preparation of Documentation for developed objects helpful for end users.
• Interacted with Business Users in solving technical issues.

Environment: Oracle Applications Release 11.5.4, Service Contact, OM, Oracle 8i, UNIX, Forms 6i/Reports 6i, PL/SQL,, TOAD, SQL Plus,Kintana, PVCS, QC.

Confidential, Nashville

Oracle Applications developer

Responsibilities:

• Responsible for Registering Reports as Concurrent Programs and created value sets as parameters as per the requirement.
• Created tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and triggers.
• Involved in writing Data Conversion programs for importing data from Legacy System to Custom Tables.
• Responsible for developing PL/SQL Procedures, Functions, Packages, Cursors and Triggers.
• Developed stored procedures using advanced PL/SQL Packages, Nested Tables, Index Tables, Arrays, Record Types, and Dynamic SQL.
• Expertise in using Oracle Advanced Collections like BULK Collections and Bulk Binds in improving the performance of the programs.
• Preparation of Documentation for developed objects helpful for end users.
• Interacted with Business Users in solving technical issues.

Environment: Oracle Applications Release 11.5.4, WIP, OM, Oracle 10g, UNIX, Forms 6i/Reports 6i, PL/SQL,, TOAD, SQL Plus,Kintana, PVCS, QC.

Confidential

Oracle Applications developer

Responsibilities:

• Development of forms and reports like Product lines, Material types, Reason code, Freight Type and Fright bill type Etc for set up tables and PO, PO Receipt and PO Return Reports.
• Enhancement of PO, PO Receipt, PO Return and PO Requisition form.
• Developed forms like QC Inspection, DMR, Corrective and preventive action, Auto timecards and material master.
• Developed Reports in sales like customer labels, delivery labels
• Enhancement of All module Reports.
• Responsible for creating BI Reports.
• Involved in the architectural changes in system.
• Responsible for Creating Tables, Views and Sequence.
• Responsible for Creating Packages, Stored Procedure Triggers and modification of the existing objects.
• Involved in Confidential Portal bug fixing using Oracle Express.
• Providing application maintenance and enhancement support to the clients.

Environment: Forms6i, Reports6i, PLSQL Developer, Toad Oracle Express and Discoverer 4.1.