1 of 48

Colleague Connect, Inc.

Group 4 Final Presentation

Soumya Mittal, Xu Lian(Linda), Tsai-Hsin(Sandy) Chen, Vivek Dasari, Ana Figuerado

Applying Project Management Principles in IT

Fall 2022

2 of 48

Contents

Project Proposal

Requirements

Stakeholder Matrix

1

2

3

Procurement

RACI Matrix

Risk Register

8

9

10

Solution Diagram

Project Schedule

Project Budget

4

5

6

Sample Project Status

Quality Mgmt. Plan

Project Resources

7

Testing Approach

Deployment Plan

Lessons Learned

11

12

13

14

15

3 of 48

1. Project Proposal

4 of 48

Project Overview

Hybrid

Approach

12 Months

Duration

$1,024,845

Cost

Project Goal

To create an application communication platform for client companies, where employees within an organization can connect and socialize with each other to build social capital and improve organizational efficiency.

5 of 48

Project Scope

Create a communication app for client organizations that lets the users connect and collaborate with others within the organization. The collaboration will facilitate employee upskilling and socializing, increasing organizational efficiency.

Users should be able to create groups, chat and share files, and create referral links. The app will also provide customer assistance and collect user feedback. User profiles and system data will be protected.

The project duration will be 12 months and cost $1,024,845.

In Scope

  • Solution Design and App Development
  • Creating communication safe environment
  • User friendly interface
  • Connect with other social media accounts
  • App testing, pilot, and deployment
  • Initial Partnership with Client Companies
  • Ensure user privacy

Out of Scope

  • Interpersonal conflict on the application
  • Relationships and criminal issues outside of application platform
  • Employee relationships in client organizations
  • Scheduling meetups, facilitating conversations, etc. among users

6 of 48

Project Assumptions

01

Mobile Device

02

Digital Literacy

03

Skill & Resources

Individuals/Clients within the organization have access to a mobile device.

Ability to use IT and digital technology to find, evaluate, create and communicate information

Team members are adequately skilled and have access to all needed resources

7 of 48

Project Success Criteria

03

04

01

02

Solution Design Meets App Requirements

Few Usability Bugs and Easy to Navigate Interface

Partner with 50+ Client Organizations

User Data and System is Protected from Cyberattacks

05

06

07

Maintain 99% App Uptime Requirements

All App Development Risks are Accounted for and Mitigated

Doesn’t exceed Schedule and Cost Limits by >10%

8 of 48

2. Project Requirements

9 of 48

Project Requirements

Functional Requirements

S. No.

Requirement

Category

Target Date

Priority

(1-low, 5 - high)

1

Verifying the users

Technical

Mo 3 - March

5

2

Create personal profiles

Technical

Mo 4 - April

5

3

Make groups, categorize activities

Technical

Mo 6 - June

4

4

Provide a chat platform

Technical

Mo 6 - June

4

5

Create a referral links

Technical

Mo 7 - July

2

6

Guide to use the app

Technical

Mo 4 - April

3

7

App testing

Technical & Security

Mo 9 - Sep

5

10 of 48

Project Requirements

Non-Functional Requirements

S. No.

Requirement

Category

Target Date

Priority

(1-low, 5 - high)

8

Hire consultants

Resource

Mo 3 - March

3

9

Administer surveys

Business

Mo 2 - Feb

4

10

Partner with clients

Business

Mo 10 - Oct

5

11

Provide customer support assistance

Business

Mo 4 - April

3

12

User protection

Security

Mo 3 - March

4

13

Procure external resources

Resource

Mo 3 - March

4

14

Data Gathering and Reporting

Technical/Business

Mo 11 - Nov

2

11 of 48

3. Stakeholder Matrix

12 of 48

Stakeholder Register

S.No

Stakeholder Name

Role

Frequency of Interaction

Communication Strategy

Position

1

Project Sponsor

Investor

Monthly

Inform

Supporter

2

Organizations

Clients/Users

Monthly

Consult & Inform

Neutral

3

Project Team (Procurement, Finance, Legal, External Liaison, etc.)

Owners

Twice a Week

Empower

Supporter

4

IT Team (Tech lead, Developers, Testers)

Owners

Twice a Week

Empower

Supporter

5

Marketing Agency, UX Designers

External Hires

Weekly

Consult & Negotiate

Neutral

6

AWS, MySQL, Language Software

Vendors, Procurement

Monthly

Negotiate

Neutral

7

iOS and Android App Stores

Retailers

Monthly

Consult & Negotiate

Neutral

8

Privacy Regulations and Compliance Monitors

Legal Community

Subjective

Monitor & Consult

Neutral

9

Discord, Slack, Other Collaboration Apps

Competitors

Subjective

Monitor

Opponents

10

Facebook, LinkedIn, Twitter (Linked to App)

Collaborators

Monthly

Negotiate & Inform

Neutral

11

Media and Interest Groups

(News, Social Media, Advertisements)

Community

Weekly

Consult & Inform

Neutral

13 of 48

Stakeholder Matrix

14 of 48

4. Solution Diagram

15 of 48

System Diagram

App Server

(Back-end)

App logic

Enterprise Management Systems

User

Firewall

Web Server

Content Delivery Network

(Cache)

Admin

Cloud RDBMS

(MySQL)

Web Browser/

Mobile App

Data Warehouse

Cloud Hosting

1

2

3

4

5

6

7

Data Flow

16 of 48

App User Journey

User

Download App

Open App

Guide to Use App

Create Account

Accept T&C

Link to Social Media

Verify User

Login Account

About Self, Hobbies, Likes

User Profile

Create/ Join Groups

Direct Message

Suggested Users/ Friends

Share & Collaborate

Socialize

Upskill

Create Referral Links

Collect Feedback

App Assistance

Call

Chat

App Functions

KEY

Routine Journey

One-Time Journey

Main App Functions

1

2

3

4

5

Share Links

17 of 48

5. Project Schedule

18 of 48

Gantt Chart

Tasks

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Project Kick-off

Requirement Collection

Solution Design - App Design

Procurement

User Protection

App Development

App Testing

Partnership with Clients

App Deployment

Data Collection & Reporting

Project Closure & Handover

Initiation

Testing

Planning

Development

Closing

Launching

19 of 48

ProjectLibre - Page 1 of 3

20 of 48

ProjectLibre - Page 2 of 3

21 of 48

ProjectLibre - Page 3 of 3

22 of 48

Critical Path

289 Days

12 months

Project Duration

Project Kick-off

(7 days)

Requirement Collection

(11 days)

Solution Design - App Design

(20 days)

Procurement

(20 days)

App Development (150 days)

App Testing

(48 days)

Partnership with Companies

(46 days)

App Deployment

(53 days)

Data Collection & Reporting

(20 days)

User Protection

(20 days)

Project Handover

(5 days)

23 of 48

6. Project Budget

24 of 48

Internal Team

Work Required

(in hours)

Cost Per Hour

Estimated Cost

Project Sponsor

48

$ 50

$ 2,400

Project Manager

568

$ 50

$ 28,400

Business Analyst

56

$ 50

$ 2,800

Technical Lead

1,144

$ 60

$ 68,640

App Designers

880

$ 45

$ 39,600

App Developers

12,720

$ 60

$ 763,200

Testers

200

$ 50

$ 10,000

Procurement Manager

432

$ 40

$ 17,280

External Liaison

384

$ 40

$ 15,360

Marketing Team

72

$ 40

$ 2,880

Finance and Legal

280

$ 40

$ 11,200

Subtotal (A)

$ 961,760

Labor Costs

External Hires

Work Required

(in hours)

Cost Per Hour

Estimated Cost

UI/UX Designers

600

$ 55

$ 33,000

Market Consultant

160

$ 40

$ 6,400

Marketing Agency

184

$ 40

$ 7,360

Subtotal (B)

$ 46,760

Material Costs

Particulars

Unit Cost

Frequency

Estimated Cost

Computer Hardware Maintenance

$ 550

25

$ 13,750

SSL Certificate

$ 70

10

$ 700

Hosting Server - AWS

$ 700

1

$ 700

SaaS - Taxio

$ 45

10

$ 450

RDBMS - MySQL

$ 600

1

$ 600

App Store & Google Play Fee

$ 125

1

$ 125

Subtotal (C)

$ 16,325

Total Costs (A+B+C) = $1,024,845

25 of 48

7. Resources Required

26 of 48

Resources Required

Resources

Associated Tasks

Duration

Cost

Team Required

Project Manager

Kick-off, Plan, Monitor, Hire consultants, App Deployment, Launch Event, Operations Handover, Lessons Learned, Close

110 days

$50/hr

Technical Lead

Kick-off, Plan, Design, Development, Privacy Testing, Pilot, Operations handover, Lessons learned

180 days

$60/hr

App Designers

App Design functions

80 days

$45/hr

App Developers

App Development Tasks, Testing

215 days

$60/hr

Procurement Manager

Procurement of external resources, AWS, MySQL, Taxio- Saas Offensive Language

50 days

$40/hr

Finance & Compliance

Legal Compliance, Reports, Contract Drafts, Privacy Clauses

35 Days

$40/hr

27 of 48

Resources Required

Resources

Associated Tasks

Duration

Cost

Team Required

Business Analysts

Kick-off, Plan, System Testing, Lessons Learned

21 days

$50/hr

Testers

Development, Testing, Pilot

35 days

$50/hr

Marketing Team

Hire Consultant, Surveys Launch events

12 days

$40/hr

External Liaison

Clients research & outreach, draft proposal, Contract drafting, Negotiate, Partnership

48 days

$40/hr

External Resources

Market Consultants

Market research & outreach, Consult on App design

22 days

$40/hr

Marketing Agency

Research and Outreach, Launch Event, Draft Proposal

43 days

$40/hr

UX Designers

UX, UI Designs integration of UX design

90 days

$55/hr

28 of 48

8. Procurement

29 of 48

Procurement Requirements

Item

Contract Type

Negotiation Strategy

Acceptance Criteria

Ongoing Support

Cost

MySQL - Relational Data Management

Fixed Price

Annual Contract

Vendor’s Pricing

Access to data

Annual Licence renewal

$600 Annually

Taxio- Saas Offensive Language

Monthly Subscription

market research

After the UAT

Monthly Subscription

$45 Monthly

AWS

Per Unit

Vendor pricing

After pass performance test

Annual Licence renewal

$700 Incremental based on use

30 of 48

9. RACI Matrix

31 of 48

RACI Matrix

Responsible

Project Tasks

Project Sponsor

Project

Manager

Business Analyst

Tech

Lead

Design

Team

Dev

Team

Procure

Manager

Finance/

Legal

Marketing Team

Testers

Market Consultant

Marketing

Agency

UX Dev

Project Plan

I

A

R

C

C

C

I

C

I

C

Gather requirements

C

A/R

R

C

C

C

C

C

C

C

C

C

Budget Plan

I

A

C

R

C

C

C

R

Solution Design

I

C

C

A

R

C

C

I

I

I

C

C

UX/UI Design

I

C

C

A

C

I

I

I

R

Procurement

I

C

C

C

C

C

A/R

C

C

User Protection

I

C

R

C

R

A

C

App development

I

C

I

A

C

R

I

I

C

R

Accountable

Consulted

Informed

32 of 48

Project Tasks

Project Sponsor

Project

Manager

Business Analyst

Tech

Lead

Design

Team

Dev

Team

Procure

Manager

Finance/

Legal

Marketing Team

Testers

Market Consultant

Marketing

Agency

UX Dev

Unit & System Testing

I

C

I

A

C

R

I

User Testing

I

C

C

A

I

C

R

C

C

Debug

I

C

A

R

C

Pilot

C

C

I

A

I

R

I

R

I

I

Partnership with Companies

I

A

C

C

R

C

R

App Deployment

C

A

R

I

R

I

C

C

Launch event

C

C

I

I

I

I

I

C

A

I

I

R

I

Data Gathering & Reporting

I

C

A

R

I

C

I

Operations handover

C

A

I

C

I

R

I

I

I

I

I

I

I

Close project

A

R

I

I

I

I

I

I

I

I

I

I

I

33 of 48

10. Risk Register

34 of 48

Risk

Risk Category

Owner

Probability

(1-none, 5-high)

Impact (1-none, 5-high)

Risk Score (1-25)

Mitigation Approach

Mitigation Strategy

Issues in Solution Design Not Meeting Requirements

Technical & Scope

Technical Lead & Business Analyst

2

5

10

Mitigate Probability

Tech Lead and BA should work together to discuss and clarify app requirements

Problems of Integration with External SaaS

Technical & Resource

Technical Lead & Procurement Rep

3

5

15

Mitigate Probability

Ensure that procured SaaS is compatible and conduct multiple integration testing

System and Data Security Risks

Technical

Technical Lead & Developers

1

5

5

Mitigate Prob & Impact

Web Application Firewall, Secure HTTPS, frequent updates, Nightly backups

Privacy Risks in Collaborative Filtering

Technical & Business

Technical Lead & Project manager

1

3

3

Mitigate Impact & Transfer

Add T&C in App for Users, Updated Software and Plugins, Fragmented Data

Requirement Change Request from Clients After App Development

Business

Project Manager & External Liaison

3

4

12

Avoid

Do market research and gather requirements well, add protection clause in client contracts

35 of 48

Risk

Risk Category

Owner

Probability

(1-none, 5-high)

Impact (1-none, 5-high)

Risk Score (1-25)

Mitigation Approach

Mitigation Strategy

Too Many Calls to Action in User Interface Design

Technical

UX Designers & Tech Lead

4

3

12

Mitigate and Accept

User Interface is key in App Dev so prioritize CTAs and add schedule flexibility

Too Many Testing Errors or Usability Bugs

Technical

IT Team

4

4

16

Mitigate Prob & Impact

Very likely. Agile testing, multiple rounds of UAT, get representative user sample

High App Downtime

Technical & Operations

Proj Manager & IT Team

1

5

5

Avoid

High impact on clients. Keep software, plugins updated. IT monitors domain, servers

Challenges in Partnering with Clients

Business & Market

Proj Manager & External Liaison

3

5

15

Mitigate Probability

Rigorous market research, Approach clients before & after solution design

Late App Development Deliverables

Schedule & Cost

Proj Manager & Tech Leaf

3

3

9

Mitigate & Accept

Conduct frequent check-ins, monitor project schedule, provide immediate support

36 of 48

11. Sample Project Status Update

37 of 48

Status Update - Current Progress

1

3

5

2

4

6

  • Requirement Collection
  • Solution Design

Planning

App Testing

Testing

Project Closure &

Handover

Closing

Project Kickoff

Initiation

  • Procurement
  • User Protection
  • App Development

Development

  • Clients Partnership
  • App Deployment
  • Data Gathering

Launching

70% Done: Finishing Testing and Focus on Launching

38 of 48

Risks Encountered & Corrective Action

MS Azure was not cost-effective

Issues in Integration with Language SaaS

1

Too Many Usability Bugs

Hired More Resources

Bugs in UX testing. Extra developer was hired to keep project on schedule

2

Integration with Language SaaS

Support from Vendor

Issues in integrating language software

Resource support from vendor under service contract

3

Difficulty in Maintaining Uptime

Updated software & plugins

Challenges in achieving 99% uptime. Increased server monitoring and frequent updates

4

Issues with Azure Hosting Server

Switch to AWS

39 of 48

12. Quality Management Plan

40 of 48

Quality Assurance Plan

41 of 48

13. Testing Approach

42 of 48

Testing Approach

Establish Testing Scenarios

Testing Scope

Testing of Mobile App

Unit Testing

  • Integration with UI/UX Design
  • Integration with Language SaaS

Integration

Testing of the whole application following integration

System Test

Test with 150 user, focus on app usability

UAT

DEBUG

DEBUG

DEBUG

DEBUG

Mo 6 - June

Mo 8 - Aug 15th

Mo 8 - Aug 30th

Mo 9 - Sept 15th

Mo 9 - Sept 30th

43 of 48

14. Deployment Plan

44 of 48

Deployment Plan

Oct 30th

Deploy App

Mo 11 - Nov

Launch Event

Mo 11 & 12 - Dec

Hyper-Care

Deploy Code to AWS & Release in Apple and Google store

Marketing Event and Campaign to Promote App

30-Day Hypercare Period,

App Data Collection and Reporting

Mo 8 - Oct

Project Pilot

Test with with 3 client companies.

Debug following the Pilot stage

45 of 48

15. Lessons Learned

46 of 48

Lessons Learned

  1. Market research was rigorous and app design aligned well with the requirements
  2. App development deliverables were on time and there was minor exceeding of budget
  3. Negotiations and partnership with vendors was efficient and valuable
  4. Secured 58 clients over the course of project

What Went Well

  1. Launch a web app in addition to the mobile app
  2. BI tools linked to apps to automate reports and generate analytics based on real-time data
  3. Partner with more social media apps to link user profiles
  4. Expand app functions to increase collaboration

Next Steps: Second Phase

  1. Estimating hidden costs in the budget, such as service charge, logistics of launch event
  2. Add more testing scenarios, especially in usability testing, during the testing phase
  3. Documentation could have been managed better

What Could Be Better

47 of 48

Appendix

48 of 48

Slides Owner: Who did What

Sections

Slides

Owner

Project Proposal

Slide 3 - Slide 7

Xu Lian & Soumya

Project Requirements and Stakeholder Matrix

Slide 8 - Slide 13

Tsai-Hsin Chen

Solution Diagram, Project Schedule, & Budget

Slide 14 - Slide 24

Soumya Mittal

Project Resources, Procurement, & RACI Matrix

Slide 25 - Slide 32

Ana Figuerado

Risk Register

Slide 33 - Slide 35

Qinfang Liu & Soumya

Sample Status Report

Slide 36 - Slide 38

Qinfang Liu & Soumya

Quality Management, Testing, & Deployment Plan

Slide 39 - Slide 44

Vivek Dasari

Lessons Learned

Slide 45 - Slide 46

Tsai-Hsin, Vivek, & Soumya