Ashraf Khalil

Background

About Ashraf Khalil

I’m a Business Intelligence (BI) professional with over 9 years of expertise in end-to-end BI solutions, working with tools like SQL, SSAS, Azure, Python, Tableau, and Power BI. I'm passionate about creating interactive, insightful reports and dashboards that bring data to life, using a range of visualizations and advanced DAX expressions to support better decision-making. In addition to my BI skills, I've successfully led data migration projects, notably migrating data from Netezza to Oracle databases, showcasing my ability to manage complex data transitions. My skills encompass traditional user case-based analysis, with deep knowledge in T-SQL, Oracle PL/SQL, and Netezza. I construct tables, joins, views, indexes, stored procedures, and functions for efficient data manipulation. My experience extends to data modeling, governance, and visualization across enterprises, working closely with business users to translate their needs into data-driven solutions. Additionally, I have hands-on experience with Azure transformation projects and ETL solutions using Azure Data Factory (ADF) and SSIS. My strong communication skills have been invaluable for gathering client requirements and leading development teams SKILLS: • BI STACK: SQL Server, SSAS, SSRS, Power BI, Azure • Data Modeling: Erwin, Database Diagrams • Data Visualization: Power BI, Tableau, Excel Power BI, Python • Source Control: Team Foundation Server (TFS), SharePoint • Cloud: Azure SQL, Azure Data Warehouses, Azure Data Factory • SDLC: Agile, Scrum, Waterfall • Languages: Java (Intermediate Level) • Database: SQL Server, Azure SQL, Oracle PL/SQL, Netezza • Business Analysis: Requirement Gathering, User Case Analysis • ETL: SSIS, Azure Data Factory, Alteryx • DAX Expressions: Power BI, SSAS (Tabular), M • Data Quality: Data Profiling, Data Validation • Reporting: SSRS, Power BI, Tableau, Python • Collaboration: Cross-functional Teamwork, Communication Skills