Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic

Nithya Mittapally

Vancouver,Canada

Summary

Results-driven Business Analyst with over 5 years of experience in retail and banking, specializing in data migration, cloud modernization, and BI/reporting solutions. Proven expertise in gathering and translating requirements into BRDs, data mappings, and process flows, while ensuring regulatory compliance and business alignment. Skilled in SQL validation, UAT/SIT execution, and dashboard enhancements (Power BI, Azure), with a track record of improving data quality, streamlining reporting, and enabling successful enterprise migrations. Adept at bridging business and technical teams to deliver measurable outcomes in Agile environments. This summary must be like a narration.

Overview

1
1
Certification

Work History

Business Analyst

Retail Business Analyst
  • Conducted requirement workshops and JAD sessions with retail operations, finance, and IT teams to capture end-to-end migration and portal requirements; authored BRDs, user stories, and acceptance criteria in JIRA for traceability.
  • Built a reusable UI component library in Figma (navigation menus, dashboards, forms) to standardize designs, streamline requirement discussions, and reduce redesign effort during future enhancements.
  • Partnered with data engineering teams to prepare source-to-target mapping documents for products, customers, and store data; executed SQL-based data validation and raised JIRA tickets for mismatches.
  • Designed and executed a parallel testing strategy by running Power BI reports (Sales by Region, Top-Selling SKUs, Customer Lifetime Value) in both legacy and cloud platforms; reconciled drilldowns and logged variances.
  • Enhanced Power BI dashboards by adding custom DAX measures (YOY growth, basket size, discount analytics), updating filters for store hierarchies, and embedding bookmarks to meet client requests.
  • Facilitated user acceptance testing (UAT) by preparing scripts for migrated reports, guiding business users, and reconciling transactional drilldowns (e.g., 'Order to Delivery Timeline') with ERP data.
  • Used JIRA dashboards to track epics, story points, and SLAs, actively participating in backlog grooming, sprint planning, and daily stand-ups to ensure alignment across UI, data, and reporting workstreams.
  • Maintained a centralized knowledge base in Confluence with functional specs, Power BI usage guides, and Figma prototype walkthroughs, reducing onboarding time for new team members.
  • Provided post-migration product support by monitoring Power BI refresh failures, troubleshooting pipeline breaks, and coordinating hotfixes; served as the first contact for user-raised JIRA tickets.

Business Analyst

Banking Business Analyst
  • Partnered with business and technology stakeholders to gather requirements for data warehouse modernization, ensuring migration objectives aligned with regulatory reporting and operational analytics needs.
  • Conducted source system analysis of 200+ Netezza tables, identifying dependencies, data volumes, and transformation logic; created detailed data inventory documents for migration planning.
  • Collaborated with the data modeling team to validate target schemas in Azure, ensuring dimensional models supported both operational dashboards and finance/regulatory reports.
  • Authored source-to-target data mapping specifications covering key transformations such as account hierarchies, product classifications, and transactional rollups; worked with SMEs to validate mappings.
  • Performed data profiling using SQL to uncover data quality issues (null values, duplicates, invalid codes) and documented remediation steps for ETL developers, improving pipeline reliability.
  • Designed and maintained the enterprise data dictionary and business glossary, aligning business definitions (e.g., customer, exposure, loan-to-value ratio) with technical metadata for consistency across teams.
  • Created business process flows and system interaction diagrams in Visio to illustrate ingestion, staging, and consumption layers, helping stakeholders understand end-to-end data movement.
  • Designed and executed System Integration Testing (SIT) plans, preparing test cases for data reconciliation, pipeline performance, and cross-system workflow validation; documented results for QA sign-off.
  • Supported defect triaging and resolution by analyzing control logs and job audit outputs, working closely with developers to isolate issues and validate fixes.
  • Facilitated Agile ceremonies (backlog refinement, sprint planning, retrospectives) and tracked migration progress through JIRA dashboards, ensuring deliverables were aligned with milestones and stakeholder priorities.

Education

Master of Business Administration -

New York Institute of Technology
Vancouver, BC
12.2020

Bachelor of Technology - Mechanical Engineering

St. Ann’s College
Hyderabad, India
05.2018

Skills

  • Jira
  • ServiceNow
  • Confluence
  • Power BI
  • SQL Querying
  • Stakeholder communication and Requirements gathering
  • Business process analysis and documentation
  • Agile/Scrum Methodologies
  • Cloud services and infrastructure (Azure)
  • Figma
  • Python
  • Microsoft Excel(Advanced Formulas, Pivot tables)

Certification

Microsoft Certified: Azure Fundamentals, https://learn.microsoft.com/en-ca/users/nithyamittapally-6480/credentials/3fb2ac57102eee83

Websites

Timeline

Business Analyst

Retail Business Analyst

Business Analyst

Banking Business Analyst

Master of Business Administration -

New York Institute of Technology

Bachelor of Technology - Mechanical Engineering

St. Ann’s College

Similar Profiles

CREATE PROFILE
Nithya Mittapally