SUMMARY:

• Over 17 Years of experience in the Information Technology Industry with full system application development life cycle experience in Custom System Development and EBS Application System Implementation, ranging from analysis & design, development, testing, implementation, documentation and production support focusing on ORACLE RDBMS.
• Excellent skills in using Oracle database, Oracle Developer 10g Forms & Reports, Ability to perform technical and functional implementation for Oracle Applications 10.7/11/11i/R12 Implementation experience ranging from Purchasing, Inventory,Payable,iProcurement, Bill of Materials, Work In Process, Order Management, Shipping, Account Receivable, GL, PAS, CST, CRM & HR modules.
• Exposure to multiple projects from multinational firms that engages in varying business that ranges from manufacturing, distributions, retail, and finance.
• Have assumed various roles from the multiple projects assigned.
• Good knowledge in Discrete Manufacturing, Supply Chain Management, Procure to Pay & Order to Cash process flow in oracle application.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Inventory (INV), Bill of Materials (BOM), Purchasing (PO), Order Management (OM), Accounts Receivable (AR), Accounts Payables (AP), GL, PAS, iSuppliers, iExpense, I - Procurement, EBTax, Cash Management, Subledger Accounting, TCA Architecture, MRP/Demand Planning, ASCP, HCM/HRMS, Oracle CRM (Service Contracts, Install Base (IB)).
• Experience in Oracle Project Billing, Project Accounting, Project Costing, Project Management.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows)
• Strong knowledge of Application Implementation Methodology ( AIM ), Application Object Library ( AOL ) implementation standards, System Administration, Trading Community Architecture ( TCA ) and Software Development Life Cycle (SDLC).
• Good knowledge in Oracle R12 Manufacturing & supply chain modules.
• Worked extensively on all AOL features like concurrent programs, request sets, value sets, and profiles and implemented key Oracle Application features like folder form, KFF, DFF, Creating Registration scripts and FND LOAD.
• Good knowledge in various systems Security Setup in oracle application.
• Experience in the customization by extension and modification of the standard application suite using EBS Application Object Library (AOL)
• Extensive experience in PL/SQL programming, including creation of stored procedures, Functions, packages & Database Triggers, Apps Screen customizations utilizing Custom library, design and development of extension screen and reports utilizing Oracle Developer(forms4.5,6/6i/9i/10g,Reports2.5,6/6i/9i/10g), SQL*Loader, Workflow, Business Events.
• Experience in OA Framework Personalization and Extensions.
• Experience in Performance Tuning using Oracle tuning utilities, TK-Prof and explain plan.
• Very good knowledge of upgrade projects from R12x to R12x, 11i to R12 and 11.0.3 to 11.5.10.
• Considerable experience in UNIX Scripting
• Modified the behavior of the form using personalization in R12/11.5.10
• Good experience in EBS XML/BI Publisher reporting tool.
• Strong Conceptual, Business and Analytical skills.
• Extensive experience in Team building / management, Reporting relations, Dispute Resolution, Effort estimates, KPI, Appraisals

TECHNICAL SKILLS:

ERP Applications: Oracle EBS Applications R12, 11i (11.5.10/9/8), 11 (11.0.3)Modules: INV, BOM, Costing, WIP, MRP/MSD, ASCP, AR, OM/OE, WSH, QP, PO, GL, AP, PASHCM, iProcurement, iSupplier.

CRM Modules: Field services, Service contract manager, install base, Customer support, Depot

Repair.

Other Software: Oracle Developer Forms (v.4.5, 5.0, 6.0, 6i, 9i, 10g,11g,12c) & Reports (v.2x/2.5/6.0/6i,9i,10g,11g), SQL*Plus, PL/SQL, Mercury System Change & Source Integrity, Test Director, Oracle Discoverer 3.1/4i, Oracle Workflow Builder, SQL* Loader, TOAD, PL/SQL Developer, OPOS Driver, RMS(RETEK) Tools, HP Test Director, Exceed, Reflexion, Clearquest, Sql Navigator, PRO*C, JAVA,JSP, UNIX Shell script, Perl Script, Crystal Report, Retalix8 (Front Office & Winpos System), XML, HTML, MS-Office, Visio, WebDB (form/report & oracle objects), XML Publisher, More4Apps Excel-Out, QTP data loader, PVCS/VSS/Harvest, Taviz, SVN, DELL STAT, KINTANA migration tool.

Operating Systems:: Windows 95/98/2k/NT/XP/7, UNIX (AIX, Sun SOLARIS, HP), Linux

Database: ORACLE 12c/11g/10g/9i/8i/8.x/7.x, SQL Server2000, MS-Access, QDX database

EMPLOYMENT HISTORY:

Confidential, Foster City, CA

Solution Architect/ Team Lead

Responsibilities:

• Designed, developed different RICEW Objects in R12 ERP/CRM EBS applications.
• Enhanced all the P2P related WFs (REQAPPRV, POAPPRV, CREATEPO).
• Done various OA Framework Personalization and Extensions in I-procurement module.
• Helped Client for new AME items in I-procurement module.
• Designed/Enhanced Payable Invoice program for all inbound sources.
• Done different partner testing and enhanced the objects delivered by the offshore team.
• All the development and enhancements in P2P modules.
• Designed/Developed/Enhanced various Interfaces/customizations from legacy system to Oracle Accounts Payable, Oracle Purchasing and General Ledger.
• Provided technical support in AR, AP and GL Modules.
• Worked with Deloitte for the R12 UPGRADE project in P2P modules.
• Lead the Team of 10 people including Client management.
• Reporting the status reports to client management team.
• Co-ordinated with offshore/onsite team for the R12 EBS RICEW works.

Environment: Oracle Applications R12 PO, AP,GL, INV, Order Management (OM/ONT), Receivables (AR), PL/SQL, Oracle 11g, Forms 10g, Reports 10g,WF 2.6, SQL*Loader, Toad, UNIX (HP), Perforce, VHelp, BOX, SVN, GDOC.

Confidential, Mountain View, CA

Solution Architect/ Team Lead

Responsibilities:

• Designed, developed different RICEW Objects in R12 ERP/CRM EBS applications.
• Co-ordinated offshore and onsite team to deliver the technical objects to the client.
• Done different partner testing and enhanced the objects delivered by the offshore team.
• Supporting the oracle R12 objects for Symantec partners in different regions (NLD, SGP, China, EMEA, US, and South America).
• Optimize Contract Renewal Process: Interface data from Oracle (primarily Oracle Service Contracts and all data related to SCs) to a third party systems (Concentrix, Partner, Eloqua Renewal Manager) so that renewal opportunities can be quoted to the customer; When SC is ready to be “booked”, Renewal Manager interfaces SC back to Oracle SCs for signing and invoicing.
• Made the Oracle Opportunity Renewal system for Confidential /Symantec and linked with different Legacy (Partner, Concentrix, and Eloqua), ERP application, BI system to generate maximum forecast.
• Imported the Service contract data using the API OKC CONTRACT PUB.
• Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable, Oracle Purchasing, Inventory, Service contracts and General Ledger while separation from Symantec to Confidential .
• Reporting the status reports to client management team.
• Co-coordinating with offshore/onsite team for the R12 EBS RICEW works.
• Managed Team of 10 resources including onsite and offshore.

Environment: Oracle Applications R12 PO, INV, Service Contracts/Contracts Core (OKS/OKC), Installed Base (CSI), Order Management (OM/ONT), Salesforce.com (SFDC), Receivables (AR)Trading Community Architecture (TCA/HZ), PL/SQL, Oracle 11g, Forms 10g, Reports 10gSQL*Loader, Toad, UNIX (HP), Perforce, VHelp, BOX

Confidential, San Jose, CA

Oracle Apps Architect/Technical Lead

Responsibilities:

• Designed, developed different RICEW Objects in R12 ERP applications.
• Co-ordinated offshore and onsite team to deliver the technical objects to the client.
• Done different partner testing and enhanced the objects delivered by the offshore team.
• Designed different automation programs in order management module (importing the orders from Confidential partner systems to shipping the goods)
• Supporting the oracle R12 objects for Confidential partners in different regions(NLD, SGP, China, EMEA, US, South America).
• Done Conversion programs in INV, BOM, ONT, PO, AR, WIP, Advance pricing modules.
• Developed various inbound and outbound interfaces, which are run on the periodic basis, including Journal Import in GL, GL Journal Export to Concur interface, Supplier Outbound extract, PO and Invoice Import, Payments Extract, AR Transactions import, Item Import in Inventory, Sales Order etc.
• Developed an interface to upload the legacy GL Journal data into the Oracle Application System, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.
• Designed and developed migration scripts for all activities and GL migration.
• Leading development team of offshore/onsite for custom components design and delivery.
• Functional set up, design documents, preparation of different test cases, presentation the solutions to client.
• Reporting the status reports to client management team.
• Co-coordinating with offshore explaining solution and technical approach to ensure the on-time deliverables.
• Responsible for on-time deliverables.

Environment: Oracle Applications R12 (INV, BOM, CST, WIP, MRP, MSD, ONT, WSH, PO, AR, GLiProcurement, iSupplier, PL/SQL, Oracle 11g, Forms 10g, Reports 10g, SQL*Loader, ToadUnix (HP), SQL developer XML/BI Publisher, Kintana, SVN, DELL STAT

Confidential, Scotts Valley, CA

Oracle Apps Techno-Functional Lead

Responsibilities:

• Working as a techno functional consultant for R12 reimplementation project from 11.5.10
• Lead Oracle Consultant for identifying relevant SCM information in Oracle Apps R12 ERP and relaying the information for inbound/outbound flow.
• Leading development team at offshore for custom components design and delivery in R12
• Working alongside business users/key stakeholders for requirement gathering
• Capturing test cases and defects in HP Quality Center.
• Reporting the weekly status reports to client management team.
• Co-coordinating with offshore explaining solution and technical approach to ensure the on-time deliverables.
• Responsible for on-time deliverables.
• Co-coordinating with business for testing.
• Developed the ATP Process Form using 10g form developer tool and it will be used by specific users to view and trigger the ATP Engine run.
• Developed different inbound/outbound interface/conversion programs (INV, BOM, PO, ONT, AR, AP) using pl/sql packages and used to integrate different legacy oracle system with R12 applications.
• Developed custom reports using Report Builder and XML Publisher. Some of the reports include Natural Account report, Un-posted Journal entries, GL interface report, Customer Outstanding report, Open Order report, Cost Tracking report.
• System set up in PO, order management and account receivable modules in R12.
• Inbound conversion of LSI logistics/shipping data into Confidential system.
• Support the legacy Oracle application systems ex: WWFG, ISS etc.

Environment: Oracle Applications R12 (INV, BOM, CST, WIP, MRP, MSD, ONT, WSH, PO, AR, GLiProcurement, iSupplier, PL/SQL, Oracle 11g, Forms 10g, Reports 10g, SQL*Loader, ToadUnix (HP), SQL developer XML/BI Publisher, Kintana, SVN, DELL STAT

Confidential, San Jose, CA

Sr. Apps Analyst

Responsibilities:

• I have started the Client from HCL side and made the Team from scratch.
• Gathering requirements from Business
• Analyzing the requirements& Co- coordinating with Confidential IT for Product feasibility.
• Designing MD-50/70 Doc
• Development of problem incident automation system by using OA Framework and oracle DB programs.
• Production Support of B2B oracle APPS system and fix the issues by using different scripts.
• Production support of Configure to Order (CTO), Build to Stock (BTS) orders for different Confidential partners (Contract manufacturer/Logistics) data using oracle EBS R12.
• Understanding the existing system and transforming that into new system.
• Designing solution and preparing Technical Design Document.
• Co-coordinating with offshore explaining solution and technical approach to ensure the on-time deliverables.
• Responsible for on-time deliverables.
• Ensuring code maintenance in PVCS
• Ensuring code migration thru Kintana
• Co-coordinating with business for testing.
• Co-coordinating the monthly releases for code migration into PRODUCTION.
• Ensuring the test cases in QC

Environment: Oracle Applications R12 (INV, BOM, CST, WIP, MRP, MSD, ONT, WSH, PO, AR, GLIProcurement, iSupplier, install base, service contract, PL/SQL, Oracle 11g, Forms 10gReports 10g, SQL*Loader, Toad, UNIX (HP), SQL developer XML/BI Publisher, SVN, Kintana

Confidential, Houston, TX

Sr. Oracle Apps Developer

Experience synopsis:

• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports, functional set up in Procure to Pay(P2P), Order to Cash(O2C), Discrete manufacturing(M2S) Cycles touching various modules such as INV, PO, AP, OM, SHIPPING, AR, BOM, WIP, iSupplier, iProcurement,
• Production support of technical and functional components in oracle R12. Deliver the solutions to the users across different entities in the globe. Responsible of the deliverables with proper quality of the output from the team members across NOV and IBM support consultants. Help the Business analyst, help desk support team and users to find out and resolve the issues.
• Analyze, Design and Develop Accounts Receivables Auto Invoice Interface. This involved data mapping and developing Conversion programs for converting Invoices, Credit Memos, Debit memos using PL/SQL script.
• Prepared Technical Requirement documents (MD070) for custom components related to Project Accounting.
• Customized Project and Budget related approval workflows.
• Customized Auto Accounting rules in Project Accounting.
• Performed Project conversion from Legacy system and implemented interface to create and update project related data from third party systems.
• Custom integration between Oracle Inventory and Project Accounting.
• Worked on resolving the Accrual Reconciliations report issues in PO module.
• Customization of account generator work flow to reclassify material account, accrual account on PO distributions.
• Developed New Customized Auto Lock box Interface Program and Related Setup based on client requirement.
• Processing of Bank Receipts using Auto Lock box Interface
• Purchase order Inbound EDI Interface (850/Orders).
• Developed custom program to load EDI 850 inbound Orders into Order Management.
• Customized the Outbound EDI 856, 810 documents to add the extra fields as per the business requirements.
• Creating Inbound and Outbound Shipping and Billing EDI transactions.
• Customized different conversion & interface programs in MFG/SCM modules for NOV.
• Item, Category, Revision, Item Cross references, Item Cost Conversions for International Plants (US, French, NL)
• BOM, Routing & ENG
• Value Sets/ Item Locator Conversions
• PO Requisitions, Purchase Order/ Quotation/ Blanket PO
• PO Receiving Conversions (with/wo LOT/Serial Number Items)
• Vendor/Vendor Sites/ Vendor Site Contact Conversions in R12.
• Sourcing Rule /Assignment Sets/ Approved Supplier List Conversions.
• On Hand Quantities & Various material transaction conversions.
• WIP Discrete Job/WIP move Trx Conversion.
• Customer Conversion/Interface.
• AR Transactions inbound interface.
• GL Balances Conversion/Interface.
• GL Expense Account Outbound Interface.
• Oracle Project Accounting conversion using standard APIs
• Set up of different modules like INV, BOM, purchasing, iProcurement, iSuppliers for different plants
• Worked with ETL team to design various conversion mappings & show the proof of concepts.
• Development, Conversion, Production support, implementation of different RICEW components in EBS R12.
• Developed WIP OSP Detailed form and attached into Discrete Job seeded form (WIPDJMDF) by using ZOOM functionality features in personalization.
• Developed “NOV Discrete Jobs Extended Query Form” and attached into Discrete job search form by using ZOOM functionality in custom libraries.
• Enhanced various custom oracle forms/ custom pll/ personalizations/ reports/interfaces to help users resolving the bugs in productions system.
• Modified the PO Create Documents workflow and used the business logic in NOV to create the standard POs once the requisitions are approved.
• Developed More4Apps Excel out, BI/XML publisher Multilanguage reports in R12.
• Personalization of OA framework screens in iprocurement/ iSupplier modules.
• Enhanced the R12 forms by using custom pll and form personalization functionalities.
• Co-ordination with different teams (Functional, business, MDM, Deployment, Management & Training).
• Coordinate the development and unit testing of the customization with offshore team (IBM Consulting). Review the unit test code for conformance with agreed coding and design standards. Review the unit test code for performance.

Environment: Oracle Applications R12 (Order Management (ONT), Shipping Execution (WSH), Inventory (INV), Bill of Materials (BOM), Accounts Receivable (AR), Accounts Payable (AP), CSTWIP, MRP, MSD, PO, GL, iProcurement, iSupplier, Subledger Accounting, AME, Cash Management), ASCP, Electronic Commerce/EDI Gateway (EC), PL/SQL, Oracle 11g, Forms 10g, Reports 10g, SQL*Loader, Toad, Unix (HP), SQL developer XML/BI PublisherMore4Apps, WEB ADI

Confidential, Houston, TX

Sr. Oracle Apps Developer

Responsibilities:

• Designed & developed various AOL, RICEW & Oracle DB components.
• Did conversions in manufacturing modules for the acquired new organizations in Confidential .
• Did conversions & set up in manufacturing modules for an existing inventory organization which was the part of the main inventory org.
• Did all the MFG Conversions & roll out for 5 inventory organizations, single master & 3 validation orgs including 3 countries
• Created different conversion & interface programs in manufacturing modules for newly acquired divisions by Powell.
• Item, Categories, Catalog, Item cross references, revision conversions.
• Item Cost, BOM & Routing
• WIP discrete jobs(Standard/non-standard)/WIP Cost transactions/WIP Move transactions
• Purchase Order & Receiving Transaction Conversions
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Supplier, Supplier Sites & Supplier Contact Conversions
• On Hand Quantities & various material transaction conversions
• Sourcing rules/ Assignment sets & Approved supplier List conversions
• Developed New Customized Auto Lock box Interface Program and Related Setup based on client requirement.
• Processing of Bank Receipts using Auto Lock box Interface
• Purchase order Inbound EDI Interface (850/Orders).
• Developed custom program to load EDI 850 inbound Orders into Order Management.
• Customized the Outbound EDI 856, 810 documents to add the extra fields as per the business requirements.
• Creating Inbound and Outbound Shipping and Billing EDI transactions.
• Created ASN (Advance Shipping Notice EDI X12 856)
• EDI set up for various customers
• Supports different manufacturing/finance/HRMS production application system for Confidential .
• Designed & Developed various reports using the tools Oracle developer report/XML Publisher/Oracle Discoverer/SQL*Plus.
• Did nearly 150 plus reports in manufacturing, finance & HRMS modules.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Good knowledge of the company process flows.
• Enhanced various PL/SQL Concurrent programs.
• Designed & Developed custom manufacturing application system using Oracle form, Form personalization in existing form, Oracle PL/SQL program etc.
• Responsible for the enhancement/supports of various daily interfaces from legacy system into oracle manufacturing system in Confidential .
• Responsible for the enhancement/support of various daily scheduled concurrent programs in manufacturing modules.
• I have introduced one new process/system in manufacturing modules for this company. This helped to recover previous long time issues.
• Enhanced various Unix Shell Scripts.
• Designed MD50, MD70 for the project.
• Did various system setups for the manufacturing modules.
• Managed the Technical team of SCM/MFG modules.

Environment: Oracle Applications 11i /R12 (INV, BOM, CST, WIP, MRP, MSD, ONT, WSH, PO, AR, GL)PL/SQL, Oracle 8i/9i/10g, Forms 6i/9i/10g, Reports 6i/9i/10g, SQL*Loader, ToadUnix (HP), SQL developer, WebDB (2.2) tool (report/form/oracle DB objects), XML Publisher, Oracle Discoverer 10g, Toad, helpdesk/ SDLC tools.

Confidential, Hebron, KY

Sr. Oracle Apps Consultant

Responsibilities:

• Designed & developed various AOL, RICEW & Oracle DB components.
• Designed & Developed the Shipping system for the client using new form (using the features: container, pick/pack/unpack, create/update/assign trip/delivery/freight cost, ship confirm) & various oracle objects by integrating all the shipping execution APIs.
• Designed & developed master Item update form using new form & various oracle objects by integrating oracle inventory APIs.
• Customized the Supply/Demand form in MRP.
• Developed the Item Conversion programs using APIs & oracle DB objects and new items imported from the legacy into Oracle 11I system.
• Developed /Customized different Oracle Reports in the application modules (INV,BOM,WIP,ONT,PO,WSH,MRP,MSD):
• Developed different WEBDB Reports: Buy Item Detail Report, PO Pre Check Report, Blanket PO Report, Return to Vendor Report
• Customized different WEBDB forms & oracle DB objects.
• The fields & behavior of the item master, Order, PO summary form has been modified using the form personalization for user level.
• Created different test cases to test all the objects, which have been customized & developed.
• Generated the Oracle reports using XML Publisher Desktop Utility.

Environment: Oracle Applications 11i (INV, BOM, CST, WIP, MRP, MSD, ONT, WSH, PO, AR, GL), PL/SQLOracle 8i/9i, Forms 6i/9i, Reports 6i/9i, SQL*Loader, Toad, Unix (HP), SQL developerWebDB (2.2) tool (report/form/oracle DB objects), XML Publisher.

Confidential, Irvine, CA

Sr. Oracle Apps Consultant

Responsibilities:

• Monitoring the Support Jobs in production server for the concurrent programs done in Order management & Receivable modules.
• Created/ modified different back order & throttle program scripts & packages.
• Scheduling & monitoring different concurrent programs in shift basis.
• Writing different job monitoring scripts & sending the status each hour Generating the OTC report, Back Order & Order status scripts, Daily message missing scripts from Sybase system into Oracle, MTI Inventory clean up scripts
• Created different SQL report & generate the output as a concurrent program.
• Developed the functional specifications for the client’s requirements.
• Involved in preparing the technical design specifications and the Unit test plan documents.
• Involved in mapping the legacy system (SYBASE) database columns mapping to the Oracle Applications table columns and prepared the mapping documents for the same.
• Developed custom programs (sales order & delivery) for loading the data from the staging tables into the Oracle Open Interfaces tables for the inbound.
• Involved in customization of various Oracle reports as per the user requirements which includes: Customer Item Cross References Report (INV), Inactive Items Report (INV), Packing slip report.
• Worked as a techno-functional consultant implementing Oracle modules OM, Purchasing and Advanced Pricing.
• Did the Conversion programs for importing the Order information from Legacy (Sybase) System into Oracle Apps.
• Worked on VSS tool for controlling the version of the codes in project.
• Developed Outbound Interfaces to download data into text files from various tables using UTL FILE package and procedures.
• Coordinated with different teams & DBAs to run different DDL/DML scripts in production in timely mannered.
• Monitoring the Bus speeds for daily messages from SYBASE system into oracle by running different scripts.
• Helping the users for testing of the deliverables.

Environment: Oracle Applications 11i (INV, BOM, Costing, Order Management, Shipping, AR, GL), PL/SQL, Oracle 8i/9i, Forms 6i, Reports 6i, SQL*Loader, Toad, Clear Case, Unix(HP), SQL server, SQL developer, PVCS Tracker

Confidential, Boston, MA

Sr. Technical Developer

Responsibilities:

• Created/ modified different Inbound/ Outbound packages which were used to import /export the data from different feeder systems into receivable interface table, then AR base tables and exporting the data as a flat file into various medical insurance customers in different states.
• Enhancement of the custom reports in (10.7) receivable system: Receivable Adj Summary Report, Detailed Aging Analysis Report
• Modification of the (10.7) custom reports in AR to reuse in 11i (11.5.10) application.
• Developed the functional specifications for the client’s requirements.
• Involved in preparing the technical design specifications and the Unit test plan documents.
• Involved in mapping the legacy system database columns mapping to the Oracle Applications table columns and prepared the mapping documents for the same.
• Developed custom programs for loading the data from the staging tables into the Oracle Open Interfaces tables for the inbound touch points.
• Worked on the following conversions for Oracle 11.5.10 system.
• Items and the categories import.
• Customer Item Cross references.
• Item Costs
• Bills Of materials and the routings import.
• Creating the New Packages for importing the Customer/Party data from (10.7) system and loading the data into different temp tables.
• Developed the packages for importing the customer data in 11.5.10 system (from 10.7 system) using different HZ party (TCA) APIs.
• Did customization of the reports in GL module in 10.7/11.5.10 system.
• Helping the users for testing of the deliverables.
• Worked on clear case tool for controlling the version of the codes in project.

Environment: Oracle Applications 10.7 (AR, OE, INV, BOM, Costing, GL), Oracle Applications 11i (INV, BOM, Costing, Order Management, AR, GL), PL/SQL, Oracle 8i/9i, Forms 6i, Reports 6i/2.0, SQL*Loader, Toad, Clear Case, UNIX(HP).

Confidential, Boston, MA

Sr. Technical Consultant

Responsibilities:

• Worked full Cycle of the project in Quote to Cash module (Design, Documentation, Coding, Testing & support etc), Worked on Clearquest tools for Unit/system test phases in project.
• Worked as a technical lead for a team having 4 resources in accenture.
• Did development/customization of the RICEW objects in Oracle APPS (11.0.3/11.5.10 )
• Worked on Interfaces to import item (item, revision, category) and cost information from the legacy system into Oracle Inventory & BOM (Oracle APPS 11.0.3) through Item/Bom Open interface.
• Worked on writing validation programs to import BOM and BOM components into Oracle Applications from the legacy system and the same data have been transferred from 11.0.3 System to 11.5.10 APPS system.
• Design/Developed Interface to load Item cost into Oracle Application.
• Design/Developed Item interface to load Master, Organization Item.
• Design/Developed interface to load Item Category.
• Worked on Mercator tools, Trigger, PL/Sql packages to transfer the item information under specific Category & Category sets to external system through XML file output.
• Worked as a techno-functional consultant implementing Oracle modules OM/OE, AR, BOM, INV for Oracle11/11i (11.5.10/11.0.3 ) System. Familiar with the modues GL (11i/11.0.3) & PAS(11i).
• Did the data set up & customization of the reports in GL module.
• Customized and enhanced interface program from legacy system (Documentum & Legato) to create journal entries to Oracle General ledger.
• Worked on Auto Invoice Interface program in 11.0.3 system and transferred the transaction data from 11.5.10 AR system into 11.0.3 Receivable system using Mercator/Smart DB tools & required Oracle objects(package/trigger/table etc)
• Did Custom pll Extentions (functionality: ZOOM/multi ZOOM, LOV, RG, field properties, Security profiles) for various forms in different modules in Apps - 11.0.3.
• Did various form extensions in AR/INV/OE/GL modules in 11.0.3 system using CUSTOM library.
• Customized Various Forms and Reports and registered them in Oracle Applications using AOL concept.
• Created 4 New forms, 1 repot & database objects in Oracle 11.5.10 System.
• Customized standard T & M Invoice/ Credit Memo Report in AR Module.
• Worked on Transaction, Customer Forms in AR and Sales Order/Shipping forms in OE.
• Used SQL*Loader for Data Conversions.
• Developed Outbound Interfaces to download data into text files from various tables using UTL FILE package and procedures. The data files transferred into different server using shell script & it has been automated.
• Helped Offshore team for implementing the Customer Conversion using TCA API in Oracle 11i.
• Did the Conversion programs for importing the Order information from Legacy System into Oracle Apps (11.0.3).
• Written DB triggers for Quick pick interface program in OE.
• Done various reports in CRM modules 11.5.10 (includes field services, Service contract manager, Install base, Customer support).The report belongs to the various forms as Service request form, Task form and are Site message report, Open cases/tasks, EIM exception rpt, CAC daily min, Shift Incident Report
• Developed the site message form and attached with the Service request form in field service module.
• Did the data set up for the SR form, Task form, various Resource/team/group forms for the testing of different CRM reports developed.
• Modified the Depot Repair Estimate report (CSDESTRT)
• Modified the queries & customized the reports using DISCOVER tool kit 4i.
• Very good knowledge of the tools like Harvest, Clear quest, ERoom etc.
• Did the post Production support for the 11i/11.0.3 application after go-live.
• Organizing meeting for code review, performance testing

Environment: Oracle Applications 11i (INV, BOM, Costing, Order Management, AR, GL), Oracle Applications 11.0.3 (INV, BOM, Costing, OE, AR, GL), CRM modules as (OKS,OKC,JTF,CSI,CS, Depot Repair (CSD) etc), Workflow Builder, PL/SQL, Oracle 8i, Forms 6i, Reports 6i, Oracle Discoverer, SQL*Loader, Toad, Clearquest, Mercator, SmartDB, Harvest, Taviz, Sql Navigator, Reflexion.