Mansi K Dolia

Experience

• 

  Infosys

  Jan 2021 - Jul 2022

  1. Built and maintained ETL pipelines using Python, SQL, and Apache Spark to process structured/semi-structured data (CSV, JSON, Parquet). 2. Performed data wrangling and transformation using PySpark and pandas, enabling more accurate business intelligence reporting. 3. Designed and implemented data pipelines using Azure Data Factory (ADF) to orchestrate data ingestion, transformation, and loading across blob storage, Azure SQL Database, and Data Lake. Optimized SQL queries and stored procedures, improving dashboard load times by 40%. 4. Contributed to enterprise data warehouse modeling using Star and Snowflake Schema designs. 5. Implemented ADF logging, alerts, and retry policies to monitor and ensure pipeline reliability. Show less

  • Data System Engineer

    May 2021 - Jul 2022

  • System Engineer Trainee

    Jan 2021 - May 2021
• 

  University of Ottawa

  Mar 2023 - Dec 2023

  Project Manager | Business Intelligence Analyst - ICanBeWell

  1. Collaborated with clinicians to gather requirements, translate them into user stories and GitHub tasks, enabling Agile development for healthcare app (ICanBeWell). 2. Built Power BI dashboards and cleaned data in Excel, boosting accuracy by 33% and enabling analysis by body part, health topic, and demographics. 3. Delivered monthly KPI reports (CTR, topic engagement, language usage) to support content updates and feature planning.

• 

  Rogers Communications

  May 2023 - Sept 2024

  1. Forecasted agent staffing across business lines using Excel (VBA, PivotTables, Macros), SQL Server, and Power BI for weekly and seasonal planning. 2. Applied time-series forecasting (YOY, MOM, WOW, moving averages) to predict call volume, sales, and staffing needs with 78%+ accuracy, accounting for peak events (e.g., Black Friday, Boxing Day). 3. Built automated Power BI dashboards tracking KPIs: occupancy, shrinkage, call volume, service levels, and agent productivity. 4. Led data cleaning and transformation, reducing errors by 30% and improving forecast reliability. Show less

  • Sales Representative - Manager on Duty

    Oct 2022 - Sept 2024

  • Data Analyst

    May 2023 - Nov 2023
• 

  Aedo

  Jan 2024 - now

  1. Designed and executed complex SQL ETL processes for timecard data (ST, OT, DT hours) to streamline uploads into Rhumbix. 2. Automated Power BI dashboards (weekly/monthly) on project progress, client performance, and financial trends via Aedo Data Hub. 3. Led client discovery to resolve data quality issues and reporting gaps, translating needs into scalable BI solutions via BRDs and user stories.4. Built Procore-integrated dashboards for financials, preconstruction KPIs, invoicing, accounting syncs, and resource planning. 5. Worked with flat files (CSV, Excel), SQL Server, and APIs using connectors and custom ETL to bring data into Power BI. 6. Leveraged DAX, Power Query, and data modeling to cut manual data processing by 40%. 7. Collaborated on UAT and troubleshooting via SQL diagnostics and Power BI tracing, reducing issue resolution time by 25%. 8. Applied Agile practices with JIRA and Confluence to manage sprints and document data flows for analytics delivery. Show less

  • Business Data Analyst

    May 2024 - now

  • Business Data Analyst Intern

    Jan 2024 - May 2024