TA

Tanu Arora

Ouvert aux possibilités

Data and Reporting Analyst

Toronto, ON

City of Hamilton
GEORGE BROWN COLLEGE

À propos

Data and BI professional with 3+ years of hands-on experience building end-to-end data and analytics solutions using Python, PySpark, SQL, Databricks, Microsoft Fabric, and Azure technologies. Experienced in developing ETL/ELT pipelines, integrating data from multiple enterprise systems, transforming and validating data, and building scalable analytical datasets for reporting and decision-making. Strong background in data engineering, cloud data platforms, data modeling, ERP and financial reporting, and Power BI. Experienced in troubleshooting data issues, improving pipeline reliability, supporting CI/CD and deployment processes, and working with technical and business stakeholders to deliver production-ready solutions.

Compétences

  • Accuracy
  • adaptability
  • Agile
  • Souci du détail
  • Tests automatisés
  • Analyse d’affaires
  • Change Management
  • CI/CD
  • Claude
  • Communication
  • Critical Thinking
  • Cross-Functional Collaboration
  • Analyse de données
  • data management
  • Data Validation
  • Visualisation de données
  • Documentation
  • Financial Reporting
  • Forecasting
  • Git
  • GitHub
  • Incident Management
  • Jira
  • Leadership
  • Apprentissage automatique
  • Mentorship
  • Microsoft Azure
  • Microsoft Excel
  • Microsoft Office Suite
  • MongoDB
  • MySQL
  • PostgreSQL
  • Power BI
  • Résolution de problèmes
  • Process Improvement
  • Gestion de produit
  • Gestion de projet
  • prompt engineering
  • Python
  • Assurance qualité
  • Reporting
  • Collecte des exigences
  • API REST
  • Risk Management
  • Root Cause Analysis
  • Scrum
  • SQL
  • Stakeholder Management
  • Tableau
  • Travail d’équipe

Expérience

  1. Data and Reporting Analyst

    City of Hamilton

    déc. 2025 to Aujourd’hui

    Hamilton ON

    Project: Contributed to the City of Hamilton’s cloud modernization initiative by migrating legacy reporting systems from SSMS to Microsoft Fabric, integrating and transforming data into centralized models, and delivering reliable reporting solutions to support decision-making. • Lead the development of end-to-end data and reporting solutions across City departments, including nVision financial reporting, from data extraction and transformation through data modeling and Power BI delivery. • Partner with Finance and municipal stakeholders to understand business requirements, translate them into technical solutions, and provide guidance on data and reporting approaches. • Develop and maintain ETL/ELT pipelines using Microsoft Fabric, SQL Server, SSIS, T-SQL, and PySpark to ingest, transform, standardize, and integrate data from multiple enterprise sources. • Design and maintain data models and analytical datasets that support scalable Power BI reporting and self-service analytics. • Support the modernization of legacy SSRS/SSMS reporting solutions by migrating data and reporting workloads to Microsoft Fabric and Power BI, improving scalability and maintainability. • Implement data validation, reconciliation, and quality checks throughout data pipelines and reporting layers to ensure accuracy, consistency, and reliability. • Develop interactive Power BI dashboards and analytical reports using DAX to deliver insights into financial and operational performance. • Lead testing, deployment, troubleshooting, and ongoing optimization of data and reporting solutions, resolving technical and data-related issues across the reporting lifecycle. • Maintain technical documentation covering data pipelines, data mappings, data models, transformation logic, and reporting workflows to support governance and knowledge transfer.

  2. BI Developer

    FirstOntario Credit Union

    janv. 2025 to déc. 2025

    Hamilton ON

    Project: Designed and delivered a cloud-based data and BI solution for the mortgage management environment, integrating data from multiple sources into centralized datasets and reporting models. The solution supported improved visibility into mortgage portfolios and provided business users with reliable reporting and analytics. • Designed and delivered an end-to-end data and BI solution for mortgage reporting, integrating data from multiple source systems into centralized datasets for analytics and decision-making. • Built and maintained Azure Data Factory pipelines to ingest and orchestrate data from Azure SQL, Blob Storage, Snowflake, REST APIs, and other cloud-based sources. • Used Azure Databricks with PySpark, Python, and SQL to process, cleanse, transform, enrich, and prepare datasets for downstream analytics and reporting. • Developed scalable ETL/ELT workflows and implemented data quality checks using Great Expectations to validate pipeline outputs and improve data accuracy and consistency. • Optimized SQL queries and maintained centralized data models to support efficient reporting and reliable analysis. • Built Power BI and Tableau dashboards, including DAX measures and semantic models, to provide insights into mortgage portfolio performance. • Supported CI/CD and production deployment activities through version control, testing, and promoting approved data and reporting changes across environments. • Collaborated with data engineers, data scientists, project managers, and business stakeholders to gather requirements, troubleshoot issues, and deliver well-documented data solutions.

  3. AI Developer - Co-op

    Semper8

    sept. 2024 to déc. 2024

    Toronto ON

    Project: Led the development of an AI-driven perfume recommendation and customer engagement solution by integrating data from multiple sources, applying machine learning techniques, and developing AI-powered customer interaction capabilities. • Led data collection and integration from multiple sources and websites using Python libraries to create datasets for machine learning and analytics. • Performed data preprocessing, cleansing, exploratory data analysis (EDA), statistical analysis, feature engineering, and data visualization using Python, Pandas, NumPy, and other analytical libraries. • Developed and evaluated machine learning models to generate personalized perfume recommendations based on customer preferences and behavioral data. • Improved model performance and prediction accuracy by approximately 10% through hyperparameter tuning, feature refinement, and model optimization. • Analyzed customer preferences and behavioral patterns to improve recommendation quality and support predictive analysis. • Worked on predictive models to support sales forecasting and user preference prediction. • Used machine learning and deep learning technologies, including TensorFlow and PyTorch, to support model development and experimentation. • Contributed to the development of an AI-powered chatbot using Large Language Models (LLMs) and an interactive questionnaire to improve customer engagement and user experience. • Collaborated with developers, designers, and business stakeholders in an Agile environment and documented data workflows, model development, and AI solution processes.

  4. ETL Developer Intern

    Canada Goose

    juin 2023 to déc. 2023

    Toronto ON

    Project: Inventory Optimization Dashboard Delivered an inventory optimization dashboard that improved stock visibility, reduced overstock and stockouts, and empowered stakeholders to make data-driven inventory decisions across retail locations. • Gather and analyze requirements from the inventory department to create custom reports, visualizations, dashboards that provide actionable insights. • Created SSIS ETL packages for integrating multi-source data into a centralized model. • Created complex calculations, measures and calculated fields to derive meaningful metrics and KPIs. • Conducted data analysis to identify trends, patterns, anomalies in the data, enable data-driven decision making. • Develop and maintain interactive reports and dashboards using SSRS to meet the needs of business stakeholders. • Optimize report performance by fine-tuning queries, optimizing data models and implementing best practices. • Trained end users on how to interact with reports and dashboards effectively promoting self-service analytics. • Conduct regular quality assurance checks to validate data accuracy and report functionality. • Conducted migration of reports and dashboards from one platform to another. • Created and maintained documentation for report development standards, data dictionaries and user guides.

Formation

  1. GEORGE BROWN COLLEGE

    Applied AI Solutions Development

    2024 to 2024

  2. HUMBER COLLEGE

    AI with Machine Learning

    2023 to 2023

  3. MIRANDA HOUSE, UNIVERSITY OF DELHI

    Bachelors of Science, Computer Science

    2019 to 2022

Permis et certifications

  • Microsoft Certified: Fabric Data Engineer Associate

    Microsoft

  • Microsoft Certified: Fabric Analytics Engineer Associate

    Microsoft

  • Microsoft Certified Azure Fundamentals

    Microsoft

  • Enterprise Design Thinking Practitioner

  • Microsoft Certified: Azure Data Fundamentals

    Microsoft