Juan Manuel Bogarin Email & Phone Number

Buenos Aires, Argentina

Buenos Aires

I am a Lead Analyst in the financial institutions sector, including banks, insurance companies, and investment funds, and in constant contact with key players in the capital markets. My main tasks include:Data Analysis: credit risk analysis of large volumes of information, mainly using Excel, Power Query, Power BI, VBA, SQL, and Python.RPA: process automation tasks using Python, SQL, VBA, Power Automate, and JavaScript. Some relevant projects include downloading information and… Show more I am a Lead Analyst in the financial institutions sector, including banks, insurance companies, and investment funds, and in constant contact with key players in the capital markets. My main tasks include:Data Analysis: credit risk analysis of large volumes of information, mainly using Excel, Power Query, Power BI, VBA, SQL, and Python.RPA: process automation tasks using Python, SQL, VBA, Power Automate, and JavaScript. Some relevant projects include downloading information and files from the web, processing them, reading relevant information, and sending the results to distribution lists.Some other projects:- I created a complete system for recording credit ratings, with different levels of permissions, storing that information in databases. It was crucial for launching Moody's Local in Argentina. This system was exported to other Latin American countries and has been successfully used since 2020.- I designed a VBA programming course for Moody's that I taught in person twice: Mexico (2017) and New York (2018). This course was included in the Moody's University portal for access by all employees globally. Show less

Buenos Aires, Argentina

I teach the subjects "Derivatives Instruments I" (Financial Engineering I) and "Financial Theory of Valuation II".I was a tutor for the CFA Research Challenge for the international stage of the UADE team (2017/18) in Boston, USA.

Buenos Aires, Argentina

Buenos Aires

Buenos Aires, Argentina

Buenos Aires, Argentina

As the Coordinator of the Master's Program in Finance at UADE, I had the opportunity to guide and advise dozens of students in their posgraduate development. This role also involved making strategic decisions for the curriculum.

Buenos Aires, Argentina

Argentina

I mainly worked in the area of investment funds. My tasks included: drafting research reports, credit risk analysis, handling large volumes of data, and programming in VBA for the automation of tools used by the line of business.

Buenos Aires, Argentina

Argentina

- Prepare the budget, forecast and report for the assigned business line, and execute commercial processes (budgets, costs, pricing, and savings), being actively involved in projects.- Execute reliable financial forecasts, handling the proper IT tools. - Analyze and report commercial data. - Give support to the Business Administration Commercial Manager and Director. - Survey costs, budgets, and forecasts.

Argentina

- Evaluated economic-financial viability of companies’ investment projects applying for co-financing. - Gave recommendations directly to Senior Management through daily and weekly reports for each project based on the analysis made, as well as economic-financial follow ups.- Developed VBA macros improving time of analysis, including a MS Excel file which automatically computed parameters based on information entered by the companies such as NPV, IIR, pay-off, among other parameters… Show more - Evaluated economic-financial viability of companies’ investment projects applying for co-financing. - Gave recommendations directly to Senior Management through daily and weekly reports for each project based on the analysis made, as well as economic-financial follow ups.- Developed VBA macros improving time of analysis, including a MS Excel file which automatically computed parameters based on information entered by the companies such as NPV, IIR, pay-off, among other parameters (Designed and proposed to Sr. Management with a co-worker). Show less

Argentina

Masters Degree In Finance, Finance, 8.40 Out Of 10

Oriented to Portfolio Management and Quantitative Methods. Final Dissertation on Macrohedging for Argentina with exotic Asian options.

Técnico Universitario En Programación, Computer Programming

Pre-Quant, Quantitative Finance

Posgrado universitario en el uso avanzado de Python en finanzas.

Licentiate Degree, Finance, Licentiate Degree In Finance

Activities and Societies: CFA Research Challenge 2014/15 (Local winners) Average of 8.95 out of 10. Thesis approved with a score of 10 out.

Licentiate Degree, International Trade, Licentiate Degree In International Trade

Activities and Societies: CFA research challenge Discontinued @75%

Electronic Technician, Electronics, Electronic Technician

Oriented in programming, robotics and telecommunications