Augusto C.
Data Analyst

Skills

Alteryx

Qlik Sense

Microsoft Azure

Oracle Database

Microsoft Sql Server

Mysql

Delphi

Augusto is available for hire

Meet Augusto C.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

An experienced professional specializing in data visualization and analytics, certified in Power BI by Microsoft. Expertise encompasses advanced skills in DAX, Power Query, and M language, along with proficiency in using Qlik Sense and Google Data Studio for comprehensive data analysis and reporting solutions.

Analytics Consultant
8/1/2019 - 2/1/2024

Engaged in projects for prominent national and international clients within sectors such as beverages, food, telephony, and machinery. Conducted extensive requirements gathering and analysis with clients, ensuring precise data extraction from diverse database platforms and various file formats. Leveraged Power Query with M language and other ETL tools like Alteryx Data Factory for data processing. Developed advanced measures using DAX to calculate metrics and indicators, followed by data loading and the creation of comprehensive data models. Designed intuitive dashboards employing UX principles and utilized Microsoft Azure DevOps for the meticulous planning, execution, and tracking of tasks. Provided guidance and oversight to analysts, ensuring alignment with project goals.

Developed expertise in data warehousing, analytical skills, ETL processes, data visualization, and data modeling. Proficient in creating dashboards and executing Business Intelligence (BI) tasks, with hands-on experience in M language, Qlik Sense, DAX, Alteryx, SSIS, Microsoft Power BI, Google Data Studio, SQL Server, and ORACLE.
Systems Analyst
12/2/2015 - 8/1/2019

Managed and developed objects within operational databases, including tables and views, using ORACLE and SQL Server. Extracted and processed data from a variety of sources, such as Excel, MySQL, ORACLE, and SQL Server, utilizing Power Query in Power BI. Published content to Power BI Service and oversaw the creation, management, and sharing of content within Workspaces. Installed and maintained Update Gateway from "On-Promises" to Power BI Service. Developed reports and dashboards primarily using Power BI, with additional experience in Google Data Studio. Provided ongoing development and maintenance for legacy systems built with Delphi language.
Systems Analyst
3/2/2013 - 10/2/2015

Documented procedures and collected data to define methods and resources necessary for the implementation and modification of systems. Created and modified methodologies and procedures essential for system development, specifically using DELPHI. Elaborated, specified, developed, supervised, and revised data models to ensure the effective implementation and maintenance of related systems, with a strong emphasis on ORACLE. Demonstrated expertise in software development, including object-oriented programming (OOP) and data modeling.
Systems Analyst
8/2/2011 - 7/2/2012

Managed customer request occurrences and meticulously documented procedural workflows. Collected pertinent data and identified the methods and resources essential for implementing new systems or modifying existing ones. Created and revised methodologies and procedures necessary for system development using VB6, ASP, .NET, and DELPHI. Developed, specified, supervised, and revised data models to ensure the successful implementation and maintenance of related systems, with a strong focus on ORACLE and SQL SERVER databases. Demonstrated technical expertise in software development, object-oriented programming (OOP), and data modeling.
Systems Analyst
11/2/2004 - 6/2/2011

Managed customer request occurrences in accordance with SLA standards, ensuring timely and efficient resolution of issues. Documented procedures meticulously to maintain a clear and organized workflow. Conducted data collection and defined necessary methods and resources for system implementation or modification. Created and modified methodologies and procedures essential for system development utilizing VB6, ASP, .NET, and DELPHI. Prepared comprehensive specifications, supervised development, and revised data models to support the implementation and maintenance of systems using Oracle and SQL Server. Directed and monitored the activities of junior analysts to ensure consistency and quality of work. Played a key role in a project to adapt information consolidating applications from construction sites to a new ERP system (Totvs), involved in planning, coordination, and execution of project activities. Developed expertise in software development, object-oriented programming (OOP), and data modeling.

Specialization in Data Science and Big Data Analytics at Metropolitan College of the State of São Paulo
2020 - 2021
Information at Bachelor in Administration with Emphasis in Systems Analysis, Systems
2003 - 2006