Rafael C.
Data Analyst

Skills

Sql

Google Analytics

Html

Php

Python

Postgresql

Rafael is available for hire

Meet Rafael C.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A specialist in data collection, cleaning, and report generation and presentation with experience in serving multinational enterprises. Proficient in generating actionable insights by aligning audience engagement with strategic client objectives.

Payments Fraud Prevention Data Analyst
1/1/2023 - Present

Enhanced engineering processes by creating automations for operational routines and ETL, leading to increased efficiency. Constructed management dashboards to monitor key metrics related to fraud, employing advanced data visualization tools. Developed customized queries to identify opportunities for reducing the chargeback rate and increasing the credit card approval rate. Played a crucial role in creating and refining rules for feeding the anti-fraud model, thereby improving the overall system. Conducted comprehensive data modeling, process documentation, and task automation to streamline operations. Investigated patterns and performed data analysis to identify fraudulent profiles in buyers and sellers.

Technical skills developed include Key Performance Indicator (KPI) reporting, Google Data Studio, data analysis, Python, SQL, and Microsoft Power BI for sophisticated data visualization and database management.
Payments Data Analyst
2/1/2022 - 1/1/2023

Interpreted and analyzed data to generate comprehensive reports, focusing on key performance indicators. Managed data ingestion and collection routines, ensuring efficient data transformation processes. Developed and maintained dashboards, including routine updates, to support ongoing business needs. Collaborated closely with the Payments team management to prioritize and address business requirements. Identified and defined opportunities for process improvements across various operations areas such as Chargeback, CS (L3), Collections, Payouts, Payments, Projects, Refunds, and Wallet Adjustments. Demonstrated technical proficiency in Google Data Studio, data analysis, Python, and SQL.
BI Analyst
7/1/2021 - 1/1/2022

Specialized in the collection, export, and cleaning of data to ensure accuracy and integrity. Created and presented dashboards for multinationals across various industries, encompassing sectors like entertainment, banking, automotive, food service, and more. Leveraged data from diverse sources to generate valuable insights and actionable recommendations aligned with clients' business strategies. Conducted competitor research to identify performance opportunities. Produced a variety of reports that included Web Heatmaps, Mail Marketing via RD Station, Paid Media analytics for platforms like Meta, YouTube, TikTok, and Google, as well as Chatbot analytics using IBM Watson and implemented solutions using Tag Manager. Developed proficiency in Key Performance Indicator (KPI) reporting, Google Data Studio, data analysis, Excel, and storytelling.
eCommerce Manager
6/2/2016 - 2/2/2021

Achieved recognition as a reference and sales leader in the online retail and trade show niches for textiles, with revenue tripling during the pandemic. Successfully optimized operational costs and integrated new technologies, resulting in annual savings of R$150,000. Responsibilities included prioritizing tasks and goals, prospecting for new technologies, and creating dashboards for results presentation. Instrumental in fostering a data-driven culture for decision-making. Led and trained teams effectively, driving digital marketing strategies based on KPIs and industry metrics. Managed marketing operations at trade fairs and exhibitions within the textile niche. Implemented a Chatbot SaaS system to enhance intelligence and improve results. Enhanced sales logistics, including freight, reverse logistics, carrier management, and accident response. Coordinated and briefed digital influencers for marketing campaigns. Developed strong skills in KPI reporting, data analysis, SQL, marketing, Excel, and leadership.
Art Director
3/2/2011 - 5/2/2013

Achieved portfolio expansion for new services, resulting in increased annual revenue for the agency. Successfully partnered in major events in the southern coastal region of São Paulo. Conducted product briefings and managed a small team to ensure seamless project execution. Maintained rigorous quality control of produced materials and actively prospected for new graphic and digital content to enhance the service portfolio. Demonstrated strong capabilities in commercial negotiation, graphic design, marketing, leadership, and management.