SUMMARY:

• 8.5 years of IT experience as Oracle EBS/Apps Technical Consultant in Oracle E - Business Suite (ERP Package Software) and have been part of Technical analysis, implementations, upgrade and support projects in R11i and R12 versions, Possess strong organizational and communication skills.
• Expertise in SCM, Order to Cash (O2C) and Procure to Pay (P2P) Cycle.
• Good Technical and Functional knowledge of Oracle Applications modules such as Inventory, Order Management(OM), Shipping, Warehouse Management System(WMS), Purchasing(PO), Requisitions, iProcurement, Accounts Payables(AP), Accounts Receivables(AR), General Ledger(GL), BOM,WIP,CRM.
• Extensive experience in Upgrade, Implementation, migration assignments.
• Technically Proficient in Conversions/Data Migration, PL-SQL, Oracle Workflows, Oracle Reports, Forms.
• Worked extensively on RICEW components.
• Extensively worked on Oracle Forms, Oracle Reports, XML Publisher Reports, Form personalization and CUSTOM.pll.
• Having good knowledge & hands on experience on Oracle Workflows.
• Worked on various Oracle Application Framework (OAF) personalization and extensions as per business requirements.
• Performed technical analysis to increase performance.
• Proficient in 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.
• Developed & customized Alerts in Oracle Apps using Oracle Alerts.
• Good knowledge about PO’s, Requisitions and AR Invoice to meet technical needs
• Logged service requests with Oracle to resolve application/system defects.
• Have exposure to Inventory modules and basic idea on WIP
• Hands on Experience in registration of various entities in System Administrator, like registering concurrent programs, forms and creating value sets, flexi fields & other related AOL objects.
• Highly motivated and self-starter to successfully contribute towards the success of organization.
• Strong technical skills on Oracle PL\SQL, data collection and analysis
• A motivated and resourceful professional with extensive experience in the setup, support and Customizations of the (EBS) Oracle E-Business Suite. Offering strong functional and technical knowledge, coupled with an analytical and problem-solving aptitude to provide end-to-end custom solutions for business applications.
• Exposure to industry sectors such as Manufacturing, HealthCare.

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business suite R11i & R12 (Purchasing (PO), Order Management (OM), Inventory (INV), Receiving, Requisitions, iProcurement, Shipping (WSH), General Ledger (GL), BOM, WIP, CRM,Warehouse Management (WMS).

Operating Systems: Windows XP and UNIX.

RDBMS: Oracle 6i/9i/10g.

Languages: SQL, PL/SQL, UNIX

Tools: Toad, SQL*Plus, SQL*Loader, Oracle Reports 6i/9i, Oracle Forms 6i/9i

Reporting Tools: Reports6i and XML Publisher.

GUI: Forms10g, JDeveloper

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle SCM Technical Support Consultant

Roles & Responsibilities: -

• Technical consultant for Oracle EBS R12 SCM ITDS Support.
• Order Fulfilment and Deliver track of IT Delivery Services of Customer Ordering Value Chain management.
• Responsibility of handling and resolving highly critical incidents on manufacturing and delivery as part of SCM and Incident Management.
• Involved in problem management such as Bug Fix/Long Term Fix deployment.
• Resolving the highly critical orders in shipment proactively.
• Handle Fast Path Bridge and provide solution to issues within 3 hours and proactive orders clearing every 4 hours.
• Deployment of bug fixes/enhancements that are critical to Cisco’s manufacturing and Revenue.
• Participate in client interactions and business meetings to identify issues and work towards resolution in Weekly, Monthly, and releases as per the priority.
• Drive meetings with Operations/IT/ITA for existing bugs/process related enhancements.
• Full week (7-day) support on critical shipping orders received via CET/Spark.
• Responding to user issues through SFDC ticket monitoring tool

Oracle Apps Technical Consultant.

Roles & Responsibilities: -

• Technical consultant for Oracle iProcurement R12 implementation.
• Worked on development of FND User and Employee conversions.
• Worked on Customization of Invoice Approval Workflow.
• Used SQL loader to load data from data files provided by business and developed PL/SQL programs to Load data using API’s.
• Involved in development of Requisition approval cycle time reports.
• Extended the OAF page functionality according to client requirements.
• Preparation of MD.070 documents and (BR100) setup documents.
• Preparation of Test Scenarios & Cases
• Preparation of Test Scripts.
• Participated in Go-Live activities.
• Providing support after go-live.

Oracle Apps Technical Consultant.

Roles & Responsibilities: -

• Performed technical analysis to analyze current processes resulting in performance increase.
• Responsible for support of all issues and enhancements.
• Resolve technical issues of Oracle Projects module through ticket handling system.
• Worked on development of Change requests and enhancements.
• Presenting status reports in weekly customer meetings.
• Ensure timely and quality delivery of the fixes
• Modules: Oracle Projects Module

Oracle Apps Technical Consultant.

Roles & Responsibilities: -

• Worked on customization of PO Requisition Approval workflow and PO Create Documents workflow to auto convert approved PR to approved PO.
• Worked on customization of PO Approval workflow to send an email to supplier once PO is approved and PO Account Generator workflow to create defaulting rule for GL code combination only for Expense rule type.
• Involved in development of AP Supplier conversion and Employee conversion.
• Worked on development of conversion programs for AR Invoice, AP Invoice, CRM Resources, Service contracts and Install base from legacy to R12.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Prepared SQL queries to identify transactions from the transactions posted to General Ledger using GL JE HEADERS, GL JE LINES, and GL JE BATCHES tables. Created flat files using UTL FILE, DBMS utility package which displays General Ledger (GL) entries grouped by code combinations.
• Worked on development of customized payment formats in AP.
• Developed Web ADI for AP Invoice.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Preparation of (MD.070) Technical documents and (BR100) Setup documents.
• Writing Unit Test cases and testing after completion of the Object.
• Providing UAT support
• Perform cut-over planning and activities
• Ensure timely and quality delivery of the fixes

Oracle Apps Technical Consultant.

Roles & Responsibilities: -

• Responsible for development, support, maintenance and implementation, testing of small to High complex components related to conversions, interfaces, Reports and Forms.
• Developed conversion Programs for Approved Supplier lists, AR Invoice, PO requisitions, Sourcing rules, Assignment sets, Suppliers and Employee conversion programs to import date from various sources into Oracle applications using PL/SQL,SQL*Loader.
• Worked on Customization of Master/Organization Item Form as per client requirement.
• Worked on retrofitment of RICE components.
• Creation of Technical Design documents and setup documents.
• Preparation of Test Scenarios & Cases
• Testing and issue resolution
• Providing SIT, UAT support
• Engage in cutover and go-live activities
• Providing support after the go-live
• Modules: Oracle Purchasing, Inventory, Bill Of Materials, Receivables, WIP, Payables, CRM.

Oracle Apps Lead Technical Consultant

Responsibilities: -

• Involved in solution design for Inventory and WIP process.
• Providing Technical Design for the custom objects
• Preparation of documents for technical solution design, configuration and getting approval
• Testing and issue resolution
• Providing UAT support
• Perform cut-over planning and activities
• Ensure timely and quality delivery of the fixes
• Modules: Oracle Purchasing, WIP and Inventory Process

Oracle Apps Technical Consultant.

Responsibilities: -

• Technical consultant at Offshore
• Responsible for development, support, maintenance.
• Involved in implementation by creating reports, interfaces as per business requirement.
• Worked on Print PO Report, Triggers and SQL codes
• Involved in Sourcing rules and assignment sets conversion programs
• Creation of technical design document and Unit test cases.
• Also involved in RFC process for all the code enhancements and changes.
• Taken up the issues reported and provided quick fixes while testing.
• Provided SIT and UAT support.
• Involve in Go-Live activities and Production support after go-live.
• Modules: Oracle Inventory, Purchasing, Receivables