Wanderson M.
Data Analyst

Skills

Cubos OLAP

Tableau

Pl/sql

Github

Microsoft Sql Server

Oracle Database

Python

Wanderson is available for hire

Hire Wanderson M.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

With over six years of experience in the IT sector specializing in business and data analysis, this professional has focused primarily on projects involving Business Intelligence (BI) and Big Data. Key competencies include requirement gathering, screen prototyping, ETL processes, database management and modeling, and dashboard creation. These skills have consistently been leveraged to deliver substantial value to client businesses in the domains of BI and Big Data.

Oracle Developer
6/1/2022 - Present

Identified requirements within the business area and restructured existing reports in Oracle Cloud Analytics. Included necessary adjustments and updated existing views in the Oracle Database. Updated settings in the Oracle semantic layer and ETL maps through Oracle Data Integration, ensuring comprehensive code control. Developed proficiency with Oracle Cloud Analytics, Oracle Database, Oracle Data Integration, and maintained rigorous version control. Demonstrated a deep understanding of database management, ETL processes, and complex data reporting, leading to enhanced business intelligence capabilities.
Data Scientist PL
2/1/2022 - 8/1/2022

Identified requirements with the business area, restructured existing reports in Oracle Cloud Analytics, and implemented necessary adjustments. Updated existing views in the Oracle Database and configured updates in the Oracle semantic layer. Refined ETL maps through Oracle Data Integration and maintained strict code control. Developed proficiency in Oracle Cloud Analytics, Oracle Database, and Oracle Data Integration. Demonstrated expertise in requirements gathering, report restructuring, database view updating, semantic layer configuration, and ETL map refinement.
BI Analyst
8/1/2021 - 6/1/2022

Located at the INTEL client, contributed to BI projects using agile methodology and Jira. Gained expertise in data modeling, developing ETL routines, and constructing Tabular OLAP Cubes. Prepared comprehensive reports utilizing DAX, M, and Power Query while investigating business needs to tailor data solutions. Managed views and jobs within a Linux environment with proficiency in Git for version control. Leveraged Microsoft tools including SSAS (Analysis Services), SSIS (Integration Services), SQL Server, DAX, and Power BI for various tasks. Worked extensively with Big Data technologies such as Hadoop, Hive, and Impala. Developed strong skills in data analysis, data warehousing, data visualization, and Extract, Transform, Load (ETL) processes.
BI Consultant
9/1/2020 - 11/30/2021

Delivered expertise in producing dashboards and IT indicators, leveraging Power BI from installation to configuration, to provide actionable business intelligence insights. Led BI project development and advanced ETL processes to facilitate seamless data integration and transformation. Excelled in report development and demonstrated strong control and management of Database Management Systems (DBMS) using various SQL tools. Enhanced skills in data analysis, data warehousing, and data visualization. Utilized JIRA for efficient project management and employed Transact-SQL for robust database querying and management tasks.
Junior BI Analyst
9/1/2018 - 9/30/2020

Developed expertise in ETL map creation and modification using PowerCenter, along with creating and modifying reports, dashboards, and managing administration and security via SAP Crystal Reports and SAP Dashboards. Performed comprehensive data extraction from Mainframe systems and utilized Data Services tools. Gained extensive experience with databases including PostgreSQL, SQL Server, Oracle, and MySQL, and honed SQL proficiency. Demonstrated strong capabilities in relational and multidimensional database modeling, leveraging HAWQ for advanced data management tasks.
ETL Internship
2/1/2018 - 8/31/2018

Demonstrated expertise in ITIL by categorizing and attending calls. Developed comprehensive reports and documentation. Made adjustments, corrections, and validations of ETL processes using Pentaho Data Integration (PDI). Configured and adjusted KPIs within BI applications such as SAIKU, Zoho, and BCC. Conducted corrective maintenance of data repositories. Provided service and support for BI tools on Linux servers.
BI Internship
8/1/2015 - 12/31/2016

Set up infrastructure for Business Intelligence (BI) applications, conducting comprehensive requirements gathering and prototyping. Utilized proficiency in dimensional and multidimensional modeling to establish robust data structures. Developed Extract, Transform, Load (ETL) processes using Oracle Data Integration (ODI). Created semantic layers for data cubes and data warehouses (DW), ensuring optimized data retrieval. Built interactive dashboards and reports employing Google Charts and Oracle Business Intelligence Enterprise Edition (OBIEE), and customized dashboard menus using HTML, CSS, and JavaScript. Demonstrated strong skills in data analysis, data warehousing, data visualization, and ETL processes.