Certified Woman & Minority Owned

Past Performance


Our track record speaks for itself

Data & Analytics
Data & Analytics

Data Warehouse and Business Intelligence

#HealthcareClient

VIVA has provided end-end services for Data Warehousing and Business Intelligence applications. VIVA's team was responsible for designing a data warehouse prototype in SQL server for a large hospital in Illinois.

Overview

VIVA has provided end-end services for Data Warehousing and Business Intelligence applications. VIVA's team was responsible for designing a data warehouse prototype in SQL server for a large hospital in Illinois. Our team studied their existing data stores and developed a logical data model of a data warehouse.

Responsibilities

  • Analysis of functional requirements of the data warehouse for the hospital environment
  • Study of disparate data stores of the client
  • Design of Extraction, Transformation, and Loading (ETL) mechanisms using MS SQL Server DTS packages
  • Design of data warehouse logical and physical models
  • Loading of data into the data warehouse
  • Design of cubes using PowerPlay, and reports using Impromptu
  • Design of data modeling, and prototyping of BI environment using COGNOS and Business Objects

#FinancialClient

VIVA was engaged to provide Technical Architecture on a reporting initiative tied to a major banking back-end system conversion.

Overview

VIVA was engaged to provide Technical Architecture on a reporting initiative tied to a major banking back-end system conversion. We provided an understanding of conversion between Legacy/Sun systems for database, system, and network sizing.

Responsibility

  • Worked with the client to complete multiple database projects simultaneously, including data modeling, database administration, and physical and logical design
  • Responsible for data warehousing file management and mapping creation between Siebel and the Informatica staging datamart
  • Responsible for leading the test effort across capital markets as well as providing corresponding Informatica development

Database Administration

Data Management

#DataManagementServices

VIVA has provided data management services for many projects with several entities in both the public and private sector

Overview

VIVA has provided data management services for many projects with serval entities in both the public and private sector. See below to see what we have been responsible for.

Responsibilities

  • Web Pages / Data Hosting
  • Data Migration
  • Data Administration
  • Database Administration
  • Middleware and Message Queuing Administration
  • Extract-Transformation-Load (ETL) Tool Administration and Production Support
  • Data and Information Products Production Support
  • Legacy Application and Database Maintenance Services Training / User Support

#FederalGovernment

The scope of the project was to provide web-hosting, downloading, and monitoring capability for the monthly zipped file that would meet performance requirements.

Overview

The scope of the project was to provide web-hosting, downloading, and monitoring capability for the monthly zipped file that would meet performance requirements. The hosting entity requires an infrastructure that supports a very large file and thousands of monthly downloads. VIVA analyzed the client's requirements in detail and identified Hosting.com and Limelight Networks (LL) as the hosting subcontractors for this engagement. As this involved large amounts of data download with a large user base, VIVA proposed a CDN (Content Delivery Network) solution. For this reason, we selected Limelight Networks, one of the leading companies in providing CDN services. As part of the CDN solution, the NPPES data file will be replicated in multiple servers around the world. VIVA PM had several technical discussions with the LL technical team to set up the CDN infrastructure. This included we hosting server, CDN set-up, etc. VIVA's technical team developed a simple website for the data file. The users were provided with features to download the data file from the web page. As part of the CDN solution, the website and data file will be replicated in multiple LL servers around the world. This will enable the users to download the data quickly from the nearest server, based on the user’s location. VIVA proposed a program manager (PM) and an IT specialist for this project. VIVA's PM developed a simple transition plan to transfer the activities from the incumbent. The transition was seamless and smooth, resulting in zero downtime to the users. VIVA's team had detailed discussions with the client in order to understand the monthly data posting activities. VIVA's team attended the kick-off meeting and developed a Document of Understanding (DOU) showing our understanding of the client’s expectations. As per the client's expectations, the VIVA PM developed a project plan and ensured that all the team members—client, VIVA technical team, LL technical team, and Hosting.com team—were comfortable. The VIVA PM executed the plan and the client's website went live as per the plan. No issues were reported from the kick-off meeting to the website go-live date. The client is very pleased with our on-time and issues-free web-hosting/website launch. The VIVA PM oversees the monthly activities and provides monthly status reports to the client. VIVA's team constantly monitors the data downloads using the LL control panel tool. The tool help to ensure the site is up and running all the time.

Responsibilities

  • Validating the presence of the four files comprising the monthly zipped NPPES file and ensuring that they are the appropriate format before posting, monitoring the uploading of the content, and validating that the content being made available is downloadable.
  • Troubleshooting for corrupt files, corrupt links to files, and/or other technical issues (i.e., related to malware or viruses), and to resolve the issue within 48 hours.
  • VIVA ensured that its system(s) was up to date and had the latest virus definitions and malware prevention measure(s) in place.
  • Provided a Program Director/Manager and IT specialist personnel to manage the above tasks.

Database Administration
Enterprise Software
Enterprise Software

Enterprise Application Development

#HealthInsuranceClient

One of VIVA’s core focus areas is application development. VIVA has been providing services to this client in the following categories — Web Design and Application Development.intelligence calls, and resources in an efficient manner.

Overview

One of VIVA’s core focus areas is application development. VIVA has been providing services to this client in the following categories — Web Design and Application Development, Enterprise Portal Deployment, Development and Customization, Content Management Design and Implementation, Legacy Application Development, Integration and Migration, and Business Process Management. VIVA has implemented, and continuously updated, the enterprise security framework for over 200 applications. VIVA provided solutions to resolve gaps in security; and provided architecture and infrastructure guidance for these applications (SOA, J2EE, Web and/or WebSphere based). Security framework around these applications was developed using SAML Tokens, Spring Security, LDAP, Single Sign-on, JAAS, and DataPower. VIVA resources have worked on the design and development of Java-based applications for Quote Management. This application is used by over 5000+ users who are agents of the client to create quotes for prospect companies. Application is developed using Webservices, Spring, Spring Security, MVC, JDBC. The database is MS SQL Server and RAD (IDE) is used for development. VIVA has been involved in the development of external, public facing pages, wireframe, predetermined page templates, and content management using TeamSite. VIVA developed and edited mockups, visual designs, and images based on wire frames provided. VIVA resources interacted with information architects, content editors, and front-end developers, usability experts, analysts, and worked closely with business owners to establish requirements.

#AutomotiveClient

VIVA’s primary services for this client include Application Development and Support, Windows Server Administration.

Overview

VIVA’s primary services for this client include Application Development and Support, Windows Server Administration Support, Network Administration, Help Desk Support, Portal Configuration and Maintenance, Testing Services, Project Management, and Database Administration Support Services. VIVA resourced were responsible for WebSphere/Portal Administration, customization, and build. VIVA deployed and supported applications into a WebSphere Application Server v.5.0 and V5.1 and WebSphere Portal Server v5.1 environment.

Responsibilities

  • Installation and configuration of WebSphere Application Server v5.0, v5.1, and v6.0 and WebSphere Portal Server v5.1 and v5.1.0.1 running on Windows 2003
  • Setting up WebSphere Clusters using Network Deployment for both WebSphere Application Server and WebSphere Portal Server Configuring and troubleshooting Java applications running in WebSphere Application Server and WebSphere Portal Server Deploying applications, configuring the webserver, troubleshooting, and supporting the infrastructure
  • Installation, configuration, and application migration responsibilities for a shared WebSphere Application Server and WebSphere Portal server environment which runs multiple versions of WebSphere Application Server and WebSphere Portal Server
  • VIVA's team was also involved in the Windows Server Administration and SharePoint Administration Support Services. The user base that uses SharePoint Portal is around 14,000. Services SharePoint 2007
  • Installation and Configuration SharePoint Administration Support Services — Portal Maintenance, Backup/Restore services, performance tuning, site maintenance, SharePoint web application development and many other services
  • Windows Server Administration
  • Implemented Google Search Appliance and integrated with the SharePoint site Implemented HP Site Scope
  • Enhanced Configuration Management of Windows server, including Exchange, IIS, and SharePoint Services as well as failover clusters
  • Performed Web Trend Analysis with Google Web Analytics
  • Performed SharePoint Migration from MOSS 2003 to MOSS 2007
  • Researched emerging SharePoint technologies and analyzed if those new technologies could be implemented

#StateAndLocalGovernment

VIVA’s primary services included web application development and support, portal configuration and maintenance, testing services, project management and Database Administration support services.

Overview

VIVA’s primary services included web application development and support, portal configuration and maintenance, testing services, project management and Database Administration support services. VIVA's team has developed several web applications using Microsoft Technologies like SharePoint, Microsoft .Net, and SQL Server 2005. VIVA's team was involved in SharePoint 2007 installation and configuration. The State Agency is required to collect and store the payroll reports of grantees as part of the ARRA fund allocation. The SharePoint Site for the Agency has been designed to collect and store the payroll reports for each grantee under their document library. The collected payroll details are validated for the minimum wages, and approval of the form is based on all those validations having been met. The SharePoint website was developed using MOSS 2007, and by using the tools like SharePoint Designer 2007. The SharePoint site has been integrated with Active Directory. The users are being created using Active Directory and added into the SharePoint Site. A custom view page was designed for each grantee to track their payroll details and approval status. For each grantee, a separate security group was created, and permissions are controlled based on the group. The minimum wage details for each work classification are being maintained using SharePoint list. Also, a separate list was created for each grantee to maintain their employee list. The grantee can view and modify their payroll form until it is approved by the State Agency. A workflow feature within the SharePoint website allows the State Agency managers to approve the payroll changes.

Responsibilities

  • SharePoint Administration Support Services — portal maintenance, backup/restore services, performance tuning, site maintenance, SharePoint web application development, and many other services.

Quality Assurance

Service Oriented Architecture

#QualityAssuranceServices

VIVA has provided quality assurance and service oriented architecture services for many projects with serval entities in both the public and private sector

Overview

VIVA has provided quality assurance and service oriented architecture services for many projects with serval entities in both the public and private sector. Please contact us for details

#TelecommunicationsClient

VIVA resources were responsible for supporting the client's technical services team that span client and web test environment installations

Overview

VIVA resources were responsible for supporting the client's technical services team that span client and web test environment installations.

Technologies Used

  • Cognos (ReportNet and dashboards, Impromptu 7.1/7.0,6.x, Transformer, PowerPlay 7.1/6.6, IWR, Upfront, PowerPrompt, Access Manager, Script Editor)
  • Business Objects ((BOE Universe Design, Migration, Adhoc Query and Analysis, WEBIntelligence, OLAP Intelligence, Crystal Reports, Crystal Xcelsius, Scorecards, Dashboard Manager)
  • Hyperion (Hyperion 9.2, Hyperion System 9 BI Interactive Hyperion (Hyperion 9.2, Hyperion System 9 BI Interactive Reporting Studio, Hyperion Interactive Reporting WebClient, Upgrade of Brio reports and Hyperion System 9 from older version 6 or 8.5)
  • Brio Enterprise Suite (6.6.4)
  • MicroStrategy 7/8
  • IBM Websphere DataStage
  • Ab Initio
  • Oracle
  • Microsoft SQL Server (SSAS, SSRS, SSIS)
  • Informatica ETL
  • Teradata/SQL Assistant
  • Attachmate Extra Enterprise 2000
  • ERWIN, VISIO

Quality Assurance
Join VIVA and grow

VIVA is faster, easier and you still have complete control