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