Summary
Overview
Work History
Education
Skills
Timeline
Generic

Keith Hill

Magnolia,DE

Summary

20 years of problem-solving experience, troubleshooting code, error in data, errors or gaps in processes and identifying possible risk in process and mitigating or eliminating the risk. 15 years of SQL query writing writing complexed queries to extract data from Teradata and oracle databases. 10 years of software testing, migrating data from legacy systems to new system, working with developer testing data, creating requirements and documenting result and insuring projects are on schedule for completion by the projected deadline. 5 years using SSRS to design reports such as sales reports, client contract reports, accounting statement reports. Microsoft Office Suite Excel, PowerPoint, Word, Microsoft Access, Publisher, SharePoint. VBA coding (create customized excel spreadsheets, and Access Databases). 7 years Tableau experiences creating customized interactive dashboards, showing trends, forecast, real-time stats as well historical data. 8 years of SAS experience creating automated reports that are linked to Oracle and Teradata databases that provide real-time or current stats and creating customize reports tailored to the business needs. Created SAS programs that Extract, format and load data into other platforms, such as excel, word, Access databases, Tableau. 15 years of conducting meetings and training with internal and external clients. 10 years of Assessment and Technical writing experience. Documented work processes, create procedures and streamline existing procedures for efficiency. Created reports with results of assessments. 15 years of corporate writing and responding, responding to customer complaints, Agencies and Lawyer inquiries regarding legal cases involving the company. Attentive and goal-focused brings successful approach to cultivating complex best practices to meet organizational and regulatory expectations. Detail-oriented focus on achieving expected outcomes. Enthusiastic hard worker with expertise in cultivating lucrative client relationships and implementing better processes and procedures. Dedicated Consultant bringing dynamic skills in client oversight, issue resolution, and presentation. Successful juggling multiple tasks and projects simultaneously. Excellent business knowledge within the field.

Overview

26
26
years of professional experience

Work History

Data Governance Consultant

Citibank
Newcastle, DE
10.2022 - Current
  • Responsible for production of monthly Critical Data Element (CDE) scorecards, gathering approvals, dispositioning red metrics, and archiving documents for audit
  • Partnering with data consumers and tech owners to establish scope of request and gather/review CDE data and metadata including profiling to ensure data is fit for purpose
  • Working with technology team to test CDE rules before implementation
  • Gathering approvals from both consumer and technology teams for CDE registration
  • Registering CDE data and metadata in an Enterprise Chief Data Office (ECDO) tool known as Collibra
  • Submitting change control documentation to the ECDO including approved profiling and test scorecards, as well as any other necessary requirements in support of the registration process
  • Organizing and archiving required audit artifacts for future retrieval and reference in support of audit
  • Ensuring tech teams add new rules accurately to the monthly scorecard
  • Effectively tracking data quality exceptions working to properly disposition against defined SLAs
  • Responsible for quality control of own work

Data Steward/ Data Intelligence Specialist

Truist Bank
Charlotte, NC
08.2021 - 10.2022
  • Used Informatica tool to trace the Metadata lineage of source tables, fields (columns, CDE’s, DDE’s and applications) from source to destination
  • Reviewed metadata at a file, table and field level to identify and gaps and understand the dataflow/Pipeline from end to end
  • Traced Metadata lineage from source to output
  • Created visualization with Tableau Dashboards to support the attestation at Data element level/Critical Data Element Level
  • Gathered requirements from the stakeholders and building visualizations via PowerPoint, Tableau, Excel and SAS
  • Designed/created databases with relational tables in MS SQL Server and MS Access to store data received from stakeholders
  • Wrote SQL code to perform ETL functions to load data into database tables and connecting the database to Tableau to create interactive Dashboards for stakeholders to view
  • Reviewed existing SQL code and look for ways to refine it to make more efficient also create new queries to support the business needs
  • Reviewed manual process and identify gaps and look for ways to automate the processes using SQL code
  • Created mapping documentation which shows the relation between the table fields to the application fields in a system
  • Linked data lineage to data quality and business glossary within the overall data governance program
  • Extensive experience in implementing metadata, Business Glossary, Data Lineage and data quality
  • Created a repository to capture reference data that provides a single source location for the systems reference data and a gate way for other applications to access
  • Worked with the Enterprise Data team to implement the MDM initiative and Global data repository
  • Converted business processes, domain specific knowledge, and information needs into coherent, and effective overall data architecture including conceptual, logical, and physical data models
  • Maintain data lineage and support root cause analysis and impact assessment on data
  • Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validated static and dynamic data for data validation
  • Communicated effectively across multiple platforms and departments by performing various QA tasks and evaluating workflow
  • Aligned with Agile Methodologies, scrum stories, and sprints in a Python-based environment in association with data analytics and Excel data extracts
  • Create Data flow diagrams and Data lineage Documents for our schemas in our Data Warehouse
  • Create SQL queries and pull Ad-hoc data for our client
  • Hold meeting with upper management to provide status of ongoing projects
  • Created user technical guides and procedure guides documenting the system and how it functions
  • Used Power BI to design and build dashboards used to monitor performance metrics
  • Utilized: advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards
  • Triage incoming email request from our clients sorting, prioritizing, responding delegating the email to the correct department on our team
  • Created, updated and published website pages using SharePoint
  • Troubleshooting system generated error messages from our database and resolving the issue; example: reviewing stored procedures, ETL, files in file locations, finding the root cause and resolving the issue or forwarding the issue to the correct departments
  • Submitted Service request tickets to fix errors
  • Created Dashboards using Tableau also maintaining, updating the dashboards
  • Meet with clients to gather requirements from our clients and creating Features, User-stories, task for our team to complete
  • Agile Mythologies
  • Created process documents for processes our teammates perform

Data Governance Specialist

Discover Financial Services
New Castle, DE
04.1999 - 08.2021
  • Developed and maintained Data Quality Metrics / KPIs reporting and monthly Material Master Data Governance Forum minutes
  • Successfully designed and built the Data Governance Program office and Data Governance Program by raising improvement opportunities and preparing users related to system enhancements, automation, and new Data structure / data integration
  • Extracted, compiled, and interpreted data relevant for periodic metrics and reporting needs
  • Spearheaded and created MDM projects for data efficiency by minimizing master data management costs, implementing automation, and digitalizing the processes
  • Managed complex portfolio of projects with master data implications while ensuring priorities were defined and deadlines were achieved within the business
  • Charged with upholding global master data governance process and developing / managing process improvement initiatives and projects
  • Commended by leadership for improving data quality and reducing manual data entry errors​
  • Led regular consultations with other functions to evaluate Data needs and recommended improvement projects
  • Partnered with leadership across the organization to identify business needs for data governance and implement data governance capabilities and processes
  • Led the community of Data Governance Specialist, coordinated efforts across the system, and obtained appropriate involvement from support organizations
  • Supported for analysis and evaluation of data mining in a data warehouse environment, which included data design, database architecture, and metadata and data governance in oracle environment
  • Performed extensive system analysis to design data model which helped in loading data from multiple data sources
  • Linked data lineage to data quality and business glossary work within the overall data governance program
  • Involved in defining the source to target data mappings, business rules and data definitions
  • Performed data integrity testing by extensive use of SQL queries and executed backend testing
  • Wrote SQL queries for checking the Data Migration, Data transformations and Database Integrity in Teradata
  • Data Validation to check for the proper conversion of the data
  • Data Cleansing to identify bad data and clean it
  • Involved in building data lineage in IBM Infosphere IGC for data comparison across source system, MDM, Enterprise data platform, Reference Data Store, Data Lake
  • Extracted and loaded the metadata from disparate source systems into MM warehouse using Informatica metadata manager packaged models as well as custom models and create data lineage among these systems

Education

Bachelors - Computer Science

Kaplan University
10.2024

Skills

  • Database Management
  • Data Management Oversight
  • SQL Data Retrieval
  • Data Visualization
  • Reporting Tools (SSRS, Tableau)
  • Programming (VBA, SAS)
  • Metadata Management
  • Data Interpretation
  • Quality Assurance
  • Project Management
  • Agile Methodologies
  • Disaster Recovery Planning
  • Failure Analysis
  • Management Coaching
  • Cost Analysis
  • Timeline Development
  • Client Requirements Assessment
  • Employee Management
  • Reporting writing

Timeline

Data Governance Consultant

Citibank
10.2022 - Current

Data Steward/ Data Intelligence Specialist

Truist Bank
08.2021 - 10.2022

Data Governance Specialist

Discover Financial Services
04.1999 - 08.2021

Bachelors - Computer Science

Kaplan University
Keith Hill