Kate Guledani

• Leading Hydro One data collection and reporting process by Amidyne Solutions
• Developed custom reports for management using advanced SQL queries, enabling informed decision-making based on accurate data insights
• Made appropriate file information updates and system upgrades according to Hydro One management requirement
• Prepared files for archiving and exchanges, tracking file movement and history in format designed by collaborative efforts by Hydro One and Amidyne Solutions It and engineering teams
• Answered queries by locating and retrieving necessary files

• Performed database management functions such as updating, organizing, cleaning-up and retrieving data from a database working in MySQL and Excel

• Used data visualization tools such as R and Tableau to create visualization for reporting purposes

• Supported management with reporting process by attending meetings and providing input to accuracy of the findings.

• Coordinated with cross-functional teams to define clear requirements for new database features or modifications, ensuring successful project outcomes.
• Collaborated with IT professionals to design, implement, and maintain secure database systems for sensitive information storage.

• Enhanced database performance by optimizing queries and implementing indexing strategies.
• Reduced data redundancy with the normalization and proper design of database tables.
• Streamlined data retrieval processes by designing and implementing stored procedures and functions.
• Improved data accuracy through the creation of validation rules and constraints in database schema.
• Increased efficiency by automating repetitive tasks using scripting languages such as SQL or Python.
• Worked closely with IT staff to ensure seamless integration of database elements into new or existing applications, promoting optimal system functionality.