Guruprasad Nookala

Associate (Application DBA)

• • Managing and administering Teradata Data warehouse • Capacity Management and Forecast of space utilization • Scripting/Reviewing code by following TD best practices based on the project standards. • Migrating the code in lower (QA and UAT ) and Higher environments (PROD) • Excellent knowledge on Teradata Physical data modeling using ERWIN. • Experienced with transformation and loading data into a Staging, Data warehouse & Data Marts using Teradata utilities like Fast Load, Multi Load, Fast Export and BTEQ scripts. • Experienced with Teradata administration tasks like Database stack creation, User access management using TD Roles and Profiles and Space management(moving space and allocation of new space from central reserve database) • Having good exposure to tools like TD ADMIN, PMON, View Point, ATANA SUITE • Efficient at tuning queries for optimal performance by reducing the CPU Cycles and executing the job in minimal time. • Defect tracking and change management using Quality Center and Service Manager. • Pulling the large CPU and time consuming jobs and tuning with best results. • Expertise with Teradata FLDM and Banking Data Models. • Experience in writing UNIX shell scripts • Worked on data profiling on Various Databases like SQL server, Oracle, Sybase and SAP • Performed Component Integration Testing and User Acceptance Testing.