SUMMARY:

• 14+ years of Oracle ERP experience which include many Full Life Cycle Project Implementations (SDLC), in Oracle SCM and CRM Tracks and modules and Oracle Applications ERP implementation and post implementation project experience (Project Kick off, Business Blueprinting, BPR - Process Re-engineering, configuration, customization, data conversion and data load, Oracle application extension and interfaces) as an expert in Supply Chain Management (SCM,ASCP), Order Management (OM), Oracle CRM, Oracle sourcing, Purchasing (PO), Inventory Management (INV), Warehouse Management (WMS), Shipping Execution, Bill of Material (BOM), Work in Process (WIP), Production scheduling and Oracle Financial(AP,AR,GL).
• Business exposure to Manufacturing, Sales, Service and Distribution, Supply Chain Management, Inventory and Warehouse Management, Logistics and Transportation Management in the various industry segments such as Aerospace, Technology and Telecommunications, Media and Electronics.
• Total 13+ years of ERP experience in Oracle SCM, CRM, Purchasing, OM, Inventory& Supply Chain Management and Oracle Applications (10.7, 11.0.3 and 11.5.10, R12) - Functional expertise in Manufacturing and Supply chain and Financial Modules e.g. OM and Advanced Pricing, INV and WMS, Shipping Execution, oracle production scheduling, PO, BOM, WIP, Order to Cash and Procure to Pay Cycles. Proficient in GL, AR, AP, CM and FA, Oracle CRM.
• Experienced in Implementation and Post Implementation Operational Support of ERP System for multi billion global business spread across continents having thousands of users.
• Led third party product integration to Oracle Applications related to shipping (UPS/Fedex), and Order Entry (Siebel).
• Experience in Business Process Design and Functional Design As-Is and To-Be Checklists.
• Experience in full life cycle development and deployment of P2P, O2C, and ASCP.
• Good Experience in Oracle Picking and Shipping, Warehouse Management System.
• Experienced in all the manufacturing modules and project management knowledge areas, and handled projects from Project scope definition, project planning, execution, control and closures. Project resource requirements, resource load and resource assignment, time and cost estimates.
• Good experience in ProdERP Project to support the business, and Designing & Maintaining ProdERP enhancements
• Good experience with Extract Transform & Load (ETL) implementation, EDI mapping, EDI Interface, E-Commerce Gateway for documenting/implementing all the necessary business requirements.
• Led teams of developers to implement, upgrade, extend and customize Oracle Applications ERP and other applications for a multinational operation of manufacturing, warehousing, sales, service and distribution environment.
• Worked closely with all level of management and users from different work environment (manufacturing, inventory managers, warehouse, sales and distribution, finance, HR and payroll) to gather requirement, convert requirements into functional designs, get sign offs on functional requirements, create technical documents, develop and help developers and team members develop the solutions. Created Test Plans, User Acceptance Testing Plan, Sign off and Production Implementation strategies.
• Experienced in coordination and cooperation among all the stakeholders including functional team, technical development team, Quality Assurance Team, Business Process owners and User community during all the phases of project development and implementation.
• Strong Background experience in understanding of the Oracle Supply Chain/Financials schema and table structures.
• Good experience in CRM Modules Service Contracts and Install Base with mfg requirements
• Experience in interfacing with third party Systems and Working experience in SQL, PL/SQL Unix and TCA Architecture etc.
• Strong understanding of supply chain planning fundamentals and EDI Transactions
• Solving business problems with application (Oracle 11i) functionality.
• Good experience in Driving small & large teams to solutions on production and project issues, including teams of internal business customers, IT testing & development teams
• Manage customer expectations
• Experience in leadership position within the Project Management office organization PMP
• Experience in managing critical interdependencies of related projects.
• Strong background experience to implementing Oracle Manufacturing (Order Management, Purchasing and Supply chain modules) and Oracle Financials (iExpense, iProcurement, iSupplier, AP, AR, GL, CM, FA).
• Good experience in Reverse logistics process implementation.
• Highly experienced in developing & customizing Oracle forms and Reports in Oracle Applications and Discoverer, Workflows.
• Management experience in on site, offsite and outsourced project team’s coordination.
• Created Test Plan and Test Scripts for Unit Testing, Integration and Regression Testing, User Acceptance Testing and Production Cut Over Testing. Test Director for Oracle Apps.
• Proficient in SQL/PLSQL, PL/SQL Developer, Workflow builder, TOAD and Visio, UPK for CRP Testing, Data Loader and SQL Loader for Conversion.
• Proficient in Oracle Applications Implementation Methodologies (AIM)
• Actively involving with business users for user testing (CRP1, CRP2, CRP3)
• Oracle Migration from Legacy system (Puridiom, MXP, Sharepoint)

SKILL:

ERP Applications: Oracle Applications (11.0.3, 11.5.10), Oracle ASCP, Oracle Forecasting and Distribution, Order Management and Shipping Execution (OM), Purchasing (PO), Inventory Management (INV), Oracle CRM, Oracle iProcurement, Oracle iSupplier, Bill of Materials (BOM), Warehouse Management (WMS), GL, AR, AP, CM, FA. Oracle Application Order to Cash and Procure to Pay Cycles.

Database Management Systems: Oracle Database 10g, 9i, 8i, 7.3, Access

Operating System: UNIX, Linux and Windows

Microsoft office Suite: MS Projects 2003, Power Point, Excel and MS-Word

Configuration MGMT: Docushare, Rational Clear Quest

Platforms & Tools used: Toad, Sql, Pl/Sql, Sql*Loader, VISIO, XML, Oracle Discoverer, Oracle Forms and Reports, Perl and Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Functional Analyst

Environment: Oracle Applications R12

Responsibilities:

• Implementation, Support and enhancement of Oracle Application R12 with respect to OM, Inventory, and pricing, Service Contract, Install Base and AR Modules.
• Coordinate with the all teams (Business, External systems, Production Support, DBAs, and Developers).
• Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Setting up Multi-Org (Multiple Organization) Access Control
• Defining price lists, item information, Defaulting Rules, Credit Checking Rules, Processing Constraints, oracle production scheduling and Define Order Management Transaction Types
• Review and delivery of all functional documentation appendices for any additions/changes to existing Oracle R12 solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Developing test plans, conducting testing, design and development of external interfaces, working with department managers on transition plans for re-engineered business processes.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Co-ordinate onsite, offsite and offshore teams in USA, India.
• Complete functional setups as required for implementation of Oracle 12i modules
• Setting up New Order Transaction Types, Process Constraints, Category Codes, Defaulting rules and other related setups for the interface from OM to Nexstra for NA and EMEA region.
• Involved in Designing Process Flows, Gap Analysis, Functional Analysis, and Writing BRD’s, Test Plan, Conducting Testing, Cross functional coordination.
• Setting up coverage templates, contract groups, templates and other mandatory setups including contract approvals process.
• Trained Service Contracts and OM Users through Lunch and Learn sessions

­­­­­­­­­­­­­­­­­­­­­

Confidential

Functional Consultant

Responsibilities:

• Coordinate with the all teams (Business, External systems, Production Support, DBAs, and Developers).
• Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Review and delivery of all functional documentation like SDD, SRD, BRD, BR100, MD050, MD070 and appendices for any additions/changes to existing Oracle R12 solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Define communication plan for team, management, business process owners and other stakeholders like other business groups being impacted, other technical groups involved.
• Lead the definition of project risks, and the required risk responses and mitigation approaches. Monitor project activities for the occurrence of risks, and takes timely action to mitigate the risk. Advises project team members, stakeholders and senior management of actions required or completed.
• Gather business requirements, preparing the DR and identify the business Gaps and cross functional areas and co-ordinate with development team.
• Working with the business owners and key users to understand and develop business processes and produce plans for implementation of changes to the eBusiness system
• Design new processes and changes to existing processes and obtain the necessary approval
• Work as part of an integrated team supporting application within an Oracle eBusiness solution
• Provide support to key users on the utilization of the application and the eBusiness system as a whole
• To develop understanding of the scope and impact of changes and to interpret and develop the execution of these within the Oracle eBusiness system
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Actively involving with business users for user testing (CRP1, CRP2, and CRP3).

Confidential, CA

Functional Lead

Responsibilities:

• Support and enhancement of Oracle Application R12 with respect to OM, Inventory, and pricing, Service Contract, Install Base and AR Modules.
• Coordinate with the all teams (Business, External systems, Production Support, DBAs, and Developers).
• Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Setting up Multi-Org (Multiple Organization) Access Control
• Defining price lists, item information, Defaulting Rules, Credit Checking Rules, Processing Constraints, oracle production scheduling and Define Order Management Transaction Types
• Review and delivery of all functional documentation appendices for any additions/changes to existing Oracle R12 solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Developing test plans, conducting testing, design and development of external interfaces, working with department managers on transition plans for re-engineered business processes.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Co-ordinate onsite, offsite and offshore teams in USA, India.
• Complete functional setups as required for implementation of Oracle 12i modules
• Setting up New Order Transaction Types, Process Constraints, Category Codes, Defaulting rules and other related setups for the interface from OM to Nexstra for NA and EMEA region.
• Involved in Designing Process Flows, Gap Analysis, Functional Analysis, and Writing BRD’s, Test Plan, Conducting Testing, Cross functional coordination.
• Setting up coverage templates, contract groups, templates and other mandatory setups including contract approvals process.
• Trained Service Contracts and OM Users through Lunch and Learn sessions

Confidential, Salt Lake City

Functional Consultant/OM

Responsibilities:

• Gather business requirements.
• Working with the business owners and key users to understand and develop business processes and produce plans for implementation of changes to the eBusiness system
• Design new processes and changes to existing processes and obtain the necessary approval
• Work as part of an integrated team supporting application within an Oracle eBusiness solution
• Provide support to key users on the utilization of the application and the eBusiness system as a whole
• To develop understanding of the scope and impact of changes and to interpret and develop the execution of these within the Oracle eBusiness system
• Experience in Approval methods to route documents for approval
• Develop support processes for application including knowledge management
• Map business requirements to Oracle Applications, Design solutions
• Formulate business test scripts, validate the deliverables
• Setup, configuration and troubleshooting for advanced procurement
• Day to day support for Purchasing and Solve Configuration Problems
• Production support for the core purchasing and iProcurement, iSupplier
• Bug fixes and how it can be communicated & managed to the business
• Third-level Applications Support - help desk ticket analysis and escalated troubleshooting, analysis, issue resolution
• Responsible on implement ProdERP and Communicate Business User for Cross functional areas like Finance Team and development team
• Coordinate with the all teams (Business, External systems, Production Support, DBAs, and Developers).
• Working with business users to define business requirements and CRP, Process Model
• Lead projects as Functional Lead and business analyst and provide solutions to the technical team and business team
• Supporting the Oracle Applications procurement in a global Oracle On-Demand environment.
• Basic troubleshooting (Help interpreting error codes and dumps).
• Bug resolution (Help from Oracle's software engineers for a bug fix.)
• Remedy identification (Assistance in finding workarounds or patches for known issues)
• Management of Oracle Service Requests (SRs)
• Complete functional setups as required for implementation of Oracle R12 modules
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams Understanding of set-ups in relevant modules of Oracle Applications.
• Responsible for Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Review and delivery of all functional documentation like SDD, SRD, BRD, BR100, MD050, MD070 and appendices for any additions/changes to existing Oracle R12 solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Define communication plan for team, management, business process owners and other stakeholders like other business groups being impacted, other technical groups involved.
• Lead the definition of project risks, and the required risk responses and mitigation approaches. Monitor project activities for the occurrence of risks, and takes timely action to mitigate the risk. Advises project team members, stakeholders and senior management of actions required or completed.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Actively involving with business users for user testing (CRP1, CRP2, and CRP3).

Confidential, SAN JOSE

Functional Consultant

Responsibilities:

• Lead customization project of Oracle Reports to include Design, development and implementation of custom application.
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams Understanding of set-ups in relevant modules of Oracle Applications.
• Responsible for Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Review and delivery of all functional documentation like SDD, SRD, BRD, BR100, MD050, MD070 and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Define communication plan for team, management, business process owners and other stakeholders like other business groups being impacted, other technical groups involved.
• Lead the definition of project risks, and the required risk responses and mitigation approaches. Monitor project activities for the occurrence of risks, and takes timely action to mitigate the risk. Advises project team members, stakeholders and senior management of actions required or completed.
• Co-ordinate onsite, offsite and offshore teams in USA, India.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Complete functional setups as required for implementation of Oracle 11i modules
• Co-ordinate on data migration from legacy system into Oracle 11i
• Managed and did hands on Configuration and customization of Oracle Applications to Purchasing.

Confidential, Rochester

Functional Consultant

Responsibilities:

• Re-Implementation of Oracle Applications iProcurement and Procure to Pay with Supplier Collaboration Integration of EDI. Managed with hands on development, and change control request.
• Gather business requirements
• Map business requirements to Oracle Applications, Design solutions
• Formulate business test scripts, validate the deliverables
• Complete functional setups as required for implementation of Oracle 11i modules
• Co-ordinate on data migration from legacy system into Oracle 11i
• Managed and did hands on Configuration and customization of Oracle Applications to Purchasing. Lead customization project of Oracle Reports (GDW) to include Design, development and implementation of custom application for Confidential SC.
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams Understanding of set-ups in relevant modules of Oracle Applications.
• Responsible for Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations.
• Review and delivery of all functional documentation like SDD, SRD, BRD, BR100, MD050, MD070 and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.
• Interact with Business Process Owners and other project stack holders to get functional sign off, Created Test Plan, Integration Test Plan, integration testing, and User Acceptance Testing, and sign off for production.
• Define communication plan for team, management, business process owners and other stakeholders like other business groups being impacted, other technical groups involved.
• Lead the definition of project risks, and the required risk responses and mitigation approaches. Monitor project activities for the occurrence of risks, and takes timely action to mitigate the risk. Advises project team members, stakeholders and senior management of actions required or completed.
• Co-ordinate onsite, offsite and offshore teams in USA, India.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.

Confidential, Rochester

Functional Consultant

Responsibilities:

• Responsible for CRM Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams
• Understanding of set-ups in relevant modules of Oracle Applications.
• Review and delivery of all functional documentation like SDD, SRD and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.
• Build or Buy Decisions/Recommendations. Contract and Vendor Management.
• Define communication plan for team, management, business process owners and other stakeholders like other business groups being impacted, other technical groups involved.
• Lead the definition of project risks, and the required risk responses and mitigation approaches. Monitor project activities for the occurrence of risks, and takes timely action to mitigate the risk. Advises project team members, stakeholders and senior management of actions required or completed.
• Co-ordinate onsite, offsite and offshore teams in USA, India.
• Co-ordinate efforts with business community, end users, database group, system administrator group, and networking groups and developer and business analysis team.
• Handled day to day operational support and production support task assignment during migration of transportation management system, cash mgmt and KRONOS activity System
• Formulation of Work Breakdown Structure(WBS), definition of major project milestones, resource requirement estimates, activity/task list and time estimates, task dependencies, cost and benefit estimates

Confidential

Functional Consultant

Responsibilities:

• Lead a cross functional team to implement, upgrade, extend and customize Oracle Applications ERP and other applications for a multinational operation of manufacturing, warehousing, sales and distribution environment. Liaison between business and IT Teams.
• Worked closely with all level of users from different work environment (manufacturing, inventory managers, warehouse, quality, sales and distribution, finance, HR and payroll) to gather requirement, convert requirements into functional designs, get sign offs on functional requirements, create technical documents and help developers implement the technical design.
• Creation of test plans and test scripts for Unit Testing, Integration Testing, and User Acceptance Testing. Used Test Director for Oracle Applications Testing documentation.
• Designed interfaces and front-end data entry screens and reports between Oracle Apps and remote Point of Sales System.
• Responsible for OM Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams
• Understanding of set-ups in relevant modules of Oracle Applications.
• Review and delivery of all functional documentation and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.
• Configuration based on BR100
• Review and delivery of all functional documentation like SDD, SRD, BRD, BR100, MD050, MD070 and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.

Confidential

Functional Consultant

Responsibilities:

• Responsible for OM Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams
• Understanding of set-ups in relevant modules of Oracle Applications.
• Review and delivery of all functional documentation and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation.
• Configuration based on BR100
• Basic Understanding of Interfaces
• Preparation of Test Plans and Review of Test Plans
• Created test Cases, decided testing strategies.
• SAP to Oracle Data Conversion
• Oracle Migration from Legacy system(SAP)
• Creation of Standard Guidelines for Business Needs.
• Business Flow Execution and bug finding and filing using Test Director.

Confidential

Functional Consultant

Responsibilities:

• Responsible for OM Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations
• Responsible for Managing Business Users, Interaction with Technical and Functional Teams
• Understanding of set-ups in relevant modules of Oracle Applications.
• Review and delivery of all functional documentation and appendices for any additions/changes to existing Oracle 11i solution, test scripts, and setup documentation
• Created test plans, decided testing strategies.
• Setup Creation based on Business needs.
• Creation of Standard Guidelines for User Interface Testing
• Writing test cases for unit and functional testing
• Manual (smoke test) testing and bug finding and filing using MS-EXCEL
• Preparation of Test Plans and Review of Test Plans