SUMMARY:

• I have 16 years of experience in production support, defining ‘As - is’ process flows, solution ‘GAP’ analysis, ‘To Be’ design, development, testing and implementation of Oracle Applications.
• I have excellent experience in various oracle tools like Reports, Forms, PL/SQL, SQL and oracle database concepts. My written and verbal communication skills are excellent.
• I have successfully led multiple projects and have invariably met client expectations.
• As a CMMI Level 5 practitioner, worked mostly on CMMI based project management methodology in Customizations development, Support and Maintenance, Migration and Upgradation projects.

TECHNICAL SKILLS:

Verticals: HealthCare, Telecom, Manufacturing, Hi Tech, FMCG, Promotional products

Domains / Programming Skills: ORACLE Apps 11i/ R12 (PO, INV, OM, EDI, iProc, AME), Oracle PL/SQL, Oracle Forms & Reports 6i, Discoverer, Oracle Apps 11i/ R12 (iStore, iSupplier, BOM, WIP, AP, AR, HRMS)

Tools: & Techniques Pareto Chart, Fish Bone, Lean, Notepad++, VISIO 7.2, Control Charts

Databases: Oracle 8/8I/9I/10G

Software Tools: Developer 6i, 2000 (Forms & Reports), SQL, T.O.A.D, Oracle Workflow Builder, Oracle SQL*Loader

Operating Systems: Sun Solaris, Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead/ Oracle Consultant

Responsibilities:

• Leading a team of 10 people across specialties (Oracle Applications Functional & Technical, EDI) and across locations (Hyderabad, Pune, US)
• Providing Root Cause Analysis and process improvement suggestions to client as value add
• Created and implemented a framework for merging of acquired entities after discussions and deliberations with acquired and acquiring business teams
• Conducting As-is and To-be workshops with SMEs and business teams
• Leading implementation of third party system integrations
• Performing Fit Gap analysis, estimating efforts and preparing BP80
• Setting up locations, organization, sub inventories etc preparing BR100
• Designing custom flows and preparing MD70
• Guiding the development team for bug fixes, enhancements and production issue fixes
• Closely interacting with end user and preparing DO070 for new flows
• Preparing project plans and client reporting by means of weekly, monthly and quarterly status reports
• Writing adhoc data fix scripts to fix production issues
• Interacting with Oracle support by way of metalink Service Requests
• Monitoring key activities like material and receiving transactions on daily, monthly and quarterly basis; employee hierarchy and user administration etc

Technologies: Oracle Apps 11i, Oracle PL/SQL

Confidential

Project Lead/ Oracle Consultant

Responsibilities:

• Managing a team of 25 people across specialties (Oracle Applications, Oracle Database Administration, Oracle ATG ecommerce) and across locations (Hyderabad, Pune, US)
• Conducting As-is and To-be workshops with CIO, Directors and SMEs
• Providing Root Cause Analysis and process improvement suggestions to client as value add
• Providing business case studies and leading preparation of proposals for various clients
• Leading implementation of third party system integrations
• Closely interacting with end user
• Estimating efforts, designing approach strategy, user and preparaing BR100, MD50
• Preparing project plans and client reporting by means of weekly, monthly and quarterly status reports
• Guiding the development team for bug fixes, enhancements and production issue fixes
• Writing adhoc data fix scripts to fix production issues
• Interacting with Oracle support by way of metalink Service Requests
• Organizing Team events
• Monitoring key activities like material and receiving transactions on daily, monthly and quarterly basis

Technologies: Oracle Apps 11i, Oracle PL/SQL

Confidential

Project Lead/ Oracle Apps Functional Consultant

Responsibilities:

• Managing a team of 15 people across specialties (Oracle Applications, User Productivity Kit, Automation Testing)
• Providing Root Cause Analysis and process improvement suggestions to client as value add
• Providing business case studies and leading preparation of proposals for various clients
• Organizing Team events
• Implementing Lean Concepts and executing Tactical Implementation Plan in the project
• Successfully leading team for ISO and CMMI s
• Planning, drafting and executing activities for building interface between 3PLs and Oracle, using EDI
• Leading implementation of Oracle Apps PO (Purchasing), AME (Approval Management Engine), IPM (Image Processing Management), AP (Accounts Payables)
• Closely interacting with end user
• Client reporting by means of weekly, monthly and quarterly status reports
• Preparation of Business Requirements, High Level & Low Level Design documents, user guides
• Guiding the development team for bug fixes, enhancements and production issue fixes
• Writing adhoc data fix scripts to fix production issues
• Interacting with Oracle support by way of metalink Service Requests
• Monitoring key activities like material and receiving transactions on daily, monthly and quarterly basis

Technologies: Oracle Apps 11i, Oracle PL/SQL

Oracle Manufacturing and Distribution Functional Consultant

Responsibilities:

• Evaluating complex client requirements, processing and preparing application systems design specifications using AIM methodology, testing, and implementing cost-effective application solutions in support of the Global Corporate and Enterprise Systems.
• Designing and configuring Order to Cash and Procure to Pay cycles involving Oracle Purchasing, Order Management, Inventory, Shipping, Warehouse Management, Advanced Pricing, Bills of Materials, Work In Process, Accounts Receivables and Accounts Payables
• Monitoring daily and resolving quickly, errors generated through multiple inbound and outbound interfaces
• Designing key Order Fulfillment interfaces with 3rd party logistics
• Working with Oracle Applications 11 i Open Interfaces, alerts and standard reports
• Testing various Mobile Materials Management processes using Mobile Supply Chain Application (MSCA)
• Defining, developing, testing and delivering the deliverables associated with implementing Purchasing and Inventory
• Designing custom workflows for Purchasing
• Working with the B2B team for development, support and maintenance of the EDI business processes and underlying ANSI X12 standards

Technologies: Oracle Apps 11i, Oracle PL/SQL

Oracle Manufacturing and Distribution Functional Consultant

Responsibilities:

• Evaluating complex client requirements, processing and preparing application systems design specifications using AIM methodology, testing, and implementing cost-effective application solutions in support of the Global Corporate and Enterprise Systems.
• Designing and configuring Order to Cash and Procure to Pay cycles involving Oracle Purchasing, Order Management, Inventory, Shipping, Warehouse Management, Advanced Pricing, Bills of Materials, Work In Process, Accounts Receivables and Accounts Payables
• Monitoring daily and resolving quickly, errors generated through multiple inbound and outbound interfaces
• Designing the system with Order management configuration setup and its related setups in E-Commerce gateway, Inventory and purchasing modules.
• Working with Oracle Applications 11 i Open Interfaces, alerts and standard reports
• Designing custom workflows for Purchasing
• Working with the B2B team for development, support and maintenance of the EDI business processes and underlying ANSI X12 standards. Providing inputs to other teams for pre-sales, sales and client presentation purposes

Technologies: Oracle Apps 11i, Oracle PL/SQL

Oracle Manufacturing and Distribution Functional Consultant

Responsibilities:

• Doing Business Requirements Mapping
• Writing functional design specification documents
• Delivering innovative business consulting, business process design, systems integration, and application design
• Designing and implementing Order to Cash and Requisition to Pay processes to create a new level of integration within the organization and with customers and suppliers
• Specifying enhancements to close gaps in standard functionality
• Creating test scenarios and developing test plans to be used in testing the business applications in order to verify that client requirements are incorporated into the system
• Following documentation, version control and testing, and migration standards