Aishwarya Ramarapu
Hyderabad
Summary
Data Analyst with over 4 years of experience across the telecom, cosmetics, and healthcare domains, specializing in SQL-based analysis, data validation, and KPI reporting. Skilled in transforming business requirements into actionable insights by ensuring data accuracy, reconciliation, and reliability across Azure data platforms. Experienced in collaborating with engineering and business teams to deliver analytics-ready data and meaningful reports using SQL and Power BI.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst - SQL & ETL Validation
Nokia
01.2023 - 08.2025
- Designed and developed optimized SQL scripts, stored procedures, views, and functions to support data extraction, transformation, data cleansing, and standardization from on-prem databases into Azure Data Lake Gen2.
- Performed data profiling to identify data gaps, anomalies, duplicates, and quality issues, and implemented SQL-based rules for improving data quality.
- Prepared Source-to-Target Mapping (STM) documents, data dictionaries, and transformation rule documentation.
- Collaborated with ETL testers to provide test data, expected outputs, root cause analysis, and clarification on data transformation logic.
- Ensured referential integrity, normalization standards, and compliance with enterprise data governance rules.
- Participated in design reviews, sprint planning, and code reviews, ensuring alignment with architectural standards.
- Provided production support during post-migration validation, including patch fixes, query optimizations, and defect resolution.
- Logged detailed defects with screenshots, data samples, and coordinated with developers, data engineers for issue resolution in Azure DevOps.
- Analyzed data trends and created visualizations using Power BI to support business decisions and strategic initiatives.
Data Analyst / SQL Developer
Amway
09.2021 - 12.2022
- Identified critical revenue and customer data issues impacting business metrics, and collaborated with data engineering teams to resolve ETL gaps, improving data accuracy by ~30%, and preventing incorrect KPI evaluation.
- Reduced data discrepancies in silver and gold layers by 40% by designing and executing systematic data validation frameworks.
- Implemented stored procedures and functions for reusable back-end business logic.
- Conducted data profiling and cleansing using SQL and Python (Pandas) to prepare high-quality data for analytics consumption. Performed reconciliation testing between source and target systems to ensure financial and business data accuracy.
- Executed data quality checks, including null checks, duplicate checks, referential integrity, and threshold validations.
- Developed reusable SQL scripts and stored procedures, integrating Git-based version control to support auditing, rollback, and collaborative development.
Education
B. TECH - COMPUTER SCIENCE AND ENGINEERING
ACE College Of Engineering and Technology
Hyderabad01.2021
Skills
- SQL
- DBMS: Oracle, MySQL, Microsoft SQL Server
- Microsoft Excel
- Python (NumPy, pandas)
- ETL/ELT validation
- Azure Data Lake Gen 2
- Data profiling and data reconciliation
- SIT/UAT and defect tracking
- Power BI
- Git
- Technical documentation
- Performance optimization
- Execution plan analysis
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Microsoft Certified: Python Fundamentals
Awards
- Best Employee of the Year – For exceptional contributions to data quality and project delivery.
- Best Team of the Year – For cross-functional collaboration on migration projects.
Timeline
Data Analyst - SQL & ETL Validation
Nokia
01.2023 - 08.2025
Data Analyst / SQL Developer
Amway
09.2021 - 12.2022
B. TECH - COMPUTER SCIENCE AND ENGINEERING
ACE College Of Engineering and Technology