Sahila Aggrawal

Developed AWS Glue jobs that transformed raw data into Redshift cluster for claims matching process, reducing processing time by 30%. Developed and deployed data solutions utilizing AWS cloud technologies, including Glue, Redshift, Lambda, Event Bridge, Step Functions, SQS, and SNS. Led the expansion and migration of the Validation Auditing System (VAS) to ingest commercial medicare data using AWS Services, ensuring that the system meets the organization's growing needs and requirements. Designed and developed a scalable and efficient data pipeline using AWS services, enabling the organization to process and analyze large amounts of data in a timely and accurate manner. Developed and implemented a notification system using SNS and dedicated teams channel to alert business teams in real-time of any errors, ensuring timely resolution and minimizing downtime. Performed data masking to provide realistic data for lower environments, ensuring that testing and development activities accurately reflect the production environment. Provided analysis based on business requirements using SQL queries and MS Excel, generating insights and recommendations that informed business decisions. Collaborated with cross-functional teams to identify business requirements and develop solutions that meet their needs, while also adhering to best practices and data governance policies.

Developed and deployed machine learning models to predict avalanche occurrences with high accuracy, improving the organization's ability to predict and respond to potential natural disasters. Collaborated with a team of researchers to develop and test new models to improve the accuracy of Avalanche detection and prediction. Developed algorithms, models and in-house tools using Python for Avalanche Detection and data management. Analyzed and processed GIS data using various tools and techniques, including ArcGIS and QGIS, to prepare data for use in machine learning models. Designed and maintained databases and GIS systems to manage and analyze large amounts of data. Provided technical guidance and training to new team members to help them develop the necessary skills and knowledge for the project.