Vandana Nandola

Data Analyst with 5+ years of experience transforming complex business and operational data into actionable insights across banking, healthcare, and supply chain environments. Proven expertise in data analysis, business intelligence, statistical modeling, and performance reporting, supporting strategic decision-making and process improvement initiatives. Skilled in leveraging SQL, Python, R, and modern analytics platforms to extract, validate, analyze, and visualize large-scale structured and unstructured datasets. Strong background in developing interactive dashboards, KPI frameworks, and executive reporting solutions that improve visibility into business performance and operational trends. Experienced in designing and optimizing ETL/ELT workflows, data models, and reporting processes to enhance data quality, governance, and accessibility across enterprise systems. Adept at applying exploratory data analysis, hypothesis testing, predictive analytics, customer segmentation, and trend analysis to solve complex business challenges and uncover growth opportunities. Collaborative professional with experience partnering with business stakeholders, technology teams, and senior leadership to gather requirements, define metrics, and deliver data-driven solutions aligned with organizational objectives. Knowledgeable in Agile and SDLC methodologies with a strong focus on data governance, regulatory compliance, process optimization, and continuous improvement within data-driven organizations.

• Agile
• Attention to detail
• Git
• GitHub
• Jira
• Leadership
• Microsoft Azure
• MongoDB
• MySQL
• PostgreSQL
• Power BI
• Python
• Requirements gathering
• SQL
• Tableau
• Time management

1. Data Analyst II

   TD Bank (Toronto-Dominion Bank)

   Nov 2023 to Present

   ON, Canada

   • Analyzed more than 10 million daily credit card transactions using SQL and Python to identify emerging fraud patterns and anomalous spending behavior, improving early fraud detection accuracy by 18% and strengthening risk mitigation efforts. • Developed and maintained Tableau dashboards tracking customer retention, product adoption, and branch performance across 200+ retail banking locations, providing leadership with actionable insights for business reviews and strategic planning. • Applied customer segmentation techniques using Python (scikit-learn, K-Means) to evaluate demographic and transactional behavior trends, enabling targeted marketing initiatives that increased cross-sell conversion rates by 9%. • Streamlined regulatory and risk reporting processes through SQL automation and Power BI reporting solutions, reducing month-end reporting turnaround time from five business days to two while improving reporting accuracy and consistency. • Evaluated loan delinquency and default trends through detailed variance and portfolio analysis, delivering actionable insights to risk management teams that supported enhancements to credit underwriting strategies. • Modernized reporting infrastructure by migrating legacy analytics workflows to Azure Synapse Analytics and Azure Data Factory, improving data reliability, scalability, and reducing pipeline execution time by 35%. • Implemented row-level security frameworks and governance controls within Power BI environments to safeguard sensitive financial data and ensure compliance with internal policies and regulatory requirements. • Partnered with data engineering, compliance, and AML teams to validate data quality controls and reporting logic, improving the accuracy and integrity of suspicious activity monitoring and regulatory reporting processes. • Conducted cohort, behavioral, and funnel analysis on digital banking engagement metrics, uncovering onboarding friction points that informed product enhancements and increased mobile onboarding completion rates by 11%. • Provided mentorship and technical guidance to junior analysts on SQL performance optimization, dashboard development, and reporting standards while establishing consistent KPI definitions and documentation across the analytics function.

2. Data Analyst

   Cardinal Health Canada

   Jan 2021 to Oct 2023

   • Developed a demand forecasting and inventory optimization model using historical order patterns, seasonality, and supplier lead-time data, reducing stockouts by 22% and lowering excess inventory carrying costs by 15% across 40+ distribution centers. • Designed and automated ETL workflows using SQL Server, SSIS, and Python to integrate order, shipment, and returns data into a centralized warehouse, reducing reporting time from two days to under two hours. • Built executive Power BI dashboards to monitor fill rate, backorders, inventory health, and on-time delivery performance, improving supply chain visibility and contributing to a 12% increase in order fulfillment SLA compliance. • Analyzed supply chain exceptions and vendor performance using SQL, Python (Pandas, NumPy), and statistical techniques, identifying recurring supplier delays that supported contract negotiations with key vendors. • Partnered with procurement, operations, and supply chain leadership to establish and track critical performance metrics, including forecast accuracy, fill rate, and days of supply, creating standardized reporting across business units. • Developed Power BI data models, DAX calculations, and inventory monitoring dashboards to identify at-risk SKUs and optimize safety stock levels, reducing emergency freight expenses through earlier replenishment planning. • Evaluated replenishment strategies through comparative data analysis and scenario modeling, providing recommendations that led to the adoption of a hybrid inventory planning approach for high-demand product categories. • Processed and validated more than 5 million transactional records using SQL and Power Query, improving data quality, reporting accuracy, and compliance readiness within a highly regulated healthcare supply chain environment. • Maintained data dictionaries, business rules, and reporting documentation to improve governance, support audit requirements, and streamline onboarding for new analytics team members. • Collaborated with business and technology stakeholders to gather requirements for an enterprise inventory visibility solution, translating operational needs into technical specifications and supporting successful solution delivery.

1. Algoma University

   Diploma in Information Technology, Information Technology

   Sault Ste. Marie, Canada

2. Gujarat Technological University

   Bachelor of Engineering in Computer Engineering, Computer Engineering

   Ahmedabad, Gujarat, India

• Google Analytics Certification

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)

• Microsoft Certified: Azure Data Fundamentals (DP-900)

• Tableau Desktop Specialist