PROFESSIONAL SUMMARY

• 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, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL 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).
• Good knowledge in Unix Shell scripting.
• Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics.
• In-depth hands on experience in database, ETL/ELT design and development and should have excellent data analysis skills
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Good knowledge on Agile Methodology and the scrum process.
• Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basic data modeling.
• Very good in Fast learning, Analytical thinking, decision making and problem solving skills.
• Have experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Proficient in preparing high/low level documents like design and functional specifications.
• Actively involved in Quality Processes and release management activities - To establish, monitor and streamline quality processes in the project.
• Very good in Analytical thinking, decision making and problem solving skills.
• Involved in review meetings with Project Managers, Developers and Business Associates for Project
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.

TECHNICAL SKILLS

Operating Systems: MS DOS, UNIX, Windows NT/ 2000/ XP and Linux
Languages: COBOL, JCL, JAVA, SQL, PL/SQL, Teradata Macros, BTEQ, MLOAD, FASTLOAD, FAST EXPORT, Shell scripting
RDBMS: Oracle 8i/ 9i/10g, MS SQL Server, Teradata V2R5/R6/R12/R13
Testing Tools: QTP, Quality Center, Rational Suite (Requisite Pro, Rose, Robot, Test Manager, Clear Quest, Clear Case), Selenium, HP quick Test Pro.
Tools: Teradata SQL Assistant, Teradata Manager, PMON, Putty, Informatica

Confidential, Englewood, CO
Jan 2011 – Till Date
Sr. Teradata Developer

Responsibilities

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• 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.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.
• 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, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, DBQL

Confidential, NJ May 2009 – Jan 2011
Teradata ETL Developer

Responsibilities

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• 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.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.
• 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
Oracle, Teradata, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, DBQL

Responsibilities

• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
• Agile team interaction.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• 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.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Extensively used SQL Analyzer and wrote complex SQL Queries using joins, sub queries and correlated sub queries

Environment
Oracle, Teradata, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT

Responsibilities

• Analyzed Business Requirements Documentand Functional Specification document to develop detailed Test Plan and Test Cases.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data.
• Worked on Oracle PL SQL to create stored procedures, packages and various functions.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• 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.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.

Environment
Oracle, Teradata, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT

Confidential, India Jul 2004 - Sep 2006
Oracle / Teradata Developer

Responsibilities

• Coordinate with the front end team working on Oracle Forms to provide with the necessary stored procedures and packages and the necessary insight into the data.
• Extensively involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages.
• Extensively involved in debugging the existing PL/SQL objects.
• Performance tuned SQL queries using Hints, AUTOTRACE, TKPROF, ADDM, AWR, Explain Plan and SQL advisor
• Created Materialized views and presented to BI teams.
• Created Ref cursors, Bulk processing, collections, nested tables.
• Performed bug verification, release testing and provided support for Oracle based applications.
• Involved in performance tuning the existing objects.
• Extensively used SQL*LOADER and UTL_FILE to load data from flat files obtained from various facilities every day.
• Used External tables to manipulate data obtained daily before loading them into the tables.
• Extracting thousands of data from the database for data analysis.
• Extracting and moving data from UNIX.
• Helped the QA team in QC’ing the data and to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Monitoring and scheduling jobs.
• Documentation of all modules for user level and system level maintenance.
• Leading the junior developers in doing their tasks.
• Worked in a CMMI level 3 coding standards.

Environment
Oracle 8i, UNIX, SQL, PL/SQL, SQL Developer and TOAD, SQL*Loader, Data pump, Crystal Reports, Erwin, VSS, Outlook, Putty.