SUMMARY

• Over 8 years of experience in Information Technology and more than 7 years of experience using Teradata V14/V13.0/V12.0/V2R6/Informatica.
• Over 7+ years of experience in IT, with proficiency as Teradata developer and strong expertise in SQL queries, stored procedures, Teradata Macros.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures,joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load and TPT to export and import data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, Teradata SQL Assistant and Query man.
• Expertise in writing large/complex queries using SQL.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Excellent Experience with different indexes (PI, SI, JI) and Collect Statistics.
• Excellent experience with Data Quality and data cleansing.
• In - depth hands on experience in database, ETL/ELT design and development and should have excellent data analysis skills.
• Extensively worked on Informatica Power Center Mappings / Mapplets using various Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Hands on experience in Global control framework (GCF)
• Extensively worked on Informatica Designer components Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Good knowledge of Performance tuning, Application Development and Application Support on UNIX,WINDOWS NT Environments
• Experience in scheduling of jobs using Autosys, Control-M.
• Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and basic knowledge of data modeling.
• Extensive experience in unit testing, System testing and User Acceptance Testing.
• Excellent Experience working with offshore and on-site co-ordination.
• Proven problem solving skills with excellent analytical, communication and interpersonal skills.
• Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/ 2000/ XP

Database: Teradata 12.xx / 13.xx / 14.xx

Languages: Teradata SQL, PL/SQL, Shell Scripting

Teradata Utilities: Teradata - Mload, Fast Load, BTEQ, Fast Export, Tpump, and TPT

Teradata Tools: Teradata SQL Assistant, Teradata Manager

ETL tools: Informatica Power center 9.0, 9.1, 9.5

Process/Methodologies: Waterfall Methodology, Agile Methodology,FSLDM

Project Planning: Microsoft Project

PROFESSIONAL EXPERIENCE

Confidential, GA

Senior Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Translate customer requirements into formal requirements and design documents.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Writing MultiLoad scripts, FastLoad and Bteq scripts for loading the data into stage tables and then process into BID.
• Developed Scripts to load the data from source to staging and staging area to target tables using different load utilities like Bteq, FastLoad and MultiLoad.
• Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Developed mappings in Informatica to load the data from various sources using different transformations like Look up (connected and unconnected), Normalizer, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.
• Developing and reviewing Detail Design Document and Technical specification docs for end to end ETL process flow for each source systems.
• Involved in Unit Testing and Preparing test cases.
• Modification of views on Databases, Performance Tuning and Workload Management.
• Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of Re-Usage, Amp Usage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BTEQ scripts using Teradata.
• Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETL scripts.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc…

Environment: Teradata 14, Teradata SQL Assistant, UNIX, Informatica 9x,BTEQ, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT.

Confidential

Teradata Developer

Responsibilities:

• Responsible for coordinating with the Business system Analysts in the requirement gathering process and creating technical specific document.Gathering requirements from the various systems business users.
• Fixed issues with the existing Fast Load/ Multi Load Scripts in for smooth loading of data in the warehouse more effectively.
• Worked on loading of data from several flat files sources to Staging using MLOAD, FLOAD.
• Created Bteq scripts with data transformations for loading the base tables.
• Worked on optimizing and tuning the Teradata SQL to improve the performance of batch and response time of data for users.
• Fast Export utility to extract large volume of data and send files to downstream applications.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems and managed user level access rights through the roles.
• Developed T-Pump scripts to load low volume data into Teradata RDBMS at near real-time.
• Created BTEQ scripts to load data from Teradata Staging area to Teradata
• Performed tuning of Queries for optimum performance.
• Preparation of Test data for Unit testing and data validation tests to confirm the transformation logic
• Tuned various queries by COLLECT STATISTICS on columns in the WHERE and JOIN expressions.
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN Collected statistics periodically on tables to improve system performance.
• Instrumental in Team discussions, Mentoring and Knowledge Transfer.
• Responsible for Implementation & Post Implementation support
• Documentation of scripts, specifications and other processes.

Environment: Teradata V2R12, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, TPUMP, UNIX Shell Scripting, Windows XP.

Confidential

Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Writing MultiLoad scripts, FastLoad and Bteq scripts for loading the data into stage tables and then process into BID.
• Developed Scripts to load the data from source to staging and staging area to target tables using different load utilities like Bteq, FastLoad and MultiLoad.
• Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Developed mappings in Informatica to load the data from various sources using different transformations like Look up (connected and unconnected), Normalizer, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.
• Used Informatica designer to create complex mappings using different transformations to move data to a Data Warehouse.
• Developed UNIX shell scripts to run batch jobs and loads into production.
• Involved in Unit Testing and Preparing test cases.
• Involved in Peer Reviews.
• Modification of views on Databases, Performance Tuning and Workload Management.
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc…

Environment: Teradata V14, SQL Assistant, Informatica,Teradata Utilities (Fast Load, Multi Load, Fast Export, SQL Assistant, Bteq, TPT),Control-M,UNIX,FTP.

Confidential

Teradata Developer

Responsibilities:

• Involved in Complete Software Development Life cycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities FastLoad, MultiLoad, t pump to load data
• Wrote BTEQ scripts to transform data.
• Created Semantic views on Teradata database
• Worked on Teradata parallel transport (TPT) to load data from databases and files to Teradata.
• Wrote views based on user and/or reporting requirements.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Used Informatica Power Center 9.0 for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Involved in performance and tuning of the ETL processes.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Environment: Teradata R12/R13, Teradata SQL Assistant, SQL, Informatica 9x, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT.

Confidential

Teradata Developer

Responsibilities:

• Analyzing and understanding the end user requirements and business rules.
• Involved in calculating project estimates.
• Designing the technical solution of Business requirement.
• Identify all potential issues during the requirement understanding phase and to describe actions to address those issues.
• Done the impact analysis in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
• Have prepared of detailed platform application design document based on the business requirements document
• Have involved in Data Profiling using SQL
• Identify the database objects like PL/SQL Procedures, tables and views, which will be impacted as part of requirement.
• Identify scripts like Bteq, M Load, F Load and TPT, which will be impacted as part of particular project requirement.
• Coordinating and delegating the work to other team members.
• Responsible for Technical implementation of the change request solution.
• Creating/Modifying the database objects and scripts to achieve the task.
• Supporting enterprise data warehouse and ETL development activities.
• Implement the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Data Analysis and issue identification.
• Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance.
• Post production implementation support responsibility.

Environment: Teradata Utilities (Fast Load, Multi Load, Fast Export, SQL Assistant, Bteq), Teradata SQL