Kovair is now part of SurgeONE.ai | Same experts, even more power.

Month: February 2018

Case Study Managing Migration of Corporate ERP

Project Background

After the merger of the two large chip tool companies, the Corporate Management decided to migrate existing Corporate ERP Application from Oracle to SAP. This is a huge initiative that spreads over a time span of two years. Some of its main areas of coverage include – mapping of existing functionalities available in Oracle with those of SAP, identifying GAPs in functionalities between systems, hiring of resources for development of new capabilities, procuring software licenses for the ALM system and implementation. Involved teams of the project were located in different geographical locations / time-zones. The Project aimed to bring savings through introduction of new capabilities, reduction in costs, increase in efficiency, integrated tools for managing operations and optimum resources utilization. The Project lifespan consist of following phases
  • Pre migration
  • Design
  • Build
  • Test
  • Deploy
  • Post-migration Support

Challenges and Risks

This is a very large enterprise level project, which is to be completed with allocated resources within a fixed time frame.
  • Managing and monitoring of this Project was very difficult due to its size. The Project scope covers 12 Functional Tracks which are further categorized into 50+ Functional Sub-tracks and dealing with 20+ Technologies.
  • Around 1300+ High-level Change Requirements were identified for the Project and these Change Requirements were categorized in Functional Tracks and Functional Sub-tracks. To implement these Change Requirements, 2100+ Delivery Packages and 2200+ Project Docs were created for the Project.
  • Keeping real-time info available for teams was a big challenge as Project was being executed in distributed environment with large teams (600+ Users) located and working from different geographical locations across continents.
  • To manage the Project Lifecycle, the organization was using different tools which were working in isolation and there was no integration
  • Timely execution of all Lifecycle Phases (Planning, Design, Build, Test and Deployment) was very crucial and challenging for this Project.

Kovair Implementation

Kovair Application Lifecycle Management Solution – the ALM was chosen by the Management Board of the implementation team to meet the requirement and challenges of this Project. A brief summary of what Kovair configuration successfully achieved is given in the diagram below.
Kovair ALM

Masters

Kovair brought a holistic approach to Project Management by creating Objects within its ALM. This helped to capture the master data of the Project.
  • Functional Tracks – This object maintains information such as Owner and Lead for the Functional Track.
  • Functional Sub-tracks – This object maintains information such as Functional Analyst, Associated GAPs, and Delivery Packages for the Functional Sub-tracks.
  • Technologies – This object maintains details of Technologies used in the Project.

GAP Requirements

GAP Requirements are a critical part of this Project. Different Project Teams were formed for each Functional Tracks and Functional Sub-tracks and were entrusted with the job of compiling information on the differences between existing Oracle system and proposed SAP system. All these information was then documented in Kovair ALM Requirements Management module as “GAP Requirements”. During the lifecycle, information such as Business Requirement, Solution in Existing Template, Proposed Solution, Owners, and Disposition Methods were maintained. The GAP Requirements were processed through the GAP Requirement Management Function that is one of Kovair ALM capabilities. Once the GAPS were ‘Approved’, Functional Analysts were able to create Delivery Packages to fulfil the GAP Requirements.

Delivery Packages

Delivery Package is the vehicle for implementation of GAP Requirements in the proposed system created after the approval of Requirements. During its lifecycle, the Delivery Package captured details of all the phases like Object Type, Functional Complexity, Build/ Technology Complexity, Owners (Functional Analyst, Dev Lead, Developer), Location of FA and Developer, Target Delivery, Plan Dates (FS Completion, Build Completion, FUT Completion), and Actual Dates.. Delivery Package in Kovair is processed through Delivery Package workflow Process, which takes control of the Deliverable Lifecycle through Activities such as Creation of Functional Specifications, Review of Functional Specifications, Creation/ Upload of Test Cases/ Steps in HPQC, Perform Development, FUT Management, Integration Test Cycle Management, and UAT Management. The Delivery Package Workflow Process in Kovair works in synchronization with HPQC Test Management Data, which is updated in Kovair ALM on real-time through Omnibus Integration Bus in the Kovair Platform and its bi-directional integration with HPQC – the main factors in FUT processing, Integration Test Cycle, and UAT Management.

Project Documents

Project Documents are objects in Kovair ALM that act as repository of Project related documents. This object maintains Project related documents such as Business Process Document, Security Requirements, Test Management Documents, and Training Documents.

Test Management

Test Management aspect of this Project are maintained and managed in HP Quality Center (HPQC). Test Management data is crucial for the Project and we have established integration between HPQC and Kovair ALM through Kovair Omnibus Integration. To capture HPQC Test Management Data we have created entity objects such as – Test Scenarios, Test Cases, Test Steps, Test Runs, Test Run Steps and Defects Management in Kovair ALM. HPQC – Kovair ALM Integration through the Kovair Omnibus synchronizes data between HPQC Test Management Objects and Kovair ALM Test Management in real-time and whenever there is any change (Creation/ Update of records) in HPQC; it is automatically synchronized in Kovair ALM Test Management module.

Kovair ALM Processes

One of the major strengths of Kovair ALM is its enterprise class web configurable process workflow engine. Setting up multiple workflows with this capability is like drawing Visio diagrams with embedded business rules at each process step/ activity. The following process workflows are two such processes, which were configured for this solution.

GAP Requirement Management Process

GAP Requirements are the crux of this Project and senior stakeholders participated in the decision making process to review the business use-case, proposed solution, risk/ mitigation plan, criticality, required budget for fulfilling, and other important aspects. It involves collaboration between different stakeholders for prioritization, feasibility check, planning, delivery creation and closure.
Kovair ALM
Kovair configured and implemented a task-based workflow across all these activities. The highlights of this automated workflow and the benefits obtained out of it are given below.
Process Highlights
  • GAP Requirements are assessed for Technical Feasibility by Requirement Owner.
  • Technically Feasible items are Reviewed by Project Manager and based on budget, criticality and priorities these are Approved/ Deferred.
  • Delivery Packages are created for the implementation of the Approved GAP Requirements.
  • Once All Delivery Packages are closed, the corresponding GAP Requirement also gets closed.

Process Benefits

Process Highlights
  • Auto generation of Tasks for the activity owners as per configured process eliminated the risk of missing any activity in the entire workflow.
  • Tracking the progress of the process graphically helped users to take informed decisions and improving the quality of delivery.

Delivery Package Management Process

Delivery Packages are the vehicles of implementation of GAP Requirements in the Project. The lifecycle of Delivery Package starts with creation of specification documents and then traverses through development, test artifacts creation, testing before final Delivery. The Testing is done in HPQC while the Delivery Packages are maintained in Kovair. Kovair omnibus helped the Organization to achieve a seamless workflow across the tools by integrating these two tools through Kovair Omnibus.
Kovair ALM

Process Highlights from the Kovair Process Workflow Configuration:

  • System Analyst creates Design Specifications for Delivery Package.
  • Development Lead reviews the Design Specifications and Approves/ Changes as needed.
  • Parallel tasks are generated on approval of Design Specifications.
    • The Developer starts Development work.
    • The Tester starts working on Test Artifacts Creation (Test Scenarios, Test Cases and Test Steps).
  • After the completion of Development and Test Artifacts Creation, the Integration Test Cycle (Test Execution, Defect Logging and Closure) is performed.
  • User Acceptance Testing (Test Execution, Defect Logging and Closure) is performed after the completion of Integration Test Cycle.

Process Benefits

  • Auto generation of Tasks for the activity owners as per configured process eliminated the risk of missing any activity in the entire workflow
  • Task based workflow along with integration between Kovair ALM and HPQC allowed the organization to achieve central governance cutting across different tools
  • Tracking the progress of the process graphically helped users to take much informed decision on improving the quality of delivery

Reports & Dashboards

Kovair ALM has built-in reports and dashboard capability. The users can easily configure several types of reports such as Tabular, Word and Graphical (Trend, Distribution Metrics, Pie chart). Knowledge on coding is not required. The reports have drill-down capabilities that enable users to review the records displayed in selected segment of the report. Some of the sample reports that were used in this project are given below.

Open GAP REQs by Criticality and Status

This report helps Management in monitoring the progress of Project by segregating the GAP Requirements based on Criticality and Status.
Kovair ALM

Open Delivery Packages by Object Type and Technology

Major properties of Delivery Packages include Object Type such as Configuration, Conversion, Enhancement, Form, Interface, etc. and Technology such as ABAB, Adobe Form, BI, Middleware, Query, SQL DBA etc. This report helps the management to visualize the overall Project landscape.
Kovair ALM

Open Delivery Packages Design Specs Plan V/s Completion Trend

This report helps stakeholders to monitor the progress of Design Specs Completion against Plan.
Kovair ALM

Open Delivery Packages by Object Type and Build Complexity

This report helps Project Managers in the management of Delivery Package by Object Type and Complexity. Kovair ALM

Project Documents by Document Type

This report depicts the volume of Project Documents by Document Type.
Kovair ALM

Benefits Achieved

  • GAP Requirements are crucial for the success of this Project. Kovair ALM Requirements Management capabilities have helped in Capturing, Collaborative Review, Approval, Management and Processing, and Monitoring of these Requirements.
  • Management Delivery Packages was crucial as Test Management artifacts were being maintained in HPQC. The Integration between HPQC and Kovair ALM through Omnibus Integration has helped to smoothen the Processing (Design, Development, Build, Test and Deployment) of Delivery Packages of this Project.
  • Project Teams were situated at different geographical locations and in different time zones. Kovair ALM, the 100% Web based Application without any client side software has helped in real-time information sharing. This has increased productivity of Project Teams and Users and significantly reduced the waiting time of response
  • Kovair ALM Reports and Dashboards have helped in delivering real-time Project information for Management and different levels of Stakeholders to keep the project on time and within Resource budget.
  • Above all, without the Kovair ALM Solution, major ERP migration project could not have been pulled off on time, on budget, and with the quality that was achieved.
<!– Date & Time: April 4, 2018, 1 PM ET –> Presenter: Soumanil Chowdhury, Manager – Solutions & Services, Kovair Software, Inc.
DevOps has changed the way many IT organizations do business. In fact, recent research performed by Coleman Parks Research for CA shows that 81% of IT Decision makers view both agile and DevOps as necessary tools to digital transformation, and roughly the same percentage are using these paradigms to one degree or another in their organization.
Watch the Webinar
Presenter
Soumanil Chowdhury
Soumanil Chowdhury, Kovair

Soumanil has been associated with Kovair for more than ten years. His key responsibilities are to provide On-site and Off-shore consulting services for complete ALM and Omnibus Integration solution implementation. He also manages projects for Kovair products for the customers.”

For further queries on this Webinar or to schedule a Live Demo, please write to sales@kovair.com

HP ALM to Visual Studio Online - VSO Migration

Introduction

A major provider of equipment breakdown insurance and related inspection services were using HP ALM to manage their Requirements, Tests and Defects. Based on several internal reasons, for instance, changes in their internal software development processes and policies made the organization decide to move from HP ALM to Microsoft VSO. All the accumulated data in HP ALM needed to be migrated to VSO. Post migration, the organization was not planning to use HP ALM, instead start using VSO for managing Requirements, Tests and Defects. The data residing under different folders and the organization of the hierarchical structure was expected to be preserved so that the users in VSO can quickly locate the records. With this data migration objective, the company approached Kovair for a suitable and cost-effective solution through a global reputable service provider.

Challenges

The migration initiative presented the following challenges,

  • The primary requirement was the migration of the requirements, test cases organized in hierarchical test plan folders and sub folders, and defects.
  • All inter relationships were to be migrated; for example – Requirement Coverage, Test Coverage and Defect Coverage.
  • The volume of data to be migrated from HP ALM were in thousands of records and migrating these without automation was a mammoth task.
  • In HP ALM there were multiple Custom Test Plan Folders and Custom Sub Test Folders under which the HP ALM Tests were organized. In VSO however there exists a single Test Plan Folder and several Test Suite Folders containing the Test Cases along with the Test Steps organized as per the Area Path.
  • In HP ALM, Target Cycle is a specialized dependent drop down list type of fields where two information – Release and Versions specific to each release, are organized in a tree view structure within that field. This field was to be mapped to Iteration drop down field in VSO.
  • All Attachments associated with all HP ALM artifacts including Design Steps were to be migrated to VSO
  • Being cross vendor tools, one from HP and the other from Microsoft, there exists no out-of-the-box connectivity between these tools.
  • HP ALM and VSO have contrasting differences in the data organization for various artifacts.
  • Last but not the least, one of the biggest challenge was to run the entire migration directly in the production environment in one shot without any staging instance thereby having very little or no margin of errors in terms of data verification and validation.

All these challenges added up to the complexity of the data migration and the quality of migration of the data needed to be verified.

Header

Kovair, in the first phase of migration started to work towards migrating the data of HP ALM to VSO Development instance. Understanding the data structure and reaching a consensus on the migration use case was the first step towards it. Kovair used its migration and Synchronisation Solution – Kovair QuickSync for migrating the data. QuickSync tool was installed in a server of this organization. Setting up the integration involved a negligible manual effort. This effort mainly consisted of mapping the Projects, Entities, and Fields between HP ALM and VSO. Once done, the rest of the migration was a swift automated process. The configurations were easy, since all Kovair tools have no coding involved and could be accomplished with simple mouse clicks. The migration took care of the most complex challenge – the contrasting data structure in the following ways:

  • The Requirements were migrated as Product Backlog Items into VSO.
  • The test related artifacts as maintained in a folder structure within HP were migrated to the corresponding test artifacts and similar folder structure of VSO.
  • The HP ALM Defects were migrated as Defects in VSO.
  • Apart from the artifacts, the corresponding attachments and the relationship links between the test and defects were also migrated.

Kovair QuickSync also facilitated the users to view the statistics of migration. The total number of successful and failed migration could be viewed from QuickSync. In case of failed migration, the detailed log of the objects and the reasons for failure were available from one of the built-in monitoring reports of QuickSync.

Business Values

  • Easy tool installation and quick initial setup.
  • Codeless configuration for mapping the HP ALM Projects, Entities and Fields to the VSO counterparts.
  • Successfully migrated thousands of records including Requirements, Tests and Defects to VSO within a week.
  • Easy monitoring capabilities having objective and subjective statistical view of the state of migration with reports and logs.
  • Retry mechanism for any unsuccessful migration.
  • Simple licensing based on the successful transactions across all configurations and all projects by any number of users.
  • 100% Migration with zero failure.

Kovair QuickSync guarantees all the aspects of data migration like Accuracy, Integrity, Consistency and completeness.

The Project Execution Overview

In the first phase of the migration project, Kovair team completed the necessary tool configurations such as creating connections, mapping projects, mapping users, mapping entities, creating business flows and installing windows service. A shakeout test was done with few records in order to validate the configuration and data integrity. Once done, the migration occurred automatically without the need of continuous review.

In the second phase of the project, team members of the customer organization were given a few hours of training on the various facets of the Kovair QuickSync tool and how to accomplish migration goals with it. Post training, the teams were able to manage the migration themselves using the QuickSync tool with a minimal assistance from Kovair.

The occasional errors occurred when data moved in incorrect format and mapping of field values were not supported in VSO. The trained team were able to ascertain the cause of errors with the monitoring mechanisms available in the Kovair QuickSync tool and took corrective measures as required. Finally, the migration was completed much to the satisfaction of the organization.