Data Analyst Wealth Management

PROFESSIONAL EXPERIENCE

First Republic Bank, San Francisco, CA 6/2022 to 7/2024

Data Analyst, Private Wealth Management Banking Deposits Group

Provided deposit payment and investment reporting information to over 130 teams of wealth managers to increase bank assets within First Republic Bank

Maintained PWM Banking data by merging and synthesizing relevant data from multiple databases and streamlining methods of accessing and reporting data

Audited data regularly while recognizing and investigating data inconsistencies, providing explanation and potential solutions to maintain data integrity

Used Snowflake to generate ad hoc reports for management to help determine the short and long-term goals of wealth managers within First Republic Bank

Worked with technology project managers and developers to help improve the daily processing of all info in private wealth management

Created new reporting to increase visibility and trust between Private Wealth Management and bankers to encourage cross-selling and more effective targeting of clients

TIAA Financial Services, San Francisco, CA 4/2022 to 6/2022

Data Analyst (Contract Role)

Used Bloomberg to monitor and evaluate data quality issues to meet the organization's information system needs and requirements

Developed detailed reports and conclusions for business, finance and investment management based on data summaries

Recognized areas of opportunity and risk through data analysis and modelling and reports findings

Assisted with mathematical, statistical, and economic methods that determine market conditions, project consumer needs and inform business initiatives.

Assisted other areas of the business to model the potential outcomes of implementing various business strategies

Kaiser Permanente, Pleasanton, CA 3/2021 to 4/2022

Medicare Data Analyst (Contract Role)

Interpreted the complex data of Kaiser members with Medicare by applying findings to contextual settings and developing insights, reports, and presentations to management

Prepared data for analytic efforts by integrating and consolidating data, ensuring data quality and accuracy within the error management group

Profiled data inaccuracies and recommended process improvements or system changes to enhance overall quality of the data

Provided user training, support and documentation to other teams within the organization

Translated business requirements, determining data/information needs and data collection methods

Wells Fargo, San Francisco, CA 3/2019 to 9/2020

Data Analyst (Contract Role)

Maintained the accuracy of over 1 million OTC derivate transaction documents and agreement terms data within Salesforce and document repository systems for the Qualified Financial Contracts and Dodd-Frank regulations

Provided re-occurring and ad hoc reporting related to QFC recordkeeping and regulatory documentation requests

Updated business requirements and identified upstream and downstream data flows from document tracking systems to dozens inside and outside of Wells Fargo

Worked closely with project managers in updating changes and enhancements to several document tracking systems and document repository systems

Handled all basic administrative functions including user account maintenance, reports and dashboards, workflows and user errors

Completed monthly data migration and integrations to and from the Wells Fargo Salesforce platform

Completed weekly User Acceptance Testing (UAT) and coordinating within several business teams to ensure Salesforce is operating correctly

Have an understanding of JIRA and knowledge of working with several lines of businesses and technology to make enhancements to the Salesforce CRM system

Allianz Insurance Group, Petaluma, CA 9/2018 to 11/2018

Workers’ Compensation Analyst (Short Term Contract Role)

Updated incoming workers’ compensation claims and tax documents to correct the proprietary database system to provide quick payment on insurance claims

Worked with a dozen adjusters to enter medical, legal and billing info for clients of Allianz Insurance Group

Data Science Program at UC Berkeley Extension, San Francisco, CA 1/2018 to 6/2018

Student

First Republic Bank, San Francisco, CA 1/2015 to 1/2018

Data Analyst (Long Term Contract Role)

Completed due diligence remediation project on 10,000 client trust account files to ensure accuracy of account information and documentation to ensure each file meets standard structure before FDIC audit

Performed data quality compliance testing on over 40,000 Investment Management Agreements (IMA) and Investment Policy Statements (IPS) for the entire division of Private Wealth Management

Worked with over 100 brokers and assistants to help improve mappings of documents and coordinate the data quality of Investment Policy Statements so First Republic could pass upcoming regulatory audits.

Identifying unique brokerage accounts and how to track them with regulators and keeping a do not buy/do not sell list of securities.

Helped communicate with management about the business process flows, flow charts and documenting procedures and process

Collaborated closely with many business teams to help design and debug a new compliance system and make daily changes to data using vlookup, hlookup, pivot tables and basic nested Excel functions.

Used SQL queries for basic UPDATES, JOINS, COUNT, MIN and MAX to send reports to 60 Portfolio Managers bi-monthly and to risk manager for private wealth management division

Wedbush Securities, San Francisco, CA 3/2013-10/2014

Wealth Management Assistant

Provided financial advisors and other staff with back office support for their service requests with multiple departments within operations, compliance and trading

Daily processing of trade confirms, executions, client statements, incoming/outgoing wires, incoming checks and incoming stock transfers.

EDUCATION

Bachelor of Science Degree, Business Administration -Finance Concentration, Sonoma State University GPA 3.3

AREAS OF EXPERTISE

Inactive licenses: FINRA Series 65 Investment Advisor, FINRA Series 24 General Securities Principal, FINRA Series 55 Equity Trader and FINRA Series 3 National Commodities Broker licenses

Traded personal account for 10+ years with complete understanding of options, currencies, and equity markets

Completed the Investment Foundations Certificate from the CFA Institute March 2024

Very basic understanding of Python, R, Excel VBA and Tableau

Salesforce, Snowflake, MySQL, PostgreSQL, Excel, Google Sheets, Alteryx, Advent APX, NetX 360, SEI Trust 3000, Thompson Reuters and Bloomberg experience

Contact this candidate