SUMMARY

• Over 12+ years of experience in Oracle EBS applications (11i & R12) as Techno Functional Consultant. Worked on Implementation, Upgrade, Development/Maintenance and Operations/Support projects in Supply Chain and Finance modules.
• Functional Knowledge in Inventory, Purchasing, Order Management, iProcurment, Account Payables, Account Receivables, General Ledger with touch points in Warehouse Management System, MSCA and Fixed Assets.
• Proficient in a wide variety of areas include Technical Design Document (MD70),Unit Test Plans, Code Migration Document (CMD) 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
• Hands on experience in Technical areas for Oracle Applications Modules (INV, PO, OM, WMS, MSCA, Shipping, Receiving, Costing, Advanced Pricing, BOM, WIP, ASCP, AP, AR, CRM (Oracle Service Contracts, Install Base ).
• Experience in working on cross functional modules in the environment of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles
• Extensive Experience in SQL, PL/SQL Programming, Oracle Forms, Oracle Reports, SQL Loader, Interfaces, XML Publisher Reports (Data templates and RTF templates) and workflows
• Worked extensively on multiple RICEW(Reports, Interfaces, Conversions, Extensions, Workflow) components tied to SCM/MFG/FIN modules
• Good experience in customization of AME(Approval Management Engine) for PO Approval, PR Approval and AP Invoice Approval
• Experience in punch out setup for various suppliers in iProcurement and Trading Partner setup in XML Gateway modules
• Experience in logging service requests with Oracle to resolve application/system defects
• Expertise with version control and migration tools like Harvest, Kintana,WinSCP,SecureFX and PVCS

TECHNICAL SKILLS

Oracle Applications: R12,R11i, Purchasing (PO), Order Management (OM), Shipping (WSH)Inventory (INV),Warehouse Management(WMS),Mobile Supply Chain(MSCA) Work in Process(WIP),Bill of Materials(BOM),General Ledger(GL),Account Payables (AP),Account Receivables(AR),Oracle Approvals Management Engine(AME), XML Gateway, iProcurement

Other Components: Oracle Workflow, RICE Components, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flex fields, New Module Implementations, Upgrades

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

Development Tools: SQL*Plus, Toad, PL/SQL Developer, Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL*Loader, XML Publisher, Oracle Workflow Builder 2.6, Oracle Discoverer, Oracle Application Framework (OAF)

Languages: SQL & PL/SQL, C, UNIX Shell Scripting, Java

Operating Systems: Win98/XP/7, Windows NT, UNIX

Software: Seapine Version Control, PVCS Tracker, Kintana Migration Tool, Harvest,WinSCP,SecureFX

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Performed functional setups and developed various technical components based on business needs.
• P2P Process - Implemented and supported P2P business flow right from requisition creation(using punch out ) to AP Invoice creation and GL Posting
• Inventory Organization Setup - Setup organizations and locations in Inventory as per business needs
• Employee Setup - Setup various employees based on the data given and added them as worker in system
• Buyer Setup - Performed buyer setup for various employees
• Punch Out Configuration - Setup punch out for various suppliers in iProcurement based on the supplier information provided and tested end to end functionality from punch out requisition to purchase order creation.
• XML Gateway - Setup Trading Partner configuration for various suppliers in order to send PO cXML orders to suppliers once the PO is approved
• Worked onItem Conversionto load items into Inventory by creating staging tables and performing validations through custom packages and finally loading them into Inventory base tables usingAPIs
• Move Order Interface - Developed custom package to interface the data from Omnicell files to Oracle EBS and create inventory move order transactions respectively based on the data
• Requisition Interface - Developed interface program to convert requisitions created into move order transactions based on the availability of on hand quantity for that items
• OAF - Personalized iProcurment page to hide unwanted data to the buyer/user
• Customized PO PDF generated through PO Communication program as per business requirements
• Participated in UAT sessions with users for iProcurment, Inventory and Purchasing module testing
• Performed production support and maintenance of existing finance modules (AP,GL)
• Month end closure process, etc.- As part of month end process, cleared all the transactions stuck in interfaces
• Interaction with Users, Super users to understand the issues/enhancements and provide resolutions
• Strictly followed all the compliance rules while making any change in the system ie documentation, approvals, unit testing, UAT test approval, Change Advisory Board(CAB) meeting, approval in CAB and migration to production system

Confidential, Irvine, CA

Oracle EBS Techno Functional Analyst

Responsibilities:

• Worked on root cause analysis of multiple recurring production issues related to Shipping, Order Management and provided long term fixes
• Troubleshooting Productions issues in WMS, MSCA, OM, Shipping, Receiving, Supply & Inventory
• Developed MSCA personalization in standard Mobile Alias Receipt Transaction page
• Support & maintenance Order to Cash business flow modules
• Support & maintenance Procure to Pay business flow modules
• Worked on Delivery Assignment process for auto creation of deliveries and assign to orders
• Personalization on PO Receipts screen to restrict user access
• Improved the performance of customized Transact move order form for quick transaction of orders
• Interaction with business users for taking business requirements on customizations
• Interaction with end users for issue resolution
• Sales order transaction issues
• Sales order shipment issues
• Serial number correction
• Address correction in Install Base
• Trouble shooting and Prod fixes in Service Contracts
• Worked on Depot Repair issues
• Troubleshooting and fixing the issues on Costing
• Monitor Cost Manager, alerts user when it errors out for any cost issues
• Month end closure process, etc.
• Interaction with Users, Super users in understanding the issues and provide solutions
• Proactively monitoring and fixing the interface errors to keep the system in good condition
• Delegate works to offshore and make sure work get done from them.
• Quarter-end and month-end supports.

Confidential, Newark, CA

Oracle EBS Technical Consultant

Responsibilities:

• Worked on SCM related modules (OM,PO,INV,WMS etc),
• Facilitated execution of CRP, SIT, UAT & Production deployment cut over tasks
• Implementation and Development of various components in Procure to Pay business flow
• Implemented AME Rules and Approval Groups for Purchase Order approval
• Developed approval rules based on PO amount for different type of POs using Oracle Approval Management(AME) and configured action types and actions for PO Approval
• Developed/Restructured PO Approval Workflow using Oracle AME and Oracle Workflow Builder.
• Developed and generated PO PDF reports using XML Publisher Bursting
• Setup attributes, rules, conditions and approval groups in AME for Purchase Requisition workflow
• Developed various SQL queries for dynamic usage in AME attributes
• Defined Oracle Alerts for critical business processes specific to Order Processing/Shipping, Inventory & Receiving to notify the Business User
• Development/Modification of new reports/existing reports using Reports 10g
• Interacted with clients/users to collect the business requirements
• Designed the migration related documents like Unit Test Documents (UTD), Technical Design Documents (TD), Code Migration Documents (CMD) etc, for all the delivered objects.
• Kintana Migration Tool for migrating the objects from Development instance to Test instance.
• Designed and verified all the documents following Confidential ’s SOX compliances throughout all the deliveries

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked on Modules of SCM (OM,PO etc), Manufacturing (INV,BOM,WMS etc) and Financials(GL,AP,AR)
• Enhancement/customization of various objects (Oracle Reports, Oracle Alerts, and Form Personalization, Logical Apps etc) in above Modules.
• Worked on LOGI PO Automation Interface which converts the Purchase Requisitions(PRs) created in iProcurement to Purchase Orders
• Worked on Inbound interface LOGI EDI PO Inbound Process which takes the customer EDI orders, validates the data using various business rules and imports into oracle EBS using APIs
• Worked on complex aging report LOGI Inventory Projection Report which forecasts the incoming quantity and in transit quantity in a particular organization
• Worked on Vendor Managed Inventory customizations in ASCP such as VMI Release Upload and VMI Receiving Upload interfaces.
• OAF - Personalized the tab VMI(Vendor Managed Inventory) in Collaborative Planning page for uploading the VMI Release data and VMI Receiving data
• Worked on PWB Horizontal Planning Detail Report in ASCP
• Worked on Payables Invoice approval process and developed rules and approval groups in AME for AP Invoice approval
• Troubleshoot the issues related to AP Invoice workflow and respective AME rules and conditions
• Migrated several Reports from 11.0.3 to 11i and registered the same in oracle applications.
• Designed the migration related documents like Unit Test Documents (UTD), Technical Design Documents (TD), Code Migration Documents (CMD) etc, for all the delivered objects.
• Extensively used Kintana Migration Tool to migrate the objects from Development instance to Test instance.
• Interacted with clients/users to collect the business requirements
• Designed and verified all the documents following Confidential ’s SOX compliances throughout all the deliveries

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Zensar Project Interface, which will be used to import the project data into Oracle Apps Staging tables using shell script and performing the validations through pl/sql package before inserting into base tables.
• Project Form, in which the existing project form has been restructured completely so that it captures all the project information (Header and Detail) in one window only with efficiently.
• Developed Bank Transfer Form through which fund transfer can be made from one account to another account in Zensar and also the transactions can be uploaded to General Ledger directly.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Involved in all the phases of Implementation of Inventory module.
• Setups for Shipping Networks, Sub inventories and Stock Locators.
• Provided Production Support and troubleshooting issues in Inventory/WMS/MSCA/PO/BOM/WIP
• Interacted with users to collect the business requirements.
• Customization of various Standard Forms and registered these forms in oracle applications
• Development and review of Custom Forms and testing the same.
• Developed several Custom Reports and registered them in oracle applications.
• Interfaces, Concurrent programs and Executables.
• Interfaces to transfer the data from PO to GL.
• Data Migration from Legacy system to Oracle Apps.
• Provided Production Support for Inventory and Purchasing modules.
• Interacted with Oracle Support Team by raising TARs.
• Month end and financial year end closing of Inventory.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Development of Various Reports in PO and Inventory
• Customization of Reports for management information needs.
• Defined Validation types in value set, including defining value set based upon multiple tables, defined value set for reports parameter using hidden-id instead of value column.
• Defining Concurrent Programs and attaching them to specific request group.
• Registering the Reports in Oracle Apps using Application Developer.

Confidential

Oracle Developer

Responsibilities:

• Multi block forms
• Master Detail relationships
• Linking more than one forms
• Various levels of validation checks using Pl/Sql
• Generation and integration of menus and various reports

Confidential

Oracle Developer

Responsibilities:

• Multi block forms
• Master Detail relationships
• Linking more than one forms
• Various levels of validation checks using Pl/Sql
• Generation and integration of menus and various reports

Confidential

Oracle Developer

Responsibilities:

• Worked on Oracle Developer 2000(Forms & Reports) tools
• Involved in development of Banking module which facilitates the maintenance of different banking customers
• Developed form modules which facilitates recording of passenger details, flight details etc
• Developed reports for extracting the required details like passenger details, flight details etc on daily and monthly basis
• Underwent training in Oracle Advanced Forms and Report Techniques