Luc Laffin Email & Phone Number

Vancouver, British Columbia, Canada

As a software developer specializing in full-stack solutions for the mineral exploration industry, I engineer essential applications tailored to meet the complex needs of this sector.I designed and currently maintain a web dashboard using Angular and Django, serving as the primary platform for managing and performing QAQC on collected data.Additionally, I contribute to the maintenance and enhancement of an Android app using Java, Kotlin, GreenDao, and Retrofit, ensuring robust data integrity and seamless cloud syncing, even in remote areas.I also oversee the development of a desktop application with Kotlin and Java using TornadoFX, which supports core shack logging crucial for precise geological assessments.Beyond application development, my role includes extensive backend management and infrastructure oversight. I administer multiple highly structured PostgreSQL databases equipped with advanced views and functions, enabling sophisticated spatial queries via PostGIS that integrate seamlessly with third-party geology software such as Leapfrog, QGIS, and ArcPro.I manage our AWS cloud infrastructure, utilizing Terraform for efficient deployment and scaling. Server maintenance is a significant part of my duties, involving the configuration of NGINX, setup of systemd services, and management of cron jobs across multiple EC2 instances.Additionally, I extensively use Python scripting to automate data processes and integrate third-party data into our databases, enhancing our operational efficiency.This comprehensive approach enables me to deliver specialized and effective technological solutions that fulfill the demanding requirements of the mineral exploration industry.

St. Catherines, Ontario, Canada

As a software developer intern at the Ministry of Transportation of Ontario, I engaged in a range of full-stack development and cloud service management tasks tailored to enhance governmental digital infrastructure.I maintained an internal web dashboard, managing full-stack development tasks including refactoring backend .NET Core RestAPIs, updating frontend Angular components, and managing SQL database integrations.In addition, I designed and developed .NET WPF desktop and console applications in C# to automate the migration of SharePoint list data between servers. This included implementing a logging system to alert developers of any data inconsistencies.My role also encompassed the management of Azure Cloud Services, working with both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) models. This included administering Azure Virtual Machines, Azure Storage, SQL databases, Azure Active Directory, and Application Insights.I implemented automated daily reporting of Azure App Registration accounts using PowerShell scripts in Runbook, enhancing system reliability and administrative efficiency.Throughout this role, I utilized Azure Boards and Wikis to collaborate effectively with the development team, ensuring robust project tracking and documentation.This experience provided me with comprehensive exposure to government IT operations, focusing on both development and system administration within the Azure ecosystem.

Toronto, Ontario, Canada

During my co-op tenure at RBC, I focused on automating critical data management processes and enhancing security protocols across various banking systems.I developed Python and IBM i Command Language scripts to automate the transfer of data and applications between servers using SSH protocols. This automation extended to journal logging of all data transfers and error messages, facilitating comprehensive audit reporting.I implemented SQL scripts to automate the generation of reports on user and security data from DB2 and SQL databases within IBM i and HP NonStop systems. These reports, generated on a daily or weekly basis, were crucial for alerting the team to any necessary actions, significantly improving operational response times.Additionally, I wrote a security audit program in TACL for Tandem Series G servers. This program generated detailed reports of all user permissions for every volume, subvolume, and file, which were utilized by security teams in audit reports. This automation saved hours of manual labor during each auditing period and increased the efficiency of the audit process.This role allowed me to enhance my technical skills in a financial environment, contributing directly to RBC’s data security and operational efficiency through advanced scripting and automation.

Mississauga, Ontario

I played a pivotal role in developing software solutions and managing cloud infrastructure to enhance real-time data accessibility and analysis.I developed a user-friendly web dashboard utilizing the Django Framework to display real-time data from IoT devices. This dashboard served as a critical tool for end-users to monitor air quality effectively.Leveraging open-source Python tools such as Numpy, Pandas, and TensorFlow, I performed data mining, data cleaning, and data analysis to extract valuable insights from the collected data, enhancing the functionality of our IoT solutions.I was also responsible for writing comprehensive technical documentation to aid clients in understanding and utilizing our software solutions effectively, ensuring a smooth user experience and maximizing the utility of our products.Additionally, I deployed Azure cloud computing infrastructure with Apache Spark to automate data transfer from IoT devices. This setup enabled real-time data analysis and modeling for our web-based application, significantly improving the speed and efficiency of data processing.This internship allowed me to contribute significantly to the development of innovative air quality monitoring solutions, combining my skills in software development, data analysis, and cloud infrastructure management.

Oakville, Ontario

In my role as an Environmental Coordinator and Data Analyst at Sheridan College, I was instrumental in advancing the college's environmental initiatives and analyzing their impact across all three campuses.I collected and analyzed solid waste data, generating comprehensive reports to assess the effectiveness of the college's Zero Waste policies. This analysis helped identify areas for improvement and supported the ongoing development of sustainable practices.To educate students on proper waste disposal methods, I created an interactive display on the department's website using HTML/CSS on WordPress. This online resource played a crucial role in enhancing student and staff engagement with the college’s waste diversion strategies.Additionally, I conducted interviews with students and staff to gather feedback on the effectiveness of current waste management practices. This feedback was integral to refining our approach and implementing more effective waste diversion strategies.As a leader, I guided a team of 20 student volunteers, coordinating efforts to promote and implement environmental initiatives on campus. This leadership role not only amplified the reach of our programs but also fostered a culture of sustainability among the student body.This internship allowed me to merge my data analysis skills with environmental stewardship, contributing significantly to Sheridan College’s sustainability efforts and providing valuable insights for policy refinement.

Bachelor Of Science - Bs, Geological And Earth Sciences/Geosciences

Advanced Diploma, Computer Software Engineering