Database Architecture and Management

Database Design and Administration

Technology research firm Gartner predicts business intelligence and data analytics will need to continue to scale to meet the “robust growth” in data sources. At CANDA, we get it – vendors that touch big data will need to provide more, do more, and find more, from multiple information resources. Gartner also predicts that in the next two years, 30% of projects will deliver insights using both structured and unstructured data.

Our years of broad expertise working with various industries, markets, and data sources, help clients manage the volume and intricacies of data analytics and management . Our expertise includes vast experience in developing database standards and naming conventions, operating procedures and backup strategy, performance optimization, logical and physical database design with world leading databases such as Oracle, mySQL and SQL Server.

Data Warehousing and Business Intelligence

The definition of a data warehouse has evolved throughout the years, but at its core, a data warehouse represents a consolidated view of an entity’s data – an integration point for all sources into one vision of the organization. The goal of a data warehouse is to turn data into something meaningful through integration, cleansing, standardizing, and improving the data from its original source. This allows companies and organizations to make better decisions about their direction and status of their business.

CANDA Solutions has years of hands-on experience developing data warehousing solutions, ETL strategy, performance optimization and partitioning. With a focus to always improve our clients business insights and ultimately business decisions, our strategic implementation is crafted from an architecture, planning, budgeting, and/or visionary perspective.

CANDA team members led efforts to achieve Certification and Accreditation (C & A) for five (5) separate systems for the United States Coast Guard, as a part of the DHS. We worked extensively with the Risk Management System (RMS) and Trusted Agent FISMA (TAF) tools to rapidly provide C & A results in accordance with the DHS/NIST standards. In order to receive an Authorization Letter to Operate, our team successfully completed the following documents:

Security Plan
FIPS 199 Security Categorization
Privacy Impact Assessment
E-Authentication Assessment
NIST 800-26 Annual Self Assessment
Risk Assessment
IT System Contingency Plan
Security Assessment (ST&E) Plan
Security Assessment Report
Plan of Action & Milestones
Accreditation Decision Letter

The National Coordination Office (NCO) for Networking and Information Technology Research and Development (NITRD) supports the planning, budget, and assessment activities for the Federal government’s NITRD program.

CANDA Solutions implemented a nimble and elegant Certification and Accreditation (C & A) solution program for the NCO. Managing and performing security authorization, security testing, and security evaluation tools, processes, and procedures, our rapid C & A Methodology, honed within DHS, provides repeatable and measured value from day one.

We took a total assessment of the office and worked to define a usable security program with the client mission in mind that included new policies, procedures, a program handbook, checklists, and other job aides, as well the full set of C & A artifacts. The project was completed early and under budget.

Our certified, professional staff offers decades of DHS systems and C & A experience, which, combined with our experienced Program Managers (PM)—all of whom are certified PMPs, CISSPs, and CAPs—brings to the table a comprehensive understanding of the C & A process and the ability to support your project.

Scryptions International software for the health care industry allows secure and accurate dictations to be transferred in just seconds. They offer the ability to transfer files and transcribe dictations, all in a password-protected environment that is secure and HIPAA Compliant.

Scryptions medical records management demands tracking and storing medical transcription information in their system that saves time and space by storing medical transcriptions on a secure server and providing multiple search and retrieval functions.

CANDA resolved a MySQL performance bottleneck challenge they encountered with PHP website, database transactions management, persistence layer, and database server configuration, all of which improved the scalability of the system.

1027px-Seal_of_the_United_States_Department_of_Homeland_Security.svg

As part of the Department of Homeland Security (DHS), the Transportation Security Administration (TSA) secures the nation’s airports and screens all commercial airline passengers and baggage. We led and delivered multiple projects to the TSA:

Integrated Security Information Management System (ISIMS)
Transportation Workers Identification Credential (TWIC) Data Warehouse
Application Support Team (AST) transition
Screening Gateway projects within the Transportation Threat Assessment and Credentialing program (TTAC).

US-VISIT supports the DHS by providing biometric identification services that help federal, state, and local government decision makers accurately identify the people they encounter, and determine whether those people pose a risk to the United States. CANDA Solutions principals managed the team that delivered incremental support to the US-VISIT Validation Service, supporting the validation of ePassports for travelers from around the world.

Domestic Nuclear Detection Office (DNDO) is a jointly staffed office within the DHS. CANDA Solution’s success within DNDO derived from our ability to provide the technical expertise required to understand how organizations operate, help them set goals, and implement the latest innovations to achieve them. Our experience was critical in supporting and enhancing the capabilities of the Joint Analysis Center Collaborative Information System (JACCIS) program.

The DHS Protected Critical Infrastructure Information (PCII) Program Office is currently administering their system in an initial operating capability (IOC) and has recently procured contractor support to enhance that capability to bring the system to a full operating capability (FOC).

The FOC, as envisioned, needs to fulfill the operating needs of the program today and into the future. The enhanced system is architected in a manner that allows flexibility and adaptability to any scenario that is presented to the office from data providers, consumers, or to meet the internal needs of the program. CANDA Solutions created the SOA blueprint for the new system and is currently leading the development team.

Founded in 1995 as one of the first providers of remote intraoperative neurophysiological monitoring, SpecialtyCare (formerly Sentient Medical Systems) is one of the largest, most sophisticated, and reliable providers of intraoperative monitoring services.

Prospective, case control, and retrospective studies published over the past 20 years attest to the efficacy of intraoperative monitoring. It is considered valuable in the management of orthopedic and neurosurgical patients by many professional organizations, among them the American Academy of Neurology, American Clinical Neurophysiology Society, Scoliosis Research Society, and the American Association of Neuromuscular and Electrodiagnostic Medicine.

We provided a solution that fit their critical needs to offer collection and reporting solutions that are secure and robust. Our web-based data collection and reporting systems offer multiple, simultaneous interactions with the most current data provided, automatic tracking of data status, reporting capabilities, and nightly batch process for invoice generation. The application has been implemented using JBoss, EJB, JSP, Servlets, Oracle 9i, Linux.

Intraoperative monitoring provides a multitude of benefits, including:

Reduced adverse outcomes and iatrogenic physical impairment
Decline in hospital length-of-stay and associated medical costs
Decreased overall insurance liability

Through the Public Health Service, CANDA Solutions helped the Architect of the Capitol in the design, development, and rollout of their Job Hazards Analysis application that is part of their comprehensive Environment Health and Safety program.

The application allows health and safety managers to record, recommend, and analyze all jobs with respect to their potential hazards and adherence-to-safety precautions. The Architect of the Capitol is responsible to the United States Congress for the maintenance, operation, development, and preservation of the United States Capitol Complex, which includes the Capitol, the congressional office buildings, the Library of Congress buildings, the Supreme Court building, the U.S. Botanic Garden, the Capitol Power Plant, and other facilities.

Nielsen (formerly Arbitron), a world leader in radio ratings, came to CANDA looking for solutions to establish IT governance, open source adoption, development process and procedures, capacity planning, code standards, and change control policies. We reengineered and developed various projects:

We were instrumental in the initiation, planning and ongoing management of projects to replace critical legacy systems consisting of 42 different languages and technologies.
Identification of the critical path through the legacy systems that include server-based systems and desktop-based software, and the workflow associated with these activities.
We supported the Portal People Meter project, which is a Java/J2EE based application, which increased performance and throughput by 250% and stabilized the operational aspects of the application that enabled the further commercialization of the service.
We developed an Oracle Data Warehouse star schema for a new, web-based product providing a robust, next-generation replacement of core enterprise reporting functionality to the Radio Market business. We developed the automation for all scripts for data extracting, transforming, and loading (ETL) data from the star schema to MySQL 4.1. and enforced data validation at the ETL time, providing data quality guidelines and standards. We designed de-normalized for performance schema in MySQL, plus data compression, indexing, and queries optimization.
CANDA implemented a multimedia collection and processing system that processes up to 40 Million records a day, collecting information from multiple distribution networks.
We also developed a Client Information System Application for consolidation of all client information from seven different data sources in the centralized Oracle repository, with the J2EE application deployed to WebLogic Server and implementation using MVC pattern.

QinetiQ North America (QNA) delivers technology, services, and solutions for U.S. government and commercial customers. They deliver high quality products and services that leverage detailed mission knowledge and proven, reliable tools and methodologies to meet the rapidly changing demands of national defense, homeland security, and information assurance customers.

CANDA, a QNA partner, has supported and continues to work with their Missions Solutions Group by providing support, insight, and services to various projects: defining solutions architecture, technical proposal writing, and working to support their efforts to ensure the success of their Defense and Civilian Agency customers.

QNA is known for translating complex system specifications into mission solutions and CANDA is committed to deliver the very best in technology and service offerings to support QNA and their mission.

This was our first delivery of full Fresh Haystack functionality in the secure cloud environment. PAE’s Security team now uses multi-factor authentication to access all the features of the Enterprise Industrial Security Suite including SCI, Collateral and Suitability & Public Trust workflows, Integration with Workday, and they are looking forward to achieve efficiencies and productivity gains by using the modern case management system.

Promoting Security Shared Services Center will enable CACI to centralize key functions of the security program that spans across the company. Fresh Haystack was selected to create efficiencies in the business process and to provide the Security team, Program Managers, and Employees with the tools, information, integrations with internal systems, and capabilities that didn’t exist in the past.

A productive, easy to use, and adaptable case management platform increases in value when processes can be implemented rapidly. ManTech decided to use Fresh Haystack, which was successfully delivered using Agile methodology against a long list of business and security requirements – not surprising for a company that has a multitude of different US Government customers.

Booz Allen Hamilton has been at the forefront of strategy and technology for more than 100 years. Today, the firm provides management and technology consulting and engineering services to leading Fortune 500 corporations, governments, and not-for-profits across the globe.

Nurturing the strategic know-how and potential of the distributed workforce, so that everyone can gain efficiencies and contribute to a successful customer engagement, has always been a key differentiator for Booz Allen. However, as security requirements evolve and policies change, the firm must find new tools to help its employees succeed and deliver to its shareholders. Booz Allen turned to CANDA Solutions’ Fresh Haystack, a platform of cloud-based case management, workflows, automation, and integration solution for complex business case processing.

All of its cleared employees use the SMART (powered by Fresh Haystack) case management tool to foster productivity and efficiency and achieve major cycle time reduction for complex business case processing.

The Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF) is a unique law enforcement agency in the United States Department of Justice that protects our communities from violent criminals, criminal organizations, the illegal use and trafficking of firearms, the illegal use and storage of explosives, acts of arson and bombings, acts of terrorism, and the illegal diversion of alcohol and tobacco products.

Through the Public Health Service, CANDA Solutions has helped the ATF in the design, development, and rollout of their HEPP Database application that is part of their comprehensive Environment Health and Safety program.

The application allows Fire Investigators to collect sample data from investigation sites and run reports to analyze the data for overexposure issues and look at trends in the use of protective equipment.

The Department of Justice (DOJ) enforces the law and defends the interests of the United States. It ensures public safety against threats—both foreign and domestic—and provides federal leadership in preventing and controlling crime, seeking just punishment for those guilty of unlawful behavior. The DOJ ensures fair and impartial administration of justice for all Americans.

The DOJ’s Legal Information Office Network System (LIONS) is a database with online capabilities which permits the USAOs and EOUSA to compile, maintain, and track information relating to defendants, crimes, criminal charges, court events, and witnesses, used by the Executive Office for United States Attorneys (EOUSA) division to manage and maintain information supplemental to legal education, policy development, and coordination with the DOJ and other federal agencies.

LIONS was established to track cases and matters which are presented to and/or pursued by the USAOs. LIONS serves as a day to day management tool as well as a litigation aid and a review tool. By allowing the USAOs and EOUSA to summarize and analyze the cases pending and completed, the USAOs and EOUSA can more efficiently promote the interests of the United States government.

CANDA’s decomposition effort of the Case Management system included a review of the code, database, and existing documentation for the LIONS system. We prepared and submitted a white paper to executive management highlighting the system status, including a path to upgrade from outdated and obsolete technology. Based on all that, we proposed a solution and showed the benefits of the suggested architecture.

The Federal Air Marshal Service (FAMS) is a United States federal law enforcement agency under the supervision of the Transportation Security Administration (TSA) of the United States Department of Homeland Security (DHS).

“The Air Marshal Service is meant to promote confidence in civil aviation by effectively deploying federal air marshals (FAMs) to detect, deter, and defeat hostile acts targeting the United States.”

CANDA Solutions led the technical implementation of the IBM’s MAXIMO solution for the FAMS Warehouse Management System. The system was based on the customization and configuration of the MAXIMO Asset Management System and was implemented to track consumable information for the Atlantic City Warehouse.

CANDA Solutions led the technical transition as well as the implementation of the Kennedy Space Center (KSC) Engineering Support Contract (ESC) for the National Aeronautics and Space Administration (NASA). We helped to build a suite of program management, engineering, and work control software services for the execution of the QKESS program.

QKESS is an information hub and collaboration portal, which forms the program Management Information System (MIS) backbone and is the branding term for the consolidated set of the MIS requirements. It also provides a means of data transport for users assigned to the KSC directorate and its partners on the ESC contract.

QKESS encompasses a variety of programmatic and administrative applications. Every ESC team member uses this integrated administrative information system. Applications within QKESS support numerous functional areas, including content management and collaboration, work control, asset management, ESC Service Desk, schedule management and Earned Value Management (EVM), risk register and risk management services, task order life cycle management services, hireling life cycle services, decision support, and our prime contractor (team QinetiQ North America) business and financial services.

QKESS provided the ESC program with the tools to improve business processes which increased efficiency, effectiveness, reliability, and cost-savings for the Government.

1024px-U.S._Department_of_State_official_seal.svg

The Department of State (DOS) Passport Records Imaging System Management (PRISM) manages archived images of passport applications for United States passports. Used on-site at passport agencies, PRISM is a digital imaging system that scans and stores information in an easily retrievable format.

This high speed document imaging system is capable of scanning, cataloging, and archiving passport documents in a central data repository. CANDA provided support and solutions:

Implementation of Microsoft SQL Server tool for managing new Disaster Recovery Site setup and configuration
SQL optimization and replication best practices and configuration
SQL Server 2000 Administration