Shraddha Rekhe
Summary
Analytical and results-driven Data Analyst with 4 years of experience in SQL development, ETL, and Power BI reporting. Skilled in building automated dashboards, optimizing complex queries, and transforming raw data into actionable insights. Strong expertise in data modeling, performance tuning, and reporting automation, with a proven track record of improving efficiency, reducing manual effort, and enabling data-driven decision-making. Adept at collaborating with cross-functional teams to align business needs with scalable analytics solutions.
Overview
4
4
years of professional experience
Work History
Associate Data Analyst
Tata Consultancy Services
Pune, India
06.2023 - 06.2025
- Designed and developed interactive dashboards in Power BI to track KPIs enabling business leaders to make faster and data-driven decisions.
- Consolidated multi-source datasets into SQL-based data warehouse; streamlined ETL processes to ensure data quality, accuracy, and timely availability.
- Built and optimized SQL queries, stored procedures, and data models to transform and aggregate millions of records into meaningful business insights.
- Partnered with cross-functional stakeholders to define KPI frameworks, validate metrics, and align reporting standards, reducing reporting discrepancies by ~30%.
- Automated recurring reporting workflows with scheduled refreshes in Power BI Service, improving reporting efficiency and reducing manual efforts by ~40%.
- Conducted trend analysis, customer segmentation, and cohort studies to uncover drivers of revenue growth and retention; recommended actionable strategies that improved ROI and campaign efficiency.
- Ensured data integrity through rigorous validation and QA; reconciled SQL extracts with source systems to guarantee reliable insights.
Analyst
Tata Consultancy Services
Pune, India
04.2021 - 06.2023
- Worked on end-to-end data processing pipelines in the insurance domain, managing large datasets of policyholder and claim information to support reporting and downstream analytics.
- Collaborated with business analysts and stakeholders to translate business rules into technical data transformations, ensuring alignment between requirements and final outputs.
- Developed and optimized SQL stored procedures, complex queries, joins, and window functions to transform raw data into structured formats; improved query efficiency and reduced processing time for recurring reports.
- Created and maintained ETL workflows to move, validate, and prepare data across staging and reporting layers, ensuring smooth integration with analytical systems.
- Performed data validation, reconciliation, and quality checks across multiple modules (e.g., membership, invoicing, claims) to maintain data accuracy and integrity.
- Partnered with QA teams and business users for UAT, resolving data mismatches and documenting workflows for future reference.
- Delivered ad-hoc SQL analyses and reports to business teams, enabling faster resolution of data issues and improving trust in analytics outputs.
Education
B.E - Computer Technology
Priyadarshini College of Engineering
01.2020
Skills
- Visualization & Reporting: Power BI (DAX, Power Query), Excel (Pivot, Power Pivot)
- Databases: SQL Server, MySQL, advanced SQL (CTEs, window functions, stored procedures)
- ETL & Data Engineering: SSIS, data cleaning & transformation, star schema modeling
- Analytics: Python (pandas, numpy, matplotlib), statistical & trend analysis
- Business Knowledge: Insurance & Marketing analytics, KPI frameworks, stakeholder collaboration
Awards
Service and Commitment Award, Tata Consultancy Services, Best Team Award, Tata Consultancy Services
Timeline
Associate Data Analyst
Tata Consultancy Services
06.2023 - 06.2025
Analyst
Tata Consultancy Services
04.2021 - 06.2023
B.E - Computer Technology
Priyadarshini College of Engineering