SUMMARY

• 10 years of experience in Oracle Applications E - Business Suite (Oracle APPS EBS) Supply chain Management (SCM), Customer Relationship Management (CRM), Distribution and manufacturing modules (11i and R12).
• Completed SIX End-to-End Implementation projects in Oracle EBS across highly complex cross-functional team environments.
• Worked in various roles such as Project Lead, Functional Architect, Senior Functional Consultant Lead.
• Worked in multiple vendor environments and managed/lead large teams across different geographies (Mexcio, Brazil, USA, UK, India) in onsite-offshore model .
• Strong functional knowledge in SCM and CRM modules in Oracle Inventory (INV), Order Management (OM), Warehouse Management (WMS), Bill of Material (BOM), Work In Process (WIP), Project Manufacturing (PJM), Advanced Pricing (QP), Purchasing (PO/PUR), TCA architecture, Account Receivables (AR), Account Payables (AP),Service Contracts (OKC/OKS), Install base (IB), Field Service, Depot Repair, CRM Foundation, TeleService/Customer Support, iSupport, System Administration Modules and Application Object Library (AOL).
• Full-life-cycle (Order to Cash OTC, Contract to Cash, Issue to Resolution, Procure to Pay P2P) implementation cycle experience for multiple Operating Units with Oracle 11i/R12 including post implementation support..
• Configured end-to-end business processes for Warehouse Management, Logistics/shipping execution, Supplier Management, Long and Short cycle orders fulfillment, ATO/CTO Models, Serial genealogy, contracts management, Contract Billing and Pricing, Service and Repair operations and setting up the SCM and CRM modules to support these business processes.
• Excellent knowledge in Manufacturing, distribution, Services, Repair and contracts business processes.
• Extensive experience in Requirements gathering, analysis and understanding of AS-IS and TO-BE models, Gap analysis, documentation and high level design of Business Processes
• Proven experience in leading large Oracle APPS implementations across all phases of SDLC and well versed with multi phase roll out projects.
• Was involved in new Oracle ERP implementation, upgrade and Support project(s) providing Functional expertise.
• Extensively used implementation methodologies viz. Application Implementation Methodology (AIM) 3.0 documents RD020, BP040, BP080, BR100, BR110, BR120, MD050, CV050, and T040.
• Conducted Conference Room Pilots (CRPs) as well as end users training.
• Extensively worked on the functional side of the Interfaces, Conversions and Customizations of reports in Oracle Applications 11i and R12.
• Strong experience in Functional Testing/SIT test scripts creation and execution.
• Provided high quality Key-User/End-User training and Customization Documentation in accordance with Applications Implementation Methodology (AIM)

TECHNICAL SKILLS

ERP: Oracle Apps11i/R12 (Modules INV, OM, WMS, BOM, WIP PJM, QP, PO, TCA, AR, AP)

CRM: Oracle Apps11i/R12 (Modules Service Contracts (OKC/OKS), Install base (IB), Field Service, Depot Repair, CRM Foundation, TeleService/Customer Support, iSupport)

RDBMS: Oracle 8i/9i/10g, MS Access

Tools: & Utilities: SQL, PL/SQL, Data Loader, TOAD, PL/SQL Developer, e-Changeman, ITG Kintana, Workflow Builder, QTP, SQL * Loader, SSH, PVCS Version Controller, HP Quality Center

GUI Tools: Oracle Forms 6i/10g, Reports 6i/10g, Workflow builder, Discoverer 4i,10g XML Publisher

Methods: Oracle Application Implementation (AIM) methodologies, TTM methodologies

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Responsibilities:

• System study and preparing business process diagrams
• Mapping the business processes and Gap Analysis
• Preparing and executing the CRP sessions
• Preparing proof of concepts and solution demos
• Oracle Applications R12 setup for the above modules and preparing setup documentation BR100, BR120s.
• Designing Oracle Applications Inventory and Operating structure of client organizations - Multi-Org Setup.
• Setup of Inventory, Purchasing, Account Payables, AR, Order Management and Warehouse Shipping.
• Implemented OTC cycle for Multiple Operating units. (15-20 OUs and 25 Inv Orgs)
• Design solution and setups for Make To Stock, Make to Order, Configure To order, OTC (Order to Cash), P2P, Issue to Resolution, Depot Repair flows.
• Warehouse Management (WMS) implementation for Confidential Service DCs McAllen TX, Penang Malaysia, GB, Juarez Mexico sites .
• Inventory cycle counting, physical inventory and setup of ABC classes for teams to aid in implementation of counting methodology
• Order Management (OM)/Inventory, WIP, BOM setups and solution design for Confidential sites for EMB business.
• Internal sourcing solution using IR/ISO for Confidential business
• Order Management, Holds for export compliance, Price Lists and Shipping Execution Setups
• Designed and defined Pick/Release rules and bard coded label for shipping execution.
• IR/ISO Internal customer setups for multi path shipping networks.
• Responsible for defining and setting up complete order cycle setups from order entry in order management to ship confirm in shipping execution module to support business requirements
• Confidential business process study and depot repair module setup and implementation.
• SPOC for entire Confidential on Install base and designed out of the box IB solution for Confidential Client, approved by Oracle Corp.
• Preparing business requirements documentation and purchasing setup, Sourcing Rules setup, Approval Hierarchy setup
• Service Contracts setup and warranty management for Confidential business
• Requirements gathering and documentation CRs
• Solution design and documentation DRs
• Conducted CRP sessions to show case the application capabilities in support to the business specific requirements and functions
• Studied the entire application management process and identified areas of improvement to the business process
• Carried the feasibility analysis of the migration of the SAP legacy system into the Oracle Applications R12 system and documented the AS-IS Business Process and framed the solution for the TO-BE process system
• Reduced the business dependencies on SAP legacy systems and framed the solution for the finance transformation on one common business system in Oracle Apps R12
• Gap Analysis Documentation and preparation of Proof of Concepts on various new business processes (POC) during the initial feasibility analysis.
• Suggested ideal work around solutions to fit and fill the gaps.
• Coordinate with functional and technical teams and ensure that the project is on track both in terms of schedule and budget
• Set up test data/scenarios as required for testing.
• Functional testing of the application and customizations
• End user support in testing and customer acceptance.
• Solution Demos to Business
• User Training evaluation and support team member for User Acceptance testing

Confidential, Bloomington, MN

Project lead and Sr. Functional Consultant SCM

Responsibilities:

• Prepared conversion strategy document, migration strategy for source system functionality including custom components.
• Debug and resolve Payables invoice attachment issues with Oracle
• Supported procure to Pay issues with month end and additional configurations
• Set up Account Payables, Setup Payment terms, invoice distribution, matching of invoices against PO
• Preparing MD050 for the below said Conversions, validating the MD070 with technical team and tie back the open balances and master data.
• Conversion of Suppliers,
• Customers Open Purchase Orders,
• Sourcing Rules,
• Oracle quotations,
• AP open invoices,
• Open sales orders,
• Item ABC assignments,
• Item on-hand balance,
• Item attachments from 11.5.10 instance to R12.
• Preparing test case (TE020) for all conversions, and evaluating the converted master data and open balances
• Ensuring the Migration RICE components with technical team and ensuring the custom functionality.
• Load the Master and Transactional data into DEV2, SIT2, UAT1, UAT2, UAT3, REGRESSION, PREPROD instances and data evaluation at each level.
• Data validation, data cleansing, data confirmation in each instance.
• Migration of RICE components from 11.5.10 instance to R12 instance.

Confidential, Dallas, TX

Oracle Business/Functional Analyst

Responsibilities:

• Requirement analysis and translating business/functional requirements into technical solutions.
• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Setting up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module for business transformation phase
• Incorporated a new consolidation center, added new pickup location, order types in Order Management to fulfill the requirements.
• Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks
• Worked in a team in understanding the integration of Advanced Pricing with OM process
• Documented the new business processes & functional requirements & also provided with training materials to the business users.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management, & Advance Pricing modules
• Participated in the User Acceptance Testing (UAT) Planning.
• Designed the UAT test cases for various scenarios.
• Executed User, Integrated and System Level testing with the technical team before the UAT planning.
• Resolved the issues/bugs while the UAT and documented the same for further reference.
• Provided user support in the live phase

Confidential, Rochester, NY.

Business Analyst / Oracle Functional Consultant

Responsibilities:

• Oracle Sales (Telesales, Sales Online/Offline and Marketing Online) setup maintenance.
• Was responsible for doing inventory setups such as defining locations, organizations, sub inventories, units of measure and items.
• Determined and defined the workday calendar.
• Defined and created the shipping networks.
• Determined the process for Min-Max planning.
• Responsible for configuration of the Bill of material module.
• Was responsible for system administrator functions including setting up users, defining responsibilities, determining request groups, and setting menus.
• Involve with user acceptance testing (UAT) and end user training
• Gathered the Requirements by interacting with Business and process experts
• Prepared the documents RD20 (Requirement Gathering), MD50 (Functional Design) and Md070 (Solution Design Document)TE40 (Application Test Scripts)
• Prepared Responsibility matrix based on new roles required to users for Confidential Integration functionality.
• Provided application support and configured all related set-ups for the supplies business process
• Defined the period closing activities related to Varian integration.
• Developed Sales orders importing job for MSS sales orders
• Designed process to load all related look-ups in single shot
• Involved in Functional and integration Testing
• Co-ordination with off-shore technical team and ensure the quality in deliverables
• Developed out bound job for sales orders (dynamically updating the sales orders info into MSS system).
• Developed a new custom logic called as CONSTARINT Inv ALLOCATION.
• Developed custom pick release process for multiple orders.
• Customized OM holds for Confidential Supplies business and customization of workflows.
• Worked on enhancements of the current POO850, 856 EDI jobs.
• Worked on new business changes Confidential ASN processing.
• Design and developing interfaces with ERP systems like AR, GL, HR, and legacy Billing and order management systems.
• Designing and developing XML based interfaces with web based legacy interfaces.
• Designing and developing dynamic approval hierarchy in marketing online and marketing campaign management, Telesales and telemarketing management.
• Telesales dash board set-up.
• Developing excel based tools for customer, prospects and contacts loading into the systems.
• Developing interface programs using TCA API.
• Designed fuzzy algorithms for data cleansing.
• Incorporated new changes in Confidential COMMON Inv. This includes the marinating common inventory between oracle apps and legacy system. Developing common inventory sharing between OTC and XSN system.
• Developed custom logic for pricing of the sales orders and developed the enhancements in modifiers.
• Inventory Transactions Out bound feed to SPARES system from OTC system.
• Developed custom Pallet pricing logic for Confidential business.
• Thorough testing of components before delivering to client, this will reduce the number of defects during DIT.
• Supporting for DIT go-live and burn-in support activities.
• Development of package to process BOM items using open interface
• Conversion of receipts into AR module
• Implemented Oracle Discoverer 4i and developed discoverer reports for Sales and Marketing departments.
• Development of custom JSP forms/reports.
• Maintaining application security and APPS administration.

Confidential

Project Lead, Techno Functional Consultant

Responsibilities:

• Oracle Service Module Implementation
• Integration of Front Office and Back Office functions in Confidential with Service Requests and Workflows.
• Designed and Developed Workflow processes & Escalation frame work according to the business rules.
• Design and development of Service Ticket Management System using Workflows and Forms6i and Reports 6i. (Rollout from SAP to Oracle CRM)
• Design and Development of Discoverer Reporting solution for front office and back office departments (call center, sales, Service, Customer Care and support)
• Design and development of EAI integrated solution between Order Management and CRM systems using IBM MQ Series
• Developing Data warehousing extracts from OM/CRM/Billing to Data warehousing for Customer Analysis, Revenue and Cost Analysis, Network Usage Analysis
• Mapping of Customers between CRM and Order Management Systems(Legacy)
• Developing scripts for Customers Import to CRM( AR Customer Interface)
• Developing scripts for Workflow-Automation, Automatic Service Request, Interaction, Notes, Creation using APIs.
• MQ Series Implementation.
• Developing Discoverer Reports, forms & Reports Customization
• Developing Customized applications in CRM using Forms, D2K & JSP Reports as per client business requirements.
• Maintaining Application Security & APPS Administration
• Developed Inbound(IVR),Outbound, Custom Interfaces with CRM from legacy Systems
• Developing Lib C (C with DB Libraries) programs to extract billing information into CRM
• Gathering Requirements & Implementing Change Requests
• Unit Testing & System testing
• User Acceptance testing, Imparting Training to users.
• Handling the Production Support/ Helpdesk Calls.
• Designed and developed data warehousing interfaces with OM, Billing and CRM systems.