Profile Summary:

• Dynamic and accomplished professional with approx. 12 years of proven IT Operation and Project Management experience with strong credentials and international exposure in end-to-end Implementation, maintenance, migrations, upgrade and integration of Oracle E-business Suite with specialization in MDM.
• Working as a Techno- Functional Architect and Business Solution analyst on implementing PIM and helped client to centralize all product information and creating a single view of product information that is leveraged across all the applications/Businesses.
• Strong experience in design and implementation of Oracle MDM, Oracle PIM - Product Data Hub module on Oracle EBS R12.1.3 and releases. Done 2 full cycle implementations of Oracle MDM PIM/PDH modules for Client like McGraw-Hill Education.
• Designed PDH Product Data Hub DataMart for ASCP and Demantra Implementation project.
• Working on a proposed solution of Oracle Customer Data Hub CDH for McGraw-Hill.
• As a PDH Product Architect and solution designer working in upgrade of Oracle order-to-cash system to release 12.2.4 along with the Re-engineering of the existing subscription process.
• Expertise in suggesting optimum solution, techno-functional assistance to client and implementing new design in Oracle Master Data Management MDM .
• 2 Implementations experience of Oracle Master Data cleansing tool Enterprise Data Quality EDQ , Product Data Quality PDQ .
• Implemented Oracle Custom Desktop Integrator CDI and Product Lifecycle Management PLM .
• Managed and executed Business super user training project of Oracle User productivity kit UPK .
• Designed and configured Workflow for setting up Business Events, designing Event Subscriptions, Change Management workflows, NIR and Change Order workflows and setting up Approvals on Implementing PIM.
• Design and setup of User Defined Attributes UDAs , Multi-row Attributes Attribute groups and all other configuration for PIM application.
• Involved in all phases of the SDLC ranging from CRP, Requirement Analysis, Design, Development, and Implementation and Maintenance of application using Oracle E-Business Suite R11i and R12 .
• Experienced in modules like GL, AP, AR, OM, Supply Chain, Inventory, PIM, ASCP, Demantra, OTC Order to Cash , OKS-Service Contracts, CRM.
• Possess technical skills in Oracle 9i/10g/11g, SQL, PL/SQL, PDQ data lenses, Unix Shell Scripting, Oracle forms, reports, Workflow, OAF pages.
• Involved in testing, Unit testing, Integration testing, end to end business testing, UAT, SME testing.
• Lead, designed and actively taken part in the execution of UI performance to improve the performance of PIM systems using SQL Trace, Explain Plan, TkProf, AWR report, Indexing and Hints.
• Providing standardized and global solutions to specific, segregated and customized business processes, performing feasibility analysis, impact analysis, RCAs, proof of concepts for complex business problems and issues.
• Proficient in maintaining relationship with key customers, identifying sourcing new business, delivering quality service and attaining customer satisfaction.

Management skill:

• Management experience includes both Implementation and Production Support project.
• Management strengths are Client Handling and Project management as a Project Lead, Project Manager and Onsite Offshore Coordinator.
• Lead team of 20-30 resources as Project Leader in major full cycle implementations and end-to-end business support projects within the assigned time, cost and with quality parameters.
• Sound understanding of software development and maintenance processes, good analytical and communication skills as well as experiences of client interaction from onsite and offshore.
• Actively involved in DART reporting, Project status reporting, Client WSR, Team's Week work plan, Onsite/offshore Management, Peer Review's for Deliverables documents, Deliverables Estimation Planning and Project Process Improvements activity.

Technical Summary:

Professional Experience:

Confidential

Role : Techno-Functional Architect and Solution Analyst

• McGraw-Hill Education MHE is a digital learning company and one of the big three educational publishers that provides customized educational content, software and services for pre-K through postgraduate education.
• Project Summary: The project is the Implementation and Global roll-out of Oracle Product data hub MDM Suite PIM 12.1.3 to replace the existing legacy system Master Product Database. The objective of this project is to replace and retire the current legacy system functions, Conversion of legacy system data and Implementation of all existing data maintenance activities.

Responsibilities/Accomplishments:

• Responsible for Functional solution, Gap Analysis and translating business requirements to design documents as a Techno-Functional architect.
• Involved in the end to end lifecycle covering strategy, requirement analysis, design, build, test, rollout support.
• Responsible for Setup of all PDH configurations like ICC, Value sets, Attribute Groups, Product Lifecycle, New Item Request, Change Order, Roles and Responsibility, Display format.
• NIR Item Number generation, Item Description generation and association with ICC.
• Log, view, access, monitor, follow up and close Technical Assistance Requests TARs online-Oracle Metalink and Oracle Applications Patch Management.
• Involved in migration process using FNDLOAD and Metadata Import Programs.
• Design of data cleansing and error review strategy using Oracle Enterprise Data Quality EDQ .
• Extensively involved in Problem Analysis, Design, Build, Unit and Regression Testing, Configuration, enhancement analysis and deployment management.
• Creation and Review of the Requirement/Functional/Technical architecture and design documents for the extension and conversions.
• Lead, designed and actively taken part in the execution of PDH UI and Batch performance to improve the performance of PIM systems using SQL Trace, Explain Plan, TkProf, AWR report, Indexing and Hints.
• Facilitated CRPs with business users to provide findings and to recommend suitable solutions.
• Project management and Co-Ordination between Onsite and Offshore team.
• Addressed issues with data migration from legacy systems for conversions including data profiling, validation, clean-up and remediation of INV and BOM data.

Environment: Oracle Product Hub 12.1.3, Oracle database 11.2.0.1, Oracle Solaris on SPARC 64-bit 10, Oracle Enterprise Data Quality for Product Data 5.6.2.

Confidential

Role : Product Architect and solution designer

Confidential

Project Summary: This project is for upgrading the Oracle order-to-cash system to release 12.2.4 along with the Re-engineering of the existing subscription process.

Responsibilities/Accomplishments:

• As Product Architect responsible for analysis of impact in the existing Product Data Hub system for this upgrade.
• Facilitated CRPs with business users to provide findings and to recommend suitable solutions.
• Identifying gaps between current state and future states of the system and providing all possible customized solutions to fill the gaps.
• Configuration of PDH set ups to fulfill the proposed requirements.
• Design of functional documentation for data lenses which can capture the error details.
• Review of the Technical Design Documents for each of the technical solutions.

Environment: Oracle ERP 12.2.4, Oracle Product Hub 12.1.3, Oracle database 11.2.0.1, Oracle Solaris on SPARC 64-bit 10, Oracle Enterprise Data Quality for Product Data 5.6.2.

Confidential

Role : Product Architect and solution designer

Confidential

Project Summary: The project was the Implementation of Advanced Supply Chain ASCP module and Oracle Demantra as its main demand planning tool. The objective is to implement an automated and end-to-end demand driven Supply plan process across McGraw-Hill Education.

Responsibilities/Accomplishments:

• Designed and implemented a DataMart in existing Product Data Hub module to hold the required data for ASCP and Dementra planning solutions.
• Completed requirement analysis and prepared functional design documents.
• Designed and documented new data cleaning strategy using Oracle Enterprise Data Quality EDQ for this implementation.
• Involved in the end to end lifecycle covering strategy, requirement analysis, design, build, test, rollout support.
• Impact analysis in current Product business process due to new implementation.

Environment: Oracle Product Hub 12.1.3, Oracle database 11.2.0.1, Oracle Solaris on SPARC 64-bit 10, Oracle Enterprise Data Quality for Product Data 5.6.2.

Role : Techno-Functional Architect and solution analyst

Confidential

Project Summary: The project is the Implementation of Oracle Product MDM Suite PIM 12.1.3 to replace the current Oracle ERP item creation and maintenance process for the US Canada and to define an companywide policy and process utilization for product information management.

Responsibilities/Accomplishments:

• As a Techno-Functional Architect responsible for translating business requirements to design documents.
• Involved in the end to end lifecycle covering strategy, requirement analysis, design, build, test, rollout support.
• Implementation and Support of PIM processes, NIR, Change Order, People Role associations and privilege processes, ICC structure, modifying User defined attributes on business requirement, BOM Creation.
• Integration of the PDH application with the existing Oracle Order to cash Cycle.
• Design and review of the Techno-Functional documents for Data Conversions and Migrations.
• Facilitated CRPs with business users to provide findings and to recommend suitable solutions.
• Project management and Co-Ordination between Onsite and Offshore team.
• Project gap Analysis on the basis of Oracle PIM functionality.
• Preparation of strategy document for data cleansing and error review using Oracle Enterprise Data Quality EDQ .
• Review of the Technical Design Documents for each of the technical solutions.
• Extensively worked with Oracle to streamline PIM standard processes, Item creation, Change order creation processes.

Environment: Oracle Product Hub 12.1.3, Oracle database 11.2.0.1, Oracle Solaris on SPARC 64-bit 10, Oracle Enterprise Data Quality for Product Data 5.6.2.

Confidential

Role : Project Manager

Confidential

Project Summary: The objective of this project is to create Oracle PDH training documents and user guides using Oracle UPK User Productivity Kit for US and Canada super users.

Responsibilities/Accomplishments:

• Project management and Co-ordination between Onsite and Offshore team.
• Assessment and road map preparation.
• Review of Oracle UPK- PDH training documents and user guides.
• Executed and managed super user training sessions.

Environment: Oracle User Productivity Kit UPK 11.1

Role : Project Lead

Confidential

Project Summary: MHE GTP Support consists of the following activities like defect resolution, management of enhancement requests received by the MHE Support team Modifications to existing ERP customizations/ enhancements.

Responsibilities/Accomplishments:

• Leading and Managing the team for supporting of McGraw-Hill's Oracle EBS application of O2C flow.
• Analyzed Service Request and defects, found root cause of problems and suggested resolutions and fixed that within defined SLA.
• Worked with the MHE Business analyst very closely for planning the effort, time and resources required for any enhancement and help them implementing that.
• Lead the offshore team, conduct status meetings, guiding them in critical issues, translating business requirements, review coding standards and provide training/mentoring to junior developers.
• Played Key analyst role and involved in understanding the evolving business processes and providing solution.
• Review of Content such as Setup Documents, Flow Models, and Test Scripts for End User training.
• Created and monitored TAR with Metalink for different severities, got patches and applied patches coordinating with Apps DBA.
• Performance tuning for the complex queries by using EXPLAIN PLAN and TKPROF.

Environment: Remedy, Database - Oracle 10g, Oracle ERP 11.5.10

Role : Project Functional Lead

Confidential

Responsibilities/Accomplishments:

• Managing, coordinating, planning and executing project
• Daily Development Interaction with Technical leads for status and any other outstanding issues.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.
• Handling of internal audits and project management reviews
• Supported production environments and users on a daily basis by responding to emergency requests.
• Responsible for Task Allocation, Progress Tracking, Scheduling and Effort Estimation.
• Resource Allocation and Appraisal

Environment: Remedy, Database - Oracle 10g, Oracle ERP 11.5.10

Role : Module Lead

Confidential

Responsibilities/Accomplishments:

• Analysis of Functional design and preparation of Technical design.
• Worked as a Finance module lead of the Production support system to address day to day issues.
• Analyzed Service Request and defects, found root cause of problems and suggested resolutions and fixed that within defined SLA.
• Involved in requirements gathering, analysis, development, QA and post-production support for new enhancements.
• Conduct business meeting whenever required based on production issues.
• Issue tracking, defect fixing and solution, maintaining of documentation.
• Creation of Content such as Setup Documents, Flow Models, Test Scripts for End User training.

Environment: Remedy, Database - Oracle 10g, Oracle ERP 11.5.10

Role : Module Lead

Confidential

Project Summary: This project is an initiative to implement Concur as the replacement of Captura system using Lawson ERP.

Responsibilities/Accomplishments:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Functional review and testing of components.
• Preparation and review of Technical design.
• Unit test plan preparation and review.
• Unit testing, integration testing and participated in CRP, User Acceptance testing UAT
• Prepared training documents and provided training to all Super Users

Environment: Remedy, Database - Oracle 10g, Lawson ERP

Confidential

Role : Module Lead

Confidential

Project Summary: This project is the implementation and customization of Oracle Service Contract OKS module as per the business requirement of.

Responsibilities/Accomplishments:

• Requirement analysis and development of Technical design of interfaces and Reports for OKS.
• Development of modules using PL/SQL which included Template preparation, Trouble shooting, writing stored packages, procedures and functions, Unit testing and Debugging
• Customized PL/SQL Packages and written database procedures
• Created new forms and reports using Forms builder and Reports builder
• Coordination of SIT, UAT and GO-LIVE.

Environment: Oracle 9i, Reports 6i / 9i, Oracle Applications 11i Service Contracts

Confidential

Role : Module Lead

Confidential

Project Summary: This project is enhancement of existing invoicing process so that customer can get the invoice along with the shipment.

Responsibilities/Accomplishments:

• Customization of existing Invoice to make it as per requirement of new Invoice using Oracle Reports 9i.
• Analysis and design of Technical design document.
• Development and customization of various PL/SQL procedures to validate the data coming from Legacy systems as per customer requirement.
• Performed System Administrator functions like registering of new reports, forms, functions, validation sets, request sets and concurrent programs.

Environment: Oracle 9i, Reports 6i / 9i, Oracle Applications 11i OM, AR

Role : Module Lead

Confidential

Responsibilities/Accomplishments:

• Techno-Functional Production Support on Oracle Application 11i Service Contract module.
• Development Supporting of Oracle Report, PL/SQL and Interfaces.
• Fixing of technical and functional related bugs and Unit testing.
• Adherence to Xerox processes like Sarbanes-Oxley, Remedy requirements, development of process documentation, providing effective production support.
• Interaction with the Clients for requirement gathering and issue resolution.

Environment: Oracle 9i, Reports 6i / 9i, Oracle Applications 11i OM, AR

Role : Module Lead

Confidential

Responsibilities/Accomplishments:

Data Conversion from legacy system to Oracle Apps 11i for the modules like Inventory, Item, Cost and Routings etc.

Development of Interfaces.

• Functional Design MD020 and Technical Document MD060 Preparation and Review.
• Development and Customization of ERP Reports using Forms 6i, Reports 6i, Oracle 8i in Oracle 11i Apps
• Development of Scripts for data migration.
• Performed System Administrator functions like registering of new reports, forms, functions, validation sets, request sets and concurrent programs.

Environment: Oracle 9i, Reports 6i / 9i, Oracle Applications 11i INV, BOM

Confidential

Role : Technical Consultant

Confidential

Responsibilities/Accomplishments:

• Development of the solution to fulfill the business requirements in Oracle E-Business Suite.
• Development of ERP Reports, PL/SQL Packages and Procedures based on the requirement.
• Technical Document Preparation and Review.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document.
• Fixing of technical and functional related bugs.

Environment: Oracle 8i, Reports 6i / 9i, Oracle Applications 11i INV, BOM

Role : Technical Consultant

Confidential

Responsibilities/Accomplishments:

• Development of ERP Reports using Reports 6i, Oracle 9i in Oracle 11i Apps
• Preparation of Technical Design Solutions.
• Preparation of Unit Test Cases for the components developed.
• Fixing of technical and functional related bugs.

Environment: Oracle 8i, Reports 6i / 9i, Oracle Applications 11i Supply Chain