Khitem Amiri

I worked as a Data Engineer at Allianz to meet the delivery of regulatory topics. I took over the existing project by quickly acquiring skills to meet client needs. I also participated in the run monitoring, an essential part of the project, by also being on call during accounting closing periods.

During the Zurich insurance project, I updated the SQL Hardening Framework, built and managed PowerBI reports, provided essential build guides for SQL cluster construction and SSRS server construction (including documentation). I also installed several SQL servers and hardened them. I also provided user support and deployed SQL Server patches and Service Packs across multiple domains, updated the framework to identify unauthorized login attempts on SQL servers and to track SQL backups.

Finally, I worked on identifying hardware performance issues on SQL servers and reported them in a Power BI report. The data was collected from servers using the SSIS package initially, then, due to security concerns, the data was ultimately loaded into the data warehouse using a Powershell script.