Data Analyst

Continued

Raymond Huang

Phone 647-***-**** Email *********@*****.*** https://www.kaggle.com/shuan3/kernels Summary

• 3 years’ experience in SQL and 1 year’s experience in python

• Experience in government regulation and data dictionary

• Strong knowledge of data presentation, analytical bench techniques and Window-based software including Microsoft Word, Excel, Power Point, SSIS, python, MangoDB, SQL DBX, my SQL, neo4j, hadoop hive, spark(spark sql, scala) and google big query analytics

• Ability to work under pressure, travel, multi-tasks and meet tight timeline of project

• Excellent interpersonal and communication skills Work Experience

Database Analyst 11/2019 – To present

Partners in Credit, Thornhill, ON

• Extracted, transformed and loaded heterogeneous data into Debt Collection Software via SSIS foreach loop container, execute SQL task, conditional splitting, file system task, ftp and xml task; Transformed data using Macro to record steps

• Validated data using excel function countifs, vlookup, iferror, offset, match and data cleaning

• Built parameterised queries through excel Microsoft query, using power BI for reporting and created interactive dashboards

• Assisted setting up dial campaigns and trouble shooting

• Worked with various applications such as text pad, SQL DBX, my SQL, FTP, remote server, Hadoop hive and different banking systems to facilitate data flow and integration

• Developed and implemented new process for importing data and validated its performance

• Designed SQL stored procedure and trigger for insert and update and views for reporting

• Used python to develop data cleaning and formatting solution and connecting to sql server for further data analysis

• Uesed Hadoop hive, spark (scala, spark sql) to identify outliers, null and duplicate value and data analysis Data Analyst 06/2015 – 10/2019

Canada Fibers Ltd, North York, ON

• Reported inventory, product quality and chemical consumption daily to management using excel pivot table and Macro

• Created charts and plotted data to present trend or abnormalities in production

• Used data analytics to optimize production efficiency and quality

• Identified potential solutions to reduce inventory based on leads and provided recommendations to management for enhancement in production efficiency

• Used python pandas heatmap and pairplot to explore data correlation and linear model training for predicting future price

• Used linear regression, random forest classifier and k fold for modeling and modeling interpretation

• Developed automated workflow for data processing and cleaning using ssis

• Designed SQL stored procedure and trigger for data cleaning Education

Master of Science 09/2012 – 08/2014

Western University, London, ON

Certificate in Big Data Analytics 09/2019 – 09/2020 York University, North York, ON

Contact this candidate