Raphael Carvalho
Verified Expert in Engineering
Data Analyst and Software Developer
Raphael是一位经验丰富的数据和业务分析师,专门从事仪表板创建, data storytelling, and web analytics. 他的工作帮助公司了解他们的主要增长杠杆,并通过A/B测试和渠道开发提高他们的转化率和受众. Raphael是一位以商业为导向的专业人士,通过数据分析产生商业价值. 他在小型团队和空白画布项目中工作得很好,这些项目需要高度的抽象和创造力.
Portfolio
Experience
Availability
Preferred Environment
Python 3, Tableau Desktop Pro, APIs, SQL, Amazon S3 (AWS S3), Data Analytics, BigQuery, Microsoft Power BI, Google Cloud Platform (GCP), Microsoft Azure
The most amazing...
...我从头开始开发了一个云数据仓库,它结合了来自多个数据源的数据, 例如主数据库和第三方api.
Work Experience
Data Warehouse Developer
Oberst BV
- Built a data warehouse from scratch, consuming data from different data sources, 比如公司数据库和第三方软件api, such as Accuranker, Plausible, and WeCanTrack.
- 开发了许多供业务用户使用的数据工具, such as automated dashboards, spreadsheets, email reports, etc.
- Developed ad hoc analysis, 比如提高网站在搜索引擎上的点击率和SERP排名, improving on-page merchant CTR, etc.
Analytics Senior Lead
XP Inc
- 负责股票研究内容平台.
- 为所有内容平台制定SEO诊断和行动计划.
- 为所有内容平台开发KPI监控系统.
Business Consultant
Qconcursos
- 咨询,寻找机会,提高公司的业绩,在获取客户和制定行动计划的团队进行测试, learn, and scale based on findings.
- 设计了大量的A/B测试,专注于提高网站的新注册转化率.
- 开发一个新的客户获取框架,协调所有渠道步骤的努力(意识), consideration, 转化)和来源(有机和无机).
Senior Business Analyst
Nubank
- 开发了一个系统,可以自动从Facebook上的所有Nubank出版物中提取数据, Instagram, LinkedIn, TikTok, Twitter, and YouTube, 使用Python构建,并由运行在AWS EC2机器上的Apache气流编排.
- 监督和指导Nubank的博客团队,使博客读者同比增长25%, focusing on SEO improvements, paid-media optimization, and email marketing.
- 监督Nubank的全国品牌活动,该活动使用了大量的线上和线下渠道, 衡量对网站的短期影响, blog, and social media.
Business Analyst
Zoetis - Main
- 开发了一个自动电子邮件报告系统,作为竞选活动绩效讨论的基础.
- 执行特别分析,如过去的活动表现和NPS调查分析.
- 为电子邮件营销活动提供客户目标列表.
Data Analytics Manager
Sympla
- 管理一个数据分析师团队,提供每两周和每月的业务绩效报告, developed ad-hoc analysis and queries, 建立和维护管理和执行仪表板, and helped departments define and monitor KPIs.
- 监督自助数据平台的创建,该平台为全公司40多名员工提供服务. 它使员工可以根据需要请求自定义和预定义的报告,而无需向数据团队提交申请.
- 理想化并执行了许多专注于企业对企业客户获取的A/B测试.
Senior Data Analyst
Sympla
- Implemented conversion data points and developed a measuring model based on sessions that map every step of the purchase funnel; through this model, A/B tests were developed, improving the conversion rate by 20%.
- 为公司不同部门的多个数据项目提供重要服务, such as marketing, sales, customer service, management, product and growth, and strategy, 并深入参与了Sympla官方kpi的定义.
- 管理有65个Tableau用户的Tableau实现,并监督1300个仪表板的环境.
Experience
Data Analysis Sample
http://drive.google.com/file/d/1mlWEI-WdKrnhl2JsK6lIfKxNCoSTUFJM/view?usp=sharingFOREX Data Pipeline
http://github.com/rapha-carvalho/forex_data其目的是在每个货币对中建立二元预测模型,以协助交易者进行谈判.
Finding the Best Linear Regression Model in R
http://github.com/rapha-carvalho/regressor_utils_RSkills
Languages
Python 3, SQL, Python, Snowflake, R, Scala
Libraries/APIs
Facebook Marketing API, Instagram API, Twitter API, LinkedIn API, Google Sheets API, Pandas, NumPy, YouTube API, Azure Blob Storage API
Tools
Tableau Desktop Pro, Google Analytics, Apache Airflow, Tableau, Google Optimize, Google Sheets, BigQuery, Microsoft Power BI
Paradigms
商业智能(BI), ETL,管理,数据科学
Platforms
MacOS、亚马逊网络服务(AWS)、Docker、Azure、谷歌云平台(GCP)
Storage
Redshift, Amazon S3, PostgreSQL, Data Integration, MariaDB, MySQL
Other
TikTok API, Business, Marketing Mix, Strategy, Data Visualization, Data Analysis, Google BigQuery, Excel 365, Data Warehousing, Digital Marketing, Data Analytics, Reports, Business Logic, Dashboards, Reporting, Amazon RDS, Data Cleaning, Data Aggregation, Google Data Studio, Google Search Console, APIs, Big Data, Big Data Architecture, Data Engineering, Human Resources (HR), Logistics, Finance, Operations, Google SEO, Amplitude, Metabase, Azure Databricks, Business Strategy, Business Analysis, Statistical Modeling, Startups, Plausible, AccuRanker, Microsoft Azure
Frameworks
Spark
Education
Specialization in Data Engineering
Udacity - Remote
Specialization in Big Data
ESPM - São Paulo, São Paulo
Bachelor's Degree in Business Administration
IBMEC - Belo Horizonte, Brazil
Certifications
Tableau Desktop Specialist
Tableau