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
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
1. Project Proposal
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.
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
Out of Scope
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
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%
2. Project Requirements
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 |
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 |
3. Stakeholder Matrix
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 |
Stakeholder Matrix
4. Solution Diagram
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
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
5. Project Schedule
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
ProjectLibre - Page 1 of 3
ProjectLibre - Page 2 of 3
ProjectLibre - Page 3 of 3
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)
6. Project Budget
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
7. Resources Required
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 |
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 |
8. Procurement
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 |
9. RACI Matrix
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
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 |
10. Risk Register
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 | |
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 | |
11. Sample Project Status Update
Status Update - Current Progress
1
3
5
2
4
6
Planning
App Testing
Testing
Project Closure &
Handover
Closing
Project Kickoff
Initiation
Development
Launching
70% Done: Finishing Testing and Focus on Launching
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
12. Quality Management Plan
Quality Assurance Plan
13. Testing Approach
Testing Approach
Establish Testing Scenarios
Testing Scope
Testing of Mobile App
Unit Testing
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
14. Deployment Plan
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
15. Lessons Learned
Lessons Learned
What Went Well
Next Steps: Second Phase
What Could Be Better
Appendix
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 |