Ted W. Email & Phone Number

• Upon Architecture design, integration plan, documentation, Migration strategy, from Mainframe and On-Premises to Azure, and from Azure feedback to Salesforce CRM, Datacenters. Conceptual/ Logical/ Physical, Dimensional modeling, • ETL/ELT, pipeline, Data Warehouse, data fix & validation, testing (SAT, UAT), auditing, Code reviews, data management and governance, Source to Target mapping (STM) and Data Quality Management, performance tuning up, troubleshooting. • Expert level experience using ADF, Databricks, Synapse, Azure SQL Database, ADLS, Hadoop, Pyspark, Data Flow mapping, transforming activities, Azure API Management, Logic Apps, Azure Functions, Azure Log Analytics and Threat hunting Sentinel, Kusto Query Language (KQL) SIEM and SOAR, Informatica, SSIS Implemented Copy activity, Data flow transformation activities, Create Azure IR, Self-hosted IR for on-promises, Azure-SSIS IR, Linked service dataset, implemented Cosmos DB solutions using SQL API, CI/CD DevOps, Python etc.

Toronto, Ontario, Canada

Design and develop enterprise applications. Manage technical team. Guidewire Insurance system (PolicyCenter7.0, BillingCenter7.0, ClaimCenter7.0)implementation and integration. Data warehousing. Data conversion and migration

Performed implementation and enhancement of insurance applications, ETL/data warehouse/BI applications for companies of insurance industry (Property & casualty, Work's compensation, re-insurance and so on).