Yichen Wang Email & Phone Number

Toronto, Ontario, Canada

Project: Excel report enhancementDescription: This Project is working on technology enhancement to modernize, optimize, and consolidate the existing version of the analysis platform based on Excel VBAResponsibilities: Analyzed the business requirements and complete system design for several data analysis project Combined Excel spreadsheet formula and VBA codes to create dashboard, dynamically showing data query from spreadsheets Built useful reports and analytics that allows the company to assess core KPIs across departments Response to requirements from customers, using Pivot table to aggregate order amounts and number of orders by sales dateProject: Access form enhancementDescription: This Project is to design more new forms to allow users to add new data, and also support update and delete existing data based on Access VBAResponsibilities: Analyzed the business requirements and complete system design for several data analysis project Responsible for end-to-end data processing execution, including data cleansing, extraction, transformation and loading, manipulation, aggregation and analysis Made up and cleaned up data using SQL Server for requirements and development Used dynamic SQL query to generate required outcomes Used Microsoft Power BI to assist the company in defining, measuring, and improving KPI

Toronto, Ontario, Canada

 Gathered business requirements to understand the business needs and to determine how systems and applications can best functionally fulfil those needs Assess, research, analyze, and documenting the objective, scope, and purpose of the Business requirement solution and identified detailed Business and System Requirements Analyze customer’s ecommerce product data by using SQL queries Assisted in creating Test Plans and Test Cases by analyzing the Business requirements and System Requirements for the various functional modules in the application Trained customer how to use the application and supported for UAT Worked closely with business partners and key groups to ensure successful project delivery

 Developed new partners and discussed cooperation agreements Maintained trainee information by using Excel, and analyzed data by using Pivot table Made schedules and organized events for various training groups, communicated with instructors Designed and maintained website, managed Wechat Official Account

Beijing, China

 Designed test cases for performance verification of TD-SCDMA solutions according to customer requirement, built test environment, wrote test documents and test reports  Presented lectures to internal engineers on physical layer algorithm of TD-SCDMA technology

Master Of Applied Science, Computer Engineer, Gpa 4.0

Master Of Information Engineering, Signal And Information Processing