kh med nour

• Built a .NET Core Web API and Angular app for real-time decisions, processing millions of data lines. • Optimized performance with load-on-demand features boosting data speed and decision-making for datasets. • Modeled data warehouse structures with SSIS, staging millions of data sources, enhancing storagel, to optimize decision support systems . • Engineered OLAP cubes in SSAS to create an analytical environment, as an entry point in the application, and managing data over time with100% historical.

• Developed STEROS Lab modules with C#, .NET MVC and SQL Server, aligning with healthcare standards, and enhanced collaboration with a team of 3 developers using SVN for version control. • Documented scenario in Redmine, calculating task completion time as an optimal efficiency KPI. • Analyzed code with SonarQube to maintain quality, achieving 70% secure and clean code.

• Developed MDX Query Builder tool with .NET, replacing the company’s existing KPI visualization system, and enables account managers to track trends and patterns in millions of customer data. • Designed a pivot table using HTML, Kendo UI, jQuery for flexible KPI analysis, ensuring optimal query efficiency with SQL Server Profiler. • Created a report module with LINQ, cutting report duplication by 100%.

• Developed a WPF application with .NET, C# and SQL, enabling 50% independent OLAP Cube management, reducing data engineer SSAS intervention time and enhancing data warehouse efficiency. • Integrated data sources into the warehouse with SSIS, achieving 100% integration with developed BI tool and boosting the efficiency of data structuring for analytics within the company. • Visualized analysis environment data with POWER BI for actionable insights and informed decision.