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.

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.

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.

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