Pargol Asghari

Experience

• 

  EFarda Company

  Mar 1394 - Mar 1395

  Data Analyst

  - Create routine reports in excel and presenting to managers.- Tracking KPI's and looking for the reasons for the decrease and increase.

• 

  Shopp

  Mar 1395 - Jan 1396

  Data Analyst

  - Create Dashboards which importing flat files like excel source type.- Learn to write queries in SQL server.- Interacting with the business and managers on requirement gathering, understanding the business and functional requirements.- Create routine reports to managers with high working in excel.- Create forms in excel and access to meet the needs of employees.

• 

  Omid Computer Services

  Sept 1398 - Jul 1400

  Business Intelligence Developer

  - Using the SSIS tool for extracting, cleaning, transforming and loading data into data warehouse with various sources like Flat Files, SQL server and Oracle.- Create new facts at least 1 billion records.- Create various dashboards for all departments which was effective in making decisions.- Using Multi Dimensional SSAS Tabular for connecting data to dashboards.- Create new paginated reports in report builder.

• 

  Digikala.com

  Aug 1400 - Jul 1402

  Business Intelligence Developer

  - Developed ETL processes to extract data from multiple sources and transform the data into a single, integrated source with stored procedures in SQL server based on Change Tracking and Timestamp method.<br>- Create, redesign and refactor facts at least 850 million records.<br>- Create new method for process partitions dynamically in SSAS Tabular.<br>- Create reports in report builder which connected to SSAS tabular.<br>- Help others to write queries with high performance and Create indexes on the tables.<br>- Create the data model which extracts important measures from existing cubes to new cube with high performance.<br>- Create new measures in SSAS Tabular with DAX.<br>- Monitor performance of the cubes in DAX Studio.<br>- Concentrate to write high performance queries with regarding execution plan by creating new indexes or using existing indexes.<br>- Help others to create dashboards in POWER BI. نمایش موارد کمتر

• 

  Snapp!

  Aug 1402 - now

  Business Intelligence Developer