Business Problem:
The NY City Government Agency wanted to enhance the current static public site to help Citizens collaborate with the Agency by allowing them to submit applications online, search for status of application and other agency information
To meet the growing need for the agency services, they wanted to deploy a Business Process Management platform to increase the productivity of their staff members
They want to have a solid platform for Reporting and Dashboards including Ad Hoc reporting to allow the leadership to obtain a clear picture of the system performance
To build a scalable and extendable platform for all their future collaboration and process management efforts
Build a robust data model for the platform and migrate data from their existing systems into this new platform database
Integrate with other agency systems to provide a consolidated view of the data
Project Description:
Designed a Solution using Microsoft Office SharePoint (MOSS) platform
Designed an Intranet, Extranet and Internet user experience to allow different user profiles to consume the services
Designed a complete infrastructure platform to meet the security and scalability needs of the business
Design a work flow framework to meet the process requirements of over 9 departments
Designed a data store strategy of storing information in MOSS Content Database as well as regular SQL Server tables. This also included a Data Access Layer to manage transactions across these data stores
Designed the approach for Data Migration to mitigate risks while ensuring data quality
Designed a Governance model for the solution
Designed a Web Services based approach as well as proper use of the Business Data Connectivity (BDC) service to integrate data from external systems
Technology included : MOSS, MS SQL Server, DocAve Extender
Company I worked For: Advica Consulting
Role : Solution Architect
The NY City Government Agency wanted to enhance the current static public site to help Citizens collaborate with the Agency by allowing them to submit applications online, search for status of application and other agency information
To meet the growing need for the agency services, they wanted to deploy a Business Process Management platform to increase the productivity of their staff members
They want to have a solid platform for Reporting and Dashboards including Ad Hoc reporting to allow the leadership to obtain a clear picture of the system performance
To build a scalable and extendable platform for all their future collaboration and process management efforts
Build a robust data model for the platform and migrate data from their existing systems into this new platform database
Integrate with other agency systems to provide a consolidated view of the data
Project Description:
Designed a Solution using Microsoft Office SharePoint (MOSS) platform
Designed an Intranet, Extranet and Internet user experience to allow different user profiles to consume the services
Designed a complete infrastructure platform to meet the security and scalability needs of the business
Design a work flow framework to meet the process requirements of over 9 departments
Designed a data store strategy of storing information in MOSS Content Database as well as regular SQL Server tables. This also included a Data Access Layer to manage transactions across these data stores
Designed the approach for Data Migration to mitigate risks while ensuring data quality
Designed a Governance model for the solution
Designed a Web Services based approach as well as proper use of the Business Data Connectivity (BDC) service to integrate data from external systems
Technology included : MOSS, MS SQL Server, DocAve Extender
Company I worked For: Advica Consulting
Role : Solution Architect