we solve / Some of our success cases

Objectives

Develop an analytical platform capable of processing the different data formats coming from a multitude of sources, both batch and in real-time, constituting the service layer for the information platforms of the whole group.

Our work

Construction of the analytical platform based on the requirements agreed with the bank using cloud infrastructure and a distribution of open source components with which information is ingested and processed, providing detailed governance and monitoring of the data.

Results

Rapid response to several of the problems and business needs that the bank had raised, demonstrating the immense possibilities offered by Big Data infrastructures with the use of open source components.

Objectives

Implementation of an analytical solution to standardise and optimise the recommended sales price levels in a way that would improve the company's profits.

Our work

1. Preparation, transformation and consolidation of transactional data of the company.
2. Creation of analytical algorithms for customer segmentation, price standardisation and recommendation of prices to B2B clients.
3. Creation of reports and analytical explorations for use by end users.

Results

Proposal of global prices by which greater benefits are obtained compared to previous years.

Objectives

Develop consolidation and analysis processes for information available from the client’s transactional systems in order to extract business value throughout the entire life cycle of the data in the exploration sector.

Our work

1. Development of ETL processes for the overall consolidation of information.
2. Preparation of data so it can be used by analytical users.
3. Creation of reports with analytical and reporting tools for business users.

Results

Make consolidated information available for use and analysis and to be able to perform data discovery actions on the data that would allow the exploration processes to be improved.

Objective

Make all human resources information immediately available in order to using the data in predictive and prescriptive analytics for each of its processes.

Our work

1. Analyse, the different data source systems from the technological point of view in order to determine the needs of the technological platform and define its architecture.
2. Install and put into production Big Data architecture components under Cloudera distribution on the Amazon Web Service cloud platform, which unifies the information from all human resource systems providing the data, both universal to the group, and local to each country.
3. Creation of an analytical repository through a complex preparation of the data in order to serve various analytical tools such as Tibco Spotfire, R Studio and SAS.

Result

Installation of a platform with centralised human resource information, with high performance, scalable processing and with multiple analytical possibilities.

Objective

Carry out the integration and centralisation of data from different departments in the company so that it can be used for decision making by the business departments.

Our work

We install Informática PowerCenter ETL systems and help integrate the information from all your systems. In addition, we programme and monitor the processes using planning tools.

We currently provide a 360° service, in which we analyse, develop and manage projects in the field of global technology.

Results

We achieve the centralisation of the company's information and develop its entire business intelligence system for decision making.

Objectives

Development of an unmanned automated inspection vehicle into which data capture systems and information treatment elements are integrated for the corrective and preventive maintenance of tunnels and critical infrastructure of the high-speed rail network, ensuring complete safety of the same.

This is a research project, with FEDER Interconnecta and CEDETI funds, in which a consortium of 6 companies are participating: Alstom, Adif, Ferrovial, Vias, Insitu and Tinámica.

Our work

Development of the analytical infrastructure capable of ingesting, processing and allowing the use of all the data received by the different sensors on the vehicle, providing alarms for any issue that violates normality. Tinámica developed the project using cloud infrastructure due to its high availability and scalability.

Result

Automated vehicle able to collect data from multiple sensors in real time for subsequent interpretation and analysis in order to monitor the status and maintenance of tunnels and critical infrastructure of the high-speed railway network. Reduces maintenance costs by 80% and improves decision making by 35%.

Objectives

1. Develop an analytical platform to centralise the entire business of En in Latin America (Brazil, Colombia, Chile, Peru and Argentina) to unify all existing analytical ecosystems providing a faster, more consistent analysis and one closer to the business.
2. Develop advanced analytical projects for the different countries and companies of En, on this platform, adding value and enhancing the business of each country, while allowing those assets to be re-used.
3. Maintenance and Support for all current business intelligence and advanced analytics infrastructures.

Our work

Business and use analysis of each country and subsequently the construction of the proposed solution using a cloud infrastructure and a Big Data architecture that would allow the ingestion, processing and use with all types of analysis tool such as Spotfire, Salesforce, R-Studio, etc.

Result obtained

The result has been a centralised platform where the Enel users in all Latin American countries have their data available and can make use of it, using all the same tools and accessing the data, from its most raw form through to the most highly processed.

Objective

Improve flexibility and speed for the incorporation of data sources (internal and external) and analytical models into the area of customer intelligence in order to make commercial campaigns more effective.

Our work

1. Development of new processes on SAS and Big Data environment (Spark/Hadoop).
2. Advanced analytical services for the implementation of new customer models (value, purchase propensity, churn, etc.).
3. Integration of new sources of internal and external data, to enrich the analysis.
4. Application of new Big Data architectures and advanced analytics, as well as new machine learning analytical tools, both with SAS technology and with other open source technologies.

Results

Better response times in commercial campaigns through a more efficient and flexible service.

Objectives

Comply with management and risk reduction regulations that affect the insurance sector (Solvency II), at the same time as obtaining information and tools to improve the overall management of the company.

Our work

1. Definition of data governance: semantics, traceability, control, unique data, etc.
2. Services of analysis, development and maintenance of data intake processes from various transactional applications of the company using Oracle ETL tools.
3. Services of analysis, development and maintenance of reports and management dashboards for operational functions and for management, using IBM-Cognos tools.
4. Design and implementation of data masking mechanisms and tests on large volumes of data.

Results

Effective implementation of data governance, comprehensive data traceability and risk control, complying with the Solvency II regulations. Production of management reports and alerts for the management, as well as business control and monitoring reports.

Objectives

To have all the relevant information related to the client available in a single point for its analytical use and implementation of more segmented and effective marketing actions.

Our work

1. Identification and analysis of various internal and external data sources relating to the customer.
2. Design and creation of an analytic Data Mart of customers.
3. Design and construction of data ingestion processes for the analytical Data Mart of customers using SAS technology.
4. Design, construction and implementation of analytical visualisation reports and models using SAS technology.
5. Design, construction and implementation of marketing campaigns with high customer segmentation.

Results

Customer analytic and segmented marketing solution, which improves the effectiveness of marketing actions, customer loyalty with an increase in sales and profitability for the company.