Sai Anusha Puvvala

Database optimization and advanced data analytics. Built 15+ SSIS ETL pipelines reducing data processing time by 35% and accelerating cross-department insights. Improved SQL and Python queries by 40%, enhancing performance of BI dashboards used by 50+ users for real-time insights. Automated system provisioning, deployment, and scaling with Python, and developed ETLs to extract data from diverse operational systems. Developed and optimized SQL queries for efficient data extraction and processing to support analytics and business initiatives.

Created and optimized SQL queries for database manipulation and data extraction, ensuring efficient data retrieval and processing to support analytical tasks and business initiatives. Developed Python scripts for automation of provisioning, deployment, upgrading, and scaling; built ETLs to extract data from various operational systems. Applied advanced statistical techniques to identify trends and anomalies, collected and integrated data from multiple sources (internal databases, external providers, APIs) to create comprehensive datasets, and designed cloud-based solutions to ensure scalability and efficiency. Collaborated with cross-functional teams to understand data requirements across departments and conducted A/B tests to measure impact of changes.

Designed and optimized PostgreSQL database structures with indexing and query optimization. Developed and optimized ETL pipelines for data ingestion using AWS Redshift and Glue, automating processes and reducing manual tasks by 40%. Analyzed large datasets from 50+ sources using Python and SQL, created dynamic dashboards in Tableau and Excel, and implemented robust data warehousing solutions with enhanced metadata management and data models. Applied data mining and cleansing techniques across 20+ projects and collaborated in Agile (Scrum) environments to deliver data-driven solutions. Built scalable cloud solutions leveraging AWS services (EC2, Lambda, RDS) and utilized Git for version control; performed statistical analysis with Seaborn to support business strategies.