Data Specialist

YILE JI

905-***-**** adokxy@r.postjobfree.com Toronto, ON

HIGHLIGHTS

Strong quantitative and statistical background experience working with structured and unstructured data.

Proficient in applying analytical tools (SQL, SAS, Python, Excel, Tableau, C#) to manage, manipulate, validate, analyze, and visualize data.

Technical reports writing and presentation skills gained through document development and user training.

Experienced in business automation using MS Power Platform and MS Office Suite.

Knowledge of Web Development and related programming language (HTML, CSS, JavaScript). PROFESSIONAL EXPERIENCE

Data Specialist Sep 2020 - Present

GVA Lighting Inc., Oakville, ON, Canada

Automated inside business process using Power Apps, Power Automate, and Power BI to integrate reporting with MS Office Suite (SharePoint, OneDrive, Outlook, and Teams).

Integral to an ERP data migration project, performed data ETL process, maintained and updated the database as necessary.

Prepared datasets for Testing, conducted Epicor ERP UAT and resolved problems before final launch.

Developed customized dashboards and configurators within the Epicor using SQL Server and C# for rapid data analysis and product development purposes.

Performed consultation service and provided timely technical support after software launch.

Composed standardized user manual for internal use and delivered end-user training to over 50 people. Production Engineer (Intern) Aug 2018 - Mar 2019

Cascades Tissue Group, Scarborough, ON, Canada

Led and coached several work teams to execute production schedule to meet the delivery commitment.

Managed and maintained SAP inventory and logistics database and updated them with supplier and customer information using SQL Server on a regular basis.

Compiled SQL queries to extract data for analytical and reporting purposes.

Performed monthly and yearly KPI analyses and generated reports with SAP Analytics Cloud to assist management team for continuous improvement purposes.

Forecasted raw material demand with former inventory data analysis to support production planning. PROJECTS

Data Analytics

Quantium, Virtual Experience Jul 2020 - Aug 2020

Carried out data cleansing, validation, manipulation to detect and deal with outliers and missing values in python (numpy and pandas), enhancing the accuracy and integrity of the data.

Leveraged and analyzed transactional sales data to explore sales trends, store performance, product penetrations, customer distribution, and purchase patterns.

Performed customer cluster analysis through profiling and correlation analyses based on various criteria to investigate the demographic and behavioural characteristics of customers to identify high-demand products.

Created interactive reports with insightful tabulations, plots, and charts using Python (matplotlib, seaborn) to provide business insights on planogram optimization, inventory management in-store level. EDUCATION & CERTIFICATION

Bachelor of Engineering, Mechanical Engineering May 2020 McMaster University, Hamilton, ON

SAS Certified Specialist: Advanced Programming Using SAS 9.4 Dec 2020

Contact this candidate