Open Sistemas

In Gandia's Hospital, Open Sistemas developed a prototype consisting on a solution for medical appointment on stands installed in the dependencies of the hospital, through which the patients, without any help of the hospital's personell, could manage their appointments for the hospital's consultations independently.

• Identified Demand / Problem

  • Automate patient appointment management in external consultation.
  • Improve efficiency of administrative service
  • Diminish overcrowding of  waiting rooms and corridors

• Description

  • Linux environment embedded in hardware device
  • Development in Spring environment on Jboss with web client

• How the problem was solved

  • Self service stand with Linux embedded and access with health system card
  • Easy management and receipt delivery of appointment with doctor
  • Patient selects easily through an agenda

• Business outcome

  • Drastic decrease of queues and waiting periods
  • Better efficiency in the use of resources and innovative image

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

Within the project scope Open Sistemas develops for Iavante different works related with technology innovation environments and R+D in Technology and Health.

• Identified Demand / Problem

  • Need to improve the definition of the positioning of the institution
  • Need to find the best ways of communication in an innovation environment

• Description

  • Iavante is a foundation oriented to technology innovation in heath
  • Communication and strategy fields present a particular case in innovation

• How the problem was solved

  • Consulting team with experience in health and technological innovation
  • Open source related technologies and strategies application
  • Combined communication strategies design

• Business outcome:

  • Perceived positioning improvement
  • Communication proceedings improvement

The project Sanos was defined within the scope of the Health Agency from Valencia as an Open Source Migration office, through which new projects and technologies are analyzed and the feasibility of being tackled through open solutions is studied, or the analysis of migration to open source of existing projects and infrastructures.

• Identified Demand / Problem

  • Analyze the suitability of open software to migrate systems
  • High cost on massive deployments
  • Application on hospital environments

• Description

  • Big environments with massive deployments
  • Very heterogeneous environments

• How the problem was solved

  • Technical team expert in open source and Linux solutions
  • Migration consulting works development
  • Diverse matters: virtualization, data bases, e-learning

• Business outcome

  • Drastic decrease of license cost
  • Guidelines creation and homogeneity

One of the projects developed by Open Sistemas for the UNED had as an axis their aLF Platform. The University wanted to improve their online platform, optimizing the availability, the frequency of the communication with the customer and their campaigns.

• Identified Demand / Problem

  • Provide support to the platform and new features development
  • Focus on online formative content quality
  • Content errors, navigation and accessibility problems

• Description

  • Databases not updated and information segmentation
  • Lack of specific tools

• How the problem was solved

  • Technical support team for aLF/openACS platform with dotLRN
  • Software development and adaptation to aLF platform
  • Development of Quality Project in online training

• Business outcome

  • Improvement of content quality
  • Decrease of content issues

The Regional Association of Popular Universities of Extremadura (AUPEX) needed to deploy projects in Ajax and Squeak. These technologies are valid in multiple platforms and operative systems, as they are based in open standards like JavaScript and DOM. These need oriented the execution to several training courses in this environment.

• Identified Demand / Problem

  • Plan, design and execute formative courses around Linux technologies
  • Impart specifically Ajax and Squeak courses as innovative technologies for education

• Description

  • Courses and contents designed depending on student type, timetables, means and availability
  • Training is supported with an online model

• How the problem was solved

  • Design and deployment of customized courses
  • Subsequent follow up
  • Blended learning model, with wide support of elearning systems

• Business outcome

  • Extremadura one of the biggest Squeak communities in the world
  • Use of Squeak in education for content generation

The project consisted on the implantation, starting and training of a Moodle environment for the Inspección de Consumo of the Junta de Extremadura, together with the hosting and subsequent support of the platform.

• Identified Demand / Problem

  • Demand of a Moodle service via SaaS
  • Reliability and scalability to thousands of users

• Description

  • Corporative environment. Service of Inspection and Consumption
  • Initial training, documentation, support

• How the problem was solved

  • LAMP environment Xen virtualized
  • Moodle deployment, documentation and training
  • Support and control service

• Business outcome

  • Moodle SaaS service active for Junta Extremadura

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

Mercamadrid needed to adapt the corporate web site to the new functionalities that it required, and to offer a renewed image of the corporation. This led them to hire Open Sistemas to develop a dynamic content portal, with a renewed and attractive image.

• Identified Demand / Problem

  • Mercamadrid has the need to update its corporate web site, with new functionalities and image

• Description

  • Integration with the rest of the information systems
  • Interaction with the user, searching for the accepted web 2.0.
  • Private and restricted zones

• How the problem was solved

  • A CMS will be used to provide flexibility to contents
  • Private and secure areas are created for board of directors and customers
  • Integrations with statistics data bases, credentials and Mercamadrid customers

• Business outcome

  • Customer autonomy to manage its contents
  • Renewed corporative image

Mercamadrid Tecnológico needed its own site in the internet, to provide them with identity. Open Sistemas solved the problem developing a web site using an open source content management application and creating a design that has allowed Mercamadrid Tecnológico to show to the public the information and contend that its business generates.

• Identified Demand / Problem

  • The new division Mercamadrid Tecnológico (buys oils, flowers, wines and dairy products) needs a corporative portal different to www.mercamadrid.es

• Description

  • New portal requires a Look&Feel aligned with the corporation
  • But also a modern and fresh design
  • It must be a dynamic site with new updated contents

• How the problem was solved

  • It is decided to use a CMS to give flexibility to the contents
  • OMOI, a company from the group, creates a design approved by the customer
  • Integrates design and usability recommendations with the open source content management leader: Joomla

• Business outcome

  • Autonomy in content management
  • Renewed corporate image