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 WorkSee more people like Rafael on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
453430 people
17
IT Project Manager @ Freelancer
26
Mobile Engineer @ Raiô Benefícios
15
.Net Fullstack Developer/Angular Developer @ Webfis Processamento de Dados Ltda
39907 people
16
Data Analyst / Engineer @ SoliDeo Glória Data Analytics
15
CEO @ Damch
15
Socio @ Domti