Data Science Machine Learning

**** ****** **** **** **, Acworth, GA – ***** 770-***-**** *************@*******.***

DAVID WILLIAMS - PH.D

PROFILE SUMMARY

EDUCATION

Northcentral University

Ph.D. - Data Science

Eastern University

M.S. - Data Science/Machine Learning

MBA. – Business Administration

Organizational Management/

Business Analytics

Wayne State University

Post Graduate classes in Artificial Intelligence, Database Management, and Software Engineering

University of Southern Mississippi

M.S. - Computer Science and Statistics

University of Michigan

B.S.E. - Aerospace Engineering

B.S.E. - Engineering Science

B.S. - Applied Math

DATA SCIENTIST / TERADATA DEVELOPER & TERADATA DBA

30 years of Teradata Experience AI Machine Learning Feature Selection & Engineering

A progress-focused professional with proven excellence in building data-intensive statistical models to help organizations/clients channel profitability. Drove actionable insights from large complex and multi-dimensional datasets, machine learning tools, and algorithms to help create and upgrade Teradata applications, and databases as per project requirements in compliance with business objectives. Skilled in data sourcing, migration, metadata development, processing, and visualization. I created innovative strategies for fixing bugs and implementing updates to troubleshoot architectural/scalability issues. Seeking an opportunity to use my data analysis and application development experience to support businesses and provide result-oriented solutions for optimizing internal workflow.

PROFESSIONAL EXPERIENCE

Teradata System DBA

Boeing - Contract April 2022 – Current

-Version upgrade to 17.20, Migration to VM, system problems, Sox reporting, Service Now tickets, work with Teradata CSR on hardware issues

-Mange Python scripts for ETL maintenance

-Gave presentations to Governance Board and Change Control Board on major changes

-Presented team training to team on Python and Data Science including statistics

-Migration and monitor VM system

Teradata Application DBA and Teradata System DBA

Bank of America – Contract (Accenture) – Remote Mar 2021 – Mar 2022

•Roll out, install, configure, and upgrade the Teradata software and applications in collaboration with Teradata Corp

•Manage workload in Viewpoint and adjust TASM settings and proactively monitor database systems performance to ensure secure services and minimum downtime

•Use data mover and BAR to migrate Teradata data and objects and establish and maintain backup and recovery procedures

•Set up and maintain standards and create documentation, users, tables, views, grants, and other

• objects

•Perform implementation and release of database changes and supported development teams by resolving SQL performance issues

•Developed standard database security assurance plans, solution design documents, and intake assessments to analyse the scope

CERTIFICATIONS & TRAINING

Teradata Special Encryption Project

Wells Fargo – Contract (Matrix) Remote Jul – Oct 2020

•Interacted with the Wells Fargo team to work on rectifying determined security threats and maintaining database security

•Defined and implemented roadmaps and techniques for root cause analysis, backup, recovery, and resolution.

•Applied algorithms and SQL for stored encryption procedures to secure transmitted digital data on the cloud/computer systems from cyber-attacks, malware, and ransomware

•Teradata 14 Certified Master

•Teradata V2R5 Certified Master

•Teradata V2R3 Certified Master

•Data Science Certification

REFERENCES

Data Analysis

M&T Bank - Contract (VirtusaPolaris) - Baltimore, MD May 2017 – May 2020

•Directed migration of all Teradata data to Hadoop, facilitated via Sqoop and created analysis script to facilitate MVC implementation in all tables

•Handled multiple transformations and joins of SQL and views from Teradata to run in Impala and Hive for building and running various short-/long-term queries

•Assessed the primary index and PPI and added secondary indices to boost performance

•Managed SQL help desk and tuned ALL SQL and semantic views before deployment

•Used various tools for querying and visualizations, including Tableau, Python, and R programming

Available upon request

Teradata DBA - Teradata 14.10/15.10

Teradata - Anthem (Teradata Contract) - Atlanta GA May 2016 – May 2017

•Increased efficiency of information security by designing and implementing improved access-granting SOWs and performance tuning

Teradata Developer

Coca-Cola – Atlanta GA Nov 2014 – Mar 2015

•Actively participated in requirement meetings to determine project scope and design a new application, using Temporal tables to maintain history records

Teradata DBA

IBM – Coca-Cola & Citizens Bank – Remote Mar 2015 – May 2016

•Received and ensured smooth Teradata knowledge transfer from current DBA staff to IBM’s steady state team for 2 Teradata contracts

•Established governance by creating Teradata at Your Service tickets and interfaces with Teradata CSR

•Restored through NetBackup and created tables to deal with Spool space, connection, and all trouble ticket problems

Teradata DBA – Version 14.0 (On Call, Rotation)

Wells Fargo – Charlotte NC Nov 2013 – Nov 2014

•Coordinated with 4 development teams for performance tuning, physical modelling of tables, and creating tables, views, and macros for developers

Teradata Production DBA / DBA Trainer - Version 13.10

Independence Blue Cross - Philadelphia PA Apr 2013 – Sep 2013

Teradata Production DBA - Version 13.10

Blue Cross Blue Shield Tennessee - Chattanooga, TN Apr 2012 – Apr 2013

Teradata Production DBA - Version 13.10

Geisinger Health Systems - Danville, PA Nov 2011 – Apr 2012

Teradata Production / Application DBA - Version 12

Blue Cross Blue Shield North Carolina - Chapel Hill, NC

Apr 2010 – Sep 2010 / Mar 2011 – Nov 2011

Teradata Performance Tuning - Version 12

Pfizer (Teradata contract) - New York, NY Sep 2010 – Jan 2011

Teradata Development DBA / Logical and Physical Data Modeler / MySQL DBA

Lockheed Martin - Fairborn, OH Sep 2008 – Apr 2010

Teradata Developer

Nationwide Insurance - Columbus, OH May 2008 – Sep 2008

Teradata Development DBA

RJ Reynolds - Winston-Salem, NC Jan 2008 – Apr 2008

Teradata DBA

Lead Teradata Production DBA - 4 Node Unix

DaimlerChrysler Financial Services - Detroit, MI Oct 2006 – Jan 2008

Teradata Production DBA - 128 Node Unix - Performance Analyst

USPS - NCR Eagan, MN Jun 2006 – Oct 2006

Teradata Developer

AT&T - Hoffman Estates, IL Apr 2006 – Jun 2006

Teradata Production DBA - 8 Node Windows

Defense Commissary Agency - Richmond, VA Nov 2005 – Apr 2006

DBA - Teradata 8 Node Windows, DB2, Oracle

Winn-Dixie Stores, Inc. - Jacksonville, FL May 2005 – Nov 2005

DB2 DBA / Oracle DBA / Teradata DBA

Bell South - Atlanta, GA Mar 2004 – May 2005

Teradata Developer / Teradata ETL/Design

NCR - Rockville, MD Oct 2002 – Feb 2004

ADDITIONAL WORK EXPERIENCE

Teradata Developer

Southwestern Bell - St. Louis, MO May – Oct 2002

Charming Shoppes - Bensalem, PA Feb – May 2002

Teradata DBA/Design

Baseline Consulting/Verizon Communications - Atlanta, GA Apr 2001 – Feb 2002

Baseline Consulting /NCR/Ford Motor Company - Detroit, MI Dec 2000 – Mar 2001

Teradata DBA/Developer

Southwestern Bell - St. Louis, MO Apr – Dec 2000

Teradata Developer

JC Penney - Dallas, TX Jun 1999 – Feb 2000

Teradata Production Support

Coca-Cola - Atlanta, GA Feb – May 1999

BellSouth Advertising & Publishing Corporation - Atlanta, GA Oct 1998 – Oct 1999

MCI - Atlanta, GA May – Dec 1998

Arthur Andersen / National Bank of Detroit - Atlanta, GA Mar – May 1998

Deloitte & Touche / KMART - Troy, MI Oct 1997 – Mar 1998

IBM / IKON Capital - Macon, GA Jan 1996 – Oct 1997

Ceridian - Dunwoody, GA Jan – Jun 1995 / Nov 1995 – Jan 1996

MCI - Dunwoody, GA Jun – Nov 1995

Chrysler Motors - Detroit, MI Mar 1994 – Jan 1995

Ford Motor Company - Detroit, MI Mar 1993 – Mar 1994

Electronic Data Systems - Troy, MI Jan 1989 – Mar 1993

Internal Revenue Service - Detroit, MI Nov 1987 – Jan 1989

Officer

United States Navy May 1976 – Nov 1987

Teaching Experience

Different Institutes, Available upon request 1988 – 2000

•Relationship Building

•Independent and Team Work

•Verbal and Written Communication

•Detail-Oriented

•Documentation & Database Maintenance

•Time Management

•Multitasking & Prioritization

•Problem-Solving

•UNIX

•Teradata (BTEQ, ITEQ, MULTILOAD, FASTEXPORT)

•QMF

•REXX

•VSAM

•FORTRAN

•VAX

•CLIST

•DIALOG MANAGER

•Net vault

•MVS

•JCL

•Teradata Administrator

•Visual Explain

•TSET

•Erwin

•COBOL / COBOL II

•ADS/ONLINE

•IMS-DC

•DB2

•PL/I

•Data Mover & BAR

•SQL /SQL Assistant

•Tableau

•Python

•R Programming.

•NetBackup

•Viewpoint Administrator

•NCR PUT

•PMON

•Ferret

•Bteqs

•IDMS-DB/IDMS-DC

TECHNICAL SKILLS

•IT Audit & Security Assurance

•Project Management

•Process improvement

•Critical Thinking & Analysis

•Research & Reporting

•Process & Gap Analysis

•Risk Assessment & Control

•Operation Support Troubleshooting

PROFESSIONAL SKILLS

Contact this candidate