Data Management Wells Fargo
Resume:
MARK JERNIGAN
Gastonia, NC *****
***************@*****.***
OBJECTIVE: To obtain a Data Management Analysis position, analyzing and Validating metadata flow back to the system of origin.
SUMMARY: Enterprising, hard-working and technically skilled Data Management Professional with Five plus years of experience working with Business and Technical Metadata validation. Tracking and Validating data lineage back to system of origin., formatting and analyzing large data from various data sources. In addition to solid skills working Application Business Owners and Technical Managers.
EXPERIENCE:
July 12, 2023 – May 14, 2024 – Wells Fargo - Consumer Savings Banking Business Dept – Data Lineage Team:
Documented and validated Metadata data flow from system of origin to source application
Worked with Application Business Owners (ABO) and Technical Managers (TM) to document source Applications system approval within System of record
Maintained, and validated the Metadata integrity of Data Dictionaries for Regulatory Reports
Prepared Attestation Documentation for Sanction Screening for Key and Standard Sourced Applications
Responsible for Documenting metadata lineage from system of record to source application
BSA\AML documentation and validation of source applications
MRA documentation and validation of source application and metadata from system of record
February 2022 – July 12, 2023 – Wells Fargo - Data Management & Insight Team:
Created Data Dictionaries for FFIEC 031, FR 2052a, and FR Y14Q Regulatory Reports
Updated and maintain Regulatory Reports data artifact documents
Worked with Physical Data Element team to document PDEs for Data Dictionaries
Worked closely with Report Owners to resolve Data Dictionary Data Element issues
Worked with QA team to resolve issues with Data Dictionary to facilitate final approval of Report
Compared High Level Data Maps to Data Dictionary to validate Physical Data Elements
Trained new staff on documenting data elements and data elements description for Regulatory reports
August, 2021 – January, 2022 – Wells Fargo, Unclaimed Property Team – Business Support Consultant
Managed unclaimed property mailbox
Directed emails to correct team member for research using PAC2000
Assisted Management with special projects, such as PAC2000 to PEGA migration
October, 2019 – March, 2021 - Press Ganey – Data Specialist, Charlotte, NC
Worked closely with Analytic and Research team to validate and identify data sources
Participated in data response manipulation process to properly group respondent data
Assisted in creating metrics and norms utilizing national standards and averages within employee engagement survey
Completed calculations using large data sets, data manipulation, recoding, assembling data sets and data entry
April, 2019 – October, 2019 – Wells Fargo – Data Management & Insight, Charlotte, NC
Report Mapping & Issue Identification (RMII) Team – Business Support Consultant
Remediating issues for reporting to audits (external and internal) and Shared Risk Platforms
Documenting risk reports across enterprise
interpreting data flow diagrams, and data narratives and control documentation
Assist with making changes to documentation and validating changes are sufficient – document examples include RCIs (Risk Control docs) and desk top procedures docs
Using MS Visio to create Data Flow and Data Narratives
Partner with report document leads on making changes as needed
Ensure documents meet all minimum requirements
November, 2018 – March, 2019 – Bank of America – Charlotte, NC
LoanIQ Recon Team – Contractor,
LoanIQ Ledger to sub ledger reconciliation
Generated MIS Reporting for LoanIQ Break tracking
Researched and resolved LoanIQ Interest and Principal break
Updated LoanIQ break tracking report
Used Excel (vlookup, and Pivot Tables) to reconcile and compare data
June 2017 – May 31St, 2018 – Wells Fargo & Co. – Charlotte, NC
Wholesale Finance Group – Contractor,
Processed GL adjustments via Adjustment Layer of regulatory reporting system
OBIEE Data mapping and comparison for Regulatory Reporting System
OBIEE variance research and data quality validation to GL
Solicited and documented requirements from IT team to get key data fields included in e-One\OBIEE Regulatory Reporting system.
Served as liaison between IT team and Group controllers to document process and requirements for e-One\OBIEE.
July, 2016 - June, 2017 – Wells Fargo & Co. – Charlotte, NC
International Finance Team – Contractor.
Responsible for extracting, reconciling and validating Data from Wells FACS Database using MySQL\SQL queries
Perform UAT test, in test region, to confirm the data reconciles to GL
Data extraction, Analysis and financial reporting generation
Big Data extraction and validation to SOR (LoanIQ, AFS)
Created Data Dictionary for each query created
November, 2015 – February, 2016 –Bank of America – Charlotte, NC
Balance Sheet Management Team –Contractor.
Responsible for conducting general ledger (GL) reconciliation and other data analysis to investigate, and quantify input data used in capital modeling group.
Data extraction and comparison using SQL (Toad App) and Excel
April, 2013 – November, 2015 – LPL Financial – Charlotte, NC
Sr. Operation Analyst – Position Recon Dept.
EDUCATION: Associate of Arts Degree in Business from Western International University
System Experience: ADMF, EMH (Element Metadata Hub), BAM, PEGA, PAC2000, Salesforce, eOne, Beta, eledger, SQL Queries, Bloomberg, Frontier, DTC trading system, Beta System, Global plus System, DST-Vision, MS-Project, MS-Excel, and MS-Access.
Contact this candidate