Sabesp, one of the largest basic sanitation companies in the world, hired NalbaTech with the objective of promoting improvements in data management in SAP ERP. For the project, the Innowera platform was implemented, designed to map, update and integrate data from different sources.

Sabesp’s objective was to have a comprehensive solution to make improvements and new features in data management in ERP without the need for major investments in development and customizations in the SAP system.

Preparing for eSocial was the first stage of the project and involved cleaning up the data of more than 17 thousand company employees.

In January 2018, the second stage began, involving immobilization.

Based on the ability of the Innowera tool to sanitize and manage data with management systems and the proximity of the eSocial effective date, Sabesp opted to start by treating and preparing employees’ social security and labor information.

“We put the platform to use very quickly and found that 41% of employees had some inconsistency in their registration, which could have a major impact on the material to be sent to eSocial, which could generate considerable delays and fines,” says Carvalheiro.

The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adaptation of employee data for reloading in SAP.

“Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro.

Sanitation and data comparison, pointing out errors for correction according to the rules and layout of e-Social (which has about 200 fields for each employee), as well as for any other legal and business obligations, are among the biggest benefits , according to him.

Sabesp serves 367 municipalities in the State of São Paulo, benefiting more than 27.7 million people with water supply and 21.4 million people with sewage collection.

Earlier this month, the company announced another project developed with support from Nalbatech.

Sabesb contracted the company’s managed services to detect vulnerabilities and security flaws in software applications during its own or third party application development. The initiative focuses on the use of the BugScout platform.

eSocial is the first project and will guarantee the quality of the information to be delivered within the legal deadline. Data for 41% of employees with record inconsistencies were corrected in record time

Sabesp, one of the largest basic sanitation companies in the world, serving 367 municipalities in the State of São Paulo, benefiting more than 27.7 million people with water supply and 21.4 million people with sewage collection, contracted NalbaTech to promote improvements in data management in the SAP management system, from the implementation of the Innowera platform, designed for mapping, updating and integrating data from different sources and with a strong specialization in SAP.

The choice of the Innowera tool meets a need by Sabesp, which sought a comprehensive solution to make improvements and new features in data management in the management system, without the need for major investments in ERP development and customization. Nalbatech was selected for the project because it has a team of specialists in the Innowera solution and with a high capacity to understand the company’s needs related to the extraction, sanitation, preparation and import of data from various sources into SAP.

Nalbatech was selected for the project because it has a team of specialists in the Innowera solution and with a high capacity to understand the company’s needs related to the extraction, sanitation, preparation and import of data from various sources into SAP. The second stage will involve the immobilization of assets and will start in January 2018, as informed by Ricardo Carvalheiro, manager of the Information Systems Department (CIS) at Sabesp.

Data sanitation for eSocial

Based on the high capacity of the Innowera tool to sanitize and manage data with management systems and the proximity of the eSocial entry into force date, Sabesp chose to start by treating and preparing employees’ social security and labor information. “We put the platform to use very quickly and found that 41% of employees had some inconsistency in their registration, which could have a major impact on the material to be sent to eSocial, which could generate considerable delays and fines,” says Carvalheiro.

According to him, “carried out in a few weeks, this work for eSocial was a great success, both because of the fast time and the results. The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adequacy of employee data for reloading in SAP, greatly reducing the working time of Human Resources teams. Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro.

According to him, “carried out in a few weeks, this work for eSocial was a great success, both because of the fast time and the results. The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adequacy of employee data for reloading in SAP, greatly reducing the working time of Human Resources teams. Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro. “We are satisfied with the results and prepared for new challenges. In addition, with the expertise and experience of the NalbaTech team, it was possible to solve complex problems, by mapping needs and delivering a project very quickly ”, comments Sabesp’s CIS manager.

SAP Security Rules

Another factor that weighed in the choice of the Innowera solution, according to Carvalheiro, was the platform’s specialization in the SAP environment, its ability to meet the security rules of the management system, such as consistencies and access profiles, for example. “This guarantees the safe execution of the processes and reduces the need to replicate these rules outside the ERP. The solution eliminated the manipulation and maintenance of data carried out manually by users, which led to error-prone processes and exhaustive tasks, in addition to affecting the security and quality of the data ”.

Another great benefit obtained: better decision making

Sabesp promotes improvements in the data management of the SAP solution with the support of Nalbatech.

Sabesp promotes improvements in the data management of the SAP solution with the support of Nalbatech.

SABESP, one of the largest basic sanitation companies in the world, which serves 367 municipalities in the State of São Paulo, benefiting more than 27.7 million people with water supply and 21.4 million people with sewage collection, contracted NalbaTech to promote improvements in data management in the SAP management system, from the implementation of the Innowera platform, designed for mapping, updating and integrating data from different sources and with a strong specialization in SAP.

According to the company, the choice of the Innowera tool meets a need by Sabesp, which was looking for a comprehensive solution to make improvements and new features in data management in the management system, without the need for major investments in development and customization in ERP. Nalbatech was selected for the project because it has a team of specialists in the Innowera solution and with a high capacity to understand the company’s needs related to the extraction, sanitation, preparation and import of data from various sources into SAP.

The preparation for the eSocial was the first stage of the project and involved the sanitation of data of more than 17 thousand employees of the company, taking into account the need for the correct sending of data and within the deadlines established for the Digital Obligation Bookkeeping System Tax, Social Security and Labor. The second stage will involve the immobilization of assets and will start in January 2018, as informed by Ricardo Carvalheiro, manager of the Information Systems Department (CIS) at Sabesp.

The company points out that, based on the ability of the Innowera tool to sanitize and manage data with management systems and the proximity of the eSocial effective date, Sabesp opted to start by treating and preparing employees’ social security and labor information.

“We put the platform to use very quickly and found that 41% of employees had some inconsistency in their registration, which could have a major impact on the material to be sent to eSocial, which could generate considerable delays and fines,” says Carvalheiro.

According to him, “carried out in a few weeks, this work for eSocial was a great success, both because of the fast time and the results. The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adequacy of employee data for reloading in SAP, greatly reducing the working time of Human Resources teams. Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro.

Sanitation and data comparison, pointing out errors for correction according to the rules and layout of e-Social (which has about 200 fields for each employee), as well as for any other legal and business obligations, are among the biggest benefits , according to him. “We are satisfied with the results and prepared for new challenges. In addition, with the expertise and experience of the NalbaTech team, it was possible to solve complex problems, by mapping needs and delivering a project very quickly ”, comments Sabesp’s CIS manager.

Another factor that weighed in the choice of the Innowera solution, according to Carvalheiro, was the platform’s specialization in the SAP environment, its ability to meet the security rules of the management system, such as consistencies and access profiles, for example. “This guarantees the safe execution of the processes and reduces the need to replicate these rules outside the ERP. The solution eliminated the manipulation and maintenance of data carried out manually by users, which led to error-prone processes and exhaustive tasks, in addition to affecting the security and quality of the data ”.

Osvaldo Antonio Pazianotto, CIO of Sabesp, comments that, as desired, the Innowera solution proved to be quite adherent to Sabesp’s business processes, delivering many benefits and, mainly, avoiding customizations and developments in the SAP ERP platform, which are complex and have high cost.

“Decision making is also benefited by the possibility of approving forms in real time directly on cell phones and e-mail, and reports obtained via extraction and connection between tables mapped within SAP make it easier to meet demand in record time. The benefits with Innowera and support from NalbaTech, are enormous. It is now possible to carry out more careful and analytical analysis of business information ”, he adds.

SABESP, one of the largest basic sanitation companies in the world, serving 367 municipalities in the State of São Paulo, hired NalbaTech to promote improvements in data management in the SAP management system, from the implementation of the Innowera platform, designed for mapping, updating and integration of data from different sources and with a strong specialization in SAP.

The choice of the Innowera tool meets a need by Sabesp, which sought a comprehensive solution to make improvements and new features in data management in the management system, without the need for major investments in ERP development and customization. Nalbatech was selected for the project because it has a team of specialists in the Innowera solution and with a high capacity to understand the company’s needs related to the extraction, sanitation, preparation and import of data from various sources into SAP.

Nalbatech was selected for the project because it has a team of specialists in the Innowera solution and with a high capacity to understand the company’s needs related to the extraction, sanitation, preparation and import of data from various sources into SAP. The second stage will involve the immobilization of assets and will start in January 2018, as informed by Ricardo Carvalheiro, manager of the Information Systems Department (CIS) at Sabesp.

Data sanitation for eSocial

Based on the high capacity of the Innowera tool to sanitize and manage data with management systems and the proximity of the eSocial entry into force date, Sabesp chose to start by treating and preparing employees’ social security and labor information. “We put the platform to use very quickly and found that 41% of employees had some inconsistency in their registration, which could have a major impact on the material to be sent to eSocial, which could generate considerable delays and fines,” says Carvalheiro.

According to him, “carried out in a few weeks, this work for eSocial was a great success, both because of the fast time and the results. The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adequacy of employee data for reloading in SAP, greatly reducing the working time of Human Resources teams. Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro.

According to him, “carried out in a few weeks, this work for eSocial was a great success, both because of the fast time and the results. The Innowera tool also allowed the construction of macros in MS-Excel to facilitate the correction and adequacy of employee data for reloading in SAP, greatly reducing the working time of Human Resources teams. Activities that would take several months were carried out in a few days. As a result, we had a significant reduction in costs and time ”, points out Carvalheiro. “We are satisfied with the results and prepared for new challenges. In addition, with the expertise and experience of the NalbaTech team, it was possible to solve complex problems, by mapping needs and delivering a project very quickly ”, comments Sabesp’s CIS manager.

SAP Security Rules

Another factor that weighed in the choice of the Innowera solution, according to Carvalheiro, was the platform’s specialization in the SAP environment, its ability to meet the security rules of the management system, such as consistencies and access profiles, for example. “This guarantees the safe execution of the processes and reduces the need to replicate these rules outside the ERP. The solution eliminated the manipulation and maintenance of data carried out manually by users, which led to error-prone processes and exhaustive tasks, in addition to affecting the security and quality of the data ”.

Another great benefit obtained: better decision making

Osvaldo Antonio Pazianotto, CIO of Sabesp, comments that, as desired, the Innowera solution proved to be quite adherent to Sabesp’s business processes, delivering many benefits and, mainly, avoiding customizations and developments in the SAP ERP platform, which are complex and have high cost.

“Decision making is also benefited by the possibility of approving forms in real time directly on cell phones and e-mail, and reports obtained via extraction and connection between tables mapped within SAP make it easier to meet demand in record time. The benefits with Innowera and support from NalbaTech, are enormous. It is now possible to carry out more careful and analytical analysis of business information ”, he adds.

Nalbatech is present at Data Innovation, which promotes a meeting designed for innovators and instigators of change in the area of Information Technology.

The world is hyperconnected. The proof of this is that a recent study by the Business Software Alliance (BSA) showed that2.5 quintillion bytes are created every day and that, 90% of the data that exists today, in the world, was generated in the last two years. The trend is that, every two years, the world will double the rate of production of this data.

And today was the day of our CE, Francisco Bernabeu, to speak with Case Sabesp, building applications using RPA in SAP.

The bugScout platform, developed by Nalbatech, has been a partner of the information security team of the basic sanitation company Sabesp, which serves more than 300 municipalities in the State of São Paulo. The tool detects vulnerabilities and security flaws in software applications during its own development or that of third-party applications, to ensure the adequacy of the systems to the company’s policies.

Since 2014, when the project was started, any new system that enters the company’s data center has been subjected to a rigorous analysis of source code to detect vulnerabilities. More than 1,000 applications have already been analyzed and the flaws most found in third-party applications are related to the exposure of sensitive information, weak encryption, breach of trust limits and basic errors in the source code.Daniel Bocalão, Manager of the Connectivity and Information Security Department – (CIC) at Sabesp, explains that the project started four years ago with a first version that evaluated only security requirements. At the end of last year, with an update, the tool also started to analyze the quality and performance of each new application.

“Any request for improvement of the system module that arises because of a regulation or law, for example, goes through the solution”, comments the executive, in an interview with Computerworld Brasil.

Sabesp’s IT infrastructure is composed of a considerable variety of systems to serve various internal and external processes. In field operations, Internet of Things (IoT) devices collect in real time the data on water and sewage services delivered to the population, which involves the identification of consumption, changes or deviations in the consumption pattern, leakage potential, among numerous other variants, producing a large amount of data that needs to be protected. In addition, the company has administrative management systems, such as billing, CRM, asset control, supplies and HR – all pass the vulnerability tests required by the company.

Bocalão comments that the main advantage is knowing the risks before production. “We were able to anticipate vulnerabilities and fix them at the time of development. The results are intangible, as we are able to show the supplier that he is vulnerable and avoid problems in the future. The feeling is that we are safer ”, he adds.

TmaxSoft, a Korean multinational company providing software for IT infrastructure, and Nalbatech, a Spanish multinational company providing IT solutions, announce the renewal of their contract with Sabesp.

As a result of bidding, the negotiation enables the supply of Tibero, TmaxSoft’s database, with the objective of supporting the applications of the legacy environment and the migration of new applications to this environment. Sabesp contracted Tibero Enterprise Edition 6.0 and Tibero Active Cluster (TAC) licenses. The investment in the technological solution in 2016 was over R $ 2.3 million and for 2017 the value is R $ 3.3 million.

Developed internally by Sabesp’s Collection Department, the SIC system started operating in 2000, based on a database that, until then, had met the company’s demands. Over the years, new features needed to be included, which required the evolution of the adopted solution that no longer supported them. Even because it is an old version, the database no longer had the technical support of the manufacturer, a feature that represents a great risk for the company.

Sabesp decided to start a bidding process for the migration of the environment and, in 2016, the company opted to update the database by opening a bidding process which Tibero won. After one year of using the TmaxSoft database TmaxSoft, Sabesp identified the success and stability of the SIC, as there was no impact whatsoever, which provided a security environment to be able to migrate other applications.

Taking into account this positive scenario with the acquisition of the TmaxSoft solution, after one year, Sabespdecided to migrate more systems and increase the Tiberoenvironment by hiring new licenses. In fact, the company opted for a high availability environment when using the Tibero Active Cluster (TAC), which provides business continuity without risks and with high performance.

The solution hired by Sabesp is a new database option for the Brazilian market, as it has local support, integration with other suppliers’ versions, lower cost and quick migration.

Nalbatech, TmaxSoft do Brasil’s business partner, was the winner of Sabesp’s bidding process and was responsible for supplying licenses, implementing and supporting the Tibero project on the company’s systems.

Nalbatech carried out the total migration of data to Tibero in just 1h30, without risks or major changes in the codes and with the SIC running at full performance.

In addition to enabling the evolution of the system and having the technical support sought by the company, the solution offers the possibility of simplified and accessible virtualization, another objective of the Sabesp team. The solution allows virtual environment licensing without the need for physical environment licensing,which reduces costs, since there is no need to invest in hardware and new licenses. This is a differential of TmaxSoft compared to other options on the market. In short, the adoption of Tibero brings several benefits such as:

• Support the maintenance of the proposed environment,
• Modernization of the current, increased availability,
• Database compatibility with the application,
• Systemic evolution,
• Reliability of the environment and functioning of migrated applications,
• Data migration with security and in an integral and
• Implementation of the monitoring tool (considering alerts and preventive actions for environmental management).