3.09 3.9
FINANCIAL\2017\Establish Cap Proj Fund 217—Computer Conversion Microsoft Azure-From Cap#64-Permissive Ref-7-3-17
RESOLUTION AUTHORIZING ESTABLISHMENT OF
INFORMATION TECHNOLOGY CONVERSION TO
MICROSOFT AZURE CAPITAL PROJECT FUND #217
RESOLUTION NO.: , 2017
INTRODUCED BY:
WHO MOVED ITS ADOPTION
SECONDED BY:
WHEREAS, the Town of Queensbury's Information Technology (IT) systems have
reached capacity as well as end of life, and
WHEREAS, the Town Board wishes to therefore establish a Capital Project that will
provide for the Town's IT Consultant, StoredTech, to accomplish two projects:
1: Temporary installation and support of additional storage capacity; and
2. Enablement of a proposed "Proof of Concept" Project designed to validate the
feasibility of using Microsoft Azure Cloud Services as an option to replace the Town server and
storage infrastructure, which proposed solution will help the Town meet its requirements to
centralize authentication, files and access to Town data, in order to meet compliance requirements
and help standardize system access; and
WHEREAS, by Quote 4STSQ6772 dated June 27, 2017 presented at this meeting, Stored
Tech will provide temporary in-house hardware support in the amount of$750 per month, and
WHEREAS, Stored Tech has also presented at this meeting a Preliminary Cloud Services
Proposal (Proof of Concept) dated June 19, 2017 to move forward with Microsoft Azure at a
cost of$15,000, with Microsoft committing $5,000 and Stored Tech committing $5,000 to help
offset the cost of the project, and
WHEREAS, the Town wishes to accordingly establish and fund the Revenue and Expense
Accounts for the Capital Project in a total amount of$10,000 - $5,000 for Proof of Concept and
$5,000 for Miscellaneous Contractual - and authorize such services of Stored Tech and Microsoft
Azure, and
WHEREAS, the Town Board wishes to authorize a withdrawal and expenditure in the total
estimated amount of$10,000 from Capital Reserve No. 64 toward this Capital Project, and
WHEREAS, in accordance with New York State General Municipal Law §6(c), the Town
Board is authorized to withdraw and expend funds from Reserve 464 subject to permissive
referendum,
NOW, THEREFORE, BE IT
RESOLVED, that the Queensbury Town Board hereby authorizes and directs the
establishment of the Information Technology Conversion to Azure Capital Project Fund 4217 in
the amount of$10,000 which will establish funding for the expenses delineated in the preambles
of this Resolution, and
BE IT FURTHER,
RESOLVED, that the Town Board hereby finds that the withdrawal and expenditure for such
Project are expenditures for a specific capital project for which the Capital Reserve Fund 464 was
established, and
BE IT FURTHER,
2
RESOLVED, that the Town Board authorizes and directs that funding for such Capital
Project shall be by a transfer from Capital Reserve Fund 464 in the amount of$10,000 to transfer
to Information Technology Conversion to Azure Capital Project Fund 4217, and
BE IT FURTHER,
RESOLVED that the Town Board authorizes and directs the Town Budget Officer to
take all action necessary to establish the following accounts for such appropriations and revenues
as necessary:
• Revenue Acct No. —217-0000-55031 (Interfund Revenue) $10,000;
• Expense Acct No. —217-1680-2033 (Computer Consultant) $5,000;
• Expense Acct. No. —217-1680-4400 (Misc. Contractual) $5,000;
• Increase Appr 001-9950-9030-0064 Transfer to Cap Project $10,000; and
BE IT FURTHER,
RESOLVED, that the Town Board further authorizes and accepts Stored Tech's Quote
4STSQ6772 dated June 27, 2017 substantially in the form presented at this meeting to
temporarily provide hardware support, for an amount of$750 per month, and
BE IT FURTHER,
RESOLVED, that the Town Board further authorizes and accepts the June 19, 2017
Stored Tech Preliminary Cloud Services Proposal (Proof of Concept) for Microsoft Azure
substantially in the form presented at this meeting, and
BE IT FURTHER,
3
RESOLVED, that the Town Board further authorizes and directs the Town Supervisor to sign
any needed Agreements and/or documentation to effectuate the Town's engagement of all such
services, and
BE IT FURTHER,
RESOLVED, that the Town Board further authorizes and directs the Town Budget
Officer to amend the Town Budget, make any adjustments, budget amendments, transfers or
prepare any documentation necessary to establish such appropriations and estimated revenues,
and
BE IT FURTHER,
RESOLVED, that the Town Board further authorizes and directs the Town Supervisor,
Purchasing Agent and/or Town Budget Officer to take any and all actions necessary to effectuate all
terms of this Resolution, and
BE IT FURTHER,
RESOLVED, that this Resolution is subject to a permissive referendum in accordance with the
provisions of Town Law Article 7 and the Town Board hereby authorizes and directs the Town Clerk
to publish and post such notices and take such other actions as may be required by law.
Duly adopted this 3rd day of July, 2017, by the following vote:
AYES
NOES
ABSENT :
4
' Quote - STSQ6772 Page 1 of 3
4,j, STOREDTECH wtvlv.storedtech.com
518-793-1111
543 Queensbury Ave., Suite 5, Queensbury, NY 12804
Quote STSQ6772
Prepared For: Prepared By:
Town of Queensbury Morgan Lane jtlfv, -y, `s.; ?
Barbara Tierney Account Executive
Phone: 518-761-8240 Phone: 518-793-1111 x234
742 Bay Road Fax: �',, 1446;
Queensbury, NY 12804 Email: quote@storedtech.com kr . c '
barbarat@queensbury.net . .{�i! `TM+ + ;w
WIcii
:®�± For the full presentation proposal,click here to view or download the PDF version of this
quote. You can sign and fax this in, or you can save time by simply electronically accepting
this quote below.
Line Item Detail
QTY Description Picture Unit Price Ext Price
Problem
As we continue to plan out the long term solution for replacement of the
existing data storage solution, we have run out of creative ways to expand the
current storage and reduce existing data storage requirements.The Town of
Queensbury will need to deploy some temporary storage and should do this in a
way that allows us to maintain an N+1 configuration.
Solution
StoredTech is recommending the temporary deployment of a Netapp storage
appliance which will be stored in a locked data cabinet that we will also supply.
Due to the fact that this recommendation is a temporary(6-8 months)solution,
StoredTech is offering to do this as a rental agreement.
1 Temporary Storage Solution $0.00 $0.00
(Qty 1) - NetApp Storage
(Qty 1)-Tripp Lite 24U Rack Enclosure Server Cabinet 33" Deep- With
Doors&Sides- Black
Scope of Work
- Pre-stage the storage appliance
- Deliver and rack the storage appliance
-Connect the storage appliance to the appropriate power sources
-Connect the appliance to the iSCSI network, present the LUN(s), and add in a
datastore(s).
https://www.quotevalet.com/concierge.aspx?TenantId=f635ae08-a807-44b7-acf2-3d2a862... 6/27/2017
•
Quote - STSQ6772 Page 2 of 3
Estimated 6-3 hours of labor to install.
SubTotal: $0.00
Shipping: $0.00
Sales Tax: $0.00
Total: $0.00
Plus$750.00 Monthly
Acceptance Detail
Order Confirmation
We reserve the right to cancel orders arising from errors, inaccuracies, or omissions.
I agree to the terms and conditions of the above document and PDF attachment with an electronic
signature below.
IP Address 72.0.130.50
PO Number
(Optional:Enter PO Number as your reference only.)
Comments Subject to Town Board
approval at the 7/3 meeting. A
I do have 3 yes votes as of
now, so it should not be a
hold up. Please schedule
'work asap. Thanks' Barbara VI
I I
Email lbarbarat@queensbury.ntj
Address
Printed Name Int
Signature
t
"signatures"could include:/john smith/;/15/;/js123/, etc
Click to Accept
This document was accepted on June 27, 2017 @ 8:00 am.
An email confirmation was sent to barbarat@queensbury.net.
Have Questions?
Quote Accepted. Have additional questions?
Submit
(Note, you will receive a copy of your message by email.)
No questions posted yet.
https://www.quotevalet.com/concierge.aspx?TenantId=f635ae08-a807-44b7-acf2-3 d2a862... 6/27/2017
STOREOTECH Microsoft.
�ERTIFiED
Microsoft Edo V lcrosOIL
Office 365 :.,zw Azure
StoredTech Preliminary Cloud Services Proposal Developed
for
Town of Queensbury
Designed by: Alan VanTassel, EVP
Aleks Pavlinik, Director of IT
Morgan Lane, Account Executive
Revision: ToQ06192017r0
•
Table of Content
Cover Letter • 3
About Storedtech 4
StoredTech as your Cloud Solution Provider 5
Assessment&Tasks to move to Azure 6
Assessment needed for the users and systems in place today: (Completed) 6
Next steps to move to Azure:Complete a POC 7
System & Network Diagram 10
Estimated Costs 11
Azure Summary Pricing— 11
Proof of Concept Project 11
Temporary Storage 12
Azure Proposal for Town of Queensbury Page 2 of 12
Cover Letter
June 19, 2017
Mr.John Strough
Town Supervisor
742 Bay Rd
Queensbury, NY 12804
Supervisor Strough,
Thank you and your Board for the opportunity to present the Town of Queensbury (ToQ)with a
preliminary Cloud Services proposal that would help you meet your requirements to centralize
authentication,files and access to ToQ's data to meet compliance requirements and help standardize
system access.
We have put together a design that encompasses all the products and services to meet these
requirements.The following pages will give you a better picture into the design based on our
conversations with your team and our knowledge of the systems we now manage for ToQ.
StoredTech is uniquely qualified to assist you in this endeavor.As a Microsoft Tier-1 Cloud Service
Provider we bring both StoredTech's and Microsoft's capabilities to the table.This allows us to design
and deliver Microsoft Cloud Service solutions around Office 365,Azure Cloud along with Enterprise
Mobility+ Security.
What we have found over the past few years, is that our customers have been moving away from the
need to house infrastructure and software at their locations.They have been moving to software as a
service (SaaS), leaving only a small footprint of software, infrastructure and data to be managed
internally. Because of this, we have been working closely with our customers to assist them in the move
from a CAPEX to an OPEX model, where infrastructure as a service (lass) and SaaS become the standard
not the exception.They no longer have to cycle through large capital expenses in infrastructure and
infrastructure refreshes.They realize that it is more important to turn out work product that meets their
business goals, rather than dealing with the constant upgrades needed to maintain the infrastructure
that turns out that work product. Users just want access to applications, anytime, anywhere.
Again, thank you for the opportunity and if you have any questions, please feel free to contact us.
Sincerely,
n v lane
7adde is Novas lane
Alan VanTassel Morgan lane
Executive Vice President Account Executive
Azure Proposal for Town of Queensbury Page 3 of 12
About Storedtech
StoredTech was founded in 2010 based off of servicing our customer's technology needs by helping
them stay always on, so they can stay focused on their business requirements and not their technology
issues. As a Managed Services Provider, based onshore, we're here to make your life easier, and to do
that we are at your disposal. We take service seriously, which is why our team leaders and support
managers monitor each engineer's responses to make sure we are meeting our customers' expectations.
StoredTech can manage your network from desktops to servers to cloud to offsite secured data vaulting
and beyond.
Our Infrastructure Solutions Group (ISG) helps integrate Voice, Data, Security and Video solutions. Our
Cloud Solutions Group (CSG) assists customers in migrating to either an On-Premise, Hybrid or Public
Cloud as their technology needs dictate.StoredTech helps our customers take advantage of new
technologies available in the ever-changing information technology landscape.
As a Microsoft Certified Partner you can trust that we will be able to assist your business with all phases
of planning, design, budgeting, installation, and ongoing maintenance of your technology infrastructure.
This gives you the agility and scalability to adapt and grow as your business needs change over time.
We specialize in:
• Managed Services & Help Desk Support 24x7x365
• Cloud Based Services for Azure, Office 365 & Enterprise Mobility+Security
• IT Consulting & Network Design
• IT Project Management
• Server Consolidation
• Desktop &Server Support
• Telephony
• Secured Data Vaulting
• Video Surveillance &Access Control
• Product Procurement &Asset Management
• Virtualization of Servers,Storage, Applications, Desktops, Networks & File Systems
Azure Proposal for Town of Queensbury Page 4 of 12
StoredTech as your Cloud Solution Provider
As a Cloud Solution Provider(CSP), StoredTech delivers all the service and support for your Microsoft
Cloud Services.
Doing so will result in the following:
1. We become your point of contact for Microsoft Cloud Services—You would submit tickets directly to
StoredTech for support, questions, service outages, etc.There would be no need to reach out to
Microsoft, we will take care of that for you. Our relationship gives us direct access to Microsoft on
your behalf so we can help maintain your environment.
2. We will provide the billing— Instead of you paying Microsoft for your Cloud Services (Azure, Office
365, EMM, etc...), you'll have a simplified process from us. Each month we will send you a statement
of your usage for that month so you know how much your spending.
StoredTech will be able to provide an enhanced level of service with your environment to ensure that
you stay running all the time.
Azure Proposal for Town of Queensbury Page 5 of 12
Assessment & Tasks to move to Azure
Assessment needed for the users and systems in place today: (Completed)
1) We need to assess the current firewalls in the offices and what VPN's if any are in use today
2) We need to assess all infrastructure/software services in use today such as MSGP,SQL, 115, SharePoint,
etc...
3) We will need to load our agent on all devices that are not currently managed by StoredTech today in
order to assess all workstations.We need to assess the local windows install, local software,etc...on each
workstation via our agent
4) We need to know where files are today, both personal and shared.
5) We will need to get an inventory of all printers, scanners, etc...and whether they are locally attached or
network attached.
6) We need to understand how they print and scan things today
Azure Proposal for Town of Queensbury Page 6 of 12
Next steps to move to Azure: Complete a POC
Azure laaS Proof of Concept
Work Item Scope of Work
Activities/Tasks 1. Assessment Phase
• Review Applications for compatibility and support in Cloud
environment
• Review workflow to ensure compatibility and support in the Cloud
environment
• Review computer attached devices to ensure compatibility and support
in the Cloud environment
2. Planning Cloud Services
• Develop IP Subnet Plan
• Devlop Site to site VPN configuration
• Develop Server Plan for POC
• Develop remote access plan
• Develop Application access plan
• Develop end user access to files and services
• Plan encryption requirements
3. Configure Microsoft Azure
• Create Microsoft Azure Tenant(if needed)
• Create admin and co-admins
• Create Virtual Networks
• Create Subnets
• Create Azure Storage Accounts
• Plan and Create a recovery subnet for VM recovery
• Create NSG for recovery testing
Azure Proposal for Town of Queensbury Page 7 of 12
• Create VMs from Gallery
• Configure Load balancing
• Create additional Data Disks
• Create Availability Sets
• Review SOC-1,2,3/HIPAA HITEC compliance documents/agreements
• Setup Site to Site VPN access for use during the POC
4. Configure Application Test Servers
5. Configure RDS Servers
• Create Virtual Application Servers
• Configure Protocols(HTTP/HTTPS)
• Configure Authentication Mechanism
• Configure Load Balancing
• Configure Application Access
• Configure Desktop Access
6. Configure Migration Services
• Validate customer Azure account availability
• Enable and Configure Azure Connectivity,Storage Account and Site
Recovery Vaults
• Deploy and Configure Microsoft Azure Site Recovery
• Create admin and co-admins
• Create a Site Recovery Vault
• Download and install Provider Agent
• Create Azure resources (Storage account)
• Create and Configure Protection Groups
• Enable Virtual Machine protection
• Create a Recovery plan.
• Test the migration of the four virtual test instances
Azure Proposal for Town of Queensbury Page 8 of 12
• Check functionality post migration
• Test backup recovery into test subnet
7. Stabilize Migration Services
• Validate Azure Site Recovery Vault
• Validate data storage and accessibility in Microsoft Azure Storage
• Validate Recovery plans
• Validate basic operations configuration
• Turnover operational documentation
8. Test Application Access
• Test access to application from internal and external clients
• Test Load balancing requirement
• Test access to test migrated File/Application/Database Server
9. Test Desktop Access
10. Develop Final Build Plan and Specs
• Determine server quatities and builds for production work
• Determine final Site to Site VPN plan
• Determine migration strategy—Big Bang vs.Trickle
Azure Proposal for Town of Queensbury Page 9 of 12
System & Network Diagram
Below is a depiction of the system and network diagram. All users will authenticate to the Town of
Queensbury Active Directory in Azure.All data will be centralized and encrypted in Azure. All users
outside of the Town offices will use Cisco's AnyConnect to create a secure and encrypted tunnel
between their workstation and Azure.Town Hall will have an updated firewall to create a site-to-site
VPN with Azure so all users in the office will have secure access to Azure.
Each user will have access to Office 365 with Exchange Online and the current version of office. We will
have options for using Microsoft's Enterprise Mobility+Security to secure all users systems and phones
(IOS based and Samsung Android based) per policies decided on by you during the onboarding process.
This will couple with Multi-Factor Authentication.
Azure
Salesforce
Office 365F.
I Po
E�
Domain 2012 R2 RDS
- controller c Server
File Server
Domain
controller 1107 2012 R2 RDS
Cell Phone Server
Server
Multifactor/wth 2012 R2 RDS
Server
C
---
ASAv10 Frewall sit im
I . .. > Qs°,
Aftfreq,
siert
Remote(Jeer
Remote User
Sr
tc, crs
��ds 1,
R�0 61,
Key West Glens Falls PA
FL
LIP
Fnew II P4
Workstation LY
diens
Workstation Workstation
client
trent /
Azure Proposal for Town of Queensbury Page 10 of 12
Estimated Costs
Azure Summary Pricing—
TOQPricing Summary I 6/19/20171
_
Microsoft Azure Estimated Monthly Recurring Cost: $ 7,350.00 _
Microsoft Software Monthly Recurring Licensing Cost: $ 523.75 _
Estimated Monthly Recuring Costsl'z: $ 7,873.75 _
Cisco Virtual Firewall,Support&Software: $ 3,541.00 _
StoredTech Time Batik-Discounted at$95/hour: $ 20,000.00 _
Total Costs for Product&Servicesl:
i
— — — -- -- --H------ --4
1 Customer is responsible for all applicable sales tax&freight charges
2 Customer is responsible for a usable and reliable internet connection to the cloud
The estimated costs for Azure are based on the designs reviewed with Town of Queensbury and the
StoredTech design team.
The model consists of monthly recurring costs and up front products and services costs.
StoredTech TimeBank- Professional Services that we provide to our clients can be billed at our
negotiated "Time & Material" rate or purchased as a "TimeBank", which is a prepaid block of labor.
Proof of Concept Project
Microsoft RIDS POC for up to 10 users with 5 applications $ 15,000.00
Includes evaluation of bandwidth requirements per site and to the cloud via the meshed
network
'Anticipated Azure Spend during POC $ 5,000.00
'Anticipated Microsoft POC Reimbursement $ (5,000.00)
'StoredTech contribution credit $ (5,000.00)
'Total cost for ToQfor RDS POC: r$y;' - >S;O:6 00=
Note:All servers below Windows 2008 R2 will need to be upgraded to at least 2008 R2
Azure Proposal for Town of Queensbury Page 11 of 12
Temporary Storage
QTY Description Picture Unit Price Ext Price
Problem
As we continue to plan out the long term solution for replacement of the
existing data storage solution, we have run out of creative ways to expand the
current storage and reduce existing data storage requirements. The Town of
Queensbury will need to deploy some temporary storage and should do this in a
way that allows us to maintain an N+1 conoguration.
Solution
StoredTech is recommending the temporary deployment of a Netapp storage
appliance which will be stored in a locked data cabinet that we will also supply.
Due to the fact that this recommendation is a temporary(6-8 months)solution,
StoredTech is offering to do this as a rental agreement.
1 Temporary Storage Solution 50.00 50.00
(Qty 1) - NetApp Storage
(Qty 1) -Trapp Lite 24U Rack Enclosure Server Cabinet 33"Deep-With
Doors&Sides-Black
Scope of Work
- Pre-stage the storage appliance
- Deliver and rack the storage appliance
- Connect the storage appliance to the appropriate power sources
- Connect the appliance to the SCSI network, present the LUN(s), and add in a
datastore(s).
Estimated 6-8 hours of labor to install.
SubTotal: 50.00
Shipping: S0.00
Sales Tax: 50.00
Total: $0.00
Plus $750.00 Monthly
Azure Proposal for Town of Queensbury Page 12 of 12