Karim Mohamed Diab

Bi DeveloperFull Time

• Job Details:Project 1: o Client: National Anti-corruption Commission, Nazaha. Onsite: Riyadh, Saudi Arabia. o One month contract to implement a project for the Nazaha government agency in Riyadh, Saudi Arabia. o Analyze data from 11 databases, assess data quality, and gather user requirements. o Evaluate the feasibility of a Data Warehouse (DWH) and define SSIS-based ETL process requirements. o Recommend a secure data model for the organization. o Design and develop SSIS ETL workflows to integrate and transform data. o Document the Data Warehouse (DWH) and define specifications for Power BI dashboards. o Set up Power BI Report Server for enterprise-wide reporting. o Prepare comprehensive project documentation and planning. Project 2: o Client: Mohammad Al Habib Real Estate, Remotely - Saudi Arabia. Tools: Power BI, Excel, Figma. o Developed a Power BI dashboard for real-time tracking of project budgets and financials, o Upgraded static Excel reports to dynamic, visually rich Power BI dashboards with interactive charts, o graphs, and maps for better data exploration. o Created interactive dashboards with key metrics and drill-through capabilities. o Automated data updates, improving accuracy and efficiency in reporting. o Implemented access controls and designed a user-friendly interface for enhanced decision-making and transparency.

Bi DeveloperFull Time

• Job Details:o Collaborate with project teams to analyze, design, build, and test BI solutions. o Translate business requirements into technical specifications. o Used Alteryx as a primary tool for data transformation, report generation, and analytics. o I worked with Data Factory to design, develop, and maintain data pipelines for seamless data integration between systems, including transforming data from API to Snowflake. o Develop and maintain ETL processes using SSIS (SQL Server Integration Services) to ensure efficient data workflows. o Optimize data processing performance and scalability to efficiently manage large datasets. o Apply SQL expertise to create robust data solutions and resolve technical challenges. o Develop and maintain business intelligence (BI) solutions using Data Factory, Alteryx, Power BI, Google Looker Tableau, and SSAS (SQL Server Analysis Services). o Create dynamic, real-time dashboards and visualizations in Power BI to support data-driven decision-making. o Utilize SSRS (SQL Server Reporting Services) to design and generate detailed reports for stakeholders. o Analyze large datasets to identify market trends and deliver actionable insights. o Document ETL processes, data mappings, and data lineage for transparency and traceability. o Stay updated with the latest ETL tools and technologies, recommending improvements to enhance data workflows.