Enhanced Portfolio

About Me

Victor Eduardo Mendez is a Business Analyst with over six years of experience in business intelligence and data analytics within the banking industry. Based in Chicago, IL, with an MBA in Finance from Loyola University Chicago and a Bachelor's degree in Computer Engineering from Universidad Iberoamericana (UNIBE).

Proficient in Python, SQL, Power BI, Tableau, and Excel, with a strong background in data-driven decision-making processes to support business goals and enhance operational efficiency.

Passionate about continuous learning and data science, as evidenced by certifications in Business Data Analytics and Data Science.

Feel free to explore the projects and skills, and don't hesitate to get in touch to discuss potential collaborations. You can also check my resume for a more detailed overview of my professional experience.

Projects

Data Warehouse for Retail Stores 📊

Designed and implemented a fully functional Data Warehouse (DWH) that integrates financial and operational data to support advanced analytics and reporting for retail business.

Developed a relational schema and entity relationship diagram using erdplus.com.
Designed fact and dimension tables for tracking revenue, expenses, budgets, and transactions.
Wrote SQL queries to create tables and insert values

🌟 Key Outcome: This project empowers businesses with data-driven decision-making, ensuring financial transparency and efficiency.

Financial Analysis & Valuation Project 📈

Conducted a financial analysis and valuation of NVIDIA (NVDA) 💹 using Tableau for Data Visualization and Python for data analysis. Key highlights:

Estimated the intrinsic value per share using Free Cash Flows and a Terminal Growth Rate.
Analyzed the impact of WACC and Terminal Growth Rate variations on valuation.
Performed Value at Risk (VaR) analysis, revealing moderate volatility and downside risks.

🔍 Key Takeaway: Gained insights into NVIDIA’s financial performance and demonstrated the importance of robust valuation models for informed investment decisions.

World Libraries (Tableau)

This project showcases a comprehensive Tableau dashboard that visualizes data on libraries around the world. The dashboard includes three key views:

A bar chart illustrating the total number of libraries by region.
A crosstab detailing expenditures, total libraries, and total users by country.
A global map view highlighting the distribution of libraries by country, with an interactive filter by region.

The data visualization provides valuable insights into the global distribution and expenditure on libraries, helping stakeholders understand regional differences and resource allocation.

Economic Indicators Dashboard (Power BI)

Developed a Power BI dashboard to visualize key economic indicators for the Dominican Republic, the US market, and the global economy. Key visualizations include:

Inflation rates and GDP growth trends for the Dominican Republic.
Public debt levels and foreign exchange reserves.
US market indices such as NASDAQ, S&P 500, and Dow Jones, along with Treasury bond yields.
Economic growth rates across the Dominican Republic, US, Latin America, and the Eurozone.

Analysis of Spotify Top Songs (Excel)

Analyzed Spotify's top songs across 73 countries using Kaggle data, focusing on popularity, explicit content, and audio features. Key insights include:

Percentage of explicit songs and their average popularity, with a focus on the Dominican Republic.
Comparison of popularity between explicit and non-explicit songs.
Analysis of audio features such as energy, tempo, and loudness.
Global trends in song popularity and explicit content visualized through charts and pivot tables.