subbarao
subbarao's
Brand Power
subbarao yadavalli
"I Rock!"
Job Title: Senior Technical Consultant
Company/School: Tech Mahindra
Location: Bangalore, Karnataka, India
About subbarao

v  5+years of experience in Administration Teradata Production Databases. As well as good Experience in Development, testing and implementation using Teradata DBA in UNIX.                                      

v  Extensively worked on Teradata Tools & Utilities like Teradata SQL Assistant, Teradata Administrator, Teradata Manager,  PMON,  T SET , Arc main, Viewpoint, Index  Wizard, BTEQ, FLOAD, M LOAD and F Export etc.

v  Involved in Performance tuning and query tuning.

v  Worked on Backup and Recovery using ARC Main scripts.

v  Good worked  Unix Commands, Knowledge.

v  Working Experience Informatica power center

v  Having domain knowledge of Banking, Telecom and Insurance

 

v  Strong analytic skills, self-driven, keen to learn and adopt new technologies and processes.

WORK HISTORY
Tech Mahindra
Apr 2010 - On Going
Bangalore, Karnataka, India
Job Title: Senior Technical Consultant
Senior Technical Consultant
Apr 2010 - On Going
subbarao has associated this Work History with :
Best performer award in the month of Aug 2015
CISCO
working as Teradata DBA
CISCO
EDUCATION
MCA
JNTU Hyderabad
Aug 2007 - Mar 2010
Hyderabad,
Masters Degree
Computer Science
PROJECTS
CISCO
Aug 2013 - On Going
Bangalore, Karnataka, India
This is the project of Cisco’s data warehouse. Cisco planned to implement a DWH solution as part of its economical and BI Strategy, the initial subject areas being Customer Intelligence, Revenue. There are five source systems from which data is coming. The total data is loaded in the data warehousing production box. The final reporting done from this system.   

Contribution:

	Production support. 
	Monitoring system using Viewpoint. 
	Take Database backups by ARCMain Scripts thru TARA and Netbackup
	Space Management.
	User management.
	Access rights management
	Creation of Roles and Profiles.
	Good understanding in analysis of locks.
	Execution of Ad-hoc queries.
	Tuning the queries having performance issues.
	Advice structural changes and gives STATS collection recommendations wherever required.
	Sending the Daily DBA reports (Node Usage, user query count, Production space, Logon off, Memory Utilization...Etc).
	Performing Backups, Archival and restoration depending up backup strategy.
subbarao has associated this Project with :
Tech Mahindra
SPECIALIZATION
working as Teradata DBA
Apr 2010
     	This is the project of Cisco’s data warehouse. Cisco planned to implement a DWH solution as part of its economical and BI Strategy, the initial subject areas being Customer Intelligence, Revenue. There are five source systems from which data is coming. The total data is loaded in the data warehousing production box. The final reporting done from this system.   

Contribution:

	Production support. 
	Monitoring system using Viewpoint. 
	Take Database backups by ARCMain Scripts thru TARA and Netbackup
	Space Management.
	User management.
	Access rights management
	Creation of Roles and Profiles.
	Good understanding in analysis of locks.
	Execution of Ad-hoc queries.
	Tuning the queries having performance issues.
	Advice structural changes and gives STATS collection recommendations wherever required.
	Sending the Daily DBA reports (Node Usage, user query count, Production space, Logon off, Memory Utilization...Etc).
	Performing Backups, Archival and restoration depending up backup strategy.
AWARDS
Best performer award in the month of Aug 2015
Aug 2015
Cisco
i have involved in performance tuning activities. I have tuned problematic SQLs which were impacting system.