SQL Developer
Kieran O'Boyle
IT Technical Advisor, Business Consulting Services
Vaudreuil-Dorion,QC
Summary
Application Developer and Technical Business Analyst with expertise in analysis and development of business requirements. Drives deployment of web-applications, datasets and dashboards for internal operations and system solutions to successful outcomes. Highly analytical and detailed with documented track record in .NET and micro-service architecture development. Proven success in analyzing issues and formulating strategic options. Team player with effective skills in both oral and written communication.
Overview
4
4
years of professional experience
2
2
years of post-secondary education
3
3
Professional Certificates in IT related courses
Work History
IT Technical Advisor, BA (Acting IT-03)
Canadian Transportation Agency (IMIT)
Vaudreuil-Dorion, QC
04.2023 - Current
- Develops applications to enhance business processes with agile methodology. Lead developer on multiple microservices currently in production at CTA.
- Project manager on high-profile projects, ensuring successful outcomes and on-time delivery.
- Evaluates problems and provides solutions based on expertise of system architecture and critical thinking skills.
- Manages sprint in Azure Dev-Ops, in order to optimize workload and ensure alignment with strategic priorities.
- Liaison between the IMIT planning and solutions team and various directorates within the agency to gather IT related requirements for evaluation, as well as presentation to respective committees.
- Successful track record working with tight deadlines in a fast-paced environment
- Create various data-sets in SQL Database, and design API calls in order for optimized data ingestion.
Technical Analyst (Indeterminate IT-02)
IMIT Planning And Business Solutions, Canadian Transportation Agency
Vaudreuil-Dorion, QC
12.2021 - Current
- Evaluates solutions and makes decisions based on critical thinking skills.
- Manages sprint in Azure Dev-Ops, in order to optimize workload and ensure alignment with strategic priorities.
- Develops applications to enhance business processes with agile methodology.
- Acts as a liaison between the IMIT planning and solutions team and various directorates within the agency to gather IT related requirements for evaluation, as well as presentation to respective committees.
- Produce dashboards in Power BI, to measure team performance, process evaluation, risk assessment, and KPIs (Key Performance Indicators).
- Successful track record working with tight deadlines in a fast-paced environment
- Identified issues, analyzed information and provided solutions to problems.
- Create various data-sets in SQL Database, and design API calls in order for optimized data ingestion.
Data and Reporting Analyst
Dispute Resolution Branch, Canadian Transportation Agency
Vaudreuil-Dorion, QC
02.2021 - 12.2021
- Supported triage procedures of intake, queue management, case document completion and complaint inquiries.
- Analyzed and synthesized information and made recommendations to senior management regarding process innovation, file batching opportunities and data integrity concerns.
- Collected data to analyze and report trends, and provided advice to senior management regarding potential process efficiencies/risks.
- Oversaw data collection for ATIP requests, annual report, departmental reporting framework as well as general media requests made by journalists and other agencies.
- Analyzed, created and maintained dashboard creation as a means to visually capture data and support branch initiatives and objectives.
Facilitator
Dispute Resolution Branch, Canadian Transportation Agency
Vaudreuil-Dorion, QC
01.2020 - 01.2021
- Reviewed and resolved air travel complaints through informal facilitation, based on analysis of terms and conditions of carriage, legislation, regulations, international conventions and jurisprudence.
- Provided outcome reports to applicants as well as stakeholders, and ensured data was reported accurately to reflect the integrity of annual reports.
- Responded to inquiries from public, industry and other governmental entities regarding disputes, processes and our role and mandate.
- Undertook research and special projects to support management and strategic objectives.
Education
Diploma - Computer Programming
Algonquin College
Virtual 06.2022 - Current
Professional Certificate - Business Analysis
Learning Tree
Online 02.2023 - 02.2023
Professional Certificate - HTML Foundations
CodeCademy
Virtual Learning Platform 05.2022 - 06.2022
Professional Certificate - SQL
Codecademy
Virtual Learning Platform 02.2021 - 02.2021
Professional Certificate - Code Foundations
CodeCademy
Virtual Learning Platform 01.2021 - 01.2021
Professional Certificates - Various Disciplines
CG Masters Academy
Virtual Learning Platform 01.2016 - 05.2017
College Certificate (1 Year) - Intro To Animation And Illustration
Algonquin College
Ottawa, ON 01.2013 - 05.2014
Secondary School Diploma - High-School
Sacred Heart High School
Stittsville, ON 09.2008 - 06.2012
Skills
Data analysis and visualization
Problem-Solving
Proficiency in SQL and C#
Proficiency in DAX and M
Planning and Team Co-ordination
Written Communication
Client Services
Proficiency in NET programming
Critical Thinking
Software
Visual Studio
Power BI
Azure DevOps
VS Code
VMWare
Excel
Visio
Interests and Hobbies
- 3D sculpting and modeling (Using Zbrush and Substance Painter)
- 3D Printing (Elegoo Saturn)
- Video game design inside Unity