Steven Zhang Email & Phone Number

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

Toronto, Canada Area

• Extracted large data sets from multiple source systems (Teradata, MicroStrategy, and SAS), performed data profiling, mapping, normalization, and cleaning to ensure the accuracy and consistency of the data;• Streamlined the data extraction process by building an Access database with VBA and SQL scripts to perform automated data extraction and integration from data warehouse (Teradata);• Developed SQL queries in Teradata and MS Access to provide ad-hoc data support for sales team;• Developed complex SQL queries in Teradata to map the missing data in the sales transaction file to improve the data accuracy from 40% to 96%;• Created and maintained regular reports to track performance and KPIs;• Automated in MS Excel and Access with VBA/Macro through exporting, updating and emailing process which increased report efficiency of deliverable by 30%;• Created and updated dashboards to support fields team tracking the sales impact after their store visits;• Designed and built reports in MS Excel to provide store level sales analysis and forecast by comparing target, actuals, and variances on a weekly, monthly and YTD basis; • Developed various highly interactive Tableau dashboards and reports to present and public to different teams;• Worked with marketing team to perform impact analysis for marketing initiatives;• Performed ad-hoc analysis for holiday sales events to identify the most popular products for each region;• Prepared PowerPoint slides for account manager to review KPI performance with clients for the quarterly business meeting;• Documented business process diagrams by applying Cross Functional Flowchart in MS Visio to visualize step-by-step process with involved teams or departments;• Took ownership of multiple projects to meet deadlines, schedule meetings and provide updated statutes on building, testing and implementation of new features into the sales pipeline.

Shanghai, China

• Extracted sales data from Oracle and MS SQL Server, conducted the data cleaning and mapping in MS Excel;• Updated the sales report for senior management team to track sales performance on weekly and monthly basis;• Built Excel spreadsheets for account managers to help forecast sales and cost;• Collabrated with account managers to prepare slides and dashboards in MS PowerPoint and MS Excel for monthly business review.