Stephen Rook Email & Phone Number

Ottawa, On, Ca

Ottawa, Ontario, Canada

Ottawa, Canada Area

Ottawa, Canada Area

Development of a custom ERP solution that is used throughout the Company to provide tracking and detailed information regarding the production and process of customer orders. The system was developed to allow users in various departments to view and interact with customer orders, view detailed inventory and costing reports, manage inventory and provide work flow dashboards. The system was designed with low bandwidth in mind, so manufacturing offices in China and Hong Kong could access with… Show more Development of a custom ERP solution that is used throughout the Company to provide tracking and detailed information regarding the production and process of customer orders. The system was developed to allow users in various departments to view and interact with customer orders, view detailed inventory and costing reports, manage inventory and provide work flow dashboards. The system was designed with low bandwidth in mind, so manufacturing offices in China and Hong Kong could access with reasonable response times. The Solution was designed with the following features: Security trimming User / Data management Inventory Cost Accounting Reporting Custom dashboards PDF generation Excel exportTechnical Environment; ANSI Transact-SQL in Microsoft SQL Server 2008, TSQL, IIS 7, .ASP NET 4.5, C#, JavaScript, Windows 2008, Visual Studio .NET 2015, Entity Framework 6.1, DOCX Word generation, EPPlus Excel generation, Telerik UI Components, Team Foundation Services (TFS) Show less

Ottawa

PSIMS – Public Safety Information Management SystemAs part of development team, participated in the development of Public Safety’s Grants and Contributions Information management system. Built on top of the Microsoft .NET technology stack, this application was designed in an n-tier fashion and utilizing andobject oriented approach. The data services layer was developed utilizing Microsoft Entity Framework. Some of the major system features include: Dynamically create and… Show more PSIMS – Public Safety Information Management SystemAs part of development team, participated in the development of Public Safety’s Grants and Contributions Information management system. Built on top of the Microsoft .NET technology stack, this application was designed in an n-tier fashion and utilizing andobject oriented approach. The data services layer was developed utilizing Microsoft Entity Framework. Some of the major system features include: Dynamically create and manipulate Microsoft Word and Excel documents Import business data from existing information systems Import financial data from SAPTechnical Environment; ANSI Transact-SQL in Microsoft SQL Server 2008, TSQL, IIS 7, .ASP NET 4.5, C#, JavaScript, Windows 2008, Visual Studio .NET 2013, Entity Framework 6.1, DOCX Word generation, EPPlus Excel generation, Telerik UI Components, Team Foundation Services (TFS) Show less

Ottawa, Canada Area

THC – Travel, Hospitality and Conference Data entry and workflowDevelopment of a Windows Presentation Foundation (WPF) prototype application that can be used by employees to enter, manage and approve travel authorizations. The application was written utilizing an object oriented approach. The application was developed as an n-tier structure. The data services layer was developed utilizing Microsoft Entity Framework.Technical Environment; ANSI Transact-SQL in Microsoft SQL Server… Show more THC – Travel, Hospitality and Conference Data entry and workflowDevelopment of a Windows Presentation Foundation (WPF) prototype application that can be used by employees to enter, manage and approve travel authorizations. The application was written utilizing an object oriented approach. The application was developed as an n-tier structure. The data services layer was developed utilizing Microsoft Entity Framework.Technical Environment; ANSI Transact-SQL in Microsoft SQL Server 2008, TSQL, IIS 7, .ASP NET 4.5, C#, JavaScript, Windows 2008, Visual Studio .NET 2013, Enterprise Library 5, Telerik UI Components Show less

Notes – Mobile meeting notesDevelopment of an HTML5 mobile application that can be used by employees to view and manage meeting notes. The application was written utilizing the jQuery mobile framework with a target user interface being the corporate BlackBerry’s built-in browser. The application was developed as an n-tier structure. The data services layer was developed utilizing the web.api interface. An iPad application consumes this web.api data service.Technical Environment;… Show more Notes – Mobile meeting notesDevelopment of an HTML5 mobile application that can be used by employees to view and manage meeting notes. The application was written utilizing the jQuery mobile framework with a target user interface being the corporate BlackBerry’s built-in browser. The application was developed as an n-tier structure. The data services layer was developed utilizing the web.api interface. An iPad application consumes this web.api data service.Technical Environment; ANSI Transact-SQL in Microsoft SQL Server 2008, TSQL, IIS 7, . ASP NET 4.5, C#, JavaScript, Windows 2008, Visual Studio .NET 2012, jQuery Mobile, Telerik UI Components, Team Foundation Services (TFS) Show less

Mobile IPIL – Passport ScannerDevelopment of an HTML 5 mobile prototype application used to provide passport and driver’s license scanning ability to border security officers. Scanned documents are sued to search databases returning any relevant data to the security officer. Application was designed to work on several devices notably the iPhone and Samsung Galaxy and to be used with the Grabba Scanning device. This HTML 5 application was designed with the following features:… Show more Mobile IPIL – Passport ScannerDevelopment of an HTML 5 mobile prototype application used to provide passport and driver’s license scanning ability to border security officers. Scanned documents are sued to search databases returning any relevant data to the security officer. Application was designed to work on several devices notably the iPhone and Samsung Galaxy and to be used with the Grabba Scanning device. This HTML 5 application was designed with the following features: Barcode scanning RFID discovery Photo capture 2D and 3D scanning MRZ passport scanning AJAX for database searchTechnical Environment; ANSI Transact-SQL in MS SQL Server, MS Enterprise Library, Microsoft SQL Server 2008, TSQL, IIS 7, . ASP NET 4.0, Custom controls, C#, JavaScript, Windows 2008, Visual Studio .NET 2012, Grabba scanning attachment Show less

Planning Support Tool – WCAG RefitThis project involves the upgrade of an existing .Net based web application to implement Web Content Accessibility Guidelines (WCAG) with a specific focus on the visually impaired users of the system. The business office application and associated login portal was retrofitted to be fully WCAG compliant. The ‘JAWS’ screen reader software was installed on the development environment and utilized to test all features.Technical Environment; ANSI… Show more Planning Support Tool – WCAG RefitThis project involves the upgrade of an existing .Net based web application to implement Web Content Accessibility Guidelines (WCAG) with a specific focus on the visually impaired users of the system. The business office application and associated login portal was retrofitted to be fully WCAG compliant. The ‘JAWS’ screen reader software was installed on the development environment and utilized to test all features.Technical Environment; ANSI Transact-SQL in MS SQL Server, MS Enterprise Library, Microsoft SQL Server 2008, TSQL, IIS 7, . ASP NET 4.0, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, SourceSafe, Telerik, Show less

Applied Epidemiology Resource Operations (AERO)The initiative involves the development of a business office application that will support the operational activities associated with the Agency’s roster/reservist of epidemiologists, requests for assistance and associated mobilizations. The application is intended to support the information requirements of the individuals identified to support mobilisations (e.g. registry, request for assistance, training, calendars, and document… Show more Applied Epidemiology Resource Operations (AERO)The initiative involves the development of a business office application that will support the operational activities associated with the Agency’s roster/reservist of epidemiologists, requests for assistance and associated mobilizations. The application is intended to support the information requirements of the individuals identified to support mobilisations (e.g. registry, request for assistance, training, calendars, and document repository). The application will also maintain information on the requests for assistance and the actual mobilisations. Meetings with stakeholders and project management office to go over and analyze requirements. The application was designed with the following feature set: User management Role based security Interactive calendar Document library Discussion Forum Email distribution WCAG AA Compliancy Multi-browser support “JAWS Screen Reader” compatible SOA implementationTechnical Environment; ANSI Transact-SQL in MS SQL Server, MS Enterprise Library, Microsoft SQL Server 2008, TSQL, IIS 7, ASP.NET 4.0, Telerix RAD Controls for ASP.NET, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, SourceSafe, Telerik, JAWS Screen Reader, , Microsoft SourceSafe Show less

Data Access Management Application (DAMA)Develop a web-based application to manage the data access requests and agreements between Health Canada/Public Health employees and the DAMA group. Created the database and stored procedures for the data access layer. Created the web-based application structure and associated user controls along with the necessary business class libraries. Meet with clients to assist in requirements gathering and demonstrating the application.Technical… Show more Data Access Management Application (DAMA)Develop a web-based application to manage the data access requests and agreements between Health Canada/Public Health employees and the DAMA group. Created the database and stored procedures for the data access layer. Created the web-based application structure and associated user controls along with the necessary business class libraries. Meet with clients to assist in requirements gathering and demonstrating the application.Technical Environment: Visual Studio 2010; Microsoft ASP.Net Framework 4.0; Visual Source Safe ; C#; JavaScript; CSS; IIS 7; Telerix RAD Controls for ASP.NET; Microsoft SQL Server 2008; Stored Procedures, TSQ, User-Defined Functions; TSQL; RedGate SQL Tool Belt; Data Modeling and Design; CLF; Microsoft SourceSafe Show less

Human Pathogens and Toxins Consultation Database – Phase IIUpdates to an existing business application based upon client feedback and an updated Business Requirement Document (BRD). Meet with end uses and business managers to clarity and finalize requirements. System was upgraded with the following features: Allow for Documents to uploaded that indexed by SQL Server Installation of Office 2007/2010 and PDF filters for SQL Server 2008 Access full text index to… Show more Human Pathogens and Toxins Consultation Database – Phase IIUpdates to an existing business application based upon client feedback and an updated Business Requirement Document (BRD). Meet with end uses and business managers to clarity and finalize requirements. System was upgraded with the following features: Allow for Documents to uploaded that indexed by SQL Server Installation of Office 2007/2010 and PDF filters for SQL Server 2008 Access full text index to enable tag cloud functionally based upon document contents Allow for multiple attachments uploads in all document areas User interface reworked to provide a more robust and intuitive experience Calendar and Scheduler ability incorporated Localized resources were created and compiled Implementation of WCAG AA guidelines Web services integration (SOA)Technical Environment; ANSI Transact-SQL in MS SQL Server, MS Enterprise Library, Microsoft SQL Server 2008, TSQL, IIS 7, ASP.NET 4.0, Telerix RAD Controls for ASP.NET, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML,IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, Microsoft SourceSafe Show less

Enterprise System Standards DevelopmentCreation of web business application and database development standards to be used by development group in an effort to create consistent application structures and database schemas. Web based development architecture standards were created utilizing Visual Studio 2010 web projects.Technical Environment: ANSI Transact-SQL in MS SQL Server, Microsoft SQL Server 2008, MS Enterprise Library, TSQL, IIS 7, ASP.NET 3.5, Telerix RAD Controls for… Show more Enterprise System Standards DevelopmentCreation of web business application and database development standards to be used by development group in an effort to create consistent application structures and database schemas. Web based development architecture standards were created utilizing Visual Studio 2010 web projects.Technical Environment: ANSI Transact-SQL in MS SQL Server, Microsoft SQL Server 2008, MS Enterprise Library, TSQL, IIS 7, ASP.NET 3.5, Telerix RAD Controls for ASP.NET, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, Microsoft SourceSafe Show less

CLF 2.0 Application ConversionConversion of all Agencies existing web applications to become compliant to Treasury Boards Common Look and Feel guidelines (CLF 2.0). Existing business applications were structured were based upon on an in-house developed guidelines. 15 existing applications and existing login portal were converted. An application framework based upon the CLF 2.0 standard was also created, documented and distributed to existingdevelopment staff to assist in startup of… Show more CLF 2.0 Application ConversionConversion of all Agencies existing web applications to become compliant to Treasury Boards Common Look and Feel guidelines (CLF 2.0). Existing business applications were structured were based upon on an in-house developed guidelines. 15 existing applications and existing login portal were converted. An application framework based upon the CLF 2.0 standard was also created, documented and distributed to existingdevelopment staff to assist in startup of new application development. Creation of application and database development standards to be used by development group in an effort to create consistent application structures and database schemas. Integration of existing login and security modules Usage of existing multi-cultural processes AJAX technology utilized for a more consistent and responsive user interface MS SQL Server 2008 System was designed from a prepared requirements document, utilizing the complete software development lifecycle. Provided feedback to project manager regarding requirements document Creation and determination of application architecture and class structures Implementation and development of all data layer components Production and implementation of required data model Provided project timelines and levels of estimates to project manager Provide status updates to project team and stakeholders Creation of application specific style sheets and look and feel Developed utilizing Visual Studio 2008, .NET 3.5 , C# Utilization of Telerik RadControls suite for ASP.NET Web services integration (SOA) Show less

Human Pathogens and Toxins Consultation Database - Business systems developmentWeb based content management tool to allow for staff to enter and manage information relating to Laboratories and other entities in Canada that handle human pathogens and toxins. The information entered into the system is validated against the rules and regulations set out in the Parliamentary Act enacted for this initiative. The system was based on the CLF 2.0 framework as set out by Treasury Board. The… Show more Human Pathogens and Toxins Consultation Database - Business systems developmentWeb based content management tool to allow for staff to enter and manage information relating to Laboratories and other entities in Canada that handle human pathogens and toxins. The information entered into the system is validated against the rules and regulations set out in the Parliamentary Act enacted for this initiative. The system was based on the CLF 2.0 framework as set out by Treasury Board. The system was designed with the following features and components: Integration of existing login and security modules Usage of existing multi-cultural processes AJAX technology utilized for a more consistent and responsive user interface MS SQL Server 2008 Integration of existing web services (SOA) System was designed from a prepared requirements document, utilizing the complete software development lifecycle. Provided feedback to project manager regarding requirements document Creation and determination of application architecture and class structures Implementation and development of all data layer components Production and implementation of required data model Provided project timelines and levels of estimates to project manager Provide status updates to project team and stakeholders Creation of application specific style sheets and look and feel Developed utilizing Visual Studio 2008, .NET 3.5 , C# Utilization of Telerik RadControls suite for ASP.NETTechnical Environment; ANSI Transact-SQL in MS SQL Server, Microsoft SQL Server 2008, MS Enterprise Library, TSQL, IIS 7, ASP.NET 3.5, Telerix RAD Controls for ASP.NET, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2008 / 2010, Microsoft SourceSafe Show less

Boat Finder – iPhone / iPad ApplicationDevelopment and successful deployment to production environment of an iPhone and iPad business application to be distributed on Apple’s App Store. Application is designed utilizing the Titanium Development Environment for the Mac Book Pro. This development studio is capable for creating iOS, Mac OS and Android native apps though a common code base. This app will allow users to search and view antique boats that are available on the… Show more Boat Finder – iPhone / iPad ApplicationDevelopment and successful deployment to production environment of an iPhone and iPad business application to be distributed on Apple’s App Store. Application is designed utilizing the Titanium Development Environment for the Mac Book Pro. This development studio is capable for creating iOS, Mac OS and Android native apps though a common code base. This app will allow users to search and view antique boats that are available on the www.antiqueboatamerica.com web site. Discussion sessions with end uses and company executives to discuss and analyze requirements. Application is being developed based upon the following feature set: Dynamically query boat categories View boat details in real time View and navigate boat image libraries Submit questions about specific boats Web services/JSON based data source (SOA)Technical Environment; iMAC, Titanium, ANSI Transact-SQL in MS SQL Server, Microsoft SQL Server 2008, TSQL, IIS 7, ASP.NET 4.0, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, Team Foundation Server Show less

Survey of Family Courts - Business application systems developmentA nationwide web based application used by provincial and federal courts to enter and manage data relating to divorce settlements, child and spousal support and relatedinformation. The system was designed to be responsive over a WAN environment to differing network connections throughputs around the country. System was based on the CLF 2.0 guidelines as determined by Treasury Board. The system was designed with the… Show more Survey of Family Courts - Business application systems developmentA nationwide web based application used by provincial and federal courts to enter and manage data relating to divorce settlements, child and spousal support and relatedinformation. The system was designed to be responsive over a WAN environment to differing network connections throughputs around the country. System was based on the CLF 2.0 guidelines as determined by Treasury Board. The system was designed with the following features and components: Utilization of a single sign-on methodology Encryption module for url encoding and decoding Localization for multilingual interface Shadowbox enabled popups AJAX enabled for faster response SQL 2008 was employed as the back end data repository Security layer to ensure courts have only access to their data System was designed from a prepared requirements document, utilizing the complete software development lifecycle. Analysis of stakeholder provided requirements and provided feedback Creation and determination of application architecture and class structures Implementation and development of all data layer components Development of SQL data layer schema Provided project timelines and levels of estimates to project manager Provide status updates to project team and stakeholders Creation of application specific style sheets and look and feel Developed utilizing Visual Studio 2010, .NET 4.0 and Microsoft’s AJAX library Provide meeting minutes, agendas and notes to project team for stakeholder prototyping and uat sessions Provide technical and support documentation for resident development groupTechnical Environment; ANSI Transact-SQL, Microsoft SQL Server 2008, MS Enterprise Library, TSQL, IIS 7.5, ASP.NET 4.0, Telerix RAD Controls for ASP.NET, Custom controls, C#, VBScript, JavaScript, Windows 2008, HTML, IE, NE, Style Sheets, JavaScript, Visual Studio .NET 2010, TFS, Visio 2010 Show less

Responsible for the development of numerous systems in a variety of platforms/environments including:Microsoft .NetSharepointBlackberryMS SQL ServerTechnical Environment; Workflow Gen tm, ANSI Transact-SQL in MS SQL Server, Web services, Microsoft SQL Server 2005, TSQL, IIS, ASP.NET 3.5, 4.5, Custom controls, JavaScript, Windows Server IIS, HTML, IE, NE, JavaScript, Visual Studio, AJAX, CSS, Microsoft SourceSafe, TFS