Sr. Data and Analytics Specialist @ Bank of Canada
View this Portfolio Project on GitHub billthan/bthan-portfolio
Bill is an accomplished team leader with experience building end-to-end on-prem/cloud data solutions.
His core focuses are full-stack and data engineering.
4x Microsoft Certified
A Docker based solution leveraging Plaid data to automate and store personal financial data in PostgreSQL for analysis in Jupyter Notebooks.
Export all Oracle DDLs for database tracking in a DevOps development cycles. Allow for repo-based code, work, and deployment tracking using tools like GitHub and Azure DevOps
| Category | Technology |
|---|---|
| Programming & Scripting | Python (Django, flask), Java, .js (React), C# (.NET Maui, Xamarin), PL/SQL, PL/pgSQL, bash/shell (Solaris, Oracle Linux, Redhat Linux), Windows Powershell, DevOps YAML, Docker YAML |
| Databases | Oracle 11g/12c/19c, Azure SQL Server, Azure CosmosDB, PostgreSQL, KQL, MS Dataverse, MS Access |
| Data Engineering | Azure Data Factory, Informatica PowerCenter 10.2 and IDMC, Mulesoft, Apache Airflow |
| Data Science | MS Fabric, Azure AI Search, pySpark, OpenAI, Databricks, MATLAB |
| Data Visualization | PowerBI, Oracle APEX, Tableau, matplotlib, leaflet |
| Artificial Intelligence | Ollama, Azure OpenAI, AI Foundry |
| Data Governance | Unity Catalog (Databricks), Purview |