Sam Xu

Data Architect, Data Engineer @ City of Calgary

Country

Canada

City

Calgary

Industry

Information Technology & Services

Skill

Scripting, Dynamic SQL, Denodo Platform, MongoDB, Python (Programming Language), AI Machine Learning, Data Engineering, Data Architects, Data Analysis, Oracle, Data Modeling, PL/SQL, Data Warehousing, ETL, Databases, Database Design, Microsoft SQL Server, Informatica, Data Integration, SQL

Experience

Data Architect, Data Engineer

City of Calgary

2015-6 - Present · 11 yrs 4 mos

Calgary, Alberta, Canada

Plan resources and work schedule. Report on project progress. Working with vender, setup data Extracting, Transformation, and Loading process to convert 20+ years municipal assessment data (900GB in size) from multiple sources into a new system. Designed new finance data model and convert municipal permit finance data. Design solution and data model for multiple sources asset data mart using Denodo. Lead the efforts on data conversion / data QA / data testing. Explore new methods and technologies to increase efficiency and performance. Oracle 19c, PL/SQL, Python, Informatica, Denodo. Perform ETL / data cleansing / QA / Test.

Data Warehouse Consultant

Cenovus Energy

2009-12 - 2015-5 · 5 yrs 6 mos

Managing client's financial data warehouse systems (700M+ records) and their interfaces. The technologies involved are: Sybase ASE, Sybase IQ (columnar), Oracle, SQL Server, UNIX, Linux, shell scripting, Informatica, BusinessObjects, Crystal report, PL/SQL, VB Sybase ASE and Sybase IQ upgrade on Unix boxes.

Data Warehouse Consultant

City of Calgary

2003-9 - 2009-12 · 6 yrs 4 mos

In municipal government, worked on City Roads data warehouse system analysis and development. Hansen application intergration and data conversion. Used technology: Informatica, BusinessObjects, Oracle 10g/9i, Linux, ESRI ArcGIS, PL/SQL, C#, Windows Server