Yitong (Sherry) Xu

Experience

• 

  Rogers Communications

  Jan 2016 - Jun 2016

  BI Technical Analysis

  ▪ Worked closely with business teams to analyze and understand business requirements▪ Produced detailed functional design and integration specifications that satisfy user requirements and adhere to development standards▪ Prepared the Requirement Matrix and system documentation including creation or review of Solution Design Specification documents▪ Utilized Software Development Life Cycle artefacts to describe end-to-end work flows▪ Reviewed application software problem reports and optimized existing SAS scripts for reporting▪ Wrote SQL queries based on business/workflow logic and functional needs provided by business teams Show less

• 

  PointClickCare

  Jun 2016 - now

  ▪ Performing data analysis, data profiling, and data mapping on key source systems on a per project basis▪ Designing and implementing technical solution in SSIS and Hadoop platform• Built a Rule Service with over 200 rules with automated testing• Created a proof of concept data ingestion module using Kafka and Flume to transfer large amount of data and save to hdfs and S3▪ Developed SQL stored procedures to automate quality assurance testing• Worked with following tools/languages: SQL, JAVA, SSIS, Pig, HDFS, Sqoop, Oozie workflow scheduler Show less

  • Principal Software Engineer

    Sept 2023 - now

  • Senior Data Engineer

    Jun 2016 - now