Data Analytics Analyst Intern

Tra Dinh

223-***-**** *********************@*****.*** Linkedin Portfolio

EDUCATION

Dickinson College Carlisle, PA

Bachelor of Science in Data Analytics and International Business and Management Expected May 2026

● Relevant Coursework: Introduction to Computing, Data Science, Data Systems for Data Analytics, Economic Managerial Decision Making, Financial Accounting, Finance, Econometrics, Probability and Statistics I, Machine Learning Supervision.

● Affiliations: Rewriting the Code, Girls Who Code, Society of Women Engineers. WORK EXPERIENCE

NielsenIQ May 2024 - August 2024

Market Research Analyst Intern

● Achieved $15,000 in sales by analyzing data from over 200 banks using Excel (PIVOT TABLES) to support content for selling and promoting the Personal Finance Monitoring Report.

● Reduced processing time by 30% by designing automated costing sheets in Excel for two major clients, utilizing advanced nested formulas (VLOOKUP, IFNA) to optimize financial calculations.

● Boosted stakeholder engagement by 40% through focus group research at Diana Unicharm JSC, gaining critical product insights to enhance consumer understanding.

United Way January 2024 - April 2024

Volunteer Income Tax Assistant Intern

● Utilized TaxSlayerPro to process complex tax data, maximizing returns and ensuring compliance with current tax regulations.

● Conducted in-depth financial interviews for 50+ low-income residents in Cumberland County, strategically optimizing tax filings to maximize refunds, and providing critical support to underserved communities. BIDV - Bank for Investment and Development June 2023 – August 2023 Data Analyst Intern

● Enhanced data quality and processing efficiency by 40% by collaborating with two mentors to develop robust ETL pipelines using Oracle SQL.

● Reduce manual reporting time by 20% by creating interactive OBIEE dashboards for the Customer Service Department.

● Optimized reporting workflows using Oracle SQL, achieving 98% accuracy, 25% efficiency gains, and 91% data integrity across 20+ banking KPIs, enhancing Q3-Q4 decision-making. PROJECTS

Stock Market Performance Analysis GitHub

● Developed Python to extract, analyze, and visualize 252+ real-time stock prices, volatility, bank correlations, and moving averages from Yahoo Finance.

● Implemented the ARCH model to predict volatility and deliver insights supporting investment analysis and risk management for four major financial institutions.

Stanford Open Policing Project GitHub

● Leveraged Python to normalize 200,000,000 traffic stop records from the Stanford Open Policing dataset.

● Processed Python to analyze and visualize the normalized data, uncovering patterns in violations, frisks, and arrests by gender and weather providing actionable insights to reduce violations in Rhode Island. New York City Airbnb Analysis GitHub

● Applied SQL with the Northeast Big Data Innovation Hub to analyze NYC data, revealing key trends and metrics that improved Airbnb occupancy rates and pricing strategies.

● Created Tableau visualizations of NYC Airbnb data, delivering insights that boosted market penetration and optimized pricing in target neighborhoods.

LEADERSHIP EXPERIENCE

Vietnamese Student Association, President August 2023 - Present

● Collaborated with the Vietnamese Embassy, organized cultural and sports events, and led a fundraising coffee event that exceeded profit expectations by 200%.

SKILLS

● Programming Languages: Python, R, SQL.

● Software and Tools: PowerBI, Tableau, Excel, Oracle, Microsoft Office, Google Workspace, Stata, PostgreSQL, NoSQL, Git.

● Analysis Skills: Data Wrangling, Data Visualization, Regression Analysis, WebScrapping.

● Project Management: Market Research, Agile development, Proposal Writing.

Contact this candidate