Chun Peng J.

Hello, my name is Joseph Jiao and I am based in Ottawa, Canada. With over 20 years of experience, I have developed a diverse skillset that includes expertise in Python, C#, and SQL. Over the past six years, I have focused on building my experience in Data Engineering and have worked extensively with various Azure tools such as Azure Data Lake Storage, Azure Synapse, Azure Data Factory, Azure Databricks, pyspark, and Delta Lakehouse. Starting in January 2023, I have expanded my knowledge to include OpenAI API and have worked on several internal projects related to chatGPT+Dynamics 365. Languages: Python, C# SQL Scripts: T-SQL, Spark SQL, Databricks SQL, Hive SQL Could Platform: Azure Synapse, Azure Data Factory, Azure Databricks, ADLS, Spark ETL Tool: pyspark, SSIS Modeling Tool: ERWIN, MS Visio, MySQL Workbench, [login to view URL] Reporting Tool: Power BI, SSRS Version Control: Git, Azure DevOps, GitHub Database: Hive, MSSQL, Azure SQL, Azure Synapse Analytics Developing Tool: VS Code, GitHub code space, VS Studio Data Governance: Collibra Expertise: Microsoft Dynamics 365 (Sales, Finance, Customer Service etc.) Orchestration: Azure Synapse pipeline, Azure Data Factory, Azure Databricks Workflow, Apache Oozie, Apache AirFlow Industries: Public Service, Mortgage, Investment, Finance & Treasury, Retail, Insurance