Senior Financial Analyst & Product Developer
Paris, Idf, Fr
Unibail-Rodamco-Westfield is one of largest commercial real estate companies in the world.Highlights:(1) Built new financial product for 36-person finance team that integrated Excel with TM1 and used OLAP database queries to pull in accurate, up-to-date financial information. Led roll-out and training of new product, resulting in 25% reduction in analyst errors.(2) Invented patented methodology using Python, Pandas, SciKit Learn and various machine learning algorithms to predict resource availability for retail properties (patent #: 10,016,897).(3) Designed and led financial analysis on over $1.8B in approved flagship retail development projects, growing forecasted US portfolio operating income by hundreds of millions by collaborating cross-functionally with various stakeholders.(4) Investigated new business opportunities in residential investment and developed an analytical platform for all new residential models, leading to an estimated $1B in predicted incremental value over 15 years.(5) Facilitated creation and review of annual pre-development budgets for assets under supervision (~2M/year), ensuring that all project deliverables were considered and future capital spend was accurately forecasted.(6) Collaborated with Chief Data Officer to craft a proposal of infrastructure requirements necessary to collect data throughout malls to the Board of Directors.(7) Trained four junior analysts and oversaw two national training initiatives for our 36-person team.(8) Served as main financial point of contact for institutional investors such as JPMorgan Chase and Canadian Pension Plan Investment Board. Improved URW IRR by holding partners accountable for money owed based on the contract language of the partner agreement.(9) Headed up national professional development mentorship program, creating curriculum, reviewing applications, proposing and managing $55k budget. Resulted in increased employee engagement and promotions for over 10% of participants.