Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Generic

Pratheesh A Prabhakaran

Oakville,Canada

Summary

Results-oriented BI Architect with 10+ years of experience in data analysis and BI architecture. Expertise in identifying business needs and developing innovative solutions for future-ready BI systems. Proven track record of driving business success through data-driven recommendations.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Business Intelligence Architect

Sunwing Travel Group
Mississauga
11.2022 - Current

Defined architectural standards, design principles, and best practices for scalable and sustainable Business Intelligence (BI) solutions across the enterprise.
Designed end-to-end BI and data architecture including data ingestion, transformation (ETL/ELT), storage, and reporting layers to support analytics and operational efficiency.
Evaluated and recommended modern data platforms and tools (e.g., data warehouses, orchestration platforms) to meet business SLAs, focusing on performance, cost-efficiency, and maintainability.
Led proof-of-concept (POC) initiatives to assess the feasibility and ROI of new technologies, translating results into actionable architectural recommendations aligned with business goals.

Collaborated with cross-functional stakeholders—including business users, engineering, operations, and leadership—to gather requirements and translate them into robust architectural solutions.

Ensured alignment of data and BI architecture with enterprise security, compliance, and cloud architecture standards.

Developed monitoring frameworks and alerting dashboards to provide real-time visibility into data pipeline health and performance, integrating observability and logging into system design.

Provided detailed documentation of data architecture, flows, lineage, and operational dependencies to support system understanding and troubleshooting.

Delivered knowledge transfer and training sessions to support teams for smooth operational handover and maintenance readiness.

Collaborated with DevOps and engineering teams to oversee deployment, testing, and smooth transition of data solutions into production.

Spearheaded the implementation and adoption of Azure Purview to classify, catalog, and manage metadata across enterprise data assets.

Partnered with data governance and compliance teams to define data quality, classification, and metadata policies using Azure Purview.

Established governance domains and structured data products aligned with strategic business priorities to improve data accountability and ownership.

Ensured enterprise data assets, reports, and models were discoverable and accessible via Purview’s data catalog to enhance self-service analytics.

Maintained and enriched business glossaries, promoting standardized terminology and consistent metadata across teams.

Worked closely with data owners and stewards to formalize roles, stewardship responsibilities, and domain ownership.

Actively monitored Azure Purview roadmap and releases to introduce automation and continuous improvements in data governance and metadata workflows.

Lead Engineer – BI Architect

OLAM Information Services
Chennai
08.2017 - 10.2022
  • Design and implement BI architecture for Risk IT team and develop scalable enterprise business intelligence Solutions.
  • Migrate the legacy reporting systems for risk team into BI solutions like Power BI / Tableau in Azure cloud.
  • Design data warehouse for data mining and reporting in MS SQL server and in Azure data lake.
  • Use Azure data factory ETL services to migrate and transform data from on-Prem data base to Azure via pipelines.
  • Design Integrations to the new systems for seamless data transfer to enable ease of business.
  • Support the clients on the technical challenges and resolve them immediately.
  • Used SAP business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  • Developed and Maintained reports in MS SQL reporting services like SSRS and SSAS.
  • Analyzed large amounts of data in data warehouses and created and maintained tables in SQL server and data lake.
  • Experience in creating complex procedures and functions to prepare data for analytics using SQL.
  • Collaborate with BI Developers and Analysts for successful development of BI reporting and analysis solutions.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Translating business requirements into comprehensive functional and technical product specification documents.
  • Work alongside the testing team to develop test cases and use cases to ensure the product readiness and usability.
  • Met with stakeholders to establish favorable business relationships and support mutually beneficial interests as part of Stakeholder Management.
  • Obtain stakeholder approvals of requirements documentation & acting as liaison between business stakeholders, such as management, customers or end users, and the software development or information technology team.

Data Analytics Engineer

GE
Bangalore
07.2016 - 08.2017
  • Company Overview: GE Healthcare
  • Reports using the Cognos and OBIEE and Power BI which adds value to GE Healthcare Business.
  • Understand the User requirements and provide suitable BI solutions.
  • Maintain reports and provide support for user queries and production issues.
  • Deliver smart solution with DevOps faster.
  • Introduced the Huge possibilities of active reports of Cognos BI to the business which was widely accepted and appreciated.
  • Deliver reports on Tableau for BI Users self-service.
  • Acted as liaison between clients and technical associates, translating complex ideas into easy-to-understand explanations.
  • Optimized data sources and processing rules to enhance data quality through design and development phases.
  • Determined data storage and optimization policies, shaping organization efforts to enhance performance.
  • Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
  • Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments.
  • GE Healthcare

Application Developer

IBM INDIA PVT LTD
Bangalore
02.2012 - 06.2016
  • Company Overview: BI
  • Develop Analytical datasets for retails consumer business.
  • Develop Cubes and Reports in IBM Cognos.
  • Migrate from Legacy reports to IBM Cognos.
  • Developed Proof of Concept in IBM Cognos analytics.
  • BI

Education

B. Tech - Information Technology

Anna University
06.2011

Skills

  • Functional Architecture and Design
  • Business Analysis Planning
  • Requirement's life cycle management
  • Strategy Planning
  • Reporting Tools
  • Power BI
  • Tableau
  • Modelling Tools
  • Power BI Desktop
  • Tableau Data Prep
  • ETL Tools
  • Azure ADF/ Synapse
  • Infosphere Datastage
  • Informatica
  • Database
  • Snowflake
  • Azure SQL Server
  • MS SQL Server
  • Oracle
  • Teradata
  • Scripting
  • SQL
  • Python
  • Cloud Environments
  • Microsoft Azure
  • Data architecture
  • ETL processes
  • Azure Purview
  • Data governance

Certification

Certified Business Analysis Professional (CBAP), Simplilearn, 06/01/20

Personal Information

Title: BI Architect

Timeline

Business Intelligence Architect

Sunwing Travel Group
11.2022 - Current

Lead Engineer – BI Architect

OLAM Information Services
08.2017 - 10.2022

Data Analytics Engineer

GE
07.2016 - 08.2017

Application Developer

IBM INDIA PVT LTD
02.2012 - 06.2016

B. Tech - Information Technology

Anna University
Pratheesh A Prabhakaran