Juliana Serapio

Responsible for setting up the budgeting process and its modeling for all business lines. Ad-hoc analysis on business relevant topics.

Performing quantitative, statistical, and econometric modeling using R and Excel. Summarizing current economic trends and forecasts for senior management and internal stakeholders. Conducting competition analysis in the Real estate industry.

Development and maintenance of the company financial and pricing models (including cash flow forecast) for co-living business. Support on financial controlling and business planning routines and reports. Cost, revenue forecasts.

Responsible for macroeconomic research and modeling of real economic indicators. In charge of updating databases, forecasts, economic trends analysis and daily reports on economic data releases. Develops a monthly research entitled "Intenção de Consumo das Famílias" (ICF) that can be found at the company's website and in a variety of media outlets. The research analyses the consumer behavior and confidence over economy in every capital city of the country.

Analysis of projects economic viability in the Oil & Gas industry (FPSO, Subsea EPCI contracts): Capital Structure, Project Finance, IRR, NPV, IL. Supervision of management and administrative activities of the business (Reports Capex / Opex, Sources & Uses Agreements, Joint Ventures). Analysis and implementation of financial statements (Income Statement, BS, Cash Flow Statement) and management reports using Hyperion.

Responsible for the monitoring of market, liquidity and credit risk of the bank and the group’s asset management. Also responsible for the development of Basel II monitoring reports for the Central Bank.

Economic evaluation of a variety of investment funds, including Value at Risk, stress testing analysis, CAPM modelling, Markowitz frontier modelling, etc. Automated report development using Visual Basic programming.

Responsible for monitoring of market, liquidity and credit risk of the bank and the group’s asset management.

Intern responsible for supporting activities for the economic modeling of all the company's products. Analysis of the utility of the products and the demand curve.

Finance and Risk.