● Monthly analysis of the Iran pharmaceutical market .● Analysis and calculation of market indecators and competitors analysis such as sales growth and ... ● Analyzing production line indecators● production capacity analysis● Creating and developing dashboards using Power BI and Tabular SSAS● Creating optimal models in SSAS Tabular, creating optimal Measurs with highest speed using DAX● Using ETL Tools (SSIS) to develop jobs for extracting, cleaning, Transforming and… Show more ● Monthly analysis of the Iran pharmaceutical market .● Analysis and calculation of market indecators and competitors analysis such as sales growth and ... ● Analyzing production line indecators● production capacity analysis● Creating and developing dashboards using Power BI and Tabular SSAS● Creating optimal models in SSAS Tabular, creating optimal Measurs with highest speed using DAX● Using ETL Tools (SSIS) to develop jobs for extracting, cleaning, Transforming and loading data into data warehouse● Creating SQL Queries to load less data inside the model instead of loading the entire data in the model to optimize the data update and lighten the model Show less

Mainly involved in ICT Department of fifth largest shoping mall in the world.● Develop and deploy Power BI Dashboards for Iran Mall Co to represent retail sell metrics utilizing SSAS Tabular to develop measures, dimensions, and business critical KPIs from relational data warehouse and building complex DAX and SQL(T-SQL, PL/SQL) Queries. ● Developing ETL for Data Warehouse using SSIS packages to extract data from ODBC and OLEDB data sources such as Access, Excel and SQL SERVER to perform… Show more Mainly involved in ICT Department of fifth largest shoping mall in the world.● Develop and deploy Power BI Dashboards for Iran Mall Co to represent retail sell metrics utilizing SSAS Tabular to develop measures, dimensions, and business critical KPIs from relational data warehouse and building complex DAX and SQL(T-SQL, PL/SQL) Queries. ● Developing ETL for Data Warehouse using SSIS packages to extract data from ODBC and OLEDB data sources such as Access, Excel and SQL SERVER to perform the transformation, cleansing and loading into the data warehouse .●Work with various Team Members, internal departments and third party agencies on report business requirements, documentation, timelines, testing, and technical delivery● Manage and maintain database of integrated retail stores using SQL SERVER and TSQL● working with Data, Databases and ETL processes and tools● Design Business Intelligence Dashboards using Power BI and QlikView to represent each retail store sale and prediction of future using Regression Linear methode. Show less

● Familiar with business KPI and Design BI Dashboards using Qlikview based on business KPI● Gather and Analyze business requirements for designing, developing, testing & migrating QlikView applications .● Design and Development of QlikView visualization dashboards using complex expressions, developing ETL for Data Warehouse set analysis, and multidimensional objects .● Develop dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes… Show more ● Familiar with business KPI and Design BI Dashboards using Qlikview based on business KPI● Gather and Analyze business requirements for designing, developing, testing & migrating QlikView applications .● Design and Development of QlikView visualization dashboards using complex expressions, developing ETL for Data Warehouse set analysis, and multidimensional objects .● Develop dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes, Scatter charts,Bar charts, Pivot Table, Straight Table, Containers.● Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server and MYSQL.● Involve in analyzing the data and defining Key Performance Indicators (KPI).● Building QVD’s from different data sources like SQL Server, Excel, CSV and Flat Files. ● Automate and schedule daily data refresh process of QVW documents using QlikView Publisher and QMC.● Develop three layered architecture which involve data extraction layer to fetch data from sources and store as QVD’s , transformation layer to build the data model and finally building dashboard layer.● Configuring QlikView Automatic reload processes and Increase data loading speed using QVD making.● Install and Maintenance enhancement of QlikView Servers to Configure autonomous and dynamic reporting interfaces to be distributed to stakeholders . Show less

Mainly involved in IT Department of largest automative parts manufacturer in Iran. ● Sharepoint power user● Analysis of business process and automating them using design Sharepoint Workflows● Design Sharepoint Forms and Workflows using NintexWorkflow , PowerForm and Infopath Designer● Knowledge of Web Parts, SubSites, Site Permissions & CAML Queries● Design Sharepoint Sites using Sharepoint Designer● Software Web Development usign C# ,ASP.NET and SQL SERVER