Ihsan Aydin

Junior Data Scientist @Canadian Intellectual Property Office Office De La Propriété Intellectuelle Du Canada

Ottawa, ON, CA

ImpactShipped data pipelines and self-serve analytics that turned multi-day refreshes into same-day insights and moved teams from weekly batches to daily decision-making.HighlightsBuilt a Python-driven trademark ETL that auto-generates schemas and loads 19 tables (tens of millions of rows) in under 5 hours—cutting refresh time from days to same-day analytics.Re-engineered the patent-applicant sector-tagging pipeline with FlashText + pandas (replacing nested regex): processed 30M+ party names in 67% from ~6 hours) while lifting precision to 98%, enabling daily analytics.Delivered two end-to-end Power BI solutions with cross-page filters and one-click CSV exports—boosted self-serve adoption among CIPO economists by 40% and eliminated ~10 hrs/week of ad-hoc pulls.Implemented role-based access control across PostgreSQL: defined 3 granular roles and issued 40+ unique credentials via pgAdmin, retiring shared logins and enabling audit-ready tracking.Stack: Python (pandas, FlashText), Power BI, SQL/PostgreSQL, pgAdmin, ETL/RBAC, Data Modeling, CI/CD

Carleton University

Bachelor of Engineering - BE, Software Engineering, Co-op