 |
 |
 |
 |
 |
 |
 |
21Tech, LLC
1390 Market Street, Suite 1202
San Francisco, CA 94102
Phone: 1-415-355-9090
Fax: 1-415-355-9095
Contact contact@21tech.com
|
|
|
 |
 |
News and Events |
|
 |
21Tech’s Successful BI Solution for DPW of San Francisco |
 |
| 21Tech, LLC, a cutting-edge provider of technology solutions for business and government, has completed the implementation of the Data Warehousing and Business Intelligence solution for San Francisco’s Department of Public Works. This has enabled DPW to develop their strategic goals, establish success measurements and targets, which have been integrated into DPW’s budget process and staff performance planning. In addition, information made available through this effort has influenced the design, build and operations, maintenance, and green initiatives that improve the city’s infrastructure, public rights-of-way, and facilities. This solution consolidated data from disparate platforms into a department-wide Data Mart which has successfully transformed DPW from silo based reporting and Excel spreadsheets to virtually real-time reporting and analysis.
The new system was produced using MS SQL Server Integration and Analysis Services procedures to extract, transform, and load data from seven DPW bureaus and their respective systems. Intricate data transformation was necessary to compensate for data integrity across multiple sources to populate a DPW datamart which was developed into two major BI cubes – Service Orders, for comprehensive performance and resolution metrics and financial analyses used to track Service Orders originating from over six public works bureaus, and Projects, to track DPW project phase milestones and on-target budgeting and expense reporting.
21Tech, as part of the Xtech joint venture, was selected by the City and County of San Francisco to lead the implementation of this new system. This project has been a model public-private partnership in which resources from both sides worked as one team. The team successfully met aggressive deadlines and a tight budget to provide a data-rich environment for decision making and monitoring – a first for DPW.
“21Tech’s professional and knowledgeable project team listened to our needs and delivered Business Intelligence and Data Warehouse products well worth our investment,” according to Ed Reiskin, Director of Department of Public Works. “The results of these products will allow us to improve organizational efficiency, innovation, and accountability that will support DPW’s mission to contribute to making SF a beautiful, livable, vibrant, and sustainable city.”
"We are proud to have 21Tech work with an enterprise city department to deliver a solution with comprehensive knowledge transfer occurring as the project is being implemented” said Dilraj Kahai, Partner of 21Tech. "Our primary focus is devising business and government solutions. We are privileged to be selected as the prime vendor to help San Francisco's Public Works replace the outdated modes of information gathering and help provide a springboard for management through data."
|
 |
21Tech LEADS IMPLEMENTATION of Microsoft Hosted Exchange (BPOS/365)
Local Tech Consulting Firm to manage implementation of San Francisco’s
New Cloud based Hosted Email platform |
 |
SAN FRANCISCO – 21Tech, a leading provider of technology solutions for business and government, today announced the implementation launch of the new San Francisco Hosted Cloud Email solution using Microsoft’s Exchange technology. This will consolidate over 24,000 City and County of San Francisco employees currently on seven different mail systems.
21Tech has been providing the Project Management, Analysis, SME and Technical support for the implementation, and has worked closely with it’s partner Microsoft in the architecture of an Active Directory solution city-wide that provides a two-way synch with Microsoft Hosted Exchange. The solution has been successfully launched with the Department of Technology being the first department to fully use the new email system.
“The benefits of a single standard email system is fairly substantial, San Francisco is leading the charge to embrace cloud solutions at the municipality level” said Dilraj Kahai, Partner at 21Tech. “We are excited to work with such a great forward thinking customer and also with one of our important partners, Microsoft, on this endeavor.”
21Tech will be working in partnership with the Department of Technology’s team in managing the implementation of the new solution across approximately 60+ departments.
“I am excited to manage a winning solution with my team and 21Tech’s, and will be working closely with all the departments to ensure a successful and positive outcome” said Gina Tomlinson, CTO of the Department of Technology.
‘By moving to the this platform, we not only get immediate improvements to our system, but we gain a disaster-resilient system that provides the most modern information tools, with solid support provisions that can scale with the needs of our constituents,” San Francisco Chief Information Officer Jon Walton said.
“Combined with other IT consolidation efforts, converting seven different email systems into one platform will move us closer to our vision of a truly 21st century city government,” said David Chiu, president of the San Francisco Board of Supervisors.
21Tech, as part of the Xtech joint venture with Eaton and Associates, was selected by the City and County of San Francisco to lead the implementation of the Hosted Exchange solution. As the prime partner, 21Tech will be project managing, providing gap analysis, transition plans, managing the rollouts, discussing migration options, managing sub-contractors, and providing detailed outreach plans for most of the cities 60+ departments.
“As a Microsoft partner, we are proud to have 21Tech work on the Exchange Hosted solution for the city of San Francisco,” said Dilraj Kahai, partner for 21Tech. “Through facilitating comprehensive access to local government San Francisco makes even greater strides in increasing the productivity and streamlining of its work”.
|
 |
|