Al Gagnon Email & Phone Number

- Championed resourcing initiatives, identifying critical team needs and executing strategic hires, enhancing team capacity and delivery timelines.- Crafted a comprehensive technical roadmap, outlining key milestones and objectives, prompting a 35% improvement in project planning accuracy and alignment with organizational goals.- Increased quality of deliverables and reduced overspending by 70% in the external Services division.- Implement team collaboration, process changes, and architectural changes which increased quality and reduced delivery time of features by 4-6 months.- Mentored and coached team members, nurturing professional development and skill enhancement.- Advocated for quality-focused practices, causing improvement in code quality, maximized efficiency, and adherence to project budgets.- Collaborated seamlessly with cross-functional teams such as Product, DevOps, and IT Ops, streamlining communication channels and decreasing project delivery time through interdepartmental coordination.- Managed 5 teams (Developers x 2, QA, MLS Data Ingestion Services, Custom Reporting Services) consisting of 28 people - Creation of dashboards to facilitate reporting of key information (project status, velocity, quality output, API usage statistics, etc)- Custom VBA macro and Add-in creation to facilitate reporting and formatting.Tech stack: Python, Scala, React.js, EDB, Postgres, PowerBI, Airflow, AWS, VBATools: Github, BitBucket, Jira, Confluence, Clockify, Jenkins

Ontario, Canada

• Managed a distributed software development team, conducting code reviews, providing team mentoring, and performing quarterly team member reviews. (Bootstrap, C#, .NET, SQL)• Established and documented database development standards and guidelines, implementing initial guidelines to affirm uniformity and adherence to best practices across the organization.• Fronted the execution of SonarQube within the development process, strategically reducing technical debt, and enhancing code quality and reliability.• Played a key role in troubleshooting SQL Server issues across various products, applying high-level database development standards to improve data integrity and efficiency.• Oversaw the creation, migration, and deployment of custom ad-hoc reports to standardized reports in SSRS, perfecting report generation time.• Custom VBA tools and Add-in development to facilitate data validation, formatting and SQL script generation. Reducing the process time from 6-11 days down to 5 minutes. Tech stack: SQL Server, VBA, C#/.NET, Bootstrap.js, SSRS, .NET, AzureTools: Github, BitBucket, Jira, Confluence, Clockify, Jenkins

Sudbury

• Led a dynamic technical team in developing API, Mobile, Database, and Web applications, improved overall development efficiency, and secured seamless integration across platforms.• Specialized in Short Interval Control (SIC) applications, and optimizing real-time project monitoring for enhanced decision-making.• Effectively managed features and mitigated scope creep within budget constraints, focusing on financial targets.• Coached a team of developers, nurtured their skills, and actualized a productive work environment.• Streamlined development and guidelines, conducted comprehensive code reviews, and established efficient documentation practices toward improved project consistency.• Develop a custom Excel VBA Add-in/Interface for the user to effectively manage application configurations stored in the database. (import from SQL Server, data formatting, data validation, saving back to SQL Server)Tech stack: C#, VBA, Angular, SQL Server, .NET 4.5, Typescript, AzureTools: Azure DevOps, SAP

Sudbury Ontario

• Simplified software and hardware support processes, curtailing issue resolution time through the execution of targeted troubleshooting strategies.• Drove the development of custom software solutions, meeting client specifications and improved workflows.• Orchestrated business process improvements by integrating off-the-shelf solutions, maximizing workflows, and achieving reasonable cost savings annually.• Directed cross-functional projects, adhering to strict timelines and budgets, boosting overall team productivity.

Sudbury, Ontario

Teacher in the Information Technology program covering the following course(s):- Introduction to relational databases (SQL Server)

Sudbury Ontario

• Engineered multiple tools (C# and .NET) for SETCIM analysis, SQL export, and PI data migration, identifying inefficiencies and overhauling them, strengthening system performance and data accuracy.• Developed comprehensive documentation for PI and ACE tag creation, streamlining the process and reducing tag creation time by 40%. (Excel and VBA)• Devised a customized Excel Add-in (VBA) for the client's Manual Data Entry application, expediting form creation and modification by 50% and enhancing user-friendliness.• Documented new tools and conducted comprehensive training sessions, enabling employees to proficiently utilize Excel Add-ins, promoting increased productivity and data analysis accuracy.

• Conducted Installation and operational Qualification (IOQ) testing, maintaining adherence to user requirements.• Implemented robust systems analysis methods, including the creation of custom tools (.NET and SQL) for data gathering, facilitating statistical analysis, and bolstering data-driven decision-making.• Organized end-user meetings, fostering collaboration and gaining invaluable insights, driving user-centric solutions and enhancements, and improving system usability and functionality.

Automated dashboard creation (Excel/VBA/SQL)Application development and maintenance (.NET and SQL)

Sudbury, Ontario

Systems analysis, planning, implementation and integration services

Sudbury, Ontario

Web application development in ..NET and SQL Server