Sruthy Elsa Jacob

Intern

Dyocense Technologies Pvt Ltd.•  January 2022 - February 2022

• Received a comprehensive dataset containing information from various home appliances connected to an IoT network, capturing sensor data and device statuses. • Conducted data cleaning and preprocessing to ensure data quality and consistency for further analysis. • Utilized SQL queries to identify and isolate potentially defective home appliances based on anomalies and specific criteria within the dataset. • Employed SQL optimization techniques to enhance query performance, ensuring efficient processing of a large-scale IoT dataset. • Developed dynamic charts and graphs using SQL-generated data, enabling clear and intuitive visualization of appliance statuses and defects.