John Alvaro
Edmonton,Alberta
Summary
Fourth-year Software Engineering student with experience in automation, data processing, and applied AI. Skilled in Python, SQL, and API integration, with proven adaptability to new tools and platforms (FileMaker Pro, Octoparse, Figma). Collaborative and open communicator across teams and languages, with hands-on experience in supplier coordination, research projects, and cross-functional eCommerce initiatives. Seeking to expand expertise in machine learning systems, API development, and automation.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data Analyst Intern
Bartle & Gibson
Edmonton, Alberta
01.2025 - 08.2025
- Coordinated with 200+ suppliers and third-party platforms (AD, Unilog) to gather product data, standardize files in Excel, and integrate ~11,000 enriched records into FileMaker PIM.
- Built Python scripts (Pandas, OpenPyXL, Requests) to automate image downloads, renaming, and SKU matching, reducing manual processing time.
- Designed 40+ Octoparse workflows and Selenium scrapers to extract structured data from 20+ supplier websites, expanding product coverage.
- Validated ~10,000 products against spec sheets and price files; collaborated with marketing/eCommerce teams to improve accuracy and highlight key product features.
- Conducted QA testing across three eCommerce websites, documenting bugs and ensuring smooth checkout, quoting, and search functionality before release.
- Prototyped AI pipelines with OpenAI API to auto-generate product descriptions, extract filterable attributes, and correct data quality issues, proving value of AI-driven enrichment.
Research Assistant - Civil Engineering Department
University of Alberta
Edmonton, Alberta
09.2024 - 12.2024
- Experimented with Python tools (NLTK, scikit-learn, SQLAlchemy) to generate and preprocess large text datasets, benchmarking ingestion speeds (1 MB–1 GB) and exploring storage/computation tradeoffs.
- Prototyped a semantic search approach by connecting OpenAI’s API to a structured text corpus, testing the potential of LLMs for exploratory domain-specific retrieval.
- Helped design simple prototypes, including a Figma-based user interface and system diagrams, while contributing progress updates and planning discussions in weekly research meetings.
Education
Bachelor of Science - Computer Engineering - Software Co-op Option
University of Alberta
Edmonton06-2027
Skills
- Python (pandas, openpyxl, requests, SQLAlchemy, Selenium)
- SQL, Excel
- OpenAI API, NLP (NLTK, scikit-learn)
- Web scraping (Octoparse, Selenium)
- FileMaker Pro, ERP systems
- QA testing
- Supplier/vendor coordination
- Cross-functional teamwork
- Documentation & reporting
- Research collaboration
Affiliations
- Deans Research Award Certificate [2024]
- Canadian Air Cadet - 3 years - Rank Flight Sergeant [2016-2019]
- Hip Hop Dancer / Club Member
Certification
Claris FileMaker Specialist Certificate | Class 5 Driver License + IDP
Timeline
Data Analyst Intern
Bartle & Gibson
01.2025 - 08.2025
Research Assistant - Civil Engineering Department
University of Alberta
09.2024 - 12.2024
Bachelor of Science - Computer Engineering - Software Co-op Option
University of Alberta