CRLMS%20Civil%20Rights%20and%20Labor%20Management%20System

1
CRLMSCivil Rights and Labor Management System

• Wednesday, October 10, 2007
• St. Louis, Missouri

2
Before CRLMS
3
Before CRLMS
4
Before CRLMS
5
Before CRLMS
6
CRLMS The Beginning

• Need for an AASHTO software product that would
  address all federal reporting requirements of
  Civil Rights and Labor Management
• April 27th-28th, 2005 thirty-one (31) individuals
  representing 13 agencies came together in St.
  Paul, Minnesota to discuss the need for an AASHTO
  software product to track Civil Rights and
  Labor Compliance issues.
• As a result of the Joint Application Development
  (JAD) session the Civil Rights and Labor
  Management System (CRLMS) was born to meet the
  common needs of the AASHTO member agencies.

7
AASHTOWare Benefits
8
AASHTOWare Benefits

• States lack resources to develop their own system
• All states have same federal requirements to meet
  
• Cost for each participating state is less than
  the cost of a state creating their own system
• Minimize cost to highway contractors

9
AASHTOWare Benefits

• State overhead costs for data collection and
  storage would be minimized
• The software is being built on the same next
  generation Trnsport platform with the unified
  database
• CRLMS being developed to integrate with
• 1) AASHTO Trnsport modules or
• 2) As a Standalone module

10
CRLMS Benefits

• AASHTO owns and licenses to state agencies
• AASHTOWare provides long term support and
  maintenance of CRLMS
• AASHTOWare allows for staying current with ever
  changing Federal Regulations

11
AASHTOWare Technical Review Teams (TRTs)

• Appointed by TTF
• Assist TTF in working with contractor in
  development of new product/enhancement
• Chaired by TTF member
• CRLMS TRT consists of
• Users familiar with product/functions nominated
  from agencies contributing funding

12
AASHTOWare Technical Review Teams (TRTs)

• CRLMS started with 10 TRT Members
• Missouri added
• Continue to receive interest from other agencies
• Business conducted by
• e-mail
• conference calls
• face-to-face meetings
• Travel associated with TRT meetings are covered
  by AASHTO in the development costs

13
AASHTOWare Technical Review Teams (TRTs)

• Each individual on the TRT has to be committed
  and available to the project
• Review software prototypes as software is
  developed
• Provide contractor guidance on user needs
• Review and recommend acceptance of results of the
  software testing
• Review and prioritize Product Backlog

14
AASHTOWare Technical Review Teams (TRTs)

• Tony Bianchi AASHTO Project Manager
• Todd Bergland TRT Chair / TTF / Minnesota

15
AASHTOWare Technical Review Teams (TRTs)

• Members of the TRT
• Roger Bierbaum Special Committee on Joint
  Development (SCOJD) / Iowa
• Rhonda Ringer Technical Application
  Architecture Task Force
• Jim Ferguson Nebraska
• Patricia Flowers Georgia
• Patricia Collins Michigan
• Shay Hope Virginia

16
AASHTOWare Technical Review Teams (TRTs)

• Members of the TRT (cont.)
• Joe Weber New Jersey
• Denis Glascock TTF / Missouri
• Charles Groshens Minnesota
• Art Wright Florida
• Andy Penney Oklahoma
• Leslie Wootan-Hartung Chair Civil Rights
  Technical Advisory Group (TAG) / Montana

17
CRLMSTRT Team
18
AASHTOWare Technical Review Teams (TRTs)

• TRT meeting May 2007
• TRT meeting August 2007
• TRT meeting November 2007

19
System Overview and Preliminary Requirements
20
System Overview and Preliminary Requirements

• CRLMS is intended to ultimately address the
  following functions
• Equal Employment Opportunity and Affirmative
  Action monitoring
• Payroll wage and labor monitoring
• DBE/MBE/WBE program monitoring
• Civil Rights, labor, on-the job training, and
  DBE/MBE/WBE federal reporting

21
System Overview and Preliminary Requirements

• Integration with, yet capability to operate
  independently of Trnsport
• Access to and use of the system by external
  parties (for example, contractors,
  subcontractors, FHWA, cities, and counties)
• Data migration from existing relevant Trnsport
  client / server modules
• Provide the base data for DBE/MBE/WBE data
  analysis (Disparity Study)

22
External Connectivity
Desired process for CRLMS currently awaiting
TTF approval
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Development Process
32
Development Process

• Agile Development
• Agile Development The scope is defined as the
  work is being performed
• Agile Development promotes involvement and
  interaction of the entire user community
• Agile Development delivers working software
  frequently

33
Development Process

• Product Backlog
• Prioritized list of requirements
• Prioritized by TRT
• 1 month sprints build highest priority items
• Produce potentially-releasable product increments
• Hands-on evaluation by TRT every iteration
• Highly-disciplined process
• Produces standard artifacts but in a different
  way
• Measure productivity with burn down charts

34
Development Process

• Dedicated team of developers and analysts
• Collective ownership by team
• Co-location with everyone participating in
  interpreting requirements, defining backlog items
  and estimating them
• Backlog items estimated relative to each other
• Sprint plan and estimates reassessed daily based
  on team progress and knowledge gained
• Retrospective at end of every iteration to
  identify and leverage lessons learned

35
(No Transcript)
36
(No Transcript)
37
Priority Use Case Description Group Priority Appendix A Estimates
1 2043 Maintain Vendor Data DBE 1 7
2 3013 Maintain Wage Decisions Header Labor 2 20
3 3005 Associate Wage Decisions to a Contract Labor 3 45
4 3027 Enter/Edit DBE Commitments DBE 4 20
5 3028 Review/Approve Contractor DBE Commitment DBE 5 7
XX 3011 Maintain Field Interview Data Labor 14
11 2109 Enter Sub Contractor Sublet Data DBE 8 45
XX 2113 Enter Bidders List DBE 10
XX 3002 Create Modify Electronic Signature Labor NP
XX 3012 View Edit Contractor Labor Compliance History DBE NP
12 2110 Enter/Maintain Month End Trucking Data DBE 13 45
13 3029 Review/Approve Contractor Sublet DBE 10 7
14 3022 Import Payments to Prime Contractor DBE 16 45
20 2107 View Basic Contractor Information Contract 9 2
44   Alternate Screen Creation ITI   85
45   Recommend DB Tailoring ITI   7
46 3007 Export Contract Certified Payroll Labor   20
38
8 2024 Maintain Contract Employee and Employment Data Labor 11 20
8 2031 Maintain Contractor Employee Data Labor 11 7
8 2082 Import Payroll File Labor 16 2
8 3001 Maintain Certified Payroll Labor 11 85
8 3014 Import Contractor Employee Data Labor 16 20
8 3021 View Certified Payroll Approvals Labor 15 20
9 3009 Maintain Certified Payroll Rules Labor 11 85
10 3004 Check Certified Payroll Labor 12 45
39
6 2014 Maintain Contract Award Data Contract 7 7
7 2042 Maintain Contract Data Contract 6 20
14 3023 Import Contract Amendment (Change Order, Modifications) Data Contract 16 20
14 3024 Import Sub-Contractor Data Contract 16 20
14   Interface from SM to CRLMS Technical 16 45
14   Interface from FM to CRLMS Technical 16 45
14   Inferface from CAS to CRLMS Technical 16 45
40
15 2037 Enter Payment Data by Contractor DBE 18 20
16 3025 Verify Payment DBE 18 20
17 2026 Maintain Sub Contractor Payment Data DBE 17 45
18 2032 Maintain OJT Trainee Data Labor 19 45
19 2050 Report OJT Employment Information Labor 20 7
41
R 01 1024 Create Federal 1392 Report     20
R 02 1023 Create US DOT Quarterly and Semi-Annual DBE Award Commitments Report     85
R 03 1029 Create Contract Clearance DBE Participation Report     20
R 04 1097 Create DBE Availability Report     20
R 05 2054 Create Report On the Job Training by Contract and Trade Category     20
R 06 2056 Create Report Showing Payments Made on a Contract     7
R 07 2057 Create Report Showing Progress Toward Transp Agency Goals     7
R 08 2095 Report Contractor/Subcontractor Data     1
R 09 3010 View Month End Truck Report     7
R 10 3019 Create Verify Contractor Data Report     20
R 11 3041 Create Contract Payroll Activity Report     45
R 12 2034 Report Contract Employment Data (total hours, minority and women hours)     7
R 13 2019 Report Contract DBE Subs From Start to Finish     20
42
Involvement

• Sources for Involvement
• wT/CRLMS Message Board
• Preview Site
• Acceptance Tests
• Civil Rights TAG

43
CRLMSCivil Rights and Labor Management System

• User involvement is vital to this process and,
  therefore, participation by agencies is welcome.
  If you would like more information, please
  contact Tony Bianchi, the AASHTO project manager,
  at tbianchi_at_aashto.org or Todd Bergland of the
  Trnsport Task Force at TTF_at_cloverleaf.net. For
  more information on web Trnsport, please go to
  www.cloverleaf.net.

44
Questions?