Data Engineer/Business Intelligence

Ruizhe (Rick) Chen

*********@*****.*** 949-***-**** 70 Queens Wharf Rd, Toronto, ON, M5V 0J2

EDUCATION

University of California, Irvine Irvine, CA

Bachelor of Arts in Economics Sep 2022

Bachelor of Arts in Philosophy

SKILLS & COURSES

Technical Skills:

• Proficient in SQL, Python, and AWS (AWS Certified Cloud Practitioner)

• Experience with C++, Matlab, and MS Office suite

• Familiar with Agile and Scrum methodologies

• Strong analytical and problem-solving skills

• Knowledge of Tableau, JIRA, Salesforce, and Power BI

• Basic understanding of database and business intelligence concepts

• Experience with data analysis, visualization, and dashboard creation Coursework:

• Strong analytical background with coursework in Applied Econometrics, Statistics, Probability, Macro & Micro Economics, Corporate Finance.

• Completed computer science courses including Programming Software Library, Programming in Python/C++, SQL, Boolean Algorithm and Logic, Database Management.

• Philosophy courses in Logic, Ethics, Epistemology, and Metaphysics, which contributed to critical thinking, argumentation, and communication skills. PROFESSIONAL EXPERIENCE & PROJECT

Freelance Work Toronto, ON(Remote)

Part-time Data Engineer (tools used: Jupiter Notebook, Panadas, AWS ) April 10, 2023 – May 5,2023

• Engineered an advanced data integration solution that merged a dataset of 1.4 million Q&A records with a comprehensive product metadata catalogue consisting of 142.8 million entries.

• Utilized Jupyter Notebook and pandas to systematically extract critical information, including Amazon Product IDs (ASINs) and image URLs associated with each Q&A.

• Devised and executed an AWS S3 bucket-based image retrieval system. Leveraged ASINs and image URLs to automate image downloading, further updating the data set with respective full file paths.

• This sophisticated system significantly enhanced the organization's capacity for further machine learning training and data analysis operations.

• Proven adeptness in handling vast volumes of data, exhibiting solid technical skills in data engineering and contributing significantly to the acceleration of data-driven initiatives. Team Crush Sport Inc. Shenzhen, China(Remote)

BI DeveloperIntern (tools used: Google BigQuery, Looker, SQL Server, SSIS, PowerBI) June, 2020 – September,2020

• Extracted Daily Active User (DAU) data from complex raw data sets using SQL on Google BigQuery, ensuring data accuracy and completeness.

• Applied data manipulation techniques to transform and organize the data into tables based on various dimensions such as platform and region, enabling streamlined analysis and reporting.

• Utilized Google Looker and Power BI to create visually compelling dashboards and charts that effectively communicated key data insights to stakeholders.

• Developed and maintained SSIS packages and SQL Server jobs, as well as other database objects (views, stored procedures, triggers, etc.).

• Implemented automation solutions that significantly reduced reporting time and minimized errors, resulting in improved overall efficiency and productivity.

• Worked on ongoing processes including company management, budgeting, forecasting, reporting, and other strategic, operational, or financial analysis as needed.

• Demonstrated ability to work in a fast-paced environment and adapt to changing priorities.

• Successfully assisted the data analysis team in reducing report generation time by 20%, while also improving data accuracy by 10% and providing the Business Intelligence team with an additional 25% of referenceable data content through query optimization. Sustainability Analysis Project Irvine, CA

Student Researcher (tools used: MS Office suite, Matlab) June, 2021 – August,2021

• Completed 60% of the data collection work for the team's data model establishment, ensuring accurate and relevant information was used in the model.

• Conducted thorough analysis of the Southern California Disposable Tableware Industries, using economic theories and statistical techniques to build a data model, completing 50% of the work for constructing the data model.

• Evaluated data output and summary statistics to ensure they met sustainable development standards, and conducted feature importance analysis on the data model.

• Analyzed the most influential factors and proposed potential solutions based on the analytical results, and utilized econometric models to test the feasibility of proposed solutions.

• Utilized tools such as MS Office suite, Matlab, and econometric models to conduct research reports, analyze data, and propose solutions, completed 80% of the work in visualizing the data model in reports.

• Collaborated with cross-functional teams and demonstrated strong communication and interpersonal skills throughout the project.

Chinese Intercultural Society (Student Organization) Irvine, CA Event Organizer and Team Coordinator (Volunteer)

October, 2018 – June, 2020

• Coordinated with various stakeholders to organize sports events, ensuring smooth operations and adherence to schedules.

• Acted as a liaison between teams, club officers, and university administration, maintaining clear communication channels and addressing concerns as needed.

• Managed event budgets, allocating resources effectively to maximize the overall event experience for participants and spectators.

• Developed and distributed marketing materials to promote events and attract participants, utilizing social media and other channels to increase visibility and engagement.

• Successfully organized multiple events, including 2 campus recruitment events, 4 offline events with the participation of both local and Chinese international students, and a cross- campus offline event with participants from UC Irvine, UC LA, and UC San Diego.

Contact this candidate