Gatineau, Québec 🇨🇦

Data Analyst &
Full-Stack Developer

8+ years delivering data and analytics solutions in the federal public service. I’m an analyst who designs and builds end-to-end data pipelines, dashboards, and ML/NLP systems that transform complex scientific and operational data into decision-ready intelligence.

View Live Apps Get in Touch View CV
About

Background

My work ranges from Oracle APEX applications and database architecture to Python-based data engineering, ML/NLP pipelines, and cloud-deployed analytics dashboards. I was centrally involved in an end-to-end national-scale bibliometric analysis supporting Canada’s Antarctic Treaty reporting. I actively experiment with LLM-assisted development to accelerate the design and implementation of complex software systems, using modern AI tooling to rapidly prototype and scale production-grade applications.

Carleton University Senate Medal recipient
Microsoft Azure certified
Secret clearance
Indeterminate status

Quick Profile

RoleAnalyst & Software Developer (PC-02)
DepartmentEnvironment & Climate Change Canada
Experience8+ years federal public service
FocusScientific Data Systems, Analytics & ML
Portfolio

Live Applications

Live dashboards and prototypes deployed on cloud infrastructure

Active Development: These applications are functional production prototypes and are being continuously improved. If you spot a bug or have feedback, email me.

Personal Development Environment: All applications shown here are personal projects built on my own hardware and time, using publicly available data, and hosted on privately managed cloud infrastructure. These systems are not connected to, or deployed within, Government of Canada networks or environments.

🌍
Live on Oracle Cloud

Global Events Monitor

Real-time geopolitical intelligence system combining large-scale RSS ingestion, NLP-based event classification and location extraction, geospatial analytics, conflict severity modeling, and intelligence reporting via interactive dashboards and automated briefing outputs.

Launch Code
🚴
Live on Oracle Cloud

Strava Analytics Dashboard

Personal endurance training analytics with time-series metrics, performance summaries, and activity visualizations.

Launch
🌊
Live on Oracle Cloud

DAS Monitor

Disposal at Sea (DAS) domain-wide website administration and governance toolkit that detects broken links, flags unauthorized content changes, analyzes readability and linguistic complexity, and performs full-domain regex search to eliminate manual content auditing across the DAS subdomain.

Launch
🏛️
Live on Oracle Cloud

Federal Workforce Explorer

Interactive visualization of 206K+ federal employees with org tree navigation, geographic mapping, and hierarchy analysis.

Launch
Featured Work

Major Projects

From analysis to analytics to applications

🇦🇶 Government of Canada • ATCM Submission

Canadian Antarctic Research Bibliometric Analysis

National-scale research analytics pipeline supporting Canada's Antarctic Treaty submission

1,500+records analyzed
1997–presentlongitudinal coverage
Modular ETLfile-to-file pipeline
QA + Treaty Outputvalidated figures & reporting
Retrieve Web of Science
Consolidate Multi-file exports
Validate Inclusion + review
Classify Research themes
Attribute Funding + fields
Publish Figures + report

Led the end-to-end design and implementation of a national bibliometric analytics pipeline to quantify Canada’s contribution to Antarctic research for international treaty reporting. The work included multi-source data ingestion and normalization, ML-based research theme classification, manual validation of ~1,000 publication records, and generation of publication-quality analytical figures for Canada’s ATCM submission.

PythonPandasScikit-learnTensorFlowNLPR / ggplot2Web of Science API
  • Built an end-to-end ETL and analytics pipeline covering 25+ years of Antarctic research publication data
  • Developed ML models to classify publications across six core Antarctic research themes
  • Manually validated and curated 1,000+ scientific publications to ensure geographic and scientific relevance
  • Engineered derived analytical fields including institutional affiliations, funding attribution, and international collaboration metrics
  • Produced publication-quality analytical figures and reporting outputs used in Canada’s ATCM treaty submission
  • Quantified Canada’s Antarctic research contributions across nearly three decades (1997–present)
🗄️

ECCC Monitoring Database

Replaced a planned external contractor build by delivering an enterprise Oracle APEX monitoring system end-to-end—database architecture, application layer, integrity controls, and production rollout.

Oracle APEXPL/SQLRelational DesignData Integrity
📊

PSC Staffing Dashboard

Dynamic web dashboard for visual exploration of public service staffing data with interactive filters, fuzzy matching, and geocoding integration.

DashPlotlyGeoPyPandas
Career

Work Experience

8+ years delivering production data systems, analytics platforms, and automation tooling across multiple federal departments

April 2020 – Present

Planning Analyst (PC-02, Indeterminate)

Environment and Climate Change Canada
  • Enterprise system delivery: Designed, built, and deployed an Oracle APEX monitoring platform end-to-end, replacing a planned external contractor implementation.
  • Database engineering: Requirements analysis, relational schema design, constraints, triggers, cascade rules, and specialized sequences.
  • Application build: Full APEX UI (forms, reports, validation logic, workflows), testing, and production rollout.
  • Delivery leadership: Led UAT, defect triage, post-release stabilization, and produced end-user and technical documentation.
  • National analytics: Led a Canadian Antarctic research bibliometric pipeline for ATCM reporting (multi-source ingestion, normalization, ML-assisted theme classification, and publication-quality figures).
  • Web operations: Maintain and enhance the Marine Program Disposal at Sea web presence using Adobe Experience Manager (AEM).
  • Automation tooling: Built Python utilities for content analytics (linguistic complexity), shared-drive automation, and data inventory / duplicate detection workflows.
Oracle APEX PL/SQL Python Pandas ML/NLP Adobe AEM
December 2018 – February 2020

Analyst, Data Services (EC-02, Indeterminate)

Public Service Commission
  • Dashboard engineering: Co-developed a production web dashboard for exploration of public service staffing data with interactive filters (classification, province, department).
  • Data integration: Implemented fuzzy matching pipelines and geocoding to reconcile locations across disparate datasets.
  • Spatial optimization: Optimized match quality by minimizing Haversine distance using GeoPy and Pandas.
Python Dash Plotly Flask Pandas GeoPy
March 2018 – December 2018

Project Services (AS-01, Term)

ESDC – Labour Program
  • System administration: Administered the Industrial Relations Information System (IRIS) for the Collective Bargaining & Settlements team.
  • Workflow automation: Built a programmatic recovery solution for accidental IRIS data loss, saving officers substantial manual re-entry time.
  • Analytics operations: Maintained and extended a SAS code library supporting recurring monthly data products.
  • Client analytics: Delivered solutions for complex data requests using SAS and Python.
SAS Python Data Ops
September 2017 – March 2018

Junior Researcher (EC-02, Casual)

ESDC – Labour Program
  • Large-scale acquisition: Built a scraper to download, merge, and analyze ~100,000 CSV files from Government of Ontario sources.
  • Automation: Implemented robust ingestion tooling using Selenium and Python data processing libraries.
  • Visualization tooling: Developed a Python tool to generate map-based infographics for Canadian data products.
  • Decision support: Contributed analysis for briefing products addressing inconsistencies across Labour Program databases.
  • Data expertise: Became a go-to resource on the LA2000 database and supported management with statistical and visual analyses.
Python Selenium Pywinauto Pandas Matplotlib
May 2017 – September 2017

Database & Statistical Analyst (FSWEP)

ESDC – Labour Program
  • Data extraction: Extracted and anonymized LA2000 data (~450 CSV tables, ~1 GB) for academic research use while preserving structure and integrity.
  • Documentation: Produced technical documentation describing dataset structure and identified potential data quality issues.
Data Extraction Anonymization Documentation
Education

Academic Journey

From neurons to neural networks

B.Sc. Computer Science
Carleton University
2015 – Present
Standing: 4th-year B.Sc. Computer Science.
Coursework: Discrete Structures, Probability & Statistics, Linear Algebra, Calculus, Web Design, Databases, Operating Systems, Programming Paradigms, Abstract Data Types, Software Engineering, Systems Development Life Cycle, Algorithms & Algorithmic Analysis.
Machine Learning Engineer Nanodegree
Udacity
2015 – 2016
Coursework: Model Evaluation & Validation, Training/Testing Models, Evaluation Metrics, Supervised & Unsupervised Learning, Clustering, Deep Learning, Neural Networks, Reinforcement Learning.
M.Sc. Biotechnology
McGill University
2014 – 2015
Coursework: Practical laboratory intensives (Gene Cloning, qPCR, RT-PCR, Pyrosequencing, Chromatography), Artificial Cells, Bioethics, Micro & Nano-Biotechnology, Bioinformatics.
Thesis: Master’s thesis research (see Research & Publications).
B.Sc. Combined Honours Neuroscience
Carleton University
2010 – 2013
Coursework: Psychology, Cognitive Science, Cell Biochemistry, Human Physiology, Genetics, Research Methods, Advanced Design & Analysis, Microbiology, Membrane Biochemistry, Immunology, Neuroscience, Sensory Processes, Pharmacology.
Senate Medal for Outstanding Academic Achievement
Credentials

Certifications

Click to view certificates

AZ-900
Azure Fundamentals
View Certificate
AI-900
Azure AI Fundamentals
View Certificate
DP-900
Azure Data Fundamentals
View Certificate
PCEP
Python Entry-Level Programmer
View Certificate
Machine Learning Nanodegree
Udacity
View Certificate
Research

Scientific Contributions

Peer-reviewed research combining wet lab work with computational analysis

McGill University Research

Centre for Research in Neuroscience (RI-MUHC)

Conducted experiments to mathematically quantify structural changes in brain microglia in response to bacterial infection, combining traditional wet lab techniques with computational analysis.

Techniques Used
LPS injection in mice models Brain and spine extraction Cryostat tissue slicing Immunohistochemical staining Confocal microscopy imaging 3D reconstruction and cell tracing
Computational Analysis

Used Python (Pandas, Matplotlib, NumPy, SciPy) to extract data, perform mathematical analyses, and graphically depict findings. Identified quantitative metrics to describe observed morphological adaptations.

📄 Peer-Reviewed Publication

Anderson, W., Greenhalgh, A., Takwale, A., David, S., Vadigepalli, R. (2017)

Novel influences of IL-10 on CNS inflammation revealed by integrated analyses of cytokine networks and microglial morphology

Frontiers in Cellular Neuroscience — Volume 11, Article 233

Open PDF

Carleton University Research

John Stead's Human Genetics Laboratory

Undergraduate thesis research investigating the relationship between single nucleotide polymorphisms (SNPs) in the oxytocin receptor gene (OXTR) and gambling addiction.

Methods
DNA extraction and purification from saliva samples Quantitative PCR (qPCR) Statistical correlation analysis Behavioral assessment batteries
Result

Correlated OXTR expression levels with behavioural test outcomes measuring impulsivity and problem gambling. Successfully defended thesis before faculty panel.

Open Poster
Get In Touch

Let's Connect

I’m open to full-time roles, short-term contracts, collaborative research, consulting, volunteer projects, and other meaningful opportunities. I’m flexible on domain and role type, and I’m interested in contributing wherever I can create real value.

Email

aditya.p.takwale@gmail.com

LinkedIn

Connect professionally

GitHub

View my code

Live Project

Global Events Monitor