Carlos Lopes

About Carlos Lopes

Business Intelligence Analyst | Cloud Computing, SQL Tuning, ETL, and Database Modeling ExpertAs a Business Intelligence Analyst with over 20 years of experience, I specialize in leveraging cloud computing, SQL tuning, ETL development, and database modeling to optimize data systems and empower organizations to make data-driven decisions. My expertise lies in designing and implementing scalable, cloud-based architectures that efficiently manage and analyze large datasets, ensuring robust performance and reliability.Key Strengths and Expertise-Cloud Computing: Proficient in Microsoft Azure (Azure SQL DB, Azure Analysis Services, Azure SQL Data Warehouse) and Snowflake, with a proven track record of building and managing cloud-based data solutions that scale with business needs-SQL Tuning: Skilled in optimizing SQL queries and database performance to ensure fast, efficient data retrieval and processing, even for complex datasets-ETL Development: Extensive experience with ETL tools such as SSIS, Azure Data Factory, Databricks, Talend, Informatica, enabling seamless data integration, transformation, and loading across diverse systems-Database Modeling: Adept at designing and optimizing database structures to support advanced reporting, analytics, and business intelligence, ensuring data integrity and accessibility.Professional Highlights-Designed and implemented cloud-based data architectures that improved scalability and reduced operational costs for large enterprises-Streamlined complex data workflows by developing efficient ETL pipelines, ensuring high data quality and accuracy throughout the process-Optimized SQL queries and database performance, resulting in faster data processing and improved system responsiveness-Collaborated with cross-functional teams to deliver data solutions that align with business objectives and drive actionable insights-With a passion for solving complex data challenges and a commitment to delivering high-quality results, I am eager to bring my expertise to a forward-thinking organization. I am particularly interested in roles that allow me to leverage my technical skills to drive innovation, improve operational efficiency, and support data-driven decision-making.

Experience

1. Data Base Developer

   Bealls, Inc.

   Jan 2024 — Present · FL, US

   Design and implement ETL processes using Python, integrating data from multiple sources into the Snowflake-based data warehouse.Develop and maintain efficient and scalable data pipelines, ensuring data integrity and consistency throughout the extraction, transformation, and loading process.Created logging mechanisms to track the number of records in source tables and the number of records successfully inserted into destination tables, ensuring transparency and accountability in data processing.Designed and implemented an SMS/e-mail notification system using Python to alert stakeholders of critical process events, improving real-time communication and response times.Collaborate with Business Intelligence teams to ensure data is accessible and organized for strategic analysis and decision-making.Utilize a variety of tools and technologies, including Microsoft SQL Server, SSIS, SSAS, Snowflake, SQL Azure, PL/SQL, and Talend, to manage and process data effectively.

Education

• Universidade FUMEC - Oficial

  Sistema de Informação

• Universidade Federal de Minas Gerais

  Mathematics

Skills

• Gestão De Projetos
• Sql
• Microsoft Project
• Team Leadership
• Pl/Sql
• Etl (Extração, Transformação E Carregamento)
• Inteligência Empresarial
• Itil
• Sistemas Operacionais
• Transact-Sql
• T-Sql
• Banco De Dados