SUMMARY:

• 12 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
• 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 .
• 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 and Customization Documentation in accordance with Applications Implementation Methodology (AIM)
• Excellent Leadership, mentoring and interpersonal skills with strong functional background. Experienced with medium to large-scale enterprise software projects.
• Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-à-vis new technology. Easy adaptability to new environments.
• Experience of working in cross-cultural environment.

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

Management Experience: Leading the Supply Chain Functional Team.

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Supply Chain Management (SCM) & Services Transformation Functional Architect

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 Confidential .
• 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 evaluation and support team member for User Acceptance testing

Confidential

Project lead and Sr. Functional Consultant SCM

Responsibilities:

• Client interaction for requirement and SRS validation
• Translating the business requirements into functional and technical specs liaising with the team
• Gathering requirements and implementing change requests.
• Develop, perform, and code review and customization according to the business requirements.
• Design and Development of the ERP (OM,PUR,AP,AR) Interfaces between legacy and oracle Applications.
• Gathered and analyzed the business requirements, Process Mapping and carried out gap analysis
• Responsible for implementing Order Management, Inventory and Procure to pay cycle
• Implemented Approval Hierarchy and Employee/Supervisor relationship for approval of PO
• Defined transaction types, order modifiers and price lists
• Defined shipping parameters, picking rules and credit check rules
• Maintained physical inventory procedures for inventory and sub-inventory locations
• Performed setups for inventory and purchasing
• Analyzing the parameters involved in cycle counting, physical inventory and setup of ABC classes for teams to aid in implementation of counting methodology
• Preparing checklists, templates, estimation guidelines and documenting the processes.
• Work allocation and team management
• Effort estimation and staffing
• Project planning and appraise the project status on regular and need basis
• Ensuring the quality in the project.
• Preparation of Unit test plans, System & Integration test plans, User Acceptance Documents, User Documents and Induction Manuals
• Reviewing/preparing the unit/integration testing.
• Preparing system test scripts and documenting the test results.
• Release of components and deliverables

Confidential

Functional Consultant - CRM

Responsibilities:

• Requirement analysis and translating business/functional requirements into technical solutions.
• Developing the Interfaces between Oracle CRM and legacy systems
• Gathering requirements and implementing change requests.
• Universal Work Queue (UWQ) setups and customizations.
• Reviewing/preparing the unit/integration testing.
• Unit and System Testing and logging the results in Mercury Test Director
• Release of components.
• Change and Configuration management using PVCS, ITG Kintana
• Review of design documents, components

Confidential

Functional Consultant

Responsibilities:

• Oracle Sales (Telesales, Sales Online/Offline and Marketing Online) setup maintenance.
• 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.
• 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 to users.
• Handling the Production Support/ Helpdesk Calls.
• Designed and developed data warehousing interfaces with OM, Billing and CRM systems.