Senior Analyst

• Jul 2022 - Present

Private Wealth Management Co-op

• Jul 2021 - Dec 2021

• Built 3 MS Excel macros using VBA to automatically update T-list status and portfolio-review notes per PWA, and to record monthly EAFE and ACWI Index country composition • Supported PWAs in cultivating and strengthening relationships with prospects and existing clients by generating month-end and mid-month CIOs, GOAS, and PE commitment planner reports • Utilized Bloomberg and GIR platform to assist PWAs in finding research reports for clients about stocks, industries, sectors, and the latest events in the financial markets • Assisted in client equity and fixed income portfolio building by evaluating investment strategies (SMAs, LLCs, GMS) through assessments of historical performance and data trends • Modified and upgraded an onshore and offshore mutual funds historical performance excel to improve accuracy by automatically retrieving returns from the Bloomberg terminal and comparing performance to a benchmark • Analyzed the market value and historical performance of over $270M invested in GMS, and compared the strategies’ returns to their respective benchmarks based on data from their factsheets and PWM Desktop • Collected data and developed detailed spreadsheets to create an Alpha analysis per strategy for a $150M portfolio

Accounting Co-op

• Jul 2020 - Dec 2020

• Utilized Oracle reports and Business Objects queries to analyze and explain month over month variances for other costs and revenue and to address questions and/or research issues • Updated assets within the FA system on a weekly basis so the depreciation method would be correct for the month-end journal entry • Created monthly journal entries and performed various balance sheet and expense account reconciliations • Performed weekly Billing Rate Differential reports using Business Objects queries to support other finance departments. • Collected ACH forms and updated employees’ profiles with their respective banking information in Oracle’s AP system on a daily basis • Supported the US Accounting and Accounts Payable teams with special projects as needed

Cashier and Customer Service Representative

• Jan 2013 - Feb 2017

• Maximized customer satisfaction by taking customers’ orders, listening to their comments, responding appropriately and forwarding issues as necessary • Assisted the restaurant manager in administering finances and leading business operations, including running payroll, making bank deposits, and analyzing income and expenses to maintain cost-effective operations • Maximized customer satisfaction by taking customers’ orders, listening to their comments, responding appropriately and forwarding issues as necessary • Assisted the restaurant manager in administering finances and leading business operations, including running payroll, making bank deposits, and analyzing income and expenses to maintain cost-effective operations