Oakland County Department of Information Technology

Project Scope and Approach Project Name: Rewrite Shopping Cart from Java to .NET

Project ID: DJ4182SC

Leadership Group: IT Steering Committee Division: Application Services

Department: Information Technology Project Sponsor: Phil Bertolini Request Type:

Date Requested: 4/01/14

New Development

PM Customer No. 182

Enhancement

Customer Support

Planned System Maintenance or Upgrade IT Team Name: eCommerce

IT Team No: J

Project Manager/Leader: Puneet Grover Account Account Number: 30004 IT App Svcs E-Government Description: Grant Funded? Yes

No

Mandate?

Customer Name: Yes

IT No

Mandate Source:

Project Goal To migrate the Shopping Cart from JAVA to .NET so that it meets Oakland County standards.

Business Objective Migrate the Shopping Cart from JAVA to .NET to meet Oakland County standards. This can be done in our local infrastructure or in the cloud. Major Deliverables Create the Shopping Cart application in .NET Use versal code for 3 screens and related pop ups Create this application in the cloud – if applicable Set up cloud environment – if applicable Develop logic to remove option to leave before the transaction is complete Update the web service to include a receipt for credit/void transactions with a print button Testing and Training Approach Technical resources from eCommerce, server team and others as necessary to develop a project plan to update the Over the Counter application

Form Rev. 05/08/2012

Page 1

Project Rev. 6/20/2014

Oakland County Department of Information Technology

Project Scope and Approach Project Name: Rewrite Shopping Cart from Java to .NET

Project ID: DJ4182SC

Research & Analysis SEMCOG County IT Collaboration Research Research Conducted – Nothing Found

Gartner Research Recommendation – N/A

NACo Application Store Research Conducted – Nothing Found

Benefits See Return on Investment (ROI) Analysis Document

Impact Number of Users - All Divisions - All Leadership Groups - All

Risk Business Environment

Medium – Project will require some changes to existing business processes

Technical Environment

Medium – Previously implemented technologies with new aspects and/or new requirements

Assumptions Staffing

IT Staffing: resources will be available for the hours indicated per the attached project plan. Other Staffing: additional staffing will be available as follows:

Role: Project Sponsor:

Form Rev. 05/08/2012

Name Phil Bertolini

Page 2

Hours per Day As Needed

Project Rev. 6/20/2014

Oakland County Department of Information Technology

Project Scope and Approach Project Name: Rewrite Shopping Cart from Java to .NET

Project ID: DJ4182SC

Facilities 

No additional space or facility resources are required

Technical 

Application development will be done in .NET (C#) using Visual Studio



Existing mobile development standards and applications will be employed



The County’s Versal Code template will be used

Funding 

Information Technology

Other 

N/A

Priority

Constraints 

Resource availability

Exclusions 

Form Rev. 05/08/2012

Page 3

Project Rev. 6/20/2014

Oakland County Department of Information Technology

Project Scope and Approach Project Name: Rewrite Shopping Cart from Java to .NET

Project ID: DJ4182SC

PROJECT PHASE AUTHORIZATION Phase(s): All Total Estimated Application Services

Hours:

951 6

Cost: $116,022

Total Estimated Technical Systems

Hours:

Cost:

Total Estimated CLEMIS

Hours:

Cost:

Total Estimated Internal Services

Hours:

Cost:

$732

IT Application Services Division Manager Approval:

Date:

IT Technical Systems Division Manager Approval:

Date:

IT CLEMIS Division Manager Approval:

Date:

IT Internal Services Division Manager Approval:

Date:

IT Management Approval: Approved:

Yes

No

Date:

Reason: Project Sponsor Approval: Title:

Date:

PROJECT SUMMARY Authorized Development (see above)

Hours: 957

Cost: $116,754

Preliminary Estimated Development for Future Phases

Hours:

Cost:

Grand Total Estimated Development

Hours: 957

Cost: $116,754

Form Rev. 05/08/2012

Page 4

Project Rev. 6/20/2014

Oakland County Department of Information Technology

Project Scope and Approach Project Name: Rewrite Shopping Cart from Java to .NET

Project ID: DJ4182SC

PROJECT COMPLETION AUTHORIZATION Customer Acceptance of Product: Title:

Date:

Project Office Review:

Date:

Form Rev. 05/08/2012

Page 5

Project Rev. 6/20/2014

Information Technology Strategic Plan Alignment DJ4182SC - Rewrite Shopping Cart from Java to .NET 3.1 - Provide an Enhanced Application Service Offering 3.1.1 - Increased application integration and standardization through web services

3.1.5 - Increase the agility and responsiveness of business units by expanding customer analytics

3.1.2 - Integrate mobility and location based services in business applications

3.1.6 - Leverage the County's web presence as a branded consolidated point of access to all County information and services

3.1.3 - Promote and utilize shared services through the use of cloud technologies to offset costs and expland product offerings to customers 3.1.4 - Improve the quality, reliability, and availability of all applications

X

3.1.7 - Centralize and standardize identity and access management for all applications and content

X

3.2 - Enhance ability to provide effective and timely customer service 3.2.1 - Advance the use of IT Infrastructure Library (ITIL) best practice framework for IT Service Management

3.2.4 - Utilize a formalized customer communication plan

3.2.2 - Implement Configuration Management Database to better identify IT Assets

3.2.5 - Build IT Staff expertise through professional development

3.2.3 - Provide a high-quality training program to empower employees through technology

3.2.6 - Expand capacity through ongoing organization review and right sourcing

3.3 - Implement a Standardized Infrastructure Strategy 3.3.1 - Deliver services using a standardized shared technology infrastructure whereever possible

Run Date

X

3.3.4 - Improve service availability through network design and management strategies

3.3.2 - Implement a consolidated security management strategy

3.3.5 - Enhance capacity planning and recovery managment strategies

3.3.3 - Develop and implement a policy for personally owned devices and services

3.3.6 - Adopt an enterprise architecture approach to technology planning, design, and implementation

6/19/2014

Page 1 of 1

DJ4182SC

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

As Of: June 19, 2014

Return on Investment Analysis Project Summary Description Benefits/Savings: Tangible Benefits Subtotal: Cost Avoidance Subtotal: Costs: Development Services Subtotal: Hardware Subtotal: Software Subtotal: Infrastructure Subtotal Training Subtotal: Other Subtotal: Annual Statistics: Annual Total Savings Annual Total Costs Annual Return on Investment Annual Costs/Savings Ratio Project Cumulative Statistics: Cumulative Total Savings Cumulative Total Costs Cumulative Return on Investment Cumulative Cost/Savings Ratio

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Total

0 0

0 0

0 0

0 0

0 0

0 0

0 0

116,754 0 0 0 0 0

17,568 0 0 0 0 0

17,568 0 0 0 0 0

17,568 0 0 0 0 0

17,568 0 0 0 0 0

17,568 0 0 0 0 0

204,594 0 0 0 0 0

0 116,754

0 17,568

0 17,568

0 17,568

0 17,568

0 17,568

0 204,594

(116,754) 0.00%

(17,568) 0.00%

(17,568) 0.00%

(17,568) 0.00%

(17,568) 0.00%

(17,568) 0.00%

(204,594)

0 116,754

0 134,322

0 151,890

0 169,458

0 187,026

0 204,594

0 204,594

(116,754) 0.00%

(134,322) 0.00%

(151,890) 0.00%

(169,458) 0.00%

(187,026) 0.00%

(204,594) 0.00%

(204,594) 0.00% NO PAYBACK

Year Positive Payback Achieved State or Federal Mandate? Signatures: Benefits Reviewed By Project Sponsor

Date:

Costs (including IT Resources) Reviewed By Information Technology Project Manager

Date:

DJ4182SC ROI.xlsx/Project Summary Date Printed: 6/20/2014 Page 1

REV: February 24, 2012

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

DJ4182SC

As Of: June 19, 2014

Return on Investment Analysis Savings Detail

Benefit/Savings Description Application will be written in IT Standard language

DJ4182SC ROI.xlsx/Savings Detail Date Printed: 6/20/2014 Page 2

Project Savings Category Intangible Benefit

Budget Category/Funding Source

Unit Desc

Units

Rate per Annual Unit Total Savings Multiplier 0 0 0 0 0 0 0 0 0 0 0 0

REV: February 24, 2012

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

DJ4182SC

As Of: June 19, 2014

Return on Investment Analysis Savings Detail Affects Project ROI? Benefit/Savings Description Application will be written in IT Standard language

DJ4182SC ROI.xlsx/Savings Detail Date Printed: 6/20/2014 Page 3

Project Savings Category

Y1 Y2 Y3 Y4 Y5 Y6

Potential Savings Extensions Y1

Y2

Y3

Y4

Y5

Y6

Intangible Benefit

REV: February 24, 2012

DJ4182SC

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

As Of: June 19, 2014

Return on Investment Analysis Savings Summary Benefit/Savings Description

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Total

Tangible Benefit:

Tangible Benefits Subtotal: Cost Avoidance:

Cost Avoidance Subtotal: Intangible Benefit: Application will be written in IT Standard language

Savings Total:

DJ4182SC ROI.xlsx/Savings Summary Date Printed: 6/20/2014 Page 4

REV: February 24, 2012

DJ4182SC

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

As Of: June 19, 2014

Return on Investment Analysis Cost Detail Affects Project ROI? Project Cost Category Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Software Software Software Software Software Infrastructure Infrastructure Infrastructure Infrastructure Infrastructure

Cost Description IT Hours - New Development IT Hours - System Maintenance IT Hours - Customer Support IT Hours - Planned Maintenance User Hours - New Development User Hours - PTNE/OT Contractor Professional Services PC System - Acquisition PC System - Maintenance Notebook - Acquisition Notebook - Maintenance Tablet Notebook - Acquisition Tablet Notebook - Maintenance Laserprinter - Acquisition Laserprinter - Maintenance Image Workstations - Acquisition Image Workstations - Maintenance PC Maintenance User Owned Printer Maintenance User Owned Package Software - Acquisition Package Software - Maintenance Business Objects Access Term Emulation SFTW-Acquisition Term Emulation SFTW-Maintenance Server - Acquisition/Upgrade Server - Maintenance Server Sftwre - Acquisition/Upgrade Server Sftwre - Maintenance Server Rack Mount Oracle Enterprise Per Processor Includes Year 1 Maintenance Infrastructure Oracle Enterprise Per Processor - Year 2 and Beyond Infrastructure

DJ4182SC ROI.xlsx/Cost Detail Date Printed: 6/20/2014 Page 5

Budget Category/Funding Source

Unit Desc

Units 957 48 48 48

Rate per Unit 122 122 122 122

400

Total Cost 116,754 5,856 5,856 5,856 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

21,372

0

3,432

0

814 2,304 1,223 2,372 2,012 1,432 1,104 3,496 2,304 1,072

8,000 360 335

Annual Multiplier

Y1 Y2 x x x x

Y3 Y4 Y5 Y6 x x x

x x x

x x x

REV: February 24, 2012

x x x

DJ4182SC

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

As Of: June 19, 2014

Return on Investment Analysis Cost Detail Affects Project ROI? Cost Description MS SQL Server Standard Per Processor - Includes Year 1 Maintenance MS SQL Server Standard Per Processor - Year 2 and Beyond MS SQL Server Enterprise Per Processor - Includes Year 1 Maintenance MS SQL Server Enterprise Per Processor - Year 2 and Beyond Websphere Basic Per Processor Single/Dual Core - Includes Year 1 Maintenance

Project Cost Category

Budget Category/Funding Source

Unit Desc

DJ4182SC ROI.xlsx/Cost Detail Date Printed: 6/20/2014 Page 6

Annual Multiplier

Total Cost

Infrastructure

4,725

0

Infrastructure

946

0

Infrastructure

19,693

0

Infrastructure

3,939

0

Infrastructure

3,506

0

701

0

13,180

0

2,635 845 180

0 0 0 0 0 0 0 0

Websphere Basic Per Processor Single/Dual Core - Year 2 and Beyond Infrastructure Websphere ND Per Processor Single/Dual Core - Includes Year 1 Maintenance Infrastructure Websphere ND Per Processor Single/Dual Core - Year 2 and Beyond SSL Certificate Internet Access Project Staff Training User Training TBD TBD TBD

Units

Rate per Unit

Infrastructure Infrastructure Infrastructure Training Training Infrastructure Infrastructure Infrastructure

ANN ANN ANN

Y1 Y2 Y3 Y4 Y5 Y6

REV: February 24, 2012

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

DJ4182SC

As Of: June 19, 2014

Return on Investment Analysis Cost Detail Potential Cost Extensions Project Cost Category Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Development Svcs Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Hardware Software Software Software Software Software Infrastructure Infrastructure Infrastructure Infrastructure Infrastructure

Cost Description IT Hours - New Development IT Hours - System Maintenance IT Hours - Customer Support IT Hours - Planned Maintenance User Hours - New Development User Hours - PTNE/OT Contractor Professional Services PC System - Acquisition PC System - Maintenance Notebook - Acquisition Notebook - Maintenance Tablet Notebook - Acquisition Tablet Notebook - Maintenance Laserprinter - Acquisition Laserprinter - Maintenance Image Workstations - Acquisition Image Workstations - Maintenance PC Maintenance User Owned Printer Maintenance User Owned Package Software - Acquisition Package Software - Maintenance Business Objects Access Term Emulation SFTW-Acquisition Term Emulation SFTW-Maintenance Server - Acquisition/Upgrade Server - Maintenance Server Sftwre - Acquisition/Upgrade Server Sftwre - Maintenance Server Rack Mount Oracle Enterprise Per Processor Includes Year 1 Maintenance Infrastructure Oracle Enterprise Per Processor - Year 2 and Beyond Infrastructure

DJ4182SC ROI.xlsx/Cost Detail Date Printed: 6/20/2014 Page 7

Y1 116,754.00

Y2 5,856.00 5,856.00 5,856.00

Y3 5,856.00 5,856.00 5,856.00

Y4 5,856.00 5,856.00 5,856.00

Y5 5,856.00 5,856.00 5,856.00

Y6 5,856.00 5,856.00 5,856.00

REV: February 24, 2012

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

DJ4182SC

As Of: June 19, 2014

Return on Investment Analysis Cost Detail Potential Cost Extensions Cost Description MS SQL Server Standard Per Processor - Includes Year 1 Maintenance MS SQL Server Standard Per Processor - Year 2 and Beyond MS SQL Server Enterprise Per Processor - Includes Year 1 Maintenance MS SQL Server Enterprise Per Processor - Year 2 and Beyond Websphere Basic Per Processor Single/Dual Core - Includes Year 1 Maintenance

Project Cost Category

Y1

Y2

Y3

Y4

Y5

Y6

Infrastructure Infrastructure

Infrastructure Infrastructure

Infrastructure

Websphere Basic Per Processor Single/Dual Core - Year 2 and Beyond Infrastructure Websphere ND Per Processor Single/Dual Core - Includes Year 1 Maintenance Infrastructure Websphere ND Per Processor Single/Dual Core - Year 2 and Beyond SSL Certificate Internet Access Project Staff Training User Training TBD TBD TBD

DJ4182SC ROI.xlsx/Cost Detail Date Printed: 6/20/2014 Page 8

Infrastructure Infrastructure Infrastructure Training Training Infrastructure Infrastructure Infrastructure

REV: February 24, 2012

DJ4182SC

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

As Of: June 19, 2014

Return on Investment Analysis Cost Summary Cost Description Development Services: IT Hours - New Development IT Hours - System Maintenance IT Hours - Customer Support IT Hours - Planned Maintenance User Hours - New Development User Hours - PTNE/OT Contractor Professional Services Development Services Subtotal: Hardware:

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

116,754 5,856 5,856 5,856

5,856 5,856 5,856

5,856 5,856 5,856

5,856 5,856 5,856

5,856 5,856 5,856

Total 116,754 29,280 29,280 29,280

116,754

17,568

17,568

17,568

17,568

17,568

204,594

116,754

17,568

17,568

17,568

17,568

17,568

204,594

Hardware Subtotal: Software:

Software Subtotal: Infrastructure:

Infrastructure Subtotal Training:

Training Subtotal: Other:

Other Subtotal: Costs Total:

DJ4182SC ROI.xlsx/Cost Summary Date Printed: 6/20/2014 Page 9

REV: February 24, 2012

Oakland County -- Rewrite Shopping Cart from JAVA to .NET

DJ4182SC

As Of: June 19, 2014

Return on Investment Analysis Assumptions Date

Assumption Description Create the Shopping Cart in .NET Use versal code for 3 pages and pop ups Create the application to live either in the local environment or in the Cloud Develop logic to prevent the user from leaving the page until the transaction is complete Update the web service to include a receipt for credit/void transactions including a print button Documentation, training and testing will be done as part of this project

DJ4182SC ROI.xlsx/Assumptions Date Printed: 6/20/2014 Page 10

REV: February 24, 2012