Guilherme Lima Email & Phone Number

State Of São Paulo, Brazil

Porto Alegre, Rio Grande Do Sul, Brasil

• Focused on the company's product division;
• Participation in the CoE of BI (Center of Excellence, a team of experts responsible for establishing best practices in report development, disseminating and training users) as a leader focused on design and standards;
• Use of Databricks tool for data manipulation using SQL and Power BI for dataviz;
• Collaborate with cross-functional teams to develop solutions and implement strategies with data-driven decisions;

• Focus on Business Intelligence;
• Implementation and development of reports of varying complexity in Power BI for management of national and export commercial teams;
• Leadership in the migration of reports from SAP BO/HANA to Power BI, making them available embedded in our own portal, managing RLS;
• Creation and standardization of queries in SAP BW preferably using data flow to centralize data and information, with 30+ queries available for consult, aggregating data from multiple… Show more
• Creation and standardization of queries in SAP BW preferably using data flow to centralize data and information, with 30+ queries available for consult, aggregating data from multiple sources;
• Server and Power BI Webperformance monitoring;

São Leopoldo, Rio Grande Do Sul, Brazil

• Developed+10 dashboards using Power BI for customers from different business areas and high volume of data;
• Implementation of good practices in storytelling to monitor data evolution, helping customer decision-making based on the Power BI reports;
• Extraction, loading and transformation (ETL) of data from +15 different databases from MySQL, SQL Server and PostgreSQL;
• Maintenance and monitoring of +30 existing dashboards, having optimized and standardized +10 existing SQL… Show more
• Maintenance and monitoring of +30 existing dashboards, having optimized and standardized +10 existing SQL queries, resulting in a 30% time reduction for problem identification;
• Migration project to Data Lake using Azure tables, to reduce the query time of reports and improve the platform's performance. Show less

Canoas, Rio Grande Do Sul, Brazil

• Updating.csv tables to insert and update the Data Warehouse, impacting +10 Tableau dashboards of indicators;
• Creation of reports and dashboards for project singularities to support decision-making, reducing by 25% the time spent to gather information for evolution reports;
• Query and extract data in ERP systems (Windchill /JD Edwards/Oracle);
• Constant use of advanced Excel tools for daily activities;
• Interface with suppliers and global branches and participation in global… Show more
• Interface with suppliers and global branches and participation in global projects; Show less

Canoas, Rio Grande Do Sul, Brasil

• Responsible for the data analysis in order to build and monitor +10 cost reduction and product improvement initiatives;
• Responsible for ensuring data quality and accuracy for Data Warehouse impacting +05 Tableau reports.
• Basic use of database maintenance tools in Tableau to support managerial decision making;
• Query and extract data in ERP systems (Windchill /JD Edwards/Oracle);
• Prototype troubleshooting analysis using VBA and DFMEA;

Porto Alegre, Rio Grande Do Sul, Brasil

• Assistance in detailing projects in the area of industrial piping with a focus on the steel and petrochemical industry;
• Caculation reports production of tube thickness and supports sizing;
• Material lists, standards, data sheets, technical specifications for piping materials;
• Development of solutions in detailing softwares and assistance in the evaluation and verification of projects according to international standards;
• Interface with customers and suppliers.

São Paulo, Brasil

• Inspection reports, installation projects, risk management and inspection plans development, in accordance with NR-13 (Brazilian regulatory standard for pressure equipment);
• Follow-up and management of service orders;
• Updating and monitoring of maintenance indicators;
• Preparation of isometric drawings withe Cad design;
• Technical Review of Inspection Reports on pressure vessels and piping in accordance with NR-13;
• Focus on contracts for large industries.

Porto Alegre E Região, Brasil

• Assistace in inspection reports, installation projects, risk management and inspection plans development, in accordance with NR-13 (Brazilian regulatory standard for pressure equipment);
• Assistance in calculations with the ASME VIII DIV standard. 1 for industrial equipment and piping;
• Interface with all hierarchical levels of the company;
• Isometric drawings in AutoCad;
• Follow-up of service orders;
• Constant monitoring of maintenance indicators;