Naresh Goud Vuduthala

E-mail: ac21og@r.postjobfree.com

Mobile: 407-***-****

Professional Summary

Overall 11+ years of experience in the field of IT related to Business Intelligence concepts like Relational Database Management, Design, Development, Data Migrations, Implementation and Project Management.

Having good experience in IT Industry Administering Teradata development, testing and production databases, implemented on MP-RAs and Linux server.

Extensive experience in all the aspects of administering and managing the Oracle and Teradata production, test and development systems.

Actively involved in project management phases of SDLC like design, development, production reviews and migrations.

Designed and Implemented system migration plans for large volume of systems.

Expertise in implementing EDW, ODS and Real Time solution in Teradata.

Having good experience in optimization, performance enhancement and Procedures for enhancing the load performance in various schemas across databases.

Proficient in ETL (Extraction, Transformation, Loading) utilizing Informatica, Data stage and O2T jobs.

Extensive working experience as Application database administrator involving the Unix administration, Storage management and other client servers.

Strong experience on Logical and Physical design of Databases, Data Modeling, Conceptual Design and Data Architecture.

Strong Knowledge in Teradata Capacity planning and Teradata VM’s on VMware, Lab Manager and VCloud, Teradata dual active systems and data replication activities.

Advanced expertise in Teradata SQL, Teradata DBA activities like database maintenance activities, Tuning ETL queries and application code, Teradata user and database creation / maintenance, Space management, Releasing the locks, Performance monitoring using PMON, Teradata Manager, Viewpoint and using API’s, Workload Management using TASM, TIWM, PS.

Expertise in validating Unix/Linux Scripts, SQL Scripts, PL/SQL and Stored Procedures to ensure the successful execution of the ETL processes.

Having knowledge on Data mover.

Highly skilled in writing SQL queries, Stored Procedures, Cursors and Triggers.

Having experience in implementing real-time and Web applications in Teradata

Experienced in preparing design documents and writing Quality center build scripts and executing them in QC

Excellent interpersonal, communication skills with the ability to manage multiple projects and meet deadlines.

Good knowledge of code, design reviews and other process oriented procedures.

Good understanding of Data warehouse Life Cycle.

Good Understanding of Dimension Modeling, which is adopted to build Data warehouse.

Well versed experience on Star Schema & Snowflake Schema.

Managed and updated the Technical Specification Documents.

Widely used the Informatica Power Center Client Tools like Designer, Workflow Manager, and Workflow Monitor & Repository Manager.

Extensively used Major transformations using Power Center Designer like Source Qualifier, Lookup, Expression, Aggregator, Update Strategy, Normalizer, Sequence Generator, etc…

Well versed exposure on RDBMS like Oracle and as well as External Sources like XMLs...

Proven track record on successfully completion of Long Term and Short term projects within deadline while adapting to rapidly changing environments and priorities.

Expertise in UNIX scripting.

Excellent communication and interpersonal skills, quick learner, self-motivated, ability to work individually and as well as in a team environment with good team spirit.

Excellent Analytical, Problem solving, communication and leadership skills.

Teradata certified.

Technical Skills

Software Products

Tools

Operating Systems

MP-RAS, Linux, Solaris, AIX, Windows XP/NT/2000

RDBMS

Teradata TD15, TD14 TD13, TD12, V2R6, V2R5, Oracle 8i, 9i, 10g,SQL Server 2005,Aster Big data,Peoplesoft

Administrator Tools

Teradata Manager (TMGR), Teradata Administrator (Winddi), Teradata SQL Assistant (Queryman), Teradata Dynamic Workload Manager (TDWM), Teradata Query Scheduler, Teradata Performance Monitor (PMON), TSET, Priority Scheduler (PS), Teradata Query Director,Query Grid, Data Lab, Unity, Viewpoint, TASM.

Performance Analysis Tools

Teradata Visual Explain, Teradata System Emulation Tool, Teradata Statistics Wizard, Teradata Index Wizard

Database Utilities

Schmon, Tdwmdmp, CTL/XCTL, Lockdisp, Showlock, Qrysessn, Vprocmanager,Ferret,Packdisk Scandisk and Checktable

Load and Unload Utilities

BTEQ, Fast Export, Fast Load, Multi Load, Tpump and Teradata Parallel Transporter

ETL and Reporting Tools

COGNOS, Informatica Power Center 9.1/8.6.0/8.1,Toad, Quality Center,ERwin.

Languages

SQL, C, C++, basic Java, Unix Shell Scripts and Perl Scripts

Backup Tools

DSA/DSC,Teradata ARC,Tara, ABU, NetVault and Netbackup

Customer Appreciation:

Customer Appreciation for Outstanding performance in achieving “Healthcare Wins Computerworld BI Award”.

Customer Appreciation for excellence in program support and competent work.

Customer Appreciation on Quarterly refresh.

Achievements:

POB (pat on Back) for fastest refresh from PROD to PDR.

Major Tasks Handled:

Worked in the design of Environmental Refreshes PDR and QA.

Performed DR (Disaster Recovery) Job.

Worked on Viewpoint Upgradation.

Active participation in Teradata upgrade activities

Active participation in Teradata Node expansion.

Designed and Implemented system migration plans for large volume of systems.

Education:

Bachelor of Computer Science from Osmania University in 2004.

Professional Experience:

Project: Micron, ID

Duration: Jan 2015 - Current

Role: Lead Teradata DBA

Description:

Micron technology is a global leader in semiconductor industry. For more than 35 years, Micron has dedicated itself to collaborating to engineers to drive innovation and transform what’s possible, with 2014 sales of $16.4 billion. Micron serves as a supply channel partner for over 20+ countries, Micron future is built on continuous innovation, but its day to day operations would not be possible without our team member’s commitment to conducting business with uncompromising integrity and professionalism.

Our responsibility includes maintenance of different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Reviewing the projects in all the phases, Design, development, testing and migrations.

Implementing Logical and Physical design of Databases, Data Modeling, Conceptual Design and Data Architecture.

Implemented the Query Grid,Unity and DSA/DSC.

Worked with BI Architects to develop and use new standards of development.

Capacity planning and projecting the future demands.

Designed and implemented the system migration plan for 2750 to 2800 and 2800 to Intelliflex.

Installed Teradata utilities like TDODBC, TPT, load unload utilities on different platforms like Unix, Linux and Windows.

Viewpoint setup and monitoring the system using viewpoint portlets.

Analysis of the requirements and analyzing the current System, Designing the System based on requirement.

Workload Management using TIWM.

Automated Reviewing and migrating development code.

Developed several customization's of Teradata, which helps in better administration.

Automated stats collection process using viewpoint/Custom scripts to reduce the overall resource usage.

Installation and build the PDCR reporting services.

Creating and managing user accounts, databases and data.

Tuning the reporting queries and ETL queries using the optimization techniques.

Prepared and automated scripts for monitoring the system and alert mechanisms.

Refreshed the data by using ARC, fast export, multi load and fast load utilities.

Customized and automated many maintenance jobs using UNIX scripts.

Worked on TTU and DBMS upgrade activities like planning, testing and coordinating with various teams.

Responsible for end to end support (design phase to post implementation) for development projects.

Maintain the standards based on System level Benchmark analysis.

Worked on TD up-gradation, expansion and migration projects.

Maintain the viewpoint, Teradata manager servers.

Working on Incidents with Teradata GSC.

Created UNIX scripts to create user, databases as per standards.

Created and automated UNIX scripts to remove duplicate and extra privileges from user and roles.

Created UNIX scripting for DSA backup and recovery.

Maintenance activities like Check Table, Scandisk using Ferret Utilities

Table level post Implementation analysis using DBQL data and implementing the primary, secondary, PPI, Indexes and Stats changes.

Build a Tableau reports for analyzing the performance reports at system level as well as application levels for Prod and non-Prod systems and working towards fixing the bottle necks by coordinating with Application team(s).

Recommending the better ways of writing the queries to the users with tuning tips and educating them on the best practices.

Capacity management and MVC analysis.

Moving sample data and production data demographics to development databases using TSET.

Client: Arrow Electronics, CO

Duration: Jun 2014 – Jan 2015

Role: Lead Teradata DBA

Description:

Arrow Electronics is a global provider of products, services and solutions to industrial and commercial users of electronic components and enterprise computing solutions, with 2013 sales of $21.4 billion. Arrow serves as a supply channel partner for over 100,000 original equipment manufacturers, contract manufacturers and commercial customers through a global network of more than 460 locations in 58 countries.

Our responsibility includes maintenance of different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Workload Management using TASM, TDWM and PS.

Upgrading system from TD13 to TD14.10.

Migrating Nodes from 5500 to 2750.

Viewpoint setup and monitoring the system using viewpoint portals.

Automated Reviewing and migrating development code.

Reviewing the projects in all the phases, Design, development, testing and migrations.

Tuning the reporting queries and ETL queries using the optimization techniques.

Backup setup using Tara.

NetBackup implementation.

Client: GE Health Care, WI

Duration: Jan 2012 – Jun 2014

Role: Senior Teradata DBA

Description:

GE Healthcare (GEHC), a $15 billion unit of General Electric Company, provides transformational medical technologies and services in medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement, drug discovery, and biopharmaceutical manufacturing technologies. As to support the business, client has a mixture of OLTP and data warehouse databases implemented on Oracle 8i/9i/10g and 11g and Teradata 12 and 13 versions.

Our responsibility includes maintenance of different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Workload Management using TASM, TDWM and PS.

Automated Reviewing and migrating development code.

Configuring the alert policies in TMGR and help in system monitoring.

Developed several customizations of Teradata, which helps in better administration.

Automated stats collection process reducing the overall resource usage.

Creating and managing user accounts, databases and data.

Reviewing the projects in all the phases, Design, development, testing and migrations.

Tuning the reporting queries and ETL queries using the optimization techniques.

Prepared and automated scripts for monitoring the system and alert mechanisms.

Installed Teradata utilities like TDODBC, TPT, load unload utilities on different platforms like Unix, Linux and Windows.

Refreshed the data by using ARC, fast export, multi load and fast load utilities.

Viewpoint setup and monitoring the system using viewpoint portlets.

Configuring viewpoint for managing a new system. Setting up the Data Collection (DCS) for the new systems.

Customized and automated many maintenance jobs using Unix scripts.

Installing and maintaining TDWM/TASM, configuring them as needed.

Worked with BI Architects to develop and use new standards of development.

Capacity planning and projecting the future demands.

Installing and implementing CPPT, PDCR and other DBA metadata jobs.

Worked on TTU and DBMS upgrade activities like planning, testing and coordinating with various teams.

Responsible for end to end support (design phase to post implementation) for development projects.

Maintain the standards based on System level Benchmark analysis.

Worked on TD up-gradation, expansion and migration projects.

Maintain the viewpoint, Teradata manager servers.

Working on Incidents with Teradata GSC.

Created UNIX scripts to create user, databases as per standards.

Created and automated UNIX scripts to remove duplicate and extra privileges from user and roles.

Created UNIX scripting for cluster backup and recovery.

Maintenance activities like Check Table, Scandisk, Pack disk using Ferret Utilities

Table level post Implementation analysis using DBQL data and implementing the primary, secondary, PPI, Indexes and Stats changes.

Moving the data between production, QA, DEV and VM boxes.

Generating and analyzing the performance reports at system level as well as application levels for Prod and non-Prod systems and working towards fixing the bottle necks by coordinating with onsite DBA team and Application team(s).

Recommending the better ways of writing the queries to the users with tuning tips and educating them on the best practices.

Monitoring the Netvault backup jobs and restore the data as required.

Capacity management and MVC analysis.

Moving sample data and production data demographics to development databases using TSET.

Used TDWM for defining the workloads for ETL’s and Reporting.

Client: AT & T, NY

Duration: Jun 2011 – Jan 2012.

Role: Senior Teradata DBA

Description:

AT&T Inc. is the largest provider of fixed telephony in the United States, and is also a provider of broadband and subscription television services. As of 2010[update], AT&T is the 7th largest company in the United States by total revenue, as well as the 4th largest non-oil company in the US.

Our responsibility includes maintenance of different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Workload Management using TASM, TDWM and PS.

Setup Teradata Virtual Environments in LabManager and Vcloud.

Automation of VM setup in VMware, Labamanger and VCloud.

Developed several customizations of Teradata VM’s, which helps in better administration.

Reviewing the projects in all the phases, Design, development, testing and mirations

Tuning the reporting queries and ETL queries using the optimization techniques.

Migrate jobs from Traditional Standalone Teradata utilities to Teradata Parallel transporter.

Redesign Teradata backup to minimize outages to the business and increase the load refreshes.

Refreshed the data by using ARC, fast export, multiload and fastload utilities.

Viewpoint setup and monitoring the system using viewpoint portlets

Upgradation of Teradata Database from V12 – V13.10.

Teradata Tech refresh from 5550 hardware to 6690.

Participate in Teradata user group conferences.

Understanding and implementing data profiling to take advantage of SSD in 6690 hardware.

Capacity planning and projecting the future demands.

Installing and implementing CPPT, PDCR and other DBA metadata jobs.

Worked on TTU and DBMS upgrade activities like planning, testing and coordinating with various teams.

Managing Backups/Recovery by Teradata application TARAGUI.

Investigating Space Usage & Monitoring the growth of the databases.

Requirement Analysis and design.

Documentation and Code Migration as per GEHC Process.

Coding scripts, BTEQs, Fast Export Scripts in Teradata

Developed complex UNIX codes and shell scripts.

Created many reports using Cognos Reporting Tool.

Unit Testing, System Testing, Regression Testing.

Understand the source system data and involved BR.

Based on BR requested from client, prepared HLD.

Once approve HLD, then involved in preparing of DD docs.

While coding worked on most the Informatica features. Like sql transformation, Lookup, joiner, router, source qualifier, mapping parameters and session parameters etc.

We have heterogeneous sources to our project like flat files, oracle tables and xml files.

I have much hand on practice in handling of the above heterogeneous sources.

With this I have worked on preparing UNIX scripts which are used for Informatica jobs.

Along with above roles I had play role of Prod Sup, as while releases deploying the REPOSITORY

And UPGRADE the repository, assigning workflows, handling QC defects and WRs.

Client: GE Health Care, WI

Duration: Dec 2008 – Jun 2011.

Role: Senior Teradata DBA

Description:

GE Health Care is Giants in Health care industry in U.S. GE Healthcare has a range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, and biopharmaceutical manufacturing technologies.

Our responsibility includes maintenance of different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Implementing the DBQL data collection and using the DBQL (Query logging data) for tuning the code.

Using the ampusage, resusage and PDCR to analyze the resource usage by account and verifying the bottlenecks.

Generating the performance and system health reports using excel and identifying the bottlenecks.

Reviewing the explain plans and tuning the ETL and reporting queries.

Tuning the application queries using secondary indexes (NUSI), Join Indexes (JI’s) and Aggregate Join Indexes (AJI’s).

Strong knowledge in Teradata locking and handling the locking mechanisms through views

BAR activities and strategies, usage of NetVault, Netbackup, writing backups and restore scripts for Arcmain.

Data refreshes and migrations from production to development/QA systems.

Rotational On-call support.

Participate in the Teradata utility and DBMS upgrades.

Good working experience in Logical and Physical Database Designing.

Teradata database installation, version upgrades, data migrations and DR activities.

Working with Teradata data load & unload utilities like Multiload, Fastload, Fast Export, Tpump, etc.

Worked with the Teradata Application Utilities and Database Administration Utilities namely Teradata SQL Assistant, Teradata Administrator/WinDDI, Teradata Pmon, Teradata Manager, Teradata Visual Explain, TSET.

Worked with Teradata support on various issues by raising incidents.

Used ERwin Tool in Data Modeling.

Requirement Analysis and design.

Development and modification of BTEQ Scripts in UNIX and TERADATA.

Unit testing of developed/modified BTEQ scripts and worked on Quality Center tool.

Performance tuning for old codes and in enhancements.

Creating and modifying Job Chains, Events, Locks and TERADATA Scripts using REDWOOD CRONACLE Scheduling tool.

Data validation of synchronization/GAP/Attribute reports using report studio in COGNOS.

Documentation and Code Migration as per GEHC Process.

Understanding the Requirement Specifications and analyzed it and prepared Mapping docs.

Worked on Informatica Power Center tools like Source Analyzer, Warehouse Designer to import the source and target database schemas, Mapping Designer, Workflow Manger and Workflow Monitor.

Used transformations like Aggregators, Sorter, lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, and Sequence Generator.

Used mapping parameters and variables.

Exclusively worked on slowly changing dimensions.

Identified Bottlenecks in the mapping, and Involved in Performance tuning.

Involved in configuring the dependency of the workflows.

Configured various tasks in the workflows for the dependency by using Command, Event wait, timer and Email task.

Involved in unit testing.

Client: ICICI Bank, India

Duration: Jun 2006– Dec 2008.

Role: Teradata DBA

ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian financial institution, and was its wholly-owned subsidiary. ICICI's shareholding in ICICI Bank was reduced to 46% through a public offering of shares in India in fiscal 1998, an equity offering in the form of ADRs listed on the NYSE in fiscal 2000, ICICI Bank's acquisition of Bank of Madura Limited in an all-stock amalgamation in fiscal 2001, and secondary market sales by ICICI to institutional investors in fiscal 2001 and fiscal 2002. ICICI was formed in 1955 at the initiative of the World Bank, the Government of India and representatives of Indian industry. The principal objective was to create a development financial institution for providing medium-term and long-term project financing to Indian businesses.

Our responsibility includes maintenance and building different databases, and solving the issues by dealing with program teams, application team’s worldwide.

Responsibilities:

Migrating Oracle Databases to Teradata.

Involved in Data Modeling.

Database, User, Role and Profile creation and maintain.

Monitoring database using VIEWPOINT.

Good understanding in analysis of locks, indexing.

Good understanding in analysis of TERADATA MANAGER.

24*7 DBA Production support

Fixing any errors in FastLoad/MultiLoad scripts.

Fixing any errors in Macros, Stored Procedures.

Daily reports generations.

Managing all the users’ queries by changing the priorities.

Maintenance activities like Check Table, Scandisk, Pack disk using Ferret Utilities

Creation of roles, profiles, giving access rights.

All DBA relates activities through PMON, TERADATA MANAGER, and SQL ASSISTANCE.

Performance monitoring, investigating long running queries and Tuning queries with the analysis of Business objects.

Managing spaces in production box.

Worked on a Remedy ticket request process.

Requirement Analysis and design.

Development of UNIX scripts which will validate all the standards which a BTEQ/JC should contain.

Development of UNIX and Teradata scripts which automates migration of tables/views from one database to other database.Development of UNIX script for automating performance metrics capturing which reduces effort by 70%.

Testing of automation tools and capturing defects in Quality Center.

Creating and modifying Job Chains, Events, Locks and TERADATA Scripts using REDWOOD CRONACLE Scheduling tool.

Data validation by report generation in COGNOS.

Contact this candidate