Business Intelligence Systems Analyst
Resume:
SANDRA ROCA
********@*****.*** 647-***-**** www.linkedin.com/in/rocasandra
QUALIFICATION HIGHLIGHTS
●Data Management, Business Intelligence and Analytics Leader specializing in Insurance, Telecommunication, Retail, Utility and Banking industries with expertise in data management, data reporting and analytics, business intelligence, enterprise cloud technology, artificial intelligence, business strategy, and business process improvement.
●Sandra played key roles in defining business strategy & roadmap and led engagements involving the adoption of Big Data Analytics Platform, Cloud migration, Data Warehouse, Business Intelligence, Artificial Intelligence and Data Engineering solutions.
●Sandra played a key role in programs & projects leading to development and support model for data modeling, data warehouse, data operations, ETL/ELT framework, business intelligence, AI initiatives, cloud technology migration plan, operations analytics and business process improvement initiatives for clients.
●Sandra’s experience includes development of business cases, business requirements & technical specifications, architecture review, solution design for implementation and management of projects for core business groups.
ROLES
Business Solution Architect
BI / DW Solution Architect
BI Manager/Project Manager
Senior Systems Analyst
Senior Business Systems Analyst (BSA)
BI Team Lead
Business Systems Analyst Lead
Business intelligence technical lead
BI Product Owner
PROFESSIONAL EXPERIENCE
Munich Re – Toronto, Business Solutions Architect, Business Strategy & Digital Transformation (Data &AI) 12/2020-to date
●Spearheaded the Azure Data Lake for Canadian Life & Health business optimizing enterprise data assets to enable self-serve analytics and data-driven insights, contributing to business growth.
●Managed data strategies for analytics, business intelligence, and AI/ML projects, ensuring seamless alignment with business objectives and key performance indicators.
●Delivered solutions for effective utilization of enterprise data assets by developing business use cases and building infrastructure for Self-Serve Analytics, Business Intelligence and AI/ML projects.
●Worked on Gen AI (LLM) project for Underwriters as a co-pilot to improve the Under Writing (UW) Processes for case evaluation and selection.
●Worked on transformational initiatives to adopt Cloud landscape for On-Prem Systems, Data warehouse, databases, ETL/ELT pipeline & reporting.
●Worked with Friendly software: OCR, data extraction, handwriting recognition. Led the test planning, design, execution, and defect reporting, ensuring thorough tracking and retesting. Conducted regression, efficiency, accuracy, and performance testing to optimize system functionality and reliability.
●Developed the Generative AI strategy to drive the AI/ML footprint at Munich Re
●Partnered with Regional and Global IT to build future state roadmaps, target operating models, data strategy and processes around data integrity, data automation, advanced analytics
●Developed an enterprise-wide Data Analytics strategy and Roadmap. Managing Business Solutions team to facilitate the deployment of Data Analytics strategy (Data Engineering, Data Warehousing, Business Intelligence and Data Governance).
●Developed analytical cases, managed business requirements & technical specifications, and led projects to completion for Canadian business groups. & US data architecture, data integration, reporting functions, and visualization mechanisms by partnering with various business groups of the company
●Led Business Solution team to define strategic & tactical plans for daily operations of Canadian & US data warehouse.
●Contributed to multiple organizational landscape changes and data transformation initiatives to reduce cost, automation data intake, defining target operating, IT interaction models and Roadmaps.
●Partnered with various Lines of Business to assess current state, performed gap analysis, and created a strategic roadmap for an enhanced analytics future state with focus on finance, corporate actuarial, claims, biometrics research and underwriting.
●Collaborated on developing a business strategy for a Data Marketplace platform for North American business. This included Data Governance, Operating Model for the Data Marketplace, Change Management and technical architecture.
●SQL Server, VSTS, HPQC, Azure, Azure DevOps, PowerBI, Dataiku, Databricks, Friendly, ADF, MS Project, Visio
Telus Health Services– Toronto, Senior BI Business Systems Analyst, BSA Team 03/2020-to 12/2020
●Gathered and documented detailed functional and non-functional requirements and specifications from stakeholders
●Worked closely with Developers and Architects to map logic in the reports and clarify any business rules and logic required for the reports, dashboards and visualizations.
●Completed required documentation – System requirement specification documents (SRS), Business Solution Document (BSD), Business Requirements document (BRD), High Level Solution Estimate documents (HLSE) and others as required on Projects
●Presented to business and technical teams’ solutions all BI Change requests and projects
●Performed data profiling and data analysis of the source data and existing Data systems
●Produced mapping documents for reporting requirements
●Produced complex SQL queries to evaluate data in the BI systems
●Assisted with testing activities
●Liaised between business and technology stakeholders throughout the entire project’s lifecycle
●SQL Server, Oracle, JIRA, Confluence, TFS, SSMS, Visual Studio, Tandem, SSAS, SSMS, Oracle SQL Developer, Strategy Companion, HPQC
Generali Global Health Services (GGHS) – Toronto, BI and EDW Team Lead and Business Systems Analyst, 06/2019-to 03/2020
●Functional management of report developers, overseeing report development and delivery. Assigned work accordingly and kept track of progress to meet business timelines and quality standards.
●Provided subject matter expertise for key BI core functions. Worked on highly complex, cross-functional, and enterprise IT and
business intelligence solutions. Directed, organized and lead the BI reporting workstream.
●Provided guidance, training, and problem-solving assistance to team members. Coached less experienced individuals.
●Gathered and documented detailed functional and non-functional requirements and specifications from stakeholders
●Worked closely with Developers and Architects to map logic in the reports and clarify any business rules and logic required for the reports, dashboards and visualizations.
●Produced mapping documents to map EDW report fields to the relevant database and documented report logic
●Liaised with Business-on-business requirement changes and updates. Documented changes in the Business requirements document.
●Lead and provided directions for the planning, designing, and execution of user testing efforts. Assisted in testing reports and reported on Defects.
●Analyzed testing results to ensure it meets the needs of the business
●Produced deployment plans to move reports and other artifacts to Production.
●Analyze business problems for the Data Management & Applications team.
●Working closely with the business units to create sustainable solutions for the problems.
●Assisted the business and project manager/product owner to resolve change management issues
●Managed business expectations by delivering clear and concise presentations of a proposed solution, data gaps and data quality issues including tradeoffs and alternatives.
●Participated in project QA & UAT to understand changes moving into the production environment
●Developed clear and concise documentation as required.
●Performed data profiling and data analysis of the source data and existing Data warehouse systems
●Identified all stakeholders and established productive and trustful relationships with all stakeholders.
●Experience working in Agile project team, Sprint delivery reviews and daily standup meetings. Collaborate in backlog grooming and Sprint planning. Used Jira and Confluence for team collaboration.
●Microsoft Azure, SSRS, SSIS, SSAS, PowerBI, Visual Studio, SQL Server, SSMS, Acti-sure Policy Management, JIRA, Confluence, UML, BPM.
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/EDW Technical Specialist, 08/2018-04/2019
●Worked on Cognos 10.2 Claim Center Guidewire reports – developed Framework Manager models, packages and Report Studio reports. Created deployment packages in Cognos configuration management.
●Promoted code via GIT, BitBucket and Source tree to manage code versioning, code deployments and defect fixes into higher environments
●Liaised with Business-on-business requirements changes and updates. Documented changes in the Business requirements document.
●Produced mapping documents to map new EDW report fields to the relevant database fields and documented in the Data dictionary
●Produced complex SQL queries to evaluate defect impact on the data in the EDW and reported to management and business.
●Documented Cognos Workbooks for business use on published Cognos reports.
●Conducted Business sessions for report design overview and training of published reports on the portal
●Guidewire Claim Center, Guidewire DataHub and Info Center, SQL Server, SQL, HPQC (HP Quality Center), Cognos Framework Manager, Cognos Report Studio, Bit Bucket, GIT, Source tree, SAP BODS, DB2
Royal & Sun Alliance (RSA) - Toronto, BI Business Systems Analyst Consultant, EDW/Management Information 05/2017-to 08/2018
●Worked on multiple projects of the Management Information team: gathered requirements, identified and documented processes and workflows, provided coordination, responsible for testing, defect management, production support, project implementation tasks and tracked project tasks.
●Integrated Legacy data warehouse and the new data warehouse’s data in multiple online client applications: Broker portal, Client Inquiry and Claims Notification.
●Worked closely with the Solution Architects, Developers and Quality Assurance Analysts in identifying best solutions and uses of technology to drive business growth, requirements and efficiencies.
●Produced mapping documents to map new EDW Claim Center Guidewire fields to legacy fields in order to integrate the data.
●Produced complex SQL queries to create data extracts from the Teradata data warehouse in order to map data.
●Conducted gap analysis for reporting elements on current reports against the new data warehouse.
●Liaised between business and technology stakeholders throughout the entire project’s lifecycles
●Guidewire Claim Center, Teradata, DB2, Seapine, Webfocus, SQL, MicroStrategy, AS400, JIRA, SAS
Toronto Hydro - Toronto, BI Business Analyst Consultant, Engineering Analytics Project 10/2016-05/2017
●Worked on Self-serve implementation of Data warehouse environment: gathered requirements, identified and documented processes and workflows, provided coordination, responsible for standard project documentation, and tracked project tasks.
●Worked closely with the Solution Architect and Developers in identifying best solutions and uses of technology to drive business growth, requirements and efficiencies.
●Performed data profiling and data analysis of the source data and existing Data warehouse systems
●Identified all stakeholders and established productive and trustful relationships with all stakeholders.
●Gathered and documented detailed functional and non-functional requirements from stakeholders
●Documented current and future environment states
●Assisted Project Manager to coordinate project activities. Tracked scope changes and produced weekly status reports
●Liaised with other project areas to coordinate interdependencies and resolved project issues
●Accountable for producing high quality documentation including all Toronto Hydro project management documents, including: PSD (Project Specification Document), SD&S (Systems Design and Support Document), issue tracking document and Decision logs, Current and Future state documentation.
●Participated in Risk, Issue assessment and Lessons learned recording.
●Provided coordination, tracking and reporting on testing as well as defect management
●Tableau, Alteryx, Oracle, DB2, Netezza, SQL Server, HPQC (HP Quality Center)
Northbridge Insurance - Toronto, BI Business Analyst, Business Analysis Team 10/2015-11/2016
●Worked on integration project to ensure Duck Creek source data (policy administration system) would integrate efficiently and seamlessly with Current state reporting systems.
●Worked closely with the Solution and Data Architects in identifying the best solutions and uses of technology to drive business growth, profitability and efficiencies.
●Facilitated the gathering and management of diverse requirements in a Business Intelligence environment with the goal to achieve a common solution.
●Worked closely with Data Architects to ensure the data models fulfill the needs of the business.
●Performed data profiling and data analysis of the source data.
●Assessed the impact of new or changing operational source systems on the Data Warehouse and BI environment.
●Worked with systems analysts, application developers and business analysts to identify options for potential solutions and the impact to systems, while assessing both technical and business suitability.
●Tested system enhancements and products for discrepancies and documented relevant data changes in an accurate and timely manner as required.
●Developed and maintained a knowledge and understanding of company operations/procedures, and insurance industry trends/developments, to enhance the Systems analysis process.
●Liaised between business and technology stakeholders throughout the entire project lifecycle.
●Created Business Requirement Documents (BRD’s), Functional Specification Documents (FSD’s), Solution Alternative documents (SAR’s) as well as weekly status updates and implementation Plans.
●SAS, DB2, SQL Server, SSMS, DQ Analyzer, SQL, Mainframe, JCL, MicroStrategy, Microsoft Team Foundation Server (TFS)
Canadian Tire Corporation - Toronto, BI Solution Architect, Architecture Team 05/2011-09/2015
●Provided technical expertise in all aspects of the Business Intelligence Solution, including infrastructure, ETL (DataStage 8.x) and Front-end artifacts (Cognos 8.x /10.x), on AIX, Linux and Wintel platforms, using Oracle, DB2, SQL Server, big data (Hadoop) and Netezza.
●Ensured scalability, security, availability, integration, maintainability of BI systems
●Involved in implementing and designing an Enterprise Data Warehouse and migration of existing DB2 EDW to Netezza platform
●Experienced working in Agile project teams, Sprint delivery reviews and daily standup meetings.
●Collaborated in backlog grooming and Sprint planning.
●Provided mentorship to junior team members and coached accordingly. Acted as Information management team lead.
●Work with the business in order to understand business requirements and convert them into workable solutions
●Create solution blueprints, design sheets, business requirements documents, risk logs, issue logs, object tracker and other project documentation related to BI solutions on major IM projects as well as small work and pre-projects/assessments
●Provided input into architecture, design, development, infrastructure and process enhancement. Defined custom architecture requirements around solutions as well as articulated strengths and weaknesses associated with alternative solutions.
●Involved in a BI Tool evaluation process that evaluated 8 leading BI tools: QlikTech, IBM Cognos 10, SAP Business Objects, MicroStrategy, SAS, Oracle, Information Builders, Tableau, Jaspersoft and Microsoft
●Served as a consultant and researcher in support of applications development teams, integration teams, and business partners.
●Determines boundaries for the components of an architecture or application.
●Provided input for tactical or strategic plans and solutions.
●Provided advice/input to ensure that clients meet their business objectives.
●Consulted with various project teams to resolve technical difficulties.
●Provided interpretation of data processing policies, practices and technical standards. Used BPM and UML to document process diagrams and data flow diagrams.
●Cognos, Netezza, SQL Server, HPQC, Unix, Hadoop, Oracle, Microsoft BI, JIRA, AS400
Telus Mobility - Scarborough, BI Technology/Solution Architect, Systems for Business Intelligence 09/2008-04/2011
●Provided technical expertise in all aspects of the front-end Business Intelligence Solution, including infrastructure and Front end artifacts (e.g., scalability, security, availability, integration, maintainability)
●Experience with Framework Manager, Report studio, Query studio and Analysis studio.
●Upgraded Cognos platform (series 7.3 and 8.2) to Cognos 8.4 – architecture, installation and migration
●Offered technical and operational assistance and feedback on potential design improvements
●Provided input into architecture, design, development, infrastructure and process enhancement
●Produced all related documentation including framework, methodology, process, diagrams, templates, workshops
●Established and maintained architecture standards and frameworks for application components and provided direction to project teams to ensure compliance
●Mentored and coached junior team members
●Played a leading role and worked with development team, business and vendors in evaluating applications and technologies. Conducted Proof of concept projects for Microsoft BI and MicroStrategy 9
●Liaised with Business users and maintained excellent customer service and relationships
●Cognos, Oracle, MicroStrategy, Control-m, Unix, ClearQuest, Informatica, Microsoft BI, HPQC, SQL Server
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 the migration of existing catalogs, reports and cubes from Cognos Series 7 to Cognos 8
●Managed a Proof of Concept based on two Business Intelligence tools – Cognos ReportNet 1.1 and MicroStrategy 8.
●Created Framework Manager models and packages for the Proof of concept as well as Report Studio reports. Used Query Studio and Analysis studio to develop reports.
●Administered Cognos services on Unix servers, including stopping and starting services and upgrades of all server components.
●Provided impact assessments for new projects
●Produced technical specifications for development of Cognos artifacts
●Provided mentoring to Cognos developers in order to help them progress in their professional development and optimized performance of existing Powerplay cubes
●Involved in DataMart design and ensured that the end user’s requirements could be produced in Powerplay cubes or in the reports
●Interviewed end users to determine and document requirements for reports, data quality and performance
●Was responsible for communication to all of the Data warehousing business users
●Provided the Business with BI development and deployment plans to allow for better analysis of key performance indicators within the corporation.
●Gathered reporting requirements and business rules from users.
●Developed and maintained Impromptu catalogs and reports, as well as Impromptu web reports.
●Developed dimensional and data maps needed to develop Cognos Powerplay cube models.
●Developed and maintained Power Cube models in Cognos Powerplay Transformer.
●Tested delivered systems solutions and monitored systems after implementation to ensure they satisfied requirements.
●Provided on-going support and training to the business on the data warehouse and the new subject areas as they were provided.
●Acted as Impromptu Web Administrator which allowed the clients to schedule and distribute Impromptu reports more efficiently. Conducted Cognos 8 Administration.
●Managed Operational issues for Data Warehouse team. Assigning and following up development progress within the team.
●Experience with scheduling via Control-m, ClearCase for version control of scripts and ClearQuest for Change management.
●Oracle 9i/10 and Unix – Sun Solaris 9/10 as well as AIX platforms.
●Working knowledge of Informatica (ETL) and shell scripting
●Cognos, Oracle, MicroStrategy, Control-m, Unix, ClearQuest, Informatica, Microsoft BI, SQL Server
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/Information Management Specialist 07/2002-10/2003
●Communicated and liaised with clients to identify and define their requirements.
●Evaluated business requests to determine feasibility.
●Designed and built systems, customized it to meet user requirements, including translating system design into program design specifications and developed specifications to resolve programming issues.
●Worked closely with the analysts and business clients to resolve any requirement/specification issues.
●Designed, created & wrote custom reports in both SAS and Cognos for clients.
●Built Catalogs and cubes using Cognos tools/products.
●Working knowledge of DataStage (ETL) and shell scripting
●Provided BI best practices to clients, did extensive data analysis, data extraction and transformation.
●Built, tested and implemented SQL queries for extraction and creation of tables and views (DB2/Unix).
●SAS, Cognos, DB2, Unix
Standard Bank of South Africa – Home Loans, Management Information Systems, BI Project Manager 11/2000-05/2002
●Partnered the Home Loan business unit to ensure that a high quality of service and good relationships were maintained.
●Ensured the business needs are defined and fully understood by all project participants and stakeholders.
●Evaluated the feasibility of the business needs and identify opportunities or alternatives so as to optimize the business requirements.
●Communicated and enforce adherence to Group Architectures and Security Policies
●Monitored project costs and resources, plan and prepare schedules for a range of activities, assign work to team members, monitor progress, and respond to changing priorities.
●Ensured that practices, procedures and principles of project management, as well as project development and life cycle methodologies are enforced.
●Kept abreast of Business Intelligence methodologies, techniques and trends as well as trained the business in the use of Cognos tools/products.
●Participated as well as running workshops during the needs assessment, analysis, design and dimensional data modeling of new systems, as well as enhancements to existing systems.
●Assisted with the on-going business discovery and development, to ensure that business requirements were constantly being met.
●Ensured the maintenance of the metadata repository as well as the data’s conformance to the Data Management standards for the Enterprise
●Led the team to achieve results using matrix management in order to achieve excellent delivery of systems.
●Managed staff and provided guidance. Evaluated job performance and conducted salary reviews and promotions.
●MS Project, DB2, Cognos, Business Objects, Unix, MVS, Easitrieve, SAS, JCL
Standard Bank of South Africa, Enterprise Data Warehouse, Project Managers Team, BI Project Manager/Leader 01/1999-11/2000
●Assisted all the business units to ensure that a high quality of service was delivered and that good relationships were maintained.
●Identified opportunities and recommended suitable solutions for the business’ relevant strategies
●Planned, ran and managed projects and work requests for all of the Bank’s business units.
●Conducted peer reviews of more junior team members as well as mentored and coached them
●Designed Data Marts and the development and implementation thereof for the Enterprise Data Warehouse. Also involved in implementing projects developed with the Cognos suite of products.
●Actively participated in all aspects of the Data Warehouse projects during their life cycle. Prepared documentation through all project development phases.
●Applied and enforced Architectural standards, policies and procedures.
●Maintained and adhered to quality assurance procedures.
●Defined and adhered to budget and schedules. Ensured that projects were developed according to time and cost specifications
●Ensured that project objectives and business requirements are met.
●Assisted the business users in finding the right information/solutions.
●Coded, tested, corrected and maintained procedures relating to the Data Warehouse, Data Marts and applications.
●Adhered to Change Management services and comply to Production standards and procedures.
●Reviewed and documented the Data Warehouse methodologies for the Project Management life cycle.
●Maintained the Commercial Banking data mart and managed all enhancements to this system
●MS Project, DB2, Cognos, Business Objects, Unix, MVS, Easitrieve, SAS, JCL
Standard Bank of South Africa, Enterprise Data Warehouse, Systems Analyst/Developer 03/1993-01/1999
●Programmed (ETL) in SAS, DB2, MVS, JCL, Easytrieve and Easytrieve plus (MVS mainframe platform)
●Developed the Matrix Profitability Analysis System application for Group Finance Division.
●Participated in workshops for all phases of development, this included definition, analysis, construction, implementation and maintenance.
●Maintained the system after implementation in the production phase. Maintained production checklists.
●Was on call out when required to assist in system maintenance after hours.
●Responsible for changes, conversions and problem solving.
●Liaised with all business users to ascertain needs and provide quality service.
●MS Project, DB2, Cognos, Business Objects, Unix, MVS, Easitrieve, SAS, JCL
EDUCATION
University University of the Witwatersrand - BSc (Bachelor of Science)
(1989 – 1992) Computer Science and Mathematics (majors)
2001 Project Management Diploma course – Harold Kerzner Methodologies - School of Project Management, Pretoria, South
2001 Certificate in Management – Graduate Institute of Management and Technology/Henley College
2006 Business Systems Analyst Course (Gathering Business requirements, Use Case Modeling, Workflow Modeling)
2008 Cognos (various)
2009 - 2010 Leadership Now management program (Telus)
2011/2012 Leadership training (Canadian Tire)
2015/2019 Agile Development Course
2015 TOGAF 9
2019 Power BI
2022 Azure fundamentals
2023-2024 Various AI and GenAI LinkedIn courses
2024 Dataiku Green Belt, Yellow belt BPI internal course
2025 DataBricks, ADF
LANGUAGES
English: Native proficiency Portuguese: Native proficiency
French: Limited working proficiency Afrikaans: Full working proficiency
Spanish: Elementary proficiency
Contact this candidate