Rafael Loução - Data Analyst,

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

KeyrusData Analyst

Mar. 2023Curitiba, Paraná, Brazil · RemoteWorking for multiple projects, from Marketing to Health Care, with different technologies and different industries. The main activities on those projects were: - Worked with engineering data in Redshift, connecting it directly to PowerBI. - Performed data preprocessing and designed data architectures. - Created KPI dashboards and translated client needs into more concise and user-friendly reports, through PowerBI and Tableau - Developed an ETL system using Alteryx to process client data. - Managed data governance and Tableau Server administration, including access and credentials. - Validated and optimized existing security dashboards (both Tableau and PowerBI) - Improved the data dictionary and restructured table relationships for better client comprehension. - Conducted a 1.5-month training program for the client on Alteryx, streamlining processes across various departments.

CI&TData Analyst

Jul. 2021 - Mar. 2023Curitiba, Paraná, Brasil - RemotoWorking on a global project, focused on United States clients, developing a data quality and data analytics environment to enhance the decision make, through: - Data quality check, ensuring that the pipelines are running with no issues; - Discovery of new metrics, through data available on lake via Snowflake environment; - Query optimization in Snowflake, in terms of building new ones, fetching data from warehouse and analyzing jobs run through engineering team and building views and stored proceedures to enhance the metrics available - Historical analysis to see user and data behavior, developing a conversion funnel to analyze how is the user performing on the application and retrieving key insights for platform enhancement; - Enhancing query performance, delivering faster and reliable results to stakeholders; - Creation of a Data Chapter, unifying and enhancing the development of Data Analysts on the organization; - Data quality process; - Applying Data Governance principles; Main tools: Python, SQL, Snowflake, Power BI, Segment, Google Data Studio, Amplitude

ExxonMobilData Analyst

Jan. 2019 - Jul. 2021CuritibaWorking directly with SAP data through SQL databases, in a global team, extracting, manipulating and analyzing data to deliver better analysis, transforming them and developing complex Tableau dashboards to generate business insights and provide business processes oversight to higher management, working through a clean data visualization perspective, concentrating essential metrics in a one-stop dashboard and optimizing the back-end structure performing query and stored procedure optimization, including index creation, execution plan analysis and re-writing poor performing queries. From mid 2020 to now, working directly on key projects that englobe data across the entire organization, developing SQL and Alteryx scripts to perform data manipulation and to harmonize data from different sources, having users from multiple areas and countries accessing the dataset. - Average of 300 internal users per month on dashboards created - 20000+ visualizations on dashboards - Dashboard training sessions for more than 500 users across the world

ExxonMobilCards Payments Assistant

Jun. 2017 - Jan. 2019Curitiba, Paraná, Brazil- Analysis and payment of corporate cards (T&E and PCard) and out of pocket expenses for Americas and Europe; - Administration of Enhanced PCard, working directly with suppliers all over North America, in order to analyze, review and release payments related to large purchases, via catalog, for the company; - Review and build metrics, improving systems and analysis, creating and maintaining dashboards using Tableau and SQL; - Responsible for the rebate program review, analysing corporate cards spend in order to assure the program effectiveness;

ExxonMobilTrainee

Jan. 2016 - Jun. 2017Curitiba e Região, BrasilResponsible for retrieving and organizing data related to corporate cards and expense reports. Participate in several projects during the period, including the implementation of dashboards, using Tableau, to analyze internal metrics

HSBCIntern

Mar. 2015 - Dec. 2015Curitiba e Região, BrasilThe main activity of the internship was to assist in the account reconciliation, helping to raise the productivity through process automatization.

Intch is a Professional Networking App for the Future of Work

100k+ people

130+ countries

AI matching

Get Intch if you'd like to

📝

Get Recommended to New Customers

👋

Connect with Like-Minded People

💸

Raise Capital

🚀