Open to opportunities

ZhuoJun Lin

@zhuojunlin1

Message

Aspiring data analyst with a strong foundation in financial analysis.

United States

Message

What I'm looking for

I am seeking a role that allows me to utilize my data analysis skills in a collaborative environment, focusing on financial insights and strategic decision-making.

As a recent graduate with a Bachelor of Science in Accounting from Brooklyn College, I have developed a robust skill set in data analysis and financial reporting. My experience as a Data Analyst Intern at Bright Power Inc. allowed me to monitor and resolve data flow issues, ensuring the accuracy of utility bill data for over 350,000 accounts. I led a team of interns in cleaning problematic data and improved the quality of our data pipeline by 10%. My ability to conduct cost-benefit analyses resulted in a 12% reduction in utility usage, saving the company approximately $20,000 annually.

In my previous role at Tyler’s Consumer Goods, I analyzed product feedback and marketing trends, which provided valuable insights into customer characteristics and brand recognition. My analytical skills were further demonstrated when I utilized PivotTables to analyze over 10,000 transactions, identifying high-value customers for targeted marketing campaigns. I am passionate about leveraging data to drive business decisions and optimize operational efficiency.

Experience

Work history, roles, and key accomplishments

Data Analyst Intern

Bright Power Inc

Apr 2024 - Jul 2024 (3 months)

As a Data Analyst Intern, I monitored and resolved data flow issues using MySQL and Python, ensuring the accuracy of utility bill data for over 350,000 accounts. I led a team to clean problematic data and developed Tableau dashboards to forecast energy usage, optimizing utility efficiency.

MySQL Python Salesforce Tableau SQL Excel Data Quality Cost Benefit Analysis Team Leadership Data Visualization

Data Analyst Intern

Tyler’s Consumer Goods

May 2023 - Sep 2023 (4 months)

In my role as a Data Analyst Intern, I analyzed product feedback and marketing trends using Excel, optimizing restock decisions and identifying high-value customers through transaction analysis. I executed pricing analysis to reduce product costs and enhance supply chain operations.

Excel PowerPoint Data Analysis Predictive Analytics Market Research Customer Insights Market Trends Pricing Analysis

Office Team Member

Immigrant Social Service

Sep 2017 - Aug 2019 (1 year 11 months)

As an Office Team Member, I processed bi-weekly payroll and maintained expense reports using Excel. I analyzed financial statements to create budget plans, ensuring sufficient funding for various events.

Payroll Processing Excel Financial Analysis Budgeting Financial Reporting Data Tracking Expense Reporting Financial Statements Event Planning

Education

Degrees, certifications, and relevant coursework

Brooklyn College

Bachelor of Science, Accounting

2020 - 2023

Activities and societies: Participated in various projects related to financial planning and analysis, including a Google Data Analytics Professional Certificate.

Completed a Bachelor of Science in Accounting, gaining a solid foundation in financial principles, accounting practices, and analytical skills necessary for effective financial management.