Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Melat Elfagid

Lawrenceville

Summary

Results-driven auditing professional with extensive experience in evaluating internal controls and risk management. Known for strong analytical skills and attention to detail, ensuring compliance with industry standards. Collaborative team member with focus on achieving organizational goals and adapting to dynamic environments.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Internal Auditor – Global Risk Management

Bank of America
08.2022 - Current
  • Complete assigned data analytics tasks using department tools, standards, and guidelines.
  • Reach audit conclusions based on data analysis.
  • Maintain documentation of analysis conducted to support audit conclusions.
  • Assist with IT-related internal audits and testing of internal controls over financial reporting to ensure compliance with Sarbanes-Oxley (SOX) 404.
  • Actively participate in global initiatives aimed at improving Internal Audit’s processes and procedures.
  • Proficient working knowledge of SQL, SAS, Python, Excel and Tableau and skills to perform data analysis/test automated controls.
  • Good knowledge of Internal Audit process and regulatory structure of financial services and banking industry and current regulatory guidance.
  • Specific subject matter expertise regarding data management control disciplines and a solid understanding of Enterprise Risk Management concepts, especially those associated with in the Operational Risk Management.
  • Perform data discovery and analytics using Alteryx, Tableau, R, Excel or other data analytics tools, with directions from team members.

Data Analyst II

Dover Corporation
02.2020 - 07.2022
  • Formulated and executed comprehensive data strategies to align with organizational goals, ensuring data quality, accuracy, and accessibility.
  • Managed a high-performing team of data analysts, data scientists, and data engineers, fostering a collaborative and innovative work environment. Provided mentorship and guidance to team members to maximize their potential.
  • Ensured the security and privacy of sensitive data by implementing robust data encryption, access controls, and data masking techniques.
  • Monitored and evaluated the performance of data systems and analytics models, making data-driven recommendations for improvements and optimizations.
  • Ensured data quality and integrity of Product Analytics database by validating data with Finance teams, CoHC Analytics teams, and other subject matter experts.
  • Lead a team of 8 data analysts to develop a self-service data solution for members of Marketing and Product teams.
  • Worked with Small Business Account Management, Sales & Billing teams to develop a member network disruption analysis, which helped SBM Account Management convert members to Trio products and reach retention target.
  • Kept abreast of emerging trends and technologies in the field of data and analytics, fostering a culture of innovation and continuous improvement within the team.
  • Conducted comprehensive competitive insights analysis for each Line of Business.
  • Lead the Data and Content team, developed and designed complex data pipelines for internal marketing, research and operations teams.
  • Conducted in-depth data analysis to identify trends, patterns, and insights. Utilized statistical modeling and predictive analytics to support business decision-making.

Database Administrator

Expedia Group
04.2019 - 01.2020
  • Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL workflows to populate fact and dimension tables, and developed Cubes and reports for analysis.
  • Developed complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
  • Troubleshooting and corrects production ETL issues.
  • Optimizing stored procedures, T-SQL, views, and functions for the best performance.
  • Refining and automates regular SQL processes, track issues, and document changes.
  • Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.
  • Developed complex database objects like complex stored procedures and complex UDFs.
  • Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
  • Developed script for data manipulation and ensuring data integrity.
  • Designed, developed and maintained a data warehouse.
  • Creating Tabular reports with SQL Server Reporting Services (SSRS).
  • Generating parameterized reports, drill down drill through reports.
  • Deployed reports, created report, schedules and subscriptions. Managing and securing reports using SSRS.

Education

Master of Science (M.S) - Data Science

University of Wisconsin – Eau-Claire
05.2022

Bachelor’s Degree - Management Information Systems

San Francisco State University
08.2018

Skills

  • IT Audit
  • IT Management
  • Information Asset Protection
  • IT System Implementation
  • IT System Development
  • Project Management
  • Python
  • PostgreSQL
  • Oracle
  • MS SQL Server
  • Hadoop
  • Trifacta
  • Alteryx
  • Tableau
  • SAS
  • MS Excel

Certification

  • Certified Information System Auditor (CISA)
  • CompTIA Security + (CompTIA)
  • Introduction to Data Engineering (Coursera)

Timeline

Internal Auditor – Global Risk Management

Bank of America
08.2022 - Current

Data Analyst II

Dover Corporation
02.2020 - 07.2022

Database Administrator

Expedia Group
04.2019 - 01.2020

Bachelor’s Degree - Management Information Systems

San Francisco State University

Master of Science (M.S) - Data Science

University of Wisconsin – Eau-Claire

Similar Profiles

CREATE PROFILE
Melat Elfagid