SUMMARY

• Over 9+ years of experience in the software industry and experience inAnalysis, Design, Development, Testing, Implementation of Software Applications and Technical aspects of Oracle Applications E - Business Suite (SCM, Financial) Version 9i,11i/11.0.3/R12.
• 5 years of extensive experience working as Oracle Applications techno functional consultant in modules PO, OM, INV, BOM, AR, TCA.
• 6 years of Strong experience AOL, Oracle D2k, PL/SQL, SQL,SQL*Plus, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle10g/9i/8i/7.3 under Windows 2000/NT/98/95/XP.
• Good functional knowledge in Order to Cash cycle and Procure to Pay Cycle.
• Good experience in Implementations and Upgrade Projects.
• Knowledge and hands on experience ofweb service modules like iStore,iPayment and iProcurement.
• Extensive experience in writing conversion scripts for migrating legacy data into Oracle Applications using Oracle Open Interface and Oracle API’s.
• Extensive experience in OracleStored Procedures, Packages, Functions & Triggers using Toad as development tools.
• Worked extensively on XML Publisher and BI Publisher.
• Very good hands on experience with Oracle OAF10g
• Project exposure in OAF personalization.
• Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
• Extensive experience in customization of workflows and in fine-tuning code for better performance.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

Oracle Apps: Oracle 9i,11i (11.5.10/11.5.9/11.0.3/10.7 ), R12,Oracle Purchasing, Inventory, Order Management, Bills of materials, Oracle EBS Financials (General Ledger, Account Payables, Account Receivables),and AOL,SQLLoader, Toad RDBMS Oracle 7.x/8.x/8i/9i, SQL Server 7/2000, Access 97/2000.

Oracle & other tools: Reports 4.5/6i/10g,Oracle Designer 6i/10g, SQL*Loader, Forms 10g/6i/4.5, Toad, XML Publisher. OBIEE 10.1.3.2.0, Dashboards, Answers, BI Publisher.

Database: Oracle 10g/9i/8i, MS Access.

Languages: C, C++, SQL, PL/SQL, Visual Basic, Java, XML.

Operating Systems: Windows, UNIX and SOLARIS.

PROFESSIONAL EXPERIENCE

Confidential, Aliso Viejo, California

Oracle Techno Functional Consultant

Responsibilities:

• Analyzing the requirements.
• Prepare MD 70 for the SRS
• Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12.1.3.
• Working on P2P module and worked in one complex PO conversion.
• Identify the gaps in 11i and make changes to R12.
• Working on RICE components.
• Developed complex shell script program calling PL SQL from shell scripts
• Helped the team in solving critical issues.

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Confidential, Carlsbad, California

Oracle Techno Functional Consultant

Responsibilities:

• Regular meetings with the business users.
• Gathering requirements and preparing MD 50, MD 70.
• Assigning tasks to the developers in offshore.
• Analyzing the requirements.
• Worked on complex configurator models.
• Worked on complex functionality ATP dates in configurator.
• Worked on P2P modules and conversions
• Worked in modules Configurator, OM, INV, PO, AP, and AR.
• Worked in JAVA coding developed JSP pages.
• Done functional setups in Order to cash and procure to pay cycle.
• Involved in DBA tasks.
• Involved in performance tuning of sql queries.

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Confidential, San Francisco, California

Oracle Techno Functional Consultant

Responsibilities:

• Analyzing the requirements.
• Mapping of EBS data model to Data Warehouse reports.
• Modules involved are Financials, MFG, OM, PO, Installed Base, Service Contracts, Field Service, and Tele Service.
• Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12.1.3.
• Worked in P2P reports in R12
• Developed complex sql queries which can be used to develop SSHR reports.
• Helped the team in solving critical issues.

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Confidential, Chicago, IL

Oracle Technical Lead

Responsibilities:

• Analyzing the requirements, preparing data collection templates for PTO models.
• Preparing Structure, Rules and User Interfaces for the models in Oracle Configurator.
• Testing the models to ensure the models are as per data collection templates
• Designed TE20 and MD120, developed the Models as a Configurator Builder to meet the client’s requirements shared modelers responsibility as a part of modeling work and prepared many documents which would minimize the build defects at the initial phase. Example Macro which would find the duplicates matrix uniqueness for a given model & Build Process for QP & CC Models.
• Project exposure in iStore-Configurator Integration and implementing Multicurrency Pricelists for iStore.
• Good experience in iStore UI Customizations (Java, JSP, Shell Scripts, XML Publisher).
• Project experience in iStore Technical Schema (PLSQL/Java API’S, Stored Procedures).
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, Updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in CZ SCHEMA, PopulatingCZ SCHEMA,Migrating,Data,SynchronizingData,CZ SCHEMA Maintenance,Integration,API's involved in Configurator development.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Involved in oracle Unified Method (OUM).
• Work experience in Business Process Modeling and Analysis (BPA).
• Work experience in Oracle Product Information Management (PIM) module.
• Helped the ITEM LOAD Team for creating Bills & assignment for the items in the BOM.I was part of maintenance Team delivered simple, complex & very complex Models.
• Key resource in handling the maintenance requests on deliverables in Production after GO-LIVE.
• Trained newcomers in the team and help them out in understanding business flow.
• Worked extensively on XML Publisher. Developed .RTF files for xml reports.
• Worked in upgrade project R12.1.2 to R12.1.3.
• Work experience in creating LOV based field using Personalization in OA Framework.
• Worked extensively in customizing the workflows and developed workflows from scratch using workflow builder 2.6.
• Developed conversions and interfaces in PO, GLmodules. These conversions extract data from the legacy system and importing the extracted data to Oracle R12 base tables using Open Interface import program.

Environment: PL/SQL, SQL*Plus, TOAD, SQL Developer, Windows XP, JAVA, SQL * Loader, Toad, SQL, PL/SQL,Reports 10g,forms 10g,workflow builder 2.6

Confidential, Columbus, OH

Sr. Oracle Technical Consultant

Responsibilities:

• Requirement Gathering, Roadmap meetings with Product Management, Product Marketing.
• Preparing Structure (parent child nodes reference nodes), Rules (complex rules) and User Interfaces (creating R12 Templates) for the redesign models (complex, high complex) in Oracle Configurator in CXP (Channel Express /iStore).
• Writing & executing queries and checking status of active nodes in Configurator.
• Creating an Archive, Attaching Archives to models, Creating Configurator Extension Rules
• Testing the models to ensure the models are as per client requirements.
• Create & Edit a Quote, Configure & Update a Quote, Price/ Discount a Quote, Approve a Quote, Maintenance Redirect and Price floor, Customer Facing Documents, Complete a quote in DXP (Direct Express) for Sales Order Processing Cycle.
• Publish to Test both in CXP & DXP (Direct Express).
• Activation of publishes in test
• Publish to Production
• Project exposure in iStore-Configurator Integration and implementing Multicurrency Pricelists for iStore.
• Good experience in iStore UI Customizations (Java, JSP, Shell Scripts, XML Publisher).
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, Updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in cz schema, PopulatingCZ SCHEMA,Migrating,Data,SynchronizingData,CZ SCHEMA Maintenance,Integration,API's involved in Configurator development.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Involved in oracle Unified Method (OUM).
• Work experience in Business Process Modeling and Analysis (BPA).
• Work experience in Oracle Product Information Management (PIM) module.
• Helped the ITEM LOAD Team for creating Bills & assignment for the items in the BOM.
• Part of maintenance Team delivered simple, complex & very complex Models.
• Worked in Maintenance Standards- Warranty and pricing list
• R12 translations and migration
• 11i SWAT Process
• Key resource in handling the maintenance requests on deliverables in Production after GO-LIVE.
• I have took training to train resources from other team at Accenture level
• Trained newcomers in the team and help them out in understanding business flow.
• Customized complex workflows and added new functions and activities.
• Worked extensively in OM, INV, PO, GL, AR and FA.
• Worked in FA module Budget Reports-->Budget Report-->Budget-To-Actual Report, Asset Listings-->Asset Inventory Report, Transaction Reports-->Additions by Period Report.
• Worked in AP module Supplier Reports-->Purchase Order Header Updates Report, Invoice Reports -->Invoice Audit Report, Payment Reports -->Payment Distribution Report.
• Worked in AR module Accounting Reports-->Account Status Report, Invoice Print Reports-->Invoice Print Preview Report.
• Developed many Oracle and XML Publisher reports for almost all the modules.
• Work experience in creating LOV based field using Personalization in OA Framework.
• Designed and generated database objects and Oracle Forms, Reports

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Confidential, Monroe, NC

Sr. Oracle Technical Consultant

Responsibilities:

• We analyze specifications that are provided by engineering team.
• The specifications contain requirements about the Alloy metals.
• Based on requirements provided in the specifications we prepare model structure and create Configurator extension rules.
• Make a valid configuration and create a quote for the end user.
• Worked in Configurator extensions.
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, Updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in cz schema, PopulatingCZ SCHEMA,Migrating,Data,SynchronizingData,CZ SCHEMA Maintenance,Integration,API's involved in Configurator development.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Worked extensively on Order management, Bills of material, Purchasing, HRMS and inventory modules.
• Developed new reports in Oracle R12 using 10g report builder.
• Customized existing reports and modified according to user requirements.
• Up gradation of oracle reports from 11. .
• Developed reports using XML and BI Publisher.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked in customization of reports in OM, Bills of material, and INV.
• Worked in FA module Budget Reports-->Budget Report-->Budget-To-Actual Report, Asset Listings-->Asset Inventory Report, Transaction Reports-->Additions by Period Report.
• Worked in AP module Supplier Reports-->Purchase Order Header Updates Report, Invoice Reports -->Invoice Audit Report, Payment Reports -->Payment Distribution Report.
• Worked in AR module Accounting Reports-->Account Status Report, Invoice Print Reports-->Invoice Print Preview Report.
• Involved in performance tuning of the reports built.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Worked with development of packages and procedures using PL/SQL.
• Registered Concurrent Programs and custom Applications using System Administration.
• Developed many reports for retail,distribution and supply chain modules in version R12.

Environment: Oracle applications 11i, R12, OM, INV, WSH, PL/SQL, SQL*Plus, TOAD, SQL Developer, Developer 2000(Reports 6i/10g and Forms 6i/10g), System administration, XML Publisher, BI Publisher, Oracle Designer 6i/10g, Windows XP, UNIX, JAVA.

Confidential, Milford, PA

Oracle Technical Consultant

Responsibilities:

• Developed complex workflows from scratch.
• Developed reports using XML and BI Publisher.
• Extensive experience in oracle configurator.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Work experience in Business Process Modeling and Analysis (BPA).
• Work experience in Oracle Product Information Management (PIM) module.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked in customization of reports in OM, INV, PO, AR, GL and FA.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL.

Environment: Oracle applications 11i, R12,PO, PL/SQL, SQL*Plus, TOAD, iStore, Developer 2000(Reports 6i/10g and Forms 6i/10g), System administration, XML Publisher, BI Publisher, SQL Developer, Oracle Designer 6i/10g, Discoverer (10.2), Windows XP, UNIX.

Confidential, San Francisco, CA

Oracle Technical Consultant

Responsibilities:

• Worked extensively in OM, INV, AP, PO, BOM, GL, AR and FA.
• Worked on Sales order interface for Japan Project for adding lines to an existing order using OE ORDER PUB API
• Developed many Oracle and XML Publisher reports for almost all the modules.
• Extensive experience in oracle configurator.
• Extensive experience in configurator extensions.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Developed many BI Publisher reports.
• Some of the reports developed include
• Customs Invoice Report for Japan
• Packing Slip Report for Japan
• Bill Of Lading Report For Japan
• Shippers Letter Report
• On hand Quantities Detail Report.
• WIP Packing List Report.
• Intercompany AR invoice report.
• QVC Invoice Report for Japan.
• Item Master Details Report.
• Internal Requisition Status Report.
• Worked extensively on XML Publisher. Developed .RTF files for xml reports.
• Worked on the XML Publisher in developing and upgrading the oracle reports to XML Reports.
• Customized many XML and BI Publisher Reports.
• Developed many reports for Financial,Distribution and Supply chain modules in version R12.
• Developed stored procedures and packages. Extensive work in PL/SQL.

Environment: Oracle applications EBS 11i (11.5.10), R12, AP, GL, HRMS,SCM,Configurator, iStore, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SOA, BPEL, OBIEE 10.1.3.X, System administration,SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, UNIX, JAVA.