Skip to main content
Aishwarya Chandragiri

Aishwarya Chandragiri

Data Analytics / Business Intelligence Analyst

Talent
BradentonMember since July 18, 2026
Historical Snapshots & Effective DatingRecord VersioningPower BITableauAdvanced SQLOracle SQLDAXPower Query (M)SQL ServerPostgreSQLManual TestingData CleansingSprint PlanningData Governance
·

Hire this person

Send a job offer directly to this candidate

Historical Snapshots & Effective DatingRecord VersioningPower BITableauAdvanced SQL

About

Data Analytics / Business Intelligence professional with 4+ years of experience designing and maintaining data models, change-tracking pipelines, and dashboards across HR, Finance, and Operations data. Skilled at translating complex, event-driven lifecycle processes (creation, elimination, modification, replacement, and overlap) into clear, auditable data flows and reporting for both technical and non-technical stakeholders. Proficient in Power BI, Tableau, advanced SQL, DAX, Power Query, ETL automation, and star-schema data modeling, with hands-on experience handling historical snapshots, effective dating, and record versioning across messy, multi-source data.

Strong communicator, experienced partnering with Finance, HR, and Operations teams to validate data logic, assumptions, and business rules.

Experience

Business Intelligence Analyst - Tekvibe Inc. - Texas, USA

(2023-05)

Project: Charles Schwab – Enterprise Operations & Performance Analytics

  • Designed and maintained data models linking source records to all approved change events, tracking lifecycle transitions including creation, elimination, modification, replacement, and overlapping periods.
  • Built scalable star-schema data models supporting historical snapshots, effective dating, and record versioning to enable accurate point-in-time and trend reporting.
  • Built data flows and mappings capturing granular change data, including status/level changes, start and end date modifications, and overlapping transition periods (backfills, phased transitions).
  • Developed advanced DAX measures, KPIs, calculated columns, and time-intelligence calculations to clearly summarize what changed, when, why, and the net impact over time.
  • Automated ETL workflows using SQL and Power Query (M), integrating data from SQL Server, Oracle SQL, and PostgreSQL into a single, auditable source of truth spanning HR, Finance, and Operations systems.
  • Built Power BI and Tableau dashboards and reporting views summarizing total record counts (then, now, future) and breakdowns by key attributes (level, location, and other business drivers) for non-technical stakeholders.
  • Partnered with Finance, HR, and Operations stakeholders to validate data logic, assumptions, and business rules, translating complex business processes into clear data structures and visuals.
  • Conducted manual testing of dashboards and reports, and performed API testing using Postman to validate data feeds from enterprise REST APIs, ensuring accurate, traceable data ingestion.
  • Participated in Agile ceremonies (sprint planning, daily stand-ups, sprint reviews, retrospectives) supporting iterative delivery of analytics solutions.
  • Performed data cleansing, validation, reconciliation, and root-cause analysis to maintain high data accuracy and consistency across messy, event-driven, multi-source data.
  • Implemented drill-down and drill-through reporting capabilities enabling self-service analysis of change history and audit trails.
  • Optimized dashboard performance through query tuning, data model enhancements, and incremental refresh implementation.
  • Created documentation of data logic, business rules, dashboard architecture, and data governance standards to support traceability and audit needs.

Research Analyst Intern - Infosys - India

(2019-07 - 2022-03)

  • Gathered, analyzed, and validated structured and unstructured datasets from multiple business source systems.
  • Developed SQL and Oracle SQL queries for data extraction, transformation, and reporting on business change events.
  • Assisted in preparing business reports, trend analysis, and performance metrics for management review.
  • Performed manual testing of reports and data outputs to verify accuracy and alignment with business requirements.
  • Conducted data quality assessments and validation activities to improve reporting reliability.
  • Collaborated with cross-functional teams to support analytics and business intelligence initiatives.
  • Maintained metadata repositories, documentation, and reporting standards.
  • Supported ETL activities and data preparation processes for enterprise reporting projects.
  • Assisted stakeholders with ad hoc reporting requests and analytical investigations.

Education

Master of Science - Business Analytics - Trine University (2022 - 2024)

Bachelor of Business Administration - Business Administration - Osmania University (2018 - 2021)

Skills

Data Analytics / Business Intelligence Analyst

Reviews

Related