Open Sistemas

Within the specific field of action of the Tax Agency Open Sistemas develops a project of analysis, comparison and selection of OLAP engines based on a study of this institution casuistry, which is the low time of response in a data query from the users and a massive quantity of information looked up.

• Identified Demand / Problem

  • Identify an optimum solution of OLAP motor
  • High requirements on capacity and space and limitation on database design
  • Final response time under 1 second

• Description

  • High sizes for standard databases
  • Lack of specific tools

• How the problem was solved

  • Consultory and analysis of problem at a business and technical level
  • Identification and selection of tool
  • Analysis of optimum data model and valuation Mondrian / SyBaseIQ

• Business outcome

  • Optimum tool selection
  • Implantation process

Open Sistemas developed the Agrastat platform for Merck. The goal of the pharmaceutical company deploying this platform was to be able to assure an optimized system, that will allow them to have customized reports and statistics whenever required.

• Identified Demand / Problem

  • Count with a platform for medical data exploitation
  • Lack of homogeneity in data retrieval and reports
  • Low attractive graphical reports

• Description

  • High business knowledge is required
  • Great heterogeneity between different studies and reports

• How the problem was solved

  • Medical testing platform design
  • Global design of reports
  • Implementation of a tool for generating business reports

• Business outcome

  • Platform capable of hosting different testings
  • BI system of medical data  exploitation

Open Sistemas developed for the Hospital de Oviedo, together with the company Medtronic, a software used for data retrieval for studies with patients with aortic prosthesis. The project was based in the product "Clinical Studies DataMed", developed by Open Sistemas.

• Identified Demand / Problem

  • The study group of Central Hospital in Oviedo needs to gather aggregated information of patients with aortic prosthesis

• Description

  • Study Director had participated in previous studies with Open Sistemas and wanted to imitate the model and technologies previously used.
  • Include information from geographically disperse researchers

• How the problem was solved

  • Development with Adobe Flex that allows RIA applications (Rich Internet Applications)
  • Exhaustive control of required fields to complete a patient
  • Parallel management application to manage hospitals and researchers (amongst others).

• Business outcome

  • Shared data through graphics, to motivate researchers
  • Big participation in the study

Pedro de Valdivia High School needed to update their customer management system, improving and optimizing their tools. They reached out to Open Sistemas that solved this need using an open source environment.

• Identified Demand / Problem

  • Need of a centralized control of customers at a national level using a tool that is extensible and adaptable to the organization

• Description

  • Customer management system
  • Customer control of the different offices of the institution throughout the country

• How the problem was solved

  • Opensource CRM deployment
  • Customized solution based on SugarCRM that provides flexibility and ease of use
  • Personnel training

• Business outcome

  • Improvement in internal management and service quality
  • Real time information to support decision taking

The Spanish Tax System Agency, and in particular the Information and Investigation Against Fraud Department, characterized by the management of massive information and the need of highly restrictive response times, required a software solution developed at a very low level, with a team with a huge knowledge on Linux operation and development in C and C++ environments.

• Customer challenge / Problem

  • Necessity to provide near real time information to users
  • Bad scalability and security

• Description

  • Complex low level programming under Linux needed
  • Very Large Databases

• How we solved the problem

  • An experienced linux programming team
  • A senior DBA to analyze and make migration to Sybase IQ
  • A team of System Admins experienced in large IBM systems

• Positive business outcome

  • Reduced 200 times the response time to the user
  • Reduced downtime to almost 0