Scott Stewart
55 MacKinley Crescent ● Cornwall, PE C0A 1H8 ● (902) 892 7722
scott@scottstewart.ca
Career Objective:
Information Technology Analyst
Summary of Experience:
Development and support experience with large and small MSSQL and Access databases
Software compatibility and reliability testing
Authoring technical and professional documentation
Teaching, leading and training others
Business Administration – Management, marketing, purchasing, human resources and accounting
Personal Attributes:
Honest, professional and straightforward individual looking to bring value to an organization
Passion for IT field and mastering new technologies as they evolve
Strong analytical skills that help turn data into information
Wide range of skills from multitasking to big picture thinking while driving to results
Excellent interpersonal, verbal and written communication skills
Pays attention to the details, constantly improves systems and reports to surpass client expectations
Specialties
Computer system hardware, networking, software testing and support.
Business management and information systems design.
Experience:
Web Application Developer (contract) at Veterans Affairs Canada October 2011 – February 2012 (expected)
- Designed, developed and maintained database of all web pages with multiple statistics for www.veterans.gc.ca.
- Cross referenced large databases to create web page traffic, status and doctype compliancy reports.
- Worked with HTML, CSS, JavaScript and ColdFusion to upgrade pages to XHTML 1.0 Strict document type standards.
Scott Stewart - Information Technology and Business Consultant 2000 – Present
Short and part-time projects for numerous clients
- Desktop, software and accounting training
- Networking, backup systems design and implementation
- Database design, development and support
- Website design, development, search engine optimization and hosting
- Marketing and advertising consulting
- Bookkeeping
Director and Website Administrator (volunteer) at North River Minor Hockey Association September 2008 – Present
- Participate in steering the policies as a Director of this local nonprofit minor hockey association
- Manage information, design, user accounts, hosting and advertising for the Association website - northriverflames.ca
- Lead training sessions for website users
- Coach, trainer, manager and 2010 Playoff Tournament Chair
Major accomplishment – Design and develop Association website currently used by 32 teams and coordinators and receives approximately 400 visitors per day during the hockey season.
Director and Treasurer (volunteer) at CHANCES Family Centre October 2004 – October 2011
- Participate at the Board level for steering policies of this Island wide, nonprofit organization that targets training and services to benefit preschool aged children and their parents
- Responsible as Treasurer for tracking and reporting to The Board with results and recommendations for annual budget
Technology Support Analyst (contract) at Agriculture and Agri-Food Canada December 2010 – May 2011
- Supported technologies include MS Access, MSSQL, managing domain user accounts, maintaining and troubleshooting Windows 2003 and Windows 2008 servers, Windows XP desktop, Microsoft Office, Microsoft Exchange email, VPN connectivity, network printing, computer hardware, computer imaging, BlackBerry, audio and video editing, large format printing, hard drive wiping, asset tracking and distribution
- Assisted with Windows 7 compatibility testing
Major accomplishment – Managed the transition of all employee’s wireless device from Telus to Rogers and Bell service providers
Software Quality Assurance at Cogsdale October 2008 – October 2010
- Quality Assurance for an in-house custom developed application that is an add-on to Microsoft Dynamics and manages groups of components and resources that are tracked as a unit for accounting purposes
- Application testing encompasses setting up, configuring and troubleshooting accounting systems built with Cogsdale’s multiple custom add-ons, Microsoft Dynamics, MSSQL, Windows Server 2003 and 2008, IIS, Crystal Reports and Microsoft Reporting Services
- Testing responsibilities include reviewing solution designs, creating test plans, testing developers’ code, documenting bugs, retesting bug fixes and finally presenting tested code to designer and/or client for approval
- Also acted as Cogsdale’s website administrator for maintenance updates
Team Lead and Support Analyst at CGI May 2006 – October 2008
VoIP Technical Team Lead
- T2 support is provided to Bell’s employees and encompasses daily support of the intranet and internet applications for 4 main product categories, incident recovery services, ticket management/prioritization, problem management, root cause analysis, solution delivery, testing, processing of client discretionary requests, executing deployments and delivery of client requested project work.
- Many environments were used in the development of the VoIP applications and technologies include UNIX, networking, C#, .NET, IIS, Weblogic, Windows Server 2003, Oracle and MSSQL
Prime Intranet Hosting Centre Support Analyst
- The IHC was created to host intranet websites for Bell’s internal communications
- Supporting the IHC encompasses daily monitoring and support of the hosting environments, incident recovery services, ticket management/prioritization, problem management, root cause analysis and server administration
- The IHC is hosted on 4 servers and technologies used include Domain user accounts, Windows NT, Windows 2000, MSSQL, MS Access, networking, IIS, .NET and Microsoft FrontPage
Major accomplishments – Managed support knowledge transfer for Business IP Voice from CGI Toronto to CGI Stratford, promoted to Technical Team Lead and prime analyst for IHC support
General Manager at Timeless HomePage Design and Bookkeeper at Timeless Technologies Inc. Oct 2005 – Jan 2008
General Manager for Timeless HomePage Design
- Main contact for all client relations including customer service, needs analysis, design/solution approval, rate negotiations, marketing, sourcing of external services and human resources
- Technologies used include DNS management, domain name management, PHP, ASP, Photoshop, MySQL, MS Access, CSS, JavaScript, .NET, Linux, Windows Server 2003, backup management and email management
Bookkeeper for the Timeless Group of Companies
- Performed bookkeeping functions on a part time schedule for all the Timeless Technologies divisions from Oct 2005 – Jan 2008
- Processed all A/R and A/P, prepared all statutory reports and payments and maintained separate accounting records for the 3 major divisions of the Timeless Group of Companies
Major accomplishment – Identified and collected payment from many overdue clients while organizing the accounting records for numerous past years
Owner and Manager at The Jewel Box April 1996 – March 2006
The Jewel Box was a 40 foot long kiosk style jewellery store with 15 staff and $900,000 annual sales
- Manager of all human resources, marketing, purchasing, receiving, technology and customer service responsibilities
- Sourcing suppliers
- Inventory management
- Bookkeeping includes all sales tax and payroll remittance reporting and T2 corporate tax returns
- Qualified to participate in ACOA SEED Capital Program
Major accomplishment – Increased jewellery sales by 45% while simultaneously improving the inventory turnover
Site Auditor at Red Shores Racetrack & Casino - Atlantic Lottery Corporation June 2005 – October 2005
Site Auditor
- Worked as part of the site opening team developing systems and processes to manage all accounting transaction data for the casino, restaurant and Pari-mutuel divisions
Lead Payroll Administrator
- Processed payroll for all onsite staff
- Manage hourly records and verify accuracy for payroll processing
Major accomplishment – Created a Microsoft Access database application to store hours worked calculate, vacation pay, holiday pay and generate reports and data files to process bi-weekly payroll for over 150 employees
Business Administration Mentor (contract) at Holland College December 2003 – June 2004
The Holland College Transitions program is a credit course conceived by Dr Sandy MacMillan targeted at introducing high school seniors to many secondary educational opportunities.
- Participated in the creation of structure of all topics in the program
- Delivered Business Administration content as mentor and instructor
- Documented and evaluated the students’ effort and content effectiveness
Major accomplishment – Prepared exhaustive summary of all content presented and evaluation report with recommendations for the following year
Controller at Allan Weeks Real Estate Company Ltd August 2002 – October 2003
- Administrator and developer for inventory management application built on MySQL and relying on Crystal Reports for output
- Office manager responsible for purchasing supplies, networking, computer desktop support, staff scheduling, bookkeeping and advertising real estate listings
- Advertising and marketing coordination and website administration
Major accomplishment – Identified numerous efficiencies while organizing accounting information and banking records
Education:
Holland College E-Business Programmer Analyst, Business Computer Systems 2004 – 2005
- Technologies studied include project management, database design/administration, networking, Windows Server 2003, internet technologies, PHP, ASP, .NET, JavaScript and Java
- Volunteered instructing technology sessions for high school students enrolled in Junior Achievement
- Created websites for the BISD program, BTG Group, CIPS, The Gold Cup Parade and Island Drafting
- 93% average overall
UPEI Bachelor of Business Administration 1991 – 1995
- Accounting and Business Systems Concentration
- Fourth highest mark overall and Marketing Award for Policy Project – the keystone group project of the BBA program