Yatin Bhat

15+ years as Teradata DW Administrator and Architect.Specialties: Teradatao System analysis and Performance optimization of Teradata Data Warehouse.o Historical transaction analysis and reporting using DBQL.o Migration and Upgrades of Teradata across various database releases.o Teradata Active System Management (TASM) implementations for Data Warehouse analysis and resource optimization.o Analysis, setup and management of Query groups and Data Labs.o Viewpoint system setup for active monitoring & analysis of the system.o Restoration of Complete Data Warehouse in different environments. o Backup & Recovery solutions implementation using TaraGUI, NetBackup & NetVaulto Implementation of partition backup and restorationo Identifying compression opportunities and using Multi-value, block & algorithmic Compression.o Management and optimization of critical resources like CPU, Space and Memoryo Assisting clients with development and management of standards-based enterprise strategic technical Data Warehouse based on and aligned with the client’s business objectivesTeradata SQL Assistant, Teradata Administrator, TSET, Viewpoint, Console UtilitiesTeradata Load Utilities (FastLoad, MultiLoad, TPump, FastExport, BTEQ), Shell Scripting, SQL, PL/SQL Data Modeling basics using ErwinTeradata V2R5, V2R6, 12.xx, 13.xx, 14.xx, 15.xx, 16.0, 16.20, 17.10, Shell scripting on UNIX MP-RAS, Linux, Solaris.Previously worked for 7 years as Oracle Adminsitrator with extensive experience on Oracle RAC