Ing. Babak Pirooz

In my role as a Data Warehouse Architect, Dashboard Developer, ETL Specialist, and Database Optimizer, I was responsible for designing and implementing a robust data infrastructure. By optimizing ETL processes, improving data models, and fine-tuning SQL queries, I successfully achieved a 30% improvement in database performance. Designed a scalable Data Warehouse architecture Developed interactive dashboards for data-driven decision-making Enhanced complex SQL queries and ETL

Identified and standardized KPIs across finance, auditing, HR, and payroll departments. Designed and implemented a centralized data warehouse architecture. Developed robust and automated ETL pipelines using SQL Server Integration Services (SSIS). Created dynamic and user-friendly Power BI dashboards to support executive decision-making. Utilized tools such as SQL Server, SSIS, Python, and Power BI throughout the project lifecycle.

Designing of business intelligence dashboard with Power BI software. Cobel Darou engages in the research, registration, importing, and marketing of pharmaceutical products for sale principally in the prescription market.Designing of business intelligence dashboard with Power BI software. Cobel Darou engages in the research, registration, importing, and marketing of pharmaceutical products for sale principally in the prescription market. Skills: Microsoft Excel · Microsoft Power BI · Project Management

I have been teaching Power BI since 2018. Power Query, M Query Language, Data Modelling, Power BI Architecture, DAX, R, Advanced Visualization (60 hours). Teaching more than 1000 hours of PowerBI course at NikAmooz Institute

One of the most significant projects that I have managed is Tidewater middle east corporate. this project Involves 6 companies In the field of Port and maritime. most tasks in this project were the integration of the financial system, Human resources, and logistics from various sources of different companies With a volume of about 100 GB of information, Creating integrated financial coding between companies, Identifying KPIs, Designing the Data warehouse,...

•Designing and Documenting production processes. Document data process life cycle and ETL processes. • Integration of business applications into the Data Lake and reporting. •Designing Data Lake, Data Marts, and Data Warehouse, while maintaining Master Data Services • Creating QVDs, from various data sources, for Qlik View/Qlik Sense. • Implementation Incremental Load • Creating streams and assigning user access