MS Excel
Anthony Baini
Research Analyst
San Diego,CA
Summary
Data Analyst with experience in consultancy and financial intelligence industry. CFA Candidate currently seeking buy-side role in financial industry across the US. Proven ability to analyze data and perform financial modeling. Passionately curious about financial markets and helping investment companies rise above limitations.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
4
4
Languages
Work History
Data Analyst
Hagerty Consulting
San Diego, CA
11.2022 - Current
- Collect, clean, organize, and manage large data sets in support of a complex humanitarian and public health mission
- Build and manage a dozen spreadsheets containing various Excel functions, pivot tables, and macros to improve collection of data and streamline operations
- Construct dashboards containing data visualizations and statistical tables using Power BI for daily use by the mission's Planning Section
- Perform data scraping to retrieve over 5,000 cost-related data points in bid to support project funding efforts
Research Analyst
Latin American Financial Publications
San Diego, CA
01.2020 - 11.2022
- Built monthly pivot tables for pricing, structure, and volume variables of over five asset classes in Latin America
- Analyzed data and create visualizations of key regional macro and financial trends using Excel, R and Tableau
- Presented budget plans, operational metrics and quarterly financial developments of regional corporations to editorial team
- Detected debt repayment profiles and refinancing needs of over 100 regional companies via Excel and R functions
Financial Reporter
Euromoney Institutional Investors
New York, NY
07.2017 - 08.2019
- Contributed ten weekly articles covering project finance and corporate loan markets across five main Latin American countries
- Updated metrics and timelines of over 100 project finance and corporate loan transactions per month
- Built graphs and visualizations for monthly magazines and research reports using Excel Data Analysis toolkit
- Conceptualized editorial strategy plan that helped improve subscription rates in one year by over 20%
- Moderated industry conference panels exploring key regulatory and business developments
Business Reporter
Inside International Industrials
New York , NY
09.2015 - 06.2017
- Delivered seven weekly proprietary articles covering financial and corporate activity in energy and industrial sectors across Latin American and Asian regions
- Collected proprietary information for database of over five transactions per day
- Modernized data system by streamlining data entry process on back-end, improving KPI metrics for team of 20
- Provided research analysis of project and trade finance markets by industry and geography for customized market reports
Education
Master of Arts - Economics
Claremont Graduate University
Los Angeles, CA 09.2020 - 05.2022
Bachelor of Arts - Economics & International Relations Double Major
New York University
New York 09.2011 - 05.2015
Skills
Quantitative Analysis
undefinedSoftware
R
Tableau
Bloomberg Terminal
VBA
SQL
Power BI
Python
Certificates
- Certified Financial Analyst (CFA) Candidate
- University of Chicago: R for Data Science Credential
- Coursera: Finance and Quantitative Modeling for Analysts, Decision-Making and Scenarios, Introduction to Corporate Finance, Fundamentals of Quantitative Modeling, Problem Solving with Excel, SQL for Data Science
Timeline
Data Analyst
Hagerty Consulting
11.2022 - Current
Master of Arts - Economics
Claremont Graduate University
09.2020 - 05.2022
Research Analyst
Latin American Financial Publications
01.2020 - 11.2022
Financial Reporter
Euromoney Institutional Investors
07.2017 - 08.2019
Business Reporter
Inside International Industrials
09.2015 - 06.2017
Bachelor of Arts - Economics & International Relations Double Major
New York University
09.2011 - 05.2015
Similar Profiles
Karrah SavageKarrah Savage
Disaster Recovery Associate at Hagerty ConsultingDisaster Recovery Associate at Hagerty Consulting
Makayla KellyMakayla Kelly
Project Manager at Hagerty ConsultingProject Manager at Hagerty Consulting
Shante WeberShante Weber
Legal Secretary at Hagerty Consulting IncLegal Secretary at Hagerty Consulting Inc