André Luiz Vale

Co-founder ADA | M.Sc. Artificial Intelligence | Data Scientist | DBA @ADA Data Solutions

Data AnalystITDatabase DeveloperML EngineerData ScientistData Engineer

Im André Luiz Vale de Araújo, a professional with experience in Database and Data Science. I have a degree in Computer Engineering and a Master's degree in Computational Intelligence from the University of Pernambuco. During my Master's degree, I developed a model for predicting Sepsis in ICUs based on clinical data, using a committee of classifiers. I work as a Senior DBA at the Court of Justice of Pernambuco and as a Data Scientist in the Bastião project at the same institution. In this project, I worked on creating predictive models for predatory actions in legal proceedings. I used advanced statistical modeling techniques, metrics analysis and visualizations. I have expertise in data pre-processing, filling in missing data, class balancing with SMOTE, and database optimization with intelligent algorithms (PSO, ABC, BRKGA). In the area of predictive models, I applied Random Forest, Logistic Regression, Decision Trees and MLP to classify data. Developed NLP models to calculate document similarity, using the BERTimbau model to generate embeddings. My experience includes leadership in data modeling and bank maintenance projects, such as Banco Topázio and CrediBRF, with a focus on volumetrics and migration of large volumes of data. I have skills with DBMSs such as Oracle, PostgreSQL, SQL Server and MySQL, and cloud environments with AWS (S3, RDS, CloudWatch).

Feedback from André Luiz’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

ADA Data Solutions Co-fouder - Cientista de Dados

Jun. 2022Recife, Pernambuco, BrazilProject 1: Support for Diagnosis of Leprosy and Skin Cancer This project aims to develop an intelligent tool for the early detection of these diseases. The process includes medical consultations, photographic recording of the lesion, application of computational intelligence techniques, feature extraction, and image classification into one of seven classes. Utilizing the Dermatological Atlas, the project achieved remarkable performance with an accuracy of 89.0%, a Kappa index of 88.0%, sensitivity of 73.0%, specificity of 98.0%, and an AUC-ROC of 95.0%. Project 2: Breast Cancer Diagnosis via Imaging This project aims to develop intelligent systems for non-invasive breast cancer diagnosis using mammography and thermography images. The system classifies early-stage breast lesions, achieving high accuracy. The current performance shows an accuracy of 99.0%, a Kappa index of 95.0%, sensitivity of 98.87%, and specificity of 91.14% for thermography. For mammography, the accuracy is 95.0%, with a Kappa index of 95.0%, sensitivity of 98.0%, and specificity of 82.24%. Project 3: Epidemiological Surveillance of Arboviruses The surveillance system addresses cases of dengue, chikungunya fever, and Zika, utilizing data on arboviruses, breeding sites, temperature, and wind speed. Notable contributions include distribution maps and predictive models. The performance of case and breeding site prediction models is robust, with Pearson correlation coefficients above 0.9875 and Root Relative Squared Error ranging from 3.29% to 14.60%. Project 4: Epidemiological Surveillance of COVID-19 In this project, the models achieved high Pearson correlation coefficients (above 0.9990), with Root Relative Squared Error ranging from 2.20% to 11.42%. In the state of Pernambuco, the performance was particularly notable, with a Pearson correlation coefficient of 99.91% and a Root Relative Squared Error of 1.92%. The project resulted in six scientific publications.

ADA Data SolutionsCo-fouder - DBA

Jun. 2022Recife, Pernambuco, BrazilData Administrator and DBA: building, maintaining, and validating data models using data management tools, data access security procedures, and redefining the company's data model to improve database performance. Implementation and maintenance of databases, environment monitoring, tuning, volume management, migration of massive data volumes, backup and data recovery policies. DBMS: Oracle, PostgresSql, SQL Server, MySQL OS: Windows, Linux. Modeling Projects: Banco Topázio: modeling of a Data Lake involving structured and unstructured data from a total of seven systems. Municipal City Hall of Curitiba: construction of conceptual, logical, and physical models for the legal support system - Justiça no Bairro (Justice in the Neighborhood). Database Maintenance Projects, Environment Monitoring, Tuning, Volume Management, Migration of Massive Data Volumes: Banco Topázio and CrediBRF: For these projects, the following stages were involved: - Data migration scope planning: data assessment from source and destination; - Data mapping: understanding the data and its types (FROM/TO); - Database structure analysis: analysis of database objects; - Data volume analysis: strategies to mitigate the impact of migrating large data volumes; - Data extraction: extracting data to a Staging area; - Data transformation: standardization and cleansing of data in intermediate tables; - Data loading: using batch insertion methods, block writes, and non-logged operations to load data with higher speed; - Environment monitoring; - Verification and validation tests with the client. Consultation of Taxpayer Debts Project (CDC) - ICI Curitiba: The scope of this project was to adapt Stored Procedures to the changes in the way the taxpayer debt inquiry portal is accessed.

Tribunal de Justiça de Pernambuco (TJPE)Senior Sql Database Administrator - PostgreSQL

Oct. 2021Pernambuco, Brasil

Tribunal de Justiça de Pernambuco (TJPE)Data Scientist

Jan. 2022 - Apr. 2024Recife, Pernambuco, BrasilBastião Project - TJPE: An innovative project aimed at predicting predatory actions in judicial processes. It utilizes advanced data science and artificial intelligence techniques to identify patterns and prevent abuses in the judicial system. I developed insights to generate effective business rules using data analysis, statistical modeling, and advanced Python tools to create efficient predictive models. Key Technical Highlights: Statistical Modeling: Metric Analysis: Evaluation of accuracy, sensitivity, specificity, kappa, and AUC-ROC. Confusion Matrix: Used for detailed assessment of model performance. Box Plot: Visualization of data distributions and identification of outliers. Data Preprocessing: Missing Data Imputation: Utilization of Gaussian distribution for imputing missing data. Class Balancing: Application of techniques like SMOTE to address class imbalance. Database Optimization: Implementation of intelligent algorithms such as PSO, ABC, and BRKGA. Hyperparameter Tuning: Use of Grid Search for model optimization. Predictive Models: Intelligent Algorithms: Application of Random Forest, Logistic Regression, Decision Trees, and MLP for data classification. Prediction of Predatory Actions: Development of models to predict predatory actions in judicial processes. NLP Models: Document Similarity Calculation: Use of NLP models for similarity analysis. Embedding Generation: Utilization of the BERTimbau model to generate embeddings for document texts. Cosine Similarity Calculation: Evaluation of document similarity using generated embeddings.

Instituto Federal do Amazonas Presidente Figueired, IFAM, Brasil.Data Architect

Jul. 2021 - Dec. 2021Manaus, Amazonas, BrasilThe project aims to research and implement technological solutions that provide the optimization of analysis processes, management of the management system of the company HUMAX. Acting as Software Architect, focusing on producing a data model and performing refactoring of the entire database, as well as improvements in database performance. Status: Completed.

Universidade Federal de PernambucoSenior Database Administrator

Oct. 2020 - Oct. 2021Recife, Pernambuco, Brasil

NeurotechDatabase Administrator

Mar. 2020 - Oct. 2020Recife, Pernambuco, Brasil

Secretaria de Meio Ambiente e Sustentabilidade de PernambucoSystem Analyst

Dec. 2014 - Jan. 2017PernambucoElicitation of user requirements to support the planning and implementation of support and assistance projects for the organization's internal departments, using UML modeling tools; implementation of projects using the WAMP platform (Windows, Apache, MySQL, and PHP).

IndraDatabase Administrator

Jun. 2012 - Oct. 2014Data Administrator: Responsible for the construction, maintenance, and validation of data models, utilizing data management support tools (DB Design, SQL Server Management Studio). This role includes implementing data access security procedures and redefining the company’s data model to enhance database performance. Database Administrator: Responsible for the implementation and maintenance of databases in test, staging, and production environments, ensuring their availability, consistency, and integrity. Duties include the installation and maintenance of DBMS, conducting database performance testing and monitoring, adjusting environments as necessary, and capacity planning. Additionally, this role involves developing contingency plans for DBMS, managing backup and restore procedures, implementing the physical database model, and providing user support for optimal SQL usage to access the database. This includes suggesting changes and adjusting the physical implementation of databases when needed.

PitangDatabase Administrator

Nov. 2012 - May. 2014

Prefeitura Municipal do Jaboatão dos GuararapesDatabase Administrator

Sep. 2011 - Oct. 2012Data administrator: construction, maintenance and validation of data models, using data management support tools (PGAdmin, MySql Workbench), data access security procedures, redefinition of the company's data model, aiming at a better performance of the database. Database administrator: implementation and maintenance of databases in test, homologation and production environments, ensuring their availability, consistency, integrity; DBMS installation and maintenance; implementation of the physical model of the database; support to users regarding the best use of the SQL language to access the database, suggesting changes and adapting the physical implementation of the databases when necessary.

Linx S.A.Database Aministrator

Jul. 2009 - Jul. 2010Data administrator: construction, maintenance and validation of data models, using data management support tools (Toad Data Modeler, Toad for Oracle, Sql Query Analyzer, Sql Server Management Studio), data access security procedures, redefinition of the company's data model, aiming at a better performance of the database. Database administrator: implementation and maintenance of databases in test, homologation and production environments, ensuring their availability, consistency, integrity; DBMS installation and maintenance; performing tests and monitoring database performance, adjusting environments when necessary, as well as doing capacity planning; contingency plan related to the DBMS, and its backup and restore procedures; implementation of the physical model of the database; support to users regarding the best use of the SQL language to access the database, suggesting changes and adapting the physical implementation of the databases when necessary. All activities were performed using DBMS's Oralce (9i, 10g, 11g) and SQL Server (2000, 2005).

Intch is a Professional Networking App for the Future of Work

300k+ people

130+ countries

AI matching

Get Intch if you'd like to

📝

Get Recommended to New Customers

👋

Connect with Like-Minded People

💸

Raise Capital

🚀