The main subject of the company's activity is investing in funds, in industries of oil, gas, and petrochemicals.Most tasks in this project include KPI identification, Designing a staging area, designing a data warehouse, and designing a dashboard In the field of human resources, accounting, budgeting, control projects, and so on.One of the most interesting things about this project is the integration of 30 companies.

I have been teaching special business intelligence courses.For instance: how to implement the Persian calendar instead of the Gregorian calendar in Power BI, how to implement the Persian Power BI report server, or how to implement forms authentication and SSO in the Power BI report server.Persian Power BI report server includes implementation of right to left, translation of all objects, and using Persian font.https://rypitech.com/education-courses/

Designing data warehouse, Designing Dashboard, Implementation Incremental QVD,...

Designing data warehouse, Designing Dashboard

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 and implementing advanced analytics such as RFM, sensitive analysis, correlation analysis, Pricing Analysis, ABC classification, Dynamic Dimension, and Dynamic measure, in addition, teaching and designing a Sales Dashboard, Customer Analysis dashboard, employee Analysis dashboard, and financial dashboardTeaching more than 1000 hours of PowerBI courses at NikAmooz InstituteWebsite: https://nikamooz.com/product/power-bi-desktop-course/https://rypitech.com/education-courses/

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.

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,developing SSIS incremental load packages and managing slowly changing dimensions.Available data exist in SQL Server and Excel are in different areas.and also Due to huge data in the facts have needed to design OLAP data with SSAS.the output of financial dashboards, human resources, and logistics have been implemented with the Power BI tool.In the area of logistics, the output of the dashboard have been identified Optimal patterns in the use of Container loading and unloading equipment to the ship, Improving stops,... .in the area of the financials, the output of the dashboard have been implemented Profit and loss statements for 6 companies integrated and Implementation financial ratios,....in the area of the human resources, the output of the dashboard have been implemented Education per capita index, realization of planning.the tools have played a role such as Power BI, SSAS,SSIS, and SSRS.Tidewater : Having more than half a century of experience in providing port and maritime services, Middle East Tidewater Company is known as one of the largest and most powerful Iranian companies in this field.Website: http://tidewater.ir/

•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• Developed Personnel Tracker application: Actual-vs-Budgeted headcount, new hires, overtime hours, average sales per employee, hourly budgeted compensation, sales per man-hours and temporary labor spend, by region/branch• Developed Insurance Claim application: showing coverage type, claim, claimant, total paid, total incurred, by region, branch, and policy year.

Designing of business intelligence dashboard with Power BI software. The mentioned company works in the field of supply and production of medicine. Just like Daya Pharmed Company, first we designed and wrote KPI document by the data provided by the web services and then we designed the data warehouse to store the data received of the web services. Finally, we designed the dashboard with Power BI software.Website: http://www.darmanyab.com/

Kavosh Group companies consist of four specialized companies. The set of services provided professionally by each of the companies in the group, has created a complete portfolio of services required by individuals and organizations in the field of using new intelligent technologies , business intelligence systems ,new IoT solutions and advanced technologies .The main activities in this company were data warehouse design as well as dashboard design with QlikView and PowerBI.Website: http://kavoshgrp.com/

Like Alborz Insurance Company , Sarmad Insurance Company is operating in the field of insurance services. The main activity that has been done in this company is the design of insurance dashboards with QlikSense software and also the design of data warehouse.•Designing and Documenting production processes. Document data process life cycle and ETL processes.•Designing Data Mart and Data Warehouse.• Creating QVDs, from various data sources, for Qlik View/Qlik Sense.• Implementation Incremental Load• Creating streams and assigning user access• Developed Insurance Claim application: showing coverage type, claim, claimant, total paid, total incurred, by region, branch, and policy year.Website: https://sarmadins.ir/

I have been teaching qlikview,qliksence since 2015.Instructor of business intelligence courses at Faratar az Danesh institute.Teaching Power Bi, Qlikview, QlikSense and SQL Server Reporting Service coursesWebsite: http://fad.ir/

Responsibilities include the development and performance of database systems for client Strategic management systemDatabase servers infrastructure improvementDatabase security improvementDefine enterprise-level standards (coding, architectural, migration), platform and tool selection.

• Designed and Implemented Dashboard for management of Arash holding (13 companies) in the year 2008 • Designed and Implemented Dashboard for management of Asiatech Co. (BI) in the year 2009