Fabio S.Back-end and Systems Engineer
Skills
A data professional with a degree in Information Systems, specializing in Database and Data Science, and holding certifications in MicroStrategy and IBM Cognos. Currently advancing expertise through a certification in Microsoft Power BI Data Analysis (PL-300). Possessing over eight years of experience within the data sector, exhibiting a strong interest in roles focused on Data Analysis, Data Engineering, and Data Governance.
BI/DW Analyst
3/1/2018 - Present
Developed expertise in performing Data Governance activities concerning data quality, including data cleaning and enrichment, data security, and the creation and upkeep of the data dictionary. Implemented and monitored compliance with LGPD within the directorate, coordinating with the intelligence section. Executed complex data queries and processing using ORACLE and SQL Server databases to create reports and management indicators, subsequently converting these queries into comprehensive reports and dashboards through MicroStrategy and Power BI. Conducted relational modeling and took charge of creating tables, views, procedures, query tuning, and PL/SQL. Led the development and implementation of a comprehensive BI/DW project, from crafting the multidimensional model to data loading using Pentaho PDI, supporting the Analysis team’s requirements. Retrieved and enriched data from various external databases, including sources like TSE, Cartórios, Federal Revenue, and IBGE, by performing intricate queries.Technical Analyst I
6/1/2014 - 6/1/2016
Developed expertise in the Office 365 platform. Managed the Management and Monitoring System for Local Innovation Agents by requesting improvements, corrections, and changes to the IT team, as well as conducting user training. Gathered requirements for the creation of the Management System for Scholarships of Local Innovation Agents (SisBolsas) in collaboration with the IT team. Performed queries and data processing using SQL Server for the creation of indicators and Balanced Score Card (BSC).Senior OLAP MicroStrategy Analyst
3/1/2014 - 6/1/2014
Developed expertise in requirements gathering, effectively liaising with demanding areas to capture detailed project needs. Specialized in creating objects within the semantic layer, configuring object hierarchies, and designing drill-down, drill-up, and drill-across functionalities to enhance data navigation. Demonstrated proficiency in creating detailed reports, documents, and dashboards, facilitating comprehensive data visualization and analysis.Cognos Data Analyst
8/1/2013 - 2/1/2014
Developed technical proficiency in object mapping within the semantic layer for the POUPEX Project. Created detailed reports and interactive dashboards to assist stakeholders in data interpretation. Played a significant role in project documentation, ensuring comprehensive records and guidelines were maintained for future reference.OLAP MicroStrategy Analyst
1/1/2012 - 7/1/2013
Worked on a project focusing on the mapping of objects in the semantic layer and the creation of reports, documents, and dashboards. Executed deployment utilizing MicroStrategy Object Manager and developed Cubes, including scheduling for updates. Participated in integrating MicroStrategy with the SAP ERP database to generate comprehensive reports. Acquired extensive knowledge and experience with products and services in the business areas of financial institutions.Junior OLAP Analyst MicroStrategy
1/1/2010 - 1/1/2012
Gathered requirements for reports and dashboards from various clients in the private pensions and pension funds sector. Conducted comprehensive mapping of objects in the semantic layer to ensure accurate data representation. Created detailed reports, documents, and interactive dashboards to meet client needs. Provided user training on tools, enhancing their ability to utilize and interpret the delivered solutions effectively. Acquired in-depth knowledge of private pensions and pension fund management, applying domain-specific insights to the technical work.Data Processing Assistant
2/1/2004 - 1/1/2010
Managed the Academic and Financial System of an institution, overseeing user management, and providing system training for users. Conducted requirement gathering with managers and users to develop new functionalities, make system changes, and correct errors. Generated strategic and operational reports for managers through SQL queries in SQL Server. Designed, implemented, and maintained projects using Microsoft Reporting Service SSRS, and utilized Analysis Services SSAS to create cubes, dimensions, and other objects. Employed ETL Integration Services SSIS to load tables (dimensions and facts). Gained knowledge in the areas of education, private colleges, and distance learning.
Information Technology at NDA College - FACNET
2004 - 2007Postgraduate Specialization: Data Science at University Center UNIFAEL
2022 - 2022Database at IESB
2009 - 2009
Big Data Fundamentals at Data Science Academy
10/1/2022IBM Certified Developer - Cognos 10 BI Metadata Models at IBM
7/1/2013IBM Certified Designer - Cognos 10 BI Reports at IBM
7/1/2013IBM Certified Developer - Cognos 10 BI Metadata Models at IBM
7/1/2013IBM Certified Designer - Cognos 10 BI Reports at IBM
7/1/2013Certified Project Designer (CPD) - MicroStrategy at MicroStrategy
12/1/2012OLAP MicroStrategy Tool – Certified Project Designer (CPD) at MicroStrategy
12/1/2012
Fabio is available for hire
Hire Fabio S.
All Howdy Candidates are vetted for skills and english proficiency.
