Andre Mendes dos Santos

Data Analyst with experience in data analytics, business intelligence, ETL, data integration, and process automation, with a focus on transforming data into insights to support decision-making.

Experience in developing dashboards, data pipelines, automated workflows, and analytical solutions across different business environments. Hands-on experience with SQL, Power BI, Excel, Python/Pandas, ETL, APIs, and PowerShell, with a focus on data analysis, process automation, data integration, performance monitoring, and identifying data patterns.

Experience across retail, healthcare, and banking, supporting operational analysis, forecasting, and data-driven decision-making. Professional background enriched by experience in business operations, KPI analysis, process improvement, and performance tracking, combining analytical capabilities with a practical understanding of business needs.

Core Techs: SQL | Power BI | Python | Excel | ETL | Data Integration | APIs | Process Automation | Business Intelligence

Data Analyst - IT/IS at MUFG (2024-01 – 2026-06)

Focused on data analysis within the IT/IS sector, collecting, processing, and visualizing information from various tools to support decision-making and the preparation of executive reports.

• Creating dashboards using data visualization tools (Power BI) to provide various views for executive committee presentations;
• Fulfilling stakeholder information requests by gathering data via SQL queries and APIs to generate consumption views;
• Developing KPIs to meet business requirements and address audit findings;
• Developing data models to store raw input data, such as workforce analytics and asset inventories;
• Using AI to refactor and review queries, code, and pipelines, aiming to optimize processes and reduce infrastructure load;
• Implementation of business rules in DAX to generate insights in accordance with company policies;
• Use of Power Query to extract and treatment data from structured and unstructured files, such as Excel files, logs, and PDFs.
• Structuring and administration of the Power BI Service online environment for hosting semantic models.
• Using GitHub as a repository for data model files, including uploading and version control.

Intern at MUFG (2022-02 – 2024-01)

Administrative Assistant - Health Economics / Outcome Cell at Einstein Hospital Israelita (2021-10 – 2022-02)

• Descriptive data analysis in the healthcare sector, focusing on clinical outcomes, treatment efficacy, and patient quality of life within the outcomes unit.
• Assistance in processing healthcare and outcome datasets to support evidence-based assessments.
• Organization and analysis of data related to medical procedures, treatments, and patient outcomes.
• Support for the comparative analysis of procedures and interventions based on efficacy, recovery, and patient impact.
• Assistance in evaluating clinical cost-benefit, prioritizing outcomes and improvements in quality of life.
• Validation and structuring of datasets to ensure consistency and reliability in analyses.
• Reporting and insights: Assistance in preparing analytical summaries and outcome reports for healthcare and research teams.
• Creation of Power BI dashboards highlighting treatment results and performance indicators.
• Support for trend analysis and basic forecasting regarding patient outcomes and procedure efficacy.

Administrative Assistant - Sales / Retail Operations at Nestlé (2018-08 – 2019-12)

• Acted as an administrative support role within the sales area, assisting executive management with operational follow-up and performance tracking
• Consolidated and maintained sales, returns, and operational data from retail channels using SAP
• Supported basic sales forecasting based on historical performance, seasonality, and trends
• Assisted in tracking and analyzing reverse logistics indicators, such as returned volumes, damages, and product losses through SAP reports and extracts
• Prepared management reports, spreadsheets, and executive summaries to support commercial decisions
• Assisted in presenting sales, logistics, and forecasting insights through Power BI dashboards
• Coordinated with sales, logistics, and administrative teams to ensure data consistency and process alignment
• Maintained organized records and documentation to support retail and sales operations

Analyst and developer system in Tecnologia da Informação – Universidade Cruzeiro do Sul (2023-01 – 2024-12)

Analyst and developer system in Tecnologia da Informação – Fatec Zona Sul (2022-01 – 2023-12)