Vitor Almeida
Viña del Mar, Chile | - |-| Brazilian | www.linkedin.com/in/vitor-loiola
Summary
Throughout 5+ years working with data, I have been exposed to many projects and methodologies, developing handson experience in data analysis, data engineering, data storytelling, dashboard planning and creation, ETL development,
data cleansing, data transformation, data validation and investigation, business requirements, stakeholder’s
communication and Business Intelligence (Data Warehouse, Data Mart, Star and Constellation Schemes). In addition,
I am savvy and skillful in SQL querying, SAS programming, Python (Pandas and Numpy), OBIEE, Power BI, Excel
(Pivot, Formulas and Dashboard) and data manipulation from sources such as: Oracle, MS Server, MySQL, Teradata,
PDF Files, CSV, TXT and Excel files. As a Data Analyst I had the chance to develop business performance enhancing
analyses approaching revenue, credit outstanding and commitment, credit assessment metrics, spending,
demographics, PnL, and others. Some dashboards and ad-hoc analyses included, but not limited to period-over-period
(PoP), YTD, growth, cross tabulation, percentile, median, mode and horizontal (history) analysis. I have also
experienced markets spanning from utilities and electricity to credit and banking across multiple regions such as Brazil,
Malaysia and the US, either located in those regions or remotely connected, being able to naturally communicate in
English, Portuguese and Spanish (written and spoken).
Skills
• BI - Data Warehouse – Data Mart - ETL
• SQL - SAS – Python
• Oracle - SQL Server – Teradata - MySQL
• Excel (pivot tables, formulas, dashboard)
• Tableau – Power BI – OBIEE
• Data Analysis – Data Engineering
Professional Experience
Senior Business/Data Analyst at Evalueserve – Viña del Mar, Chile
Jan/2020 to Current
Multination analytics-focused Indian company, provider of intelligence for top market firms of various segments.
• Work directly with a top 3 US bank, analyzing complex data in order to deliver meaning to business.
• performing credit lending related analyses targeting the behavioral understanding of indicators suchlike
outstanding/book amounts, exposure/commitment, collateral assessment KPIs as BQR, CQR, AQR and LTV,
charge off, recovery, and other attributes of commercial loan portfolio using Excel and Tableau.
• Maintenance and validation of stress testing snapshot databases (IFRS and CECL) through various data
sources and technologies such as SAS, Teradata and Oracle.
• Development of ETL processes and conversion of SAS programs to Python utilizing Pandas, Numpy and
other libraries, connecting to distinct data sources, viz Teradata, Oracle and MySQL.
Data Analyst at CTOS Data System – Kuala Lumpur, Malaysia
Dec/2018 to May/2019
Malaysia’s leading Credit Reporting Agency, driven by credit scoring and credit analysis.
• Measurement of predictive power of variables using bivariate analysis and data treatment for credit score
product intended to incorporate new customers into the credit market based on similar behavior and cross
comparison information. By the time nothing similar was operating in the region due to its complexity,
enhancing the importance of this pioneering project and its benefits to the business and industry at large.
• Data analysis of credit reliability by business type, bad definition, revenue growth, score migration for
banks stablished in Malaysia, namely OCBC, MayBank, CIMB, Alliance and City Bank.
• Comparison of performance and capability of Hadoop platforms (Alibaba vs MapR) for Big Data projects
utilizing the tools Spark/Spark SQL, Pig and Hive (shell and Hue UI) in Unix environment.
• Daily usage of Python and SAS Guide as main tools for analysis and data manipulation.
DBM/BI Analyst at MarketData/Santander Bank – São Paulo, Brazil
Apr/2017 to May/2018
MarketData is the most prized Brazilian marketing firm driven by data and part of the multinational group Geometry Global.
• Development of databases, data warehouse structure and business analyses for the credit and debit cards
department of Santander Bank Group through SAS, SQL Server, SSAS and Excel.
• Elaboration and development of the first united data structure in the cards department, gathering KPIs as billing
and debit amounts, active and activation, spending information and cadastral data. This project made viable
the usage of trustworthy information for the whole department and other decisive sectors, enabling forecast
studies, marketing strategy decisions, simplicity consolidating DRE, daily ad-hoc analyses, and better
communication among the credit related departments.
• Analytical analysis of purchase profitability, assessing the gains among internal products, credit flags and
business type. This project made possible a better planning of the future impact of the contracts with credit
flags (Visa/MasterCard) and formulating decisive strategies for internal products.
• Analysis of customers who perform certain international operations and calculation of related taxation. This
project allowed the correction of a billing systema problem and rebilling of thousands of customers.
• Maintenance and generation of the quarterly report to the brands MasterCard and Visa. Modifications in this
process were constants and Santander Bank is the first Brazilian bank to automatize it due to its complexity.
Education
Bachelor of Technology in Analysis and Development of Systems
FATEC – Faculdade de Tecnologia Zona Sul – São Paulo, Brazil
Language: Portuguese – Native | English – Fluent | Spanish – Advanced.
Jul/2013 to Jun/2016
