Aishwarya Chandragiri
Data Analytics / Business Intelligence Analyst
Hire this person
Send a job offer directly to this candidate
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)
