Mahdi Sayyari

- Designed and maintained SQL Server databases, including data modeling, schema design, and data integrity management. - Developed and optimized queries and stored procedures to implement business logic and improve system efficiency. - Implemented modern frontend development best practices, including component-based architecture with React.js, state management using Redux, and server-side rendering with Next.js.

Developed and maintained financial systems supporting stock exchange brokers in Iran, serving over 11 million customers for online trading of shares. - Contributed to the development and troubleshooting of a .NET-based web application integrated with SQL Server databases. - Maintained and optimized SQL Server dimension tables to support data warehouse and reporting solutions for brokers, and used Power BI to develop dashboards. - Participated in developing, and debugging RESTful APIs and SOAP web services.

In the administrative automation team, we implemented Agile methodologies. - Developed, maintained, and optimized SQL Server databases and complex stored procedures, including query optimization, performance tuning. - Developed and maintained ETL processes using SSIS (SQL Server Integration Services), improving data accuracy and processing efficiency. - Designed and developed SSRS (SQL Server Reporting Services) reports for customers, providing customized insights and data visualizations.