Hello! I'm Herbert Fernando, I'm a Business Intelligence Analyst, BI Consultant and Big Data Analyst.Experience in data modeling, Data Engineering, ETL, building Dashboards and management reports.
I have worked in Oracle / Mysql database and MongoDB, DynamoDB non-relational database, in my current experience I work only with Microsoft SQL Server. Knowledge also in Cloud for big data with Google Cloud and Amazon AWS, and Azure DataBricks.
I also have strong skills with Linux (Red Hat and Ubuntu), Shell Script Development, Mobile and Web Development (Java, NodeJS, C # .NET and currently improving Python)
Main domain in the tools: ETL: Talend, Pentaho, SSIS (Integration Services), Talend. OLAP: Tableau, PowerBI. Big Data: Hadoop Ecosystem, Apache Kafka, Apache Airflow.Cloud: AWS, Google Cloud. Read more
English - Advanced
Spanish - Intermediate
March 2020 - Currently
Mapping and building a robust Open Baking architecture environment, using a wide variety of technologies.
September 2019 - March 2020
Working with development of reports and Dashboards in Tableau; ETL creation with Integration Services (SSIS); Creation of Procedures for loading data into SQL Server; Developing and implementing the hadoop ecosystem in the corporation.
June 2019 - September 2019
Acting with Microsoft technologies; ETL with Integration Services; Requirements gathering; Reporting in Power BI. Language DAX and M; Creation of Facts, Dimensions and OLAP Cubes; Microsoft Analysis Services; Acting only with SQL Server.
September 2018 - June 2019
Project Worked: Serasa Experian: Creation of ETL for data migration from Oracle - Exadata to Ibm Db2, and SQLServer. Requirement raising, DW creation, and support. Using Tableau to create Dashbords. Reporting with the IBM Hyperion tool. Reporting and data visualization with IBM Cognos Analytics. Bradesco: Using the Powercenter tool for data migration and ETL creation. CNPQ Brasilia: Creation of ETL using Talend and using the OLAP tool, Microstrategy.
January 2018 - August 2018
I worked on strategic projects. Project and developed ETL processes, through the Postgree platform, and non-relational database (MongoDB) in order to integrate the data contemplated in the project scope. I developed load ETL processes to load the data incrementally according to the periodicity defined during the planning phase. I implemented, through the load packets, data quality process, considering validation rules. I designed and developed multidimensional data models and tabular Data Mart and Olaps Cubes creating as the main and only source of information, security (roles) to access the multidimensional and tabular model in the cloud environment through preformatted reports or Ad-Hoc queries in the Cube of PowerBI, Tableau among others. Creating intelligent reports using DAX and M (PowerBI)
June 2017 - December 2017
Advanced Zabbix management, trigger creation and new monitoring methods. Call handling Level 3, for insertion of new parameters on the server. Java development (Eclipse Plataform) and PHP for panel development indicators. Experience in SQL (Oracle, Postgre, Mysql and SQLServer) for B.I applications: Pentaho, SpagoBI (Knowage), PowerBI and Tableau. Currently working with development and loads of ETL, Data Wherehouse and creation of dynamic dashboards for presentation of customer indicators.
February 2016 - March 2017
Management of hospital systems: Creation and blocking of users, training of new employees and doctors, maintenance and configuration of screens. Monitoring, maintenance and network creation: Monitoring through the Zabbix tool, creation of navigation rules in the Firewall (Fotigate), creation of login scripts on the AD server. Service level 1 to 3 calls to users of the units for which I am responsible (Camaçari, Cajazeiras, Lauro 1 and 2), for solving systemic problems and training screens for new deployments..
June 2015 - March 2016
Experience in providing assistance in the administration of the computer network and support to users in hardware and software, performing maintenance of computer equipment and network configuration, and the like; Performance in the diagnosis and exchange of equipment with problems, involving the installation and reinstallation of the operating system; Experience in field and remote customer service, performing tests on systems developed by the company and maintenance services (systems and hardware).
March 2013 - December 2013
Development and maintenance of websites and application maintenance in Mambo, Joomla. Database development in MYSQL. Creation of logos and Marketing campaigns for the company. Creation of the Mobile Application for the company.
February 2012 - March 2013
Responsible for publicizing and implementing, selling and distributing the new technological electronic components of the ASUS brand in the states of Bahia and Sergipe; Marketing campaign creation, to expand the brand business; Training teams of salespeople and managers to sell IT and Smartphone products in large retailers (Extra, Walmart, Cencosud, etc.)
2017 - 2019 - Completed
Plan and develop projects of systems of Databases.Manage Databases, serving users and evaluating system performance. Create physical and logical projects for the structuring of company information with the purpose of assisting decision processes. Control access, analyze records, and manage backups.Develop protection mechanisms for shared information systems. Inspect and test computers and peripherals, prepare technical reports and determine the necessary corrective measures. Supervise teams in activities to develop programs, interfaces or applications aimed at the management of Databases.Guide the production of project documentation, programs and applications, using tools and software.
2018 - 2020 - Studying
This postgraduate course had as my primary objective to collaborate for the formation in Business Intelligence, approaching concepts and practices with the objective of identifying business opportunities through the analysis of corporate data. I made this post in order to use assertive information and improve my analytical visions, thus providing sustainability and competitive advantages for organizations.
2014 - 2017 - Interrupted
Technologist course to learn how to develop, analyze, design, implement and update information systems. With notions of data management, but with specialty of creation of computerized systems: programming of computers and development of softwares and expansion of the capacity of the resources of the equipment.
2009 - 2011 - Completed
Technologist course to learn how to implement and manage computerized systems in companies and takes care that these systems are safe and user friendly. Handles hardware and software.
Professional very competent and always carrying out their activities with great zeal and good results. Do not be content with the quality of your services less than great. always creative and proposing new actions to improve results delivery of greater value to the organization. Your personality provides a great environment for teamwork..
He is a boy of knowledge and unique intelligence, always solicitous and willing to help, with excellent advice always well grounded. A very competent BI professional with a thriving career due to his professional and personal qualities.
A professional with a high problem-solving ability and an indescribable ease of teamwork. In the ambit of Business Intelligence, he has extensive experience and solid knowledge.
Herbert is a professional with extensive knowledge in the area of Business Intelligence. Excellent relationship for teamwork. Always willing to learn new technologies. Proactive and Self-taught.