Mahdieh Dianati
Summary
- 7 years of work experience in Business Intelligence
- Skilled in Microsoft SQL Server, SSAS, SSRS, Microsoft Power BI, Business Analysis, Data Modeling, Data Warehousing, Relational Databases
- Deploying more than 10 Business Intelligence projects
- A critical thinker and innovator, able to play a key role in analyzing problems and coming up with creative solutions.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst & Business Intelligence Specialist
System Group
01.2018 - 08.2022
Responsibilities:
- Data Analysis and Business Analytics in various industries and companies
- Data Preprocessing and Data Cleaning
- Gathering data from different data sources (databases, excel files, …)
- Developing Data warehouse and Data Cube
- ETL
- Design and implement customized modules attached to the ERP system
- Developing Database Systems
- Data Visualization using BI tools such as Power BI
- Project management
Impacts:
- Deployed 12 BI projects for various companies and industries
- Example: Mahak Charity, Knauf Iran,
- Sharif University, Mahan Meat Co, Pension Fund of IRIB, etc.
Awards:
- Two of my projects were selected as outstanding BI projects which have been published as success stories on the System Group's website:
- Knauf (K+)
- Pension Fund of IRIB
Business Intelligence Expert
Coca-Cola
04.2015 - 12.2017
Responsibilities:
- Creating reports using SSRS, Excel (e.g., daily reports, monthly reports)
- Business Analysis for sales team (e.g., sales target defining, sales region)
- Define and Measure Key Performance Indicators for sales (KPIs)
- Business Process Analysis for deploying Enterprise Resource Planning (ERP)
- Deploying Business Intelligence (BI)
- Deploying Educational Management system
Impacts:
- Creating organized excel files for daily and monthly sales reports
- Involved in deploying ERP for 5 branches
- Deploying BI
- Deploying Educational Management system
Awards:
- I got promoted from Report Analyst to Business Intelligence Expert after one year of working
Education
PhD - Virtual Reality in Mineral Processing
University of Nevada
M.Sc. - Industrial Engineering-System Management &Productivity
Payame Noor University International Center of Kish
02.2020
M.Sc. - Mineral Processing Engineering
Yazd University
02.2014
Bachelor's Degree - Mining Engineering
Yazd University
09.2011
Skills
- Professional Skills & Software
- Microsoft Excel, Power point, Word, Outlook
- Microsoft SQL Management Studio
- SQL querying
- Microsoft SQL server Reporting Services
- Microsoft SQL server Analysis Services
- Data Warehousing (Kimball & Inmon Approach)
- Machine Learning and Statistical learning
- Rapid Miner
- Python Programming
- SAS
- Data Visualization Tools (eg, Power BI)
Certification
- Machine Learning by Python, System Group Education Center, 2019
- Data Warehousing, System Group Education Center, 2018
- Advanced SQL Querying, System Group Education Center, 2020
- System Analysis and Design System Group Education Center, 2021
- Python Programming, Sololearn, 2022
Languages
English
- IELTS Score 6.5 (Speaking 7, Listening 6.5, Reading 6, Writing 6)
- GRE 309 (Quantitative 161, Verbal 148)
Timeline
Data Analyst & Business Intelligence Specialist
System Group
01.2018 - 08.2022
Business Intelligence Expert
Coca-Cola
04.2015 - 12.2017
PhD - Virtual Reality in Mineral Processing
University of Nevada
M.Sc. - Industrial Engineering-System Management &Productivity
Payame Noor University International Center of Kish
M.Sc. - Mineral Processing Engineering
Yazd University
Bachelor's Degree - Mining Engineering
Yazd University
Similar Profiles
Alan WHITEAlan WHITE
Mechanical Maintenance Technician at System GroupMechanical Maintenance Technician at System Group
AJIBOLA ATILOLAAJIBOLA ATILOLA
Student Worker at System GroupStudent Worker at System Group
Jerry DunawayJerry Dunaway
Director of Business Development at Allen System GroupDirector of Business Development at Allen System Group
Ashna VilliyathAshna Villiyath
<p > <b>Data Analyst- HR Intelligence & People Analytics</b> </p><p > Gargash Group </p><ul > <li > Responsible for identifying, designing and performing complex analyses and make recommendations on complex HR issues in partnership with the Head- HR Intelligence & People Analytics. </li> <li > Providing training to internal/external stakeholders on data interpretation, data evaluation, statistical and analytical techniques. </li> <li > Design and develop useful metrics, dashboards, analyses and data reporting to support variety of HR and business initiatives. </li> <li > Develop, prepare and analyze metrics to measure effectiveness of business outcomes. </li> <li > Produce clear, concise reports and/or presentations. </li> <li > Develop and prepare charts, tables, and other related documents and graphics. </li> <li > Manage multiple simultaneous work streams. </li> </ul> at Gargash Group<p > <b>Data Analyst- HR Intelligence & People Analytics</b> </p><p > Gargash Group </p><ul > <li > Responsible for identifying, designing and performing complex analyses and make recommendations on complex HR issues in partnership with the Head- HR Intelligence & People Analytics. </li> <li > Providing training to internal/external stakeholders on data interpretation, data evaluation, statistical and analytical techniques. </li> <li > Design and develop useful metrics, dashboards, analyses and data reporting to support variety of HR and business initiatives. </li> <li > Develop, prepare and analyze metrics to measure effectiveness of business outcomes. </li> <li > Produce clear, concise reports and/or presentations. </li> <li > Develop and prepare charts, tables, and other related documents and graphics. </li> <li > Manage multiple simultaneous work streams. </li> </ul> at Gargash Group
Ismat M JamalIsmat M Jamal
Business Intelligence, Commercial Advisor, Business Analyst, Data Engineer, Financial Analyst at Abdul Latif JameelBusiness Intelligence, Commercial Advisor, Business Analyst, Data Engineer, Financial Analyst at Abdul Latif Jameel