Camilo Durango Salguero
Financial Analyst at San Francisco Association of REALTORS- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Spanish Native or bilingual proficiency
-
English Full professional proficiency
Topline Score
Bio
Credentials
-
SQL For Joining Data
DataCampNov, 2022- Oct, 2024 -
Cleaning Data in Python
DataCampSep, 2022- Oct, 2024 -
Intermediate Importing Data in Python
DataCampSep, 2022- Oct, 2024 -
Introduction to Git
DataCampSep, 2022- Oct, 2024 -
Introduction to Importing Data in Python
DataCampSep, 2022- Oct, 2024 -
Python Data Science Toolbox Part 2
DataCampSep, 2022- Oct, 2024 -
Analyze Financial Data with Python Skill Path
CodecademyAug, 2022- Oct, 2024 -
Data Manipulation with Pandas
DataCampAug, 2022- Oct, 2024 -
Data Types for Data Science in Python
DataCampAug, 2022- Oct, 2024 -
Exploratory Data Analysis in Python
DataCampAug, 2022- Oct, 2024 -
Intermediate Python
DataCampAug, 2022- Oct, 2024 -
Joining Data with Pandas
DataCampAug, 2022- Oct, 2024 -
Learn the Command Line Course
CodecademyAug, 2022- Oct, 2024 -
Python Data Science Toolbox (Part 1)
DataCampAug, 2022- Oct, 2024 -
Learn Python 3 Course
CodecademyApr, 2022- Oct, 2024 -
Decision-Making and Scenarios
CourseraJan, 2022- Oct, 2024 -
Modeling Risk and Realities
CourseraSep, 2021- Oct, 2024 -
Introduction to Spreadsheets and Models
CourseraAug, 2021- Oct, 2024 -
Fundamentals of Quantitative Modeling
CourseraJul, 2021- Oct, 2024
Experience
-
San Francisco Association of REALTORS
-
United States
-
Real Estate
-
1 - 100 Employee
-
Financial Analyst
-
Sep 2020 - Present
Financial Planning Reporting & Budgeting: - Efficiently managed budgeting process and cashflow forecasting of ~8MM+ USD operation by connecting management's long-term vision to a structured, actionable financial plan. - Lead monthly presentations of financial statements, membership counts, ongoing projects, and any relevant insights found throughout monthly analysis with the CFO and CEO in the Budget & Finance committee. - Built a 5-year cash flow forecast for the IRS as a requisite for the application to Public Charity status, which led to the approval and successful transition of the Association's foundation. Finance Operations Management: - Built a dashboard in Excel with multiple charts and Pivot tables by scraping data from the operating credit line online portal to monitor daily expenses in the operating credit line and manage costs more efficiently. - Automated the formatting of the financial statements for distribution with VBA increasing accounting operations efficiency. - Restructured billing operations and processes for Data Feeds products by replacing manual billing with Real Estate-focused accounting software (Rapattoni Magic), supporting an increase of 10% in Data Feeds Royalties revenue. Show less
-
-
-
US Angels
-
United States
-
Venture Capital and Private Equity Principals
-
1 - 100 Employee
-
Business Analyst Intern
-
May 2020 - Jul 2020
Intern position to support US Angels, an investment company located in the San Francisco Bay Area, on various business matters: - Collected relevant information in Google Sheets during weekly funding rounds meetings where startups would make their pitches to build a database with prospective investment opportunities for US Angel members by analyzing the startups' metrics and positions in their respective markets. - Collaborated with multiple team members to maintain the database up to date. - Participated in weekly investor calls where startup selection occurs by data-driven presentations and summaries. Show less
-
-
-
StarCubed
-
Professional Training and Coaching
-
Business Analyst Intern
-
May 2020 - Jul 2020
Intern position to support on early stages of the accelerator and attract startup talent to its program. - Coordinated a research project to explore investment opportunities through its startup accelerator program in 2 months, which resulted in 2 meetings with prospective Latinamerican business partners. - Gathered and extracted data on more than +60 Latinamerican startups through online databases by performing selective analysis to meet CEO's requirements. - Sorted collected data by defined parameters such as funding, stage, and location to merge top performers of +60 potential accelerator participants using Google Sheets to the master database. Show less
-
-
-
Gomez Velasquez SAS
-
Colombia
-
Financial & Business Analyst
-
Feb 2019 - Jun 2019
Contractor position to participate as a critical contributor in the financial restructuration, ratio analysis, and company valuation: - Created an extensive financial ratio analysis of the past five years of the company from raw financial data by performing complex operations in Excel. - Facilitated +20 meetings with C-Executives to get feedback and evaluate partial findings to deliver high-quality analysis to their expectations. -Communicated meaningful research and analysis insights to the CEO, Board, and other C-Executives in a digestible manner. - Performed complex Excel modeling to retrieve raw financial data, cleaned it and organized it to build a model that effectively reflected the company's value. Show less
-
-
-
Banco Davivienda
-
Colombia
-
Financial Services
-
700 & Above Employee
-
Investment & Equity Intern
-
Jan 2018 - Jul 2018
- Coordinated over 100 monthly customer account operations with direct report to Senior Account Executive. - CRM Maintenance & Client Prospection - Created a daily financial newsletter for the private equity department to optimize information around critical financial data within and outside the country. - Optimized client research processes throughout an excel database with prospects clients. - Facilitated +150 monthly international investment account operations in coordination with subsidiaries from Panama and Miami. Show less
-
-
-
Trejos Restrepo LTDA
-
Colombia
-
Financial Analyst
-
Feb 2016 - Feb 2017
Financial Statements Analysis, Company Valuation & Consulting Financial Statements Analysis, Company Valuation & Consulting
-
-
Education
-
Hult International Business School
Master's degree, International Business, Data Analytics Specialization -
Springboard
Bootcamp, Data Science -
The Wharton School
Course, Business Statistics -
Universidad Católica de Pereira
Bachelor in International Business, International Finance -
University of Northern Iowa
English / Exchange Student