KALPANA GOPALASWAMY
Kitchener
Summary
Data Engineering & BI professional with 5+ years of experience designing scalable ETL/ELT pipelines, cloud-based data architectures, and analytics-ready data assets using PySpark, SQL, Azure Databricks, and visualization platforms. Adept at implementing data quality frameworks, building metadata-driven models, and collaborating with cross-functional teams including data science, product, and business leaders. MBET graduate with foundational AI/ML knowledge and strong critical thinking skills. Experience delivering portfolio performance insights applicable to P&C insurance analytics and enterprise financial reporting. Strong financial services analytics experience with transferable skills for P&C insurance portfolio reporting.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Scientist
TD Bank
09.2024 - Current
- Designed and maintained enterprise dashboards in Tableau, Power BI from Hyperion, HMT, OAS/OAC/OBI integrating financial data for executive insight.
- Developed ETL dataflows with PySpark in Azure Databricks to automate data ingestion and improve processing efficiency by 100%.
- Partnered with Finance and Risk stakeholders to gather requirements and deliver dashboards aligned with data governance standards.
- Managed Tableau and Power BI access controls and security provisioning ensuring compliance with enterprise data management policies.
- Coordinated teams and led Hybrid sprints to deliver BI enhancements within tight timelines.
- Proactively monitored portfolio performance trends, investigating positive and negative variances to support leadership decision-making.
- Delivered executive-level insights through data storytelling and business contextualization of technical outputs.
- Acted as technical business owner for BI initiatives, ensuring solutions met stakeholder requirements.
Data Engineer/BI Reporting Analyst
TD Bank
06.2022 - 08.2024
- Designed and automated enterprise Tableau dashboards for Corporate Expense and FTE reporting used by 3,000+ users.
- Facilitated requirement workshops with finance stakeholders to define KPIs, performance measures, and dashboard layouts, ensuring alignment with business needs and visualization best practices.
- Partnered with data and IT teams to migrate reporting pipelines from Hadoop systems to Azure Databricks, improving scalability and enabling future integration with Enterprise Data Lake.
- Developed data models linking finance, service and vendor data to enable MTD/QTD/YTD performance tracking.
- Developed an automated Tableau dashboard for North American cost center users, enabling monthly and annual analysis of expense transactions through hierarchical KPI tracking, trend visuals, and summary views.
- Designed enterprise KPI frameworks to track corporate performance and operational efficiency.
- Built curated data assets (OBTs) using SQL and PySpark to support downstream analytics consumption.
- Led requirements gathering workshops with business stakeholders to define metrics and success criteria.
- Performed data reconciliation across multiple finance systems to ensure reporting accuracy.
Data Analyst
TD Bank
10.2021 - 04.2022
- Delivered regulatory and operational reports from OEBS and Excel automation supporting month-end closing.
- Identified operational problems and escalated issues when needed to management.
- Enhanced reporting processes and validation framework reducing SLA violations by 20%.
- Evaluated programs, corrected errors and made necessary modifications in Host systems.
- Collaborated with teams to prioritize data maintenance defects and process improvements.
Data Analyst
Instacart
04.2020 - 08.2021
- Developed SQL insights supporting dynamic pricing algorithms and customer segmentation.
- Automated KPI dashboards in Tableau and Python (Pandas) for real-time product and operations tracking.
- Constructed and published periodic reports, as well as any necessary and hoc reports.
- Implemented ETL validation and data reconciliation for high volume transaction datasets.
- Performed Data analysis, data quality, data governance and data profiling on complex data sources to identify any anomalies that may exist.
Education
Master of Business, Entrepreneurship & Technology - MBET
University of Waterloo
Waterloo01.2024
Insurance regulatory knowledge and client advisory fundamentals - undefined
Registered Insurance Brokers of Ontario (RIBO)
01.2021
Advanced Diploma - Data Science & Applications
Metro College of Technology
Toronto01.2019
B.E. (Hons.) - Electronics & Instrumentation Engineering
BITS Pilani, Dubai Campus
01.2008
Skills
- Data Engineering: PySpark, SQL, Delta Lake, ETL/ELT Automation, Azure Databricks
- Cloud Platforms: Azure (ADLS, Synapse), CI/CD Deployment
- Data Architecture: Structured & Semi-structured Data, Data Modeling, Data Integration, Data Transformation, Governance, Metadata
- Data Quality: Validation, Profiling, Reconciliation, Audit Frameworks
- Analytics Enablement: Power BI, Tableau, Oracle Analytics, Alteryx, Excel Analytics, KPI Tracking & Portfolio Monitoring, Executive Reporting & Data Storytelling
- ML Foundations: Python, Pandas, Scikit-learn, MLlib
- GenAI Tools: ChatGPT, Microsoft Copilot
- Project Management: Agile and Traditional Frameworks, JIRA, Confluence, SharePoint
- Soft Skills: Business Requirement Elicitation, Stakeholder Management, Facilitation, Cross-Functional Collaboration, Analytical Thinking, Leadership, Problem Solving, Adaptability, Strategic Decision Support
- Azure (Databricks, ADLS, Synapse)
- PySpark
- SQL
- Hive
- Impala
- Power BI
- Tableau
- Alteryx
- Power Pivot
- Power Query
- Power Apps
- GitHub
- APIs
Websites
Accomplishments
- Engineered PySpark and Azure Databricks pipelines reduced manual work by 80%.
- Built BI dashboards featured in Viz competitions for innovation and data storytelling.
- Key contributor in TD's migration from on-prem Hadoop to Azure using CI/CD.
- Strengthened data accuracy through automated validation and reconciliation frameworks.
- Delivered portfolio performance dashboards enabling leadership to track trends, risks, and opportunities.
Certification
- Tableau Desktop Specialist
- Power BI Data Analyst Associate (in progress)
- RIBO License
Technical Tools
- Azure (Databricks, ADLS, Synapse)
- PySpark
- SQL
- Hive
- Impala
- Power BI
- Tableau
- Alteryx
- Power Pivot
- Power Query
- Power Apps
- GitHub
- APIs
Languages
Tamil
Native or Bilingual
English
Full Professional
Hindi
Professional Working
French
Elementary
Timeline
Data Scientist
TD Bank
09.2024 - Current
Data Engineer/BI Reporting Analyst
TD Bank
06.2022 - 08.2024
Data Analyst
TD Bank
10.2021 - 04.2022
Data Analyst
Instacart
04.2020 - 08.2021
Insurance regulatory knowledge and client advisory fundamentals - undefined
Registered Insurance Brokers of Ontario (RIBO)
Advanced Diploma - Data Science & Applications
Metro College of Technology
B.E. (Hons.) - Electronics & Instrumentation Engineering
BITS Pilani, Dubai Campus
Master of Business, Entrepreneurship & Technology - MBET
University of Waterloo