Cristiano B.Data Analyst
Skills
Currently a Data and Business Intelligence Analyst pursuing a Power BI Specialist qualification with the aim of achieving Microsoft certification. Additionally, engaged in studying French. Holds a postgraduate degree in Data Science and Big Data from Pontifical Catholic University of Minas Gerais (2016) and a postgraduate degree in Database and Business Intelligence from Unicentro Newton Paiva (2011). Earned an undergraduate degree in Information Technology from the latter institution in 2007. Since completing formal education, has been involved in numerous projects to enhance professional expertise. Also possesses a technical secondary education degree in Data Processing from the Polytechnic School of Minas Gerais - Polimig. Actively seeking new professional opportunities while striving to further specialize, expand knowledge and experience, achieve relevant certifications, and build a global professional network.
Business Intelligence Analyst
4/1/2019 - 4/1/2023
Belo Horizonte, MG - Outsourced Service Provision - Supported the interview process and evaluation of new collaborators for the BI Team; facilitated the reception of new collaborators and the transfer of processes and tools used; conducted analysis and specification of business rules and company processes with a greater focus on Risk Management, Credit Management, Controllership, and Planning areas. Engaged in data modeling, maintenance, and development of BI solutions for various departments, leveraging tools such as Microsoft Excel (integrated with Power Query), Power BI for dashboard maintenance, development, and publication, Visual Studio 2019, and SQL Server 2017. Developed ETL packages, reports, and dynamic spreadsheets, coordinating with the Database Administrator for performance improvement actions. Utilized Reporting Services, Integration Services, and Analysis Services extensively. Ensured collaborative code maintenance and version control using GIT and managed demands using Azure DevOps with SCRUM methodology.Business Intelligence Analyst
11/1/2016 - 4/1/2019
Developed expertise in modeling and creating databases, and designing ETL processes for extracting information from REST services in JSON format. Efficiently loaded information into newly created databases and utilized these data sets for generating reports and dashboards. Demonstrated proficiency in creating and maintaining procedures for data extraction, data loading, and developing comprehensive reports, charts, and dashboards for Business Intelligence systems.
Undertook the complex task of modeling and establishing a central database to consolidate information from three disparate systems, validating it based on predefined client rules, and developing ETL packages for data treatment and loading. The primary goal was to assess data quality across systems, identify potential failures, and recommend improvements.
Spearheaded projects to integrate data between packaging and dispatch control systems for the assembly of transmission towers, including creating, maintaining, and publishing detailed reports. Developed processes for data coexistence between new and legacy systems, including data migration from the new system to the old one and automatic data replication. This involved maintaining high isolation levels when replicating data from the new system's database to the legacy system’s database, which was scheduled for future deactivation.
Demonstrated proficiency with tools such as Microsoft Excel integrated with Power Query, Power BI, Visual Studio 2017, Reporting Services, Integration Services, and SQL Server 2016.Business Intelligence Analyst
4/1/2015 - 7/1/2016
Analysis of business rules for systems, focusing on the TOTVS Human Resources System: RM Vitae, which involved in-depth data modeling and maintenance. Developed and enhanced Business Intelligence (BI) solutions for the HR Department, specifically targeting areas of Medicine and Occupational Safety. Created and managed cubes, ETL Packages, reports, and dynamic spreadsheets. Utilized various tools including Microsoft Excel 2010 integrated with Power Pivot for data manipulation, and leveraged Tableau and Power BI for developing and publishing dashboards. Assisted in evaluating tools for potential acquisition. Designed data models using DBDesigner and Toad Data Modeler. Demonstrated technical proficiency with Reporting Services, Integration Services, Analysis Services, and SQL Server 2012.Career Break | Professional Transition
9/1/2014 - 4/1/2015
Managed project specifications and monitored development, deadlines, and deliveries for various projects, including new versions of the Conveniar System (Management of Agreements and Contracts for Foundations). Applied SCRUM methodology for agile project management. Supported database server management, which involved maintaining indexes, backup routines, and disk space (Data and LOG Files). Extracted data from Google Docs for report generation, focusing on ETL and Data Quality. Utilized tools such as Reporting Services, Integration Services, and SQL Server 2008.Business Intelligence Analyst
4/1/2013 - 9/1/2014
Developed proficiency in analyzing the business rules of systems, with a primary focus on Nucleus and Fluxus Systems by TOTVS. Gained expertise in data modeling, maintenance, and development of BI solutions tailored for the Controllership Department, specifically in creating cubes, ETL packages, reports, and dynamic spreadsheets with a concentration on financial sectors such as budget and purchasing. Utilized Microsoft Excel 2010 integrated with Power Pivot for data analysis, and employed tools like DBDesigner and Toad Data Modeler for the creation of data models. Demonstrated advanced skills in leveraging Reporting Services, Integration Services, Analysis Services, and SQL Server 2008 to deliver comprehensive business intelligence solutions.Systems Analyst
7/1/2011 - 1/1/2013
Engaged in the analysis of business rules, development, and maintenance of customizations for systems with a primary focus on the products: Nucleus and Fluxus. Utilized tools such as WinMerge, Visual Source Safe, and Team Foundation Server 2010. Developed proficiency with Delphi 7, Visual Studio 2010, SQL Server 2008, and Oracle 10g.Systems Analyst
10/1/2009 - 9/1/2010
Developed expertise in the analysis and maintenance of systems designed to support the aviation sector, specifically in aircraft maintenance and airport services. Utilized tools such as CVS, Delphi 7, Visual Studio 2008, Oracle 10g, and Crystal Reports. Acquired programming skills in languages including SQR and PHP.Systems Analyst
2/1/2008 - 10/1/2009
Conducted analysis and maintenance of systems within the banking sector, focusing on improving system functionality and reliability. Performed maintenance and enhancements, including the development and optimization of packages for data extraction, transformation, and loading. Designed and created customized reports accessible via intranet, improving data accessibility for end-users. Utilized a range of tools and technologies including CVS, Delphi 5 and 7, Visual Studio 2005, SQL Server, Reporting Services, and Integration Services 2005 to ensure robust and efficient system operations.Programmer Analyst
1/1/2005 - 10/1/2007
Analyzed business rules, performed database modeling, and developed and maintained systems tailored for engineering and occupational safety. Created entity-relationship models and data dictionaries for comprehensive documentation and database definition in various systems. Utilized Microsoft Visio 2002 for diagramming and database modeling, Firebird 1.5 for relational database management, and Delphi 5 for software development.Programmer
1/1/2004 - 1/1/2005
Developed and maintained an ERP system tailored for commerce, industry, and service sectors. Focused extensively on banking and tax modules, which included reading, interpreting, and loading return files, as well as generating and sending remittance files. Created, modified, and printed bank slips and invoices (Continuous Form). Utilized Delphi 6 for development and Interbase for database management.Computer Instructor
3/1/2001 - 1/1/2004
Conducted system development classes, emphasizing best practices in programming logic and database modeling utilizing tools such as Access 2000, Visual Basic 5, and Delphi 6. Assisted in the evaluation of new instructors and contributed to the creation, organization, and distribution of course syllabi aligned with respective workloads. Delivered graphic design instruction using Corel Draw 9 and provided comprehensive training on Windows, Word, Excel, PowerPoint, and Internet. Integrated practical application of these tools with theoretical content in the Auxiliary Accounting and Personnel Department course.
Information Technology at Unicentro Newton Paiva
2002 - 2007Data Processing at POLIMIG - Polytechnic School of Minas Gerais
1998 - 2000Database and Business Intelligence at Unicentro Newton Paiva
2010 - 2011Data Science and Big Data (Locked) at Pontifical Catholic University of Minas Gerais
2016 - 2017
WGC Sistemas | Implementing Data Models and Reports with Ms SQL Server 2012 (40Hs) at Ms Official Course
4/1/2014Implementing a Data Warehouse with Ms SQL Server 2012 (40Hs) at Ms Official Course
4/1/2014Implementing and Maintaining Ms SQL Server 2008 Analysis Services (20Hs) at Ms Official Course
8/1/2012Implementing and Maintaining Ms SQL Server 2008 Reporting Services (20Hs) at Ms Official Course
8/1/2011Developing Ms ASP.NET Web Applications Using Visual Studio.Net 2008 (40Hs) at Ms Official Course
5/1/2010Implementing and Maintaining Ms SQL Server 2005 Integration Services (20Hs) at Ms Official Course
8/1/2008Developing Ms ASP.NET Web Applications using Visual Studio.Net 2003 (40Hs) at Ms Official Course
2/1/2008
Cristiano is available for hire
Hire Cristiano B.
All Howdy Candidates are vetted for skills and english proficiency.
