João V.
Data Analyst

Skills

Transact-sql

Sql

Pl/sql

Google Bigquery

Microsoft Sql Server

Python

Microsoft Azure

Google Cloud

João is available for hire

Hire João V.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

With a strong passion for data and extensive experience in Business Intelligence projects, this professional integrates technical prowess and business insights to enhance organizational decision-making. Expertise encompasses dashboard development using Power BI, and script creation for data integration and extraction utilizing Python. Proficiency extends to data development, extraction, and input through TSQL, as well as data tasks using PL/SQL. Additionally, this individual is adept at developing integration packages and ETL processes with Integration Services (SSIS), managing backup routines, and maintaining MS SQL Server. Skills also include dimensional and relational data modeling, conducting integrations, and performing requirements analysis.

BI Analyst
5/1/2023 - Present

Managed requirements analysis to gather, document, and address the needs of various stakeholders effectively. Developed technical expertise in T-SQL for comprehensive data extraction and manipulation, ensuring accurate and efficient data handling. Demonstrated proficiency in creating insightful and interactive dashboards using Power BI, contributing to enhanced data visualization and business intelligence.
BI Analyst
12/1/2021 - 4/1/2023

Gained expertise in requirements analysis to effectively gather and interpret client needs, ensuring successful project outcomes. Developed and executed data extraction processes using T-SQL, allowing for the retrieval and analysis of complex datasets. Designed and implemented interactive dashboards with Power BI, providing visually impactful and data-driven insights that facilitated informed decision-making.
BI Analyst
8/1/2021 - 12/1/2021

Gained expertise in requirements analysis, facilitating the development of tailored packages for ETL and data integration using Integration Services (SSIS). Demonstrated advanced skills in developing and extracting data using T-SQL.
BI Analyst
10/2/2020 - 8/1/2021

Specialized in requirements analysis and the development of data extraction and integration processes utilizing Python. Gained expertise in creating packages for ETL and data integration using Integration Services (SSIS), as well as in performing data extraction with T-SQL. Engaged in both dimensional and relational modeling. Developed and designed dashboards and reports using Power BI, showcasing a robust understanding of modern data visualization tools and techniques.
IT Analyst
4/2/2019 - 8/2/2020

Developed expertise in requirements analysis, prototyping, and the support and implementation of systems. Acquired skills in testing and demonstrated proficiency in relational and multidimensional modeling. Excelled in development and data extraction using PL-SQL. Created impactful dashboards and reports utilizing Power BI and Qlik View.
Systems Consultant
9/2/2016 - 4/2/2019

Specialized in consulting, implementation, and support for a specialized CRM in collections. Performed thorough requirements analysis to ensure functional and efficient software applications. Conducted comprehensive black box software testing to identify and resolve defects. Developed expertise in T-SQL for complex data extraction and manipulation. Created and managed ETL and data integration packages using SQL Server Integration Services (SSIS). Generated detailed reports using SQL Server Reporting Services (SSRS), ensuring accurate data representation. Conducted and monitored training sessions to ensure effective user adoption and proficiency.
Intern
5/2/2016 - 9/2/2016

Gained expertise in consulting, with a focus on implementing and supporting a CRM specialized in collections. Conducted thorough requirements analysis and performed software testing using black box methodologies. Developed and extracted data proficiently using T-SQL, and created ETL packages for data integration using Integration Services (SSIS). Demonstrated advanced skills in report development through Reporting Services (SSRS). Proficient in conducting and monitoring training sessions for end-users, ensuring smooth adoption and effective use of the CRM system.
Intern
1/2/2014 - 1/2/2016

Excelled in providing comprehensive helpdesk support, including preventive and corrective maintenance on both hardware and software systems. Demonstrated expertise in relational and multidimensional modeling, alongside data development and extraction using T-SQL and PL/SQL. Specialized in the development of ETL packages and data integration through Integration Services (SSIS). Played a pivotal role in the implementation of Data Warehouses utilizing Analysis Services (SSAS).