JL

Juan López

IT Coordinator | Software Development & Data Automation

Ontario, Canada

I build data validation workflows and troubleshoot workplace technology at PenFinancial Credit Union. I use Python and SQL to prepare data for migration and produce reports for IT and Operations. My development projects include backend APIs and relational databases.

Download résumé LinkedIn Email

Experience

IT Coordinator

May 2026–Present

PenFinancial Credit Union · Welland, Ontario

  • 122,000+ address records processed through a Python validation workflow.

    Built a Python tool to automate address validation and give IT and Operations Excel reports for reviewing migration exceptions.

  • Used SQL extracts and Python reports to investigate missing, duplicate and inconsistent records before migration.
  • Troubleshoot Windows, Microsoft 365 and business applications for staff and document issues for follow-up.

Student Engagement Leader

Aug 2025–Jun 2026

Niagara College · Niagara Region, Ontario

  • Tracked student service requests, summarized recurring issues and coordinated follow-up with campus departments.

Front Desk Assistant

Mar 2023–Apr 2024

InterContinental Hotel · Cali, Colombia

  • Verified reservation and guest records and coordinated corrections with hotel departments.

Skills

Automation & data
Python (pandas, openpyxl), SQL, Excel, data validation, batch processing
Software development
C#, ASP.NET Core, React, REST APIs, Entity Framework Core, relational databases
IT support
Windows, Microsoft 365, issue triage, technical documentation

Selected Projects

View full portfolio

Address Migration Toolkit

Professional project · PenFinancial Credit Union

Independently built a batch tool that integrated an address validation API to check and classify more than 122,000 address records. It produced Excel exception reports and could resume from saved checkpoints.

Python · Google Address Validation API · Excel

Movement Unlimited

Client project · Niagara College

On a five-person team building a platform for a healthcare client, I developed backend endpoints, relational data models and validation rules to support a move from spreadsheets to structured records.

REST APIs · SQL

CoTas

Web application project

Built database-backed REST endpoints for creating and updating pet listings in a web application with a React frontend.

C# · ASP.NET Core · React · SQLite

Education

Computer Programming and Analysis — Advanced Diploma

Niagara College · Welland, Ontario

Expected completion December 2026

  • President’s Honour Roll (Fall 2025)
  • Honours Standing (Winter 2026)

Volunteer Technology Mentor

2024–Present

Cyber-Seniors

Help older adults troubleshoot devices and everyday apps through one-on-one guidance.

Contact

I’d be glad to talk about opportunities in IT, software development, or data automation.

juan@juanlopez.tech
LinkedIn Download résumé