Data Analyst
- 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.
- 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.
- 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.
- 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.
Sep 2021 - Apr 2024
