fady roufaeil

Senior Data Analyst

• Job Details:Collaborated closely with internal auditors to define audit requirements, identify risks and controls, and determine the data sources needed for testing. Developed testing plans to ensure audit objectives were met. Built and maintained strong relationships with data management teams, data stewards, and IT specialists to acquire necessary datasets and ensure access to source systems and data dictionaries. Utilized Dataiku to upload, clean, and prepare data, and developed SQL queries to test data validity, completeness, and compliance with bank procedures. Designed and implemented Tableau dashboards to visualize audit results, highlight data exceptions and anomalies, and train the business users on dashboard usage and generating random samples. Conducted SQL code reviews for reports generated by various bank teams, providing analysis on the accuracy and reliability of the queries and reports. Conducted research and explored multiple databases to extract the necessary information for stakeholders. Contributed to the development and automation of data quality checks to ensure accuracy and consistency across audits, identifying opportunities for process improvements.

Senior Business and Technical Analyst

• Job Details:Conducted technical reviews of SAS programs for the global AML transaction monitoring team, comparing results with rule documentation to ensure compliance and accuracy. Collaborated with analytics managers and auditors to gather analytic requirements and developed solutions using SAS, SQL, and Teradata SQL Assistant. Partnered with cross-functional teams to gain access to critical databases and understand the relationships between tables and views in complex data systems. Gathered and documented audit requirements to provide tailored technical solutions for acquiring the necessary data for auditing purposes. Served as a subject matter expert on RBC data sources, offering training and support to business users on data systems and analytics tools.