Aishwarya Chandragiri

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.

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.

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

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