AYDA GHAZI-ZADEH

• Successfully leveraged Azure Data Factory and Azure Synapse to streamline data processing and analysis.

• Designed and implemented efficient data lakes and data warehouses to improve data management and reporting.

• Played a key role in optimizing Power BI data models, facilitating more insightful and interactive data visualization.

• Demonstrated expertise in data integration, transformation, and consolidation from diverse data sources.

• Proficiently managed multiple databases, including enterprise ERPs and various APIs.

• Ensured data security and confidentiality in Power BI through implementation of Role-Level Security (RLS).

• Spearheaded automation of critical data processes, reducing manual efforts and improving data accuracy.

• Collaborated closely with frontend developers to define and align business requirements for data-related projects.

• Conducted SHIR configurations to enhance data processing capabilities and data accessibility.

Create an "Energy Management Dashboard" that provides valuable insights into the company's maintenance operations data.

• Analyze raw operational data, including energy production, consumption and distribution data.
• Develop data Models using PowerBI's data modeling capabilities and establish relationships between various data sources and parametrize connection strings.
• Design visually appealing dashboards, considering company's main metrics, KPIs and reporting requirements for different aspects of business data:

- Energy Production Dashboard: Visual representation of the company's energy production, displaying key metrics such as total energy generated, energy distribution, and trends over time.

- Generation Efficiency Dashboard: Design KPI visualization to track the efficiency of power generation such as capacity utilization rate, energy loss percentages, and comparisons to industry benchmarks.

- Consumption Analysis Dashboard: Analyze energy consumption patterns over time, identifying peak hours or seasons including granular data to drill down by geographical regions, customer segments, and specific timeframes.

- Outage Monitoring Dashboard: Implement a near-real-time monitoring system to track power outages. Create a map-based visualization that shows outage locations and durations.

• Analyze, design, develop and maintain technical solutions in Azure using data warehouse technologies, including Azure Data Factory, Data Lakes, Azure SQL DB, Azure Logic Apps
• Develop Power BI reports with data models, visualizations, analytics, metrics (KPIs) and dashboard that provide data insights across multiple areas of the business
• Maintain Organization's Power BI Reporting portal, app and Dashboards Troubleshoot and resolve complex data issues for the business
• Deploy and maintain BI solutions including Azure and old solutions (SSIS, SSRS, SSMS)
• Day to Day monitoring, support, and health checks Conduct data validation processes
• Develop and update technical documentation
• Support ad-hoc requests for data & visualization when required

• Review and document high volume of monthly expenses within a very tight deadline
• Process invoices and manage accounts payable Monthly expense reports and analysis
• Reconcile credit cards and calculate intercompany transfers Process new employee's coordination including setup computers

• Effectively communicate with stakeholders to gathering the requirements, needs and functionalities for customizing the ERP system
• Understand relevant level impacted by ERP system, including company's processes, reporting requirements and user interface
• Customize and configure workflows to allow integrations of company's IT environment to elicit, analyze, and record required functionality and non-functionality requirements to ensure success of the project development
• Developed T-SQL scripts & commands, Prepare configuration and test codes
• Provide weekly project progress reports to the project manager Provide end-user training for the product module
• Utilized entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, defaults, and complex SQL statements