Successfully worked with the business stakeholders and development team for the Pega Upgrade (launched three months early) and onboarding of ten business units onto Workbench (100+ users)Act as an experienced resource and point of contact for the project team responsible for the onboarding of new business units onto WorkbenchConduct interviews with business users to collect information and elicit business requirements to assist the development team in implementationAnalyze key aspects of business to evaluate factors driving results and prioritized changes with highest business valueUpdate and develop scripts and queries to extract and analyze data from multiple sources and support data-focused initiativesProvide technical support for troubleshooting issues with users

Identify critical bugs in the system and provide developers and infrastructure specialists with requirements and solutions to ensure end user experience. Build test cases for UAT testing of new logic and coordinate with IT and vendors to oversee the development through testing sprints. Build a strong working relationship with business partners, key stakeholders, IT and third party vendors to facilitate receipt and processing of essential data, ensuring accurate information in a timely and effective manner. Represent business interest in relation to applications used within the department with Vendors and the ITSCTroubleshoot end user problem and resolve them through design, development, and implementation of solutions for any issues identified. Established intra-department communication protocols which helped improve turnaround time for problem-solving tasks. Support members the Processing team, reviewing workflows, testing, and data to ensure it best suited business needs.

Performed complex data analysis and investigation on large datasets (millions of rows) with the use of relational databases and reconciliations for multi-million dollar accounts. Performed root cause analysis for data integrity gaps and developed plans to resolve data issues. Researched data management techniques and reporting processes and made recommendations for improvements and customized solutions for data quality initiatives. Coordinated report enhancements, issue resolutions, and modifications for data processing quality. Led initiatives to improve data quality for large unstructured datasets and reduce data turnaround times from weeks to days.Communicated with stakeholders and senior management effectively and consistently to identify drivers, needs, and opportunity for improvement for all business partners. Provided training on SQL and company’s agile ETL development process for junior analysts and supported work distribution based on strengths and capacity in my role as a First Responder for the processing team.

Worked in the Personal Insurance Department (Aon & Portfolio Team) in RSA.Responsible for processing home and auto insurance renewals, flagging inaccuracies, and missing informationResolved queries and re-keyed policies for home and auto insuranceCreated system solutions to manual processes such as policy flagging and amendments for RSA and Western AssuranceProactively for more policy renewal projects and completed them successfully Worked on cross functional teams with underwriters and accounting staff

Worked in the National Logistics Department in RSA and created a database of all insurance brokers in Canada affiliated with RSA and its subsidiaries for the broker contracts issued in 2014Analyzed and interpreted existing data for insurance brokers to identify missing information and anomaliesContacted Business Development Managers across Canada to correct deviations and obtain missing broker dataCreated a database in MS Excel and Access, loading the incoming electronic data files with effective controls and enhancements required to ensure that the data is accurate and accessible for all usersPerformed Broker Changes in Huon (RSA’s database system)- broker amendments, adding and removing brokers from the databasePerformed administrative tasks such as organization, record keeping, and answering any queries from Business Development Managers via phone or email