INDUSTRY

Life Sciences

National R&D Laboratory – Application Clean Up and Upgrade

Due to numerous development efforts that did not follow standard procedures for customizing several areas in the system, an Application Clean Up effort was necessary at this National R&D Laboratory. This project included resolving issues which create problems during new development projects. In addition, this project was needed to alleviate extra work during the Application Upgrade required to stay current with IBM Maintenance and Support.

The scope of this work included:

Object Analysis:

Form: 250+
Query: 1000+
Workflow: 650+

Forms Updates:

Identified and fixed forms that did not follow naming convention
- Pure custom versus invalid
- Built form rename table
- Built and applied renamed SQL from table
- Identified and updated impacted workflows

Workflow Updates:

Identified and fixed workflows that did not follow naming convention
- Removed orphaned and unneeded workflows that did not follow naming convention
- Pure custom versus customized OOTB
- Built workflow rename table
- Built and applied rename SQL from table

Query Updates:

Identified and fixed queries that did not follow naming convention
- Removed orphaned and copied queries that did not follow naming convention
- Pure custom versus customized OOTB
- Identified and reviewed outstanding non-standard queries for targeted resolution
- Identified and updated the queries used in extended formulas impacted by renames
- Built query rename table
- Built and applied rename SQL from table

The Application Upgrade included the following work requirements and upgrade efforts:

Platform Compatibility Readiness Assessment
- Verified that OS, Database and Application Server versions are supported
Platform Upgrade
- Released Notes Impact Report
- Regression Testing
Application Upgrade
- Work Process Documentation
- App Upgrade Dev, Qual & Prod
- System Test
- User Acceptance Test
- Post Deployment Support

Scope of Work Included:

Initiate Phase

This phase included the Project Kick Off and Strategy Sessions to prepare the teams for the required project tasks, as well as review and revision of the project plan based upon strategy session findings.

Define Phase

This phase involved Application Review and Work Process Flow meetings. These workshops ensured that all business requirements, process flows, and detailed functionality were documented. Additionally, the roles that interacted with the system, and their use cases were documented. Deliverables included the Work Process Flow Documents.

Development Phase

The Development Phase was driven by the completion of the Work Process Flow Documents (WPD). The Product Backlog was generated by the collection of details in the WPD and upgrade development work commenced. This phase included all aspect of development and deployment of upgraded objects into the test environment.

Validate Phase

From system test through to User Acceptance Testing, the Validate Phase provided exertion of stringent controls to ensure that all product features and functionalities were thoroughly reviewed and functional requirements were validated against test result criteria.

Deployment Phase

In the Deployment Phase, EDI drew upon their deep Object Migration expertise to accurately migrate test functionality and configuration from test to production systems. The result is an effective deployment and a system ready for heavy user activity.