Eric Logo

This is my Official Resume Webpage.

Current Occupation: Application Developer

Information Services & Technology — Enterprise Applications

University of Alberta

PDF iconview my resume in PDF
Portrait

Profile

Application & Database Analyst with 10+ years of experience designing, developing, and supporting enterprise web applications and data-driven systems in higher-education and corporate environments. Strong background in C#, Python, Java, SQL (SQL Server & MySQL) and ETL-style data integration between enterprise systems. Skilled at optimizing queries and stored procedures, building reporting datasets, and troubleshooting complex production issues. Known as a collaborative, detail-oriented team member who can work independently, communicate clearly with stakeholders, and improve systems for performance, scalability, and data quality.

Skill Set

Languages & Databases

  • C#, Python, Java, PHP, JavaScript, HTML, CSS; SQL (T-SQL, MySQL, MS SQL Server, basic Oracle/PostgreSQL)
  • Application & Data

  • Application design & development (web, services, internal tools)
  • Database design, normalization, indexing & performance tuning
  • Stored procedures, views, functions, triggers
  • ETL/data integration (scripts, REST APIs, scheduled jobs)
  • Reporting & BI datasets, Power BI basics
  • Frameworks & Tools

  • .NET / ASP.NET, Bootstrap, jQuery, REST APIs
  • Drupal 7/8, WordPress, CiviCRM
  • Git, SVN, Jira, Bugzilla, Freshservice
  • Platforms & Infrastructure

  • Windows & Windows Server, Linux (CentOS, Ubuntu, Red Hat)
  • MS SQL Server, MySQL
  • Active Directory, IIS/Apache, SSL, cPanel, Hyper-V, Docker (basic)
  • Other

  • Microsoft 365, SharePoint, Power BI
  • Photoshop, Illustrator, InDesign, AutoCAD, SketchUp
  • Professional Experience

    University of Alberta

    2021 - Present
    Application Developer (IST - Enterprise Applications)
  • Design, develop, and maintain internal web applications for the Faculty of Engineering (HR/Payroll requests, TA assignment, accreditation/SEAS, graduate processes, etc.).
  • Use C#, PHP, JavaScript, SQL (MySQL & SQL Server) to implement application features, reports, and integrations with enterprise systems (e.g. PeopleSoft, BOT/automation tools, UODA feeds).
  • Build and optimize SQL queries, views, and stored procedures to support reporting, dashboards, and high-volume transactional workflows.
  • Develop and maintain ETL/import scripts to synchronize data across systems, improving data quality and reducing manual work.
  • Work closely with analysts and business stakeholders to gather requirements and translate them into scalable, maintainable technical solutions.
  • Troubleshoot application and database issues in production; analyze logs and query plans, implement fixes, and improve performance and reliability.
  • Document application architecture, data models, and operational procedures to support long-term maintenance and onboarding of new team members.

  • Computer Programmer (Faculty of Engineering)
  • Designed and developed C# / .NET applications backed by MS SQL Server to support engineering research projects (data collection, analysis, and reporting).
  • Created and maintained database schemas, tables, views, and stored procedures to model experimental data and research workflows.
  • Implemented data import/export and basic ETL processes to integrate lab instruments, spreadsheets, and other data sources into centralized databases.
  • Optimized SQL queries and indexing strategies to improve performance for large datasets and complex calculations.
  • Collaborated with faculty members and graduate students to understand research requirements and translate them into reliable, user-friendly tools.
  • Assisted with server and workstation setup for research systems, including backups, updates, and troubleshooting of application/database issues.

  • MacEwan University

    Systems Analyst

    2017 - 2020
  • Led and supported large public and internal web projects for a post-secondary institution, working closely with business analysts, communications, and IT.
  • Re-architected public/internal sites to responsive design using JS/jQuery, Handlebars.js, Bootstrap, HTML5, CSS, and Cascade CMS.
  • Built custom applications and data migration/ETL solutions to move content and metadata into Oracle WebCenter and other repositories using PHP, MySQL, REST APIs, and JSON.
  • Co-developed a web-based faculty annual report system using PHP, Symfony, Twig, XML, REST APIs, and JS/Ajax, backed by relational databases designed for reporting.
  • Implemented automation and reporting for customized e-forms using SharePoint, MS Flow, REST APIs, and Power BI, improving reporting speed and data accessibility.
  • Optimized database queries and application logic to improve page load times and system reliability.
  • Ensured data accuracy and integrity during migrations and system integrations, and documented solutions for support teams.

  • Lung Association of Saskatchewan

    Web Developer

    2013 - 2017
  • Designed and maintained 15+ data-centric web applications and services (160,000+ contacts, 20,000+ users, 7,000+ monthly visits) using Drupal 7/8, CiviCRM, PHP, MySQL, and shell scripts.
  • Built and supported online payment and transaction systems (e-commerce, donations, raffles), including database tables, stored procedures, and reporting queries.
  • Created ETL scripts to clean, transform, and load data between public-facing systems, CRM, and reporting databases, helping improve data quality and consistency.
  • Managed databases (schema changes, indexing, backup/recovery) and wrote queries for finance, fundraising, and program teams.
  • Provided documentation and training for internal users and external partners; acted as a bridge between business staff and technical systems.

  • Meridian Development Corp.

    IT Administrator

    2011 - 2013
  • Developed internal business applications and reporting tools using PHP, HTML, CSS, and MySQL.
  • Supported Windows servers, Exchange, SharePoint, and Active Directory; implemented backup and disaster recovery processes.
  • Created a web application to track project costs and progress, designing the underlying database and reports for management.

  • First Degree Developments Ltd.

    IT Administrator

    2009 - 2011
  • Designed and developed business applications and corporate websites using HTML, PHP, and MySQL.
  • Managed servers, backups, and networking, ensuring systems availability and data integrity.

  • Education

    University of Saskatchewan

    College of Arts and Science – Department of Computer Science

    2005 - 2009
  • Bachelor of Science Four-Year: Computer Science
  • Recent projects

    Macewan University and myportal

    The Lung Association

    Lung Disease Drug Database

    Yancoal Canada Resources Co., Ltd.

    Stanard Service

    Arbour Ridge Inn and Suite

    Montebello Homes

    Ezreal Studio

    OverC Health Management