Learn Data Skills
Beta
Stefan Rangel

Stefan Rangel

Business Data Analyst

KAVAK | Mexico City

Technologies

My Portfolio Highlights

My New Workbook

Project: Analyzing Students' Mental Health

My New Workbook

Project: Analyzing Students' Mental Health

Python, SQL, R, Machine learning for Stock Market Predictions

My Work

Take a look at my latest work.

course

Understanding Data Science

PythonSQLExcel
course

Intermediate Python

Python
DataLab

Project: Investigating Netflix Movies

DataLab

Project: Analyzing Students' Mental Health

course

Understanding Data Science

PythonSQLExcel

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Cambridge English Qualifications B2 First English

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to R
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

Kavak.com | Aug 2024 - Present

Data Analyst - Process Automation

Automated Inventory report process using Python and SQL, reducing time from 8 hours to just 5 minutes. Identified applications for Daily Cash management within 5 minutes, overseeing debt for three trusts (BBVA, Santander, and Goldman Sachs). Working with databases containing up to 3 million rows, and daily processing of datasets with approximately 500,000 rows from Netsuite Currently developing automation for P&L reporting both for Mexico and globally, streamlining processes for greater efficiency and accuracy
Show More

Bolsa Mexicana de Valores | Jan 2024 - Aug 2024

Finance Intern and RPA Flows

In charge of RPA (Robotic Process Automation) workflows, using platforms such as Amazon Web Services to automate information through robots enabling API integration. Managed daily financial market data (1 million rows per month), ensuring accurate and timely updates for financial reporting. Conducted financial reconciliations of accounts with custodians such as Euroclear, BCP, and Citibank.

Abbott | May 2023 - Dec 2023

Finance Intern

Responsible for managing the Fixed Asset Census, Contracts, and accounting for additions and disposals of diagnostic equipment and instruments. Liaised with hospitals and distributors nationwide (Mexico) to ensure accurate asset tracking and updates. Created and maintained a database with up to 300,000 rows to streamline asset management and reporting.

My Education

Take a look at my formal education

B.A in FinancesTecnológico de Monterrey | 2024
Data analytics in FinancesTecnológico de Monterrey | 2023
Specialization in in Fund Management and Alternative InvestmentsTecnológico de Monterrey | 2023

About Me

Stefan Rangel

Graduated with a B.A. in Finance from Tecnológico de Monterrey with a keen interest in data analytics and investment. I am experienced in using SQL, Python, Rstudio, and Excel for financial data analysis, as well as developing investment models.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free