Data Analyst / Data Engineer
About Me
I am a seasoned Data Analyst and Data Engineer with extensive experience in business intelligence, data warehousing, and ETL processes. Over the years, I have developed a strong expertise in SQL Server, Power BI, Azure, and various big data technologies such as Apache Kafka, Hadoop, and Spark. My work spans multiple industries including finance, insurance, retail, and technology, where I have successfully delivered data-driven solutions to support decision-making and operational efficiency.
My academic background includes postgraduate studies in Systems Analysis, Design and Management, along with a technologist degree in Data Processing. I continuously enhance my skills through specialized courses in Databricks, Azure Synapse Analytics, Tableau, Python, and other data-related technologies. I am proficient in advanced data modeling, dashboard development, and scripting languages such as Python and DAX.
Throughout my career, I have managed complex projects involving data migration, pipeline creation, and dashboard development using tools like Power BI, SQL Server, and cloud platforms including Azure and Google Cloud Platform. I am experienced in Agile methodologies and use tools like Jira and Confluence for project management and documentation.
I am passionate about leveraging data to create impactful business insights and have a proven track record of collaborating with cross-functional teams to deliver scalable and maintainable data solutions. My approach combines technical expertise with a deep understanding of business needs, ensuring that data initiatives align with organizational goals.
I am fluent in Portuguese and have advanced proficiency in English (B1 level). I am committed to continuous learning and staying updated with the latest trends in data engineering and analytics to provide innovative solutions. I am eager to contribute my skills and experience to challenging projects that drive business growth and operational excellence.
Skills
PythonSQLData AnalysisAzureCI CDJiraGitScrumMongoDBNoSQLSQL ServerMicrosoft Project
Education
Postgraduate in Systems Analysis, Design and Management
Technologist in Data Processing
Experience
Six-month project supporting and maintaining demands in Fabric and GCP with SAP, using Databricks, complex SQL queries, Azure DevOps, Git version control, and CI/CD for delivery.
Built 50 Big Queries in GCP for Power BI consumption, applying ETL principles, data extraction, testing with Ateryx, and data validation.
Developed complex Power BI reports with Power Query M language and DAX, transforming and joining data from SQL Server data flows.
Created Power BI dashboards for treasury department with data from SAP, Prisma cubes, Databricks PySpark, Excel data models, and Azure Data Lake integration.
ETL project migrating data from AX application to Locavia, creating Big SQL queries, Apache NIFI pipelines, Azure DataBricks ETL processes, and Synapses Lake House integration.
Temporary project developing NPS Dashboard in Power BI for Marketing, using Teradata, Hive, Spark, Jupyter Notebook, SQL, and detailed documentation.
Restructured data area with OLTP, Data Stage, OLAP, ETL, Data Cleansing, ROLAP Cubes, DW, and BI structure implementation on SQL Server Azure.
Developed dashboards from Manhattan SCI system in IBM Cognos Cloud, managing Jira stories and delivering KPIs for B2B and B2C models.
Delivered Business Intelligence solutions with Power BI and Oracle Database, using Scrum and Jira for project management.
Adapted dashboards in Power BI, implemented Performance Assessment program, developed ETL jobs, and maintained databases with SQL Server and PostgreSQL.
Performed ETLs and developed managerial dashboards using DAX, M language, Power Query, and migrated reports to Power BI.
Provided consultancy and support for SQL Server implementation, including high availability, disaster recovery, and backups.
Taught programming and administration of MS SQL Server, including stored procedures, triggers, security, backup, and replication.
Executed business routines and improved SQL Server scripts for insurance area, managed tasks with Kanban.
Administered and maintained SQL Server and Reporting Services for Rio 2016 Olympic Project, including AlwaysOn, migrations, and performance monitoring.
Managed IT systems development, DBA responsibilities, project management, recruitment, and software acquisition for 11 years.
Developed process control system using VB-6 and Access with Agile methodology.
Developed complex management reports using Crystal Reports 9.0 and SQL Server 7.
Developed inventory and invoice systems in VB-6, Access, and Crystal Reports.
Participated in migration planning and development of customer service systems on UNIX and web platforms.
Developed results indicators project using UML, Rational, VB-6, and Access.
Developed forum and database using SQL Server, ASP, and JavaScript.
Developed three-layer E-Commerce system using VB-6, ADO, HTML, JavaScript, ASP, and SQL Server.
Maintained client-server project in VB-6 and Access.
Maintained websites and intranet using HTML, ASP, JavaScript, VBScript, SQL Plus, PL/SQL, Oracle Reports, and Crystal Reports.