Project to replace Avantis (CMMS) with an EAMS (Enterprise Asset Management System)Project to replace Accruent FAMIS (Facility Management System) with an IWMS (Integrated Workplace Management System)Project to identify requirements, review market and implement a Shipping Management SystemProject to identify and track hazardous materials through all locations at CNLSustain to 2025: Numerous projects to upgrade applications and /or servers, data migrationSustain to 2025: Various projects to decommission applications at end of life.Upgrade/Replace Active Directory System, Network Access System.Upgrade/ Replace Fire Inspection System.Upgrade/ Replace First Responders Firehouse System.Replace Project Reporting System.

AMANDA Business Analyst (ABA) Certified- City of Winnipeg – Data mapping from legacy system to AMANDA (Oracle) - City of St. Paul, MN – Public Portal - XML and web services; this incorporates Liferay Portal and SmartGuide.- City of Federal Way, WA – Public Portal – AMANDA (Case Management & Process Automation platform for Governments and Regulatory Agencies) Configuration of Permit and Licensing. - State of Iowa – Public Portal – AMANDA Configuration of Permit and Licensing. - City of San Jose, CA – AMANDA – Requirements Definition and QA of Crystal Reports, Portal, etc.- City of Kitchener, ON – AMANDA – Verifying Workflow in Existing system and Upgrade to AMANDA 6

During this permanent BA role, accomplishments included:1. Configure One - ‘Concept’ a Web Based Configurator / Quotation System (BA/PM) o Integration to IBM Power Systems – ETL and Real-time orders via XML and web services.Accomplishment: Internal sales force of 75 users could provide configurations and quotes to customers and fire sales orders to ERP system.2. Provision of Data Extracts for CRA – 2 Fiscal Corporate Year Audits.3. Import of XML Sales Orders from various customers and portals.Accomplishment: XML Sales orders were automatically translated and transmitted to ERP.4. Automatic generation and transmission of special invoices to OSWCA (Ontario Sewer & Watermain Construction Association) members.Accomplishment: Automated process to fulfil Wolseley’s obligation as a member of OSWCA5. Numerous projects with eBusiness and Marketing:• Required Date, etc. added to portal• Wolseley Express / Wolseley360 – online portals• Provision of View, Download and Print Invoices and StatementsOrder Placement and Processing Accomplishment: Portals for customers and staff fully functional.I also worked as Project Manager (as well as BA) for some projects.

This was a part time contract while seeking a position and taking some Business Analyst education. My role was to design and document web services for a new portal. This included creation of functional and technical specifications.

I worked for Samuel for nearly 6 years as a Business and Systems Analyst1. Investigated the market place for a CMMS solution, wrote a report presenting solutions and recommendations to upper management and project sponsors. Accomplishment: the company implemented one of my proposed systems: Proteus.3. Proposed options for procurement solution, arranged demonstrations and presentations (participating in some) of best solutions to upper management and project sponsors, wrote a report presenting short list solutions. Accomplishment: the company implemented one of my proposed systems: Puridiom (SaaS.)5. Evaluated the market place for a replacement for their existing Service Desk Ticketing application (IssueTrak), selected applications that best met requirements, wrote a report to present short list solutions to upper management and project sponsors. At the end of my contract, Samuel were leaning towards one of the proposed solutions; Microsoft System Center Service Manager.6. Created various MS Excel pivot tables and charts to provide visibility of procurement history based on journal entries and GL entries. This was done by importing data from IBM System i DB2 database, using ODBC, and using VLookup and HLookup functions.Accomplishment: company had good visibility to spend analysis by branch, product type, season, category etc. and were able to enforce procurement standards and rules accordingly, resulting in millions of dollars in savings as spend exceeded Million $100 per year on non-metals. 8. Managed and designed a project to facilitate the imaging of payable invoices and supporting documentation for journal entries (promissory notes, AFEs, receipts). Accomplishments:• Considerable savings: No longer did branches have to courier documents to the central office, nor did they need to be stored for 7 years• New functionality: Images of invoices etc. were viewable from IBM System i functions and in the Imaging system; i.e. print, view, email, fax.

This application vendor developed a WMS system (Maestro). This system controlled all aspects of warehouse management, from receiving at the dock to shipping, and included directed picking with barcode scanners and RF guns. My role included programming (RPGILE) and testing in the base and customers' systems, providing project estimates and proposals, base and custom designs, writing specifications, development and implementation at various customer sites. Service desk support for SCM / 3PL; usually remote support. Onsite support for customers.1. Implemented Maestro at West49 warehouse in Burlington. Also designed and built the workflow (including programming and implementation) for shipments (full and partial) from the WMS system (Maestro) to feed to the customer's Unix based system in order for their ASN and invoicing functions. Ongoing support and customization.2. Independently successfully migrated West49 to a new release of Maestro WMS.

Having previously worked contract on Year 2000 compliance issues for them, I returned to Gates to support the company through the transition to Year 2000. After Year 2000, I continued supporting their AS/400 ERP system, and supported the newly implemented WMS (Maestro) system to resolve issues. I also made various enhancements and custom changes for Gates.

Migrated database from legacy system to Microsoft Access. The existing system running on an AS/400 was not Year 2000 complaint, and the decision was to move to a PC network system. The new system was developed in Microsoft Access 97. My function was to convert all necessary data files down to the server and import into Microsoft Access.

My function was to independently test the AS/400 systems for Year 2000 compliance and report to executives. This covered 2 software applications, a financial system (PARA), an in-house RENTAL system that was developed in LANSA and some other functions. My role covered all areas, from setting up a leased AS/400 on TCP/IP, to reporting to management with my findings.• Set up leased AS/400 system from scratch, installed microcode, operating system, setup printers and workstations with TCP/IP on network.• Migrated environment, applications and databases to "test" AS/400 system.• Wrote "aging data" programs and ran aging routines to simulate dates beyond and prior to Year 2000.• Wrote test scripts and followed them using multiple functions, interactive and automated to test results under advanced date scenarios.

This contract was primarily to make the manufacturing applications, end of day / month processes and the MPS function Year 2000 compliant. Also to support and maintain manufacturing systems and support various users. Used Microsoft VISIO to document many of the systems.• Migrated environment, applications and databases to test AS/400 system.• Ran aging routines to simulate dates beyond and prior to Year 2000.• Wrote test scripts and tested multiple functions, interactive and automated to test results under advanced date scenarios.