Business Intelligence Data Management
Resume:
SANDRA ROCA
********@*****.*** 647-***-**** www.linkedin.com/in/rocasandra
QUALIFICATION HIGHLIGHTS
Data Management, Business Intelligence, and Business Analysis Leader with expertise in Insurance, Telecommunication, Retail, Utility, and Banking industries. Skilled in data management, reporting and analytics, business intelligence, enterprise cloud technology, artificial intelligence, project management, business strategy, and business process improvement.
KEY SKILLS
●Data Management: Expert in managing and optimizing data assets, ensuring data integrity and accessibility for business insights.
●Business Intelligence: Skilled in developing and implementing BI solutions that enhance decision-making and operational efficiency.
●Business Analysis: Proficient in business analysis, identifying business needs, analyzing processes, and delivering data-driven solutions to drive strategic decision-making and improvements.
●Enterprise Cloud Technology: Experienced in leading cloud migration initiatives, transforming on-prem systems to cloud-based solutions for improved scalability and efficiency.
●Artificial Intelligence: Developed AI strategies and solutions, including Generative AI, to enhance business processes and decision-making.
●Business Strategy: Played key roles in defining business strategy and roadmap, aligning data initiatives with organizational goals.
●Business Process Improvement: Led projects to streamline and improve business processes, reducing costs and increasing efficiency.
●Project Management: Managed complex projects from inception to completion, ensuring timely delivery and alignment with business objectives.
●Stakeholder Collaboration: Partnered with various business units and IT teams to develop strategic roadmaps and implement data solutions.
●Technical Documentation: Produced comprehensive technical specifications and business requirements, facilitating clear communication and project execution.
TOP ACCOMPLISHMENTS
1.Spearheaded Azure Data Lake for Canadian Life & Health business, optimizing enterprise data assets for self-serve analytics and data-driven insights, contributing to business growth.
2.Developed Generative AI Strategy to drive AI/ML footprint at Munich Re, enhancing underwriting processes and case evaluation.
3.Led Cloud Migration Initiatives for On-Prem Systems, Data Warehouse, databases, ETL/ELT pipeline, and reporting, transforming the data landscape.
4.Partnered with Regional and Global IT to build future state roadmaps, target operating models, data strategy, and processes around data integrity, automation, and advanced analytics.
PROFESSIONAL EXPERIENCE
Enercare – Markham, Scrum master and Business Systems Analyst, IT 04/2025-current
●Reported Project Progress: Provided regular, clear updates on project progress to stakeholders, ensuring transparency and alignment across teams.
●Analyzed Business Processes: Identified operational inefficiencies, streamlined workflows, and recommended system enhancements to boost service delivery and reduce manual effort.
●Documented Business Requirements: Produced detailed user stories, process flows, and functional documentation to guide the development and testing lifecycle.
●Enabled Data-Driven Decisions: Extracted and analyzed data using SQL and Excel to track KPIs and support strategic planning and operational improvements.
●Facilitated Agile Ceremonies: Led daily stand-ups, sprint planning, and retrospectives as Scrum Master, promoting team collaboration and Agile best practices.
●Led Service Optimization Projects: Delivered process improvement initiatives, improving efficiency and customer satisfaction.
●Supported Digital Transformation: Guided Agile teams in delivering innovative technology solutions that enhanced both customer experience and internal operations.
●Delivered Analytics Solutions: Enabled cross-functional teams to leverage analytics tools and techniques for better decision-making and operational performance.
●Led Testing Initiatives: Directed system testing activities, including development of test cases, defect tracking, and coordination of user acceptance testing (UAT).
●Drove Cross-Functional Collaboration: Partnered with business stakeholders to translate requirements into technical solutions aligned with business goals.
●Championed Continuous Improvement: Promoted scalable, sustainable enhancements across business systems through continuous process review and feedback.
Munich Re – Toronto, Business Solutions Architect, Business Strategy & Digital Transformation (Data &AI) 12/2020-02/2025
●Spearheaded Azure Data Lake: Optimized enterprise data assets for Canadian Life & Health business, enabling self-serve analytics and data-driven insights.
●Managed Data Strategies: Oversaw analytics, business intelligence, and AI/ML projects, ensuring alignment with business objectives and KPIs.
●Developed Generative AI Strategy: Enhanced underwriting processes and case evaluation, driving AI/ML footprint.
●Led Cloud Migration Initiatives: Transformed the data landscape for On-Prem Systems, Data Warehouse, databases, ETL/ELT pipeline, and reporting.
●Partnered with Regional and Global IT: Built future state roadmaps, target operating models, data strategy, and processes around data integrity, automation, and advanced analytics.
●Developed Enterprise-wide Data Analytics Strategy: Managed Business Solutions team to deploy Data Analytics strategy, including Data Engineering, Data Warehousing, Business Intelligence, and Data Governance.
●Led Projects to Completion: Managed business requirements and technical specifications for business groups, ensuring successful project delivery.
●Contributed to Organizational Changes: Implemented data transformation initiatives to reduce costs and automate data intake.
●Assessed Current State and Created Strategic Roadmap: Partnered with various Lines of Business to perform gap analysis and create a roadmap for enhanced analytics future state.
●Collaborated on Data Marketplace Strategy: Developed business strategy for Data Marketplace platform for North American business, including Data Governance, Operating Model, Change Management, and technical architecture.
Telus Health Services– Toronto, Senior BI Business Systems Analyst, BSA Team 03/2020-to 12/2020
●Requirements Gathering: Collected and documented functional and non-functional requirements from stakeholders.
●Collaboration with Developers & Architects: Mapped logic for reports, dashboards, and visualizations, clarifying business rules.
●Project Documentation: Created SRS, BSD, BRD, HLSE, and other necessary project documents.
●Solution Presentation: Presented BI change requests and project solutions to business and technical teams.
●Data Profiling & Analysis: Examined source data and existing data systems for insights and accuracy.
●Mapping Documentation: Developed detailed mapping documents for reporting requirements.
●SQL Queries: Produced complex SQL queries to evaluate and validate BI system data.
●Testing: Assisted in testing activities to ensure data integrity and system functionality.
●Stakeholder Liaison: Facilitated communication between business and technology teams throughout the project lifecycle.
Generali Global Health Services (GGHS) – Toronto, BI and EDW Team Lead and Business Systems Analyst, 06/2019-to 03/2020
●Managed Report Development: Oversaw report developers, ensuring timely and quality delivery, meeting business timelines and standards. Provided subject matter expertise for BI core functions, leading complex, cross-functional BI solutions, and enhancing strategic decision-making.
●Guided Team Members: Trained and coached team members, improving performance and skills. Offered guidance, training, and problem-solving assistance.
●Gathered and Documented Requirements: Collected detailed functional and non-functional requirements from stakeholders, ensuring project accuracy. Managed requirement changes, ensuring alignment with business needs.
●Collaborated on Report Logic: Worked with developers and architects to ensure accurate report logic and business rules. Produced mapping documents to streamline data integration and reporting processes.
●Led User Testing: Directed planning, designing, and execution of user testing efforts, ensuring reports met business needs. Analyzed testing results to ensure accuracy and effectiveness of BI solutions.
●Developed Deployment Plans: Created plans for moving reports and other artifacts to production, ensuring smooth transitions.
●Analyzed Business Problems: Worked closely with business units to create sustainable solutions, improving operational efficiency. Assisted in resolving change management issues and facilitated smooth project transitions.
●Managed Expectations: Delivered clear presentations of proposed solutions, data gaps, and quality issues, ensuring stakeholder alignment. Participated in QA & UAT to understand changes moving into production.
●Performed Data Profiling: Analyzed source data and existing data warehouse systems, improving data quality and utilization.
●Established Relationships: Built productive stakeholder relationships, ensuring effective communication and collaboration.
●Worked in Agile Teams: Participated in Agile project teams, sprint planning, backlog grooming, and daily standup meetings, ensuring efficient project execution and delivery.
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/EDW Technical Specialist, 08/2018-04/2019
●Developed Cognos 10.2 Claim Center Guidewire reports, including Framework Manager models, packages, and Report Studio reports.
●Created deployment packages in Cognos configuration management.
●Managed code versioning and deployments using GIT, BitBucket, and SourceTree.
●Liaised with business teams, documenting requirement changes in the Business Requirements Document (BRD).
●Developed mapping documents to align new EDW report fields with database fields in the Data Dictionary.
●Wrote complex SQL queries to assess defect impact on EDW data and reported findings to management.
●Documented Cognos Workbooks for business users on published reports.
●Conducted business sessions and training on report design and usage of published reports.
Royal & Sun Alliance (RSA) - Toronto, BI Business Systems Analyst Consultant, EDW/Management Information 05/2017-to 08/2018
●Managed report development team, overseeing delivery, progress tracking, and business alignment.
●Led BI reporting workstreams, providing expertise in cross-functional enterprise solutions.
●Gathered and documented business requirements, collaborating with developers and architects.
●Developed mapping documents to align report fields with databases and business logic.
●Led user testing efforts, including planning, execution, and defect resolution.
●Created deployment plans and managed production rollouts.
●Analyzed business problems, delivering sustainable data management solutions.
●Facilitated change management, resolving business and project issues effectively.
●Managed stakeholder expectations, addressing data gaps and quality concerns.
●Worked in Agile environments, contributing to QA, UAT, backlog grooming, and sprint planning.
●Performed data profiling and analysis, optimizing data warehouse systems.
●Utilized Jira and Confluence for Agile collaboration and project tracking.
Toronto Hydro - Toronto, BI Business Analyst Consultant, Engineering Analytics Project 10/2016-05/2017
●Led self-serve Data Warehouse implementation, gathering requirements, documenting workflows, and tracking project tasks.
●Collaborated with Solution Architects and Developers to identify optimal technology solutions for business growth.
●Performed data profiling and analysis of source data and existing Data Warehouse systems.
●Established strong stakeholder relationships, ensuring alignment and trust.
●Gathered and documented functional & non-functional requirements from stakeholders.
●Documented current and future environment states to support project planning.
●Assisted Project Manager in coordinating activities, tracking scope changes, and producing status reports.
●Liaised with cross-functional teams, resolving interdependencies and project issues.
●Produced high-quality project documentation, including PSD, SD&S, issue tracking, and decision logs.
●Participated in risk assessments, issue resolution, and lessons learned sessions.
●Coordinated testing efforts, tracking and reporting defects for resolution.
Northbridge Insurance - Toronto, BI Business Analyst, Business Analysis Team 10/2015-11/2016
●Led integration project to ensure seamless data flow between Duck Creek policy administration system and reporting systems.
●Collaborated with Solution and Data Architects to identify technology solutions that drive business growth and efficiency.
●Facilitated requirement gathering and management in a Business Intelligence environment to achieve a unified solution.
●Worked with Data Architects to ensure data models met business needs.
●Performed data profiling and analysis on source data to assess its suitability for BI.
●Assessed impact of operational system changes on the Data Warehouse and BI environment.
●Collaborated with systems analysts, developers, and business analysts to explore solutions and assess technical/business impact.
●Tested system enhancements, documenting data changes and discrepancies accurately and promptly.
●Maintained knowledge of company operations and insurance industry trends to improve system analysis processes.
●Liaised between business and technical stakeholders throughout the project lifecycle.
●Created key project documentation, including BRDs, FSDs, SARs, status updates, and implementation plans.
Canadian Tire Corporation - Toronto, BI Solution Architect, Architecture Team 05/2011-09/2015
●Provided technical expertise in BI solutions, including infrastructure, ETL (DataStage), and front-end artifacts (Cognos) on AIX, Linux, Wintel, and multiple databases (Oracle, DB2, SQL Server, Hadoop, Netezza).
●Ensured scalability, security, and integration of BI systems, maintaining high availability and performance.
●Led the design and implementation of an Enterprise Data Warehouse and migration from DB2 to Netezza.
●Worked in Agile teams, contributing to sprint reviews, planning, and backlog grooming.
●Mentored junior team members and led the Information Management team.
●Translated business requirements into workable BI solutions, creating solution blueprints and project documentation (BRDs, risk logs, issue logs).
●Provided architecture, design, and development input, including evaluating BI tools like QlikTech, Cognos, SAP, and Tableau.
●Consulted with development, integration, and business teams, resolving technical issues and advising on strategic plans.
●Interpreted data processing policies and ensured clients met business objectives through tailored solutions.
Telus Mobility - Scarborough, BI Technology/Solution Architect, Systems for Business Intelligence 09/2008-04/2011
●Provided technical expertise in front-end Business Intelligence solutions, including infrastructure and key features (scalability, security, availability, integration).
●Worked with Cognos tools such as Framework Manager, Report Studio, Query Studio, and Analysis Studio.
●Upgraded Cognos platforms from version 7.3/8.2 to 8.4, handling architecture, installation, and migration.
●Provided design improvements, technical and operational feedback for continuous system enhancements.
●Produced documentation related to frameworks, methodologies, processes, and templates.
●Established and maintained architecture standards, ensuring compliance and providing guidance to project teams.
●Mentored junior team members and coached them on best practices.
●Led evaluations of applications and technologies, including Proof of Concept projects for Microsoft BI and MicroStrategy 9.
●Liaised with business users, fostering strong customer relationships and providing excellent service.
Telus Mobility - Scarborough, Sr. Systems Analyst, Systems for Business Intelligence 10/2003-09/2008
●Installed, configured, and tested Cognos 8 on Unix Sun Solaris and AIX servers.
●Led migration of catalogs, reports, and cubes from Cognos Series 7 to Cognos 8.
●Managed Proof of Concept for Cognos ReportNet 1.1 and MicroStrategy 8, creating Framework Manager models, packages, and reports.
●Administered Cognos services on Unix servers, including system upgrades and service management.
●Produced impact assessments for new projects and technical specifications for Cognos artifacts.
●Mentored Cognos developers to optimize Powerplay cubes and improve performance.
●Designed DataMarts, ensuring end-user requirements were met in reports and Powerplay cubes.
●Gathered reporting requirements and business rules, translating them into Cognos solutions.
●Developed and maintained Impromptu catalogs and web reports for business users.
●Built and maintained Power Cube models in Cognos Powerplay Transformer.
●Tested systems solutions and provided ongoing support and training to ensure business requirements were met.
●Managed operational issues and development progress within the Data Warehouse team.
●Experienced with scheduling tools (Control-m), version control (ClearCase), and change management (ClearQuest).
●Worked with Oracle 9i/10, Unix (Sun Solaris, AIX), and Informatica (ETL) for data integration.
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/Information Management Specialist 07/2002-10/2003
●Liaised with clients to identify and define requirements.
●Evaluated business requests for feasibility and alignment.
●Designed and built systems, translating design into specifications and resolving programming issues.
●Collaborated with analysts and business clients to resolve requirements/specification issues.
●Developed custom reports in SAS and Cognos for clients.
●Built Catalogs and cubes using Cognos tools/products.
●Utilized DataStage (ETL) and shell scripting for data processing.
●Provided BI best practices, conducting data analysis, extraction, and transformation.
●Built, tested, and implemented SQL queries for data extraction and table/view creation (DB2/Unix).
Standard Bank of South Africa – Home Loans, Management Information Systems, BI Project Manager 11/2000-05/2002
●Partnered with the Home Loan business unit to maintain high service quality and strong relationships.
●Ensured business needs were clearly defined and understood by all project participants and stakeholders.
●Evaluated feasibility of business needs, identifying opportunities to optimize requirements.
●Enforced adherence to Group Architectures and Security Policies.
●Monitored project costs, resources, and schedules, assigning work and responding to changing priorities.
●Enforced project management practices, methodologies, and life cycle procedures.
●Kept up to date with Business Intelligence trends and trained business users on Cognos tools/products.
●Led workshops during needs assessment, design, and dimensional data modeling phases of new and enhanced systems.
●Assisted with ongoing business discovery to ensure consistent alignment with business requirements.
●Ensured metadata repository maintenance and conformance to Data Management standards.
●Led the team using matrix management, driving excellent system delivery results.
●Managed staff, evaluated job performance, and conducted salary reviews/promotions.
Standard Bank of South Africa, Enterprise Data Warehouse, Project Managers Team, BI Project Manager/Leader 01/1999-11/2000
●Provided high-quality service to business units and maintained strong relationships.
●Identified business opportunities and recommended solutions aligned with strategies.
●Planned and managed projects for all business units, ensuring timely delivery.
●Mentored and conducted peer reviews for junior team members.
●Designed and implemented Data Marts for the Enterprise Data Warehouse, including Cognos suite projects.
●Contributed to all phases of Data Warehouse projects, preparing documentation throughout the lifecycle.
●Enforced architectural standards and quality assurance procedures.
●Managed project budgets and schedules, ensuring adherence to timelines and cost specifications.
●Assisted business users in finding the right data and solutions.
●Coded, tested, and maintained procedures for the Data Warehouse and Data Marts.
●Complied with Change Management services and production standards.
●Documented Data Warehouse methodologies for the Project Management life cycle.
●Maintained and enhanced the Commercial Banking data mart.
EDUCATION
1989 – 1992 University of the Witwatersrand, BSc - Computer Science and Mathematics (majors)
2001 Project Management Diploma course – Harold Kerzner Methodologies - School of Project Management, South Africa
2001 Certificate in Management – Graduate Institute of Management and Technology/Henley College
Professional Development
2006 Business Systems Analyst Course: Gathering Business requirements, Use Case Modeling, Workflow Modeling
2008 Cognos: All tools
2009 - 2010 Leadership Now management program (Telus)
2011 - 2012 Leadership training (Canadian Tire)
2015/2019 Agile Development Course
2015 TOGAF 9
2019 Microsoft Power BI
2022 Azure and cloud fundamentals
2023-2024 Various AI and GenAI LinkedIn courses
2023 Yellow belt BPI (business process improvement) course
2024 Dataiku Green Belt
2025 Data Bricks, ADF
LANGUAGES
English: Native proficiency Portuguese: Native proficiency
French: Limited working proficiency Afrikaans: Full working proficiency
Spanish: Elementary proficiency
Contact this candidate