å°Šę•¬ēš„ å¾®äæ”걇ēŽ‡ļ¼š1円 ā‰ˆ 0.046166 元 ę”Æä»˜å®ę±‡ēŽ‡ļ¼š1円 ā‰ˆ 0.046257元 [退å‡ŗē™»å½•]
SlideShare a Scribd company logo
DECQ L.L.C.
COLEMAN UNIVERSITY SCHEDULING SYSTEM
Jorge Caballero, Project Manager
Barbara Essien, Project Coordinator/End User
Edwin Depaz, Facilitator
Mike Quimpo, Database Administrator
The Company
DEQC, LLC is a new and
innovative consulting
company dedicated to create
and design quality products
for our clients based upon the
latest technology. Our goal
and company vision is to
differentiate ourselves
through technology, and to
lead in service and quality as
a trusted technology partner.
DECQ L.L.C.
The Company
DEQC, LLC was created on 2013 by a group of
computer architects and software designers
looking to make a difference in the technology
field. We are a small company with big dreams
and ideas willing to work hard to help our clients
to achieve their next level of success in the
technology field.
The Problem
ā€¢ Currently the institution does not have an efficient
scheduling system to enroll students to the proper school
curriculum.
ā€¢ The lack of a working scheduling system slows down the
registration process; therefore the productivity of staff
members is diminished.
ā€¢ The current scheduling system is outdated and consists of a
basic Excel spread sheet creating a higher risk for error and
potential loss of valuable data.
ā€¢ The non-existing scheduling systems affects students by
slowing down the registration process and frequently
students do not receive the correct classes or hard copy of
their school curriculum.
The Problem
The Solution
The scheduling system will execute the following task:
ā€¢ The system must produce a class schedule when a student makes an online request for it
before the start of a Mod.
ā€¢ The system must produce a teacher pool and a report of student grades for the dean of each
program when there has been an online request for it by providing a database report of
available teachers.
ā€¢ The system must produce schedules validated by a dean.
ā€¢ The system must produce a student roster following a teacherā€™s web request before a Mod.
ā€¢ The system must produce a studentā€™s grade when requested.
The Solution
Project Manager
Jorge Caballero
ā€¢ Review and approve all project deliverables (Initiation Plan, Detailed Plan,
Testing etc.)
ā€¢ Provide overall project oversight and work with business offices and
Technical Project manager to keep project on track.
ā€¢ Ensures business and functional decisions are made to ensure technical
development progress and completion.
ā€¢ Work with Change Manager to develop Campus Readiness plan and
related deliverables
ā€¢ Ensure the project is initiated against a plan.
ā€¢ Gain buy-in from key stakeholders and keep their interest and level
involvement right throughout the project.
ā€¢ Measure the performance of the project. Know how the project is
performing against milestones, time frames, deliverables, budget and
resources.
System Analyst/Programmer
Jorge Caballero, Barbara Essien, Edwin Depaz, Mike Quimpo
ā€¢ Participate in Requirements gathering
ā€¢ Develop, review and refine technical spec
ā€¢ Design, Build, Unit test, migrate and transition
all technical deliverables, including online
reports
ā€¢ Conduct Stress Test (if needed)
Project Coordinator
Barbara Essien
Assist Project Manager with
scheduling meetings and
securing meeting space
Capture meeting notes
about the discussion and
design in an orderly
fashion
Assist with stakeholder
involvement throughout
project lifecycle
Project Coordinator
Barbara Essien
Assist with development of
test plan
Support and
participate in
testing
End User Training Security Expert
Barbara EssienWork with project team to
define training approach
Develop training
materials
Develop security
policies
Deliver training
and information
sessions
Coordinate
training logistics
Facilitator
Edwin Depaz
Prepares a
draft of the
requirements
and organizes
the JAD
sessions.
Facilitator
Edwin Depaz
ā€¢ Controls the meeting and keeps the group on the
agenda
ā€¢ Classify issues into those that can be solved as
part of the meeting and those which need to be
assigned for follow-up
ā€¢ Facilitate the decision-making process by asking
questions, seeking out ideas from all of the
participants, ensuring that the discussion is
focused and capturing sufficient amounts of
information for documentation and review
Facilitator
Edwin Depaz
Facilitator creates the
final version of the
requirements
documentation
Database Administrator
Mike Quimpo
ā€¢Installing and upgrading the database server and application
tools
ā€¢Allocating system storage and planning future storage
requirements for the database system
ā€¢Modifying the database structure, as necessary, from
information given by application developers verbally
ā€¢Enrolling users and maintaining system security
ā€¢Ensuring compliance with database vendor license agreement
Database Administrator
Mike Quimpo
ā€¢Controlling and monitoring user access to the database
ā€¢Monitoring and optimizing the performance of the database
ā€¢Planning for backup and recovery of database information
ā€¢Maintaining archived data
ā€¢Backing up and restoring databases
ā€¢Contacting database vendor for technical support
ā€¢Generating various reports by querying from database as per
need.
ā€¢Game server hosting, administration of games, using a database.
Program Costs
ā€¢ Development - Currently Coleman University spends approximately $3,312.00 per mod
extracting studentā€™s information, processing and creating the schedule for the next mod. This
numbers reflect the cost from deans working 24 hours at a $25.00 pay rate and student
advisors working 24 hours to a $19.00 pay rate, not taking in consideration the operational
cost. Our scheduling system will reduce the time and processing cost to a $1,208.00 per mod,
giving Coleman University a total of $2,104.00 on savings per mod; the expected
implementation life of our project is about 4 modā€™s equivalent to 40 calendar weeks, this will
bring a total of $8,416.00 on savings just from the development area.
ā€¢ Training ā€“ Currently Coleman University implements and old outdated scheduling system,
which most of the users have ample training on how to update and do changes. If our
scheduling system gets implemented an initial and one time training expense of $80.00 for a
8 hour training seminar will be the only expense to master the scheduling system training.
ā€¢ Operational (ETL, Web/Database Maintenance) ā€“ A small monthly fee for data extracting and
maintenance fee of $75.00 for the duration of 3 months will be part of the system operational
expense. As mentioned before the expected implementation of our project is 4 months,
however, we only have to implement that service for the first three months of the life of the
system due to the uncertainty duration of the scheduling system. The charge will continue if
the life of the project gets an extension.
ā€¢ Given the limitations of the project, the computed return on investment for the Coleman
University Scheduling Application System is $8,416.00 in the first four mods and a expected
payback period to break even on the second mod of implementation, making this a 52.3 %
return profit for the company.
Program Costs
Program Costs
Program Costs
Program Costs
Program Costs
Database Generation
Database Generation
Database Generation
Technical Specifications
Technical Specifications
Technology Concepts
Technology Concepts
Technology Concepts
Technology Concepts
Technology Concepts
Where do we go from here?
QUESTIONS?

More Related Content

What's hot

lenny resume
lenny resumelenny resume
lenny resume
Lenny Skierski
Ā 
Task management system
Task management systemTask management system
Task management system
Jayy Shah
Ā 
Hire Fulltime Web Developer
Hire Fulltime Web DeveloperHire Fulltime Web Developer
Hire Fulltime Web Developer
Cooper Hill
Ā 
Ppc software
Ppc softwarePpc software
Ppc software
MohammadNuruddinSohel
Ā 
sarath_virtusa
sarath_virtusasarath_virtusa
sarath_virtusa
chanda4uonly
Ā 
Neeraj Kumar Resume 2.0
Neeraj Kumar Resume 2.0Neeraj Kumar Resume 2.0
Neeraj Kumar Resume 2.0
Neeraj Kumar
Ā 
Sheela_Resume
Sheela_ResumeSheela_Resume
Sheela_Resume
Sheela Kanakaraj
Ā 
Workable software review
Workable software reviewWorkable software review
Workable software review
whatasoftware
Ā 
Sulakshana PramodKumar
Sulakshana PramodKumarSulakshana PramodKumar
Sulakshana PramodKumar
Sulakshana Sudarsanan
Ā 
Implementing Site Manager in UAS at University of Oxford
Implementing Site Manager in UAS at University of OxfordImplementing Site Manager in UAS at University of Oxford
Implementing Site Manager in UAS at University of Oxford
David Miller
Ā 
Web application maintenance services
Web application maintenance servicesWeb application maintenance services
Web application maintenance services
vanitharajblaze
Ā 
Web Developer Salary | Edureka
Web Developer Salary | EdurekaWeb Developer Salary | Edureka
Web Developer Salary | Edureka
Edureka!
Ā 
Jyoti Pareek
Jyoti PareekJyoti Pareek
Jyoti Pareek
Jyoti Pareek
Ā 

What's hot (13)

lenny resume
lenny resumelenny resume
lenny resume
Ā 
Task management system
Task management systemTask management system
Task management system
Ā 
Hire Fulltime Web Developer
Hire Fulltime Web DeveloperHire Fulltime Web Developer
Hire Fulltime Web Developer
Ā 
Ppc software
Ppc softwarePpc software
Ppc software
Ā 
sarath_virtusa
sarath_virtusasarath_virtusa
sarath_virtusa
Ā 
Neeraj Kumar Resume 2.0
Neeraj Kumar Resume 2.0Neeraj Kumar Resume 2.0
Neeraj Kumar Resume 2.0
Ā 
Sheela_Resume
Sheela_ResumeSheela_Resume
Sheela_Resume
Ā 
Workable software review
Workable software reviewWorkable software review
Workable software review
Ā 
Sulakshana PramodKumar
Sulakshana PramodKumarSulakshana PramodKumar
Sulakshana PramodKumar
Ā 
Implementing Site Manager in UAS at University of Oxford
Implementing Site Manager in UAS at University of OxfordImplementing Site Manager in UAS at University of Oxford
Implementing Site Manager in UAS at University of Oxford
Ā 
Web application maintenance services
Web application maintenance servicesWeb application maintenance services
Web application maintenance services
Ā 
Web Developer Salary | Edureka
Web Developer Salary | EdurekaWeb Developer Salary | Edureka
Web Developer Salary | Edureka
Ā 
Jyoti Pareek
Jyoti PareekJyoti Pareek
Jyoti Pareek
Ā 

Viewers also liked

Dream dayppt
Dream daypptDream dayppt
Dream dayppt
joyousone1104
Ā 
Mitch capstone presentation
Mitch capstone presentationMitch capstone presentation
Mitch capstone presentation
joyousone1104
Ā 
Hargis and kimery inc
Hargis and kimery incHargis and kimery inc
Hargis and kimery inc
joyousone1104
Ā 
Capstone powerpoint
Capstone powerpointCapstone powerpoint
Capstone powerpoint
joyousone1104
Ā 
Iss presentation 68214-46950-93485-34617
Iss presentation 68214-46950-93485-34617Iss presentation 68214-46950-93485-34617
Iss presentation 68214-46950-93485-34617
joyousone1104
Ā 
Opaque powerpoint
Opaque powerpointOpaque powerpoint
Opaque powerpoint
joyousone1104
Ā 
Newest copy _rockstar solutions
Newest copy _rockstar solutionsNewest copy _rockstar solutions
Newest copy _rockstar solutions
joyousone1104
Ā 
In hand show
In hand showIn hand show
In hand show
joyousone1104
Ā 
Presentation1219
Presentation1219Presentation1219
Presentation1219
joyousone1104
Ā 

Viewers also liked (9)

Dream dayppt
Dream daypptDream dayppt
Dream dayppt
Ā 
Mitch capstone presentation
Mitch capstone presentationMitch capstone presentation
Mitch capstone presentation
Ā 
Hargis and kimery inc
Hargis and kimery incHargis and kimery inc
Hargis and kimery inc
Ā 
Capstone powerpoint
Capstone powerpointCapstone powerpoint
Capstone powerpoint
Ā 
Iss presentation 68214-46950-93485-34617
Iss presentation 68214-46950-93485-34617Iss presentation 68214-46950-93485-34617
Iss presentation 68214-46950-93485-34617
Ā 
Opaque powerpoint
Opaque powerpointOpaque powerpoint
Opaque powerpoint
Ā 
Newest copy _rockstar solutions
Newest copy _rockstar solutionsNewest copy _rockstar solutions
Newest copy _rockstar solutions
Ā 
In hand show
In hand showIn hand show
In hand show
Ā 
Presentation1219
Presentation1219Presentation1219
Presentation1219
Ā 

Similar to Decq llc final

Presentation Slides of College Management System Report
Presentation Slides of College Management System ReportPresentation Slides of College Management System Report
Presentation Slides of College Management System Report
MuhammadHusnainRaza
Ā 
AngelaShortridge Resume -010917
AngelaShortridge Resume -010917AngelaShortridge Resume -010917
AngelaShortridge Resume -010917
Angie Shortridge
Ā 
Robert-Project Presentation
Robert-Project PresentationRobert-Project Presentation
Robert-Project Presentation
Robert D. Williams
Ā 
Proj Mgmt.ppt
Proj Mgmt.pptProj Mgmt.ppt
Proj Mgmt.ppt
NikhilDudka
Ā 
Mahesh_resume
Mahesh_resumeMahesh_resume
Mahesh_resume
Mahesh Satpute
Ā 
Sumalatha_Kalugotla
Sumalatha_KalugotlaSumalatha_Kalugotla
Sumalatha_Kalugotla
Sumalatha Kalugotla
Ā 
Gururajan_new
Gururajan_newGururajan_new
Gururajan_new
Gururajan Venkataraman
Ā 
JC_Gabuya_Resume
JC_Gabuya_ResumeJC_Gabuya_Resume
JC_Gabuya_Resume
John Carlo Gabuya
Ā 
Bua 235 teamwork
Bua 235 teamwork Bua 235 teamwork
Bua 235 teamwork
UMaine
Ā 
Developing A Facilities Vision - Savings Summit 2013
Developing A Facilities Vision - Savings Summit 2013Developing A Facilities Vision - Savings Summit 2013
Developing A Facilities Vision - Savings Summit 2013
SchoolDude
Ā 
Siddharth Dutta
Siddharth DuttaSiddharth Dutta
Siddharth Dutta
Siddharth Dutta
Ā 
KPavanKumar_Resume
KPavanKumar_ResumeKPavanKumar_Resume
KPavanKumar_Resume
K Pavan Kumar
Ā 
Seminar on Project Management by Rj
Seminar on Project Management by RjSeminar on Project Management by Rj
Seminar on Project Management by Rj
Shree M.L.Kakadiya MCA mahila college, Amreli
Ā 
Hari Babu-DBA Resume
Hari Babu-DBA ResumeHari Babu-DBA Resume
Hari Babu-DBA Resume
haribabu pamarthi
Ā 
Proposal DMS
Proposal   DMS Proposal   DMS
Proposal DMS
Media-Mosaic
Ā 
Resume charles vermette
Resume   charles vermetteResume   charles vermette
Resume charles vermette
Charles Vermette
Ā 
Resume charles vermette
Resume   charles vermetteResume   charles vermette
Resume charles vermette
Charles Vermette
Ā 
Patricia R. Smogor_v6
Patricia R. Smogor_v6Patricia R. Smogor_v6
Patricia R. Smogor_v6
Patti Smogor
Ā 
Computer Based Assessment.pptx
Computer Based Assessment.pptxComputer Based Assessment.pptx
Computer Based Assessment.pptx
salah327743
Ā 
Proposal dms for dwf v2
Proposal   dms for dwf v2Proposal   dms for dwf v2
Proposal dms for dwf v2
Media-Mosaic
Ā 

Similar to Decq llc final (20)

Presentation Slides of College Management System Report
Presentation Slides of College Management System ReportPresentation Slides of College Management System Report
Presentation Slides of College Management System Report
Ā 
AngelaShortridge Resume -010917
AngelaShortridge Resume -010917AngelaShortridge Resume -010917
AngelaShortridge Resume -010917
Ā 
Robert-Project Presentation
Robert-Project PresentationRobert-Project Presentation
Robert-Project Presentation
Ā 
Proj Mgmt.ppt
Proj Mgmt.pptProj Mgmt.ppt
Proj Mgmt.ppt
Ā 
Mahesh_resume
Mahesh_resumeMahesh_resume
Mahesh_resume
Ā 
Sumalatha_Kalugotla
Sumalatha_KalugotlaSumalatha_Kalugotla
Sumalatha_Kalugotla
Ā 
Gururajan_new
Gururajan_newGururajan_new
Gururajan_new
Ā 
JC_Gabuya_Resume
JC_Gabuya_ResumeJC_Gabuya_Resume
JC_Gabuya_Resume
Ā 
Bua 235 teamwork
Bua 235 teamwork Bua 235 teamwork
Bua 235 teamwork
Ā 
Developing A Facilities Vision - Savings Summit 2013
Developing A Facilities Vision - Savings Summit 2013Developing A Facilities Vision - Savings Summit 2013
Developing A Facilities Vision - Savings Summit 2013
Ā 
Siddharth Dutta
Siddharth DuttaSiddharth Dutta
Siddharth Dutta
Ā 
KPavanKumar_Resume
KPavanKumar_ResumeKPavanKumar_Resume
KPavanKumar_Resume
Ā 
Seminar on Project Management by Rj
Seminar on Project Management by RjSeminar on Project Management by Rj
Seminar on Project Management by Rj
Ā 
Hari Babu-DBA Resume
Hari Babu-DBA ResumeHari Babu-DBA Resume
Hari Babu-DBA Resume
Ā 
Proposal DMS
Proposal   DMS Proposal   DMS
Proposal DMS
Ā 
Resume charles vermette
Resume   charles vermetteResume   charles vermette
Resume charles vermette
Ā 
Resume charles vermette
Resume   charles vermetteResume   charles vermette
Resume charles vermette
Ā 
Patricia R. Smogor_v6
Patricia R. Smogor_v6Patricia R. Smogor_v6
Patricia R. Smogor_v6
Ā 
Computer Based Assessment.pptx
Computer Based Assessment.pptxComputer Based Assessment.pptx
Computer Based Assessment.pptx
Ā 
Proposal dms for dwf v2
Proposal   dms for dwf v2Proposal   dms for dwf v2
Proposal dms for dwf v2
Ā 

Recently uploaded

QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
AlexanderRichford
Ā 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
Safe Software
Ā 
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - MydbopsMySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
Mydbops
Ā 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
Tobias Schneck
Ā 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
Larry Smarr
Ā 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
UiPathCommunity
Ā 
Must Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during MigrationMust Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during Migration
Mydbops
Ā 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
Neeraj Kumar Singh
Ā 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
Enterprise Knowledge
Ā 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
ScyllaDB
Ā 
APJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes WebinarAPJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes Webinar
ThousandEyes
Ā 
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
TrustArc
Ā 
Fuxnet [EN] .pdf
Fuxnet [EN]                                   .pdfFuxnet [EN]                                   .pdf
Fuxnet [EN] .pdf
Overkill Security
Ā 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
ScyllaDB
Ā 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
UmmeSalmaM1
Ā 
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
leebarnesutopia
Ā 
Day 4 - Excel Automation and Data Manipulation
Day 4 - Excel Automation and Data ManipulationDay 4 - Excel Automation and Data Manipulation
Day 4 - Excel Automation and Data Manipulation
UiPathCommunity
Ā 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
Ā 
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDCScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB
Ā 
Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2
DianaGray10
Ā 

Recently uploaded (20)

QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
Ā 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
Ā 
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - MydbopsMySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
Ā 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
Ā 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
Ā 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
Ā 
Must Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during MigrationMust Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during Migration
Ā 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
Ā 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
Ā 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
Ā 
APJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes WebinarAPJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes Webinar
Ā 
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...
Ā 
Fuxnet [EN] .pdf
Fuxnet [EN]                                   .pdfFuxnet [EN]                                   .pdf
Fuxnet [EN] .pdf
Ā 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
Ā 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
Ā 
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Ā 
Day 4 - Excel Automation and Data Manipulation
Day 4 - Excel Automation and Data ManipulationDay 4 - Excel Automation and Data Manipulation
Day 4 - Excel Automation and Data Manipulation
Ā 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
Ā 
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDCScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDC
Ā 
Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2
Ā 

Decq llc final

  • 1.
  • 2. DECQ L.L.C. COLEMAN UNIVERSITY SCHEDULING SYSTEM Jorge Caballero, Project Manager Barbara Essien, Project Coordinator/End User Edwin Depaz, Facilitator Mike Quimpo, Database Administrator
  • 3. The Company DEQC, LLC is a new and innovative consulting company dedicated to create and design quality products for our clients based upon the latest technology. Our goal and company vision is to differentiate ourselves through technology, and to lead in service and quality as a trusted technology partner. DECQ L.L.C.
  • 4. The Company DEQC, LLC was created on 2013 by a group of computer architects and software designers looking to make a difference in the technology field. We are a small company with big dreams and ideas willing to work hard to help our clients to achieve their next level of success in the technology field.
  • 5. The Problem ā€¢ Currently the institution does not have an efficient scheduling system to enroll students to the proper school curriculum. ā€¢ The lack of a working scheduling system slows down the registration process; therefore the productivity of staff members is diminished. ā€¢ The current scheduling system is outdated and consists of a basic Excel spread sheet creating a higher risk for error and potential loss of valuable data. ā€¢ The non-existing scheduling systems affects students by slowing down the registration process and frequently students do not receive the correct classes or hard copy of their school curriculum.
  • 7. The Solution The scheduling system will execute the following task: ā€¢ The system must produce a class schedule when a student makes an online request for it before the start of a Mod. ā€¢ The system must produce a teacher pool and a report of student grades for the dean of each program when there has been an online request for it by providing a database report of available teachers. ā€¢ The system must produce schedules validated by a dean. ā€¢ The system must produce a student roster following a teacherā€™s web request before a Mod. ā€¢ The system must produce a studentā€™s grade when requested.
  • 9. Project Manager Jorge Caballero ā€¢ Review and approve all project deliverables (Initiation Plan, Detailed Plan, Testing etc.) ā€¢ Provide overall project oversight and work with business offices and Technical Project manager to keep project on track. ā€¢ Ensures business and functional decisions are made to ensure technical development progress and completion. ā€¢ Work with Change Manager to develop Campus Readiness plan and related deliverables ā€¢ Ensure the project is initiated against a plan. ā€¢ Gain buy-in from key stakeholders and keep their interest and level involvement right throughout the project. ā€¢ Measure the performance of the project. Know how the project is performing against milestones, time frames, deliverables, budget and resources.
  • 10. System Analyst/Programmer Jorge Caballero, Barbara Essien, Edwin Depaz, Mike Quimpo ā€¢ Participate in Requirements gathering ā€¢ Develop, review and refine technical spec ā€¢ Design, Build, Unit test, migrate and transition all technical deliverables, including online reports ā€¢ Conduct Stress Test (if needed)
  • 11. Project Coordinator Barbara Essien Assist Project Manager with scheduling meetings and securing meeting space Capture meeting notes about the discussion and design in an orderly fashion Assist with stakeholder involvement throughout project lifecycle
  • 12. Project Coordinator Barbara Essien Assist with development of test plan Support and participate in testing
  • 13. End User Training Security Expert Barbara EssienWork with project team to define training approach Develop training materials Develop security policies Deliver training and information sessions Coordinate training logistics
  • 14. Facilitator Edwin Depaz Prepares a draft of the requirements and organizes the JAD sessions.
  • 15. Facilitator Edwin Depaz ā€¢ Controls the meeting and keeps the group on the agenda ā€¢ Classify issues into those that can be solved as part of the meeting and those which need to be assigned for follow-up ā€¢ Facilitate the decision-making process by asking questions, seeking out ideas from all of the participants, ensuring that the discussion is focused and capturing sufficient amounts of information for documentation and review
  • 16. Facilitator Edwin Depaz Facilitator creates the final version of the requirements documentation
  • 17. Database Administrator Mike Quimpo ā€¢Installing and upgrading the database server and application tools ā€¢Allocating system storage and planning future storage requirements for the database system ā€¢Modifying the database structure, as necessary, from information given by application developers verbally ā€¢Enrolling users and maintaining system security ā€¢Ensuring compliance with database vendor license agreement
  • 18. Database Administrator Mike Quimpo ā€¢Controlling and monitoring user access to the database ā€¢Monitoring and optimizing the performance of the database ā€¢Planning for backup and recovery of database information ā€¢Maintaining archived data ā€¢Backing up and restoring databases ā€¢Contacting database vendor for technical support ā€¢Generating various reports by querying from database as per need. ā€¢Game server hosting, administration of games, using a database.
  • 19. Program Costs ā€¢ Development - Currently Coleman University spends approximately $3,312.00 per mod extracting studentā€™s information, processing and creating the schedule for the next mod. This numbers reflect the cost from deans working 24 hours at a $25.00 pay rate and student advisors working 24 hours to a $19.00 pay rate, not taking in consideration the operational cost. Our scheduling system will reduce the time and processing cost to a $1,208.00 per mod, giving Coleman University a total of $2,104.00 on savings per mod; the expected implementation life of our project is about 4 modā€™s equivalent to 40 calendar weeks, this will bring a total of $8,416.00 on savings just from the development area. ā€¢ Training ā€“ Currently Coleman University implements and old outdated scheduling system, which most of the users have ample training on how to update and do changes. If our scheduling system gets implemented an initial and one time training expense of $80.00 for a 8 hour training seminar will be the only expense to master the scheduling system training. ā€¢ Operational (ETL, Web/Database Maintenance) ā€“ A small monthly fee for data extracting and maintenance fee of $75.00 for the duration of 3 months will be part of the system operational expense. As mentioned before the expected implementation of our project is 4 months, however, we only have to implement that service for the first three months of the life of the system due to the uncertainty duration of the scheduling system. The charge will continue if the life of the project gets an extension. ā€¢ Given the limitations of the project, the computed return on investment for the Coleman University Scheduling Application System is $8,416.00 in the first four mods and a expected payback period to break even on the second mod of implementation, making this a 52.3 % return profit for the company.
  • 35.
  • 36. Where do we go from here?
  ēæ»čƑļ¼š