Professional Summary

Srinivasa Rao has around 15 plus years of work experience in the IT industry.

Designing, development, DBA activities involving Teradata and designing, developing and supporting various features in Teradata namely Teradata Stored Procedures, Teradata V2R5 Triggers and Teradata UDFs and solid experience in developing SQLs in Teradata.

Have good experience in Teradata DBA activities like Teradata database installations, version upgradations, database maintenance activities, Archive/Recovery operations, Teradata user and database creations. Creating and managing user accounts. Prepared scripts for monitoring the system. Automated the Arcmain for the database. Installed Teradata drivers for the teradata utilities. Refreshed the data by using fast export and fastload utilities. Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.

Fully aware of the IUMB (Install, Upgrade, Migration, and Backdown) procedures of V2R51 and V2R6 Teradata Software on all flavors of UNIX and WINDOWS platforms.

Extensively worked in Teradata DBA activities like: Archive/Recovery, DBS installation / upgrading / maintenance, Creating Teradata Users, Teradata Databases

Lead the teams in the usage of mostly all the Teradata Utilities like Backup and Restore Utilities (ARCMAIN/Net Vault/Net Backup), Fastload, Multiload, Tpump, BTEQ, FastExport, Pmon.

Worked extensively in C, C++, Bourne Shell, Unix Internals, TCP/IP, Socket Programming, Perl languages, Teradata and well versed with RDBMS: MS-SQL server, Sybase and Teradata RDBMS. Strong in developing tools and system applications using Unix Internals, TCP/IP, Socket Programming and FTP. Worked on Windows NT, 95, CE, SCO-UNIX, HP-Unix and Linux, Sun OS 5.5 platforms. Conversant with Wipro & Satyam\'s ISO 9001 quality procedures.

Worked extensively in Teradata Manager, ARC, BTEQ, TDADMIN, SQLA, PMON, Priority Scheduler, Teradata RDBMS, SQL, Teradata Data Modeling, Teradata Client Utilities and Backup and Recovery Utilities on operating systems like UNIX MP-RAS, Solaris-SPARC, HP-UX, SUSI Linux, .NET and Windows 2000 and on hardware platforms such as NCR4400, NCR4300, NCR4100, Pentium and Itanium.

Experience:

Confidential

Sr.Teradata DBA

Dec 2009 to Till Date

Confidential

Sr.Teradata DBA

Jan/2009 – Dec 2009

Confidential

Sr.Manager

April/2008 – Jan/2009

Confidential

Consultant

Feb/2007 – April/2008

Confidential

Senior System Analyst

April/2005 – Feb/2007

Confidential

System Analyst

June/2003 – March/2005

Confidential

Senior System Analyst

(02/2003) – (06/2003)

Confidential

Associative System Analyst

(01/2001) – (02/2003

Confidential

Software Engineer

06/1997) – (12/2000)

Technical Skills Hardware:

NCR 5400,5380,5350,5300,5250, 4850, 5200, 4400, 4300, 3550, LSI-6841, 6840, IBM RS-6000, HP-9000, Sun E Ultra 2, E-4500, Dell, IBM desktop systems, Intel x86, PA-RISC, RS6000, SPARC, IA64

Operating Systems:

Windows 2000, NT, ’95,HPUX11i, AIX5.x, SOLARIS-SPARC9i, MPRAS 03.02.00, 03.03.00, Red HatLinux9.0 PS, AS3.0,SUSE LINUX9.0,IAHPUX11.22

Languages:

C, C++

Databases:

Teradata, SqlServer7.x, Sybase

GUI:

Xwindows / Motif

Web Related:

PERL

Tools & Utilities:

ARC, NetVault, Teradata Visual Explain, BTEQ, Teradata System Emulation Tool, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Administrator, TASM, FastLoad, MultiLoad, FastExport, Tpump, Teradata Statistics Wizard and Priority Scheduler
Utilities : FTP, Purify, sed, awk, Teradata Client Utilities, Shell Script, Parallel Upgrade Tool(PUT), Fastload, Multiload, Fast export, bteq ,Vprocmanager, xctl, dbscontrol, cvstool,Teradata MultiTool, Ctl/Xctl, Vprocmanager, Check table, Scandisk, Reconfig, Filer, Lockdisp, Showlock, Qrysessn, RCVManager, Teradata Dynamic Query Manager, Queryman, TSET, TiWiz, Visual Explain, StatsWiz, TSTSQL

Domain Knowledge:

System Programming, Telecom, DBA

Debuggers:

GDB (mpras), dbx (sparc), idb (aix)

Others:

Unix Internals, TCP/IP, Socket Programming

Certifications

• Teradata Basics V2R5 (NR0-011) - SR2061037
• Teradata Physical Implementation V2R5 (NR0-012) - SR2061037
• Teradata Administration V2R5 (NR0-014) - SR2061037
• Teradata SQL V2R5 (NR0-013) - SR2061037
• Teradata Design Architecture (NR0-015) – SR2061037
• Teradata Application Development (NR0-016) – SR2061037
• Teradata Certified Master V2R5

Projects Profile 14

Confidential,

Client

Confidential,

Role

Sr. Teradata DBA/Application DBA /Teradata Architect

Organization

Cognizant , USA

Duration

Feb 2010 – Till Date

Team Size

Project: EDW Support

Module: NA

Environment

Software

Database : Teradata 6.2
Applications: NETVAULT, NetBackup, TMGR, TDADMIN, PMON, SQLA, TASM, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and Informatica
Client O/S : LINUX , MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-bit
Tools :Erwin, Power Designer, Informatica
RDBMS platforms: TERADATA 12 & 6.2, SQL Server

• Penn National Gaming is a big Casino Gaming company providing services for gaming line customers. I worked as a Sr Teradata DBA/Application DBA / Architect to provide EDW Data mart solution for marketing department to analyze Campaign Analytics with Customer Analytics. Informatica 8.x, 7.1.3/6.2 is used as ETL tool & SQL Server, Teradata 12 & 6.2 is the database & Cognos is used for Reports.
• Contribution
• Worked on NetBackup/NetVault Technology to take the hot and cold backups.
• As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
• Setup core process required to source new data streams into Teradata data mart
• Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
• Responsible for providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
• Involved in workload balancing through TASM.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
• Performed database health checks and tuned the databases using Teradata Manager.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Use of all database administration tools to analyze system status/performance.
• Analyze explains/statistics/diagnostics to isolate SQL problems.
• Teradata SQL, OLAP functions, and Load/Unload utilities
• Perform report development, MSTR architecture work, and interaction with business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Moved databases between machines.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Installed Teradata drivers for the teradata utilities.
• Refreshed the data by using fastexport and fastload utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

13

Project Name: Confidential,

Client

Confidential,

Role

Sr. Teradata DBA/Application DBA /Teradata Architect

Organization

Wipro Technology , USA

Duration

06/2009 – Feb 2010

Team Size

Project: CMBI Support

Module: NA

Environment

Software

Database : Teradata 12
Applications: NETBACKUP, TMGR, TDADMIN, PMON, SQLA, TASM, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and Informatica
Client O/S : LINUX 12, MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-bit
Tools :Erwin, Power Designer
RDBMS platforms: TERADATA 12, SYBASE, DB2, Oracle

• AT&T is a big Telecommunications company providing services for wireless and wire line customers. I worked as a Sr Teradata DBA/Application DBA / Architect to provide BI Data mart solution for marketing department to analyze Campaign Analytics with Customer Analytics. Informatica 8.x, 7.1.3/6.2 is used as ETL tool & Oracle 10g/9i , Teradata 12 is the database & Micro strategy Ver. 8 is used for Reports.
• Contribution
• Worked on NetBackup Technology to take the hot and cold backups.
• As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
• Setup core process required to source new data streams into Teradata data mart
• Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
• Responsible for providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
• Involved in workload balancing through TASM.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
• Performed database health checks and tuned the databases using Teradata Manager.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Use of all database administration tools to analyze system status/performance.
• Analyze explains/statistics/diagnostics to isolate SQL problems.
• Teradata SQL, OLAP functions, and Load/Unload utilities
• Perform report development, MSTR architecture work, and interaction with business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Moved databases between machines.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Installed Teradata drivers for the teradata utilities.
• Refreshed the data by using fastexport and fastload utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

12

Project Name: Confidential,

Client

Confidential,

Role

Sr. Teradata DBA/Application DBA

Organization

Artech Information Systems (IBM Global Services at Xcel Energy-Denver), USA

Duration

01/2009 – 06/2009

Team Size

Project: EADW Production Support

Module: NA

Environment

Software

Database : Teradata
Applications: NETBACKUP,TERA,TMGR, TDADMIN, PMON, SQLA, TSAW, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and Informatica, Goldgate
Client O/S : LINUX 6.2, MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-biten
Tools :Erwin, Power Designer
RDBMS platforms: TERADATA 12, SYBASE, DB2, Oracle

Hardware

NCR5500

• Project Description

Xcel Energy & Utilities Company is aleading provider of electricity and natural gas energy and offers a comprehensive portfolio of energy-related products and services to 3.3 million electricity customers and 1.8 million natural gas customers in USA.
EADW (Enterprise Analytic Data Warehouse) is the next generation of Xcel Energy’s current data warehouse and more .It is intended to be the “single version of the truth” for non-customer analytics, metrics and decision support applications. It provides data integrated from multiple sources throughout the enterprise EADW is a reflection of the operational data sources (“systems of record”). Currently EADW is retaining 2 to 7 years of data which approximately sum’s out the data volume upto 6 TB. EADW also provides Business Intelligence tools to enable users to “self serve” analytics .The tools provided are designed to allow business users to produce their own reports and perform their own analytics with minimal technical assistance.

EADW responsible for production support and scheduling. Dedicated 3NF (third normal form) schema. EADW monitors all jobs for non-optimal performance and may be forced to cancel SQL and jobs that impact other users. Responsible for managing controlled data access – Energy Markets, Finance, Customer & Billing, etc. Interfacing with the approving organization for approval. Designing and implementing access control tools to support control limitations.

• Contribution
• Worked on NetBackup/TERA Technology to take the hot and cold backups.
• As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Involved in workload balancing through TASM.
• Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
• Performed database health checks and tuned the databases using Teradata Manager.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Use of all database administration tools to analyze system status/performance.
• Analyze explains/statistics/diagnostics to isolate SQL problems.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Moved databases between machines.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Performed database health checks and tuned the databases using Teradata Manager.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Installed Teradata drivers for the teradata utilities.
• Refreshed the data by using fastexport and fastload utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.
• Acted as a liaison between the offshore and onsite teams.
• Also performed functions as Project Lead (teams up to 15 people)

11

Project Name: Confidential,

Client

Confidential,USA

Role

Sr. Teradata DBA/Application DBA

Organization

Wipro Technologies

Duration

02/2007 – 01/2009

Team Size

Project: IDW Production Support

Module: NA

Environment

Software

Database : Teradata 12
Applications: NETVAULT,TMGR, TDADMIN, PMON, SQLA, TSAM, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and Informatica
Client O/S : MPRAS V2R6, HPUX, MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-bit
Tools: Erwin, Power Designer
RDBMS platforms: MP-RAS, W2K, DB2, Oracle

Hardware

NCR5450

• Project Description

IDW (Integrated Data Warehouse) is the next generation of Schwab’s current iSchwab data warehouse and more .It is intended to be the “single version of the truth” for non-customer analytics, metrics and decision support applications. It provides data integrated from multiple sources throughout the enterprise IDW is a reflection of the operational data sources (“systems of record”). Currently IDW is retaining 2 to 7 years of data which approximately sum’s out the data volume upto 7 TB. IDW also provides Business Intelligence tools to enable users to “self serve” analytics .The tools provided are designed to allow business users to produce their own reports and perform their own analytics with minimal technical assistance.

IDW responsible for production support and scheduling. Dedicated 3NF (third normal form) schema. IDW monitors all jobs for non-optimal performance and may be forced to cancel SQL and jobs that impact other users. Responsible for managing controlled data access – NPI, Bank, Employee, etc.Interfacing with the approving organization for approval. Designing and implementing access control tools to support control limitations.

• Contribution
• Worked on Netvault Technology to take the hot and cold backups.
• As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5450, 17 node for production, development and testing.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Involved in workload balancing through TASM.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
• Performed database health checks and tuned the databases using Teradata Manager.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Use of all database administration tools to analyze system status/performance.
• Analyze explains/statistics/diagnostics to isolate SQL problems.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Installed Teradata drivers for the teradata utilities.
• Refreshed the data by using fastexport and fastload utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.

Education : B.Tech (Computer Science)