Texas Lottery Commission

tenuousdrunkshipInternet και Εφαρμογές Web

12 Νοε 2013 (πριν από 3 χρόνια και 10 μήνες)

402 εμφανίσεις

Original


RESPONSE


To

Texas Lottery Commission


STATEMENT OF WORK (SOW)


FOR

DELIVERABLES
-
BASED INFORMATION TECHNOLOGY SERVICES

Application Development Services for

Charitable Bingo Operations Division System


By



PreludeSys

Vendor Name

Prelude Systems, Inc.

Proposal Submitted by

Craig Oliver

Contact Details

Email :
coliver@preludesys.com

Telephone Number:
512
-
582
-
7507

Facsimile Number:
909
-
801
-
2369

Date of Submission


09/
10
/2013





Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
2

Table of Contents


Table of Contents

................................
................................
................................
.......................

2

1

Background

................................
................................
................................
.........................

7

2

PreludeSys Res
ponse Organization to meet Required Content in Bidder Response

..........

7

2.1

Value Proposition

................................
................................
................................
.........

7

2.2

Project Approach

................................
................................
................................
.........

8

2.2.1

PreludeSys uniqueness to Project Approach and Delivery

................................
...
10

2.3

Technical Approach

................................
................................
................................
....
11

2.3.1

Solution Overview

................................
................................
................................
11

2.4

Project Management and Software Development Process

................................
..........
14

2.5

PreludeSys Functional Expertise

................................
................................
................
23

2.6

PreludeSys Technical Expertise

................................
................................
..................
23

2.7

No. of years’ experience in providing similar services

................................
.................
24

2.8

Application development projects delivered during the past five years

........................
25

2.9

IT Application Maintenance and Support for private, government organizations and
Texas state agencies

................................
................................
................................
.............
27

2.10

References

................................
................................
................................
.................
29

2.12

Scope o
f work

................................
................................
................................
.............
31

2.13

Assumptions

................................
................................
................................
...............
32

2.14

Out of Scope

................................
................................
................................
...............
34

2.15

Cost Proposal

................................
................................
................................
.............
35

2.16

Pricing Sheet

................................
................................
................................
..............
35

2.17

Pricing Sheet for Hourly Rate

................................
................................
......................
37

3

Project Organization

................................
................................
................................
..........
38

3.1

Project Engagement Model

................................
................................
.........................
38

3.2

Organization Chart

................................
................................
................................
......
38


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
3

3.3

Project Organization Plan

................................
................................
...........................
39

3.4

Roles and Responsibilities Matrix

................................
................................
...............
40

3.5

Communication Plan

................................
................................
................................
...
41

3.6

Ri
sk and Issues

................................
................................
................................
..........
42

4

Project Schedule, Deliverables and Plan

................................
................................
...........
4
4

4.1

Schedule

................................
................................
................................
.....................
44

4.2

Project Plan

................................
................................
................................
................
46

4.3

Mileston
e Chart

................................
................................
................................
...........
48

5

Agreement to confidentiality and legal statements

................................
.............................
49

6

Qualifications & Resumes of Proposed Key Staff

................................
...............................
51

6.1

Project Manager
-

Chandilvel Singaravelu

................................
................................
..
51

SUMMARY

................................
................................
................................
........................
51

SKILLS

................................
................................
................................
..............................
52

PROFESSIONAL EXPERIE
NCE

................................
................................
.......................
53

EDUCATION & CERTIFIC
ATION

................................
................................
......................
59

6.2

Enterprise Architect


Jayaraman Palaniappan

................................
...........................
60

SUMMARY

................................
................................
................................
........................
60

SKILLS

................................
................................
................................
..............................
60

WORK EXPERIENCE

................................
................................
................................
........
61

6.3

Lead Bus
iness Analyst
-

Yogesh Kate

................................
................................
........
65

SUMMARY

................................
................................
................................
........................
65

SKILLS

................................
................................
................................
..............................
66

WORK EXPERIENCE

................................
................................
................................
........
66

EDUCATION/CERTIFICAT
IONS

................................
................................
.......................
80

AWARDS

................................
................................
................................
...........................
80

6.4

Lead Developer
-

Bhaskar Kumar Kuttuva Mohan

................................
......................
81


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
4

SUMMARY

................................
................................
................................
........................
81

SKILLS

................................
................................
................................
..............................
82

WORK EXPERIENCE

................................
................................
................................
........
82

EDUCATION/CERTIFICAT
IONS

................................
................................
.......................
89

6.5

Sr. Database Developer
-

Hari Rajesh Gurram

................................
...........................
90

SUMMARY

................................
................................
................................
........................
90

SKILLS

................................
................................
................................
..............................
91

WORK EXPERIENCE

................................
................................
................................
........
91

EDUCATION/CE
RTIFICATIONS

................................
................................
.......................
99

6.6

Senior Developer


Deepan Rajkumar Muthusamy

................................
.....................
99

SUMMARY

................................
................................
................................
........................
99

SKILLS

................................
................................
................................
............................

100

WORK EXPERIENCE

................................
................................
................................
......

100

EDUCATION/CERTIFICAT
IONS

................................
................................
.....................

109

6.7

Sénior Developer
-

Srinivasaraju Datla

................................
................................
.....

110

SUMMARY

................................
................................
................................
......................

110

SKILLS

................................
................................
................................
............................

111

WORK EXPERIENCE

................................
................................
................................
......

111

EDUCATION/CERTIFICAT
IONS

................................
................................
.....................

122

6.8

Senior Developer
-

Ashokkumar Subramanian

................................
.........................

123

SUMMARY

................................
................................
................................
......................

123

SKILLS

................................
................................
................................
............................

123

PROFESSIONAL EXPERIE
NCE

................................
................................
.....................

124

EDUCATION & CERTIFIC
ATION

................................
................................
....................

128

6.
9

Business Analyst / Quality


Sripriya K Padmanabhan

................................
.............

129

SUMMARY

................................
................................
................................
......................

129


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
5

SKILLS

................................
................................
................................
............................

129

WORK EXPERIENCE

................................
................................
................................
......

129

EDUCATION/CERTIFICAT
IONS

................................
................................
.....................

131

























Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
6

September
10
, 2013



Debi Barbre, CTPM

Contract Specialist

Texas Lottery Commission

611 E. 6th Street

Austin, Texas 78701


Dear Ms. Barbre
,


On behalf of Prelude Systems, thank you fo
r the opportunity to respond to

the Statement of
Work (SOW) for Application Development Services for Charitable Bingo Operations Division
System from the Texas Lottery Commission

(TLC
).

The services described in this document reflect our core competencies
. Our

strengths in the
area of
Application Development
will

provide
unparalleled value and quality to TLC.

Coupled
with
years of experience and a world class personnel support structure
, we will

yield

greater
ef
ficiency and increased flexibility
.

TLC and PreludeSys share similar corpo
rate values. Among these similarities, there are t
wo
which are resoundingly clear:

Integrity and Service Excellence. As these are the driving forces
within our separate enterprises, they will become unifying forces within our continued strategic
partnershi
p
.

We appreciate the opportunity to submit our response to TLC and look forward to a long lasting,
mutual
ly beneficial relationship
.


Sincerely,


Craig Oliver

512
-
582
-
7507



Direct

210.708.6371


Mobile

coliver@preludesys.com



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
7

1

Background

The Charitable Bingo Operation division provides opportunity to monetize funds for charitable
purposes by conducting Bingo.
Charitable Bingo is a fund raising activity and the administrative
oversight is done by Charitable Bingo Operations Division (CBOD).

Currently a system developed on Oracle designer, Forms and Reports Platform called the
Automated Charitable Bingo System

(
ACBS
)

is being used

by CBOD
. The requirement
of Texas
Lottery Commission
is to replace this legacy system with a new application that would help in
better control and supervision

of the operations
.

The new system to be built
will use a Java/ADF platform on

an Oracle database

and
will be
used by the internal staff to manage various operational activities.


2

PreludeSys Response Organization to meet Required Content in Bidder Response

We have organized this SOW response as follows:

1) Agreement to confidentiali
ty and legal statements



Section
5


2) Staff capabilities specific to this SOW:


Key personnel resumes
-

Section
6


3) Bidder’s services capabilities:


Outline of capability to deliver the required services, including process, functional
and technical expertise


Section 2.1,

Section 2.2
, Section 2.3, Section 2.4,
Section 2.5, Section 2.6


Number of years’ experience in providing similar services


Section 2.
7
, Section
2.
8
, Section 2.
9


Five (5) verifiable references


Section 2.
11


Agreed
-
on SOW for deliverables
-
based services



Our e
xecuted SOW
agreement has been a
ttached separately to the response



4)
Project plan addressing the deliverables specified in the SOW


Section
4.2


2.1

Value Proposition

PreludeSys would like to take this opportunity to list the values and alignment towards
TLC

goals and this project specifically as below,

1.

PreludeSys is well expe
rienced and accustomed to DIR’s Texas Project Delivery
Framework having executed multiple projects under the DBITS model with Texas State
Agencies.

2.

PreludeSys has successfully modernized a critical 3000 + User Case Management
system and a public website th
at provides Quality Review data on
p
roviders for another
Texas State Agency under HHSC.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
8

3.

PreludeSys has also successfully implemented 508 compliant
a
ccessibility standards on
multiple projects with Texas State Agencies.

4.

Our critical success factors for prio
r engagements with Texas State Agencies were on
-
time delivery, thorough documentation, exhaustive knowledge transfer and transition to
maintenance activities.

5.

PreludeSys has a team of Microsoft Certified Professionals who have good
understanding, knowledge

and skills to work on Microsoft technology platform. The team
comprises of project members from various projects who collaborate on a regular basis
to share their extensive project experience and the knowledge of .Net and SQL
technology. The team has vast

experience in C#, VB.NET, ASP.NET, ASP, Visual Basic,
Visual C++, IIS, MTS, MSMQ, Index Server, Visual Source Safe, BizTalk Server,
Exchange & SharePoint Portal Server, Ajax.net.

6.

The
t
echnologies identified in the
following section
are
the
core
competencies of
PreludeSys.


2.2

Project Approach

PreludeSys understands the importance of a structured approach in delivering project solutions
especially for large and critical initiatives such as Automated Charitable Bingo System for TLC.
As the first step in making this project successful, PreludeSys has assembled a team that has
key personnel

who have in
-
depth experience and extensive knowledge about Texas Project
Delivery Framework and with
technical staff

who are experts in the technolo
gies proposed for
this solution.

PreludeSys will initiate the project by conducting a kick
-
off meeting to engage with
TLC
’s IT staff
and customer area business sponsors, stakeholders and users. PreludeSys will plan the
detailed activities to validate any

additional/new risks or issues that need to be addressed
during the project. PreludeSys will work with the agency Project Manager to update the project
plan with updated milestones and deliverable dates based on the actual project initiation for
Analysis,

Requirements, Design,
Development, Testing, Deployment
,

Go
-
Live
and Post
implementation tasks
.

Based on Texas Delivery Framework guidelines
and previous experience with similar projects
PreludeSys has identified to deliver the solution in multiple stages
and has critically taken into
account the timelines defined by
TLC

when defining this,

Analysis Stage:

The Analysis stage comprises of requirements gathering and technical design phases.

PreludeSys will approach the Requirements Phase with the following k
ey steps:

1.

A
k
ick
-
off meeting with stakeholders, business sponsors, business and technical subject
matter experts will be held upon project award.

2.

Multiple workgroup sessions to understand and analyze with business and technical

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
9

subject matters for each sys
tem impacted. The following steps and artifacts will be used
during the sessions:



Templates will be used to gather information



Meeting minutes will be captured and circulated for each session



Action items log will be maintained for each session



Change ord
er log will be maintained through the sessions

3.

Multiple Joint Application Development (JAD) Sessions with the necessary experts to
validate use cases and requirements identified from the workgroup sessions.

4.

Hands on analysis of the systems and applications

by Systems Analysts.

5.

Clarification Sessions based on the finding of the hands on analysis.

6.

Documentation of SRS and STP.

7.

SRS Signoff sessions with subject matter experts.

PreludeSys will approach the Design Phase with the following key steps:

1.

Technical
Architecture validation meetings with TLC and other stakeholders.

2.

Document SDD, SAA and RTTR.

3.

Update SRS and STP.

4.

Conduct meetings with external stakeholders and validate interfaces and Web Services.

5.

SDD, SAA and STP signoff sessions with subject matter ex
perts.

Execution Stage:

During the Execution Stage of the project, PreludeSys will utilize its proven SDLC solution
development methodology that
will include

development, testing and deployment phases
:

o

The vendor will plan the detailed activities to validate any additional/new risks or issues that
need to be addressed during the project based on the Analysis stage.

o

The vendor will work with the agency project manager to update the project plan with
upd
ated milestones and dates for completion of Development, Testing, Deployment and Go
Live tasks.

o

Adopt an iterative process to develop the solution and integrate. Currently 4 iterations have
been planned for development

During the Testing Phase of the p
roject, t
he application would go through the following testing
phases
.

Unit Testing

During the development phase t
he code goes
through
Unit Testing for achieving the design
goal.

The unit testing will be done by PreludeSys developers.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
10

Development Integrat
ion Testing

After a particular unit of work or module has been developed and unit testing, PreludeSys
Quality Assurance team will perform testing to make sure the application is ready for QA Test/
System Integration Test (SIT).

QA Test /
System
Integration
Testing

(SIT)

System Testing is a verification that checks if the build (units integrated into modules and finally
into the product) meets the system specifications approved by
TLC
. This is done by the
TLC QA
Testers
who use system test cases.
These system test cases are designed to check if the
application meets the requirement specifications in SRS. These system test cases are reviewed
by the PM/SME to check if all functionality has adequate test cases for normal and abnormal
scenarios.

User A
cceptance Testing

(UAT) / Customer Acceptance Test

During acceptance testing, UAT test cases are used which are designed to test the final product
in the intended environment to check if the application meets
TLC

business requirements.
These are reviewed b
y the Project Manager (PM) /SME/Customer to ensure that all business
scenarios are covered by the test cases
.

Accessibility and Usability

Testing



The new application will comply with the DIR’s EIR accessibility standards.



The user interface to be develope
d will be
strictly adhering to the Agency Standards and
will be tested by TLC Quality Assurance team if it meets the same.


2.2.1

PreludeSys uniqueness

to Project Approach and Delivery

As PreludeSys has exhibited in the past with small and large projects and
support initiatives with
other Texas State Agencies, PreludeSys will leverage its unique approach that has led to
successful implementations. Although PreludeSys adopts these from their experience, industry
best practices, standards and methodologies, Pre
ludeSys knowledge about how it fits the
agency best and how the vendor can successfully deliver project solutions will provide the
unique approach to mitigating risks for the agency and making the agency IT and customer
areas successful. Some of the key f
actors include

o

Use case driven iterative development iterations

o

Pragmatic and parallel testing with development to reduce

any code or functionality
breakage.

o

Automated build and unit tests to find bugs faster and regression test existing functionality.

o

Technical and functional leader driven teams to build
various modules

and other sub
systems

o

Collaborative development and integration to seamlessly integrate the sub systems
.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
11

o

Project coordination/management across these teams to provide a unified view to
T
LC

o

Timely communications/updates with status, issues, risks and escalations to
TLC

o

Project management and delivery using
DIR Texas Delivery Framework and Extensions and
adapting to TLC framework
.

o

Technical expertise with infrastructure, environments, staff

and technology.

o

Configuration Management Approach that will easily integrate with existing
TLC

configuration management plan and seamlessly merge newly developed code.

2.3

Technical Approach

PreludeSys proposes using following technologies
to build the redesi
gned ACBS solution
that
meets
the a
pplication
a
rchitecture
s
tandards
and technology preferences
provided by
TLC.



Presentation:

Oracle ADF Faces, Oracle ADF Task Flow



Database:


Oracle Database 12c, Oracle Toplink



Reporting:


Jasper Reports



Data Migration:

Oracle database tools and custom scripts.



Integration:


Any TLC recommended SOA solution




Application

Server:
TLC recommended JEE Compliant Server


Platfor
m:


Linux/Unix/Solaris

2.3.1

Solution Overview

PreludeSys has carefully reviewed the Statement of Work and
Question and Answer
Responses Final documents

provided by
TLC

and proposes
the
following
high
-
level
solution
architecture and approach on how we will build

the technical solution
.

PreludeSys has made
these suggestions based on the experience with such type of solutions and will modify any part
of the approach as per TLC requirements once awarded.

2.3.1.1

Component Architecture

We will use following components as building blocks for building any and all modules.

2.3.1.1.1

User Interface


-

We will use Oracle ADF Faces to build simple web forms and content pages.


-

We will user Oracle ADF Task flow to build wizard or workflow.

2.3.1.1.2

Front Contr
ollers

-

We will use Oracle ADF Controllers to manage request response lifecycle and define
navigation rules based on user’s roles and responsibilities.

2.3.1.1.3

Business Components

-

We will user Oracle ADF business component to interface with the database and write

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
12

business logic and functional validation.

2.3.1.1.4

Application
Container

-

We will use any TLC recommended JEE compliant server as our application container
to host the solution.

2.3.1.1.5

Integration Services

-

We will build REST/SOAP based web services as appropriate to build integration
adapters on each module.

-

We will use any TLC recommended SOA suite to build integration services

2.3.1.1.6

Reporting

-

We will use Jasper Reports Designer and
Jasper Reports Server to build custom
reports and Business Intelligence data.

2.3.1.1.7

Security

-

We will integrate with existing Oracle Identity Server to
enable

authentication and
authorization
based on roles and responsibilities defined by TLC.


-

We will use HTTP

over SSL to provide transport security between modules and end
users.
















Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
13

2.3.1.2

Components Overview




Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
14

2.3.1.3

Integration Architecture

-

Preludesys recommends service oriented architecture concepts to expose all cross
cutting functionalities on
each module as web services.

-

These web services will then be integrated with other modules using an orchestration
engine that will build workflows based on functional requirements.


2.3.1.4

Integration Overview






2.4

Project Management and Software Development
Process

PreludeSys will leverage its custom project management life cycle, application analysis and
design
processes

that comply

with
DIR Delivery Framework and
TLC
Project Management
Methodology. PreludeSys proposes to manage this project based on such a

methodology that
has been refined based on its past experiences as shown in the diagram below.

From the project management perspective, the SOW determines the list of deliverables and the

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
15

required dates of delivery for those deliverables. This is further
developed into Software Project
Plan (SPP) which is an end
-
to
-
end plan for the execution of the entire project

PROCEDURES

Project Initiation:


Once the SOW is accepted, project initiation starts. As a first step the Project Manager (PM) is
identified.
The PM studies the SOW and conducts a project kick
-
off meeting in which the
stakeholders are informed about the scope and other details of the project. The resources and
infrastructure needs, communication plan, deliverables and delivery schedules, commitm
ents
and expectations from various stakeholders are all discussed at the project kick
-
off meeting.

Project Planning:


The PM prepares Software Project Plan (SPP) which covers all aspects
of P
roject
M
anagement
like resource plan, infrastructure plan,
communication plan, inspection plan (
r
eviews), test plan
(verification and validation), QA plan, configuration management plan, risk management plan.



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
16


The Software Quality Assurance (SQA) reviews the SPP to verify if it is in agreement with the
contents

of SOW in regards to deliverables, delivery schedule and the verification and validation
requirements. These are also included in the Microsoft (MS) Project for tracking purposes.

Project Monitoring and Control:

The weekly status of the project is reviewe
d by the senior management with reference to the
status of commitments mentioned in the SOW and
PreludeSys

quality goals.




During these weekly status meetings, we review weekly achievements with respect to
completion of deliverables, plans for the follo
wing week, status of risks and effectiveness of any
risk mitigation. We also review the status of issue resolution, progress to date compared to
budget, potential scope changes, etc.




Monthly progress reviews are conducted with the project steering comm
ittee which includes key
stakeholders. This reviews the progress with respect to the deliverables, status of stakeholder

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
17

commitments, and issues.

At each phase
-
end, metrics are obtained to check the project performance from project
management perspective
(Schedule, Effort and Cost) and software engineering perspective
(Review Effectiveness, Test Effectiveness and Defect Density). Corrective actions are identified
and implemented if needed.

POLICY

The PreludeSys Quality Policy states


PreludeSys delivers
high quality deliverables and services by following proven methodologies,
effective testing and a rigorous quality control process.

STANDARDS:

The list of deliverables, delivery schedule, verification and validation requirements are the
references against which the project is monitored for its compliance to the PreludeSys Quality
Policy. To this end the PreludeSys Quality Management System (QMS)
has defined guidelines,
checklists, and templates that standardize all project management activities. Risk Management
Guidelines, Configuration Audit Checklists, and Metrics Templates are all examples of
guidelines and controls to ensure high standards fro
m PreludeSys.

METHODS:

The Review Methods defined in the QMS include the following:

Technical Reviews:

The purpose of Technical Reviews is to check for the completeness,
correctness, feasibility and compliance to standards. These are conducted by Peers, P
roject
Managers, and Subject Matter Experts etc.

Some examples are Design Review, Code Review, and Test Case Review.

Verification:

Verification is to check if the work product has been prepared according to the
design/ specifications. These are normally c
onducted by developers, test engineers and
Software Quality Assurance (SQA).


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
18

Some examples of verification are Unit Testing and System Testing.

Validation:

Validation is done to check if the deliverable meets customer requirements. It is
carried out by th
e customer, a representative of the customer or in the presence of the
customer. Usually, validation is followed by a sign
-
off.

Examples of validation are SRS review, Prototype review and User Acceptance Testing (UAT).

All reviews use the standard Review
Form Template to record the findings in each review. This
is a tool that captures the source, type, cause, severity, status and corrective action taken for
each finding.

Findings from all review forms are consolidated and analyzed at each phase
-
end using a

Defect
Summary tool. The results from this summarization tool are used to identify correction and
improvement needs.

MEASURING DELIVERABLES

Each deliverable goes through a cycle of Preparation, Inspection and (optionally) Testing. The
phase
-
wise work prod
ucts / deliverables and the corresponding preparation, inspection and
testing are detailed as follows:

REQUIREMENTS

System Requirements Specification (SRS
)

Preparation: The template is picked up from the Quality Management System. All header
information/ m
etadata are completed. Requirements stated at a high level in the SOW are
elaborated into a comprehensive set of functional and non
-
functional requirements through one
or more methods of requirement elicitation. These requirements are analyzed, organized i
nto
components, prioritized and then documented as a system requirement specifications

document.


Inspection:

The SRS goes through a technical review by the Subject Matter Expert (SME) to
check for correctness, completeness, feasibility and testability et
c. It is also used to identify and
resolve any requirement conflicts, etc.

Testing (Validation):

SRS is validated by the customer and signed
-
off

DESIGN

Design Document


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
19

Preparation:

The template is taken from the QMS. All header information/ metadata are
completed. The details of solution architecture, database design, UI design, component reuse,
navigation, pseudo code etc are included.

Inspection:

A Technical Review of the design d
ocuments is carried out to ascertain that the
details are necessary and sufficient to implement the system as defined in the SRS.

User Interface (UI) Design

Preparation:

The Design Team prepares the UI design appropriate to the technology chosen
for the so
lution based on the UI details provided in the design document.


Inspection:

A Technical Review of the UI design documents is carried out by the PM to ensure
that it meets the design specifications.

Testing:

The UI Design is validated by the customer

Database Design


Preparation:

The Database (DB) Design is developed using a Design Tool that supports the
chosen database and that provides traceability to meet the Design Document specifications.

Inspection:

A Technical Review of the DB design documents

is carried out by the (Database
Architect (DBA)) to ensure that it meets the design specifications. The review covers the
completeness (vis
-
à
-
vis the classes, transactions etc), adherence to DB Design Best Practices.
The best practices include right level

of normalization, indexing, stored procedures, and scripts
and so on).

Testing:

The DB Design is
validated

by the customer and the development leads.

System Test Cases


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
20


Preparation:

The template is taken from the QMS. All header information/ metadata are

completed.
System Test Cases are designed to check if the application meets the requirement
specifications in SRS. This is prepared by the Test Engineers.

Inspection:

These system test cases are reviewed from a technical perspective by the
PM/SME to veri
fy that all functionalities has adequate test cases for normal and abnormal
scenarios

Requirement Traceability Matrix (RTM)

Preparation:

The template is taken from the QMS. All header information/ metadata are
completed. The system requirements are added a
nd design details from the design document
and database design are mapped to the corresponding system requirements. Dependencies
among requirements are also shown.

Inspection:

Technical review is carried out to ensure that all customer requirements have t
heir
corresponding design, verification, validation and traceability.

CODING AND UNIT TESTING

Code

Preparation:

Code is created as per the pseudo code provided in the Design Document.


Inspection:

Code review is carried out as a Peer Review to check that the code meets the
coding standards applicable to the specific technology.

Testing:

Code is unit tested by the developer to make sure that the code meets the
specifications in the Design Document.
The defects are recorded and tracked until closure in a
Defect Tracking Tool

SYSTEM TESTING

Test Results

Preparation:

The Test Results are recorded when the build (intermediate or final) is tested

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
21

using the system test cases.


Inspection:

Test Results
are inspected for valid defects by the development team.

USER ACCEPTANCE TESTING (UAT)

Test Results

Preparation:

The Test Results are recorded when the final build is tested using the UAT test
cases.

Inspection:

Test Results are inspected for valid defects by the development team.
The defects
are recorded and tracked till their closure in a collaborative Defect Tracking Tool shared by the
developers and the test engineers.

LOAD AND STRESS TESTING

Load

testing at
PreludeSys is designed to test run time performance of the software within the
context of an integrated system. It is not until all systems elements are fully integrated and
certified as free of defects the true performance of a system can be ascertained.
It focuses on
determining or validating performance characteristics of the product under test when subjected
to workload models, and data volumes beyond those anticipated during production operations.
The purpose is to ensure that the system degradation is

graceful during such extreme
conditions.

Performance tests are coupled with stress testing which help in identifying the hardware and
software bottlenecks and tune the system to deliver the required throughput with minimal loss of
performance

PROJECT PLAN
NING

Software Project Plan

Preparation:

The PM prepares Software Project Plan (SPP) which covers all aspects project
management like resource plan, infrastructure plan, communication plan, inspection plan
(Reviews), test plan (verification and validation), Quality Assurance plan, configuration
management plan, risk management plan.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
22


Inspection:

The SQA reviews the SPP to check if it is in agreement with the contents of SOW
with respect to the list of deliverables, delivery schedule, and verification and validation
requirements are concerned.

PR
OJECT MONITORING AND CONTROL

Weekly Status Reports (WSR)

Preparation:

The template is taken from the QMS. All header information/ metadata are
completed. Weekly achievements with respect to the deliverables, plans for the following week,
status of risks an
d effectiveness of any risk mitigation, status of issue resolution etc are all
included in the WSR

Inspection: The WSR is inspected for its data compatibility with the MS project updates and
other trackers like Risk Tracker, Issue Tracker etc.

CHANGE REQU
EST PROCESS

In the event there is a reason to change the project Statement of Work,
TLC
IT will initiate the
change request. The Change Request must provide information regarding the change
comparable to the detail originally included in the Statement of W
ork documentation.

TLC
IT and PreludeSys will endeavor to agree upon appropriate and mutually agreeable
changes in cost, schedule or other terms associated with the Change Request. While such
changes are under review, PreludeSys shall continue to perform u
nder the Statement of Work
so long as such continued performance does not cause
PreludeSys
to incur a material cost or
other undue hardship in relation to the Change Request. Change Request shall be made only
by mutual written agreement of both parties.

No

Change Request shall be implemented unless set forth in writing and approved and signed
by an authorized representative of each party.
PreludeSys
agrees to act in good faith effort with
regard to price and schedule terms if requires for any proposed chang
e

Once a change order is identified we go through the following procedures:



Carefully, define the requirements associated with the change order



Estimate the impact of the change order on the project from a technical perspective



Estimate the cost of the
change order (change order costs can be positive or negative)



Document the change using the Change Request Form. This form includes: Requestor,
Functional Description, Technical Descriptions, Requirements, Anticipated Database
changes, Estimates of Cost, E
stimate to complete and implement change, etc.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
23



Seek approval through the change management process that was agreed to a
t the
beginning of the project.


2.5

PreludeSys Functional Expertise

PreludeSys has developed unique expertise over the years in a variety of

functional areas within
public sector and private sector

and has a large pool of staff proficient in these areas to add
value to every engagement that PreludeSys executes
,

Public Sector

Long Term Care, SNAP, TANF, Medicaid, Managed Care,
Child Support, Ch
ildren’s
f湳nr慮捥. C慳a

j慮慧敭敮eI
bligi扩lity 慮搠p捲敥湩湧I B畳u湥獳so畬敳eb湧i湥I o敧畬at潲oI
o数潲oingI
p散erity 慮d A畤it
.

mriv慴攠p散瑯e

䙩湡湣nI p異灬y C桡i測nC潮t敮t j慮慧敭敮tI bl散瑲潮i挠a慴a
C慰t畲攬


mr敬畤敓y猠桡猠扵ilt t桥 f潬l潷i湧
獯s畴楯湳 for mu扬i挠獥捴潲 捵ct潭orsI



Case Management



Eligibility



Screening



Electronic Data Capture



Content Management



Enterprise Por
t
al


2.6

PreludeSys Technical Expertise

PreludeSys brings a breadth

of unique skills and core competencies

in
Project

Management,
Application Development, Maintenance and Support, Business Intelligence
-
Analytics, Service
Oriented Architecture (SOA), Legacy Modernization,
and
emerging technology expertise in
Business Process Management (
BPM
),
Content Management
,
Mobile, Cl
oud
and

Intelligence
.

The table below illustrates our core Competencies,

Application Development

Java, JEE,
ASP.Net, Oracle ADF,
Cobol
, Rules Engine

Emerging Technologies
(
BPM, Content
Management,
Mobile, Cloud
and Intelligence)

Drupal,
Force.com, iOS, An
droid and other Mobile
development tools and technologies, Hadoop, Tableau, Big
-
Insights and other Big Data technologies

Databases

Oracle
, Microsoft SQL Server,
Sybase, DB2, MySQL


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
24

SOA

Oracle SOA, IBM Websphere

Business Intelligence

IBM Cognos
, SAP Business Objects, Microstrategy, Netezza
,

SSAS

Legacy

PowerBuilder, Visual Basic, Model204, Sybase


2.7

No. of years’ experience in providing similar services

Overall PreludeSys

has been providing
the following
IT services to
organizations

that include
private and government
for ove
r 13 years:



Applica
tion Maintenance and Support (13

Years)



Business Intelligence & Data Warehouse (
8

Years)



Servic
e Oriented Architecture (SOA) (9

Years)



Project Management

(13

Years)



Technology Migration
/Upgrade
and Transformation (13

Years)



Application Development (13

Years)

PreludeSys has been providing deliverable
-
based services to Texas State agencies as a direct
supplier for the past
5

years in the following areas:



Application Maintenance and Support



Service

Oriented Architecture (SOA)



Project Management





Technology Migration/Upgrade and Transformation



Application Development

PreludeSys

has also been providing
IT
services to Texas State agencies as a
subcontractor
for more than 10 years

in the following ar
eas:



Application Maintenance and Support



Service Oriented Architecture (SOA)



Technology Migration/Upgrade and Transformation



Application Development



Business Intelligence





Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
25


2.8

Application development projects delivered during the past five years


1.

Client

Name

Department of Aging and Disability, State of TX

Project Name

Single
Service Authorization System (
S
SAS)

Project Description

Implementation of a Single Service Authorization System
(SSAS) for Long Term Support and Services

-

The scope of the
project included services to develop, build and implement the
new Single Service Authorization System (SSAS). The scope of
SSAS project included

Consolidate service authorization and claims payment
functionality of ID CARE and SAS into
a single integrated DADS
Service Authorization System for all DADS Long Term Services
and Supports (LTSS) programs.

Consolidate all DADS Waiver Interest Lists into the Community
Services Interest Lists (CSILs).

Automate manual forms processes for Communit
y Living and
Attendant Services (CLASS), Deaf Blind with Multiple
Disabilities (DBMD) and Nursing Facilities (NF).

Updates to CSIL for maintenance of HCS and TxHmL Interest
Lists in the Community Services Interest List System (CSIL).

Slot Tracking for HCS
& TxHmL through the new SASO Admin
Slot Tracking System

Management of HCS and TxHmL and Guardianship contracts
through the DADS LTC Provider System.

Project Duration

1
2

Months

Project Cost

$ 2.8 Million

Team Composition

20 Full Time Employees
with

Subcontractors


2.

Client Name

HP Enterprise Services/General Motors

Project Name

Sales Order Management (SOM)

Project Description

Sales Order Management
-

The scope of t he pr oj ect was t o
i mpl ement a Sal es Or der Management sol ut i on f or t he cl i ent's
Aust r al i an sal es deal er net wor k. The scope i ncl uded
r emedi at i on of t hei r cur r ent sal es or der management f r om t hei r
cur r ent I BM Mai nf r ame

/ Power Bui l der sol ut i on t o an Or acl e

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
26

11G SOA platform. The project covered the complete sales
order cycle including the dealer inquiry, search, quotation, order
generation, order processing, contract management, pricing and
billing. The solution also inte
grated seamlessly with financial
systems and SAP supply chain management systems


Project Duration

30 Months

Project Cost

$ 5 Million

Team Composition

15 Full Time Employees
with

5 Sub contractors


3.

Client Name

Allergan, Inc.

Project Name

Lapband
Website Conversion, Telecommute Metrics Collection

Project Description

Lapband Website Conversion project involved converting
multiple major customer facing internet websites of the client
(
http://lapband.com
,
http://lapbandcentral.com

etc.) from Dot Net
framework 1.1 using proprietary scripting from previous vendor
to Dot Net framework 4.0 using standard Microsoft MVC 3.0
framework and razor syntax. The database was Micro
soft SQL
Server and was also utilized for State management.

The Telecommute Metrics Collection project was designing and
developing an intranet web based application that provides an
avenue to record and modifies the days an employee
Telecommutes for work.

It also involved sending weekly
reminder emails to employees who were registered in the
program and haven’t logged any days for the current week.
䙵rt桥r r数orting 潮 t桥 摡t愠t桵猠捯cl散瑥搠桥l灥搠t桥 捬i敮t i渠
慮慬祺i湧 慮搠 im灲潶i湧 t桥 潶敲慬l 捯牰cra
te q敬散emmute
灲pgram.

q敡m 䙯畮摡ti潮 p敲e敲ei猠畴楬iz敤 f潲ow潲o 慬l潣oti潮I 捨cnge
m慮ag敭敮tI 捨cng攠扵il搠慮搠摥ploym敮t 慮搠潶敲慬l tr慣aing
f潲o 慬l w潲o 摯湥. 䙯r 慬l 捨c湧敳Ⱐ req畩r敤 慰灲潶慬 w慳
潢t慩湥搠fr潭 t桥 fq as w敬l 慳a B畳u湥獳s j慮慧er a
湤 潮捥
摥v敬潰敤I w慳am潶敤 t漠nAI mr攠mr潤畣瑩u渠慮搠mr潤畣ti潮
敮vir潮m敮t猠潮ly aft敲 慰灲潰物pte 慰灲潶慬猠w敲攠杲慮g敤.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
27


Project Duration

4 Months

Project Cost

$ 250,000.00

Team Composition

6 Full Time Employees


2.9

IT Application Maintenance and Support for private, government organizations and
Texas state agencies


Organization

Department of Aging & Disability Services (DADS)

Project Name

Service Authorization System Online (SASO)

Scope of Project

Providing support for the ongoing maintenance of the
new SASO system, conversion of data from the
Service Authorization System (SAS) mainframe
system, provide quick IT response to changing
business needs, and provide extended training for
mainframe transit
ion team on
the
new system.

Project Duration

3 Months


Organization

Med
-
Legal, Inc

Project Name

Med
-
Legal Application Maintenance Services (AMS)

Scope of Project

Ongoing support

for bug fixes
, development of
enhancements for Med
-
Legal’ e
J
捯cmer捥c
灯rt慬I
捡獥 m慮agem敮t 獹獴em献 q桥 獣潰攠慬獯si湣n畤敤
扵il摩湧 t潯l猠f潲o摡t愠coll散瑩e渠慮搠m慩湴慩湩湧 摡ta
q畡lity.

mr潪散t a畲慴楯n

lng潩湧



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
28

Organization

Universal Music Group

Project Name

Technical support to UMG RFS (Reporting &
Forecasting
group)

Scope of Project

UMG used analytics about record label sales and
social media response to track and report record
download data to its marketing department and
artists. PreludeSys helped UMG achieve its goal by
building mobile analytics so
lution
in the cloud.

Project Duration

Ongoing



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
29

2.10

References

1.

Client Name

Med
-
Legal, Inc

Project Name

Med
-
Legal Application Maintenance Services (AMS)

Point of Contact (Name and Title)

Stephen Schneider
-

President

Contact Phone Number

(626) 653
-
5160 Ext105

Contact email

StephenSchneider@getrecords.com



2.

Client Name

HP Enterprise Services

Project Name

Sales Order Management (SOM)

Point of Contact (Name and Title)

Kannan Ramachandran
-

PM/VP

Contact Phone Number

248
-
961
-
6640

Contact email

kannan.ramachandran@hp.com



3.

Client Name

First American

Project Name

Data Trace Legacy Migration Project

Point of Contact (Name and Title)

Hien

Huynh

Contact Phone Number

(714) 250
-
6636

Contact email

hihuynh@firstam.com



4.

Client Name

Tuttle click

Project Name

Tuttle Click Automotive Group

Point of Contact (Name and Title)

Paul Wilburn

Contact Phone Number

949
-
598
-
4808


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
30

Contact email

38
-
43 Auto Center Drive, Irvine, CA


92618



5.

Client Name

Universal Music Group

Project Name

MM Music Daily Sales forecasting tool

Point of Contact (Name and Title)

Rajeshbabu Padmanabhan
,
Director
-
Enterprise Application

Contact Phone Number

818 436

3105

Contact email

Rajesh.Babu@umusic.com



6.

Client Name

Department of Aging and Disability Services

Project Name

Service Authorization System Online (SASO)

Point of Contact (Name and Title)

Rhonda Pratt

Contact Phone Number

512 438 5813

Contact email

Rhonda.pratt@dads.state.tx.us





Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
31

2.12

Scope of work

This project consists of a complete redesign of the existing Automated Charitable Bingo
System. The redesign will include but not be limited to:



1. The automation and reporting of business processes for performing accounting
functions of Charitable Bingo.

2. The automation and reporting of business processes for performing licensing
functions of Charitable Bingo.

3. The automation and reporting o
f business processes for performing audit functions of
Charitable Bingo.

4. The automation and reporting of business processes for special projects functions of
Charitable Bingo;

5. The ability of charitable organizations and bingo operators to perform o
nline functions
including, but not limited to:



a.

Application for a license; pay and receive approval for:

i. Amendments,

ii. Temporaries,

iii. Renewals


b. Apply for, pay, and receive approval of worker registry badges

c. Renewal of a license;

d. Online Operator Training;

e. Receive online payments

f. Reporting



6. Provide a semi
-
functional prototype of the new application.

7. Conduct requirements meetings with users.

8. Conduct requirements meetings with Texas Lottery Information Resources

on
interfaces to other Texas Lottery applications.

9. Document business processes.

10. Provide systems documentation in a format approved by the Texas Lottery
Commission

11. Design, Develop, Test, Document and Implement the new Automated Charitable
Bin
go System;

12. Convert existing data into new system.

13. The new system will use a Java/ADF platform on an Oracle database.



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
32

2.13

Assumptions

Scope:



The proposed approach, project plan, resources and cost estimates are based on the
information provided by TLC as part of the SOW.



Any changes in our assumptions, modification to requirements, scope or fun
ctionality
may impact the timelines, resources and

hence the

cost of the project and
is expected to
go through a change request process.



PreludeSys

will meet with
TLC

within
a

week of the project award and will mut
ually
establish an agreed upon Project C
hange
R
equest
(PCR) p
rocess and
a communication
and
escalation plan
.



Any
information/
queries
/questions

requested

by PreludeSys team will be
responded

by
TLC
within a reasonable time preferably within two

day
s
.
If the response is delayed more
than two days PreludeSys Project Manager will escalate to TLC
Project Manager.



Delays impacting the execution dates of critical path activities will go through a mutually
agreed upon impact analysis and subsequent change request process.



Real time
Integration with any external applications is not part of the
scope

of

this
SOW
.

R
esources:



PreludeSys

Project Manager

will be the
sole point of contact to TLC Project Manager
and will be responsible to refer to other PreludeSys staff as required
for meetings and
interactions with
TLC

staff, stakeholders and users.



This
SOW

will require time from
TLC

staff
(business SME’s and information resources)
through a
single point of contact

which will be TLC Project Manager who may
direct to
other resources if required
for the life of

the project
for

analysis, requirements gathering,
design, development, testing, deployment and post implementation support activities.



The
TLC

Steering Committee members, or their designees, will define priorities

with staff
within their division to accommodate participation in this project.



TLC

will coor
dinate requirements meetings with
business Users
.



PreludeSys staff will report to PreludeSys Project Manager and all activities and tasks to
PreludeSys staff will be assigned by PreludeSys Project Manager.



PreludeSys shall be solely responsible to onboard
and offload resources as per the
various requirements of the SOW deliverables throughout the duration of the project.

Project Initiation

and Approach
:



The project is scheduled to begin on a mutually agreed upon date. Any delays in project
initiation will d
elay the respective delivery dates.



PreludeSys
assumes it will be

a few days between project award and kick
-
off to
assemble team and logistics
.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
33



PreludeSys will leverage its
project management and
software development life cycle
methodology

as defined in th
e Section “Project Management and Software Development
Methodology”

which

has been successfully suited to
meet
DIR Texas Project Delivery
framework and will be adapted to meet TLC

Framework and Extensions.



Existing documentation of current In
-
House applica
tions and database will be made
available to
PreludeSys

upon award
.



Technical standards for each of the technology stack if applicable will be provided to the
PreludeSys staff during on
-
boarding process.



TLC will provide access to the existing system to
PreludeSys to be able to perform
analysis immediately after Kickoff.

Requirements:



PreludeSys has conducted a preliminary analysis of the Charity Bingo website and the
various features and components of it that is publically available in relation to the 5
business areas this SOW addresses and has also utilized the data provided in the
background section of the SOW to provide an estimate of the resources, timeline and
costing to complete the deliverables, however the p
roject scope could change during
require
ments sessions;

and PreludeSys expects

all changes must go thr
ough the
Change Control Process.

Execution:



Build and Configuration Management
support
will be provided by
TLC
.



All Database
administration
activities will be handled by
TLC

DBA

and PreludeSys will
provide the necessary deliverables for TLC DBA to be able to execute setup and/or
update the database.



TLC

will provide infrastructure information relevant to the applications being developed
for PreludeSys to prepare Deployment plan.

Testing:



All the necessary test data for UAT and System test will be provided by the
TLC
.



User Acceptance Test cases will be documented and executed by TLC and PreludeSys
will assist TLC during the UAT.

Go Live:



PreludeSys assumes that TLC will own and exe
cute the Go Live activities and
PreludeSys will support in those activities.

Infrastructure:



TLC will provide access to PreludeSys staff to TLC facilities, infrastructure both remote
and onsite in a timely manner.



Deliverables w
ork will be conducted at the

TLC
premises
using the TLC infrastructure.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
34



Any work to be performed off
-
site
can

be done after getting approval from T
LC.



TLC will provide the development environment, equipment and work space necessary
for
PreludeSys

staff to successfully complete
the
SOW deliverables.



TLC will size and procure infrastructure as required for development, test and
production.

Data:



The current data
model/
structure will be made available to the
PreludeSys

upon award
.



TLC will provide resources to
Cleans
e/scrub

data

prior
to conversion
.

Deliverables:



Deliverables will be spread through the life of the project and will have corresponding
review periods respectively.



Once TLC has reviewed a deliverable and has been returned back to PreludeSys for
comments and/or correction,
PreludeSys will mutually determine the timeline (typically 5


15 business days) for returning back the corrected deliverable and expects TLC to
revalidate and approve within a reasonable timeframe typically 3
-
5 business days which
can be mutually agreed u
pon SOW award.



If a deliverable approval is delayed due to unforeseen circumstances not within the
control of Vendor due to delays with environment, infrastructure, availability of resources
to validate and approve due to holidays etc, PreludeSys expects T
LC to perform due
diligence and reasonable judgment and provide direction regarding the deliverable
approval and invoicing.

Post Implementation:



If a defect or enhancement is not released into production due to delays in
r
elease of a
build into production

then a successful User Acceptance test result will be considered as
deliverable completion criteria.



PreludeSys has assumed a certain no of issues and defects that are to be addressed
based upon the SLA’s defined in the approach to Post Implementation and

has identified
resources accordingly.

2.14

Out of Scope

1.

Functionality that is not identified as part of Statement of Work will be considered a
change request or new proposal.

2.

Changes to any external applications or systems not identified as part of Statement o
f
Work is considered out of scope

3.

Preparations of User Acceptance Criteria and User Acceptance Test Plans or data are
not covered under this proposal.


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
35

4.

Maintenance and support of application after deployment into production is not included
as part of the p
roposal. However, PreludeSys will support the deployment activities and
the deployed application for two weeks from Go
-
Live as part of our standard application
development methodology and value add to clients.

5.

Setting up testing or production system is not considered in the proposal. We assume
that the
TLC

infrastructure team will be setting these up.

6.

Production data load and transformation is not included. However the application and
process built and delivere
d as part of this project will facilitate this activity but will be
executed by
TLC
team.


2.15

Cost Proposal

Based on the scope of work and detailed deliverables identified as part of the S
O
W, PreludeSys
estimates the value of the proposal cost is
$1
,9
19
,
825
.0
0

for providing the services.

2.16

Pricing Sheet

Deliverable
No

Deliverable Name

Price

%

Est
.

hours

1

Project Work Plan

$125
,
000.00

6.5

640

2a

Accounting
-

Documentation of
Business Processes

$10
0,
000.00

5.2

480

2b

Accounting


Documentation of
System
Requirements

$125
,
000.00

6.5

480

2c

Accounting
-

Semi
-
Functional
Prototype

$
60
,
000.00

3.1

800

2d

Accounting


Released to
Customer Acceptance Testing

$
75
,
000.00

3.9

1120

3a

Audit
-

Documentation of
Business Processes

$
8
5
,
000.00

4.4

480

3b

Audit


Documentation of System
Requirements

$
75
,
000.00

3.9

480

3c

Audit
-

Semi
-
Functional
Prototype

$
50,
000.00

2.6

800

3d

Audit


Released to Customer
Acceptance Testing

$
75
,
000.00

3.9

1120

4a

Licensing
-

Documentation of
Business Processes

$
75
,
000.00

3.9

480

4b

Licensing


Documentation of
System Requirements

$
75
,
000.00

3.9

480

4c

Licensing
-

Semi
-
Functional
Prototype

$
50,
000.00

2.6

800

4d

Licensing


Released to
Customer Acceptance Testing

$
75
,
000.00

3.9

1120


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
36

5a

Special Projects
-

Documentation
of
Business Processes

$75,000.00

3.9

480

5b

Special Projects


Documentation of System
Requirements

$75,000.00

3.9

480

5c

Special Projects
-

Semi
-
Functional Prototype

$
50,
000.00

2.6

800

5d

Special Projects


Released to
Customer Acceptance Testing

$
75
,
000.00

3.9

1120

6a

Online Module
-

Documentation
of Business Processes

$75,000.00

3.9

480

6b

Online Module


Documentation
of System Requirements

$75,000.00

3.9

480

6c

Online Module
-

Semi
-
Functional
Prototype

$50,000.00

2.6

800

6d

Online Module


Released to
Customer Acceptance Testing

$
75
,000.00

3.9

1120

7

Flowchart outline of Batch
Process.

$
75
,000.00

3.9

800

8

Conversion


Documentation

$50,000.00

2.6

800

9

Completed system including
conversion of existing data for
QA Testing

$
50
,000.00

2.6

960

10

Completed system including
conversion of existing data for
UAT Testing

$
50
,000.00

2.6

960

11

Implement system into TLC’s
Production environment

$
50
,000.00

2.6

640

12

6 months post implementation
support

$50,000.00

2.6

2000











Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
37

2.17

Pricing Sheet

for Hourly Rate

Staff Name / Title

Hourly Rate

Estimated
Number Of Hours

Project Manager

$
105
.00

1275

Lead Business Analyst

$95.00

2850

Enterprise Architect

$
1
10
.00

260

Lead Developer

$90.00

3450

Sr. Business Analyst

$85.00

2550

Sr. Developers

$85.00

7540

Database Administrator
/Sr.
Database Developer

$90.00

1930

Quality Assurance / Testers

$75.00

1930


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
38

3

Project Organization

3.1

Project
Engagement Model

PreludeSys has

a proven engagement model that has been used in similar projects and the
below figure demonstrates how we will engage with the
TLC.
We
will be able to make any
adjustments required to this model to cater to the standards and guidelines of
TLC.


3.2

Organization Chart

Specifically with respect to this SOW
, PreludeSys
proposes the following organization chart.



Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
39

3.3

Project Organization Plan

Phase

PreludeSys (No of Resources)

TLC

Project
Initiation



Director
-

Delivery



PreludeSys Project Manager



PreludeSys

Project Team



TLC Project Manager



TLC Project Team



Business Sponsors



Business Stakeholders

Analysis



PreludeSys

Project Manager



Enterprise Architect



Lead
Business Analyst



Senior Business Analyst



Lead Developer



TLC Project Manager



Project Lead



Tech SME’s



Business SME’s



Business Stake holders

Execute



PreludeSys

Project Manager



Lead
Business Analyst



Senior Business Analyst




Lead Developer



Senior Developers



Sr.
Database
Developer



TLC Project Manager



Project Lead



Tech SME’s



Business SME’s



Trading
Partner


Point of
contact

Testing



PreludeSys

Project Manager



Lead Business Analyst



Senior
Business Analyst



Quality Assurance



Lead Developer



Senior Developers



TLC Project Manager



Project Lead



Tech SME’s



Business SME’s



Trading Partner


Point of
contact



SIT Testers



UAT Testers

Pre
-
Deployment



PreludeSys
Project

Ma
n
ager



Lead Business Analyst



TLC Project Manager



Project Lead


Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
40



Senior
Business An
alyst



Quality Assurance



Lead Developer



Senior Developers



Database Administrator



Tech SME’s



Business SME’s



Trading
Partner


Point of
contact

Project
closure



Director
-

Delivery



PreludeSys
Project Manager



Project Manager



Business Sponsor
s


3.4

Roles and Responsibilities Matrix

The below table demonstrates the roles, individuals and their responsibilities.

Role

Individual

Responsibility

Steering
Committee

Vijay Viswanathan,
Craig Oliver



Pr潪散t C潯r摩湡ti潮 慮d S畢 C潮tr慣a
M慮慧敭敮e



S灯湳nr m敥tings



E獣慬慴楯渠慮搠剩sk Mitigati潮

Pr潪散t M慮慧敲

C桡湤ilv敬 C.
Si湧慲慶敬u



C潯r摩湡ti潮 wit栠
T䱃
Pr潪散t M慮慧er



Weekly
Stat畳 R数潲o猠a湤 m敥ti湧s



Pr潪散t Pl慮 潷湥r, m慮慧敳 摥liv敲e

E湴敲灲楳p
Ar捨ct散e

䩡J慲慭慮
P慬慮i慰灡n



Ow湳⁁灰li捡瑩c渠䅲捨nte捴畲u 慮搠䑥獩gn



Ow湳⁆n慭敷潲k

䱥慤L
B畳u湥獳s
A湡ly獴

Y潧敳e K慴a



SME 慮搠捯潲摩湡te猠䩁D 獥獳s潮献



C潯r摩湡t攠eit栠
T䱃
stake 桯l摥r ar敡s

to g慴桥r
req畩r敭敮ts 慮搠d慬i摡t攠摥f散ts.



C潯r摩湡t攠獹獴em猠慮慬y獩猠慮搠摥獩gn



Ow渠䉵獩湥獳sPr潣o獳 D潣om敮t 慮搠卯ftw慲攠
R敱畩rem敮ts S灥捩fi捡瑩潮 D潣om敮t



C潯r摩湡t敳eQA T敳t 慮搠啁T

B畳u湥獳s A湡ly獴
/ Q
畡lity
Priy愠
P慤m慮慢桡n



C潯r摩湡t攠eit栠
T䱃
stake 桯l摥r

ar敡s to g慴桥r
req畩r敭敮ts 慮搠d慬i摡t攠摥f散ts 慮搠

Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
41

Assurance

enhancements



Owns STP

Lead Developer

Bhaskar Kumar



Coordinate and Lead the Technical Teams



Coordinates
Coding

and Code review



Coordinates and Supports

Test
ing



Owns Application and Database Architecture and
Design

Senior
Developers

Srinivasaraju Datla
Ashokkumar

Subramanian

Deepan Rajkumar



Coding and Unit Testing



Support Development Integration, QA and User
Acceptance Test

Sr. Database
Developer

Rajesh
Gurram



Own Database Architecture



Responsible for Database creation and update
activities



Responsible for Conversion


3.5

Communication Plan

PreludeSys is responsible to assign a PreludeSys Project Manager to work closely with the
TLC
Project Manager through the duration of the engagement effort and will collaborate on the
specific project deliverables.
PreludeSys Project Manager is responsible for the collection and
distribution of information to project stakeholders in a timely manner
.
TLC
Project Manager is
the single point of contact for
PreludeSys

for all related risks, issues, escalation and status
report updates.

A large part of the responsibility during execution is keeping the stakeholders informed of
project status. Joint proje
ct reviews are a good way to bring visibility to all areas of the project.
They provide an opportunity to discuss important issues and make management decisions on
the project with input from several sources.
Joint project reviews would involve
PreludeSys

Project Manager, project team members, project stakeholders, and agency management
depending on the issues being discussed.

PreludeSys will be responsible for conducting weekly status meetings with the
TLC
Project
Manager by e
-
mail, and/or
in person
.






Texas Lottery Commission

Charitable Bingo Operations Division System (RQ13
-
1237)

Page |
42

The frequency and topics covered at these meetings
are

outlined in the Communications Plan.

Description

Audience

Frequency

Owner

Weekly
Status Meeting

PreludeSys Project Team &
TLC Project Team

Weekly

PreludeSys Project
Manager

Executive Sponsor Meeting

Steering Committee Members
and TLC Sponsors and TLC
Project Manager

Bi
-
weekly

/

Monthly

PreludeSys Project
Manager

Change
Management
Meeting

PreludeSys Project Team &
Change Management Board

Monthly