Environment: Microsoft VB.NET 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / IBM MQSeries / Microsoft C# 3.5 / Ajax Control Toolkit / jQuery

Leveraging his experience in testing emiliWEB and its related component applications, Mr. Turcotte was tasked and delivered the design, documentation, development, and deployment of emiliTEST. This application is designed to execute test cases against the emili environment. The structure allows execution of unit, application and system-wide tests to compare results of software revisions and also test the ‘health’ of emili at any given moment.

Environment: Microsoft VB.NET 2.0 and 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / IBM MQSeries / Microsoft C# 3.5 / Ajax Control Toolkit / jQuery / Service Oriented Architecture (SOA) / UML Modelling

Adaptation of the emiliCONNECT web interface for use within emiliRU which allows underwriters to access third party services to order appraisals. Centract is an Appraisal services provider. emiliCONNECT interacts with a web service provided by Centract to provide Appraisal Services to CMHC clients. NAS is an Appraisal services provider. emiliCONNECT interacts with a service NAS provides via MQ Series to provide Appraisal Services to CMHC clients. Equifax is a credit bureau / credit score service provider. emili interacts with Equifax via MQ Series connections to provide credit scores on borrowers for risk assessment.

Environment: Microsoft VB.NET 3.5 / Microsoft C# 3.5 / Microsoft ASP.NET 2.0 / Microsoft Windows Communication Foundation (WCF) / Windows Server 2003 / XML Schema / IBM Websphere MQSeries / IBM DataPower / Service Oriented Architecture (SOA) / UML Modelling

emiliWEB Data Services is a custom implementation of a service bus to manage service requests from various external business sources. emiliWEB Data Services represent an evolution of the simple web service interface presented with emiliXML allowing service calls through Websphere MQSeries, WCF services, and simple web service interfaces. Dealing with many large financial clients including CIBC, MCAP, Desjardins, and Bank of Nova Scotia, Mr. Turcotte’s responsibilities included:

• Analyzing business requirements and then communicating impact, concerns, concepts, and solutions to managers.
• Preparing concept and design documentation to meet new requirements employing UML diagrams.
• Analyzing technical outcomes and generating functional and technical specifications for team members to meet those outcomes.
• Ensure successful compatibility and integration with external service buses on IBM DataPower, WCF service call, and WebSphere MQ based systems.
• Producing test cases for unit, application, and system-wide scenarios.
• Maintaining and updating CMHC’s emili XML schema document to meet new business products and service new interface technologies.

Environment: Microsoft VB.NET 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / IBM MQSeries / Ajax Control Toolkit / jQuery

Extension of the emiliWEB platform to deliver QA, BPR, and Exception reports to the lender user community. Responsibilities included:

• Reviewing requirements with client and assisting with construction of a business requirements document
• Analyzing business requirements and producing functional specification

Environment: Microsoft VB.NET 2.0 and 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / IBM MQSeries / Microsoft C# 3.5 / Ajax Control Toolkit / jQuery

Development of Web interface for both CMHC Corporate users and client (lender) users. The application itself is n-tier with database processing on mainframe DB/2 and web service connections to third party service providers. Responsibilities included:

• Reviewing requirements with client and assisting with construction of a business requirements document
• Analyzing business requirements and producing functional specification
• Analyzed existing database and made recommendations for improved normality and performance

Environment: Microsoft VB.NET 2.0 and 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / IBM MQSeries / Click-Once Deployment

Duties involve provision of technical and design support to project team. emiliRU is a corporate desktop application communicating with a server via both direct web service calls and Workflow Foundation/Windows Communication Foundation calls. Helped construct and maintain the automated deployment method and package for the product.

Environment: Microsoft VB.NET 2.0 and 3.5 / Microsoft ASP.NET 2.0 / Windows Server 2003 / Microsoft COM+ / IBM MQSeries / Microsoft C# 3.5 / Ajax Control Toolkit

Enhancements are being made to the emiliCLAIMS application to take advantage of AJAX architecture and improve the overall performance of the application. Responsibilities included:

• Reviewing requirements with client and assisting with construction of a business requirements document
• Analyzing business requirements and producing functional specification

Environment: Microsoft VB.NET 1.1 and 2.0 / Microsoft ASP.NET 1.1 and 2.0 / Windows Server 2003 / Microsoft Transaction Server/COM+ / IBM MQSeries

This project involved redeploying the existing emiliWEB application with a new presentation layer coded in Visual Studio.NET to enhance appearances and functionality of the web site improving the quality of data received from lender clients and improving their user-experience. Responsibilities included:

• Reviewing requirements with client and assisting with construction of a business requirements document
• Analyzing business requirements and producing functional specifications
• Producing specification for new tables integrating into existing emili relational database
• Producing test plans
• Producing specifications for production hardware requirements
• Produce specifications for deployment (firewall rules, port assignments, application installation guides, platform dependencies, back-out methods, etc.)

Environment: Microsoft VB.NET 1.1, 2.0, and 3.5 / Microsoft ASP.NET / Windows Server 2000 / Microsoft Transaction Server/COM+ / IBM MQSeries / Ajax Control Toolkit

emiliClaims replaces the Claims Receipt component of the legacy MICS application. Mr. Turcotte participated in client meetings and designed and implemented the web server application components. Responsibilities included:

• Analysing Claims Receipt module of MICS to produce a scope analysis document
• Reviewing requirements with client and assisting with construction of a business requirements document
• Analysing business requirements and producing functional specification which leveraged existing emiliCLAIMS application
• Producing specifications for application database

Environment: Microsoft VB.NET 1.1 and 2.0 / Microsoft ASP.NET / Windows Server 2000 / Microsoft Transaction Server/COM+ / IBM MQSeries

Mr. Turcotte was responsible for creating the initial application architecture, dealing with the clients and system teams (database, hardware, mainframe programmers). Responsibilities included:

• Analysing Claims Receipt module of MICS to produce a scope analysis document
• Reviewing requirements with client and assisting with construction of a business requirements document
• Analysing business requirements and producing functional specification which leveraged existing emiliCLAIMS application
• Producing specifications for application database

Environment: Windows XP/2003, MS Visual Basic 6.0 / Microsoft Visual Interdev / Windows Server 2000 / Active Server Pages / MS Transaction Server/COM+ / IBM MQSeries

emiliClaims was created to replace a “claim submission by fax” process. The system improves data quality and provides access to the claims process to any lender with Internet access. Mr. Turcotte was responsible for creating a project plan, architecting a solution, coordinating work tasks with the groups involved (database, mainframe programmers,) and presenting the final deliverable. Responsibilities included:

• Analysing client functions to produce a scope analysis document
• Reviewing requirements with client and assisting with construction of a business requirements document
• Analysing business requirements and producing functional specification
• Producing specifications for application database

Environment: Windows XP/2003, MS Visual Basic 6.0 / Windows Server 2000 / Active Server Pages / MS Transaction Server/COM+ / IBM MQSeries

emiliXML was created to provide a data interface between lenders with an exsiting LOS and emili to reduce data entry duplication. Mr. Turcotte produced the XML Schema – data definition document – used to define the format of the data exchange. The application was interfaced with the existing emiliWEB application to reuse code as much as possible and maintain equivalent processing between emiliXML and emiliWEB.

Environment: Windows XP/2003, MS Visual Basic 6.0 / MS Visual Interdev / NT Server 4.0 / IIS 4.0 / Active Server Pages / Microsoft Transaction Server / IBM MQSeries

emili is a system permitting lenders to apply for mortgage insurance on behalf of their clients electronically. WEBemili is an Internet based version of this application allowing access by any lender with an Internet connection. Mr. Turcotte was responsible for design and implementation of the application code, improving efficiency and capability over that of the original VB application.

Environment: Windows XP/2003, Microsoft Visual Basic 5.0 / Crystal Reports / Videosoft VS-OCX / Apex TrueDBGrid / IBM MQ Series Client

Mr. Turcotte was responsible for implementing new business requirements. As the application was very old, its code did not take advantage of the modern development tools available. Mr. Turcotte updated large sections of the application to improve performance and simplify future maintenance.

Environment: Windows XP/2003, Microsoft Visual Basic 5.0 / Crystal Reports / Videosoft VS-OCX / Apex TrueDBGrid / IBM MQ Series Client

MBS is a client-server application. Mr. Turcotte was responsible for the design and implementation of the client-side reporting tools. In addition, he designed the client-side component architecture.