Adil Khan Email & Phone Number

● Used SQL queries to connect to different databases and extract relevant financial and customer data, employing features like joins, subqueries, and filtering to gather comprehensive datasets.● Utilized Power Query to create report measures by transforming and aggregating data, leveraging features such as merging, appending, and grouping to generate meaningful insights for reporting purposes.● Prepared, edited, and executed SQL scripts within SSMS to perform various tasks such as data manipulation, schema changes, and database maintenance, utilizing features like query execution plans and script debugging for optimization.● Transformed data using SQL Server by performing tasks such as data cleansing, normalization, and enrichment, employing features like data types, constraints, and transactions to ensure data integrity and accuracy critical for risk assessment, fraud detection, and customer segmentation.● Developed interactive dashboards and reports in Power BI and Excel by connecting to SQL Server databases and transforming SQL-derived data into visually appealing visualizations, utilizing features like slicers, filters, and drill-downs for interactivity and real-time insights.● Ensured data and report compliance with banking regulations by generating regulatory reports using SQL queries to extract and aggregate data, and creating compliance reports in Power BI.

● Utilized SQL and Python for data extraction, transformation, and analysis, improving financial model accuracy and enhancing data retrieval efficiency.● Demonstrated proficiency in Excel (using functions like VLOOKUP, pivot tables, and data validation) and Python (employing libraries such as Pandas and NumPy) for data manipulation and cleansing.● Achieved high data accuracy and integrity, saving significant time in data preparation through efficient cleaning processes.● Created interactive dashboards and reports in Tableau, reducing reporting time and contributing to a decrease in policy cancellations.● Provided actionable insights from SQL analysis, Excel data manipulation, and Tableau visualizations, improving decision-making speed.● Managed and analyzed large datasets using SQL and Python, showcasing the ability to handle complex data environments.● Developed interactive dashboards and reports in Tableau to visually represent insurance trends, claims patterns, and risk profiles.