Teradata Developer Resume Sunnyvale - Hire IT People

SUMMARY

10 Years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Application Systems.
Extensively worked on Teradata Utilities (Fast Load, Multi Load, Fast Export, Queryman, BTEQ).
Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities.
Expertise in writing SQL, Stored Procedures, Views in Teradata and Hadoop(Hive).
Good experience working with FTP, SCP using SSH protocol.
Developed and Automated UNIX shell scripts using K - shell.
Good knowledge in working with Indexes, Statistics, Volatile and Global Temporary tables.
Resolve issues across multiple functional areas. Effectively monitor and act to ensure coordination and effectiveness of all SDLC components and activities.
Strong Communication, Self-motivated, Self-starter, Presentation and Interpersonal skills with good problem-solving capabilities.
Experience in working with Google Cloud for Data analytics.

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale

Teradata Developer

Responsibilities:

Working with Architects to design ETL processes and build complex reports (Health care data).
Performance tuning of long running queries.
Good understanding of Claims and Membership data.
Automate reports that are required on a cadence.
Brief stint with Confidential working as Data Analyst in visualizing datasets for business teams
Involves Data mining, analyzing trends and measuring Year over Year comps.

Confidential, Alpharetta, GA

Teradata Consultant

Responsibilities:

Worked primarily as a ETL resource designing approach, process and appropriately leverage Teradata utilities.
Used Mload and TPT utilities for loading raw files (within a SHELL script) and the data is finally loaded to production environment using BTEQ scripts.
Worked on complex queries to map data per user requirements.
Prepare production change requests to migrate updated or new scripts in to production and specify scheduling changes.
Involved in Performance tuning for the long running queries.
Extensively worked on Teradata Parallel Transport utility (TPT) (both loading and exporting).

Confidential, Atlanta, GA

Architect/Pricing Manager

Responsibilities:

Design Price tests to analyze price changes and generate lift metrics to determine success or failure of different pricing programs.
Create infrastructure to support Price tests, elasticity and forecast models.
Worked on Google cloud and rewrite existing production processes in Cloud.
Used Tableau for visualizing dataset and alteryx for ETL needs.
Worked on complex queries to map data per user requirements.
Used UNIX Scripts for automating reports that are generated on a cadence.
Involved in Performance tuning for the long running queries.
Explored ways to optimize existing ETL processes and enhance their performance.

Confidential, Phoenix, AZ

Teradata Consultant

Responsibilities:

The project is a migration work from Sybase to Teradata Environment.
Coordinated with off shore team and review their daily activities.
Used Teradata BTEQ and Fast Export scripts to export data to various data marts.
Optimizing query performance, session performance and reliability.
Identifying jobs that require performance tuning, suggesting necessary modifications and helping in re designing the process.
Optimized high volume tables (Including collection tables) in teradata using various techniques, PPI, secondary indexes and stats.

Confidential, Marietta, GA

Teradata Consultant

Responsibilities:

Coordinated with off shore team and monitored and their daily activities.
Designing KShell scripts, using Teradata SQL and utilities to improve the design of Extract and Load processes.
Create and execute test plans for Unit, Integration, and System test phases.
Involved in processes to transfer extracted files using FTP or NDM or CFI protocols.
Implemented different kind of purging techniques to free up space in certain teradata databases and to remove orphan records.
Scheduled jobs using Maestro and monitor for any issues of daily/monthly load jobs.

Confidential, Alpharetta, GA

Teradata Consultant

Responsibilities:

Design, create and regular tuning of physical database objects (tables, views, indexes) to support normalized and dimensional models.
Requirements analysis, data assessment, business process reengineering.
Worked primarily as a ETL resource designing approach, process and in appropriately leveraging Teradata utilities.
Used Mload and TPT utilities for loading raw files (within a SHELL script) and the data is finally loaded to production environment using BTEQ scripts.
Worked on complex queries to map data per user requirements.
Prepare production change requests to migrate updated or new scripts in to production and specify scheduling changes.
Involved in Performance tuning for the long running queries.
Explored ways to optimize existing ETL processes and enhance their performance.