Sai Preetham Ampolu

• Executed data transformation, deduplication, and consistency checks using MySQL to enhance data quality.
• Automated daily data workflows to improve accuracy and reliability.
• Teamed with backend and scraping teams to identify and resolve data issues, improving overall data reliability.
• Led large-scale movie showtime data cleanup and validation processes to ensure data integrity.
• Handled missing data, format corrections, and anomaly detection.
• Worked with document based content workflow, enabling structured storage & tagging of unstructured data such as logs, API responses and system generated documents.

Spearheaded migration of extensive datasets to ClickHouse, achieving a 70% performance improvement.

• Optimized complex queries, cutting execution times from several minutes to mere seconds.
• Engineered and deployed over 100 stored procedures and complex SQL queries, boosting reporting speed by 40%.
• Automated dashboard metric roll-ups, reducing manual effort by 50% and enhancing data accuracy.
• Collaborated with UI and QA teams to refine data retrieval processes, enhancing report accuracy and reducing errors.
• Fortified database security with SQL injection validations and role-based access control, protecting sensitive data.
• Trained and mentored new SQL developers, facilitating smooth integration into projects and improving team capabilities.
• Assisted in designing basic data models and standards for sourcing, storing and distributing operational datasets.
• Created and maintained basic reference data in metadata tables to standardised key business attributes across pipelines.
• Participated in internal evaluations of database tools and ETL utilities to support project requirements.
• Collaborated with cloud engineering teams to work with Azure-based data pipelines involving ADF and Databricks notebooks for staging and processing data.
• Gained hands-on exposure to Azure resource configuration such as storage accounts, networking basics, and access roles.