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 - 2022.06
Professional Certificate - SQL
Codecademy
Virtual Learning Platform 02.2021 - 2021.02
Professional Certificate - Code Foundations
CodeCademy
Virtual Learning Platform 01.2021 - 2021.01
Professional Certificates - Various Disciplines
CG Masters Academy
Virtual Learning Platform 01.2016 - 2017.05
College Certificate (1 Year) - Intro To Animation And Illustration
Algonquin College
Ottawa, ON 01.2013 - 2014.05
Secondary School Diploma - High-School
Sacred Heart High School
Stittsville, ON 09.2008 - 2012.06
Skills
Data analysis and visualization
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
Similar Profiles
PHILIPPE MADGINPHILIPPE MADGIN
Director General (EX-03) at CANADIAN TRANSPORTATION AGENCYDirector General (EX-03) at CANADIAN TRANSPORTATION AGENCY
Aline Melissa AMAHOROAline Melissa AMAHORO
Project Services Officer at Canadian Transportation AgencyProject Services Officer at Canadian Transportation Agency
KIMBERLY NOWAKKIMBERLY NOWAK
Research Assistant at Canadian Air Transportation Safety AgencyResearch Assistant at Canadian Air Transportation Safety Agency