Client:

State of New Jersey, Division of Medical Assistance and Health Services (DMAHS)

Project:

DHS Enterprise Data Warehouse

Description:

Cosmic provided consulting assistance to the Department of Human Services for its Enterprise Data Warehouse (EDW) Project. Cosmic provided the EDW Project Coordinator who was responsible for performing the following tasks:

• Assisted With Determining Current Project Status - reviewed all materials related to the EDW project. These materials minimally included the current Advanced Planning Document (APD), Draft Request for Proposals (RFP), Detailed Implementation Schedule (DIS), and other relevant documentation.
• Reviewed and Commented on the Logical Data Model - reviewed and provided comments on the logical data model (LDM). The review and comments focused on the completeness and accuracy of the data model, entity types, cardinality and data relationships.
• Developed a Plan to Determine an Approach for Project Implementation - developed a plan to provide for state staff review of the current EDW project status. This included developing an organization to gather input relevant to the project implementation approach, process feedback and confirm current EDW needs and requirements.
• Managed Execution of the Project Implementation Plan - managed the execution of the project implementation plan developed above. Arranged and lead all meetings relevant to the project implementation. In addition, provided for the documentation of all meeting minutes, the tracking of issues and facilitate their resolution, and the documentation of all decisions.
• Assisted With Advanced Planning Document Updates - assisted with the identification of the need for any APD updates, assisted with the modification of the APD and assisted with obtaining Federal approval of the modified APD as necessary. This process took place in a multi-optive environment with ACF acting as the "umbrella" agency for the Federal Government.
• Assisted With Any EDW Requests for Information - assisted with the development of a Request for Information (RFI) determined necessary for the implementation of the EDW project.
• Assisted With RFP Development - assisted with any modifications to the Requests for Proposals (RFP) determined necessary for the implementation of the EDW project.
• Assisted During Procurement - assisted the State by managing the arrangements for approval of the release of the EDW RFP, the bidder conferences, bidder RFP questions and state answers, and the procurement library. In addition, advised the State throughout the evaluation of proposals.
• Assisted During Design, Development and Implementation - assisted the State by managing the completion of State responsibilities as outlined in the RFP during the design, development, and implementation of the procured EDW.

Client:

State of New Jersey, Department of Health and Senior Services

Project:

Communicable Disease Reporting System

Description:

Cosmic was involved in the design of various server side modules of the web site and involved in the implementation of certain core EJB components. Responsibilities included project status tracking, conducting Requirements Analysis meetings.

• Collecting Requirements from meetings and preparation of a Software Requirements Specification.
• Designing the Use Case Diagram, Logical Component Diagram using Rational Rose.
• Developing the UML Document.
• Designing the business components using Rational Rose.
• Designing the deployment architecture.
• Developing the core components using EJB.

This system is the Department's first step towards the systems consolidation of the various two-tier systems. The Department of Health and Senior Services has a variety of information systems, which follow the Stove Pipe paradigm. CDRS is being designed and implemented such that it could potentially serve as a framework for supporting the Department's ongoing EAI effort. CDRS is a N-Tier web-based system and would be replacing a FoxPro system called NETSS. NETSS is a Surveillance System and the current reporting system is the archaic, paper based system. There is a huge delay in reporting epidemics, using the current reporting system. CDRS would alleviate this situation. By making the reporting electronic, the Department gets accurate information in a very short period of time. The targeted users for this system are physicians, laboratories, local health officials and officers of the Department.

CDRS as mentioned above is a web-based Reporting system, and hence involves capturing information from users and providing the ability to update the same. Users are provided with the ability to search from a particular report, by providing parameters. The system would apply the parameters and list all the reports that match. The user interface design is complex for this system, as there is a great deal of information involved in a report. Due to the dynamic nature of this UI design, and the possibility that this system could serve non-pc clients for instance, special devices that are used in hospitals, PDAs, etc. The presentation layer is implemented using XSL and XML. CDRS supports batch electronic reporting for Laboratory based systems; the data from the Laboratories would be received in HL7 (Health Level 7) compliant format. The interpreter for HL7 data is an integral part of the system. CDRS would import data from its predecessor NETSS and would provide all functions that the user would be able to apply on a web-input case to the imported data as well as the electronic data. The state departments work with CDC and report information to CDC periodically; CDRS also has a module, which would generate the report in the CDC specific format. This format is CDC proprietary property.

Client:

Bristol-Myers Squibb Pharmaceutical (BMS)

Project:

Engineering Document Management System

Description:

BMS implemented an "Engineering Document Management System" for the electronic creation, storage, retrieval, viewing and modification of drawing and documents associated with its engineering projects.

• Involved in development, production, administration, customization, testing, and migration.
• Resolved day-to-day user, development, production, testing and customization problems related to Documentum.
• Involved in configuration & installation of Web Cache/Web Publisher/Documentum 4iWCM Edition. Involved in Creation of Workflow templates and configuration of web publisher and ACL scheduling periodic jobs in Documentum server. Created DQL and SQL Scripts for analyzing Documentum and SQL Server performance. Involved in migrating existing content into repository through Web Cache. Developing dynamic web publishing solutions and large-scale document management applications.
• Involved in knowledge transfer for client staff using Web Content Management tools. Involved in training the key staff at client side on Documentum work process.
• Involved in exporting the existing version control systems to Documentum.
• Customized the look and feel using the application, DFC and WDK. Created workflow template for the task workflow automation. Modifies the XML files adding and removing actions for the custom Objects. Installed Rendition tools for translation of documents from one format to another format.
• Developed web front applications for the management of documents for domain, Specific users with Documentum API calls. Used DFC for integration of Customized and existing applications with Documentum. Created custom methods and automated the execution of those methods through the Documentum job object.
• Restored/Migrated Documentum objects using Dump and Load methods.
• Used DFC to Customize actions to custom attributes. Involved in a document and generates a PDF request whenever a user checks in a document or imports a document. Used Documentum Framework classes to customize client.

Environment:

Documentum 4i, Right site server 4.1.3, Documentum Administrator 4.2.2, AutoRender Pro 4.2.2, HP-UX11.0, SLA, Solaris, Windows NT 4.0, Documentum WCM Edition, Desktop Client 4.2, Developer Studio 4.2, html, JavaScript, DFC4.2, eConnector4.2, ftpIntegrator 4.1,IntranetClient4.2, EDM Server 4.0.5,e-Content Server4.1 for SAP, WDK 4.2, Web Cache 4.2, Web Publisher 4.2, Oracle 8i, XML, VisualBasics6.0, ASP, Documentum Foundation Classes 4.2, SQL Server 7.0, Documentum WCM edition, Web logic server, Web Cache, Documentum Auto Render Pro 4.2.2 With Acrobat Exchange, IIS 4.0, WebSphere, Weblogic server.