• Led the development of a web-based tool for mutual insurance member companies to reconcile reported P&C1 data with insurance claim and premium information.• Streamlined quarterly financial reporting for over 35 Mutual Insurance Companies by centralizing data collection with a web-based file management tool, improving efficiency and accuracy.• Conducted in-depth reviews, analysis, and problem-solving to resolve data issues raised by member companies, system vendors, IFRS consultants, and regulatory bodies.• Collaborated with internal and external stakeholders, including OMIA staff, BizXcel programmers, the Insurance Bureau of Canada, CGI, and Farm Mutual Re to achieve common goals.• Created advanced Python scripts and Power Automate flows to automate daily tasks, boosting efficiency and accuracy.• Developed Power BI and Qlik reports, integrated them with SharePoint, and built Power Apps for streamlined data visualization and app-based solutions.• Mentored and trained junior team members to help them grow and contribute to the team's success.

• Developed 15 advanced data trackers in Microsoft Power BI, significantly enhancing data integrity and operational efficiency.• Conducted comprehensive user acceptance testing to align with client needs and uphold stringent data quality standards.

• Collaborated with Recycle BC and MMSW field service team members to address data issues related to WeRecycle portal and SAP Business Warehouse reporting.• Executed comprehensive user acceptance testing plans to ensure the developed application enhancements met the specific requirements of business clients.• Conducted thorough positive, negative, and regression tests to validate the proper functionality of WeRecycle application enhancements.• Identified, reported, and meticulously tracked all application errors using JIRA software.• Delivered valuable feedback and provided timely project status updates to stakeholders within Project Management, Service Provider Reporting, and Development teams.• Ensured the delivery of exceptional service by monitoring incoming calls, maintaining high-quality standards, and efficiently managing WeRecycle collector account setups and modifications.

• Orchestrated the seamless service provider registration and onboarding process, offering comprehensive training and guidance on reporting standards and requirements.• Conducted in-depth trend analysis using SAP Business Warehouse to assess data integrity, uncover valuable insights, and identify opportunities for process improvement.• Fostered collaboration with the Service Provider Reporting manager, Supply Chain Operations, and Field Services teams to swiftly address service provider issues and diligently investigate data discrepancies.• Maintained accurate and up-to-date daily team reports, request for information logs, and meeting agendas, ensuring smooth communication among internal and external stakeholders.• Facilitated accurate and timely payments to service providers by proficiently creating and managing purchase orders within the SAP Material Management System.• Ensured compliance and effective communication with service provider reporting contacts through the creation and management of contract outline agreements within the SAP Material Management System.

• Established effective communication channels with BASF Australia / New Zealand, as well as BASF Canada head office members and sales representatives to gain insights into crucial application data requirements, upcoming enhancements, and troubleshoot data-related concerns.• Orchestrated and chaired weekly scrum meetings, providing context for the upcoming week's work, facilitating discussions on data management challenges, and addressing resource constraints.• Developed and executed complex MS SQL queries to validate client web application data and ensure the quality assurance of routine application enhancements.• Prioritized data-related production issues and seamlessly assigned them to the Development team using JIRA software.• Enhanced data quality assurance techniques through the implementation of comprehensive MS SQL query logic tests, resulting in improved data consistency.• Curated, analyzed, and disseminated BASF Australia / New Zealand retail profile, product profile, and retail hierarchy datasets, guaranteeing the accuracy and integrity of critical data.• Actively contributed to the design and maintenance of multiple service level agreements with BASF Canada, BASF Australia, and BASF New Zealand, fostering strong working relationships and ensuring mutually beneficial outcomes.

• Played an active role in optimizing ad-hoc reporting and quality assurance processes by collaborating closely with developers to identify and address inconsistencies in SQL queries. Additionally, effectively communicated business requirements using JIRA software, ensuring smooth project execution.• Successfully documented business requirements and conducted quality assurance checks on approximately 200 ad-hoc reports, providing valuable support to internal stakeholders for critical client initiatives and informed business decision-making.• Collaborated with Account Managers, Account Supervisors, and Account Executives to gain a deep understanding of ongoing client requests and provided expert data management and technical SQL recommendations.• Introduced and presented the powerful capabilities of Lucidchart, a diagram software and visual studio, to the Data Management team. Additionally, skillfully created data flow diagrams to effectively communicate data governance objectives and promote clarity within the team.

• Conducted comprehensive analytical procedures to evaluate compliance with the Income Tax Act for charitable organizations, small businesses, and medium enterprises, ensuring adherence to tax regulations and identifying areas for improvement.• Meticulously documented audit procedures and meticulously cross-referenced working papers, establishing a streamlined and efficient office audit process that enhanced accuracy and productivity.• Effectively communicated complex tax matters to taxpayers and their representatives, utilizing interpretation bulletins and leveraging precedent-setting tax court judgments to provide clear explanations and guidance.• Collaborated closely with multiple field auditors to reconcile various general ledger accounts and meticulously sampled taxpayer documentation. This meticulous approach enabled the identification of audit risks and facilitated comprehensive and accurate financial assessments.

• Employed advanced SAP tools and leveraged i2 Technologies to efficiently manage the docking and tendering of deliveries, streamlining operations and ensuring timely and accurate processing.• Fostered seamless collaboration with multiple Customer Support Associates, fostering a highly productive team environment that consistently achieved exceptional results.• Effectively engaged with customers and transport carrier representatives, skillfully coordinating appointment times and orchestrating the smooth transfer of large volume stock, enhancing customer satisfaction and optimizing logistics.• Proactively identified and reported capacity constraints for deliveries and pick-ups, playing a pivotal role in mitigating potential disruptions and ensuring efficient operations.• Pioneered the development of a dynamic payload maximization report, leveraging macros to enhance logistical management and swiftly identify underweight or overweight loads, resulting in improved efficiency and cost savings.• Demonstrated meticulous attention to detail by accurately reconciling various general ledger accounts and meticulously sampling taxpayer documentation, facilitating comprehensive risk identification during audits.

• Cultivated and nurtured strong professional relationships with a portfolio of 120 BASF Canada retail accounts, ensuring seamless and accurate fulfillment of financial rewards.• Employed advanced data analysis techniques using Excel Pivot tables and V-lookup to meticulously analyze, organize, and present comprehensive financial rewards summaries to the Account Supervisor and client, providing valuable insights and facilitating informed decision-making.• Conducted rigorous quality assurance checks on retailer and grower sales data, meticulously verifying and validating information to ensure precise and timely financial rewards fulfillment for both retailers and their growers.• Demonstrated exceptional attention to detail and data integrity by promptly identifying and addressing duplicated data entries, including retailer and grower profiles or retailer and grower transactions, effectively eliminating redundancies and enhancing the overall accuracy and reliability of the CRM tool.

• Ensured seamless communication and data synchronization of all meters, guaranteeing accurate billing for customers.• Produced and meticulously organized comprehensive reports to assess the stability and accuracy of the company's electric and water meters, providing valuable insights for efficient resource management.• Demonstrated exceptional attention to detail and precision in billing processes, accurately calculating and invoicing customers based on their usage of water or electricity, while efficiently initializing and managing their accounts.