Professional Summary:

• Eight years of Experience in Teardata, Oracle, ETL tools, Data mining and Analysis tools, Data Access methods,SQL, PL/SQL, Unix shell scripting.
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting.
• Experienced in trouble-shooting techniques, tuning SQL statements, Query Optimization, Dynamic SQL and Materialized Views.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions using Informatica.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Good exposure to Contol_M Scheduling tool.
• Involved in Enhancement and Maintenance of Teradata database and customer support.
• Sound Knowledge about Stored Procedure, Triggers, Batch Referential Integrity, Indexes and other features of Teradata.
• Sound Knowledge of Data Warehousing concepts, E-R model & Dimensional modeling (3NF) like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Proficient with software engineering concepts and full System Development Life Cycle.
• Excellent problem solving, analytical, communication and interpersonal skills.

Technical Skills

Teradata SQL, Teradata tools & Utilities

Teradata Utilities

BTEQ, FastLoad, MutliLoad, Fast Export, Tpump, SQL Assistant, Teradata Manager, PMON, Teradata Administrator (Winddi)

Teradata Analyst tools

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

Languages

Teradata SQL, PL/SQL, C, C++

Databases

TeradataV2R5.x/6.x/12.0,Oracle 8i/9i, MS Access

Operating Systems

Windows 95/98/NT/2000/XP, Unix, Linux, NCR MPRAS-Unix

Methodologies

Data Modeling - Logical/Physical/Dimensional/3NF, Star/Snow flake, ETL, OLAP, ROLAP, Complete Software Development Cycle

Scripting Languages

UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential,Columbus, OH Feb 2011-Present
EDW Tester/Developer/DBA
Responsibilities:

• Analyzed the requirements and enhancements to migrate the data from version12 to version13 on teradata platform.
• Validated the data migrated from version12 to version13 on teradata platform.
• Worked extensively with the Teradata SQL Assistant 6.2 to interface with the clients Database.
• Used BTEQ scripts to batch-load large data sets into the existing database.
• Executing monthly, weekly and daily reports in UNIX and automated the scripts using shell script.
• Checked the accuracy of data loaded into Teradata.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues.
• Preparing Test Cases and performing Unit Testing.
• Using Teradata Administrator to manage Users and Databases.
• Extensively used the tools Toad for editing, saving and executing Teradata scripts.
• Control_M job Scheduler tool to Schedule jobs.
• Scheduled various Pre and Post Sessions, workflows to load data from Source files tables to Target tables

Environment: Teradata12.0,Oracle 9i/10g, Teradata SQL Assistant, BTEQ, IBM Datastage8.0,
UNIX Shell Scripts. Query Analyzer, TOAD, Windows XP, Control-M scheduling tool.

Confidential,Minneapolis, MN May 2009-Jan2011
Sr Teradata Developer/DBA

Responsibilities:

• Highly proficient in writing loader scripts like BTEQ, MLoad, FLoad and Fast Export
• Educated the team on how to utilise the Teradata visual tools like Teradata Manager, Database query language (DBQL), TDQM, Visual explain etc.,
• Faster incoming file process automated to loading into Teradata staging using BTEQ, Fast Load and then loaded into MLoad by concatenating files on the basis of table name
• Extensively used MLoad, FLoad and Fast Export Teradata tools both in ETL and UNIX scripts for high volume flat files.
• Created a Generic BTEQ script to load the data into various target tables from flat files using control table mechanism.
• Extensively worked on Teradata performance optimization by using various Teradata optimization strategies and increased the query throughput
• Analyzed the requirements and enhancements to migrate the reports from SQL Server 2000 to SQL Server 2005.
• Designed new tables and enhanced existing tables, reduced number of tables by de-normalization and by reducing joins.
• Created complex stored procedures, views, SQL joins and scripts for applications.
  

Environment:TeradataV2R6/12.0,Oracle 9i/10g, Teradata SQL Assistant, BTEQ, FLOAD, FEXP,
MLOAD, UNIX Shell Scripts, MS SQL Server 2005/2000, SSMS, Query Analyzer, ERWIN,

Confidential,CA Sep 2008 - Apr 2009
Sr Teradata ETL developer/DBA

• Involved in defining the dimensions, fact tables and data loading process.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Designed database, tables and views structure for the new data mart.
• Optimize SQL queries for better performance.
• Troubleshoot and created automatic script/SQL generators.
• Checked the accuracy of data loaded into Teradata and assured the linkage of keys on the tables for the various bank systems.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues.
• Work on complex queries to map the data as per the requirements.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Preparing Test Cases and performing Unit Testing.
• Using Teradata Administrator to manage Users and Databases.
• Production Implementation and Post Production Support.
• Using Teradata manager, Index Wizard and PMON utilities to improve performance.

Environment: Teradata V2R5, SFTP, BTEQ, Query man, Multi load, Fast export, Teradata SQL
Assistant, Informatica 7.1, SQL Tools, PL/SQL, Solaris 5.3, Windows XP

Confidential,Parsippany, NJ Jun 2007 - Aug 2008
Teradata Database DBA

• Worked extensively with the Teradata SQL Assistant 6.2 to interface with the clients Database.
• Written several SQL scripts for large data pulls and ad hoc reports for analysis.
• Performed script validation in the Development and Testing environments before sending them to the Production environment.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Worked with several marketing managers and project manager to gather financial data and requirements and build reports using Teradata SQL.
• Worked with an interdisciplinary team to implement the proposed business logic.
• Created daily, weekly, monthly reports related to the customer database by using Teradata, MS Access and Excel.
• Developed Teradata scripts for updating and inserting millions of records into tables.
• Communicated with vendors to make sure the campaigns are released to the customers on time without flaws.
• End-to-end implementation of several Analytical Applications.
• Designing and creating different reports for cost and time management purposes.
• Extensively used MS Access (modules) in order to manipulate and run the Teradata reports for the marketing managers according to their needs.
• Created and developed various departmental reports from several databases and tables by using Teradata, SQL, MS Access and Excel.
• Extracted data from external database (Teradata) to Excel by using ODBC connection.
• Used Teradata SQL to handle Ad-hoc requests as per the requirements.
• Used SAS data platform for running critical algorithms.
• Used an FTP tool, CoreFTP for transferring data sets from one environment to another.

Environment: Teradata V2R6, SQL Assistant 6.2, Queryman, ODBC, MS Access, MS Excel,
Windows NT and 2000, SAS, CoreFTP, Microstrategy

Confidential, DE Oct 2006 - May 2007
Sr. Teradata DBA

• Extracted, Transformed and Loaded data from different sources into Teradata by using Teradata utilities such as FastLoad, MultiLoad, Tpump and exported data into flat files using FastExport.
• Developed and maintained complex Teradata SQL scripts using BTEQ environment.
• Established best practices, methodologies and documentation standards for ETL work.
• Worked with business analysts by providing specific and crucial information through data mining using Oracle, SQL, Teradata, Bteq, UNIX and Toad.
• Executing monthly, weekly and daily reports in UNIX and automated the scripts using shell script.
• Create and Maintain user groups, users for Production/Development of Teradata Systems.
• Used BTEQ scripts to batch-load large data sets into the existing database.
• Performed FastLoad to run the ETL jobs and to load the empty tables.
• Worked extensively on MultiLoad to insert, update and delete records.
• Used FastExport to export large data sets from Teradata tables or views to flat files.
• Used BTEQ to import and export data between the client and the database tables.
• Worked on physical and logical design of the dimensional model using ERWIN.
• Programmed in Excel (macros) in order to generate daily reports, which pull data from Teradata database.
• Used a report generating tool called Microstrategy for creating financial reports.
• Modified and created tables in Teradata using metadata (Data Dictionary).
• Extensively used the tools EditPlus and Toad for editing, saving and executing Teradata scripts.
• Created SAS data sets in order to load into Teradata tables.

Environment: Teradata V2R6, Unix Servers 5380/5250, SQL Assistant 6.1, Oracle 9i, MS SQL
Server, ETL, Erwin Designer 2000, Excel, VB, ODBC, TOAD, CoreFTP, Microstrategy, Windows
NT, UNIX Shell Scripts, SAS

Confidential,MI Apr 2006 - Sep 2006
Teradata Developer/DBA

• 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.
• Provide ongoing support by developing processes and executing object migrations, security and access privilege setup and active performance monitoring.
• Index maintenance & analysis.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Explored ways to optimize existing ETL processes and enhance theirperformance.
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Application development that enables data to be moved from legacy systemsand external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fastexport and BTEQ.
• Apply broad in- depth business and technical knowledge to resolve production support and sustainment activities.
• Resolve and work on issues across multiple functional areas. Effectively monitor and take action to ensure coordination and effectiveness of all components and activities and decide on issues requiring escalation.
• Help create and maintain operational documentation to support the solution in a production environment.
• Extensive work experience in the design and development using UNIX shell scripting and SQL.

Environment:Teradata V2R5, MVS, Teradata SQL Assistance 6.1, Teradata Administrator 6.0,
Teradata Utilities (Mload, Fastload, FastExport, BTEQ, ARC Utilities, Teradata Manager, PMON,
Teradata SQL Assistant, Teradata Administrator, ASF, Teradata Priority Scheduler, JSC, UNIX
Shell Scripting.

Confidential,Hyderabad, India Jan 2005 - Feb 2006
ETL Analyst

• Involved in analysis of Extraction, Transformation and Loading Process.
• Involvedin creation of the mappings between sources and target tables.
• Used different transformation like Expression, Aggregator, Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
• Created reusable transformations. Involved in unit testing as well as Functional testing.
• Created the sessions and Batches using Server Manager. Involved in debugging mappings and tuned for better performance.
• Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
• Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Extensive use of Transformations like Joiner, Aggregators, Connected & unconnected lookups, Filters, Sequence generators, Routers, Expression, Sorter etc.

Environment: Informatica 5.1, Business objects, Oracle 8i/9i, Windows NT

Confidential, Bangalore Feb 2003 - Dec 2004
Oracle Developer

Responsibilities:

• Have used Bulk Binding features for mass loads.
• Have done SQL Tuning to improve performance.
• Performed database design (Views, Database triggers, Materialized views, packages, functions, and procedures).
• Have done Migration and Upgrade tasks.
• Have used Analytical functions extensively.
• Have implemented frame work for Error Handling.
• Developed materialized views and summary tables necessary for structured and ad-hoc reporting.
• Involved in OLTP database design.
• Experienced on FACT, Dimension tables, workflow process, mappings in Informatica.
• Designed and developed privileges form for giving the privileges for each and every user. So based on the privileges users can enter the data, delete the data and update the data and only query.
• Created materialized views for Data warehouse data
• Scheduled the nightly jobs using DBMS Scheduler.
• Implemented Advance Queuing for message transmission between different programs.
• Developed control scripts for SQL*Loader for loading data from flat file to Oracle.
• Prepared UNIX shell scripting programs.
• Working on multitasking for different branches and different customers.
• Running script for creating table spaces, tables, indexes etc.
• Involved in day-to-day database maintenance.
• Developed Packages to extract data and populate tables in CSV format for reporting.
• Involved in developing packages to convert data from legacy to Oracle.
• Prepared Technical Design Document and Installation Document.

Environment: Oracle 9i, UNIX, Data warehouse, PL/SQL, SQL*Plus, Forms 6i, Reports 6i,
OLTP, OLAP, SQL*Loader, UNIX, TOAD.

Education:
Masters in Computer Science
Bachelors in Computer Science and Information Technology