SUMMARY

• Having 11+ years of IT experience in Oracle Applications (11i & R12) as a Techno - Functional Consultant.
• Worked on Implementation, Operations/Support and upgrade projects in SCM and CRM modules.
• Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as Inventory, Order Management, Shipping, Warehouse Management System, RMA Processing, Purchasing, Requisitions, iSupplier, Receiving, Quality, Oracle Receivables, Oracle Install Base, Oracle Service Contracts & Oracle Field Service modules.
• Extensively worked on Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Proficient in a wide variety of areas include System Analysis (AS IS) (TO BE), GAP analysis, preparation Business Requirement Documents (BRD100), Functional design document (MD050), full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment.
• Worked extensively on multiple RICEW components tied to O2C & P2P modules.
• Working exposure on developing reports using Oracle Discoverer 10g Reports.
• 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) personalizations and extensions as per business requirements.
• Good experience in Oracle Mobile Supply Chain Application (MSCA), development, configuration, debugging, troubleshooting & also MSCA Personalization.
• Developed & customized Alerts in Oracle Apps using Oracle Alerts.
• Good knowledge on 3PL & EDI business flows.
• Developed & supported interfaces between 3PL & Oracle EBS integration.
• Strong experience on SQL Loader for Conversions as per the business requirements.
• Logged service requests & TAR’s with Oracle to resolve application/system defects.
• 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.
• 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.

TECHNICAL SKILLS

ERP Applications: Oracle Applications E-Business suite R11i & R12 (Purchasing (PO), Order Management (OM), Inventory (INV), Receiving, Requisitions, iSupplier, Shipping (WSH), Warehouse Management (WMS), Mobile Supply Chain (MSCA), BOM, Quality, Advanced Pricing, Install Base (IB), Oracle Receivables (AR), Oracle Payables (AP), Oracle Service Contracts (OKS), Oracle Field Services (OFS)

Databases: Oracle 9i, 10G.

Other Components: RICE Components, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields, Electronic Comments EDI Gateway (EC), New Module implementation & Upgrades.

Development Tools: SQL *Plus, Toad, PLSQL Developer, Oracle Reports 6i/9i, Oracle Forms 6i/9i, SQL Loader,Oracle Discovered & Oracle Workflow Builder.

Languages: SQL, PLSQL, C, UNIX Shell scripting & Java.

Testing Tools: HP Quality Centre, HP VUGEN (Load Runner)

Operating systems: Windows XP/7, Windows NT 2000 Server & Linux

PROFESSIONAL EXPERIENCE

Confidential, Goleta, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Translating business requirements, designing, developing and deploying solutions in Supply Chain Modules (OM, Shipping, INV, PO, Requisition, Receiving, Pricing, WMS & Quality).
• Designed OM defaulting rules, transaction types, quick codes and processing constraints as per the business requirement in the upgradation project.
• Implementing R12 (12.2.4) upgrade, this includes developing & retrofitting custom interfaces, reports & also conversions.
• Worked on Sales Order Conversion, Purchase Order conversion from 12.0.6 to 12.2.4.
• Developed Item conversion from 12.0.6 to 12.2.4
• Developed custom interface that performs ship confirm or back order/cancel or apply custom Hold for the given order.
• Developed custom interface, to receive many ASN’s in one-go by using seeded Receipt Interface tables and that saved lot of time for operations team.
• Created new interface program to transfer the entire inventory in a given locator to different organization in one-go by using “Inter Org Transfer” method as part of “Brand Move” project.
• Developed a custom interface to streamline Reverse Logistics Order process by using Quality Collection plan till performing Receipts and also adjusting the material after inspection.
• Developed a custom maintenance program to create and update the price list for a given item.
• Also developed interface for inventory transactions like sub-inventory transfer, account alias.
• Involved in development of Inbound Shipment interface, interface is to communicate between EBS and WMS (3rd party) for the ASN Extracts/ASN Updates, PO Extracts/PO Updates in EBS.
• Developed custom interface program to streamline process for creating Requisitions & converting to PO for Back-to-Back order creation scenario.
• Performed setups for Sourcing Rule assignment set creation.
• Extensively worked on ASL (Advance Supplier List) creation/maintenance.
• Performed setups for Receiving Parameters, Internal customer creations for P2P cycle.
• Developed Open Pick Report (contains pending pick task details for the given organization) by using Oracle Discoverer Reports.
• Developed custom interfaces for creation of Replenishment Move Order Based on SO Demand.
• Developed Packing Slip reports for wholesale & eComm channels by using XML Publisher Reports technology.
• Customized Order Line workflow to meet business requirement for eComm channel.
• Defined Oracle Alerts for critical business processes specific to Order Processing/Shipping, Inventory & Receiving to notify the Business User.
• OAF - Personalized iProcurment page to hide unwanted data to the buyer/user.
• OAF - Personalized “Receiving Options” in Warehouse Manager Responsibility to hide “Accounting” information from the unwanted users.
• Developed MSCA personalization in standard Mobile Alias Receipt Transaction page.
• Facilitated execution of CRP, SIT, UAT & Production deployment cut over tasks.
• Involved in Testing of business flows with inbound operations (Supplier creation, ASL creation, Sourcing rules, PO (Blanket & Standard) creation & approval process and also receipt into warehouse) and outbound logistics (Order Creation/Booking, Pick Release, Ship Confirm & interface to AR).
• Responsible for all the project deliverables comprising of AOL components like Menus, Functions, Concurrent Program Registration, PL/SQL packages and procedures, Triggers, Shell scripts, Flexfields and Alerts etc.
• Played as a mentor role in troubleshooting and fix complex Productions issues in Inventory, O2C & P2P modules as and when required for the support team.
• Resolved production issues of 3PL organizations for both Inbound, Outbound & Inventory transactions.
• Helped business in closing Year/Quarter & Month end process.
• Responsible for clearing inventory Interfaces.
• Worked with ORACLE support to diagnose problems, identify bug fixes and implement the solution provided by oracle.

Confidential, San Jose, CA

Techno-Functional Consultant

Responsibilities:

• Involved in the customization and implementation of OM, Inventory, Advance Pricing & Shipping.
• Prepared the Test Scripts for the various modules and various scenarios. Conducted the Conference Room Pilot (CRP)
• Reviewed Set ups and conducted trials in Order Management and Pricing especially for ATO, Drop Ship, RMA, Internal and External Orders.
• Implemented Formula based pricing, discounts, deals. Defined price lists for items and attached modifiers and qualifiers.
• Involved in setting up of Organization, Sub inventories, item transactions and picking rules, defining Item attributes, item categories & lot control.
• Prepared Functional Specification document for Extension, Customization & Reports
• Customized Miscellaneous Transactions and Move Orders Forms as per the business requirement
• Created custom application, responsibility, profile, report group and menu.
• Involved in registering custom programs in user testing environment.
• Developed several complex matrix reports for PO, OM, WSH and INV modules.

Confidential

Associate Consultant

Responsibilities:

• Gathered business requirements for OM, INV, AR and performed an initial configuration of the system for demonstration activities.
• Completed configuration and setup to meet the business requirements for distribution and manufacturing modules.
• Worked on Flexfields- segments, value sets, values and look up codes in PDH, ERP
• Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Year end processes
• Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization issues
• Troubleshooting the order management, invoices, intercompany, WIP transactions, etc issues using SQL statements in Oracle
• Three cycles of testing performed: conference room pilots (CRPs) 1 and 2 and user acceptance testing (UAT).
• Trained the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way
• Supported all go-live activities and post-production troubleshooting for the entire 12-operating unit dispersed in the Americas, Europe (EMEA), and Asia (APAC).

Confidential

Associate Consultant

Responsibilities:

• Completed configuration and setup to meet the business requirements for distribution and manufacturing modules.
• Worked on Flexfields- segments, value sets, values and look up codes in PDH, ERP
• Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization issues
• Troubleshooting the order management, invoices, intercompany, WIP transactions, etc issues using SQL statements in Oracle
• Trained the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way
• Creation and configuration of AOL entities like Form functions, Concurrent programs and their executables.
• Setup of Contract Coverage.
• Documentation of MD200, CV200 and TE20 test Scripts for the gaps involved.
• Extensively Created custom package and procedures to validate vide variety of different custom QA validations & also some standard validations.
• Development & customization of concurrent program to meet the business requirement
• Created custom Views and attached to the Custom Supplementary data source.
• Developed Conversion programs as per business requirement.
• Registration of Reports, Forms, Host and SQL Programs.
• Providing necessary SQL reports to business heads
• Solved urgent/critical cases very rapidly before they got escalated during SITs & UAT.
• Done code migration during cutover and production and solved issues as and when raised.

Confidential

Associate Consultant

Responsibilities:

• Documentation of MD200, CV200 and TE20 test Scripts for the gaps involved.
• Created interfaces for different custom validations & also some standard validations.
• Development & customization of concurrent program to meet the business requirement
• Developed Conversion programs as per business requirement.
• Setup of Responsibilities, DFFs, System Profile Options.
• Registration of Reports, Forms, Host and SQL Programs.
• Providing necessary SQL reports to business heads
• Done code migration during cutover and production and solved issues as and when raised.
• Solved urgent/critical cases very rapidly before they got escalated during SITs & UAT.

Confidential

Software Engineer

Responsibilities:

• Developing the code
• Code document generation
• Solved urgent/critical cases very rapidly before they got escalated during SITs & UAT

Environment: Oracle Order Management, Shipping, Inventory, Oracle Field Service, Oracle Service