Leonardo Basilio Email and Phone Number

- Development of pipelines in the Microsoft cloud environment using Synapse, Python, GIT, and SQL. - Responsible for maintaining and creating topics and consumers of microservices to replicate databases using Kafka technology. - Development of ETL using SISS technology. - Creation of dashboards for various internal sectors using Power BI and Apache Superset. - Developing multidimensional data models and cubes utilizing IBM Cognos Transformer, Framework, and TM1 technologies. - Documentation and standardization of processes. - Collaboration with internal areas to understand their needs and develop necessary flows and information, alongside the data/BI team.

Building dashboards with Tableau Desktop;Monitoring of the Tableau Server, ensuring the operation of the tool in the company;Building M.I.S (Management Information System ) with Alteryx;Develop SQL queries for data extraction using SQL Server DBMS (Microsoft) and FireBird;Creation of studies aiming at better results within a credit recovery structure;Using Python, to run and send reports of routine processes;

Responsible for extracting, modeling, and analyzing databases in order to identify business;Using Python, to run and send reports of routine processes;Responsible for modeling and creating a data warehouse, with good practices applied;Applied the Kolmogorov–Smirnov Test (KS) for the credit recovery segment;

Develop SQL queries for data extraction using SQL Server DBMS (Microsoft); Model the extracted data in order to generate value information; Perform all ETL (Extract Transform Load) process using the Alteryx tools; Develop reports and dashboards on the Tableau platform to assist management in the elaboration of credit recovery strategies;

Dashboard maintenance (Tableau)Monitor the execution of ETL (Alteryx)Sending information to customers (Excel/WINSCP)