Automatization opens business opportunities and other advantages to Banco Votorantim
The Bank used spreadsheets and systems for data extraction and collection, which was no longer viable given the volume of information. With automation, they were able to deliver analytical and business-driven results.
Situation
Automation of repetitive manual tasks
In 2017, there was a complex scenario in which the bank used various spreadsheets and systems for data extraction and collection. This scenario required a great deal of manual effort and a lot of time.
The need to keep up with new technologies, connecting to more data sources, through product logs and databases, to expand the scope and performance of the area, demanded more from the team. With the increasing volume of information, it was no longer possible to support this data in spreadsheets, until then used to consolidate, make adjustments and projections.
Solution
Automated collecting, instrumented load testing robots and data cleaning
Predictor was implemented. With it, it was possible to automate the gathering of data, load testing and data cleaning. The tool made it easy to centralize information, increasing the scope of the technologies and components monitored, as well as reducing operational effort, directing the team's performance towards increasingly analytical and business-focused deliveries.
To complete the implementation, which lasted about 03 months, it was required six employees: three operations, one project, one database and one manager. The bank's investment generated around R$ 450 thousand.
R$1 million in database disk idle opportunities was quickly identified
Marcelo Maylinch, IT Coordinator - Capacity Planning and Infrastructure Projects at Banco Votorantim.
Benefits
1-day data collection, greater insight and significant cost savings
We can mention a few benefits:
R$ 1 million in idle disk opportunity was quickly identified in databases
We increased by 300% the support performance with weekly FUP on monitored items;
Time it to compose monthly executive reports document reduced from 13 to 1 day;
Today it's possible to project the whole infrastructure in 24 hours.
In addition, there was a reduction of staff, about 547 hours per month and reduction of overtime.
Testimonial
Park projection in less than 24 hours and efficiency at 99.13%
"As a strategy of operation, we mapped all manual processes, which were prioritized and automated according to time and effort of delivery, adding efficiency from day one."
"Currently, Banco Votorantim has: 3,950 configuration items, distributed among data center, facilities and infrastructure and servers; 1,338 servers; 21,679 file systems, distributed among 12 frames; 2.76 peta bytes; 82 database instances, which have more than 2,500 components collected; more than 1 million records stored per day, which add to a historical base of more than 3 years. Today, we project 100% of this park in less than 24 hours, predicting 730 days ahead. In the last 6 months, we have carried out more 1,331 preventive recommendations, avoiding incidents in production resulting from growth trends, changes in behavior influenced by business or systemic demands and deviations due to adverse causes. This performance guarantees us an efficiency rate of 99.13%."
About Banco Votorantim
Banco Votorantim is currently one of the largest Brazilian banks in assets and has a robust shareholder base, formed by a strategic partnership between Banco do Brasil, the largest financial institution in the country, and Grupo Votorantim - one of the largest private conglomerates in South America.
Founded in 1988 as a securities distributor (DTVM), Banco Votorantim S.A. started operating as a multiple bank since 1991.
Historically, it was primarily active in the wholesale, treasury and investment segments. In recent years, Banco Votorantim has grown and broadened its scope, seeking to increase its revenue and asset base through a diversified portfolio of businesses, internally classified as Wholesale and Retail.
