Looking for a job

Sugan Sathi

@sugansathi

Senior Cognos Consultant at Canada Life who migrated enterprise financial and operational reports from Cognos 10 to Cognos Analytics 11.

Canada

Message

At Canada Life, I worked on migrating enterprise financial and operational reporting from IBM Cognos 10 to Cognos Analytics 11. I developed and enhanced reports and dashboards for finance and insurance reporting, and supported deployments, testing, and production fixes.

Across consulting engagements, I’ve developed Cognos reports, models, dashboards, and TM1 applications for financial services, healthcare, and other organizations. I’ve also migrated Cognos reporting to Power BI, supported Cognos environments, and trained users on Cognos Analytics.

Experience

Work history, roles, and key accomplishments

Senior Cognos Consultant

Canada Life

Jan 2026 - Sep 2026 (8 months)

Designed, developed, and enhanced IBM Cognos financial reports and dashboards supporting Premium Revenue, Claims Analysis, Policy Profitability, Loss Ratio, Expense Analysis, and Regulatory Reporting for Finance and Insurance business units. Collaborated with stakeholders to gather reporting requirements and deliver accurate reports for budgeting, forecasting, month-end close, and management repor

IBM Cognos Framework Manager Report Studio Dashboarding Jira DB2 Oracle 11g

Senior Cognos Consultant

IGM

Nov 2023 - Dec 2025 (2 years 1 month)

Created new impromptu reports and enhanced existing reports as per user requirements. Ran monthly and quarterly reports for ad hoc users via the ticketing system and provided RCA for data extract issues.

PowerPlay Transformer 7.4 Power Play Enterprise Server Impromptu IWR Oracle 11g ServiceNow

Senior Cognos Consultant

Ontario Ministry of Health and Long Term Care (HSC)

Jun 2022 - Jul 2023 (1 year 1 month)

Migrated reports and dashboards from Cognos to Power BI. Analyzed and identified existing Cognos models and reports, and used Power BI Query Editor for data transformation and DAX for calculations.

Power BI Desktop DAX IBM Cognos Analytics BI Query Admin DB2

Senior Cognos Consultant

Ministry of Community and Social Services

Aug 2021 - Feb 2022 (6 months)

Developed new Cognos Analytics reports based on DISCIS data and enhanced existing reports. Created new fact tables in the reporting schema based on ETL scripts utilizing materialized views.

IBM Cognos Framework Manager Report Studio Dashboarding DISCIS Azure DevOps GitHub Oracle 11g

Senior Cognos Consultant

Canadian Nuclear Laboratories (CNL)

Jul 2020 - Jun 2021 (11 months)

Created views specifically to meet reporting requirements. Unit tested reports and helped the testing team with Cognos questions, and fixed production bugs.

IBM Cognos Analytics Power BI DAX SQL Server 2017 Azure SSIS SSRS Oracle 11g

Senior Cognos Consultant

North York General Hospital

Jun 2017 - Oct 2017 (4 months)

Migrated existing Metric Studio Dashboard to Dashboard based on Workspace using Cognos Rave Visualization. Built backend tables and views in DB2 to support reporting needs.

IBM Cognos Cognos Rave Visualization DB2

Senior Cognos Consultant

Ontario Ministry of Health and Long Term Care (DHSI)

Apr 2016 - Mar 2017 (11 months)

Created and enhanced PEAR standard reports using Cognos Version 10. Created over 20 reports and dashboards using Report Studio, and ensured compliance with GO-ITS standards.

IBM Cognos Crystal Reports Oracle SQL Developer IBM Panorama

Senior BI Consultant

CIBC

Jan 2016 - Mar 2016 (2 months)

Migrated existing Salesforce and TIBCO Spotfire reports into Cognos reports. Worked on Framework Manager modeling to support report development and provided RCA for production issues.

IBM Cognos TM1 IBM Cognos TIBCO Spotfire Salesforce

TM1 Developer

Northern Trust Bank

Oct 2011 - May 2015 (3 years 7 months)

Administered the Cognos TM1 reporting environment including security, upgrades, content storage and usage. Designed, developed, and implemented Cognos TM1 Applications to forecast portfolio revenues.

TM1 Report Studio Analysis For Excel Lifecycle Management Go Office Oracle 11g

Sr. Cognos Developer

Acxiom

Nov 2010 - Sep 2011 (10 months)

Implemented security blueprint for the Cognos environment and developed 30 Cognos reports. Worked on migrating Cognos 8.4 reports to Cognos 10.1.

Cognos Framework Manager Business Insights Business Insight Advanced Report Studio Query Studio Impromptu PowerPlay Transformers Upfront Access Management SQL Server Oracle 11g PL SQL Developer

Sr. Cognos Developer

Hines Horticulture, Inc.

May 2010 - Oct 2010 (5 months)

Responsible for daily monitoring of cube builds and troubleshooting failures. Created reports and cubes on Inventory on Hands, Shipped and Sold calculations.

Cognos ReportNet Framework Manager Oracle 10g Toad 7.4 PowerPlay Transformer Cognos Administration Cognos Configuration

Sr. Cognos Developer

CCi

Feb 2008 - Apr 2010 (2 years 2 months)

Upgraded Cognos 8.2 reports to Cognos 8.4 and tested all reports in the new environment. Loaded big data (30-40 TB) into the BIS system from multiple data sources.

Cognos Framework Manager Windows NT Pl SQL Erwin Informatica PowerCenter Oracle 10g

BI Team Lead

DIRECTV

Feb 2007 - Jan 2008 (11 months)

Worked on different projects involving requirement gathering, project planning, and creating Power Play Cubes, Multidimensional Power Play Reports, and Cognos 8 Framework Manager Packages.

Cognos ReportNet PowerPlay Power Play Enterprise Server Framework Manager Informatica PowerCenter Unix Windows NT Oracle 9i

Senior Cognos Developer

Travelers

Jun 2005 - Jan 2007 (1 year 7 months)

Studied the existing CRN environment and drafted the Design Document for the Sales Analytics project. Built Framework Manager Model and established cardinalities to suit business needs.