HomeMy WebLinkAboutIntellectyx_Response - RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
INTELLECTYX PROPOSAL RESPONSE
RFP - GIS DATA & DATABASE ARCHITECTURE AND
DATA MAINTENANCE HEALTH CHECK
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
1
Table of Contents
A. EXECUTIVE SUMMARY .......................................................................................... 2
B. FIRM/INDIVIDUAL PROFILE .................................................................................... 3
C. DESCRIPTION OF PROPOSED SOLUTION ........................................................... 4
D. SCOPE OF PROJECT ............................................................................................. 8
E. RELATED EXPERIENCE WITH PROJECT SIMILAR TO THE SCOPE OF
SERVICES .................................................................................................................... 9
F.STATEMENT OF QUALIFICATION ......................................................................... 14
G. REFERENCES ....................................................................................................... 15
H. PRESENT AND PROJECTED WORKLOADS ....................................................... 16
I. KEY PERSONNEL ................................................................................................... 17
J. PRICE PROPOSAL ................................................................................................ 31
K. ADDITIONAL INFORMATION ................................................................................ 32
L. AFFIRMATION OF NONDISCRIMINATION & EQUAL PAY ................................... 41
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
2
A. EXECUTIVE SUMMARY
Intellectyx is pleased to submit the proposal response for the “RFP – GIS Data and Database Architecture
and Data Maintenance Health Check”.
Intellectyx, Inc (a C Corporation Company) is an AI + Data Science company founded in 2010, providing solutions
around Integrated Digital and Data solutions (Web & Mobile), Artificial Intelligence, Modern Datawarehouse,
Data Lake, Big Data, BI, Analytics, and Visualization for Public, Private and Non - Profit organizations We are a
women-owned company with over 200+ employees and locations in Denver CO, Los Angeles CA, Edison NJ,
and various client locations in the USA. We also have global offshore delivery locations in India. We are awarded
at the national level and presented with the 2019 COSB National Champion award. https://cosbvi.org/cosb-
news/2019-cosb-awards/
This proposal shall address all the evaluation criteria, firm’s capability, relevant experience in providing similar
services with City of Bozeman business goals and objectives while providing additional value by delivering
design, review, recommendation plan, and system analysis report consulting services for the City’s GIS and
other integrated management databases. As our response demonstrates, we offer the City’s GIS department an
experienced & cohesive team who is qualified to perform the required roles and responsibilities set forth in the
request for proposal documents. To succeed in this project, we formed a team of industry-leading experts in
multiple areas of expertise: Leadership, GIS, Data, Analytics, Software, and Asset Management.
Our experience in delivering similar solutions to other notable enterprise organizations shall prove valuable and
critical in delivering to the City of Bozeman within the planned timeline. Our team has a successful history of
delivering quality GIS products and services to enterprise organizations such as the “Reporting, MDM, and GIS
Platform” for the “City of Spokane”, “Web-Based Annual Reporting System” for the “Washing State Housing
Finance Commission”, “Affordable Housing Data Portal (GIS)” for “Washing State Housing Finance
Commission”.
Date: Jan 15, 2020
Raj Joseph,
President, Intellectyx
720.256.7540 | raj@intellectyx.com | www.intellectyx.com
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
3
B. FIRM/INDIVIDUAL PROFILE
COMPANY NAME Intellectyx, Inc.
U.S HEADQUARTERS 600 17th Street 2800 South, Denver, CO 80202
CORPORATE OFFICE 680 East Colorado Blvd. #180, Pasadena, CA 91101
NEW JERSEY OFFICE 611 Cinder Road, Edison, NJ 08820
OFFSHORE-DEVELOPMENT
CENTER
Mayflower Building, No:72 Second Floor, Dr, Balasundaram Rd, ATT
Colony, Coimbatore, Tamil Nadu 641018
TELEPHONE NUMBER 720.256.7540
WEBSITE www.intellectyx.com
EMAIL ADDRESS raj@intellectyx.com
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
4
C. DESCRIPTION OF PROPOSED SOLUTION
OUR UNDERSTANDING
Intellectyx understands that the City of Bozeman (hereinafter referred to as “the City”) is a dynamic growing
community and regional trade center of southwest Montana with medical, retail, and cultural amenities. The City
managing the GIS division for over 20 years. The City currently maintains its data in Enterprise Geodatabase,
File Geodatabases, ArcGIS Enterprise Data Store, and ArcGIS Online. The majority of integrations with other
databases and systems such as (Cityworks, Navline Innovyze hydraulic models, Neptune, Dropcountr, CUES
GraniteNet, Zuercher, Emergency Reporting, Montana Department of Revenue Orion database, Laserfiche,
LiGO Automatic Vehicle Location tracking, and Utility locates) are completed with FME workspaces by City’s
GIS department in-house team.
The City providing support across every department within the City, considering this, the City has undergone a
full architecture review with Esri. At the end of this review, Esri recommends expanding the system architecture
and transition into an Enterprise-wide Web GIS platform (ArcGIS Enterprise). GIS division has expanded its Esri
production environment from Coverages and Shapefiles to support a robust and complex Enterprise
Geodatabase, File Geodatabases, ArcGIS Enterprise (Portal), stand-alone ArcGIS Servers, and ArcGIS Online.
Over the last 3 years, the City’s GIS staff have added additional ArcGIS Servers and built out a full ArcGIS
Enterprise implementation including Portal, Data Store, Host ArcGIS Server, additional federated ArcGIS
Servers, and Image Server.
With this, the City has a fully developed Web GIS, same as the City looking for a qualified vendor to conduct a
full data, database architecture, and maintenance review/plan for the GIS department’s existing database
architecture and provide recommendation/suggestion for improved maintenance and transitioning from a
traditional GIS to a web-based modern Enterprise GIS. Also, the City is interested in learning and exploring new
data models and data maintenance processes.
The selected qualified consultant shall provide the following services but not limited to
✓ Analyzes current business processes using GIS and recommends best practice solutions.
✓ Works closely with end-users/City Staff to identify GIS requirements, technical issues, and training needs.
✓ Provides support for GIS data conversion, systems integration, and makes a recommendation plan for
exploring new data models.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
5
✓ Develops/Assist quality controls and standard operating procedures to ensure data integrity.
✓ Assists in the evaluation, troubleshooting, and managing of the GIS and asset management system
✓ Provides training, demonstrations, and technical support to personnel in the operation of the Geographic
Information System and related desktop.
OUR APPROACH
Below is our proposed approach towards the existing system review/recommendation plan for the City’s GIS and
asset management databases.
EXISTING SYSTEM REVIEW/ANALYSIS
At the initial phase of this project, our consultant will do business analysis as part of the continuous project
delivery but also take dedicated time as below to align with business goals and market needs –
• Periodic meetings as the minimum desired by the City.
• Via Digital Transformation Workshops wherein we try to understand the current state and the underlying
issues by talking with the various end-users of the system. Digital transformation is the profound and
accelerating transformation of business activities, processes, competencies, and models to fully leverage
the changes and opportunities of digital technologies and their impact across society in a strategic and
prioritized way.
• Taking time to understand the business strategic, tactical, and operational goals and the necessary items
we have to do from a systems perspective to align with those goals. We understand that if our clients are
not successful, we are NOT and therefore we understand and operate it is essential to be able to assess
how the proposed solution impacts the organization
• Also, post-assessment to evaluate and assess how the rolled out solution impacted the organization.
Our consultant will define and capture requirements as part of an ongoing work plan or backlog of requirements
that are groomed periodically via engaging with all business stakeholders. Our consultant shall work closely with
the key stakeholders in the City to better understand the current process flow and the City’s GIS and other
integrated asset management databases. Our consultant shall analyze the databases, data characteristics,
current data storage manner/structure, GIS integration possibilities, accessibility, current GIS data, data
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
6
architecture, and data maintenance, existing use of Enterprise Geodatabase, existing use of File Geodatabases,
existing use of Hosted data and so on. It ensures that all requirements activities are captured, appropriate
elicitation and analysis method are selected, expectations with stakeholders are set, the whole project team has
a common understanding of the requirements elicitation process, resources are available when needed, risk
strategies are in place, and elicitation is coordinated with other project tasks. Also, our staff shall support or
augment a business analyst on the project to interview stakeholders, document use cases, and document current
and desired work processes. The deliverables milestones along with specific timelines shall be developed and
documented by collaborating with the City project team. Additionally, the required work plan will also act as a
powerful tool for risk analysis and management.
We have classified requirements into the following types
• Business requirements - Describe the higher-level needs of the organization as a whole.
• Stakeholder requirements - Describe the needs of a stakeholder or stakeholder group.
• Solution requirements - Describe the features, functions, and characteristics of a solution.
We shall identify the tools/frameworks required to successfully migrate the data.
In this framework, requirements were analyzed, prioritized, and modeled. Modeling requirements means using
a model to represent requirement description. This practice turns out to be helpful for the City’s stakeholders’
understanding of requirements purposes and how they fit in the broad picture of the solution.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
7
RECOMMENDATION
After gathering all the inputs and analyzing the detailed business and technical requirements we shall provide
best-fit recommendations regarding the improvement of data management, migrating to new data models, when
to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services, transitioning from ArcGIS
Desktop to ArcGIS Pro, best possible/suitable GIS data integration method, the efficient processing method of
data retrieval and storage, suitable and more appropriate tools to analyze and report with feature enhancement
capabilities. With this, the City can be able to implement and handle its GIS database and analysis needs.
DOCUMENTATION
Our consultant will do the technical documentation in parallel to development. Our team will collaborate with the
project team including Architecture, Development, Testing, and maintenance team to capture all the details for
documentation. The purpose of such documentation is to clearly explain the concepts of the City’s GIS databases
(SQL Server Enterprise Geodatabase, ArcGIS Enterprise (referenced as well as hosted data), ArcGIS Online),
and other integrated asset management databases for the staff members to understand from an end-user
perspective. Our consultant will provide the following documentation includes Project Plan, Risks, Delivery
Timeline, Software Requirement Specifications, Design Document, User Guide & Training Material. we promise
to deliver a comprehensive report and a summary of the analysis performed by our consultant. The user guides
will be delivered in the following format Word, PowerPoint, Excel, or PDF document which the client desires so.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
8
D. SCOPE OF PROJECT
The following are the deliverables to be provided by Intellectyx in the following areas but not limited
✓ Project Kick-Off Meeting
✓ Stakeholder Interview, Project Management Documentation (Project Management Plan contents will
include, but are not limited to: Communication Plan, Project Responsibilities, Stakeholder Register, Risk
Management Plan, Change Management Plan, Testing and Quality Assurance Plan, and detailed project
schedule.)
✓ Project Scope document (Confirmation of project understanding and key areas of Needs Assessment.)
✓ Review the GIS & File Directory Structure and listing.
✓ Review the existing use of Enterprise Geodatabase (Bozeman, Bozeman_Test, GIS, Cityworks
Production, CityworksTest…etc)
✓ Review the existing use of File Geodatabases (Static data that are updated frequently)
✓ Review the existing use of Hosted data (ArcGIS Enterprise Data Store and ArcGIS Online)
✓ Recommendations for improving database maintenance and overall performance.
✓ Recommendations to improve data management (including integrations with FME)
✓ Recommendations for migrating to new data models (i.e., ArcGIS Solutions for Local Government, Utility
Networks, etc.)
✓ Recommendations on when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature
Services (ArcGIS Enterprise or ArcGIS Online)
✓ Review the existing GIS integrations and how to more efficiently use FME to channel data to the
appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc.)
✓ Recommendation plan for transitioning from ArcGIS Desktop to ArcGIS Pro.
✓ Detailed Project Approach (Documentation of existing systems and approaches/plan to develop the new
solution.)
✓ Documentation of support services and integrations/dependencies.
✓ Final documentation, Project Closeout
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
9
E. RELATED EXPERIENCE WITH PROJECT SIMILAR TO THE SCOPE OF
SERVICES
REPORTING, MDM AND GIS PLATFORM FOR CITY OF SPOKANE
CHALLENGE
The City of Spokane, through its Innovation and Technology Services Department, wanted to implement a
Master Data Management Solution to promote government transparency and accountability. The current
challenge for the City of Spokane is with streamlined efficiencies in sharing frequently requested city datasets
that are needed for analytics and reporting purposes by standardizing a method of publishing and disseminating
the data through a central location.
SOLUTION
Intellectyx is helping the City of
Spokane with a Master Data
Management and GIS platform
implementation using Microsoft
Azure’s Modern data warehouse
architecture, PowerBI, ArcGIS,
and AzureML based analytics
platform to develop advanced
reporting, visualization, and pull
out-of-the-box reports. The City
of Spokane IT department carries
different information’s Criminal
Justice Information (CJI), Payment Card Industry (PCI), Health Insurance Portability and Accountability (HIPAA),
Federal Energy Regulatory Commission (FERC), County Parcel, GIS, Tax Jurisdiction, and other PII. All these
datasets have structured, Unstructured data this was a major challenge to maintain a single version of truth data.
We used the Azure Data Warehouse to perform extract, transform, load, (ETL), and achieved credibility and
consistent data through data quality and master data management services.
• We initially created a Datawarehouse where all the ETL transformation take place and created a
structured dataset thus achieved to develop a centralized single repository.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
10
• We have Created and schedule data-driven workflows (called pipelines) that can ingest data from
disparate data stores.
• Build data visualization with interactive reporting, drill-down and roll up, and dashboard reporting
capability embedded with appropriate charts and graphs using a combination of visualization.
• Publish output data to data stores such as Azure SQL Data Warehouse for business intelligence (BI)
applications to consume.
RESULT
Some of the key benefits that the City of Spokane to be gained from the proposed solution are:
• Created a Master Data Management which has only a single version of data.
• Improved City applications and interfaces
• Optimizing the manual effort required to manage and use data across the departments
• Enhancing business intelligence, reporting, and analytic capabilities.
• Safe easy data access across the departments and reduced data quality errors.
Now with having a single centralized repository city of Spokane has a widespread of opportunities to
interact with citizens and other stakeholders.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
11
AFFORDABLE HOUSING DATA PORTAL (GIS)
CHALLENGE
The data analytics team at the Commission is
dedicated to increase housing access and affordability
and to expand the availability of quality community
services for the people of Washington. They wanted to
build an affordable open data dashboard platform to
increase transparency and accountability and to help
the public and city officials access valuable
government data.
SOLUTION
The Commission wanted to build an affordable open
data platform to increase transparency and
accountability and to help the public and city officials
access valuable government data. Intellextyx
developed tool has the ability to federate and
normalize data easily from a variety of external federal
sources like the Bureau of Labor Statistics, Census
data, CDC, CMS, and other third-party data providers.
The tool support conversion of data in the required
format, geocoding, and geographic editing of
extensive databases with millions of records. We
support the commission tagging spatial database records with longitude, latitude, postal codes (ZIP codes),
legislative districts, and Census FIPS codes to simplify geodata for users. The developed system is quick and
responsive and can access a large set of queries and It can customize the data and present it in rich graphical
formats. Users can pull the reports easily with more customizable and infographic ways.
RESULT
The developed tool has the ability to federate and normalize data easily from a variety of external federal sources
like the Bureau of Labor Statistics, Census data, CDC, CMS, and other third-party data providers. The developed
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
12
system is quick and responsive and can access a large set of queries and It can customize the data and present
it in rich graphical formats. Users can pull the reports easily with more customizable and infographic ways.
WEB-BASED ANNUAL REPORTING SYSTEM FOR HOUSING FINANCE COMMISSION
CHALLENGE
Washington State public funders
wanted to implement an online
reporting system for use by property
ow and managers to report data from
their affordable multifamily rental
projects. The public funders include
the Washington State Housing
Finance Commission, State
Department of Commerce (Housing
Trust Fund), City of Seattle, King
County, Snohomish County, City of
Tacoma, and UPIPS. Washington
State had a challenge on
consolidating and cleansing all data
from different partners while needing
to make this available through a user-
friendly portal with mobile and
accessibility features.
SOLUTION
Intellectyx helped to build and maintain a custom Real-Time Housing Compliance Portal using a value-added
innovation approach. The solution involved extracting data from different departmental databases and deduping,
matching, and linking with the source registry data. We implemented effective data architecture to support the
requirements we have mastered all the records performed (ETL) operations, created a unique record for each
individual for easy identification and query mechanism. Intellectyx demonstrated how each of the dataset’s
measures could be produced from the data warehouse, showing the accuracy and completeness of the data
model. The portal provides affordable housing project details in an easy-to-use format with in-depth data and
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
13
advanced reporting - providing accurate, actionable information that can be used to track and the compliance
status of any housing projects.
RESULT
By the end of the project, Intellectyx’ s solution enhanced the capabilities of retrieving, reporting, and visualizing
the data with quick turnaround time. The system satisfies program and contract reporting requirements and
tracks most of the main components of project performance (operation indicators, income, expense, the status
of reserves, tenancy, etc.).
• It also had the ability to integrate with various housing systems, search real-time in a fraction of seconds
over massive data from funders, tenants, and builders, and track compliance status.
• Now with no worry’s public funders, property owners and property managers can easily transfer the data
to the upgraded version – all of that will happen behind the scenes.
• With the help of NoSQL and AWS we scaled up the instances to store the data, thus now their system is
not facing any storage issues.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
14
F.STATEMENT OF QUALIFICATION
Intellectyx works with state, regional, and local governments and has a proven track record of design, redesign,
development, and implementation for a GIS solution. Our team of experts has delivered state-of-the-art database
and software solutions that are making a real difference for our clients. Intellectyx focuses on delivering creative
solutions in the areas of Artificial Intelligence, Modern Datawarehouse, Data Lake, Big Data, BI, Analytics,
Visualization, Data Conversion, Geospatial services, Urban Planning & Geographical Information Systems
Applications, we have successfully won many clients over the past decade.
With our experienced technical staff, we aim at providing high quality and innovative GIS-based solutions. We
have strong experience in providing Enterprise GIS solutions and Database projects using ESRI Arc GIS
Desktop 10.3 & earlier versions, FME Desktop and Server, and Microsoft SQL Server 2008 & 2012 based
technologies. Also, we have extensive experience in using map creation software, including ArcGIS, ArcIMS,
and ArcView. We explained our qualification and experience with Enterprise Geodatabase using one of the
projects that we are providing for the “Affordable Housing Data Portal” for the “Washington Finance Housing
Commission”
The Commission wanted to build an affordable open data platform to increase transparency and accountability
and to help the public and city officials access valuable government data. Intellextyx developed tool has the
ability to federate and normalize data easily from a variety of external federal sources like the Bureau of Labor
Statistics, Census data, CDC, CMS, and other third-party data providers. The tool support conversion of data in
the required format, geocoding, and geographic editing of extensive databases with millions of records. We
support the commission tagging spatial database records with longitude, latitude, postal codes (ZIP codes),
legislative districts, and Census FIPS codes to simplify geodata for users. The developed system is quick and
responsive and can access a large set of queries and It can customize the data and present it in rich graphical
formats. Users can pull the reports easily with more customizable and infographic ways.
Intellectyx has the knowledge and experience to enhance and enable the City’s GIS department needs. We are
pleased to be considered as an IT Contract Staffing resource and believe that our history of performance
providing GIS solutions combined with our respectable client reference list reflects the expected qualities of an
organization that is capable of delivering the support City’s require.
The projects that showcase our qualifications, experience, and knowledge of Enterprise Geodatabases, ArcGIS
Enterprise, and FME are explained in a detailed manner in the “Relevant experience in the project similar to
scope of work” section.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
15
G. REFERENCES
Client Name Contact Information Period of Performance
City of Spokane – Reporting,
MDM and GIS Platform
Myspokanecity.org
Name: Peggy Lund
Title: Supervisor Information
Systems Analyst
Address: 4th Floor, City Hall 808 W.
Spokane Falls Blvd. Spokane WA
99201-3316
Email: klund@spokanecity.org
Phone: 509.625.6954
City of Spokane Reporting,
Analytics, MDM Web
Implementation
Period of Performance: 2 Year
New Implementation and Ongoing
Support since 2019
Web-Based Annual Report
System (WBARS)
www.wshfc.org
Name: Melissa A. Donahue
Manager of Asset Management &
Compliance Division
Address: 1000 2nd Ave #2700,
Seattle, WA 98104, USA
Email:
melissa.donahue@wshfc.org
Phone: 206.287.4444
Web-Based Annual Reporting
System (WBARS)
Period of Performance: 5 Years
New Portal Implementation and
Ongoing Support since 2015
Affordability Housing Data
Portal (GIS)
https://wahousingportal.org/
Name: Rich Zwicker
Senior Policy Advisor
Address: 1000 Second Avenue,
Suite 2700 Seattle, WA 98104-3601
Email: rich.zwicker@wshfc.org
Phone: 206.287.4480
Affordable Housing Data Portal
(AHDP)
Period of Performance: 2 years
New Portal Implementation and
Ongoing Support since 2018
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
16
H. PRESENT AND PROJECTED WORKLOADS
Intellectyx has the breadth and depth of experience in application development, database administration, and
system installation to meet the City’s needs. With senior staff, we have over 11 years of experience in IT staffing
solutions and with a pool of professionals with expertise in a wide range of technologies, we bring a pragmatic
approach to solving the problem and providing value. Our team consists of highly skilled Information Technology
and personnel with decades of experience handling technology staffing support and consulting services for large,
government, private, and public- sector clients and currently on the projects such as the
✓ National Registry to collect standardized epidemiological and demographic data regarding children for
the New Mexico School for the Blind and Visually Impaired
✓ Reporting, Master Data Management, and GIS Platform for the City of Spokane, WA
✓ Employee Engagement Platform with interactive dashboard and capability to generate insights for
People Element using MERN, D3.JS, and NoSQL
✓ Centralized Reporting Platform and Open Data Housing Finance Portal (GIS) for Washington State
Housing Finance Commission
✓ Sales/Marketing Visualization Portal for NY Times using Hadoop, Elastic, D3 for gaining behavioral
insights using trillions of clickstream data
✓ Data Lake Analytics for PatelCo for online, offline channel measurement and 360-‐- degree view of the
customer
✓ Customized visualization and Operational analytics platform for HID Global
✓ First Party Media and Analytics Measurement Platform for TruEffect for cross-sell products
✓ Contingent Workforce Mobile Hybrid Platform with AI/ML for AdCorp
✓ Digital Content Distribution Platform for NBA, Hunter Lab
✓ Development of the GDPR compliance model using NLP and .NET ML mobile application (Xamarin app)
for Waterford technologies.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
17
I. KEY PERSONNEL
STAFF ROLES AND RESPONSIBILITIES
KEY
PERSONNEL ROLE YOE QUALIFICATION RESPONSIBILITY
Raj Joseph Technical
Leadership 22 BE., MBA
Technical Architecture, Design,
Development, Delivery Activities,
Milestones, and Discussion Sessions
Kishore
Kumar
VP Delivery &
Architecture 22 BE Development, Delivery Activities,
Milestones, and Discussion Sessions
Shanmuga
Pragash VP of Solutions 18 BE Business Solution, IT infrastructure,
Software architecture design
Lily Caroline Project
Manager 14 BE., MBA
Project Plan, Project Communication, Risk
Methodologies, Delivery Management QA
Plan, and Results
Anoop Tiwary GIS Solution
Architect 17 MCA
Solution Architecture, Application
development and integration,
Documentation, System analysis, and
reporting
Gopinath Data Architect 11 BE Solution / Technical Architecture, Design
Ramesh
Senior
Database
Developer
12 BE
Database design and development, Delivery
Activities
Ashok Lead Developer 14 BE Front/Back-End Development and Delivery
Activities
Veera Senior
Developer 12 BE Front/Back-End Development and Delivery
Activitiess
Hari Priya Lead Business
Analyst 11 M.Tech Research & Discovery, Stakeholder
Interviews, and Scope Documentation
Raja
Ganapathy Lead DevOps 14 BE Oversee code releases, platform
integrations, deployment
Monica Lead QA 13 BE Test Plan, Test Execution, Quality Analysis,
QA Plan and Results, Acceptance
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
18
STAFF ROLES AND RESPONSIBILITIES
Below is our management structure that has successfully been in place for years.
ASSIGNED PERSON RESUME
RAJ JOSEPH – TECHNICAL LEADERSHIP
Raj Joseph is the founder of Intellectyx, (www.intellectyx.com) with over 22 years of experience, ranging from
global corporations to government and start-up businesses. Core disciplines include strategic business planning,
organizational change management, data governance, business intelligence, program, and project
management. Raj Joseph will provide a strategic, technical architectural solution and governance framework
leadership through his past experience of working with both public and private sector organizations including the
City of Spokane, State of Washington, Federal projects, and other relevant experience. Another effort led by Mr.
Raj was a technology refresh effort which included implementing: ESRI Collector, Arc Server upgrades, and
custom GIS business intelligence web applications solutions.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
19
Highlights
• Extensive experience in the full life cycle of the Software Design Process including Customer Handling,
Project Management, Requirements Definition, Requirement Tracking, solution architecture, solution
design, integration, testing, production rollouts, and maintenance.
• Extensive experience in managing enterprise-level GIS software systems to support the storage and
delivery of geospatial data, oversight of design and maintenance of databases, including the
development, and compliance of accepted GIS operating standards.
• Cross Vertical experience across intensive Data warehousing architecture and software development
using Microsoft Business Intelligence (MSBI) Tools and SQL Server.
• Manages enterprise-level GIS software systems to support the storage and delivery of geospatial data,
oversight of design and maintenance of databases, including the development, and compliance of
accepted GIS operating standards.
• Experience in Data Models for ArcGIS, Geodatabase Database Design, Versioning, Domains, Subtypes,
Reconcile, Posting and replication with ArcSDE for SQL Server, ArcSDE for Oracle, and ArcSDE for
PostgreSQL.
• Hands-on experience in creating and analyzing maps, cleaning, and updating spatial data using ArcGIS
for Desktop 9.x/10.x. Experience in customization, such as a collection of tools on a toolbar that plugs
into an ArcGIS for the Desktop application using VBA, Python, ArcObjects, and ArcGIS Engine.
• Hands-on experience in the Development of Web GIS Applications using ArcGIS API for
JavaScript/DOJO/JQuery/HTML/CSS. Hands-on experience in creating applications using C#, VB,
ASP.NET, ADO.NET, XML, HTML, JavaScript, jQuery, and JSON. Hands-on experience in creating and
publish map services using ArcGIS Server, Geoserver, ArcGIS Online, and ArcGIS for Portal.
• Cross Vertical experience across intensive Data warehousing architecture and software development
using Microsoft Business Intelligence (MSBI) Tools and SQL Server. Designing and creating complex
ETL packages (Staging, ODS, MDW) using SSIS (SQL Server Integration Services), creating drill thru &
drill down reports using SSRS, and visually compelling dashboards using Power BI and Business
Intelligence.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
20
KISHORE KUMAR – VP OF DELIVERY
Kishore Kumar is an experienced Delivery Head of Global Teams specializing in the delivery of strategic
initiatives involving technical architecture, implementation, and delivery. Over 22 years of IT industry experience
successfully delivering large scale Transformations in Java and Business Intelligence Programs. Kishore has
primarily worked as a Strategic Transformation Leader with stakeholders from various geographies and verticals
of Banking, Retail, Telecom, Insurance for customers primarily in the USA and UK delivering projects in an
onsite-offshore based model and is at forefront of accelerating Digital Transformation efforts for clients. He is
majorly focused on Delivery and Engagement Management of AWS Cloud Initiatives, Client Relationship
Management, Team Building, Digital Technology Integrations, Digital Quality Assurance, Data Warehousing
Technologies, Data Migration, and Master Data Management.
Highlights
• A transformational leader in Dev/Application Support/QA process with global experience in processes
and methodologies such as ITIL., Scrum, Kanban
• Highly skilled and experienced in Solutions Sales, Business Process, Project Governance, Requirements
Analysis, Enterprise Software, and Partner Management
• Experienced in setting up Data Lake / DW/ MDM/Business Intelligence Practices from scratch with a
highly successful track record.
• Technocrat with expertise in propelling organizational growth through excellence in translating business
goals into program strategy development & execution, solution defining, budgeting & taking a leadership
role in overall program management, and assisting business development activities
• Skilled in multitasking in various time-sensitive projects while achieving priorities in a dynamic business
environment while maintaining strong, productive relationships with internal stakeholders & external
partners.
• Majorly focused on Delivery and Engagement Management of AWS Cloud Initiatives, Client Relationship
Management, Team Building, Digital Technology Integrations, Digital Quality Assurance, Data
Warehousing Technologies, Data Migration, and Master Data Management
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
21
SHANMUGA PRAGASH – VP OF SOLUTIONS
Shanmuga Pragash has 18 years of extensive experience in programming and application design and
development. Focused largely on Esri and Microsoft .NET technologies. He has been developing GIS solutions
using ArcGIS Enterprise, ArcGIS Desktop, ArcGIS Runtime SDK for .NET, Leaflet, and Google Maps. Lately, he
has been building web mapping applications on Microsoft’s ASP.NET MVC framework, SQL Server, Esri’s
ArcGIS API for JavaScript, Esri Leaflet, HTML5, and backbone.js. He is a developer who is known for tackling
the most complex tasks on development projects and producing ground-breaking solutions for GIS applications.
Highlights
• Experience in application design, development, testing, and technical support and guidance in ESRI
ArcGIS Desktop & Web-based products technology and open source tools.
• Assist in designing, developing, creating data models, directing, and maintaining highly complex internal
customer-facing GIS Web Applications through concept, design, and implementation phases to consume
new web-enabled GIS solutions.
• Responsible/managing quarterly GIS data update for CoreLogic, NAVTEQ data, Parcels, boundary,
create Geo-Locator, Network Dataset, and extend them to new (map, feature, network, Geo-Locator,
Geo-processing) services in all environments.
• Hands-on experience with Esri software including ArcGIS Enterprise, ArcGIS Desktop, ArcGIS Online,
Portal for ArcGIS, ArcGIS Runtime, and their associated APIs or interfaces
Experience in platform architecture, solution design, project envisioning, planning, developing,
deployment, security, identity management frameworks, cloud, and scalability.
• Experience with architecting, implementing, and administrating enterprise IT-GIS solutions/systems that
leverage the ArcGIS enterprise platform (desktop, server, and online). Leverage experience in the
implementation of Enterprise Information System (EIS) frameworks and platform architectures from
requirements including IT and GIS strategies, cloud patterns, security, scalability, and licensing.
• Proficient in Asset Management, Geodatabase management, authoring geoprocessing tools, model
builder, web app builder, Operations Dashboard, and Story Maps.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
22
LILY CAROLINE – PROJECT MANAGER
Lily has 14 years of IT experience in Information Technology, Project Management, Software Testing & Quality
Assurance. She has diverse experience in Agile and Traditional Project Management principles and
methodologies such as Scrum, Kanban, and traditional waterfall and cultivated heavy experience in managing
and delivering data and digital-related projects. She has demonstrated skills in project delivery, technical
leadership, customer liaison, team health and composition, project management, risk management, business
development, and budget management. . She is responsible for monitoring the overall project.
Highlights
• Experience in both Agile based project management methodologies such as Scrum, Kanban, and
traditional waterfall.
• Draft end-to-end project plans to track milestones/quality toll gates & delivery timelines to further track
and escalate project risks, issues, dependencies, control gaps, and minutes the action items
• Focused on managing data related projects for over 5+ years and have delivered successfully for both
states, nonprofits, and private fortune 100 clients and has extensive experience in Requirement Analysis,
Design, Generation, and Execution of Test cases.
• Overall responsible for the delivery with the experience to maintain, develop, and execute client
relationships, understand the competitor landscape in the practice area. Identify the value proposition
and differentiators.
• Educate internal and external stakeholders on service offerings. Identify and review opportunities and
prioritize activities to optimize the pipeline. Lead the large delivery team, articulated job requirements for
resources needed, supporting talent acquisition and fulfillment.
• Articulate risk, issues, budgeting challenges, and upcoming project planning summary in a clear and
concise manner via a weekly, bi-weekly, and/or monthly report to stakeholders/executives at all levels.
• Core responsibilities included supporting and maintaining systems to serve the needs of the business for
map products, spatial map layers, reports, and integration primarily utilizing the PODS/GIS database.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
23
ANOOP TIWARY - GIS SOLUTION ARCHITECT/TRAINING
Anoop is a seasoned GIS Architect and industry leader in providing innovative GIS consulting services, utilizing
state-of-the-art GIS technology by Esri. He has extensive experience with legacy applications as well as the
ArcGIS framework. He is well-versed with ArcGIS Desktop, ArcGIS Server, ModelBuilder, Python, ArcGIS
Spatial Analyst, ArcGIS 3D Analyst, ArcGIS for AutoCAD, Survey 123, Visual Basic, ArcObjects, AML, MS
Access, and geodatabase design.
Highlights
• Develop and present GIS System, automated workflow, test plans, cartographic mapping elements, and
integrates GIS elements with other technologies for different business requirements.
• Experienced in updating the GIS assets such as water, sewer, stormwater, streets, parcels, boundary,
street signs, GPS data collections and conduct linear referencing for sewer and storm drainage systems.
• Responsible for testing the creation of web services applications using ArcGIS online to create map
layers and mash-up with different base-map and online applications.
• Conduct a geospatial analysis for the vector. Raster, DEM, TIN, and Lidar using Spatial Analyst, 3D
Analyst, Geo-Statistical Analyst extensions, raster calculation, Geo-referencing, and spatial correlation.
• Provide assistance to GIS Development, Quality Engineering, User Experience, and Implementations on
various aspects of the GIS solution.
• Experience implementing and supporting GIS solutions that use Esri ArcGIS Enterprise and/or
ArcGIS Online platforms, with release implementations.
• Experienced in analyzing and supporting complex GIS solutions that are implemented and maintained in
large, very complex, and multi-platform development environments that include web, mobile, mainframe,
server, cloud, and/or database components.
• Demonstrated experience with C#, VB.NET, C, C++, Python, Java, JavaScript, ArcGIS, ArcObjects,
Windows Presentation Foundation (WPF). Proficient with Core Java, J2EE, ESRI ArcGIS Suite of
Product version 10.6 and above.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
24
GOPINATH - DATA ARCHITECT
Gopinath has been working in the information technology industry for over 17 years. He has a strong background
with Microsoft SQL Server, Transact-SQL Extract, Transform and Load, and tabular data modeling. He is also
proficient in Microsoft Power BI, SQL Server Reporting Services, SQL Server Integration Services, and Microsoft
Excel. Additionally, he leverages his experience with server and network infrastructure to ensure that reporting
systems operate efficiently and do not impede the performance of other systems.
Highlights
• Experience in MDM, Data Warehouse/Data Marts Designing, OLAP, MOLAP, ROLAP, HOLAP,
Performance tuning, Data Modelling, Application Development, and Product Support on Windows NT &
UNIX.
• Manages enterprise-level GIS software systems to support the storage and delivery of geospatial data,
oversight of design and maintenance of databases, including the development, and compliance of
accepted GIS operating standards.
• Data creation, processing, validation, and automation of tasks such as the creation of heat map raster
data for a variety of neighborhood techniques and automating it utilizing ESRI’s ArcMap, Catalog
applications.
• Develops GIS applications using ESRI software, ASP.NET, JavaScript, HNML, or Windows client-based
development tools
• Designing and creating complex ETL packages (Staging, ODS, MDW) using SSIS (SQL Server
Integration Services), creating drill thru & drill down reports using SSRS, and visually compelling
dashboards using Power BI and Business Intelligence
• Experience in Data Warehouse/Data Marts Designing, OLAP, MOLAP, ROLAP, HOLAP, Performance
tuning, Data Modelling, Application Development using SSAS, SSRS
• Data creation, processing, validation, and automation of tasks such as the creation of heat map raster
data for a variety of neighborhood techniques and automating it utilizing ESRI’s ArcMap, Catalog
applications.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
25
RAMESH – SENIOR DATABASE DEVELOPER
Ramesh A Microsoft Certified Professional having around 12 plus years of experience in MS SQL Server
Database Administration and Development, and 4 years in SQL Server Integration Services (SSIS). Experience
in integrating databases like MongoDB, MySQL with webpages like HTML, PHP, and CSS to update, insert,
delete, and retrieve data with simple ad-hoc queries. Expertise in developing Data Conversions/Migration from
Legacy System of various sources XML, flat files, Oracle, Non-Oracle Database to Oracle system Using Utl file,
SQL LOADER, External table and Calling Appropriate Interface tables and APIs. Ramesh is responsible for
database design and development. He works closely with the technical leadership in designing database
schema, and the overall data flow. He manages the process of legacy data migration to the new database.
Highlights
• Expertise in developing and implementing BI Tools including SSIS, SSAS and SSRS, IBM Cognos,
Power BI, and Tableau.
• Expertise in handling Data Base and Storages such as SQL Server 2008, SQL Server 2008 R2, SQL
Server 2012, SQL Server 2016, Azure Data Lake, Oracle, and MicroStrategy.
• Expertise in Data Modeling, Data Cleansing, querying the database, and fine-tuning the query. Strong
working knowledge in reviewing and suggesting improvements to the data architecture processes,
policies, and vision and explore new and emerging technologies.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity
relation modelling and design techniques. Expertise in writing T-SQL scripts as high-performance SQL
queries, stored procedures using SQL Server 2008/2012/2014/2016 and database administration on
production servers with server configuration, performance tuning, and maintenance with outstanding
troubleshooting capabilities.
• Experience in SQL Server high availability - Log shipping, Replication, and AlwaysON availability using
failover clustering and experience in SQL Server Profiler, Performance Monitor, Index Tuning, Solar
winds, and DBCC commands for performance.
• Managing Security (creating users, logins, and roles, granting permissions) and Hands-on installation of
SQL Server 2008, 2008 R2, 2012, 2014 setup and service packs (Installation, Migration, and Inplace
upgrade).
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
26
ASHOK- LEAD DEVELOPER
Ashok has 14 years of experience working with the ArcGIS platform and developing software applications. With
a strong educational background in GIS, GPS, ortho imagery, computer science, cartography, geo-visualization,
and programming, he is able to use his skills for a variety of applications. His technical skills include the Esri
ArcGIS software suite and server applications. He has developed applications using HTML, CSS, JavaScript,
Python scripting, and. NET.
Highlights
• Experienced in GIS Application Development, Analysis, Research and Development, utilizing ArcGIS,
ArcGIS for Server, Big Data, Elasticsearch, Scala, Maven, Java, Query DSL, cURL, Kibana,
Microservices, Web Adapter, ESRI products, Angular JS, REST Services, ENVI and ERDAS, .NET (VB,
C#, and ASP), Oracle RDBMS, Spatial, PL/SQL, C, C++, JavaScript.
• Experienced in the development of web-based projects module for the utility permit application utilizing
.NET (ASP and C#), ArcGIS API for JavaScript, DOJO, REST, and HTML5. Release management of
applications (upgradations) with server administration team and database administration team on the
server utilizing IIS and other ancillary tools.
• Hands-on experience in developing a web-form application to searching and collecting the CRGIS
Culture Resource GIS-related data including archaeological sites and archive reports the technologies
used on the project are Visual Studio 2010 .NET with C under MVC framework.
• Responsible for the overall web-based mapping application design development and coding with Java
JSP combine with ArcIMS API and ArcSDE API. Also responsible for creating and maintaining the
ArcSDE geodatabases and creating XML parser using Java Swing SAX and DOM to processing the
environmental-related data.
• Building the SDSFIE Spatial Data Standard for Facilities Infrastructure and Environment compliant
geodatabases and processing the raster imagery data with Global Mapper.
• Data creation, processing, validation, and automation of tasks such as the creation of heat map raster
data for a variety of neighborhood techniques and automating it utilizing ESRI’s ArcMap, Catalog
applications.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
27
VEERA - SENIOR DEVELOPER
Veera has contributed his talents to cutting-edge JavaScript and HTML5 work for local, state, and federal
governments. He supports networking, ArcGIS Enterprise configuration, as well as front-end web application
development. He has also contributed significantly to several mobile applications for the iOS, Android, and
Windows operating systems, developed using Xamarin and the ArcGIS Runtime SDK. NET. His background in
computer science lends an ability to see a path through difficult networking and programming challenges.
Highlights
• Experience in GIS related application development and maintenance (ArcGIS API for Javascript, ArcGIS
Pro SDK, ArcObjects SDK for .Net, Python/ArcPy/ArcGIS Model Builder, and C#). Experience in
administrating and maintaining ArcGIS Server and ArcGIS Portal include web apps such as Insights,
Operation Dashboard, etc.
• Strong working knowledge on the usage of GIS software (ESRI and Open Source) and spatial Databases
(SQL spatial, PostgreSQL with PostGIS extension)
• Assist the development team and develop as part of the team for Republic Services Maps by Line of
Business applications with JavaScript using ArcGIS Web APIs, Python, and SQL Server & ArcSDE.
• Extensive experience in relational database development, for creating complex database queries, writing
Constraints, Indexes, Joins, Views, Stored Procedures, Triggers, Cursors, and Functions using T-SQL
and PL/SQL in Microsoft SQL Server.
• Proficient at developing Single Page Application (SPA) with AngularJS controllers, directives, factories,
services, routing, DOM manipulation using JavaScript, JQuery, and AngularJS.
• Expertise in designing and deployment of Reports for the End-User request using SSRS and tableau,
crystal reports, and created many Drill through, Drill Down, Matrix/Tabular Reports, charts, parameterized
reports using SSRS.
• Experienced in all phases of the Software Development Life Cycle (SDLC) from Requirements gathering,
Analysis, and Design, Development, Documentation, Testing, Implementation, and Maintenance of
various Web and windows applications in Waterfall and Agile Methodology.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
28
HARIPRIYA – LEAD BUSINESS ANALYST
Haripriya has been specializing in GIS project development and management experience in defining business
solutions in the IT environment, working with Business Owners and IT development teams. She stays current in
Esri GIS software and database modeling. She also has extensive experience gathering requirements,
documenting as-is business process workflows, financial cost analysis, and opportunity assessments. She is
proficient in Esri mobile applications such as ArcGIS Desktop, ArcGIS Server, ModelBuilder, Python, Collector,
and Survey 123.
Highlights
• Experienced in Business Analysis, Agile & SCRUM methodologies, Product Governance & Compliance,
Electronic Data Interchange for integration, Web & Mobile application development.
• Performs the Product Owner role as part of the Agile delivery team.
• Good experience in preparing functional design documents and analyzing business and customer
requirement documents (BRD, BRS, CRF).
• Involves in product prototyping with the UI team developing wireframes for the proposed solution and
demo casting the same to the product management team and clients for UI Sign-off
• Assists technical teams in analyzing and translating business requirements to ensure accurate
understanding and application design.
• Manage Process, Product, and Project Management duties for assigned business initiatives,
workstreams, and operational components
• Worked on different documents related to requirements, functional specifications, sow, CRS, charter,
cost and timeline analysis, process flow, use cases, test cases, implementation plan, and lessons
learned.
• Manage operational and system enhancement projects in accordance with corporate goals and
initiatives, develop through business requirement documents which are utilized to execute the UAT
scenarios for validations.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
29
RAJA GANAPATHY – LEAD DEVOPS
Raja has 14 years of Cloud Service / System / Network Administrator, Technical Support Engineer in a
professional atmosphere with a strong focus on Database integration. He has strong experience in developing
cloud infrastructures in a secure and compliant way plus enabling automated continuous deployment delivery
model all the way from dev to deployment all automated. He has configured and managed several Amazon Web
Services, Apache, Linux, MongoDB, MySQL, Hudson/Jenkins for portal management, and data warehouse
solutions for Intellectyx in agile deployment and management infrastructure.
Highlights
• Expertise knowledge in implementing Development Environment by launching the instance, managing
artifacts deployment through Jenkins, managing deployment scripts, security groups through the puppet.
Sever monitoring through Nagios, log management.
• Server hardware load handling by creating the AWS auto-scaling group to scale up/down a number of
servers according to the current load.
• Hands-on experience in Setting up and managing, Production, Staging, and QA server environment,
Providing IAM rules to access AWS other services for application requirements, managing server failover,
and load balancing through HAproxy.
• Expertise in performing remote management using remoto-it, Bash script that executes recipes to
perform deployments, change orders, AWS instance launching, and maintenance.
• Setup and Administration, Device Management, Application & Patch Management, Disk and File system
Management, Backup Management, System Security Management, Performance Management, Ansible
scripts creation for deployment.
• Installed ArcGIS Server, ArcIMS, ArcSDE, ArcGIS Desktop, BEA WebLogic, PWE Petris Winds
Enterprise, and Websphere both internally and at numerous client locations.
• Hands-on experience with AWS Cloud platform and its services which includes EC2, VPC, S3, EBS,
ELB, Autoscaling, DynamoDB, Cloud Watch, Cloud Trail, SNS, SES, SQS, AURORA, LAMBDA, API
Gateway, Redshift.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
30
MONICA – LEAD QA ANALYST
Monica has 13 years of experience in testing diverse applications on various platforms. He has extensive
experience in Manual Testing, Automation Testing, Quality Assurance of Client/Server, and Web/Windows
applications using Black Box testing. Specialized in performance testing applications using load-testing tools
such as JMeter, App pulse (HP), and Blaze meter. His exclusive experience in Reviewing System Requirements,
Test Planning & Test Execution, Test Estimations, System, and Regression Testing across all devices will make
sure the project is delivered with no bugs.
Highlights
• Strong experience in Automating Web Application Testing using Selenium WebDriver and well versed
with Handling Elements in Selenium WebDriver and experienced in Data-driven Testing using Selenium
WebDriver.
• Vast experience in Agile Methodology and preparing Capacity Planning report and writing queries in
Mongo DB for data validation and Back-end testing.
• Expertise in performing different kinds of testing like Sanity, Smoke, Black Box, GUI, Functionality, Unit,
Integration, Regression, Compatibility, System and User Acceptance Testing (UAT) of Web and
Client/Server applications.
• Experienced in Project/Defect Management process using JIRA, Redmine, Mantis, Bugtracker.net, and
Basecamp and experience in preparing Task Breakdown (TBD) using XMind.
• Experienced in preparing Prototype using a specialized tool called Justinmind, Post-delivery process
such as preparing Change Request and CTB Report.
• Experienced in preparing User Stories and Subtasks in JIRA with different logics such as UI, DL, and BL.
Assist other testing team members in the use of Automation and other QA tools to develop tests more
efficiently and thoroughly.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
31
J. PRICE PROPOSAL
HOURLY RATE
# Resource Hourly Rate
1 Technical Leadership $60 per hour
2 VP of Delivery & Architecture $50 per hour
3 VP of Solutions $50 per hour
4 GIS Solution Architect/Training $45 per hour
5 Data Architect $40 per hour
6 Senior Database Developer $30 per hour
7 Lead Developer $35 per hour
8 Senior Developer $30 per hour
9 Project Manager $35 per hour
10 Lead Business Analyst $35 per hour
11 Lead Quality Assurance $30 per hour
12 Lead DevOps $35 per hour
We shall use the above mentioned roles for this project based on the needs upon approval and the total cost for
this project is $32,500.00
Payment Terms: NET 30*
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
32
K. ADDITIONAL INFORMATION
ORGANIZATION OVERVIEW
About – Intellectyx develops innovative Data + AI enterprise solutions using Data, Data Science, and AI
solutions. A global company established in 2010, Intellectyx is headquartered in Denver, the USA with associates
working across the country and globally with offshore development centers in India.
Years in Business - Intellectyx is a global software service provider specialized in software development and
has successfully implemented many full life cycle projects in data, data science, and AI for over a decade.
Employee Strength – We are 200+ employees strong spread across the world. Consultants and SME’s are
used on a need basis.
Mission – Intellectyx mission is to “Do the Right Thing Right” and we take the long-term view to ensure that
solutions are adaptable, extensible with new capabilities combining the right amount of change and delivered in
the shortest duration possible – allowing our clients to be a market leader.
Hours of Operation – 24 hours given distributed locations in the U.S, India.
DIFFERENTIATION
The following factors set us apart from other companies and will help the City of Bozeman benefit from using our
services
• Local Presence in the US – Our presence in the US with the extended arm in India helps a lot in
collaborating 24/7 across disparate stakeholders (onsite/virtual) to establish trust, confidence and
align with overall goals.
• Focus on all three: People, Process, Technology - We see business outcomes are not met with just
Technology, but with all these three elements playing a critical role – People, Process, and
Technology. All our implementation considers building an application simple to use but more robust to
scale.
• Similar Projects/Clients – Our experience in delivering similar solutions to other notable organizations
shall prove valuable and critical in delivering to the City of Bozeman within the planned timeline.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
33
• Fixed Cost Delivery - The costing is committed based on the deliveries we have done and is a fixed
cost. This means, there will be no additional costing and also, we are committed to more milestone
payments per month.
• Data Science, Digital and Intelligence Expertise - Intellectyx can leverage its combined three different
practice and support various initiatives around data visualization, reporting, narration, machine learning,
conversational support, AI, etc.,
• Technology Selection based on the existing ecosystem- We have come up with the technology
preferences and solutions based on the requirements plus the economies of scale for adoption. We want
to drive user adoption and efficiency, which means it’s critical that we deliver a solution that contains cost
and does not increase licensing cost with user adoption.
• 100% IP Ownership - Intellectyx provides 100% IP ownership to the City for both data and code and the
overall application, unlike product-based companies.
SERVICES/OFFERINGS
Intellectyx offers a portfolio of products and services that enable our partners and clients to deliver high-quality
training solutions around the globe. Our solution offerings include
UI-UX Design
We offer complete UI/UX design services by understanding human behavior and unlocking
exceptional user experience. Adopting a user-centric design approach, we help the world to
experience our customer brand and its product.
Business Intelligence
Intellectyx offers comprehensive BI services that can help our customers make more informed
decisions faster and optimize business performance across the entire enterprise.
Analytics
Intellectyx provides analytics to BI platform to gain and uncover value and insights from enterprise
data accumulated over decades, make faster and smarter decisions across the enterprise,
increase the productivity of business users and improve the satisfaction level.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
34
Visualization
We embed data visualization tools with BI applications to help you gain insight into your complex
scientific datasets and dealing with large, complicated datasets to get to the core of what the
customer looking for.
Enterprise Applications
Our application development and maintenance solutions drive efficiency and effectiveness and help
you build adaptable platforms for the enterprise. Custom applications development using existing
and emerging technologies that work well with any software portfolio to meet specific business
requirements.
TECHNOLOGY
Technology/Domain Technology Details
Microsoft Technologies
C#, ASP.Net, VB.Net, AJAX, SQL Server, ASP.Net Charts, Silverlight, WPF,
WCF, WF, ActiveX, MFC, VC++ and ATL COM, SSIS, SSRS
Java/J2EE
Java Enterprise Edition, Spring, Struts, Hibernate, JBoss SEAM Framework,
Swing, JSF, JSP, EJB 2.x - 3.x, myBatis, Junit, Mockito, Eclipse, and IntelliJ,
MyEclipse, RSA (Rational Software Architect), RAD (Rational Application
Developer)
UI/UX
Angular, Backbone, Knockout, Kendo UI, MEAN, Bootstrap, Marionette,
jQuery, jQuery UI/Mobile, JS, HTML5, JS, CSS, Underscore, D3, High charts,
AM Charts, Handlebars, Mousetrap, JAWR, Require, Sammy, Amplify, Bundle
Mobile Platforms
iOS, Android, Windows, and Blackberry; Sencha, Xamarin, Java ME MIDP;
J2ME Polish; Sun Wireless Kit, IBM Work light, Google Android Studio,
Objective C, Swift
DevOps
CI (Travis, Jenkins, Hudson, Bamboo, Team City), Infrastructure management
and Deployment (Vagrant, Docker, Puppet, Chef, PowerShell, Ansible),
Monitoring (Logstash, Kibana), Repository management (Artifactory, Nexus)
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
35
Software Testing and QA
Functional Testing, Load and Performance Testing, Acceptance Testing, Test
Automation
Tools: Quick Test Pro, WinRunner, Silk Test, LoadRunner, JMeter, Selenium,
Test Link
Open Source and Web
OS – Red Hat Enterprise Linux, Ubuntu Linux | App Server – JBoss, and
Apache, Web Servers – Apache Tomcat | Web - PHP Development, Symphony
Framework, Zend Framework, and Code Igniter Framework Web 2.0
Development – AJAX Toolkits – jQuery, DOJO, GWT, Node.js, SocketIO,
Yeoman, Grunt, npm, Bower, Karma, Mocha, Chai, PhantomJS, Jasmine
Cloud Platforms
Microsoft Azure, MS SQL Azure, Amazon, and AppFabric
Databases
Microsoft SQL Server, Oracle, PostgreSQL, MySQL, SQLite, Sybase,
Couchbase, Amazon DynamoDB, MongoDB, PostgreSQL, MySQL
Microsoft SharePoint
Microsoft Office SharePoint Server, Windows SharePoint Services, and
SharePoint Foundation. Custom Web Parts, Workflows / Process Flows.
Big Data
Casandra, Hadoop, MapR, Apache HBase, Apache Drill, Apache Storm,
Spark, Horton Works, Flink, Kafka, Cloud Era, Apache Solar, Logstash,
Elasticsearch, Lucene, Splunk, Neo4j.
Analytics and Visualization
Karma Sphere, Greenplum, D3, Kibana, Clearstory, Tableau, Platfora, angular
js, Teradata, Metamarkets, Qlik, sisense, H2O, Harman, Data bricks, Feedzai,
NetOwl, Visually, Redis, mahout, Jasper, Palantir, Rapidminer
Business intelligence
Microsoft, Oracle, Jasper soft, MicroStrategy, Pentaho, Business Intelligence,
SAP, Flume, IBM Cognos, QlikView, Tamr, Trifacta, Tibco, Fico, Informatica,
Oracle Hyperion, SAS, Oqoop, Kognitio, Birt.
GIS
ESRI, SpatialLite, Cesium, pycsw, ILWIS, gvSIG, ArcGIS, AutoDesk,
Intergraph
Chatbot
IBM Watson, Azure Bot Service, Alexa
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
36
OUR CUSTOMERS
LOCATIONS
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
37
PROJECT MANAGEMENT
AGILE METHODOLOGY WITH PMP
We shall follow an Agile-based methodology combined with feedback and continuous improvement as shown
below. The process and methodology cover not only development but also the best practices, DevOps/security
principles as well together.
Intellectyx follows a rigorous agile methodology and enforces the evaluation of all the projects on a daily basis.
We have perfected a Continuous Delivery model that takes into the challenges that come in a data or application-
related project wherein all three components (People, Process, and Technology) are very critical in the success
of a project. Each project is tracked on our internal agile process compliant list which is audited not only by
Intellectyx but also is developed in accordance with the specific needs of each customer. At Intellectyx, the
methodology itself is maintained and updated on an ongoing basis. Intellectyx Agile has been upgraded to follow
a Program Management Plan methodology to track large programs with multiple projects, provide real-time
insight into resource leveling, and keep track of timeline impacts calling out the intersection points. This takes
care of all the aspects that happen across planning stages, design and build, test, and deploy. Intellectyx project
management practice follows the best practices that are supported by a strong foundation and agile collaboration
tools such as JIRA, FogBugz, Bugzilla, GitHub, and Redmine, etc. Intellectyx uses a suite of integrated
management and project tools namely, Insight with extensive collaboration, security features, and integration
with popular tools like Subversion, MS-Project, and MS-Office. Intellectyx dedicated project manager for this
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
38
project will be communicating directly with the client at the end of each week to update the status of the project.
The project manager will provide a detailed report on the tasks performed in the current week and the tasks that
are scheduled to be performed in the coming week.
CONTINOUS DELIVERY MODEL
Below is the high-level view of the continuous delivery workflow we follow at Intellectyx and that shall be used
for this implementation too —
This continuous delivery workflow allows Intellectyx to run parallel key workstreams in configuring the application
to support various functions around implementation, testing, deployment, client feedback, and any changes in
specification. The obvious goal here is to reduce development, testing time, and go live with a mature stable
product with full acceptance from the client in the planned duration.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
39
COMMUNICATION
Communication is a critical element of any service delivery or transition. Intellectyx shall provide dedicated
technical and customer account management to ensure business alignment at all-time throughout the
implementation, roll-out, and on-going management periods of this initiative. Intellectyx team will be
communicating to the client on a daily basis to update the status of the project as needed and via weekly updates
on the overall status to the leadership. The project manager will provide a detailed report on the tasks performed
in the current week and the tasks that are scheduled to be performed in the coming week. Blended with delivery
is a closed-loop system testing that is performed with simulated input and well-coordinated end to end integrated
process/use-case testing. This QA process is especially important for any integrations that introduce system
interdependency.
Moreover, Account management is a professional function at Intellectyx and will provide:
• A central point of communication for the overall City of Bozeman team.
• Scheduled management and status reviews to track adherence to program objectives
• Change order management as needed.
• Coordinate with the City of Bozeman team for roadmap, plans, identifying interdependencies with all key
stakeholders
• An “always available” point of escalation for business and technical issues.
MAINTENANCE AND SUPPORT
Technical support shall be provided by telephone, e-mail and is available 24/7/365. Also, extensive technical
support will be provided for a total contract period from the date of the Final product Release for any bugs/defects
in the courses. Intellectyx shall support both major and minor versions of the application and provide time-to-
time notifications about Software upgrades including new versions, service packs, patches, and instructions.
Defects will be addressed in accordance with the assigned priority level from high to low level of severity.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
40
CONCLUSION
Intellectyx is highly enthusiastic about the opportunity to work with the City of Bozeman on the “GIS Data and
Database Architecture and Data Maintenance Health Check” RFP. We are confident that our consultant with
his strong working knowledge and expertise with the GIS database will review the existing system and provide
a recommendation plan to move the data into Web GIS and hosted data structure required by the City’s to
successfully complete the project. We look forward to working with the City of Bozeman and welcome any
questions regarding this proposal.
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
41
L. AFFIRMATION OF NONDISCRIMINATION & EQUAL PAY
Intellectyx, Inc (name of entity submitting) hereby affirms it will not discriminate on the basis of race, color,
religion, creed, sex, age, marital status, national origin, or because of actual or perceived sexual orientation,
gender identity, or disability and acknowledges and understands the eventual contract will contain a provision
prohibiting discrimination as described above and this prohibition on discrimination shall apply to the hiring and
treatments or proposer’s employees and to all subcontracts.
In addition, Intellectyx, Inc (name of entity submitting) hereby affirms it will abide by the Equal Pay Act of 1963
and Section 39-3-104, MCA (the Montana Equal Pay Act), and has visited the State of Montana Equal Pay for
Equal Work “best practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent “best
practices publication and has read the material.
Raj Joseph, President/CEO
Name and title of person authorized to sign on behalf of the submitter
Intellectyx Proposal Response | RFP GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
42
GOOD STANDING CERTIFICATE