PROFESSIONAL PROFILE:

• Oracle Applications, Release 10.7 to 12.1.3 - More than 17 years of experience in Business Systems Analysis, Functional Analysis, Configuration, Project Management and Full Life Cycle Implementation.
• Experience with complete life cycle of the ERP/CRM development extensions from requirement gathering, GAP analysis, functional/technical designs, test plans, User acceptance testing, training to migration and support of applications
• Well versed with Oracle Application Implementation Methodology (AIM)
• Defined many Business Requirement documents and functional/technical designs for Purchasing, iProcurement, iSupplier, Sourcing, Inventory, Accounts Payables (AP), GL, and Complex Maintenance Repair and Overhaul products (MRO)
• Extensive experience with Procure to Pay and Supply Chain Management processes and modules
• Led very complex and large projects successfully
• Self-motivated and possess excellent communication and interpersonal skills

SKILL:

Project Management: MS Project

Oracle Applications: Purchasing, iProcurement, iSupplier, Sourcing, Order Management, Shipping, Install Base, Advanced Pricing, Accounts Receivables (AR), Payables (AP), GL, Inventory, BOM, WIP, AK Developer, Alerts, Workflow, FlexFields, AOL and SysAdmin.

Programming skills: PL/SQL, SQL, Forms 6, Discoverer, C

Database: Oracle, SQL Server

Operating Systems: Windows, Unix

Others: Visio, MS Word, MS Project, Excel and PowerPoint

WORK EXPERIENCE:

Confidential, Los Angeles, CA

Procure to Pay Lead: Oracle Purchasing and iSupplier

Responsibilities:

• Upgrading Procure to Pay modules from R11 to R12.1.3
• Incorporating new requirements of Mass Cancel, Auto Sourcing, etc.
• Changes to existing requirements on approvals for direct and indirect PO
• Functional design for new requirements and setup (BR100) of Purchasing and iSupplier.
• Confidential, iSupplier, Sourcing, Inventory

Confidential, San Jose, CA

Business Systems Analyst

Responsibilities:

• Analyzing existing spares process and collection of requirements for new spares distribution center
• Integration of new spares DC with existing architecture
• Functional design (MD50) and setup (BR100) of Purchasing, OM and inventory modules.

Confidential, Costa Mesa, CA

Procure to Pay Lead

Responsibilities:

• Collecting requirements for approval enhancements and PO category overhaul
• Architecting and implementing the approval hierarchy from Employee Supervisor hierarchy to position based hierarchy to support approval routing based on direct and indirect buys.
• Overhaul of PO category to categorize items properly for plant purchases and indirect buys
• Integration of iSupplier and Consigned Inventory

Confidential, CA

Functional Consultant

Responsibilities:

• Upgrade of Oracle Purchasing from 11i to R12 - This involved configuration of Purchasing, Blanket, Item and Vendor conversion. Creation of sourcing rules, assignments and ASLs as part of Blanket conversion.
• New Implementation of iSupplier in R12. Requirement gathering, GAP Analysis and functional design for iSupplier module.
• Vendors use the functions of PO Acknowledgement, request changes, send ASNs and view invoices and payments

Confidential, Madison, WI

Procure to Pay Lead: Oracle Applications

Responsibilities:

• Full life cycle implementation of Oracle Purchasing, iSupplier and iProcurement.
• Requirement gathering, GAP Analysis and functional design for Purchasing, iSupplier and iProcurement Modules. iProcurement Punchout with external suppliers
• Integration between ASCP and Purchasing - touchless PO from demand to release generation through Blankets, Sourcing rules and ASLs
• Responsible for implementing position based approval group with multiple position hierarchies

Confidential, San Jose, CA

Business/IT Analyst

Responsibilities:

• Requirement gathering, GAP Analysis and functional design for Confidential Project.
• This project involves providing visibility to serial numbers at vendor locations so that defective goods purging and servicing can be done effectively.
• Interfacing with third party logic providers to enhance their systems to enable Confidential
• Setting up Oracle Modules

Confidential, Oshkosh, WI

Functional Consultant

Responsibilities:

• Requirement gathering, GAP Analysis and functional design for iSupplier module. Oshkosh has 5 divisions and all of the divisions run JDE. iSupplier is implemented as the supplier portal solution for all the five divisions.
• Full life cycle implementation of Procure to Pay modules of Oracle Applications R12. This involves implementation of GL, Multi-Org and MOAC, Accounts Payable (AP), Purchasing, Inventory and iSupplier
• Setting up GL, Payables, Inventory, Purchasing, HR and iSupplier
• Detailing & Performing mock period closes (AP, PO, INV &GL)

Confidential, Palo Alto, CA

Functional Consultant

Responsibilities:

• Validating and testing the business processes and setup for subsidiary rollouts.
• This involves validating the processes from placing a non-catalog request using punch-out to payment to cash reconciliation.
• Oracle Applications 11i iProcurement, Purchasing, Inventory, Accounts Payables, Cash Management (CM), GL

Confidential, Sunnyvale, CA

Sr. Business Systems Analyst

Responsibilities:

• Requirements gathering, Gap Analysis, functional testing, conducting CRPs, UAT and training of Procure to Pay solution for marketing department. This involves Requisition, PO, Release and AP Processes. It also involves custom processes for prior month accrual, negative accruals
• Requirements gathering and Analysis of custom Purchasing processes to accrue based on online clicks and subscribers
• Requirements gathering, Analysis and Design of integration of Atlas (third party marketing system) system with Oracle Purchasing
• Analysis of FEITH system to integrate with Oracle Payables processes
• Oracle Applications 11i Purchasing, Inventory, Accounts Payables, GL, Workflow and FEITH

Confidential, Santa Clara, CA

Functional Analyst: Oracle Applications

Responsibilities:

• My role included requirement gathering, gap analysis, configuration, functional testing, conducting UAT and user training. This project involves automating the PO communication, PO Change, ASN and invoice processes.
• Requirement gathering, gap analysis and implementing Consigned Inventory for supplier. Suppliers use iSupplier to manage and view consignment process.
• Implementing Approved Supplier Management process, which involves integration from Agile to Oracle.
• Requirement gathering, analysis and recommendation of a strategy to implement approvals hierarchy for Purchasing Documents
• Oracle Applications 11i iSupplier, Supplier Collaboration, Purchasing, iProcurement, Inventory, Accounts Payables, GL, Multi-Org and Workflow

Confidential, Fremont, CA

Oracle Functional Consultant

Responsibilities:

• Conceptualizing process controls for Procure to Pay and Order to Cash Cycles.
• These controls analyze the data and present the process violation and fraudulent activities in the system.
• Few examples are overpaid purchase orders; over discounted sales orders, etc.
• Functional Design for Virsa Firefighter. This product has rules to enable responsibilities for users for specific period of time. These users can activate themselves as firefighters and will have all the responsibilities assigned in the firefighter template.
• Functional Enhancements to Virsa Compliance Calibrator. Using Compliance Calibrator, user can define conflicting functions as specified in COSO, COBIT framework. Then system can run to find the conflict for a user or for a responsibility.
• Oracle Applications 11i iProcurement, Inventory, Accounts Payables, Order Management, Advanced Pricing, Shipping, Accounts Receivables (AR), TCA, GL, Cash Management

Confidential, San Jose, CA

IT Analyst: Oracle Applications

Responsibilities:

• Gap Analysis and identifying the customizations and extensions needed for Oracle Accounts Payables
• Setup and Configuring iSupplier
• Analyzing requirements for cXML PO and invoicing using Ariba (ASN) and Oracle Supplier Networks (OSN) for iProcurement, PO and AP
• Analysis and customizations of invoice approval workflow to include the following functionalities: Proxy, dual approval, reminder and escalation notifications, reassign notifications, voting
• Analysis to migrate DFFs from Asia Instance to San Jose instance
• Technical feasibility study of replacing custom notification system with Oracle Workflow Notification for invoice approval notifications
• Analyzing requirements for document imaging solution for invoices
• Gap analysis for bank account auditing requirement for SOX compliance
• Reviewing Technical Design Documents
• Evaluating the upgrade strategy for upgrade from 11.5.8 to 11.5.10 for Accounts Payable and FND
• Oracle Applications 11i iProcurement, iSupplier PO, AP, Cash Management, Workflow, Multi-Org

Confidential, Sunnyvale, CA

IT Analyst

Responsibilities:

• Gathering requirements and analysis of processes for multiple operating units to implement Multi-Org solution.
• Gathering requirements and designing customizations to requisition and PO workflow in iProcurement and PO. Implemented the following functionalities for requisition workflow: multiple approvals in different HR hierarchies, multiple approvals based on the amount of the requisition, addition of new approver in the list of approvers, proxy
• Gathering requirements and designing “Recurring Billing” custom module. This module allows generation of periodic invoices automatically using user definable template invoices in Accounts Receivables (AR). It also performs proper Revenue Recognition. Invoice Open Interface and Customer Open Interface are used for invoice creation.
• Configuring and setup of template invoices
• Gap Analysis and Designing custom form to enter additional parameter for template invoice in “Recurring Billing” custom module for AR
• Gathering requirements for “Managed Services” business process and Gap Analysis.
• Designing and Developing interface to Purchasing to create PO to vendors for “Managed Services” module. Purchase Document Open Interface for Standard PO is used for this.
• Designing and developing a zoom form to integrate with PO form to enter details for PO line
• Designing and developing interface to create AR invoice for “Managed services” module. Template invoices are created for periodic billing or direct invoice is created for one time billing
• Customizing Drop Ship functionality in Order Management. In standard OM functionality, externally sourced line automatically goes to awaiting receipt after booking. It was customized to do purchase release only when ASN is received so changes to PO and Sales Order are synchronized. Receipt creation process in Receiving is also customized so that it need not be entered manually.
• Designing and Developing material transaction issue in Oracle Inventory for Drop Ship sales order
• Supporting customizations to Drop Ship workflow. Created hold activity to put the order on hold so that it does not purchase release.
• Gathering requirements for “Sales Commission System”
• Designing and developing Sales Commission System using rule based system which automates the commission assignment for salesreps depending on various complex rules involving the customer, bill to, ship to, referral, parts, etc. This system allows definition of territories, assignment of territories to the salesreps, assignment of customer sites to salesreps and assignment of referrals to customer sites. This system also allows the split of sales commission to more than one salesrep for a deal.
• Gathering requirements for “Point of Sale System”
• Designing and Developing “Point of Sale System”. Apart from directly selling to businesses and customers directly, Fujitsu sells to resellers also. Then the system has to pay commission to the salesreps based on whom the reseller sells to. I designed and developed this system to enable resellers to send POS information and process in the system so that commission could be paid correctly. An FTP program and a form were developed to process this information.
• Designing the interface to Advanced Pricing API from custom OE tool. Discounts, pricing qualifiers and pricing modifiers are setup in Advanced Pricing. Custom OE tool uses the APIs to get the final price
• Oracle Applications 11i iProcurement, PO, Order Management, Accounts Receivables (AR), TCA, BOM, Inventory, Advanced Pricing, Multi-Org, Oracle Workflow

Confidential, Redwood Shores, CA

Product/Development Manager

Responsibilities:

• Service Request integration with MRO. A new user interface was created in Oracle Service module to enable adding maintenance requirements to Service Request
• Gathering requirements for Configuration module to model complex equipments
• Gathering requirements for configuring an instance of a complex equipment
• Gap analysis to integrate a configuration with Oracle Install Base and Oracle Contracts
• Gathering requirements and Gap analysis for generating suggested maintenance plans for a Unit (complex equipment). The Unit Maintenance Plan supports the following functionality: Maintain utilization forecast, View remaining serviceable time of units, Model repetitive maintenance requirement over a time period, Calculate due date of maintenance requirements and Associate maintenance requirement to visit.
• Gathering requirements and GAP Analysis for outside processing of service
• Creating a custom workflow to automate the outside processing. This workflow process automated creation of PO, creation of ship only sales order, creation of RMA and closing of the production job
• Designing interface to Oracle Purchasing to purchase service for outside processing
• Designing interface to Order Management to create “Ship Only” order to ship the unit for outside processing
• Gathering requirements and Gap analysis for servicing the unit. Unit servicing (Production) module supports parts change, material transactions and production jobs. This module integrates with Oracle Installed Base, Inventory, WIP
• Integrating with Advanced Pricing to arrive at maintenance requirements cost
• Business process mapping
• Managing development and testing team
• Functional Design of Route, Operation and Job Completion UIs. At the time of execution of a job, the route, operations and job completion status are interfaced to WIP
• Oracle Applications 11i MRO, PO, OM, Inventory, WIP, Installed Base, Service Contracts, Advance Pricing

Principal Engineer

Confidential

Responsibilities:

• Designing and leading the development of Purchase Document Open Interface for Standard POs. Oracle purchasing previously allowed Blankets and Catalogs to be imported using open interface. I extended this feature to allow import of Standard Purchase Order.
• Designing, Coding and Testing of Purchase Order Acknowledgement and Promise Date Change for iSupplier. Once the customer creates a PO, the vendor could immediately see the PO online using PO acknowledgement and acknowledge it online. Vendor could change the promise date online using “Promise Date Change” feature.
• Designing Advanced Shipment Notice function
• Designing and Coding “View Purchase Order flow”.
• Designing and Coding navigation to different UIs from View PO UI
• Supporting and Enhancing Requisition approval Workflow
• Supporting and Enhancing PO Approval workflow
• Oracle Applications 11i iProcurement, iSupplier, PO

Architect/Senior Engineer

Confidential

Responsibilities:

• Integrating Order Management and Shipping system with multiple picking lines for a shipment.
• Designing the workflow process for drop ship functionality which includes purchase release process
• Designing various sets like ship sets, fulfillment sets
• Designing and Developing Pricing Contract functionality for Release 11i of Order Entry System. This module supports recording terms of doing business like freight terms, freight carrier, payment terms and price list. This module supports specifying price for customer items as per volume and discount.
• Designing RMA functionality for 11i release
• Functional and Technical design for freight and Special Charges module for Release 11i of Order Entry System. I designed this module to support multiple charge types and support for multiple charges to an order line.
• Handling support and enhancements to scheduling module for Oracle Order Management release 11i. During that time, I wrote interfaces to Inventory for ATP (Available To Promise), material transactions and material reservations functionality
• Functional Design on the Order Management interface to WIP for configured items in sales order. Configured item is an instance of a BOM.
• Oracle Applications 11i Order Management, Shipping, Advanced Pricing, Inventory, BOM, WIP, and Workflow