Jimmy Yeung

Data Platform Solution Architect at 407 ETR

Canada

About

6+ years’ experience in Data Warehousing / Business Intelligence 3+ years’ experience in Automation Development • Administration, Upgrade, Development in MicroStrategy 10.x/9.x and Informatica 10.x/9.x • Informatica ETL Systems Admin, responsible for ETL infrastructure, installation, configuration and Upgrade • Extensive experience in designing, data profiling, testing automation and performance optimization for enterprise data warehouse • Strong knowledge of Data Warehousing concepts and Dimensional Modelling • Selenium WebDriver, Selenium Grid, TestNG, JUnit, Jenkins, Java, Python • Oracle 11/12, DB2/UDB, SQL Server, Sand, Postgres • Worked on both Agile and Waterfall methodology Specialties: 10 Years of IT experience Architecture / Modelling: Extensive experience defining vision and guiding principles, data migration strategies, data masking, data generation, automated data integrity checks, error-handling strategies, data governance, data analysis, requirement gathering, conducting gap analysis, proof of concepts, maintenance, writing specs (ETL, reporting, infrastructure, overall architecture, source to target matrix, etc.), and SLAs. MicroStrategy- 6 years (Dashboards, Cubes, Mobile, Administration, Installation, Upgrades, SME). Currently working on MicroStrategy 10.3. ETL (Informatica PowerCenter) - 6 years (Complex mappings, Administration, Tool Installation, Configuration, Upgrades, SME) Scripting • Unix Shell and python. • Developed Automated application/server maintenance, Logs Monitoring, Production Monitoring/ Alert Mechanisms for Error or Delayed ETLs, Automated historical load, Automated Problem Investigation etc. Automation • Developed Automation Framework using Selenium WebDriver, Selenium Grid, TestNG, JUnit, Jenkins, JAVA, etc. • Developed JMeter scripts to Performance test and miscellaneous tools • Experienced in using Continuous Integration tool like Jenkins • Experienced in testing web services using tools like SOAPUI

Experience

  • 407 ETR (15 yrs 10 mos)
    • Data Platform Solution Architect
      Jan 2023 - Present · 3 yrs 6 mos

    • Data Engineer Lead
      Jan 2020 - Jan 2023 · 3 yrs 1 mo

    • Senior Data Engineer
      Jan 2018 - Jan 2020 · 2 yrs 1 mo

  • IBM Canada (Markham, Ontario)
    • Software Engineer
      May 2008 - Aug 2010 · 2 yrs 4 mos

    • Software Developer
      Sep 2007 - May 2008 · 9 mos

    • Software Tester
      May 2006 - Sep 2007 · 1 yr 5 mos