Getting Started My first publication was a PC-based Math Tutor that my father distributed to colleagues at Humber College in Toronto, Ontario. It was written in GW-BASIC on my first PC, the IBM PCJr. By the end of high-school I ran a bulletin board on a computer equipped with 1200 BAUD modem in my parent's garage. The system was linked into the FIDO network and exchanged messages between members and users all over the world. Communications was my interest and developing tools along these lines began with my purchase of TurboBASIC and developing a tool to connect PCs to LinoType digital typesetters. It was obvious to me that networking technologies, innovating solutions, and development of tools was my future. The following are the accomplishments of my professional career, in many cases the solutions provided were over-and-above my prescribed role and were built based on a recognised need. Microsoft Canada Inc. Microsoft Canada Download Service - When I started at Microsoft, Canadian customers would only be able to source drivers and product updates though our BBS in Seattle. For the bulk of our customers this meant cross-board long-distance calls or waiting for a diskette in the mail. Based strictly on conservative mailing costs this system saved $250,000 the first year it operated and remained in operation until 1998 when the Internet was finally strong enough to replace the BBS technology. The BBS did not solely serve the customer. The technicians faced the challenge of not knowing what files were and were not on the download service in Seattle and Toronto. The knowledge base would list a file as being available but there was no simple manner for the support services staff to verify that it was there, perhaps having a repeat caller due to a file being dropped. To prevent the inconvenience for everyone involved, the service gained a tool to verify and report all files on the service through an intranet web server. The file would report missing files as well as estimated download times. The Microsoft Canada support services lab - Until 1996 PSS agents relied on cannibalizing their own PCs to test a customer's problem. Through pressure from myself and others the lab was created as a key tool in serving customers better. Featuring an isolated LAN, leading edge hardware, and controlled internet access this lab moved support ahead allowing technicians to research problems without a reliance on the corporate support teams and allowing them to maintain their own PC's stability. Microsoft Canada Intranet Server - Providing easy access to information through a relatively new technology, this system began my web-centric activities and served the entire organization, putting Microsoft Canada on the electronic map. Services included Call Queue tracking, reporting, marketing information and social information. 15 year Wallpaper - While a trivial act, this was displayed on all PCs during the opening of the Canadian office on Matheson Blvd. in Mississauga. Letter Log Report Generator - Used for tracking paper-based correspondence at Microsoft, this was written in BASIC 7.1 in my first year at Microsoft. CD-Key Generator for Office 97 - When the manufacturing process dropped the last digit off the CD-KEY, the phone lines were swamped and the CSRs had no choice but to put people on hold for a technical support agent. They would wait for as much as an hour, at their expense. This tool allowed the CSRs to handle the issue and save the customer, and company a great deal of time. Anti-Piracy Auditing - Supporting Microsoft's involvement with Canadian Alliance Against Software Theft (C.A.A.S.T.) I was fortunate to participate in software auditing raids across Canada. Under the rights offered by an Anton Pillar order we were able to enter and audit computer systems gathering evidence regarding software theft (piracy) within an organisation. Molson Breweries Ltd. Meridian Max Report Capture - Eliminating the paper output from our phone system and accommodating direct import to Microsoft Excel or Access through the use of Visual Basic and connection over serial communications Move/Add/Change Database Application - Again, removing the need for paper and automated the access and review or upcoming MAC activity. Management no longer felt removed from the information and managers were able to print their own reports for reference and staff meetings. Developed with Microsoft Access. Online Service Book - Web-based manual for on-site technicians featuring all technical documentation, online and updated as changes or additions were available. Paramount Trading Inc./e-Concept/Berkshire Interactive Technologies Web Skin Manager - Based on strict rules and design code, the tool would overhaul a web site's overall look through a management tool that mapped all graphics used and making adjustments to the content in a clean and user-friendly manner. This was later integrated into the online design using my code for a CGI tool to interconnect with a telnet-based gaming system. Web-based Financial Reporting - Removing Cognos as the tool of choice (mostly because they wouldn't pay for it) I wrote the tool running on IIS in Active Server Pages against the Microsoft SQL database. Migration of Site from Antigua to Guatemala - Start a move from one site in the first week of April for a drop-dead, servers-ready date of May 8th. We ordered 4 Dell Servers for delivery to our software vendor in Canada, Had them prepared and delivered to Guatemala and were ready to run in time to move the domain to the new systems, with no down time. Planning and development of Antigua office network with Remote Access and ISDN connectivity. Planning and development of the Server Rack featuring a Domain Controller, SQL Server, Exchange Server, IIS Server and Application server. This site maintained stable operations from 1999 through 2001. Toyota Canada Inc. Toyota Imaging Network - for PC deployment and data recovery. Reduces errors and time to rebuild from 1 hour, to 20 minutes. Allows for data recovery using Symantec Ghost. All system images are available and easily updated as needed through a common server and interface. The menu-driven solution ensures that even newcomers are able to get up to speed with very little hand-holding. On-line documentation and practical scripting ensures that systems built are 100% ready and able to protect themselves from the latest viruses. SALVAGE.CMD and the procedures around System Migration - User impact reduced from over an hour to 5 minutes. Though there will be a change when Windows XP hits TCI, the current exploitation of unfettered (unfirewalled) access to desktop systems serves the team very well. Are there security concerns, yes, but the key is your people and a tightly controlled list of users who have rights to perform such tasks. SMS Reporting Tools - Canned queries for software licencing, PC tracking, and administration have saved time and efforts for the whole of I.T. and have given some opportunity for pro-active user assistance. Transferred auditing demands from SMS Administrator, to clerical staff. SMS compatible scripting (application packaging) allowed for manual or automated installation of software, even where SMS was not required, these packages saved time for end-user support team and reduced delivery time. Mentoring TCI's co-op placements and full-time employees in the how and why of technology is a huge mutual benefit. The company gains very productive employees who are well trained. The co-ops gain practical knowledge, even though they are worked off their feet, and the company has a very capable body that doesn't cost them and arm and a leg. My reward, teaching. I love the transfer of knowledge Disaster Recovery Image - Should anything cause TCI's location in Scarborough to be unavailable, the desktop systems will not be the hurdle. The systems are as similar to the employee's work environment as they can get. It'll be much easier with Windows XP, but as the standard is Windows 2000 for the next few weeks. Multiple Monitors on one PC - When our operations team began requesting multiple PCs to accomodate applications that are meant to monitor our network they gained some resistance due to the cost of these additional systems. The simplest solution was to utilize some of the more capable video cards to connect two or more monitors to existing PCs. While we did upgrade many of the displays to LCD Flat-Panel, the cost per screen was $300 vs. the potential $1700 per PC (with screen) and, in this case, saved us the deployment of 4 or more PCs. The solution has been applied to many other projects around the company and is now a standard offering. Notably there are easier solutions available now that offer this solution, remarkably, through USB. This eliminates the need to open a PC and does reduce the cost. Freelance Media Advertising Chart - This tool, based in Excel and written in VBA, allowed an uptown advertising company to plan and coordinate Radio, Print and TV ads over a calendar factoring costs and placement for accounts. |