Administrative Assistant Data Analyst

Joy Watson

Phone: 302-***-**** Email: ***.********@*****.***

Professional Summary

Administrative professional with over 30 years of progressive experience in investment management, data analysis, and executive support. Proven expertise in Microsoft Office Suite, Excel reporting, event coordination, and internal communications. Recognized for organizational excellence, professionalism, and a solutions-oriented mindset in fast-paced corporate environments.

Education

Anthem Institute – Springfield, PA

Coursework in Microsoft Office Applications, Accounting, Web Design, and Programming

Work Experience

PNC Bank Corporate – Executive Administrative Assistant (2021–2023)

- Managed senior manager’s calendar and scheduled meetings based on availability and priorities

- Coordinated and hosted virtual meetings via Teams and Webex

- Handled confidential information with discretion on behalf of executive leadership

- Ordered office supplies and managed procurement through Staples

- Prepared PowerPoint decks for executive leadership meetings

- Managed travel logistics and expense reports using Concur

- Planned and coordinated large-scale events, including venue logistics

- Generated ad-hoc Excel reports for the management team

Vanguard – Data Analyst (2013–2020)

- Created and managed custom 401(k) reports using Excel and Access

- Delivered reporting solutions for internal research, audits, and legal use

- Designed and delivered internal training materials and documentation

- Assigned daily tasks and ensured quality assurance across team deliverables

Vanguard – Data Associate (2003–2013)

- Managed ad-hoc data report requests using multiple internal databases

- Generated ASCII and Excel files per client specifications

- Coordinated legal mailing processes with attention to regulatory requirements

Vanguard – Administrative Associate (1998–2003)

- Managed calendars of Senior Principal Manager and 13 direct reports across a 200+ team

- Handled confidential information with discretion on behalf of executive leadership

- Prepared internal PowerPoint presentations and team documentation

- Planned and coordinated large-scale events, including venue logistics

Volunteer Experience

Volunteer – Delco Helping Hands

Contact this candidate