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.