Warehouse Architect Data

Koeby Johnson

pg. *

Edmond, Oklahoma ***** • 405-***-**** • *****.*@*****.***

EXPERIENCE SUMMARY

Experienced Data Architect with 20+ years of supporting data warehouse and big data platforms/environments. Skilled in creating detailed design documentation, architecting end-to-end data solutions, and collaborating with clients and development teams. Proficient in Teradata implementations, performance, physical design, and entire Teradata ecosystem with best practices. Deep understanding of data flows, lineage, and virtualization layers. Strong data management, governance, and security expertise.

PROFESSIONAL EXPERIENCE

Sr. Data Solutions Architect PNC Bank 2017- 2023

• Supported warehouse and big data platforms/environments as a Data Solution Architect contributing to a 20% increase in data processing efficiency in query performance.

• Collaborated with clients, developers, and architecture teams to understand requirements and design and implement project-specific data solutions, resulting in a 15% reduction in data processing time.

• Created detailed design documentation, including source to target mapping from files and ETL systems, streamlining data engineering processes and reducing processing time by 10%.

• Architected end-to-end data solutions for both batch and real-time designs based on project requirements, resulting in a 25% improvement in data accessibility and availability.

• Demonstrated excellent verbal and written communication skills with SOP/Best practice docs and conducted training for conveying complex technical concepts.

• Backup, restore, migrate Teradata data and objects with DSA and Netbackup.

• Establish and maintain backup and recovery policies and procedures.

• Manage and monitor system performance to proactively monitor the database systems with TASM and Viewpoint.

• Set up and maintain documentation and standards for maintaining multiple Teradata Systems

• Optimized hardware resources allocated to the databases and to ensure high availability and optimum performance through MVC and other mechanisms such as PI, PPI MLPPI, Indexes, Statistics, etc.

• Responsible for improvement and maintenance of the databases upgrades.

• Responsible for implementation and release of database changes as submitted by the development team.

• Fluent with Teradata tools and utilities, SQL, Administration.

• Proficient with Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL).

• Data Mover, Query Grid data fabric, Autotune, TAPS auto provisioning.

• Troubleshooting performance from Tableau, MLOAD, FASTLOAD, TPT, Informatica, NOPI, Teradata AutoStats.

• Viewpoint, QueryGrid, TASM, BTEQ, Data Domain, TPT, FASTOAD, MLOAD, TPUMP, DBQL, PDCR.

• TD versions 16.xx – 17.xx

Enterprise Data Warehouse Architect/DBA Cigna Corporation 2012 – 2017

• Responsible for All Teradata operations from DBA, Security, Physical and Logical design.

• Teradata CSR and incident management, Logical and Physical Modeling

• using Embarcadero Data Architect, Teradata TARA and DSA Data Stream Architecture

• BAR implementation and operations, Disaster Recovery plans and operations,

• Managed 3 Teradata DBA’s. Teradata Versions 14.0, 15.x, Managed multiple applications.

• for Enterprise Operational Reporting. Successful startup and implementation of 3 Teradata High

• Performance Utility systems. Developed documents for Operational SOP

• Architecture, IT OPS database monitoring policies and Teradata database

• best practices and standards. Capacity planning graphs and charts for upgrade

• recommendations. Teradata training and onboarding for new users.

• Viewpoint, QueryGrid, TASM, BTEQ, Data Domain, TPT, FASTOAD, MLOAD, TPUMP, DBQL, PDCR. Koeby Johnson

pg. 2

Senior Application DBA/Architect RadioShack / Fort Worth TX / 2007 – 2012

• Worked with consultants on the Physical table design of all objects in the Enterprise Data Warehouse

• Analysis of the business requirements and relational Logical Data Model analysis.

• Primary index considerations for local AMP joins and redistribution issues.

• Designed and maintained security level for users, roles, and profiles.

• Ensured all database objects are tuned for optimal performance using TD utilities such as Priority Scheduler, TDQM, TD Manager features, and physical design techniques (PPI, Join Indexes, Hash Indexes, Secondary Indexes, Triggers, Advanced Statistics, etc).

• Performed problem determination and resolution for database-related problems with analysis of QCD, Higa Macros, DBC Macros, and TD Manager features such as Heartbeat queries and Trend analysis charts.

• Engaged in modeling and database design sessions for the logical implementation of new entities for the Data Warehouse

• Responsible for installing and maintaining the Teradata TTU software. Very Familiar with the ‘Teradata at Your Service’ application to manage incidents, knowledge base, and patch downloads.

• System integration and migration of PSF and TASM to ViewPoint.

• Configuration and design of ViewPoint Workloads, filters, and throttles. Senior Teradata DBA/Architect Pier1 Imports / Fort Worth, TX / 2004– 2007

• Responsible for recommendations and implementation of the security layer for Teradata behind the NCR DCM

(Demand Chain Management) application.

• Design and implement Priority Scheduler for workload management between the QA and PROD environments on the same system. System and Application DBA work as well as 24/7/365 on call responsibilities.

• Query tuning and locking contention troubleshooting.

• Coordination with NCR on all upgrades, patches, and system work. Archive and recovery with TARA. Senior Database Administrator PhelpsDodge / Phoenix AZ / 2001 – 2004

• Responsible for the Physical table design of all objects in the Enterprise Data Warehouse as well as all production control DDL and DML operations.

• Analysis of the business requirements and relational model analysis.

• Primary index considerations for local AMP joins and redistribution issues.

• Designed and maintained security level for more than 1500 users, roles, and profiles.

• Successfully completed SOX compliance testing for the Enterprise Data Warehouse.

• Ensured all database objects are tuned for optimal performance using TD utilities such as Priority Scheduler, TDQM, TD Manager features, and physical design techniques (PPI, Join Indexes, Hash Indexes, Secondary Indexes, Triggers, Advanced Statistics, etc).

• ETL jobs (Using BTEQ, OLEDB, Multload, Triggers) into Teradata from source system applications residing in Oracle, SQL Server, etc.

• Business Objects servers. Created and maintained BAR operations with Netvault.

• Some advanced features include Pre and Post ARCMAIN script execution, duplication, and automatic cleaning. EDUCATION

Master of Science - Computer Information Systems Tarleton State University 2001 PROFESSIONAL CERTIFICATIONS

• Certified Teradata Master • Teradata SQL specialist

• Teradata Application Developer

• Teradata Implementation Specialist

• Teradata Design Architect

• Teradata Advanced Professional

• Teradata Database Professional • Agile Scrum Master

Contact this candidate