Sandhya Lakshmi Bondalakunta
Bothell
Summary
Data Analyst and Business Analyst with 7+ years of experience across Microsoft, Amazon, and enterprise projects. Skilled in SQL, KQL, Power BI, Excel, and data modeling with expertise in subscriptions, renewals, fraud analysis, and operational reporting. Proven ability to build reliable datasets, create impactful dashboards, validate data accuracy, and deliver insights that improve decision-making, efficiency, and business outcomes.
Overview
19
19
years of professional experience
Work History
Business Intelligence Analyst
Intelliswift Software/Amazon
02.2024 - 12.2025
- Gathered, analyzed complex business requirements into detailed BRD's and user stories to drive strategic decision-making and optimize processes.
- Collaborated with cross-functional teams to develop data-driven insights and enhance operational efficiency.
- Designed and implemented reporting frameworks to monitor key performance indicators and support organizational goals.
- Built early datasets in Excel by aggregating raw data from multiple sources and verifying accuracy through manual comparisons with reference systems.
- Implemented a more scalable analytics foundation by creating structured tables in Andes and validating data using automated joins across systems, improving the reliability and consistency of downstream analytical models reducing data preparation time by 30–50%.
- Increased data accuracy by eliminating manual errors through automated joins and validation across systems.
- Enhanced reporting reliability, enabling Data scientists to make faster and more confident data-driven decisions for their ML models enhancements.
- Resolved 250+compliance tickets by providing suggestions and solutions for the team and reduced the Queue capacity by 95% in a span of 8 months.
- More deep dives and root cause analysis to fix the problem and increase the efficiency of business decisions.
- Presenting WBR, MBR and QBR to higher management and adhoc analysis as needed within strict timelines.
- Providing KT session to improve efficiency of the team.
- Working with Parquet files and converting them to excel using python
Sr.Data Analyst
Zen3 Info Solution/Microsoft
09.2021 - 08.2022
- Gathering and analyzing subscription data from multiple internal sources using SQL, KQL, and Excel, applying transformation and validation logic to ensure accuracy and completeness.
- Validated subscription datasets by performing cross-system joins and QA checks.
- Developed interactive Power BI dashboards that tracked key subscription KPIs like activation, trial conversion, renewal rates, churn, and engagement.
- providing leadership with real-time visibility into subscription data metrics.
- Conducted business-focused analyses to identify trends, user behavior patterns, and root causes behind conversion drops or churn spikes
- Collaborated cross-functionally with 6 different Product Managers to translate business questions into measurable metrics, analytical models, and actionable recommendations.
- Scenario analysis by building pivot tables in Excel-based models used to estimate the impact of new features, pricing changes, and customer segments.
- Communicated insights through reports, dashboards, and presentations, enabling stakeholders to make data-driven decisions.
- Aligning with Microsoft data governance and privacy standards while handling sensitive subscription and customer lifecycle data.
- With analysis and root cause detection of early churn and at-risk customer segments, contributed to a 5–9% reduction in churn.
- Consolidating requirements into documents for future reference.
Business Analyst II
Intelliswift /Amazon
02.2021 - 08.2021
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Partnered with Data Scientists to prepare high-quality datasets and support exploratory analysis, accelerating insights generation for seller performance and operational improvement.
- Created data and visualizations for WBR and MBR and daily metrics.
- Supported successful product launches with detailed workflow analysis.
Business Data Analyst
HARMAN/Microsoft
03.2019 - 01.2021
- Analysis on subscription systems to validate renewal data accuracy, billing consistency, and customer lifecycle records using SQL and Excel.
- Identified discrepancies in subscription status, renewal dates
- Audited end-to-end subscription workflows to detect gaps in data flow, incorrect mappings, and system errors impacting renewal and churn reporting.
- Preparing data to analyze by removing anomalies and binning to view categorically
- Meeting with stakeholders for requirements and model efficiency review
- Offsite team management
Data Analyst
TechMahindra/Microsoft
05.2017 - 07.2018
- Analyzed Windows Device telemetry and advertising performance data to identify opportunities for improving ad targeting and user engagement.
- Translated business and data requirements into project-level data models, ensuring structured and scalable analytics outputs.
- Built interactive Power BI dashboards to visualize key advertising and device metrics, enabling data-driven decision-making.
- Utilized SQL queries and developed SSIS packages for data extraction, validation, and import workflows, significantly improving data accuracy and processing efficiency.
Data Analyst
Robustware/Microsoft
10.2015 - 07.2016
- Performed data analysis for the Office 365 Business Planning Team, supporting strategic planning and performance evaluation.
- Extracted, transformed, and analyzed large datasets using SQL, SCOPE, and C# scripting.
- Developed DAX calculations and SQL stored procedures for advanced data visualizations and operational dashboards.
- Collaborated with management, analysts, and data scientists to define analytical requirements and deliver actionable business insights.
Intern Developer
TCS
03.2008 - 12.2009
- Worked closely with senior developers, absorbing critical knowledge and developing technical expertise in various programming languages and frameworks.
- Assisted in troubleshooting software issues for end-users, providing timely resolution and improving overall system stability.
- Engaged in continuous learning opportunities such as workshops or training sessions provided by the company, expanding skillset as an intern developer.
- Implemented unit tests to validate code functionality while reducing potential errors or bugs that might occur later in production.
Intern
ISRO
01.2007 - 11.2007
- Contributed to the development of an internal intranet system used to assess manpower requirements for ISAC projects.
- Supported analysis and documentation of applications, project workloads, team structures, and manpower allocation workflows.
Education
MCA - Computer Applications
JNTU
Hyderabad,India06-2007
Skills
- SQL programming
- Data dashboard design
- Python programming
- Data visualization
- Big data analytics
- Business intelligence analysis
- Data analysis
- Business analysis
- Advanced Excel
- Pattern recognition
- ETL development
- KPI monitoring
- NoSQL databases
- Data warehousing
- Workflow Analysis
- Requirements analysis
- Data and analytics
- Business planning
- Team collaboration
- Project management
- Specifications documentation
Timeline
Business Intelligence Analyst
Intelliswift Software/Amazon
02.2024 - 12.2025
Sr.Data Analyst
Zen3 Info Solution/Microsoft
09.2021 - 08.2022
Business Analyst II
Intelliswift /Amazon
02.2021 - 08.2021
Business Data Analyst
HARMAN/Microsoft
03.2019 - 01.2021
Data Analyst
TechMahindra/Microsoft
05.2017 - 07.2018
Data Analyst
Robustware/Microsoft
10.2015 - 07.2016
Intern Developer
TCS
03.2008 - 12.2009
Intern
ISRO
01.2007 - 11.2007
MCA - Computer Applications
JNTU