Caspian Yang

Greater Boston, MA +1-781-***-**** ad4k4e@r.postjobfree.com https://www.linkedin.com/in/qinghaoyang/ PROFILE

A skilled data analyst with 2 years of experience in data analysis, database management, developing automation systems, and analysis reports. Seeking employment as a Data Analyst to apply proven skills to deliver business insights and develop business solutions. Bringing my master’s degree in analytics and a solid foundation in Python, SQL, and business intelligence software. SKILLS

Technical Skills: Python, R, SQL, PowerBI, Tableau, Microsoft Excel, PowerPoint, SPSS, Dash, HTML & CSS Data Analytics Techniques: Data Visualization, Database Management, Data Mining, Machine Learning, Business Dynamics Soft Skills: Communication, Collaboration, Project Management, Innovation, Leadership, Adaptability, Critical Thinking EDUCATION

Brandeis University Waltham, MA

Master of Science in Business Analytics (STEM-Designated) – GPA: 3.98/4.00 08/2022 – 02/2024 Jinan University Guangzhou, China

Bachelor of Economics in Economic Statistics 09/2018 – 07/2022 WORK EXPERIENCE

Fidelity Investments Boston, MA

Capstone Data Analyst 08/2023 - 12/2023

• Created a user-facing dashboard using Python, HTML, and CSS to analyze data from 6 crypto exchanges, built ETL pipelines using SQL to extract, manipulate, and transform data, integrating 100% more data into the database

• Identified data irregularities on cryptocurrencies’ prices over 12 months, analyzed and found the root cause of data anomalies using Python and R, increasing the data accuracy by 15%

• Initiated and produced a 7-minute video explaining the dashboard’s User Interface features, incorporated into 2 sale pitches to 20 stakeholders and executives with a non-technical background APPLICA Solutions Waltham, MA

Data Analytics Intern 05/2023 - 08/2023

• Developed and implemented a marketing automation system in Python by introducing natural language processing into the marketing process, acquiring 2 new clients from the insurance and healthcare industry

• Managed and updated the company’s advertisement database using SQL, distributed over 1,000 advertisements, increasing the customer-matching system’s accuracy by 11%

• Collaborated with the marketing team to create dashboards in Tableau to display the marketing metrics of over 16 million customers, increasing customer coverage to all 30 seasonal zones of the country Guangdong Zhixue Information Technology Co. Ltd. Guangzhou, China Data Analyst Intern 06/2021 - 08/2021

• Refined and analyzed over 10 million data using Python and R to evaluate the users’ behavioral patterns, transformed the analysis into business findings in presentation to development leaders, increasing user participation by 8%

• Deployed SQL and PowerBI to develop a dashboard of user activity metrics, analyzed and improved user interface experience through statistical analysis, accelerating the acquisition of more than 2,000 new users

• Found and reported 16 bugs in the company’s website, collaborated with 3 development teams to launch new websites and applications, attracting more than 100,000 clicks

Bank of China Guangzhou, China

Data Analyst Intern 01/2021 - 02/2021

• Analyzed financial data from more than 40 branches of banking institutions using Python and R, evaluated trends of customer growth to provide customer acquisition strategy, attracting more than 30 new clients

• Created reports to monitor the performance of more than 40 branches, provided analysis of operations and marketing data using SQL and Excel, increased communication efficiency by 12%

• Collaborated with 3 cross-functional teams to conduct testing on the report distribution system, identified 8 bugs in the system, reduced testing time by 6%