SUMMARY

• Over 8+ years of Oracle Applications experience as a Functional/ Business Systems /Support Analyst.
• Strong experience in understanding user requirements, System Analysis, writing the functional documents and production support activities.
• Development of the above deliverables was met under tight deadlines with exemplary quality. Rich experience in system testing and implementation of developed software.
• Over 8 years of extensive Enterprise application Design, Development, Testing, Implementation, Upgrade, Customization, Integration, experience in all kind of application environments.
• Expertise in System, Functional, Production Support and Issue resolving and handling TARs with Oracle support.
• Worked extensively with business users/super users, IT, and various levels of the company in analyzing and evaluating existing or proposed complex ERP and other systems.
• Business requirement gathering and architecting experience in Financial and Manufacturing industries.
• In depth experience of designing solutions with Order to Cash (O2C) and Procure to Pay (P2P) process.
• Good knowledge of the various stages of Software development life cycle (SDLC) in an ERP environment.
• Good analyzing and problem solving skills, and worked in design, testing and implementing /deploying the ERP systems. Developed and executed end - to-end business solutions.
• Strong knowledge in Cross-functional and integration of Oracle SCM and ERP modules.
• Participate in Test cycles of other projects that impact the Order to Cash (O2C) and Procure to Pay (P2P) Process in this division.
• Worked on gap analysis, solution specification, design review as well as QA testing for local projects.
• Implemented Oracle manufacturing modules like Inventory, Purchasing, Bill of Material, Work in Process, Order Management and financial modules of Oracle Receivables, Oracle Payables and General ledger.
• Implemented approved enhancements and support the project rollouts.
• Hands-on experience in several aspects of Oracle and other related tools and technologies. Used Oracle 11g/10g.
• Well organized and capable of multiple tasks and managing time efficiently.
• Strong ability to learn, grasp and deliver both individually and also as a proactive team member.
• Experience working with Onsite-Offshore delivery model.
• Worked on defining AME rules in iProcurement.
• Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users, DFF and Profile Options.
• Well versed in the different stages of Software Testing Life Cycle from the conception of preparing test plans and test cases to the CRP and UAT test phase.
• Provided guidance and recommendations on process improvements and “Best practices”.

TECHNICAL SKILLS

Application: Oracle Applications (R12,R11i)

Oracle Modules: Oracle Apps Releases 12, 11i Manufacturing(SCM)/Finance PO, INV, ASCP, BOM, WIP, OM, AR, AP, GL, FA, Pricing, iProcurement Involved in Full life Cycle implementations, Upgrades and production support.

Languages: SQL, PL/SQL

Databases: Oracle 11g/10g

Tools: SQL*Plus, SQL*Loader, Toad, MS Office products MS Word, Excel, PowerPoint,Visio

Operating Systems: MS Windows XP/NT, HP UNIX and Linux.

PROFESSIONAL EXPERIENCE

Confidential, California

Functional Support Analyst

Environment: SCM R12, Finance R12, Inventory, PO, OM, BOM, WIP, AR, AP, FA, GL and ASCP.

Responsibilities:

• Involved in requirement gathering, Functional solution design, setups and user training.
• Involved in Production support activities after go live.
• Modules involved in this project are SCM modules of Order Management, Inventory, Purchasing, Bill of materials (BOM), Work in Process (WIP), ASCP and finance modules of Oracle Payables, Oracle Receivables, Fixed Assets and General Ledger.
• Resolved issues in AP invoicing, AR auto invoicing, purchasing approval hierarchies, order management picking and shipping issues.
• Supported month end activities.
• Provide resolution for ASCP Planning work bench issues.
• Training provided to users In ASCP (Workbench, Horizontal Plan, pegging).
• Resolving Physical Inventory and Cycle Count Issues in Inventory Application.
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations.
• Extensively worked and resolved the issues on Work Flows (Requisition, Purchase Order, RMA Order, Standard Sales Order, Internal Sales Order, Drop Ship Order)
• Resolving the critical issues in Test instances and migrate to PROD instance.
• Worked and fixed the root cause problems in BOM, WIP Applications.
• Creation of Multi level Standard Bills with alternative routing & Substitute components
• Creation of WIP Job Routing / Job Costing & configuring outside processing process.
• Worked on workflow notifications and re-routing the notifications to other employees based on the super user requests.
• Worked extensively on Over (or) Under Shipment tolerances and corrected the setups to populate those values as needed in Order Management module.
• Worked on Processing Constraints, Validation Templates, and Record Sets and corrected the setups according to the business needs in Order Management module with the SOX approval.
• Load GL journal vouchers through web ADI.
• Implemented Fixed Asset module in different locations.
• Converted Fixed Asset data into Oracle through web ADI.

Confidential, California

Business System and Functional Analyst

Environment: SCM R12, Inventory, PO, OM, BOM, WIP

Responsibilities:

• Involved working with SVG and HDS team to define new data mapping to Servigistics v10.3.
• Resolved issues on data feed that HDS currently sends to Servigistics v8.1.
• Reviewed current oracle programs to identify the gaps and issues.
• Involved in requirement gathering, solution design and prepare BRD, FSD, and BR100 (Setup) documents by using Oracle AIM methodology and involved in testing.
• Worked with the client on final signing process in the UAT testing stages.
• Worked on Post production support.
• Modules involved in this project were OM, Inventory, BOM, WIP and Purchasing.

Confidential, California

Business System / Functional and Support Analyst

Environment: SCM R12, Inventory, PO, OM, BOM, WIP, AR and AP.

Responsibilities:

• Participation in requirement gathering and solution design meetings with business teams and IT teams.
• To conduct the solution confirmation activities and the fit/gap analysis, identify key gaps and ensure that the foot prints and design meets the local requirements.
• Implement approved enhancements and support the project rollout.
• Ensure design fits with current requirements and future business direction.
• Ensure Change Management process is followed for all changes to Production system.
• To communicate the functional and process requirements to the development team by developing and maintaining functional specs documents.
• In coordination with users and business team involved for requirement gathering and solution design and prepare RD050, MD050 (FSD) and BR100 (Setup) documents by using Oracle AIM methodology and involved in testing.
• Extensively worked on Change Requests (CR's).
• To run functional, integration and User acceptance testing.
• Created South Africa Operating Unit, Inventory Org, Sub Inventory and Locators.
• Assigned all Organization parameters to South Africa OU.
• Inventory Org has been setup based on South Africa fulfillment models.
• Intercompany setups and Intercompany account setups have been done.
• Worked extensively on Inter Company transactions, Inter Organization transactions in Inventory application.
• Created Inter Company price list for Inter Company transactions in Order Management and Inventory application.
• Various Order Management Transaction types have been setup to fulfill business needs and DFF’s have been setup to capture additional information.
• RMA Fulfillment business model with defective parts received has been setup.
• Resolved the issues while importing the orders from Siebel to OM Application.
• Captured the full acquisition costs including taxes, services and others additional costs for all South African sales order.
• Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management.
• Extensively worked on Price Upload, Item Upload, Autogen process to create / update the Items, Prices in Oracle.
• Worked on Item cross references like customer and supplier items.
• Setup has been done to fulfill all inventory and Shipping functions by using the scan gun functionality of WMS.
• Created functional spec document to capture information on supplier custom report based on South Africa localization requirement.
• Created functional spec document to capture additional information on the Oracle WMS forms for new Distribution Center.
• Purchasing setup done to satisfy local procurement and receiving.
• Defined AME rules and attaching conditions and approver groups in oracle iProcurement.
• Setting up of ASL, Sourcing Rules, and Assignment Set for Inventory Min Max Planned Items with release generation method "Automatic Release" for auto generation of Blanket Releases and Standard Purchase Orders.
• Working extensively on Advanced Pricing setups in Oracle Order Management - Defining Pricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, and Freight Charges.
• Setting up the Drop Shipment and Internal Orders for some of the service items in the Oracle Order Management module.
• Creating the option classes in the Bill of Materials Application for the service items selection in the Order Management (OM).
• To lead functional conversion activities in the specific area like item, item category, Bill of Material, Customer and supplier conversions.
• Modules involved in this project are SCM modules of Order Management, Pricing, Inventory, Purchasing, Bill of Material (BOM), Work in Process (WIP) and finance modules of Oracle Payables and Oracle Receivables.
• Resolving the issues on Pending Transactions from various applications.
• Resolving the month end issues and prepared a setup document for Month-end closing
• Involved in production support after go-live.

Confidential, California

Business System / Functional Analyst

Environment: Oracle Application R12 Inventory, PO, BOM, WIP, OM, Shipping, AR

Responsibilities:

• Participation in requirement gathering and solution design meetings with business teams and IT teams.
• To conduct the solution confirmation activities and the fit/gap analysis, identify key gaps and ensure that the foot prints and design meets the local requirements.
• Ensure design fits with current requirements and future business direction.
• To communicate the functional and process requirements to the development team by developing and maintaining functional specs documents.
• To run functional, integration and User acceptance testing.
• Setup of ATO and PTO items for the configuration item in BOM.
• Worked on ATO, PTO, Drop Ship and Back to Back order flow process.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Worked on Modifiers, Qualifiers, and Price List setups to define the discount (or) surplus charges at various levels in OM application.
• Worked extensively on Over (or) Under Shipment tolerances and corrected the setups to populate those values as needed in Order Management module
• Resolved the critical issues on Shipping Execution while Ship Confirming the Sales Order.
• Modules involved in this project are SCM modules of Order Management, Inventory, Purchasing, Bill of Material (BOM), Work in Process (WIP) and finance module of Oracle Receivables.
• In coordination with users and business team involved for requirement gathering and solution design and prepare RD050, MD050 (FSD) and BR100 (Setup) documents by using Oracle AIM methodology and involved in testing.

Confidential, Fremont, California

Business System / Functional and Support Analyst

Environment: Oracle Applications R12 (12.1.2), OM, AR, INV, Pricing, Costing.

Responsibilities:

• Worked as a Business Systems Analyst for Oracle Applications for the project Deferred COGS and Revenue Reconciliation at Confidential .
• Analyzed the Business structure of Confidential and prepared Business Requirement and Solution Design document to work according to the requirements.
• Worked on the modules Order Management, Inventory, Accounts Receivables, Pricing, and Costing.
• Analyzed how cogs and revenue portion gets affected for different Order types and RMA types like Return for credit, RMA without credit, RMA Credit only, Advance exchange, Return Exchange and Warranty replacements.
• Worked with technical team to resolve the order type work flow issues and for exporting the custom report into discoverer report.
• Involved in creating modifiers, qualifiers and discounts for various price lists for various customers.
• Developed high level test scenarios to check the R12 functionality of Deferred Cogs and Revenue Recognition for different order types and RMA types.
• Created test scenarios, test cases and test scripts in order management, receivables and costing modules from Order entry to COGS recognition.
• Involved in unit testing as well as end to end testing of order to cash and costing cycles.
• Interacted with Business users to resolve the Deferred Cogs and Deferred Revenue Reconciliation issues.
• Involved in Reconciliation of user data and custom report extract.
• Created desk procedures and User document for training.
• Used Oracle support for tracking and solving Cogs issues for RMA.

Confidential, Seymour, Indiana

Business System / Functional and Support Analyst

Environment: Oracle Applications 11i, INV, PO, AP, OM, AR

Responsibilities:

• Worked as a Business Systems Analyst for Oracle Applications Up gradation Project at Confidential , INC.
• Analyzed the Business structure of Confidential , INC to work according to the business requirements.
• Worked across all SCM and Finance modules like Procure to Pay and Order to Cash cycle which includes Accounts Payables, Purchasing, Bill of Material (BOM), Inventory, Order Management, Pricing and Accounts Receivables.
• Created Multiple discounts and promotion types based on customer, order types, items and attached it to a price list.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application.
• Worked on workflow notifications and re-routing the notifications to other employees based on the super user requests.
• Resolving the issues on Pending Transactions from various applications.
• Resolving the month end issues and prepared a setup document for Month-end closing.
• Worked with client in suggesting & developing position hierarchy for organization in Purchasing module.
• Good Knowledge on Blanket Purchase Agreement and Releases in Purchasing Application.
• Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing.
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing.
• Worked extensively on Item categories, Category sets, Category codes and resolved the issues on Item categories for the reports in Inventory and Purchasing modules.
• Developed Setup documents and did setups for PO (Sourcing Rules and Assignment Sets), AP (Suppliers and Invoices), INV (On-hand Quantities), Order Management and Accounts Receivables.
• Prepared Mapping document BR.030 and setup document BR.100 for Inventory, Purchasing, Payables, Order Management and Receivables modules.
• Prepared Test scenarios and scripts. Conducted CRP & UAT testing.
• Created desk procedures and training material for user’s reference.
• Worked with technical team to resolve / provide technical issues.
• Writing / executing scripts using Toad to perform various extracts from database.
• Involved in production support after project upgrade. Resolved many issues related to Oracle O2C and P2P flow.
• Provided user training on Oracle Accounts Payables, Inventory and Purchasing module.
• Used Oracle support for tracking and solving issues.

Confidential, Sunnyvale, California

Business System / Functional and Support Analyst

Environment: Oracle Applications R12 (12.0.3) INV, BOM, WIP, PO, AP, OM, AR,ASCP

Responsibilities:

• Involved in R12 (12.0.3) Implementation Order Management, Receivables, Inventory, Purchasing and Accounts Payables.
• As a Business Systems Analyst, responsible for studying the business process. Prepared AS-IS understands document for OM, AR, AP, PO, INV and Advanced Pricing.
• Assisted in business process reengineering, created TO-BE process document.
• Gathered business requirements, analyzed the structure and performed GAP Analysis.
• Created documents to make presentation to the client.
• Performed set-up for Order Management, Accounts Receivables, Purchasing, Accounts Payables, and Inventory.
• Performed end-to-end testing of O2C and P2P modules.
• Involved in implementation of SCM and Finance modules.
• Involved in Oracle ASCP implementation. As part of ASCP implementation performed d unconstrained plan setups. Created multiple plans for multiple operating units.
• Created various simulation sets with or without safety stock to analyze the benefit of planning before implementing plan options.
• Gave ASCP training to middle and end users to use the planning workbench, and how to drill down. How to analyze the workbench and also how to verify whether the recommendations suggested by system is correct. Performed set-up for Oracle ASCP unconstrained Plan.
• Resolved ASCP issues after implementation and giving support in areas like analyzing the safety stock information, inventory netting, analyze supply and demand picture of an item and analyze why certain sales orders are missing in pegging.
• Worked on Modifiers, Qualifiers, and Price List setups to define the discount (or) surplus charges at various levels in OM application.
• Resolved the issues on Taxes, Freight charges for the customers in Order Management Application.
• Worked on Shipping Tolerances at Customer level in Order Management Application
• Troubleshooting and clearing the PO Approval issues, Stuck POs from the Workflow utilizing the standard scripts from Oracle.
• Prepared training documentation (desk procedures) for user’s reference related to OTC and P2P modules and developed Functional (BR100) Design Documents.
• Interacted with users and developed Setup documents for Item (INV), Bill of Material (BOM), Order Management, Pricing, Receivables, Purchasing and Payables.
• Involved in activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, creating responsibilities, menus, and registering the concurrent programs.
• Worked on Shipping Tolerances at Customer level in Order Management Application.
• Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups according to the business needs in Order Management module with the SOX approval
• Conducted CRP & UAT Testing and provided user training.
• Enabling Key Flex field and Descriptive Flex field.
• Prepared issue and risk tracker and submit to client on a weekly basis.
• Testing of various test scenarios of Order to Cash and Purchase Requisition to AP Invoicing.
• Created desk procedures and training material for user’s reference.
• Used Oracle Support to track issues.
• Did post production support after GO-LIVE.

Confidential, Sunnyvale CA

Business System / Functional Analyst

Environment: Oracle Applications 11i INV, PO, AP, OM, AR

Responsibilities:

• Actively involved in Oracle application upgrade project from 11.5.9 to 11.5.10.
• Created detailed test scripts and integrated test scripts for most of the modules like OM, AR, INV, PO, and AP, OSFM.
• Involved in Oracle SCM and Finance modules.
• Review 11.5.10 new features and recommend to client.
• Training to oracle users.
• Actively involved in CRP1 & CRP2 and coordinated testing activities with US and Israel users.
• Involved in child applications testing like Noetix views & Optio (form printing)
• All documents were uploaded to share point (document control) for all the users to review.
• Worked on multiple TARs with Oracle to resolve lot of 11.5.10 issues
• Did post production support after GO-LIVE.

Confidential, Santa Clara, California

Production Support Analyst

Environment: Oracle Applications 11i INV, PO, AP, OM, AR

Responsibilities:

• Worked as a techno-functional Analyst of Oracle ERP System (Manufacturing & Finance)
• At Confidential resolved day-to-day user issues and interacted with the management for all MIS data need.
• Resolved issues in AP Invoicing, Purchasing, Inventory, Order Management and AR Invoicing.
• Downloaded Sales tax rates from Tax ware Software and uploaded to Oracle
• Working with Oracle Support System to resolve critical issues and apply Patches.
• Gathered requirements from the user group and implemented new functionalities.
• Reviewed Setups and trained the users at all levels.
• Created users, customized menus, and responsibilities.