
Luis Andrada
Test Analyst | Research Coordinator | Data Analyst | Quality Assurance | Computer Programming
About
Research data professional and programmer with 5 years of progressive experience at the University of Toronto Faculty of Dentistry, specializing in data validation, quality control, system administration, process automation, and quantitative analysis. Experienced in configuring and testing electronic data-capture systems, investigating discrepancies and logic errors, documenting corrective actions, and communicating technical findings to technical and non-technical stakeholders. Advanced Diploma in Computer Programming and Analysis with programming experience in Python, Java, C#, C++, JavaScript, TypeScript, SQL/MySQL, and web technologies. Hands-on workflow automation using Microsoft Power Automate, Microsoft PowerToys, Windows batch scripting, and AutoHotkey. Uses Git/GitHub and AI tools including ChatGPT, Claude, and Microsoft Copilot to improve development, analysis, documentation, and operational efficiency.
Passionate about working and developing in harmony with AI: treating AI as a collaborator, not a shortcut, with a human setting the direction and the standards, reviewing every change, and keeping the work tested and documented so people and AI can build on it together. Builds and maintains a personal website, andrada.one (six subdomains, automated end-to-end tests, a deploy pipeline that keeps GitHub and the live site identical, and scripts that prepare images, books and music for the web), in close collaboration with AI coding agents such as Claude Code. Applies large language models and prompt engineering to development, data analysis, and documentation, grounded in the University of Toronto’s Applied AI in Medicine workshop series (large language models in healthcare, complex prompt engineering, cybersecurity best practices).
Experience
CIBC
Test Analyst, IT Quality Engineering
Present
- Design, document, and execute test plans, test cases, and test scripts based on business and technical requirements.
- Perform functional, regression, integration, and user acceptance testing across releases; verify that systems behave as specified before deployment.
- Identify, log, and track defects through resolution; investigate root causes, retest fixes, and communicate status to developers, business analysts, and project teams.
- Validate data integrity and system outputs using SQL queries and prepared test data across test environments.
- Maintain traceability between requirements, test cases, and defects; prepare test summary reports and sign-off documentation.
- Collaborate with cross-functional teams in Agile delivery to improve test coverage, quality processes, and test automation.
University of Toronto, Faculty of Dentistry
Toronto, ON · Oct 2021 – Oct 2026
Research Coordinator
Jul 2025 – Oct 2026
- Designed and executed data validation and quality-control procedures across active research studies; identified discrepancies, out-of-range values, and logic errors before reporting or downstream use.
- Administered and maintained REDCap as the team's primary data-management platform; configured system logic and validation rules and tested new instruments and system updates before deployment.
- Provided first-line technical support for REDCap; investigated system and data issues, identified root causes, implemented corrective actions, and escalated when appropriate.
- Developed and maintained quality-control documentation, including procedures, issue records, corrective actions, and operational documentation.
- Used Python scripting, Microsoft Power Automate, Microsoft PowerToys, Windows batch files, and AutoHotkey to automate repetitive data-processing, reminders, scheduling, application-launch, file-management, and desktop workflow tasks.
- Coordinated participant booking and scheduling workflows, including automated email reminders and calendar notifications through Microsoft Power Automate; used PowerToys and desktop automation to reduce repetitive manual steps and improve day-to-day execution efficiency.
- Collected, analyzed, and reported quantitative research data using IBM SPSS, R, and STATA; prepared summaries, visualizations, and briefing materials for senior researchers and institutional committees.
- Coordinated with investigators, research staff, and external partner labs to resolve data-quality issues and communicated findings to technical and non-technical stakeholders.
- Ensured activities adhered to UofT ethics, FIPPA, and OCAP requirements and maintained secure, confidential handling of participant data.
Data Analyst
Oct 2023 – Jul 2025
- Collected, analyzed, and reported quantitative and qualitative research data using IBM SPSS, R, and STATA; prepared summaries and visualizations for publications and institutional reports.
- Designed and administered survey questionnaires and data-collection instruments across concurrent research projects; maintained data integrity and platform consistency throughout study lifecycles.
- Queried databases using SQL to generate reports on research outputs, participant data, and study metrics; identified discrepancies and implemented corrective procedures.
- Built and maintained relational databases to store, organize, and query research data; designed front-end research tools and study websites using JavaScript and React.
- Developed research outreach websites using HTML, CSS, JavaScript/TypeScript, React, and related web tooling; deployed sites through Netlify.
- Prepared ad hoc reports for senior investigators and institutional stakeholders and trained staff and students on data systems, entry procedures, and analytical workflows.
Research Assistant
Oct 2021 – Sep 2023
- Built and maintained institutional databases to organize and query research data across concurrent study projects.
- Designed results tables and data summaries for academic papers, committee presentations, and institutional records.
- Organized electronic and physical filing systems and trained graduate students on data systems and procedures.
Education
Certificate in Project Management
University of Toronto, School of Continuing Studies – Toronto, ON
2025 – 2026
Foundations of Project Management | Leading Projects in Organizations | Project Tools and Techniques
Advanced Diploma, Computer Programming and Analysis
George Brown College – Toronto, ON
2021 – 2024 · Dean's Honour List (GPA 3.5+)
Python, Java, C#, C++, JavaScript, TypeScript, React, SQL/MySQL; database design and management; full-stack web development; Git/GitHub
Certifications
Applied AI in Medicine Workshop Series
Temerty Faculty of Medicine, University of Toronto
2025
Large Language Models in Healthcare | Complex Prompt Engineering | Cybersecurity Best Practices
Data Analysis Workshops – R and Stata
OISE, Ontario Institute for Studies in Education, University of Toronto
2025
Fundamentals of OCAP
First Nations Information Governance Centre – Online, Canada
2024
Data sovereignty, First Nations collective rights, and Indigenous information governance principles
Skills
Core competencies
- Data Validation, Quality Control & Discrepancy Resolution
- System Configuration, Functional Checks & Pre-Deployment Testing
- Python Scripting, Data Processing & Workflow Automation
- SQL / MySQL: Querying, Validation & Data Extraction
- REDCap Administration, Logic, Validation & Testing
- Process Automation: Power Automate, PowerToys, Batch & AutoHotkey
- Programming: Python, Java, C#, C++, JavaScript & TypeScript
- Git / GitHub: Version Control & Development Workflows
- Technical Documentation, Issue Tracking & Corrective Actions
- Data Analysis & Reporting: R, SPSS, STATA, Excel & Power BI
- Project Coordination, Risk Identification & Stakeholder Communication
- Microsoft 365, Visual Studio Code & Windows Productivity Tooling
- Web Development: HTML, CSS, React, Tailwind CSS & Netlify Deployment
- AI Tools: ChatGPT, Claude & Microsoft Copilot
- AI Prompt Engineering, applied LLMs
Technical skills
- Programming
- PythonJavaC#C++JavaScriptTypeScriptHTMLCSS
- Web & Deployment
- ReactTailwind CSSNetlifyVisual Studio Code
- Databases
- SQLMySQLOracle SQL DeveloperMongoDBMicrosoft Access
- Quality & Data Systems
- REDCapdata validationquality controlsystem configurationpre-deployment testing
- Automation & Productivity
- Microsoft Power AutomateMicrosoft PowerToysWindows batch (.bat)AutoHotkey
- Version Control
- GitGitHub
- Data Analysis
- IBM SPSSRRStudioSTATAExcelPower BI
- AI Tools
- ChatGPTClaudeMicrosoft Copilotprompt engineeringapplied LLMs
- Microsoft 365
- OutlookWordExcelPowerPointTeamsSharePoint
- Other
- Adobe Creative SuiteaxiUm
Languages
- English
- C2 – CELPIP Level 12 – Fluent / Near-native proficiency
- Portuguese
- Native proficiency
- French
- CEFR B1 – Upper-intermediate reading and listening comprehension / Intermediate spoken communication – Actively studying
- Spanish
- Conversational understanding
References available on request. Contact
