Data Analyst Wealth Management

PROFESSIONAL EXPERIENCE

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

Data Analyst, Private Wealth Management Deposits Group

Provided deposit and investment balances data to over 130 teams of wealth managers to increase bank deposits within First Republic Bank every quarter

Maintained private wealth management banking data by merging and synthesizing relevant data from multiple databases such as Microsoft SQL and Snowflake and streamlining methods of accessing and reporting data

Audited data while recognizing and investigating inconsistencies, providing explanation and potential solutions to maintain 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

Used subject matter knowledge of private wealth and deposits areas to ensure requirements were created to enhance systems to meet long term objectives of the deposit promotions group

Analyzed legacy procedures and created new business analysis such as mappings, process flows and risk analysis while updating documentation.

Used an Agile methodology to effectively collaborate with developers and upper management to improve

Created new reporting to increase visibility and trust between private wealth management and bankers to encourage cross-selling and more effective targeting of clients

Was the sole owner of designing a new Deposit Promotion system to help users better communicate info to wealth managers and increase deposits

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

Used Microsoft SQL Server to query info and develop several new queries to track the daily progress of error handling for new Medicare enrollments

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

LICENSES

Series 7 - General Securities Representative - Financial Industry Regulatory Authority (FINRA)

Series 63 - Uniform Securities Agent - Financial Industry Regulatory Authority (FINRA)

Inactive:

Series 24 - General Securities Principal - Financial Industry Regulatory Authority (FINRA)

Series 65 - Uniform Investment Adviser - Financial Industry Regulatory Authority (FINRA

Series 55 - Limited Representative Equity Trader - Financial Industry Regulatory Authority (FINRA)

Series 24 - General Securities Principal - Financial Industry Regulatory Authority (FINRA)

Series 3 - National Commodities Futures Representative

State of California Life Agent

Completed the Investment Foundations Certificate from the CFA Institute March 2024

AREAS OF EXPERTISE

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

Salesforce, Snowflake, MySQL, PostgreSQL, Excel, Google Sheets, Alteryx

Advent APX, Pershing NetX 360, SEI Trust 3000, Thompson Reuters and Bloomberg experience

Basic understanding of Python, Jupyter Notebook, R, Excel VBA, Tableau, Git and Github

Contact this candidate