RÉSUMÉProfessional profile

Lucas Rosat.

Data Engineering Analyst
SQL Development / Business Intelligence (BI) / AI Automation

I am a Data Engineering Analyst and AI Automation Engineer with a strong background in SQL development, Business Intelligence (BI), data integration, reporting, data modeling, database design, Generative AI and process automation.

Throughout my experience, I have designed and developed end-to-end ETL processes, data integrations and SQL Server database structures, including tables, relationships and data models. I develop complex T-SQL queries and Stored Procedures, optimize query and database performance, and implement validations and business rules for reliable enterprise solutions.

My Business Intelligence experience includes Power BI Paginated Reports (RDL), SQL-based datasets, data analysis and existing reporting models. I also work with Azure DevOps, BMC Control-M and Microsoft development technologies to support enterprise reporting, production systems and business operations. My background in Systems Analysis, programming, algorithms, databases and software development helps me quickly adapt to new technologies and programming languages.

In addition to Data Engineering and Business Intelligence, I actively work with Generative AI and AI-driven automation. I have designed and developed multiple AI agents using Microsoft Copilot to support technical analysis, SQL development, troubleshooting, requirements understanding, process documentation and day-to-day engineering activities.

I use Power Automate, Microsoft Copilot and other AI and automation technologies to improve development workflows, reduce repetitive work, accelerate problem-solving and make technical and business processes more efficient.

I am interested in opportunities across Data Engineering, SQL Development, Business Intelligence, Reporting, Data Integration, AI Automation and related technology fields, where I can build practical enterprise solutions that improve business processes and engineering productivity.

I am a Data Engineering Analyst and AI Automation Engineer specializing in SQL development, Business Intelligence (BI), ETL and data integration, enterprise reporting, Generative AI, and process automation.

I am interested in opportunities across Data Engineering, SQL Development, Business Intelligence, Reporting, Data Integration, AI Automation and related technology fields, where I can build practical enterprise solutions that improve business processes and engineering productivity.

Read full profile

Throughout my experience, I have designed and developed end-to-end ETL processes, data integrations and SQL Server database structures, including tables, relationships and data models. I develop complex T-SQL queries and Stored Procedures, optimize query and database performance, and implement validations and business rules for reliable enterprise solutions.

In addition to Data Engineering and Business Intelligence, I actively work with Generative AI and AI-driven automation. I have designed and developed multiple AI agents using Microsoft Copilot to support technical analysis, SQL development, troubleshooting, requirements understanding, process documentation and day-to-day engineering activities.

I use Power Automate, Microsoft Copilot and other AI and automation technologies to improve development workflows, reduce repetitive work, accelerate problem-solving and make technical and business processes more efficient.

My Business Intelligence experience includes Power BI Paginated Reports (RDL), SQL-based datasets, data analysis and existing reporting models. I also work with Azure DevOps, BMC Control-M and Microsoft development technologies to support enterprise reporting, production systems and business operations. My background in Systems Analysis, programming, algorithms, databases and software development helps me quickly adapt to new technologies and programming languages.

  • Data Engineering
  • SQL Development
  • Business Intelligence (BI)
  • AI Automation
DataTransformAutomateAIReport

Technical skills

Skills, technologies & tools.

Experience

Professional experience.

From web development to data engineering and AI automation.

May 2021 — Present

Accenture

AccentureDec 2022 — Present Data Engineering AnalystCurrent
  • Design and build end-to-end ETL processes from scratch, including extraction, transformation, validation, data integration and automated processing across enterprise systems.
  • Design SQL Server database structures and data models for ETL solutions, defining tables, relationships and business rules to support reliable data processing.
  • Develop, troubleshoot and optimize complex T-SQL queries, Stored Procedures and reporting datasets, applying SQL performance tuning to improve reliability and efficiency.
  • Develop and maintain Business Intelligence and enterprise reporting solutions using Power BI Paginated Reports (RDL), SQL-based datasets and existing reporting models.
  • Design and develop AI agents with Microsoft Copilot to support SQL development, technical analysis, troubleshooting, requirements understanding, process documentation and engineering workflows.
  • Apply AI-assisted development and Power Automate to reduce repetitive tasks, accelerate debugging and code analysis, and optimize technical and business workflows.
  • Support production data integrations, scheduled ETL jobs, deployment and enterprise operations using technologies including SSIS, Azure Data Factory, BMC Control-M and Azure DevOps.
  • Collaborate with functional, development and testing teams to translate requirements into technical solutions, define acceptance criteria, validate end-to-end behavior and resolve complex data issues.
  • Microsoft Copilot Enterprise
  • OpenAI Codex
  • Power Automate
  • SQL Server
  • T-SQL
  • SSIS
  • Azure Data Factory
  • Power BI
  • SSRS
  • PowerShell
  • BMC Control-M
  • Azure DevOps
  • Power BI Paginated Reports (RDL)
  • ETL
  • Stored Procedures
  • Data Modeling
  • Database Design
  • SQL Performance Tuning
  • Business Intelligence (BI)
  • Generative AI
  • AI Agents
AccentureMay 2021 — Dec 2022 SQL Developer
  • Developed and optimized database queries and stored procedures, supported ETL workflows and maintained enterprise reporting solutions.
  • Implemented and supported scheduling, deployment and automation workflows for recurring data processes.
  • SQL Server
  • T-SQL
  • SSIS
  • SSRS
  • BMC Control-M
  • Azure DevOps
  • Visual Studio

Feb 2020 — May 2021

Grupo Aoniken

Grupo AonikenFeb 2020 — May 2021 SQL Developer & Technical Support
  • Developed database solutions and provided technical support for business systems, troubleshooting data and application issues and supporting end users.
  • Investigated incidents through relational data analysis and supported day-to-day operational processes.
  • SQL
  • Relational Databases

Jan 2019 — Dec 2019

Iddea Devs

Iddea DevsJan 2019 — Dec 2019 Web Developer
  • Developed responsive and dynamic web applications based on client requirements.
  • HTML
  • CSS
  • PHP
  • SQL

Education

Education & certifications.

Education

Advanced Technician in Systems Analysis

Juan XXIII Institute

4 years of study

Systems Engineering

Universidad Nacional del Sur

One year completed

Java Programming

Quantumm Institute

2017

Certifications

SkillsoftApr 2024

Generative AI APIs for Practical Applications: An Introduction

SkillsoftMar 2024

Artificial Intelligence and Machine Learning

SkillsoftMay 2024

ChatGPT Prompt Engineering Examples & Use Cases

SkillsoftMay 2021

Application Security Awareness & Validation

SkillsoftMay 2021

API Security

SkillsoftMay 2021

Secure Application Architecture & IAM

SkillsoftMay 2021

Top 10 List Items

Languages

SpanishNative

EnglishC1 · CEFR

AI-assisted development

Independent projects.

Independent applications and websites built with Codex to explore practical uses of AI-assisted development.

web

Manos a la Obra

A public home renovation and maintenance website with a private content editor, review and publishing workflow, and persistent content and media management. Designed around a zero-cost operating constraint.

Stack

Astro, React, TypeScript, Hono, Cloudflare Pages, D1, KV

Live website
android

My Flight

A native Android flight companion for on-demand flight lookup, recent ADS-B positions and traces, aircraft details, and map-based viewing. API credentials are protected with Android Keystore.

Stack

Kotlin, Jetpack Compose, MapLibre

windows

DisplayConductor

A Windows desktop application for monitor profiles and display control, with window grouping, startup rules, recovery tools, and diagnostic reporting. Physical display behavior still needs validation on target hardware.

Stack

C# 14, .NET 10, WinUI 3

windows

Sound Mixer

A Windows audio mixer for per-application sessions, with browser-tab volume control through a Chromium extension and Native Messaging integration.

Stack

C# 14, .NET 10, WinUI 3, WASAPI, Chromium extension

Skillsoft credential

Credential details

Open on Skillsoft