Background Information: A Bureau of HIV/AIDS Prevention and Control for a large city, operates a number of grant funded programs to address HIV and AIDS prevention, care, treatment and housing needs. The grant funding for these programs originates from several agencies. This funding is then contracted to over 200 community providers across the city to carry out specific HIV/AIDS services on behalf of agency. In order to meet grant reporting requirements and effectively manage agency public health priorities, a wide range of data is collected from the community providers. Exact data reporting requirements often differ greatly by funding source, but frequently collected data include process data, outcome data, and client-level demographic and clinical data. In addition, a multitude of data is needed for contract management and contract oversight by agency and the Master Contractor engaged by agency for contract administration.

The Obstacles: Highly sensitive data and security was prime objective. Complicity includes 40+ different service categories, 20+ different forms for each services, 2500+ field elements, 5000+ validations depends on combination of service category and related forms. The system implementations deadline were based on contractual period. The reporting requirements were very complex and user interface was listed as prime concerned.

How GCOM Assisted: Considering complexity for analyzing different service categories and forms, the GCOM team created a bottom up approach by analyzing total forms elements vs. form element used by individual service categories. GCOM developed robust security architecture where all security controls were implemented and thoroughly tested. GCOM’s Project Manager developed a very robust project plan, and obtained customer buy in, which allowed the team to meet deadlines. As part of the requirement analysis, the GCOM identified a set of UI components (such as form elements, demographic information, etc.) which were repeated on multiple screens. These custom components were designed and developed only once, as part of common services development. This approach not only reduced the development cost but development time too.

End Results: A Layered Architectural Model which was not only satisfied the current needs of the customer but also met their future enterprise-level long-term requirements. Key features of the system included:

  • Application is flexible, web based and utilizes Microsoft SQL database.
  • Application was written in a modern, widely used language.
  • Framework and application architecture utilized to develop the application follow industry accepted design patterns. This reduces the effort required to maintain the developed code.
  • Application is secure and utilizes agency Single Sign On (SSO) using agency Portal for external users and Web Seal Junction for internal users.
  • Communication between browser and IIS Server is through HTTPS using 128 bit encryption
  • Application has thorough reporting features in the form of data extract and canned reports.


Click below to see details on our capabilities within this project scope: