Lavanya 01

Automated the ETL process using AWS Glue ETL job scripts to handle extraction, transformation, and loading of sales data, complaints data, and production logs from Amazon S3. Implemented quality checks and production statistics calculations, leading to the creation of three comprehensive reports in Amazon Redshift, enhancing data accuracy by 30%. • Developed a Python package for filtering and analyzing employee data, with functionalities to filter employees based on their joining date and calculate the average salary for specific designations. This tool is utilized in various data analysis and HR applications, reducing data processing time by 40%and streamlining employee data management. • Created a utility package designed to detect sensitive information or secrets within a given text file. The package processes input from a file path or a content string, returning true or false based on the detection of sensitive data. This enhanced data security measures and detected over 95% of potential data leaks.