Back to the résumé

Thomas Eapen · Technical skills

Technical skills and examples

An index of what I do with data and code. Each line links to work on this site that shows it.

At a glance

Where each skill shows up

Each dot opens the part of a role page that shows the skill.

SkillResearch and Policy AnalystEmployment and Social Development CanadaData Science ProgrammerAgriculture and Agri-Food CanadaData OfficerAgriculture and Agri-Food CanadaWorkforce analyst rolesTangerine Bank
Data engineering
Automating data workAutomating data work, Research and Policy Analyst: Automation: a direct link to our databaseAutomating data work, Research and Policy Analyst: EI MAR AutomationAutomating data work, Data Officer: Automatic generation of hierarchical outputsAutomating data work, Workforce analyst roles: Database Programming: SQL Server (T-SQL)
Replacing legacy systemsReplacing legacy systems, Research and Policy Analyst: EI Data Conversion (SAS to R)Replacing legacy systems, Data Science Programmer: The Migration Project
Proving the resultsProving the results, Research and Policy Analyst: EI Data Conversion (SAS to R)Proving the results, Data Science Programmer: Ensuring the accuracy of the migrationProving the results, Workforce analyst roles: Testing
Speed and large dataSpeed and large data, Research and Policy Analyst: Azure InfrastructureSpeed and large data, Data Science Programmer: Increasing the performance of the connection between R and the Oracle databaseSpeed and large data, Data Science Programmer: Increasing the performance of the R codeSpeed and large data, Workforce analyst roles: Data Analytics
Databases and applicationsDatabases and applications, Research and Policy Analyst: Automation: a direct link to our databaseDatabases and applications, Data Officer: WTO Database ApplicationDatabases and applications, Workforce analyst roles: Database Programming: SQL Server (T-SQL)
Modelling and forecastingModelling and forecasting, Data Science Programmer: Solving non-trivial problemsModelling and forecasting, Data Officer: Python Programming ShowcaseModelling and forecasting, Workforce analyst roles: Predictive Tools
Platforms and ways of working
Cloud platformCloud platform, Research and Policy Analyst: Azure Infrastructure
Working with AI agentsWorking with AI agents, Research and Policy Analyst: EI Data Conversion (SAS to R)Working with AI agents, Research and Policy Analyst: EI MAR AutomationWorking with AI agents, Research and Policy Analyst: AI Hackathon: drafting decision records
Version controlVersion control, Research and Policy Analyst: Git WorkflowVersion control, Data Science Programmer: Git workflow presentation
Communicating the work
Maps, charts and publication designMaps, charts and publication design, Data Officer: Data manipulation and geospatial mappingMaps, charts and publication design, Data Officer: InfographicsMaps, charts and publication design, Data Officer: Publication DesignMaps, charts and publication design, Workforce analyst roles: Reporting and visualisation
Papers, talks and documentationPapers, talks and documentation, Research and Policy Analyst: Papers and presentationsPapers, talks and documentation, Data Science Programmer: Talks & PresentationsPapers, talks and documentation, Data Officer: TalksPapers, talks and documentation, Data Officer: Papers and briefingsPapers, talks and documentation, Workforce analyst roles: Process Documentation

Data engineering

Automating data work

Manual steps replaced by programs that run from start to finish.

ToolsR · Python · SQL

Replacing legacy systems

SAS programs rebuilt in free, open-source tools.

ToolsR · DuckDB · Python

Proving the results

New code checked against the old system before it is trusted.

ToolsR · DuckDB · ggplot2

Speed and large data

Faster database connections, work spread across processor cores, and data too large for memory.

ToolsArrow · DuckDB · ROracle · furrr

Databases and applications

Code that reads straight from the database, and a web application to manage one.

ToolsSQL · Oracle · Django · SQL Server

Modelling and forecasting

Optimization to fill gaps in data, and forecasting methods.

ToolsPython · Pyomo · GLPK

Platforms and ways of working

Cloud platform

Analysis tools and code repositories set up on the department’s cloud platform.

ToolsAzure ML · Azure DevOps

Working with AI agents

AI agents write and document code under my direction; I review it and run it myself when real data is involved.

ToolsAI agents

Version control

Git for the team’s code, with a shared repository colleagues can work from.

ToolsGit

Communicating the work

Maps, charts and publication design

Maps, infographics, dashboards and a publication layout.

ToolsR · Python · Power BI · Adobe InDesign

Papers, talks and documentation

Work explained in papers, talks and written documentation, so others can run it and change it.