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 cloud-based platforms that turn complex data into clear inputs for decision-making.
He is focused on scalable data engineering, risk-aware design, and analytics that support real-world outcomes.
5x 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 |