Hello! I am

Russell Sun

Capital One Retail Bank Marketing, Senior Data Analyst

Certified ScrumMaster® | Certified Scrum Product Owner (CSPO®)

About Me

Jack of all trades, master of "some"


Data analyst with 4 years experience of marketing platform and data product management in the financial industry. Demonstrated impact on projects that deliver new functions and tools to fulfill marketing requirements, risk management, and product roadmaps. Strong applied Python and SQL skills for data analytics.



Profile

Location: McLean, VA
Phone: 608-421-8477
Email: swqruss@gmail.com

LinkedIn Tableau Public
Placeholder image

Skills

Data Analytics Skills: Python, SQL, Tableau

Business Understanding: Retail Products, Marketing, Risk Management

Product/Project Management: Agile, Scrum, SDLC, JIRA

Classic Music and Art

Hobbies: Tennis, Golf

Projects

Here are what I've done in the past. Click on headers to know more details of the projects.



Stockview Website by Flask

Developed a full-stack Flask web application with an intuitive interface for viewing stock performance in the past 18 months, leveraging web design, Matplotlib integration, and multiprocessing; analyzed and processed historical data from Yahoo finance API to identify moving average lines and phased trends to generate a dynamic stock market look and insights on the equity market.





Placeholder image
Analyzing Bike Manufacturer Operations

Built Tableau dashboards including bar charts, line charts, tree maps, doughnuts, and geographic visualizations, delivering four-year business overview of three product lines, product categories, and customer types across five countries. Analyzed trends in price and cost growth; calculated profit margins by item with discounts, generating potential marketing strategies for discount types and risk management recommendations for supply chain operations.

Placeholder image
Bear Market Observatory

Built data pipelines in R to extract historical stocks performance with API from Yahoo Finance, clean and format the dataset, identify lengths and amplitudes of bull and bear markets and corrections regimes, and create a dynamic market book. Analyzed S&P 500 Index performance and market recovery time using dashboards and word clouds; established relationships between market index and 200-day-MA, generating insights into equity market. Placeholder image

Resume

More about my past experiences


Download My Resume

Contact Me


I started working with Capital One in December 2023, assisting its Retail Bank Marketing and Technology team. I previously worked in Citi global finance data team. Please get in touch with me on LinkedIn if you are interested in what I've been working on.