web Trnsport Development Update

1
web TrnsportDevelopment Update

• Presented by
• Monelle McKay, Info Tech, Inc.
• October 2008

2
Topics

• Focus in the Past Year
• Focus in the Next Year
• Key Lessons Learned
• Demo

3
Focus in the Past Year
4
Focus in the Past Year

• Preconstruction
• Extend Business Functionality
• Sprint Testing
• Beta Testing
• Production Release
• Infrastructure and Test Coverage
• Civil Rights and Labor Management System (CRLMS)
• Core Business Functionality
• Construction and Materials TRTs
• Business Requirements

5
Preconstruction Business Functionality

• Addenda Snapshot (proposal/project tree with
  differences)
• Reports (e.g. detail estimate funding reports,
  bid tab analysis, bid letting summary, DBE
  interest)
• Breakdowns and Breakdown Items
• Completeness/Validation Checks (proposal/project)
• Line Numbering (zero fill, lock proposal item
  line number)
• Interfaces
• Data View for PropItem and PropItem Table
• PES/LAS Data Migration Utility
• Relet Proposal
• Quick Add for Project Items and Proposal Vendor
• Stop by the demo room for more details

6
Preconstruction Sprint Testing

• TRT
• Weekly meetings
• Onsite testing in Atlanta in March
• Monthly review of results and focused testing
• Preliminary Release Agencies (15)
• Alabama, Florida, Georgia, Indiana, Kansas,
  Kentucky, Louisiana, Maryland, Michigan,
  Minnesota, Mississippi, Montana, New Jersey, Nova
  Scotia, Oregon
• Installation, data migration, documentation,
  business issues
• Call Ticket and feedback

7
Preconstruction Sprint Testing (contd)

• TAG
• Review and input into functionality (monthly
  update meetings)
• Preview Site
• Available to all agencies through Cloverleaf
  membership
• Documentation and functionality throughout
  development and issue resolution
• Info Tech
• Automated tests daily
• Manual testing by Business Analysts as features
  are completed and at end of sprint

8
Preconstruction Beta Testing

• 2 Beta Sites (Vermont, Virginia)
• Planning Started in April
• Weekly calls to prep (TeamTrack, training,
  orientation, processes, review beta test plan)
• Started Testing in June, Testing Continues
• ITI Onsites
• VA/VT for mobilization, orientation, environment
  checks
• 2 VA follow-ups for specific testing, environment
  tuning
• Monthly Sprint Updates
• Install, run acceptance tests, data migration
• Weekly Beta Calls
• Review beta testing accomplishments and obstacles
• Review Beta Issues submitted via TeamTrack
• Review beta testing plans for the upcoming week

9
Preconstruction Beta Testing (contd)

• Interfaces
• aecXML MN CAS VA CES FL
• DSS VT/VA Estimator VT/VA Expedite VT/VA
• SAPW MI SiteManager VT/VA SiteXchange IA
• Main issues reported
• Performance related (server configuration, long
  lists, data migration, multiple users, time outs,
  Grid window filter)
• Interfaces (SM, CAS, DSS)
• Upper Casing (agency option switching)
• Record Locking
• Reports Sent to TRT/TTF
• Weekly Updates (minutes) and Error Reports
• Updated Beta Test Distribution Materials
• Beta Test Checklist
• Beta Results (final)
• Beta Site Questionnaire (final)

10
Preconstruction Production Release

• CD of source, documentation, automated tests to
  AASHTO
• Authorized File Download Site for Licensees
• Licensees download product, documentation,
  automated tests
• Technical documentation (e.g. ERD) request from
  AASHTO
• Site also has Beta, Preproduction Releases,
  source code and Emergency Fixes where approved
  for download
• Continue to update Preview Site monthly

11
Infrastructure

• User Participation
• Technical TRT, Business TRTs, TTF, Standards
  sub-group
• Functionality
• User Role Security, Field Level Security
• Database Logging
• Navigation, Sort/Find/Filter Functionality
• Workflow/Phase
• Custom Processes, Custom Reporting, Data Loading
• Attachments
• Installation, Running Acceptance Tests
• Changing Business Rules (Metadata)
• Performance (tests, serialization, quick add
  popup dialog)
• Check out web Trnsport Technology presentation

12
Infrastructure (contd)

• User Documentation
• Online Help (includes system management,
  client/server differences and summary of changes)
• Guides for Installation, ActiveReports, Automated
  Tests
• Technical Documentation
• System Design Specification (SDS) and Entity
  Diagram (ERD)

13
web Trnsport Test Coverage

• Automated Testing
• 75,000 unique acceptance tests
• 125,000 total acceptance tests factoring in
  multiple environment platforms (e.g. DB2, Oracle)
• Full suite of tests run for each software build
• Manual Testing
• Ongoing as backlog items are developed
• Formally at the end of each month
• Regression
• New functionality
• Installation
• Interfaces

14
Civil Rights and Labor Management System (CRLMS)

• TRT participation
• Three on-site meetings for user story
  development, testing, planning
• Weekly meetings (TRT, 3 subgroups for user
  stories, testing)
• Monthly testing
• Extending business functionality
• Contractor payrolls and labor compliance
• Wage decisions
• DBE certification, vendor data, commitments
• OJT tracking and monitoring
• Subcontractor data and prompt pay tracking
• Trucking types and tracking
• Interfaces (CAS, PES/LAS, SiteManager)

15
CRLMS Functionality (contd)

• Reports
• Create US DOT Quarterly and Semi-Annual DBE Award
  Commitments Report
• Federal 1392 Report (Annual EEO Report)
• DBE Directory Report
• Report Project Employment Data
• Report OJT Employment Information
• OJT by Project and Trade Category Report
• End of Month Trucking Report

16
Construction/Materials TRTs

• 3 Onsite Meetings
• Members gain knowledge of web Trnsport system
• Developing user stories for business requirements
• Week of November 10th, fourth meeting
• Weekly TRT Meetings
• Members continue to develop user stories
• Gather Input from User Community
• Listserve questions
• Collaboration across teams in support of
  unification
• Preconstruction, CRLMS, Technical TRTs
• TTF

17
Focus in the Next Year
18
Focus in the Next Year

• Preconstruction (Post Production Release)
• Warranty Items
• Agency Funded Enhancements (Min/Max bid items)
• Technology Upgrades and maintenance
• TTF Directed Work
• CRLMS (schedule re-alignment)
• Complete remaining business items (interfaces,
  reports)
• Application License/Partitioning, Performance
  Tests
• Beta/Preliminary Release Jan/2009 (100
  functionality)
• Production Release May/2009
• Warranty Items
• Post-Production Release

19
Focus in the Next Year (contd)

• Construction and Materials TRTs
• Continue to focus on user story development
• Cross-collaboration on global items
• General
• Technology Upgrade (database, browser, Vista OS)
• Section 508/WCAG (web content accessibility
  guidelines) standards
• External Access (e.g. contractors)
• Support for Implementing Agencies
• Integrating Customer Support processes
• Support TTF in Product Release Strategy (timing
  of releases, patches, code branching)

20
Key Lessons Learned
21
Key Lessons Learned

• Theme Based Approach
• User story development
• Release planning, Testing, and Preliminary
  Releases
• Requirements Gathering
• Develop all user stories for theme up front
• Early User Exposure to Software
• Assess need for testing at end of sprint
• Once a theme is completed, test feature end to
  end
• Handling of Cross-Functional and Global Items
• User input, ownership, testing, timing of release

22
Key Lessons Learned (contd)

• Benefits of Unified Product Approach
• Testing, interfaces, product release strategy
• Leveraging infrastructure for future efforts
  (security, data model, global functions,
  automated tests)
• 100 of Functionality Prior to Beta
• Interface Challenges (e.g., data dependencies)
• Environment
• Servers, Browser version (e.g., IE6), VMWare
• VPN Connectivity

23
Demo
web Trnsport informationin demo roomupon
request or signup for daily democheck out
www.cloverleaf.net