Responsible for designing, developing and maintaining business intelligence solutions using SQL Server, Power BI, SSIS and Python. Creation of efficient data models and databases to store and process large volumes of information.{** *}Development of ETLs using SSIS for the extraction, transformation and loading of data from various sources to the data warehouse. Creation of interactive reports and control panels using Power BI to facilitate data analysis.
realização principalImplementation of a business intelligence system based on Power BI for the monitoring and analysis of key performance indicators as well as the development of a data extraction and transformation process using SSIS for the integration of multiple sources of information.
Validation and cleaning of the source structure, Load sources to the database, validation of the information in the database, validation of the Storage Procedure, Validate the tasks programmed in the (Jobs), creation and validation of Linked Server, review and updating of Power BI reports, sending detailed and consolidated reports to managements, support and training of BI dashboards at final user.
realização principalImplementation of a business intelligence system based on Power BI for the monitoring and analysis of key performance indicators in the Call Center area and appointment scheduling