Web Developer and IT Specialist

• Sep 2023 - Present

Data Engineering Analyst

• Sep 2022 - Jul 2023

• Leveraged technical expertise in AWS services, Python, SQL, Scala, Excel, and Tableau to design and implement efficient data pipelines for extracting and transforming on-premise Oracle database data into S3 buckets, enabling downstream teams to access critical dashboards.• Automated the swapping of glue connection security groups, resulting in $10,000+ cost savings and avoiding production job failures.• Developed step function and lambda function to monitor periodic job failure thresholds, enabling automated email alerts to clients and ensuring timely issue resolution. Show less

Data Engineering Associate

• Jan 2021 - Sep 2022

• Collaborated with senior developers to design and implement an enterprise big data analysis platform using AWS services, Python, SQL, Scala, Spark, Hadoop, and microservices, improving data extraction, transformation, and loading processes for 800+ client users.• Aggregated unstructured data from 10+ sources to perform analytics and study clinical reports, enhancing decision-making processes.• Analyzed over 3 years of application transactional data using Python and SQL, resulting in a 30% decrease in production failures through streamlined resource allocation.• Implemented an automation script to monitor AWS services and display CloudWatch metric dashboards via emails, leading to an 80% reduction in support monitoring efforts and a 40% cost reduction. Show less