Mahdi Rahimi moghadam

Coached a junior BI team for 10 hours per week. Created a BI project for Iran’s Ministry of Education using SQL Server 2019, SSIS, SSAS, and Power BI. Developed more than 6 crucial key performance indicators (KPI) of UNICEF. Improved Power BI query performance through optimized data models and performance tools, achieving 40% faster speed. Administered and maintained the SQL Server Datawarehouse.

Managed 20 SQL server databases’ infrastructure and administration. Implemented data warehouse and analytical reports using SQL Server 2017, SSIS, SSAS Tabular, and Power BI. Used Power BI to create dashboards that helped analyze frequently out-of-stock products. Optimized the NoSQL databases of the organization, MongoDB and Elasticsearch. Transformed the e-commerce retail store into a marketplace platform by applying data-driven solutions. Coached a junior BI team for 10 hours per week.

Administered 24/7 SQL Server databases for a payment gateway system. Experienced with 35 TB data and 25 million records transactions per day. Delivered High Availability Always On (HA) and disaster recovery systems in SQL Server. Monitored and optimized the SQL Server database performance and TSQL. Developed SFTP Component for SSIS to facilitate data integration, using C#.Net and Script Task. Improved an insert operation from 3 hours to 20 minutes by replanning the indexing scenario.

Taught more than 10 SQL Server and C#.NET foundations for a training institute, using effective teaching methods and materials. Gained teaching and mentoring experience and learned how to communicate effectively with the students and motivate them to learn, achieving a 90% satisfaction rate in the feedback surveys

A company worked for IT of the Port Marine Organization of Iran. Create a web app for Iran's port marine org, used by 53 ports with 600+ users. Implemented the section for ship entry and exit, which was the software's most complex and significant part. Provided SQL Server performance tuning training to a northern port. Optimized and tuned SQL Server database performance

A software development company that is for legal claims software systems with an ERP. Implement business logic for the Tehran municipality, using TSQL and Microsoft SQL Server. Generate reports in SSRS to display and analyze the data and results.

A company for Teaching programming courses and Implementation of enterprise web applications. Assisted professors in class management and student support for more than 10 classes. I created backends for the student portal and National Standards Institute.