Proposal To South Coast Air Quality Management District

flutheronioneyedΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 4 χρόνια και 20 μέρες)

480 εμφανίσεις

Proposal

To

South Coast Air Quality Management District


For

Motor Vehicle Emission Reduction System

e
-
MOVERS Web Application New System Development

By


PreludeSys

Vendor Name

Prelude Systems, Inc.

Proposal Submitted by

Andrew Yoshikawa

Contact Details

Telephone number: 949
-
390
-
5482

Mobile: 714
-
329
-
6981

Fax number: 909
-
801
-
2369

Email:
ayoshikawa@preludesys.com

Date of Submission

September 1
0
, 2013

Signature



Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
2

of
82

Table of Contents

Table of Contents

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

2

Letter of Submittal

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

3

Project Pl
an

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

5

1.1

Objective Statement

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

5

1.2

Statement of Work

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

5

1.2.1

Scope of Work

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

5

1.2.2

Activities in Scope

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

8

1.2.3

Out of Scope

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

1.2.4

Assumptions

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

1.2.5

List

of Deliverables

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

1.4

Resources

................................
................................
................................
.................
13

1.4.1

Roles and Responsibilities Matrix

................................
................................
.......
13

1.6

Total Project Cost Estimates

................................
................................
.....................
15

1.6.1

Cost Schedule

................................
................................
................................
....
15

1.6.2

Payment Schedule

................................
................................
.............................
20

1.7

Microsoft Project Plan

................................
................................
................................
21

1.8

Execution Methodology

................................
................................
.............................
22

Te
chnical Specifications

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

1.9

Proposed Approach

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

1.10

Benefits of Proposed Approach

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

1.11

Inadequacies the proposed approach will

correct

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

1.12

Project Risks

................................
................................
................................
.............
30

1.13

Proposed Technical Architecture

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

1.14

Resumes

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

1.14.1

SelvaPandian


Project Manager

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

1.14.2

Senthilkumar M


Sr.System Analyst

................................
................................
..
36

1.14.3

Ganesh Chinnasamy

-

Sr. Programmer

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

1.14.4

Amithabh Kandpal

-

Sr. Programmer

................................
................................
..
54

1.14.5

Gourav Poddar

-

Sr. Programmer

................................
................................
......
64

1.14.6

Nawaz Mohammed



Tester
................................
................................
...............
73

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
3

of
82


Letter of Submittal

Irvine, CA

Aug 28
, 201
3

To:

Procurement Unit

South Coast Air Quality Management District

21865 Copley Drive

Diamond Bar, CA 91765
-
4178

(909) 396
-
3520


Sub: Response to RFP for “
Task Order Number IM25
-
13

-

e
-
MOVERS

Web Application New
System Development
Work
for South Coast Air Quality Management District

(
SC
AQMD
)
.


Dear Sir/Madam,

Prelude Systems, Inc. (alias PreludeSys) is pleased to provide this proposal in response to the
RFP for providing
e
-
MOVERS

Web Application New System Development

The services

described in this document are our core competencies as we bring years of
experience and
a
world class personnel support structure that can provide

South Coast Air
Quality Management District(hereinafter referred as “
SCAQMD
”)

with greater efficiency,
incr
eased flexibility and a commitment to continuous improvement. We believe that our
strengths in the area of
Web Application

will bring value and a competitive advantage to
SCAQMD
.


Following are the details as requested in the RFP:

Agency

Name:

Prelude Systems Inc

Headquarters Address:

5 Corporate Park #140

Irvine, CA 92606

Telephone Number
:
949
-
390
-
5482

Fax Number
:
909
-
801
-
2369

Email Address:
ayoshikawa@preludesys.com

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
4

of
82

Authorized Person

Name:



Andrew Yoshikawa

Title:



Business

Development Executive

Telephone Number
:
949
-
390
-
5482




The above mentioned management representative has complete authority to represent,
negotiate and execute the contract on behalf of Prelude Systems, Inc. In
the event of any
replacement
SCAQMD

will be duly notified.

We thank
SCAQMD

for providin
g this opportunity to submit a

proposal.



Yours sincerely,



Andrew Yoshikawa

Business Development Executive

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
5

of
82

Project Plan

1.1

Objective Statement

MSETS which is
SC
AQMD
’s

current Client
-
Server system was built over 12 years ago. It was
developed to support the Vehicle Mitigation Options programs. The MSETS program currently
serves all of its intended purposes
. Ho
wever there are many areas where improvements are
required.

SC
AQMD

has
hence
decided to develop a new web application which would allow it to move
from paper s
ubmission to online submission
and
where
checks would be replaced by online
payment. The expectation is to improve the efficiency of the enti
re process.
SC
AQ
MD

had
requested PreludeSys for a proposal for the development of
Motor Vehicle Emission Reduction
System

hereafter referred to as
e
-
MOVERS Web Application
.

T
he Business objective is to build and
impl
e
ment

the Electronic
-
Motor
-
Vehicles Emission
Reduction System (e
-
MoVERS) Web Application

Using the Agile application lifec
ycle methods
and best practices
.

The Statement of Work which was received from
SC
AQMD

states the expectations on the
methodology to be foll
owed and on
the
deliverables. PreludeSys has
a
rich experience in
following
agile

project management and, in developing web applications using the right
technology.

PreludeSys is delighted to submit this proposal for the development of the
above said
web

application
.

1.2

Statement of Work


1.2.1

Scope of Work

The vision of this project is to build the e
-
MoVERS Web Application
,

which will allow regulated
facilities to use the internet to submit their Emission Reduction Programs as required by
District’s Rule 2202, a
nd to

pay their fees and invoices on
line. In addition, the new application
will be used internally by the
SC
AQMD
’s Transportation staff to process the submitted
programs and to administer all associated tasks and procedures.

Main Features

The main compone
nts of the e
-
MoVERS Web Application are:



Site Information


Worksite details, Address, Contact information



Registration Information


Year
-
based Registration details



Event Information


All Events related to the Registration.



Finance Information


Fees,
Invoice and Payment details.



Administration


Business Processes & Functions.



Emission Bank


Emission Credit Transaction details.



AVR survey


All Survey related details.



Marketing Strategies


Strategies implemented by worksites
.




Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
6

of
82


Security

Authentication and Authorization:

Integrate with
SC
AQMD
’s Claims based Authorization system to provide Authentication and
Authorization. This security will have to be implemented for Web Services/WEB API’s that will
be built as part of this application.


S
ubmission on the Web

The following requirements shall be integrated within the new e
-
MoVERS Web Application:

All registrations (AQIP, ERS, ECRP, and OFST) shall be submitted over the web by registered
users designated by the Employers. Each registration s
hall have its own set of forms and
calculations.


Employers shall have the ability to submit Registrations for both Single
-
sites and Multi
-
sites.

The e
-
MoVERS Web Application shall perform a series of checks to see if the User is allowed
to submit. This s
hall include checks
such as
, but not limited to, due date, fees, previous
registrations, etc.


All data from the forms shall be saved
in

the District’s DBCIR database. The payments shall
be calculated
,

an invoice shall be generated

and the
fee payment sha
ll be made online

using
existing Web Services
.


The summary forms
wi
ll be moved to OnBase Document Management System upon
submission using DMS web services. After submission, if there is a change to the submitted
registration, the changes
will

be saved as

a new revision in OnBase.


The employer

will

have the ability to upload documents using the existing
Upload

Web
Service.


The application
will

be integrated with the existing Notification web service.


Administrative Procedures

Exemption Request:

Employer: Request Exemption based on various reasons.

SC
AQMD

Staff: Exemption request is sent to Registration Reviewer who reviews and sends it
to the Supervisor to Grant or Deny. The employer is notified by email of the decision made and
when
related act
ions such as Event save, Onbase upload take place.

Due Date Change/Extension:

Employer: Request Extension.

SC
AQMD

Staff: Extension request is sent to Registration Reviewer who reviews it and sends it
to the Supervisor to Grant or Deny. The employer is not
ified by email of the decision made and
when
related actions such as Event save, OnBase upload take place.

Information Change:

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
7

of
82

Employer: Can change MSETS related site information.

SC
AQMD

Staff: Office Assistants change site related information when a reque
st is received.

Change of Ownership:

Employer: Submit change of ownership.

SC
AQMD

Staff: Work with Permit Services to request change.

Declare Bankruptcy:

Employer: Declare bankruptcy.

SC
AQMD

Staff: The supervisor sets the site to bankruptcy for a period of

two years.

Site Inactivation:

Employer: Requests site inactivation.

SC
AQMD

Staff: The supervisor inactivates the site.

Program Change:

Employer: Requests Program Change before Approval/Disapproval.

SC
AQMD

Staff: The supervisor changes program after review

and all data from the existing
plan is removed.

Administrative Functions

Plan Review:

The submitted registrations will be reviewed by the Registration Reviewer. The Reviewer will
recommend Approval or Disapproval and forward the plan to the

Supervisor:

The Supervisor can approve all registrations but the registrations recommended for disapproval
will be forwarded to the Manager. Once the registration is approved, the approval will be
emailed to the employer. The Employers whose plans are recommended fo
r disapproval will
also be notified by email with the reasons for their disapproval.

Multi
-
sites:

Plans can be submitted as either Single or Multi
-
Site if the employer has more than one site.
Not all sites of an Employer need to belong to a single multis
ite. The sites can be split into
multiple multi
-
sites or multi
-
sites and single sites or all single sites. The employer can choose
to change this from year to year. The
SC
AQMD

staff should have the ability to create Multi
-
Sites, and add/remove sites fro
m a Multi
-
Site.

Emission Bank:

Ability to add emission credits to sites and also process transactions between credit vendors
and regulated sites. The system needs to check the validity and expiration of the credits
transferred.

Revision:

Once a plan has

been submitted, all changes will be submitted to
SC
AQMD

and the changes
will be done by
SC
AQMD

staff. These changes will need to be tracked as revisions in OnBase.

Amendment:

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
8

of
82

When a plan has been approved, the employer may choose to amend the plan and resubmit a
new plan. The system should be able to handle such a plan change.

Maintenance:

Most of the maintenance
types
listed below relate to lookups.



Source Receptor Area



Perfo
rmance Target zone



Disapproval Reasons



Exemption Reasons



Event related maintenance



Strategy Type



Program Type



ECRP related Maintenance



ERS related Maintenance



Strategy Type



Program Type

Reports:

The system would give the ability to generate
the below
reports, print and email them.



Summary Status Report



Finance Memorandum



Emission Bank Reports



Miscellaneous Reports

1.2.2

Activities in Scope

1.2.2.1

Project Management Activities

The Agile PM can be better understood as a unique professional with a very particular set
of
skills that allows him to own part the responsibilities of two or more roles at the same time, as
needed. Considering
several factors like Cost control, Availability of detailed requirements,
SC
AQMD
’s continuous participation during the project, Prelu
de
Sys feels that the PM can play

a role of BA and also of Scrum Master.

The
identified

PM
will use

project management
expertise
to play both roles
, filling in the gaps while always aiming for the best outcome for the
project and walking the extra mile.

PM be
ing the Scrum Master as well is typically viewed as the Agile Process Owner, who will
make sure the team is using the Scrum and Agile frameworks correctly.

Activities
for which
the A
gile PM will be responsible
are

given below
:

Iteration planning meetings:

Agile PMorganizes and run
s

the iteration

planning meeting at the beginning of each iteration to
identify the stories that will be developed, and to break each of them down into specific
technical tasks and acceptance criteria. Iteration planning
meetings
generally last f
or

2
-
4

hours,
depending on the length of the iteration. The longer the iteration, the more time needed to plan
its details. The result is an iteration backlog of stories, defects, tasks, and acceptance tests.
Ideally, each iteration
will
have a

specified goal
which
the team
will attempt

to achieve.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
9

of
82

Daily Standup meetings:

Agile development processes depend on a high level of communication and collaboration for
success. This is no truer than in the daily standup meeting that occurs during a
n iteration. This
meeting is an opportunity for teams to communicate what they've done, what they are
committing to the team to do next, and any issues that are causing them or may cause the
team to be less effective.

It is the responsibility of the Agil
e PM to deal with any impediments as quickly as possible.

The daily standup
meeting
will

be held every day at the same time in order to ensure a reliable
rhythm. Daily stand
-
ups are time
-
boxed
and set such that they do not

exceed 15 minutes.

Preparation o
f burn down charts:

Sprin
t burn
-
down

charts are used to track progress in sprints. Burn down charts can show (1)
whether the team is committing to more work than they can perform (2) whether the team is
taking more time to complete than what it should tak
e. It is Agile PMs responsibility to help the
team see the issues and get them fixed so th
at th
e team can get on its way to being high
performing.

Change control monitoring:

B
usiness requirements are in a constant state of flux to stay current with their
needs.

L
arger
the

project and longer the duration, greater the number of changes
one

should expect.

Getting
requirement changes is after all not bad. Only uncontrolled change is bad.
Uncontrolled
change means that new requirements are allowed to come into
the project with no formal
process for analyzing the requirement and accepting / rejecting it.

It is important to identify the
new
requirements that are

getting added to the project.
Reprioritize the requirements that
would

get addressed in the following S
print. To track these items
,

Change Log templates will
be used.

1.2.2.2

Detail Work plan Development

An integrated project plan will be developed (extending the plan attached in this proposal),
which will help in envisioning how the project will run through the c
ycle. The project plan would
be primarily done by the Agile PM. He will be taking inputs from the team members so that
accuracy and efficiency is

ensured. A product backlog and user stories will be arrived at based
on the prioritization in consultation
with the SCAQMD (product owner). User stories
prioritization will be done by following the approach of ‘
Must have'
,
'Should have'

and
'Could
Have'.

Team availability calculation would be done considering various factors including
providing for non
-
productive hours. A release plan will be created by breaking down the whole
release in terms of Sprints. Each of these iterations has an associated iterat
ion schedule to
track it closely. Key dates
of deliverables are made part of the plan. This finalized work plan,
user stories, product backlog and release plan will be published to all project stakeholders.

1.2.2.3

Software Requirement Iteration Planning

Iteratio
n planning is a refinement of the level of detail and adjustment of the initial plans
derived. Various inputs go into the Iteration planning such as: product backlogs, user stories
Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
10

of
82

arrived during the work plan development sessions, prior feedback and proje
ct objectives.
During iteration planning, the tasks will be further broken down at a granular level and use
cases if applicable. Iteration planning helps to adapt better as the project and requirements
unfold. This leads to a robust design that is aligne
d to address the requirements.

1.2.2.4

Functional Design

Functional design in an Agile methodology brings in better clarity and helps in visualizing the
end solution better. The detailed functional specifications will be documented and these specs
will be transf
ormed into diagrams and wire frames to understand the nuances involved. These
also help in making complex interfaces tangible, assessable and optimizable. Sprints are tightly
timed and usability is easily overlooked or considered only in passing. This prob
lem can be
solved by an asynchronous design, creating unit test design, database design and regular
reviews.

1.2.2.5

Build and Test

During a Sprint, multiple tasks will be conducted. The key phase is the

Build /
Development
phase
, also known as the

Sprint
. Sprint

is an iterative cycle


that stops when certain
requirements are completed, such as quality and functionality. Key activities that will be
performed are development, testing by the tester and testing by the user in comparison with
the acceptance criteria
, and implementation of changes.


Agile development and frameworks like Scrum and extreme programming are in support of
continuous integration testing. These frameworks, where adopted, are not known to be
uncertain and ambiguous. Agile project testing has
gone from verification and validation to
being a way of building quality into a product. This is largely because testing has become a
central practice and is integral to the development process, rather than coming after
development. SCAQMD will have to dev
elop the acceptance criteria, i.e., the expected actual
or expected validation criteria. The tester will verify every feature in the user story so as to
meet the validation criteria.

1.2.2.6

Documentation

Scrum methodology does not offer documenting everything, bu
t this does not mean "no
documentation". System documentation as per an agreed template will be created and this will
be provided to the stakeholders.


1.2.3

Out of Scope

1.

Migration of existing web services for payment

and invoicing are not considered as part
of
the scope.

2.

Migration of OnBase document management system web services is not part of the
scope.

3.

Integration of a
ny
other
third
-
party tool/application
not mentioned in the SOW is
considered as out of scope for this fixed duration/fixed cost project

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
11

of
82

4.

Setting

up of infrastructure will be
SCAQMD
’s responsibility and considered as out of
scope for PreludeSys

5.

PreludeSys can provide support and maintenance for this solution. But this proposal
costing does not include solution support and/or maintenance
.


1.2.4

Assumpti
ons


1.

Client would be sharing the existing system for requiremen
ts and

analysis
.

2.

MS Windows Server 2008 R2 would be the hosting infrastructure at
SCAQMD
.

3.

SCAQMD

will provide the technical environments for te
sting, & deployment activities.

4.

The Project
Manager will be the

person responsible for i
nteractions with
SCAQMD
,
stakeholders and users.

5.

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

SCAQMD

6.

The website will run in Microsoft windows environment/OS.

7.

We

assume
‘Miscellaneou
s reports’

to contain no more than 4 reports.

8.

As per the response to the Q&A, it is understood that there will
be a
total

of 3000
users
and 200 concurrent users
.

1.2.5

List of Deliverables

Tasks

Deliverables

Task 1:

Detail Work Plan
Development



Integrated
Project Plan and Schedule including
MPP



Product Backlog and Release Plan



Team Foundation Server (TFS) Entry:

o

User Stories

o

Project Task List.

Task 2: Software
Requirement
Specifications



TFS View
of

o

Clarified
and updated
User Stories

o

Logical Database
Design

o

Software Release (Iteration Backlog)
Definition

o

Iteration plan 1 through 4

o

Minutes of meeting

Task 3: Functional
Design



Workflow diagram



UI Wire Frames



Unit Tests



Database Design including ERWin Data Model



Change control logs

Task 4:
Build and
Test



Software Release(s)



Test Results Release



Repurposed Software Release(s)

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
12

of
82



B畲渠摯w渠捨慲ts



Change control logs

Task 5
:
Documentation



O灥rati潮猠G畩摥



Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
13

of
82

1.4

Resources

1.4.1

Roles and Responsibilities Matrix

The below table demonstrates the roles, individuals
identified for the roles and their
responsibilitie
s. The substitution of Project M
anager or Lead Personnel will be done
only
after
the written consent of
SC
AQMD
.

The below mentioned resources have been identified for this project. Every attempt will be
made to retain them for this project. For any reason, if the identified resource is not available, a
similar experienced resource with equivalent capability will be allocated.

Role

Individual

Responsibility

Steering
Committee




Pr潪散t C潯r摩湡ti潮 慮d S畢

C潮tr慣a M慮慧敭敮t



S灯湳nr m敥tings



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

Project
Manager

SelvaPandian



Iter慴楯渠灬慮湩ng m敥tings



D慩ly St慮搠啰 m敥tings



T䙓 Pr潪e捴 U灤慴敳



B畲渠摯w渠捨慲t猠慮d 獴慴畳a異摡t敳



C桡湧攠捯ctr潬 m潮it潲o湧

/ l潧ging



S灲楮t
r整r潳o散瑩e攠e敥ti湧s



S畢j散e M慴a敲e數灥rt (SME)



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



R敳e潮獩扬攠f潲 SRS
, O灥r慴楯湳ng畩摥



C潯r摩湡t攠eit栠

AQMD
’s stake holder areas to
gat桥r req畩rem敮t猠慮d v慬i摡t攠獴rategy



T敳t Pl慮湩湧 慮d C潯rdi湡ti潮



S潦ow慲a

R敬敡獥⡳)



R数畲灯獥u Softw慲攠R敬敡獥
.

Sr. Systems
Analyst


Senthilkumar
M



T散e湩捡c m慴t敲 數灥rt



Workfl潷 摩慧r慭 灲数pr慴楯渠(UM䰠摩慧r慭猩



HTM䰠䑥獩g湥r 灲数pre搠慮湯tat敤 wir攠fr慭a猠
i湣nr灯r慴楮朠啉gl潯欬 f敥l 慮搠扥桡vi潲



P桹獩捡c 摡t慢慳a
摥獩杮

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
14

of
82



䱯gi捡c 摡t慢慳a 摥獩gn



D敶敬潰m敮t of m潤畬敳



I湴n杲慴i潮 t敳ti湧

Sr.
Programmer
s

Ganesh
Chinnasamy


Amitabh


Kandpal


Gourav

Poddar



G敮敲et攠獯er捥 捯c攠e湤 數散et慢le



U湩t T敳瑩eg



T敳t R敳elt猠R敬敡獥

Tester

Nawaz
Mohammed



S灲楮t l敶敬 t敳瑩eg



I湴n杲慴i潮 t敳ti湧



Sy獴敭ete獴ing



P畢li獨⁴敳e r敳elts

T桥 R敳em敳e慲攠att慣a敤 i渠
Section 1.14
: Resumes

of this proposal.
The estimated number
of Labor Hours is given in
Section
1
.
6
.
1

Total Project Cost Estimates.


1.6

Total Project Cost Estimates

1.6.1

Cost Schedule

Tasks and

Deliverables

Start Date

Due

Date

Estimated Hours

Estimated Cost

(USD)

Task 1:
Detail Work Plan Development

Deliverable(s)

1.

Integrated Project Plan and Schedule MPP

2.

Product Backlog and Release Plan

3.

TFS Entry(s)

September 30,
2013

October 30, 2013

104 hours

$10,400

Task 2: Software Requirement Iteration Planning

Deliverable(s)

1.

Clarified User Stories

2.

Logical Database Design

3.

Software Release Plan 1 thru n

October 7, 2013

November 5,
2013

152 hours

$14,4
80

Task 3: Functional Design

Deliverable(s)

1.

UI Wire Frames

2.

Unit Tests

3.

Database Design/ERWin Data Model

October 17
, 2013

November
14
,
2013

344 hours

$27,76
0

Task 4: Build and Test

Deliverable(s)

1.

Software Release(s)

2.

Test Results Release

3.

Repurposed Software Release(s)

October 31, 2013

March 7
, 2014

2576 hours

$212
,
800

Task 5: Documentation

Deliverable(s)

1.

Operations Guide

January 22
,
2014

January 28
, 2014

40 hours

$4000

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
16

of
82

TOTAL





3216

hours

$2
6
9,
440



LABOR CATEGORY


Task
s


Hours

Hourly

Rate

Total

Cost

Project Manager

Integrated Project Plan and
Schedule MPP

Clarified User Stories

Deliverable: System
documentation

Product Backlog
and Release
Plan

Team Foundation Server (TFS)
Entry: User Stories and Project
Task List.

Sprint 1 tracking and meetings

Sprint 2 tracking and meetings

Sprint 3 tracking and meetings

Sprint 4 tracking and meetings

424 hours

$100

$42,400

Sr. Systems Analyst

Logical Database Design

Incorporate review feedback
-
Task
2

Workflow and functional
specifications

Database Design including ERWin
Data Model

Incorporate review feedback
-
Task
808 hours

$90

$
72
,
720

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
1
7

of
82

3

Integration Testing and Fixing
Sprint 1

AQIP Form Registration
-

Development

EC
RP Form Registration
-

Development

Eligibility Testing for Submission
-

Development

Integration with the Existing
Payment Web Service
-

Development

Integration Testing and Fixing


p灲楮t O

f湴n杲慴i潮 q敳ting 慮d ci硩湧


p灲楮t P

o敶isi潮 慮搠楴猠
tracki湧 wit栠
l湂慳a
J

a敶敬潰m敮t.

j慲a整楮朠却r慴agi敳
J

a敶敬潰m敮t

o数潲os
J

p畭m慲a ptat畳⁒u灯rt

f湴n杲慴i潮 q敳ting 慮d ci硩湧


p灲楮t Q

py獴敭eq敳ti湧 慮搠䙩x敳

a数l潹m敮t

r獥爠A捣数t慮捥cqe獴ing

a数l潹m敮t 慮搠剥view

pr. mr
ogramm敲



1

rf tire 䙲cm敳
J

m慲t 1

A畴桥湴楣uti潮 L A畴桯uiz慴楯n

bv敮t a整慩ls

f湴n杲慴i潮 q敳ting 慮d ci硩湧

㜳㘠桯畲S

␸A

A

I
㠸U

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
18

of
82

Exemption Request Form and
Workflow

Information Change and Workflow

Declare Bankruptcy and Workflow

Program Change and WorkFlow

Sprint 3
Testing and Fixing

Database migration

System Testing and Fixes

User Acceptance Testing support

Sr. Programmer



O

rf tire 䙲cm敳
J

m慲t O

pit攠enf潲m慴楯n

tor歆k潷 j潤ule

p灲楮t 1 q敳瑩eg 慮搠䙩xi湧

a略 a慴攠C桡ngeLbxt敮獩潮 慮搠
torkfl潷

C桡湧攠ef lw湥r獨s瀠慮搠
torkfl潷

pit攠e湡ctiv慴楯渠慮搠tork䙬潷

A摤i湧 or j潤ifyi湧 bmi獳s潮
Cr敤its

f湴n杲慴i潮 q敳ting 慮d ci硩湧

a慴慢慳a mi杲慴i潮

py獴敭eq敳ti湧 慮搠䙩x敳

㌷㘠桯畲S

␸A

␳〬〸M

pr. mrogramm敲



P

bop 䙯rm oegi獴rati潮

l䙓q
䙯rm oegi獴rati潮

f湴n杲慴i潮 wit栠h桥 數i獴i湧
f湶潩捩湧 teb p敲ei捥

f湴n杲慴i潮 wit栠h桥 l湂慳a
a潣om敮t j慮慧敭敮t py獴敭e
f潲 t桥 p畭m慲a 䙯rms

f湴n杲慴i潮 wit栠䕸i獴i湧 r灬潡搠
㐳㈠桯畲O

␸A

␳㐬㔶Q

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
19

of
82

Web Service

Integration with the existing
Notification Web Service

Sprint 2
Testing and Fixing

Integration Testing and Fixing

AVR Survey

Master Tables C.R.U.D

Reports
-

Finance Memorandum

Reports
-

Emission Bank Reports

Reports
-

Miscellaneous Reports

Integration Testing and Fixing

Tester

Unit Tests design

Sprint 1 Testing and Fixing

Integration Testing and Fixing

Sprint 2 Testing and Fixing

Sprint 3 Testing and Fixing

Sprint 4 Testing and Fixing

System Testing and Fixes

440 hours

$70

$
30
,
800


TOTAL


3216

hours


$269,440


Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
20

of
82

1.6.2

Payment Schedule

Tasks and
Deliverables

Start Date

Due Date

Cost

10% Withhold

Invoice
Amount

Task 1: Detail Work Plan Development

Deliverable(s)

1.

Integrated Project Plan and Schedule
(MPP)

2.

Product Backlog and Release Plan

3.

TFS Entry(s)

September 30,
2013

October 30,
2013

$10,400

$1,040

$9,360

Task 2: Software Requirement Iteration
Planning

Deliverable(s)

1.

Clarified User Stories

2.

Logical Database Design

3.

Software Release Plan

October 7,
2013

November 5,
2013

$14,4
80

$1,44
8

$
13,03
2

Task 3: Functional Design

Deliverable(s)

UI Wire
Frames

Unit Tests

Database Design/ERWin Data Model

October
17
,
2013

November 14
,
2013

$
27,76
0

$
2,776

$
24,984

Task 4: Build and Test

Deliverable(s)

1.

Software Release(s)

2.

Test Results Release

3.

Repurposed

S
oftwareRelease(s)

October 31,
2013

March 7
, 2014

$
212
,
800

$
21
,
280

$191
,
520

Task 5: Documentation

Deliverable(s)

Operations Guide

January 22
,
2014

January 28
,
2014

$4
,
000

$400

$3,600

TOTAL



$2
69,440

$26,944

$242,49
6

1.7

Microsoft Project Plan


1.8

Execution
Methodology

Agile Scrum

We practice agile SCRUM methodology and use the iterative agile development framework for
managing software projects and application development. This is a process in which by
regularly apply a set of best practices for working col
laboratively and in teams to get the best
result possible. We implement SCRUM because it is a versatile project management process
that works best for adapting to abrupt changes in current business needs and trends.


Scrum model, partial deliveries are ma
de regular final product, prioritized by the benefit they
provide to the customer. Scrum is ideally suited for projects in complex environments where
the need to get results sooner, where requirements are changing or poorly defined, where
innovation, compe
titiveness, flexibility and productivity are critical.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
23

of
82

Technical Specifications

Preludesys

would provide the client with
Electronic
-
Motor
-
Vehicles Emission Reduction
System (
e
-
MoVERS
)
Web Application
.
e
-
MoVERS

shall fully
incorporate

the entire business
process of the current MSETS application along with
features
outlined
.

1.9

Proposed Approach

PreludeSys proposes using the following technologies f
or the various layers that meet

the
Application Architecture Standards:



Presentation
: Microsoft ASP.Net
MVC
4.0

Framework
, Ext
.NET MVC



Database
:
Ingres



Application
/
WebServer
: IIS 6.0 or above



WindowsCommunicationFoundation

/
WebServices



Platform
: Windows Server 2008 R2(Assumption)



Development tool
:

Visual Studio 2012

The various modules in this web application are

Login

Authentication

The E
mplo
yers / C
ompany representatives and the
SC
AQMD

administrators would be able to
login through this application.
The login information will be authenticated using Claims
-
based
Authentication mechanism, which is expected to be available when the e
-
MoVERS application
is ready to be moved to production.

Claims
-
based authentication provides an industry standard security

protocol to authent
icate a
user.
Claims
-
based authentication requires the availability of a security token service (STS)
running on a server.

Authorization

After authenticating, the user
(
s
)

role will be fed back to the application. The role of the user wi
ll
determine the subsequent flow of the application for the user.

The various users of the application and their responsibilities are

User

Responsibilities

Administrator

Validate all

request
s, handle all

administrative
functionalit
ies

Supervisor

Grant/Deny the requests raised by the
employer, Validate and Verify the requests

Registration Reviewer

Review the requests and recommend

Manager

Review the denied registration plan from
the
Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
24

of
82

Supervisor

SCAQMD

office assistant

MSETS related site informati
on

Employer

Can place various requests, place registration
plan etc.


Site Information and Event Details

The

employer

/ company representative

would be able to store, retrieve and modify thesite and
event details for the site(s) he
/she

is responsible for.

The user inte
rface provided would be with
Ext
.NET
.
Ext.NET
is a component framework built
with
ASP.NET and

Sencha Ext JS
, the
JavaScript Framework for Rich Desktop Applications
.
Ext JS helps to build applications using MVC architecture
. MVC leverages the features like Big
Data Grids enabling an entirely new level of interactivity in Web applications.

It provides with an asynchronous communication with the server
,

which gives a high
performance and intuitive user interface. The web pages would feel like a client application in
its performance and style of components.


Registration Forms:

The below mentioned forms are currently being filled
out
manually by t
he Empl
oyers
/
Company representatives

and entered manually by the
SCAQMD

administrators
.



Air Quality Investment Program (AQIP) Option



Emission/Trip Reduction Strategies
(ERS)
Option



Employee Commute Reduction Program (ECRP) Option



OFST Form



Average Vehicle Rid
ership Survey Form

Form filling is a cumbersome process, be it manual paper base
d filling
,

excel based filling
,

or
PDF based filling.

To provide a better user experience, e
-
MoVERS will be designed in such a way that the
necessary data for filling

out
the
forms will be collected from the users through a wizard based
entry mode. Ext JS

provides

classes
, which is commonly used for Wizards and Tab
implementations. For implementing the above forms through Wizard mode, the above given
class will be extended.

Ea
ch of the registration form
s

would
have

its

own calculations
. These calculation parameters
will be configurable by the administrator of the application. Thereby any changes to the
calculation in the future will not have to go through the application progr
ammer’s desk.

e
-
MoVERS application is expected to perform a series of checks to see whether the Users are
allowed to submit the forms. The series of checks that are needed will be configurable by the
Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
25

of
82

Administrator thus providing the flexibility to the bus
iness to add various checks when they find
it relevant.

The data from the form will be
saved to the District’s DBCIR database. Calculation of payment
will be done by passing the relevant data to the existing
Payment
Web S
ervices. The invoice
generation wi
ll be done by passing the relevant data to the
existing
Web Services. Payment
Gateway for paying fees online is already set and e
-
MoVERS need to be integrated to the
Payment Gateway.

The registration forms are
expected to be
taken through a series of work
flow
(at least 4)
as per
the requirement after which the submission might get approved or rejected.

The workflow
configuration interface will be provided for the Administrators of the system to set the hierarchy
based on the user roles for each of the for
ms. Since the workflow process is going to be
developed as a configurable interface, any changes to the workflow process will not need the
application programmer to make any changes to the application.

The system would be integrated with the existing OnBa
se Document Management System
which would store the
summarized version of the submitted form
.

Any change to the form will
be added as another version in the OnBase DMS.

Existing notification Web S
ervices would be used for any email or other forms of notifi
cations to
the users.

e
-
MoVERS will have a

provision for the employers to upload documents using the read
i
ly
available Upload Web Service.


Administrative Procedures and Functions

Administrative Functions

e
-
MoVERS is expected to support various Administrat
ive functions and
procedures. It will
include plan Review, a
pprovin
g or disapproving plans, c
reat
ing

multi
-
site
s
, add
ing

or remov
ing
sites from multisite, a
dd
ing

emission credits to site, process
ing

tr
ansaction between emitted
sites,
cre
dit
ing

vendors and regulated sites,
a
mendment of a plan
, and grant
ing

or deny
ing

various requests from the employer.

The
SCAQMD

administrators would be able to perform various functions and procedures
according to the user role.

e
-
MoVERS is expected to support a

series of work flow as per the request. Once a registration
is submitted by the employer, the
SCAQMD

staff


Registration Reviewer

-

should be reviewing
the plan and he/she can recommend it for approval or disapproval. The next level of work flow
will be
performed by a supervisor
-

he should be able to approve or disapprove the registration
plan. The disapproved registration plan should be sent to

the manager who is in charge. The
e
mployer will be notified via email about the status of the registration
pla
n.

As stated before
,

the workflow process
would

be developed as a configurable interface. There
will be skip options to avoid selected level of work flow. Assigning user to each level can be
done by
AJAX

class
es
.
This

will be using
JSON

to retrieve the dat
a
and
thus increase speed.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
26

of
82

e
-
MoVERS will be supporting the
SCAQMD

staff
to create m
ulti
-
Site
s, and add/remove sites
from a multi
-
s
ite

as per employer choice on a

yearly basis. This
w
ould be achieved by using

the classes

provided by Ext
.NET.

The proposed e
-
MoVERS will be performing
add emission credits to sites and also process
transactions between credit vendors and regulated sites. The system
will be
check
ing

the
validity and expira
tion of the credits transferred.

The system will allow the
employer to submit changes for submitted plan. The
SCAQMD

staff
will be provided with the rights to change the plan according to the user role.

Any change to the
form will be added as another version in the OnBase DMS.

The proposed e
-
MoVERS will allow the
user to

amend any approved plan and re
-
submit a new
plan. It will be tracked in the database.

The system will enable the user to place v
arious request as follows. D
ifferent type
s

of request
can be created by using
Ext
.NET

classes
.
This will provide user to

navigate through various
procedures

easily. The administrator will be able to customize the work flow used to fulfill the
requested procedure.

Administrative Procedures



Exemption Request:

The system will aid the employer to raise Exemption request
s
. The
request will
go

through different workflow
s

after which the request will get approved or rejected. The
reviewer will review the request and send to the supervisor for grant
ing
/deny
ing the
same
. The request will be saved in
the
DB and wi
ll be uploaded the O
nBase DMS. An
email notification will be sent

to the employer




Due Date Change/Extension:

The system will aid the employer to raise
Due Date Change/Extension
. The request
will
go

through different workflow
s

after which the request will get approved or
rej
ected. The reviewer will review the request and send to the supervisor for
grant
ing
/deny
ing it
. The request will be saved in
the
DB and will be uploaded
to the
OnBase DMS. An email notification will be sent

to the employer.




Information Change:

The system
will help the user to place the request to change
MSETS related site
information
. The
SCAQMD

office assistant will
change site related information when a
request is received
.




Change of Ownership:

The system will
have
an option of placing a request to change ownership. The
SCAQMD

administrator will verify and validate the request and provid
e for

the request
change
.




Declare Bankruptcy:

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
27

of
82

e
-
MoVERS will aid the employer to declare a request to bankruptcy. The
administrator
will verify and validate the request and
set the site to bankruptcy for a
period of two years
.





Inactivation:

Customer can place a request to inactivate the site. Supervisor will inactivate the site
after validating the request.




Program Change:

Customer
can request for Program change before Approval/Disapproval. The
superv
isor will be given the right to

change
a
program after reviewing

it
. Once the
program is changed
,

all the data from the existing plan will be removed.

Master Tables Maintenance


The fol
lowing Master tables are envisaged to be part of the e
-
MoVERS application.
Admi
nistrators would be able to maintain the master data tables
.



Source Receptor Area



Performance Target zone



Disapproval Reasons



Exemption Reasons



Event related maintenance



Strateg
y Type



Program Type



ECRP related Maintenance.



ERS related Maintenance.



Strategy Type



Program Type.

Reports:

PreludeSys strongly suggest
s

the use of EXT.NET controls for creating reports. No additional
reporting tools

are

needed.
The system would give the ability to generate
Ext
.NET based
reports, print
, download various type
s of documents such as

MS EXCEL, PDF formats

and e
-
mail them.



Summary Status Report.



Finance Memorandum.



Emission Bank Reports



Miscellaneous Reports

Ext
.NET ha
s

the

capability
of

a very rich reporting UI which can be like below.

Below given are
the
UI for some sample report
s
.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
28

of
82


Fig: Dashboard Sample


Fig: Gauge

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
29

of
82


1.10

Benefits of Proposed Approach

The
propos
ed solution is based on the ASP.
NET MVC 4.0 Framework and the
benefits

would
be



Highly scalable



Highly extensible framework



High performance.



Clear separation of concerns, which would enable quicker development of the
application.



Each of the registration form would
have

its own calcul
ations. These calculation
parameters will be configurable by the administrator of the application. Thereby any
changes to the calculation in the future will not have to go through the application
programmer’s desk.



AJAX class
es

used

will
help to
increase the
performance
.



U
ser
navigation
for

d
ifferent request
s

will be easier as EXT.NET classes are used to
create various requests,



Since the workflow process
would

be developed as a configurable interface, any
change
(
s
)

to the workflow process will n
ot need the application programmer to make
changes to the application.



EXT.NET
classes used

at the page load
will help to
improve the
performance
.



Graphical Reports can be easily switch
ed

to different type of report
s

like Chart to
Gauge, Gauge to Pie, Pie
to Chart etc.



The Graphical Reports can be export
ed

as an

image and save
d
.



The reports can be export
ed to MS Excel and
pdf
.

1.11

Inadequacies the proposed approach will correct



The proposed e
-
MoVERS system is a highly receptive web based application, the users

of this application can submit registration plans and other requests through web pages.



It will eliminate paper work and difficulties coming along with it in the existing system.



In the existing system, once the registration plan or requests are received

from an
employer, it then needs to be re
-
entered in the system by SCAQMD staff leading to
increased effort. In the proposed system the employer can enter the data online leading
to lesser manual data entry errors and better efficiency.



The newly proposed
system eliminates the burden of deploying the application on each
client machine. It doesn’t require a version check

in the client side and this eradicates
version conflicts in the client.



The web based application will provide the advantage of easier and

quicker updates as
due to the updates being done in a centralized server. The web based application
hence does not require much processing requirement on the client side. This in turn
reduces the infrastructure overhead in the client side.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
30

of
82



Support and mai
ntenance

is easier for the same reason indicated above


the complete
process of error fixing is done in the centralized server. This would be a highly cost
effective and productive system.



The client machine need not be updated with a supporting platform.

Users can access
the web apps using any platform. And this can be accessed from any location.



The system can be accessed across browsers and mobile applications.



Ext.Net used in this system will be providing us with a rich set of user interface
component
s. A generic configurable content workflow is provided with this application
which provides a great level of ease to scale the system. As AJAX Linked Combos
class is used, it would increase the application performance. Tab Panels, Card Layouts
and graphi
cal reports would provide for easy navigation, higher performance and
consistency with a rich graphic interface.


1.12

Project Risks

Risk 1.
SCAQMD’s evaluation timeline of 10 days for specification documents and 30 days for
source code and executable is high. Project team
would not be able to
wait for the response to
move

on

to the next phase as the sequential approach will burn the cost. So

when SCAQMD
provides feedback while the team is working on a sprint, the feedback might throw the team off.

Mitigation plan:
Agile PM and Sr.

System Analyst should absorb the feedback, evaluate it,
prioritize the items and plan them in subsequent Sprints

appropriately
.


Risk 2.

I f a ny of t he e x i s t i ng We b Se r v i c e s do not pe r f or m a s pe r t he r e q ui r e me nt of
e
-
MoVERS
,
fixing of those Web Services by the SCAQMD team and moving th
em to production
may delay the

project. Schedule and Cost will
have an impact.

Mitigation plan:

PreludeSys PM will try to re
-
plan the development of the affected modules in
such a way that the project schedule is not affected. If it is inevitable, then

a

Change Request
would

be raised for the delay in schedule and
cost consumption.


Risk 3.
The project will be executed from October through March. Any extended vacatio
n
from any of the project staff

will delay the project.

Mitigation plan:
PreludeSys PM to discuss the vacation plan of the project team members and
SCAQMD’s evaluatio
n team upfront and plan for
any
contingency
.


Risk 4.
Claims
-
based model for Authentication and Authorization is being built. It is expected
Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
31

of
82

to be availabl
e during development, so that
meaningful tests can be
performed
. Any delay in
the availability of
this Claims
-
based model will delay the project a
nd escalate

cost.

Mitigation plan:

PreludeSys PM will try to re
-
plan the development of the affected modules in
such a way that the project schedule is not affected. If it is inevitable, then
a
Change Reque
st
will be raised for the delay in schedule and burning of cost
.


Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
32

of
82

1.13

Proposed Technical Architecture



The architecture design for this website
would be

ASP.NET MVC4 framework. In MVC
there is a clear dis
tinction of concerns between three tier

Model, View and Controllers.

The MVC framework includes the following components:

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
33

of
82



Models
. Model objects are the parts of the application that implement the logic for the
application's data domain.
M
odel objects retrieve and store model state in a
database
.

The business logic of the application will be
a part of

the model.



Views
. Views are the components that display the application's user interface (UI).
Typically, this UI is created from the model data.

In our application
,

all the UI pages
would be part o
f views.



Controllers
.
Controllers are the components that handle user interaction, work with
the model, and ultimately select a view to render that displays UI.

In our Service
Oriented architecture, the Web API or the MVC WCF service layer (which is part o
f
the controller) would receive the interaction from user and based on the request, the
concerned model is affected and tied to its relevant view as response to the user.
In
an MVC application, the view only displays information; the controller handles and

responds to user input and interaction. The Controllers are the classes which would
handle the various application logic
s
,
such as

which method would re
-
direct to which
views
,

etc. The browser requests are made to the controller and it would decide on
whi
ch model and view should be used to complete the request. There would
be
cont
rollers for each functionality
like

u
ser management
, r
egistration forms handling,
workflow handling,
site(s) and events management, a
dministrative procedures and
function
s.
This w
ould
consist of

one part of the
application logic of the whole system.

WCF Services

Web Services or WCF Services would be used
as a major part
for implementing the business
logic for any
of the
required modules as per the request. Service objects retrieve
and store the
data in a database. Some of the existing web services will be used as per the requirements

given. The new system would be integrated and consume the existing payment, invoicing and
other services available.

Cross Cutting:



All the layers would

have cross cutting features like the below implemented

o

Logging

o

Exception Handling

o

Caching (As necessary)

o

Security






Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
34

of
82

1.14

Resumes

1.14.1

Selva

Pandian


Project Manager

Professional

Summary

A Vision
-
driven Technology Professional with demonstrated record of providing project
leadership throughout concept definition, project requirements, analysis & design,
development, testing and support phases for more than 12 years.

Areas

of Practice



Expe
rt knowledge in researching, analyzing, and interpreting information conducive to
making critical technical decisions.



Interface with all levels of personnel and clients throughout the project life cycle,
including project scope creation, skill requirement

identification, project scheduling and
coordination, while effectively managing customer relationships.



Has demonstrated leadership skills by Managing and Mentoring a team of highly
qualified developers to meet the project deadlines and goals.



Has exper
tise in architecting and development of Large Client
-
Server (n
-
tier) and Web
-
based applications.



Has Good domain knowledge of core business processes like E
-
Commerce, Financial
Accounting (GL/ AR/ AP), Mobile Solutions, Rebate Processing, Statistics, Inte
rfaces,
Order Processing, Invoicing, Manufacturing, Inventory, Bill of Materials, Procurement
and Purchasing.



Has served clients in diverse industries throughout his career including Utility (Energy),
Financial Services, Retailing, Manufacturing, Technolog
y, E
-
Commerce, Research.

SKILLS

VB.Net, C#, VB 6.0, VBA, C++, Java, MS SQL Server 2008/2005/2000/7.0/6.5, Oracle
11g/10g/9i/8i/8.0, DB2, Sybase, OOD, OOP, Web Services, SOA, AJAX, XML, HTML,
DHTML, CSS, Business Objects 11/6.5.1/ 5.1, Oracle Spatial, ASP.N
et, Web Services,
SOA, AJAX, Silverlight, IIS, Tomcat, Apache, WSS, MOSS, ASP, HTML, DHTML,
JavaScript, JSP, Servlets, JDBC, RMI, XML, Dream Weaver, FrontPage and MS InterDev,
NUnit, NHibernate, GForge, Selenium, Rational Clear Case, TFS, Business Objects
5.1/6.5/11, SSRS, Crystal Reports, MS Data Reports, Rational Software Modeler, MS Visio,
Rational Requisite Pro, Rational Clear Quest, MS Project, Mercury Load Runner,
Performance Center, Data Stage, SSIS Middleware SAP PI, Data Power

W
ork experience



Conso
lidated Mobile Solutions


Developed the project replacing the existing field tool
application with the new application which integrates with GIS, Automatic Vehicle Locator
(AVL) and other backend enterprise systems like SAP, OMS, Open Text, EMS, CSS,
Orac
le Spatial and Click Schedule. Integrated the back end systems used Web services
and SOA. SAP PI was used as the ESB for integration. The application will function in LAN,
WLAN, Wireless and Offline mode.

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
35

of
82



EZRE
-

Involved in gathering the requirements from
the client and relaying it to the offshore
team. Designed the database, framework, classes and the standards to be followed for the
development. Implemented NUnit Testing framework to automate unit testing. Allocating
work to all the offshore developers an
d closely monitoring the progress of the development.
Periodic code review to ensure that the development standards are met. Providing weekly
update to the client on project progress. Integrating the outputs from the onsite and
offshore team and delivering

the product to the client. Testing the application and ensure
that the delivery from offshore teams meets the business requirements.



NexOS

-

Involved in gathering the performance requirements from the client on
performance expectations of the application. Working with Performance center/Load
Runner extensively to verify the performance of the application. Designed and Developed
web based app
lication to display the performance results. This helped management to
have a look anytime. Developed a windows based application to capture/import data from
Load Runner database to SQL Server database for analysis. Developed many tools to do
deployment, v
erifying deployment. Involved in analyzing the performance of the website /
web services periodically and improving the performance constantly.



Taxnet.com

-

Designed the Framework and the standards to be followed for the
development. Periodic code review t
o ensure that the development standards are met.
Integrating the outputs from the onsite and offshore team and delivering the product to the
client. Testing the application and ensure that the delivery from offshore teams meets the
business requirements.



C
omputer Integrated Application

-

Was actively involved in the database design. Having
known business well, played a crucial role in the redesign of the database. Designed the
database in such a way that the validations are all data driven. Did a bench mark

of
different data providers (OLE DB, .NET Native driver for Oracle by Microsoft and .NET
Native driver for Oracle provided by Oracle) and found that Native provider for Oracle by
Microsoft was fast and we are using the same. Involved in extensive client i
nteraction for
Requirement gathering wherever changes were required. Created the data dictionary,
System Design Documentation, Use Cases, State Flow Diagrams, Exception handling
class, stored procedures on Oracle 9i, Crystal reports.

Education/certificatio
ns



Bachelor of Engineering








Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
36

of
82

1.14.2

Senthilkumar M


Sr.

System Analyst

Summary:



More than 11 Years

of Professional experience in Analysis, Design, Development,
Testing, Support, and Onshore Coordination to
Web and Client Server Applications

using
Microsoft .NET Technologies



Strong Skills in
.NET Architecture
and
SQL Server Database Programming



Hands
-
on experience in Implementing Service Oriented Architecture
(SOA),
Invoking
and Consuming a
Web Service, Developing a Windows Service



Microsoft Certified Programmer (MCP)
in Web Applications in
ASP.NET and C#



Brain Bench Certified Programmer in
ASP.NET
,
C#, and RDBMS Concepts



Worked extensively in
Web Application

Development
,
Windows Forms

and
Web
Services



Having actively worked experien
ce in Win Mobile Applications Development in C#
and
Interested in Android Mobile Application Developments



Experienced in different reporting tools like

Crystal Reports 9/.Net, SQL Server 2000
Reporting Services



Extensive experience working with
ASP.NET 1.0
/1.1/2.0/3.5/4.5, C# 1.1/2.0/3.0,
VB.NET 1.1/2.0,
Active Server Pages,
Visual Basic 6.0 on different architectures such
as
Web
,
Client
-
Server, MVC Architecture Developments



Worked extensively on the design and development of
Data Driven Applications

using
ADO.NET

to access databases like
SQL Server 2000/2005, Oracle
and
MS Access



Performed backend programming like Database Design, Writing Stored Procedures,
Triggers, and Functions for
SQL Server 2000/2005/2008



Good hands on experience in
Visual SourceSafe (
VSS) and
Clear Case Version
Control System, GIT



Hands
-
on working experience with Microsoft Application Development blocks such as
Data Access Application Block (1.1/2.0), Exception Management Application
Block(1.1/2.0)



Experience in Building Rich User Inte
rface using
AJAX,HTML, JavaScript, CSS

and

DHTML



Experience in
BizTalk Server
2006 (
BTS
),
SQL Service Broker
(
SSB
),
COM

Interoperability
,
XML,
XSLT
,
XML Schema,
Threading.Net

and
Remoting.Net



Hands
-
on experience in
VBA Excel Automation
,
Digipede.NetGrid
Computing Tool,
ASP
.NET Dundas Chart Tool, Infragistics Web/Windows Controls, Telerik Web Controls



Working knowledge of Team Foundation Server (TFS), SQL Server 2005


Reporting
Services


Develop/Publish/Testing

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
37

of
82



Experience in Offshore Coordination whereby

assisted many new system studies along
with project /client management in Software Applications Design and Development



Proven ability to work with diverse and disparate teams and consistently recognized for
organizing and finishing projects in a business
environment including all phases of
software development



Experience in ASP.NET MVC,
Agile


SCRUM Development Methodology



Possess excellent
Analytical, Communication & Interpersonal Skills


Education:

Master of Computer Applications (MCA)


Technical Skills
:

Languages / Tools

Visual Studio.Net 1.0, 1.1, 2.0, 3.5, C#.Net, VB.Net, ASP.Net, MVC 4.0,
EF 5.0, ADO.Net
, Visual Basic 6.0, AJAX, HTML, DHTML, CSS,
JavaScript, XML, XSL, XSLT, VBScript, SOAP, IIS,
Crystal Reports
8/.Net, SQL Server 2000 Reporting Servi
ces
, T
-
SQL, SQL Service
Broker, WIN API, Visio, Digipede Grid Computing .NET API
Programming

Infragistics .Net UI Controls, Telerik .Net UI Controls, ASP.NET


D

Dundas Chart

Operating Systems

MS Windows 95/98/2000/XP/NT/2003/Vista/7

Databases


MS SQL Server 7.0, 2000, 2005, 2008, CE, Sybase, Oracle 8i/ 9i
, MS
Access

Version Controls

Micro
soft Team Foundation Server,
Visual SourceSafe, Clear Case, GIT

Familiar with


Health Industry Bar Code Structures (HIBC/Non
-
HIBC/GS1)

Motorola Symbol Bar Code Scanner Interface

Win Mobile Application Development in C#

Agile


SCRUM Development Methodology

.NET Modules

Web Applications (ASP.NET 1.0, 1.1, 2.0, 3.5), Windows Forms.NET,
ADO.NET,
XML Web Services, Interoperability, Remoting.Net, COM+ Services
,
Threading.Net, MSMQ, Microsoft Application Blocks
-

Data Access Application
(1.1/2.0), Exception Manag
ement Application

Certifications:



MCP (Microsoft Certified Professional)
Developing and Implementing Web Applications
with Microsoft Visual C# .NET and Microsoft Visual Studio .NET




Brain Bench Certifications
in
ASP.NET, C#.NET, and RDBMS Concepts

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
38

of
82

Professional Experiences:

Company:

PreludeSys Inc. USA





Nov 2008



Till

Client
: Mobitor Corporation, CA, USA






Nov 2008



Till

Project:

SOPIC

The SOPIC is designed to the Mobitor Corporation and caters to the Medical Device Logistics.

SOPIC means t
hat,
Schedule, Order Process and Inventory Control

to handle all shipments to
the medical centers for their scheduled surgeries. As a product, SOPIC allows their users to do
their all business activities including surgery schedules, medical devices order,
to plan their
pickup/delivery, and process their billing related queries and execution. And, this product
supports to web/windows/mobile applications to do the above all activities.

This product uses the base framework which is developed by the Mobitor Co
rporation, to
support the Web/Mobile applications.

SOPIC Applications

FS : Mobitor Field Support Application (Web Application)

WareCom


: Mobitor Warehouse Management Application (Desktop Client Application)

Integration : Advance Sh
ipping Notice, Master Feed Data (Product/Kit/Bin/Surgeon/Facility)

QC


: Mobitor Quick Case Scheduler (Web Application)

CRM

: Mobitor Customer Relationship Management Application (Web Application)

MBM

: Mobitor Mobile Business Manager
Application (Handheld Client Application
-

WinCE/iOS/Android)

Business Modules



System Management refers to the overall organization of the database
structure/configuration.



Territory Inventory Management refers to the management of all inventories.



Corpora
te Loaner Inventory Management refers to the management of all inventory owned
by the corporate entity, and loaned out on a short term basis to the field for specific surgical
cases.



Post Bill Management refers to the management of the billing and replenis
hment
processes.



Surgical Case Management refers to the process of scheduling a surgical case. This
includes requesting inventory to satisfy the implant and instrumentation needs of a
particular case.



Surgeon Data Management defines the process by which a

territory organizes an individual
surgeon data file.


Responsibilities:

Prelude Systems, Inc.


South
Coast Air Quality Management District

Task Order Number IM25
-
13


Page
39

of
82



As a
Sr. Software Engineer
involved actively in development & enhancements
(discussion/design/support)



As a Lead developer manages a team of 5.



Developed Windows, Mobile &

Web applications in
C# and ASP.NET, AJAX, Java Script



Developed modules with Infragistics UI Controls



Created Stored Procedures/Triggers/Views in
SQL

Server 2008
, modified and debugged
existing procedures



Developed reports in SQL Server Reporting Services



Involved in Unit Testing modules



Implemented modules to interact with Motorola
Symbol
BarCode Scanner/Socket Bluetooth
Scanner



Developed Bar Code patterns for HIBC/Non
-
HIBC/GS1 BarCode Structures



Upgraded Web Applications to support Multi
-
Browser Comp
atibility


Environment:

Visual Studio.NET 3.5,
C#, ASP.Net, AJAX, Web/Win Services, SQL Server
2005/2008/CE, SQL Server Reporting Services, Win Mobile Clients, GIT
-
SCM, JQuery Multi
-
tier/MVC Architecture, Sybase Ultralite Database, Zebra BarCode Printer, M
otorola Symbol
BarCode Scanner, Agile


SCRUM Development Methodology

Company:
E* Pro Inc. USA






Feb 2008



Oct
20
08


Client:
US Labs, CA, USA







Feb 2008



Oct
20
08

Project:
US Labs Enterprise Framework Project (Product)

The EFP is designed to the US Labs. EFP project aims to create a framework, which will cater
to oncology and hematopathology laboratory requirements. This Project involves providing
support for enhancement & maintenance. This framework has the features of

handling
exceptions, communicating with databases like SQL Server, Oracle and DB2 and verifying the
security. This is the base framework for all the applications developing by the US Labs.

Responsibilities:



As a
Sr. Programmer Analyst
involved actively i
n implementation



Developed Data Access
layer built on
ADO.NET classes
to manage interactions
with SQL
Server, Oracle and DB2 Data base in C#



Developed Windows & Web applications in
C# and ASP.NET



Used
XML

as the medium of
Data Transfer

between the differe
nt application layers



Designed and developed the
Business layer components



Created Stored Procedures in
SQL

Server 2000
, modified and debugged existing
procedures



Using the
Microsoft Data Access Application Block
to interact with the SQL Server



Using the
Service Interface layered design pattern