Deborah Latter

Team: Commercial Insurance (CI) Enhancements Projects: 1) *New* Risk Services Inspection Control application in ServiceNow 2) Digital Document Delivery for Commercial Property - Broker Extranet 3) Incorporation of Agribusiness into ServiceNow Commercial Case Application Workflows 4) Incorporation of Specialty Lines into ServiceNow Commercial Quote Tool and Transaction Management Application Workflows 5) Operations Enhancements - Application Data Metrics and Workflows 6) *New* Broker Quality Reviews application in ServiceNow 7) Various RPA Enhancements to applications to reduce manual user efforts 8) Integration of custom ServiceNow Extreme Quote tool and OpenText Exstream to create Lead Subscription Declarations Responsibilities: a) Application Screen/Field Design, Mock-ups and Mapping b) Client Liaison: Discovery, UAT and Delivery c) Project User Story, Task, Spike and Decision Requirements Specifications d) JIRA Functionality e) Timeline Management f) Developer, Process Analysis and QA Liaison g) Data Load and Integrity Management h) French Translation and Language Consistency Tracking i) Security, Roles and Entitlements Specifications j) Project Documentation, Knowledge Base Articles, Manuals, Cheat Sheets and Online Guides k) Client Training: Presentation, Demonstration, Client 'Hands-on' Workshops and 'How To' Videos l) Production Support Transition, Handover and Product Warranty Support

Project: Broker BMS Upload Project Project Goal: To allow policy application upload from in-scope Broker BMSs, which would then transform and load into the OneShield policy management system. Responsibilities Include: Creating Project Use Cases (and custom Use Case Template) in Azure DevOps, define requirements and mapping for: Initial Project Requirement, LDAP Set-up for Brokerage Authentication, Policy Viewer (proprietary software for viewing uploaded applications and supplemental information), Automated Quote Assignment to Underwriting in OneShield, Billing and Payment Data Upload Requirements, Auto (ON, AB, QC), Hab, Personal Articles and Watercraft Supplement field mapping (CSIO XML to OneShield), comprehensive Test Strategy: including Unit, Quality Assurance, Integration, User Acceptance, Load, Operational Readiness and Pilot testing strategies, the Training Strategy for both internal (GCNA) and external (Broker) trainees, and the Pilot/Roll-Out Strategy. Also wrote small tools to benefit testing, for example, the License Generator Excel macro. Methodology: Combination of Waterfall and Agile Tools: Azure DevOps, Snipping Tool, Microsoft Office, SharePoint, TEAMS, Skype, Microsoft Windows 10, Microsoft Edge, OneShield, Cisco AnyConnect Secure Mobility, TAM.

Contract Position Working on project Team: COSECO Path to OMNI Channel (CIF/ECM) Project Goal: To convert client, policy and affinity/sponsored group information from the AS400 COSECO system to Cooperator's CIF/ECM PeopleSoft client management system, and Guidewire's PolicyCenter, BillingCenter and ClaimCenter systems. Responsibilities Include: Writing requirements for client and group conversion, creating detailed mock-ups for new and updates to existing screens/pages, creating/updating test cases using JIRA Zephyr, QA testing, creating/updating defects using JIRA, smoke-testing new development/test environments, presenting new and proposed functionality/processes, updating the team knowledge-base intranet website, hosting occasional team events, creating/updating test matrices and sprint planning, participating in scrums, participating in requirements reviews, recording/closing issues, and participating in issues/defects reviews. Methodology: Combination of Waterfall and Agile Tools: ECM (PeopleSoft), CUST (Customer Management), PMSC-Client, Guidewire PolicyCenter, Guidewire BillingCenter, CIF tables, ECM tables, CIF UI, CSU (CIF Support/Maintenance Tools), Service First (Incident Management), JIRA Cloud, JIRA Zephyr, Microsoft Office, Snaggit, GreenShot, SharePoint, OneNote, Skype, Confluence, CISCO IP Communicator (softphone), WebEx, Microsoft Windows 10 Enterprise

Contract Position Working with Broker Policy Administration Systems Data Conversion Team, in an Agile project environment, to map policy data converting from legacy systems (Energie & CICS) into Guidewire PolicyCenter. Responsibilities include: Data Mapping (Target Focus - mapping XML to XML to prepare for data Transformation); mapping fields, entities and typelists using Guidewire model target XML as the foundation for mapping. Conversion Note Mapping, including cross-references between coverages and related conversion notes to highlight conversion-related policy changes to underwriters. Creating user stories in JIRA, completing JIRA assignments, entering policies and test data in Energie, doing policy XML extracts from Energie, updating Confluence, liaising with Business subject matter experts, Deloitte Guidewire consultants, and BSA, development and test teams (both local and offshore). Tools: Microsoft Office 2010: Excel, Word, PowerPoint, Outlook, etc. Skype, Notepad++, Energie (for Personal Property and Auto, and Commercial Auto (IRCA)), Guidewire PolicyCenter (Personal Property, Personal Auto, Commercial Auto), Confluence, JIRA, Guidewire Product Designer

Contract Position Creation of New Quebec Motorcycle Product under GIS Application - New product, plan, requirements and GIS configuration, in Agile project environment for Quebec Motorcycle product release. Responsibilities included: Liaising with decision makers, systems owners, and business users to define business and operations requirements and systems goals, and identify and resolve systems issues. Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow. Prioritize work requests with system owners. Create and execute work release plan. Provide application support on production issues. Meet with business users to gather, analyze and produce the Business Requirements and Functional Requirements Specifications. Conduct the validation and obtain approval of the Business/Functional Requirement Specifications with the business users and system owners. Create systems models, business requirement specifications, diagrams, and charts to provide direction to Application Developers. Coordinate definition of test cases for QA and User Acceptance Testing. Oversee test results. Provide orientation and training, including creation of training material, to business users for all modified and new systems. Document and support the company’s existing business workflow processes; make recommendations for improvements and/or alternatives Collaborate in the planning, design, development, and deployment of new applications, and enhancements to existing applications. Categorize, reproduce and troubleshoot issues using analytical skills and creative thinking. Assign unresolved issues to appropriate resources for further analysis. Track and record fixes for identified/reported issues using JIRA and Service Desk Ticketing application. Schedule and manage in-house system configuration and upgrades.

Sr. Business Systems Analyst | Conversion Systems Integration (CSI) - Auto | CSI - Commercial Contract Position Commercial Quality Assurance Team: Participated in code merge strategy planning/testing for ‘Rating by Peril’ project. Have also done work on validation of Automation Document Solutions, Auto Conversion Maintenance, Data Feeds (Corporate Audit & Common Data Extract), Guidewire PolicyCenter to BillingCenter Integration (also BillingCenter to PolicyCenter) as well as the same for ClaimCenter Integration, and CIF/ECM (PeopleSoft) Integration & Refresh. Also worked with Quality Assurance, preparing for End-to-End (E2E) Commercial product testing in PolicyCenter. Included test strategy planning, statistical risk analysis, end-to-end test case planning/writing, creating test cases, meeting with other test teams to determine test schedules, integration pieces and where E2E policies could be leveraged for other testing, and creating the test condition mapping matrix, as well as performance tracking and status updates. Conversion Systems Integration Team - Auto: Worked with Conversion Systems Integration (CSI) team to ensure accurate conversion of Auto policies from legacy policy management systems (SIGMA, GNA, PMSC) to new PolicyCenter policy management system. Included running conversion jobs, validating conversion results through mapping and requirement specification documents, reporting and retesting for problems found, entering policies to satisfy specific test conditions, reporting and providing statistical analysis. Was moved to Commercial Team once Auto product was ready for ‘go live’ in Pilot Provinces.

Volunteer Position Led the EBC Tech Team's Visual Ministries. Coordinated the 'A Taste of Dundas Crescent' project which resulted in a day-long multi-cultural, community event, where 1500 people were fed and entertained, free of charge, by approx. 100 volunteers.

Contract Position Projects: - AtTask Project & Time Management System Implementation: Project leader. Built and maintained project website. Wrote Requirements, did Development, created test environment and coordinated QM testing. Coordinated release to Production. Provided training materials and user communications. - Lotus Notes Mail to Outlook Mail & Notes Domino Apps. to SharePoint Conversion: Sr. BSA on conversion project team. Built/maintained project website in SharePoint. Incl. site design/layout and security, Project Plan, Team Member info., Project Communication Plan, Project Meeting Agendas, Minutes, Presentations, Email Communications including Distribution Groups & French Translations, Conversion Schedules, Risk Assessment/Lessons Learned, Pilot Information, Applications to Convert, Owner/User Liaisons. In-depth analysis of 700+ Notes applications. Helped CGI write conversion formulae and do QM testing. Liaised with UK Parent Company, CGI, RSA Teams, Training & Communications departments, and Business Units. Coordinated mass training called “Speed Geeking” where 300+ people were trained in Outlook, by 4 trainers, in one day. Wrote training/support documentation. Performed post-conversion support. - Change Control: Developed, implemented and supported Autotrack, a custom SDLC management system to track changes to the HUON policy & claims management system (both mainframe & web). Improved process by 100 person hours/week. Wrote specs for, supported/maintained the Data Migration Database, an application to track and manage Business Management Table data movements. This Lotus Notes based custom application also cross-communicated with mainframe DB2 tables in order to validate data being requested to migrate, and prepared preliminary migration JCL. Completed dev. projects for the following groups: - Strategic Sourcing - National Sales and Distribution - Marketing - Personal Insurance - Quality Assurance - Regional & Central Sales Logistics - Forms Warehouse

Contract Position - Worked on the ‘France Implementation Project’ as an Ingenium Quality Assurance and Unit tester - Posted as a Solcorp onsite Consultant, at SunLife, as a Quality Assurance and Y2K performance tester

Salaried Staff Position IS Project Management & Business Analysis for multiple projects including: Development of custom statistical analysis policy, claims, and other business-related data views for Finance, Marketing and other departments Development of SQL reports as requested by various departments using Management Decision Support (MDS) software Wrote Support Strategies, User Guides, Tutorials & Manuals for all new systems Developed custom courseware for the new Management Information System (MIS) and did a 3-week on-site client training blitz to all GA branches across-Canada. Created a Lotus Notes-based change control and approval system to track changes to Policy Management System (PMS) & MIS Created the MIS Client Newsletter which contained new release ‘how to’ information, tips, tricks, support and regulations information. Also handled cross-Canada distribution.