-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
344 lines (313 loc) · 15.9 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
<!DOCTYPE HTML>
<!--
Editorial by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>Portfolio Vitor Ferreira</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
</head>
<body class="is-preload">
<!-- Wrapper -->
<div id="wrapper">
<!-- Main -->
<div id="main">
<div class="inner">
<!-- Header -->
<header id="header">
<a href="index.html" class="logo"><strong>Project Portfolio</strong> | Vitor Ferreira</a>
<ul class="icons">
<li><a href="https://vitorhmf.github.io/portfolio/pt" class="image object"><span class="label"><img src="images/flag-br.png" width=35 height=35 alt="" /></span></a></li>
<li><a href="https://vitorhmf.github.io/portfolio/" class="image object"><span class="label"><img src="images/flag-us.png" width=35 height=35 alt="" /></span></a></li>
</ul>
</header>
<!-- Banner -->
<section id="banner">
<div class="content">
<header>
<h1>Welcome to my Analytics Project Portfolio<br /> </h1>
<p>A brief description about my skills and projects</p>
</header>
<p>On this page I present projects developed from public
data, with resolutions of business problems using Data Science and Analytics concepts
and tools. You will also find my professional experiences, skills and contacts.</p>
</div>
</section>
<!--Sobre Mim -->
<section id="banner">
<div class="content">
<header class="major">
<h2>About me</h2>
</header>
<h3 id="content">Hey, I'm Vitor Ferreira.</h3>
<p>With 15+ years of professional experience in business and commercial management, I am a passionate advocate for the
transformative power of data. I firmly believe that data-driven decision-making will increasingly influence
businesses and leaders across all sectors.</p>
<p>Currently, I contribute as a Product Data Analyst at LeadSimple, a leading B2B SaaS company in the US specializing in
property management operations software.</p>
<p>With a strong foundation in Python, SQL, Redshift, Snowflake, DBT, Power BI, AWS, and Agile methodologies, I excel at
empowering Startups and SMBs SaaS B2B growth through data, reducing churn, improving engagement, and driving measurable
results.</p>
</div>
<span class="image object">
<img src="images/perfil.jpg" alt="" width="200" height="200" />
</span>
</section>
<!-- Section Habilidades -->
<section>
<header class="major">
<h2>Skills</h2>
</header>
<div class="features">
<article>
<span class="icon solid fa-laptop-code"></span>
<div class="content">
<h3>Programming Languages and Database</h3>
<ul>
<li>Python for Data Science.</li>
<li>Web Scraping with Python.</li>
<li>SQL for data transformation.</li>
<li>DBT.</li>
</ul>
</div>
</article>
<article>
<span class="icon solid fa-chart-area"></span>
<div class="content">
<h3>Data Visualization</h3>
<ul>
<li>Power BI, Tableau, Metabase.</li>
<li>Matplotlib, Seaborn, Plotly.</li>
<li>Streamlit.</li>
<li>Descriptive Statistics.</li>
</ul>
</div>
</article>
<article>
<span class="icon solid fa-rocket"></span>
<div class="content">
<h3>Machine Learning and Cloud</h3>
<ul>
<li>Regression, Classification and Clustering Algorithms.</li>
<li>Algorithm Performance Metrics.</li>
<li>SKLearn and Scipy.</li>
<li>AWS, Heroku, Git, Github, Virtual Environment.</li>
</ul>
</div>
</article>
<article>
<span class="icon solid fa-handshake"></span>
<div class="content">
<h3>Soft Skills</h3>
<ul>
<li>Assertiveness.</li>
<li>Flexibility and Adaptability.</li>
<li>Problem-solving.</li>
<li>Teamwork.</li>
</ul>
</div>
</article>
</div>
</section>
<!-- Experiências -->
<section>
<header class="major">
<h2>Professional Experience</h2>
</header>
<h3 id="content"> Senior Product Data Analyst @LeadSimple (2024 - current)</h3>
<p>Responsible for implementing the data stack and developing data analysis focused on Product at LeadSimple,
a leading B2B SaaS company in the US for property management operations software. </p>
<h3 id="content">Data Scientist @Dadosfera (2022 - 2024)</h3>
<p>Dadosfera is a cutting-edge startup focused on providing Data Platform services. We deliver consultancy
in data science, data analysis, and data engineering, enabling our clients to achieve sustainable
results through informed, data-driven decisions.</p>
<p> As a Data Consultant at Dadosfera, I am responsible for developing data-driven solutions for a diverse set
of clients, my responsibilities span from conducting the initial ETL processes to implementing machine
learning models and creating compelling data visualizations. </p>
<h3 id="content">Founder & Data Analyst @Metapro Sales & Data (2019 - 2022)</h3>
<p>At Metapro, I was involved in developing commercial solutions that integrate sales strategies with data analysis.
My role encompasses a range of activities, including market mapping, data extraction and analysis, defining actionable
strategies, conducting negotiations and alignments with stakeholders, as well as managing outcomes through key performance
indicators.</p>
<p>One of the main results was the commercial representation of the Mexichem industry (largest
producer of tubes and connections in the world) in the region of Brasília and around Goiás, where
I achieved a <b>262% increase in sales in 2020 vs. 2019</b>, keeping the result in 2021.</p>
<h3 id="content">Senior Sales Manager @Cement Ciplan (2015 -2019)</h3>
<p>Cement Ciplan is one of the largest cement companies in the central west region of Brazil.
In this company, I led sales teams, monitoring and supporting the team based on data analysis,
market context and company KPIs. I also fulfilled the demands of different stakeholders, such
as: customers, sales team, internal commercial, financial, and production team.</p>
<p>Among the results in this period, I highlight the <b>restructuring of 3 sales regions in less than
4 years</b>, developing people, implementing processes, and building results through creative solutions,
such as developing a new product in the market, which increased revenue. and
improvement in the company's profitability in 2017 and 2018.</p>
<h3 id="content">Other Experiences (2008 - 2015)</h3>
<p>At Votorantim Cimentos, the largest cement industry in Brazil, I worked from 2010 to 2014.
I started as a Business Analyst in the Logistics area, focusing on the preparation and maintenance
of management reports and support for field teams based on data analysis and results. About 2 years
later, I went to the commercial area as a Consultant, where <b>I developed solutions for retailers,
industries and construction companies</b> in 3 Brazilian states: DF, GO and TO.</p>
<p>I stayed at Ambev from 2008 to 2009. I worked as an Industrial Quality Supervisor and was responsible
for Quality Control at the Brasília plant, with a strong statistical base and a structure composed
of 4 chemical laboratories and a team of around 20 employees.</p>
</section>
<!-- Section de projetos-->
<section>
<header class="major">
<h2>Data Science Projects</h2>
</header>
<div class="posts">
<article>
<a class="image"><img src="images/loyalty_program.png" alt="" /></a>
<h3> Insiders Loyalty Program </h3>
<p>To deploy a new loyalty program called Insiders, an unsupervised machine-learning
model of <b>Clustering</b> was developed, grouping the customer base according to their
similarities. <br> The group of special customers was formed by 3.7% of the customer base and
represents 37% of the company's revenue</p>
<h4>Tools Used:</h4>
<ul>
<li>Python, Pandas, Numpy e Seaborn.</li>
<li>Sklearn, Scipy.</li>
<li>Clustering Metrics: WSS, Silhouette Score.</li>
<li>AWS Cloud, Metabase.</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/loyalty-program" class="button">Read More</a></li>
</ul>
</article>
<article>
<a class="image"><img src="images/insurance_all.png" alt="" /></a>
<h3>Cross-Sell Campaign </h3>
<p>To increase the sales team's performance during a Cross Sell campaign, a <b>Classification</b>
Machine-Learning model was developed to generate a purchase propensity score and classify
a base of 127 thousand customers. The trained model generated an extra revenue of $25,000,000.00. </p>
<h4>Tools Used:</h4>
<ul>
<li>Python, Pandas, Numpy, Seaborn.</li>
<li>Boruta, Sklearn, Scipy.</li>
<li>KNN, Random Forest, Extra Trees, XGBoost, LGBM.</li>
<li>Classification Metrics: Precision and Recall at K.</li>
<li>Pickle, Flask, Heroku Cloud</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/cross-sell" class="button">Read More</a></li>
</ul>
</article>
<article>
<a class="image"><img src="images/rossmann.png" alt="" /></a>
<h3> Sales Prediction </h3>
<p>Development of a Machine Learning algorithm to predict sales 6 weeks in advance in a pharmacy
chain in Europe. The trained <b>Regression</b> algorithm has 88% MAPE and was made available for queries
through a Telegram bot.</p>
<h4>Tools Used:</h4>
<ul>
<li>Python, Pandas, Numpy, Seaborn.</li>
<li>Boruta, Sklearn, Scipy.</li>
<li>Linear Regression, Lasso, Random Forest Regressor, XGBoost Regressor.</li>
<li>Regression Metrics: RMSE, MAE, MAPE.</li>
<li>Telegram Bot, Flask, Heroku Cloud.</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/sales-predict" class="button">Read More</a></li>
</ul>
</article>
</div>
</section>
<section>
<header class="major">
<h2>Data Analytics Projects</h2>
</header>
<div class="posts">
<article>
<a class="image"><img src="images/dbt_project.png" alt="" /></a>
<h3>Data Professionals in Focus: Brazil vs. USA</h3>
<p>A comprehensive analysis comparing data professionals in Brazil and the USA. Through this analysis,
I dive deep into various roles, experience levels, and salary ranges, offering insights into
the landscape of data professionals in these two countries.</p>
<h4>Tools Used:</h4>
<ul>
<li>DBT, SQL.</li>
<li>GCP, BigQuery, Looker.</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/dbt-project" class="button">Read More</a></li>
</ul>
</article>
<article>
<a class="image"><img src="images/google.png" alt="" /></a>
<h3>Google Data Analytics Capstone</h3>
<p>In this final project of the certification in Data Analytics from Google, the analysis of
data from the Cyclistic company was carried out to generate insights to increase
the conversion rate from casual customers to annual subscribers</p>
<h4>Tools Used:</h4>
<ul>
<li>R, RStudio, Tidyverse, Geosphere.</li>
<li>Tableau.</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/customers-insights" class="button">Read More</a></li>
</ul>
</article>
<article>
<a class="image"><img src="images/seattle.png" alt="" /></a>
<h3>Real Estate Opportunities </h3>
<p> To maximize the company's return on investment, this Data Analysis project was
developed using <b>Python</b> to identify opportunities for homes below the average market price and
define when and at what price to resell these properties.</p>
<h4>Tools Used:</h4>
<ul>
<li>Python, Pandas, Numpy, Seaborn.</li>
<li>VS Code e Jupyter Notebook.</li>
<li>Plotly, Folium.</li>
<li>Streamlit Python framework web.</li>
<li>Heroku Cloud.</li>
</ul>
<ul class="actions">
<li><a href="https://github.com/vitorhmf/sales-insights" class="button">Read More</a></li>
</ul>
</article>
<article>
<a class="image"><img src="images/sales.png" alt="" /></a>
<h3>Sales Dashboard</h3>
<p>Development of a <b>Dashboard in Power BI</b> to visualize the evolution of 4 KPI's:
Revenue, Sales Quantity, Average Ticket and Positivation. The results are detailed in the
project by time period, by product and by collaborator.</p>
<h4>Tools Used:</h4>
<ul>
<li>Power BI, Power Query, DAX Languages.</li>
<li>Excel, Power Point.</li>
<li>Descriptive Statistics.</li>
</ul>
<ul class="actions">
<li><a href="https://app.powerbi.com/view?r=eyJrIjoiN2VjZDUyY2YtNDcxYy00MTljLWI1ZjAtZTJlOWQ4ZGFmNDNmIiwidCI6IjgyOWZmMzMyLTMxYmEtNDg0ZC1iNDQ4LWU1NDYxMzE3ZWZjYSJ9&pageName=ReportSectiona5a2606ecaf70f7e89c8" class="button">Read More</a></li>
</ul>
</article>
</div>
</section>
<!--Contatos -->
<section>
<header class="major">
<h2>Contact</h2>
</header>
<p>Thanks for reading and feel free to get in touch.</p>
<ul class="contact">
<li class="icon solid fa-envelope">[email protected]</li>
<li class="icon brands fa-linkedin"><a href="https://www.linkedin.com/in/vitorhmf">LinkedIn</a></li>
<li class="icon brands fa-github"><a href="https://github.com/vitorhmf">GitHub</a></li>
</ul>
</section>
</div>
</div>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>