Simone – SQL, Python, Microsoft Azure

The project is BI reports to support business intelligence and decision-making.

• Designed and developed interactive Power BI reports and dashboards.
• Connected and transformed data from multiple sources using Power Query.
• Implemented DAX measures for accurate KPIs and metrics.
• Optimized report performance and usability.
• Maintained and updated reports based on evolving business needs.

It's a chatbot powered by Azure OpenAI that understands the database schema and helps generate, explain, and debug SQL queries, improving self-service and reducing support load.

• Developed an AI-powered chatbot using Azure OpenAI to assist with SQL queries.
• Leveraged SQL project files to train and fine-tune the language model.
• Designed conversation flows to interpret user intents and generate accurate SQL.
• Developed a JavaScript front-end for the chatbot.
• Implemented error handling and query validation to improve reliability.

This project is about enhancing data pipelines by optimizing Azure SQL databases and integrating Azure Synapse Analytics for advanced analytics and machine learning.

• Designed and implemented Synapse Analytics pipelines, enabling real-time BI dashboards.
• Optimized query performance via indexing and partitioning.
• Mentored junior devs on T-SQL best practices and troubleshooting production issues.
• Integrated Azure SQL with Synapse for hybrid analytics, supporting ML model training.

It's an Azure Durable Function that automates the daily import of Jira issue data, storing it in a SQL Server database for reporting purposes.

• Developed an Azure Durable Function to automate daily Jira data imports.
• Integrated the Jira REST API with SQL Server for reliable data ingestion and storage.
• Implemented pagination, authentication, and data consistency mechanisms for robust processing.
• Designed and deployed a Power BI dashboard to visualize key project KPIs and performance trends.