Steven Zhang

Background

About Steven Zhang

Over 5-year data analysis and reporting experience in retail industry with proven ability to extract, manipulate and analyze large data sets from various sources and create complex dashboards and reports; • Hands-on experience with different BI tools, including Teradata, SAS, Oracle, MicroStrategy and Tableau, for data analysis and visualization; • Solid knowledge of ETL technologies and process, including data extraction, cleaning, transforming, validation and consolidation; • Expertise in MS Excel, including but not limited to LOOKUP, PivotTable, Array Formulas, What-If Analysis, Power Query and Data Analysis Tools; • Solid experience with MS Access including design, develop and troubleshoot database and applications, create table, SQL queries forms, reports, and modules; • Proficient in developing VBA and Macro programs in MS Excel and MS Access to automate processes to improve efficiency; • Proficient in complex SQL, stored procedures with advanced knowledge of Relational Database Management Systems; • Advanced knowledge of SAS with SAS Certified Base Programmer, experienced with SAS coding for data modeling, profiling, and analysis.