SUMMARY

• A competent professional with over 6+ years of experience in design, development, implementation, testing, maintenance and administration of Teradata database
• Experienced on Teradata Database Architecture, Database Features, Teradata tools and worked on Teradata Database Internals Parser, Optimizer and the Amp modules
• Experience in using Teradata tools and utilities like BTEQ, SQL Assistant, TSET, Teradata Administrator, Teradata Manager, Teradata Workload Analyzer, Teradata Visual Explain, Teradata Index Wizard, Teradata Statistics Wizard, FastLoad, MultiLoad, TPump, ARCMAIN (Archive/Recovery), FastExport, DBQL, QCD, QRYSESSION, CTL, Filer, Rebuild, Check Table, AbortHost, DIP, DBSCONROL, LokDisp, Priority Scheduler (schmon),Recovery Manager, Tpareset, Vproc Manager.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting.
• Well versed knowledge on SQL scripts on various Relational Databases.
• Experience working on performance tuning and optimization of Teradata queries
• Experience and knowledge in Teradata database installations, version upgradations, database maintenance activities like Archive/Recovery operations, user and database creations, creating and managing user accounts, monitoring the SQL queries, monitoring the database status, identifying the CPU,I/O usage, identifying blocking sessions, locks, amp downs, analyzing the plans using Explain etc..
• Expertise onStar Schema and Snowflake Schema, Fact Dimension Tables, Slowly Changing Dimensions. Interacting with both clients and users as well to know their requirements
• Strong skills in resolving Teradata issues, providing workaround for the problems, knowledge on diagnostics, Database Tuning, SQL Tuning and Performance Monitoring.
• Strong Knowledge on SQL, DDL, DML’s, various types of Indexes, Join Planning, Join Methods, Join Types, Join algorithms used in Teradata Database.
• Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development using Teradata.
• Ability to deliver quality improvements and streamlining processes in a cross functional environment
• Experience in Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Design and Development of Informatica mappings & workflows for Source to Flat File, Flat File to Stage, Stage to Work and Work to 3NF as well as Source to 3NF.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Teradata SQL Assistant.
• Experience on utilities like FastLoad, MultiLoad, TPump, FastExport, tpt.
• Experience in Data warehousing applications, responsible for Extraction, cleansing, Transformation and Loading of data from various sources to the data warehouse.
• Good knowledge on UNIX Scripting.
• Technical expertise in all aspects of the SDLC involving requirement analysis, system study, designing, coding, testing, documentation and implementation
• Hands - on experience in managing projects and new systems implementations for streamlining operations within time & cost parameters as per organization's’ quality standards
• Gained significant exposure in debugging complex C/C++ programs

TECHNICAL SKILLS

• Programming Languages: C, Data Structures and C++, SQL, Shell scripting
• Databases: TERADATA 13.10,14.00,14.10,15.00
• Teradata Load and Unload Utilities: FASTLOAD,FASTEXPORT MULTILOAD, TPUMP,TPT
• Database Utilities: Checktable,cnsrun,ctl,dip,xdbw,dbscontrol,dul,ferret,gtwcontrol,lokdisp,schmon,qrysessn,rcvmanager,showlocks,
• tpareset, vprocmanager: Database Adminstration
• Tools: INDEX WIZARD,QUERY SCHEDULER,TSET,WORKLOAD ANALYSER,VIEWPOINT
• Query mgmt tools: BTEQ,SQL ASSITANT,VISUAL EXPLAIN
• Other Tools: GDB, Clearcase
• Administrator tools: Teradata Manager, Teradata Administrator
• Operating Systems:UNIX, LINUX and Windows

Confidential, Sunnyvale,CA

Teradata Developer

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD
• Developed mappings to load data from Source systems like Oracle, AS400 to Data Warehouse
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata
• Experienced in using OLAP functions like sum, count, csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Experience in Power Point Presentation (Financial Data, Charts).
• Expertise in generating graphs using MS Excel Pivot tables.
• Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Extracted data from existing data source and performed ad-hoc queries.

Environment: Teradata V12, BTEQ, MLOAD, FLOAD, ORACLE, SQL, PLSQL, UNIX, Windows XP.

Confidential, san francisco, CA

Teradata Developer/DBA

Responsibilities:

• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD
• Developed mappings to load data from Source systems like Oracle, AS400 to Data Warehouse
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Adapted Agile software development methodology to ETL the above data marts.
• Created mapping documents from EDS to Data Mart. Created several loading strategies for fact and dimensional loading.
• Designed the mappings between sources (external files and databases) to Operational staging targets.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Experienced in using OLAP functions like sum, count, csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Experience in Power Point Presentation (Financial Data, Charts).

Environment: Teradata V12, BTEQ, MLOAD, FLOAD, ORACLE, SQL, PLSQL, UNIX, Windows XP.

Confidential

Teradata Developer

Responsibilities:

• Assessed the code and developing the new logic to handle this cost-based duplicate removal approach
• Documented the HLSDS and SIS.
• Developing the test cases to test the developed code
• Fix the bugs opened in feature testing.
• Designed & implemented code in the Optimizer area
• Assessed the code, identified the root cause of problem and rendered fix for bugs identified during testing
• Updating the system using the dip and sysint.
• Version switching the teradata machine using the ctl.
• Enabling the features using the dbcontrol and diagnostics.
• Using the tpareset and vprocmanager bring AMP online of found the problem.
• Install the teradata packages and upgrade and downgrade the machine.
• Looked after the Teradata ‘optimizer & the dispatcher’ database code and related bugs

ENVIRONMENT:-TERADATA14,14.10,15.00,BTEQ,FLOAD, Checktable,cnsrun,ctl,dip,xdbw,dbscontrol,dul,ferret,gtwcontrol,lokdisp,schmon,qrysessn,rcvmanager,showlocks,tpareset,vprocmanager

Confidential

Teradata Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• The project involved extracting data from various sources, then applying the transformations before loading the data into target (warehouse) Stage tables and Stage files.
• Worked on Informatica power center tools-Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer.
• Created the mappings using transformations such as the Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Configured the source and target database connections using .dbc files
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Adapted agile software development methodology to ETL the above data marts.
• Created mapping documents from EDS to Data Mart. Created several loading strategies for fact and dimensional loading.
• Designed the mappings between sources (external files and databases) to Operational staging targets.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Did the performance tuning for Teradata SQL statements using Teradata Explain command.
• Created .dml files for specifying record format.
• Worked heavily with various built-in transform components to solve the slowly changing dimensional problems and creating process flow graphs using Ab Initio GDE and Co>Operating System.
• Analyzed the Data Distribution and Reviewed the Index choices
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes
• Extensively worked under the UNIX Environment using Shell Scripts.

Environment: Teradata RDBMS, BTEQ, FastLoad, MultiLoad, Fast Export Teradata Manager, Teradata SQL Assistant, Rational Clear Quest, UNIX, MQ, NDM, FTP