Ayesha

Data Analyst with 5 years of experience in Canadian banking and insurance, specializing in Power BI, SQL, and financial reporting across large, regulated datasets. Reduced manual reporting effort by 40% and cut dashboard refresh times by 40% at Canadian Western Bank, supporting a $5B+ portfolio used by 200+ stakeholders. Skilled at translating business requirements from Finance and executive teams into accurate, audit-ready dashboards and automated reports.

Data Analyst / BI Developer - Canadian Western Bank - Toronto, ON

(2023-06 - 2026-04)

• Built and maintained Power BI dashboards integrated with Azure DevOps Analytics Views, delivering real-time financial and project visibility across a $5B+ portfolio for 200+ internal users, including Finance and executive stakeholders.
• Automated weekly and monthly reporting with Power BI and advanced Excel, reducing manual reporting effort by 40% and improving the consistency and accuracy of financial outputs.
• Optimized dashboard performance through query folding and data model redesign, cutting report refresh time by 40% and improving reliability for all report consumers.
• Designed SQL and DAX data models to classify CapEx vs. OpEx spend at the Feature and Epic level, enabling accurate budget tracking and supporting audit and compliance reporting.
• Performed daily and monthly financial reconciliations across multiple source systems, identifying and resolving variances to maintain a single source of truth for Finance reporting.
• Prepared and validated financial data for journal entry review, proactively flagging variances to Finance and driving timely resolution of outstanding items.
• Maintained documentation of data models, reconciliation processes, and report logic to support SOX controls, internal audit, and team knowledge transfer.

Data Analyst / Power BI Developer - Sharp Insurance - Remote

(2021-02 - 2023-05)

• Built Tableau and Power BI dashboards tracking policy renewals, claims SLAs, and retention across a 500,000+ policyholder portfolio, contributing to a 5% quarter-over-quarter improvement in customer retention.
• Consolidated data from Azure DevOps, CRM platforms, and policy databases into a unified Power BI reporting layer, giving stakeholders one reliable source for business data.
• Reconciled and validated policyholder data across source systems, identifying discrepancies and ensuring the accuracy of financial and operational reports.
• Created CapEx vs. OpEx financial reporting at the portfolio level, improving budget forecasting accuracy and delivering audit-ready compliance reports.
• Managed exception reporting for unmatched transactions across policy and claims data, partnering with operations teams to resolve outstanding items promptly.
• Analyzed claims and renewal trends and presented findings to marketing and operations, informing customer acquisition and retention strategy.

Post-Graduate Diploma - Business Analytics - Conestoga College

Bachelor of Technology - Computer Science - JNT University