SUMMARY

• Over 8+ years of experience in IT, with proficiency as Teradata developer and strong expertise in SQL queries, stored procedures, Teradata Macros.
• 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.
• Have experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Profound knowledge about the architecture of the Teradata database
• 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.
• 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).
• Extensively Worked with Teradata DBQL, thus analyzing the Teradata system performance
• Expertise in Migration of objects from Oracle databases to Teradata
• Good knowledge in Unix Shell scripting.
• Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics.
• Extensively worked on PMON/Viewpoint for Teradata to look at performance Monitoring and performance tuning
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Extensive experience in SQL tuning activities
• Hands on experience using query tools like TOAD, SQL Developer, PL/SQL developer, Teradata SQL Assistant and Query man.
• Expertise in writing large/complex queries using SQL.
• Experience in scheduling and running jobs using control - M, Autosys
• Skilled in creating custom transformations, functions and routines.
• Knowledge in Query performance tuning, managing and Request scheduling.
• Actively involved in Quality Processes and release management activities - To establish, monitor and streamline quality processes in the project.
• Proficient in preparing high/low level documents like design and functional specifications.
• Worked with a project development and test team providing support during the project cycle, helping develop optimum solutions for data warehouse and Reporting deliverables.
• 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

RDBMS: Teradata V2R5/R6/R12/R13, Oracle 8i/ 9i/10g/11g, MS SQL Server 2008/2005/2012

Tools: Teradata SQL Assistant, Teradata Manager, PMON, Putty, Informatica 8.6/7.1, TOAD, Control M, Autosys, ERWIN r 7/r4, Visio 2007/2010

Teradata Utilities: BTEQ, Fast load, Multi-Load, Fast Export, Teradata Macros, Query Man

Languages: SQL, PL/SQL, Shell scripting

Testing Tools: QTP, Quality Center, Rational Suite (Requisite Pro, Rose, Robot, Test Manager, Clear Quest, Clear Case), Selenium, HP quick Test Pro.

Operating Systems: UNIX (Sun-Solaris, HP/UX), Windows NT/ 2000/ XP and Linux

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Teradata DW Consultant

Responsibilities:

• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
• 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 to Data Warehouse
• Loading staging tables on Teradata and further loading target tables on Teradata via views.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Used various Teradata Index techniques to improve the query performance
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata
• Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
• Used for loading, Mload for modifying database objects.
• Created series of Macros for various applications in Teradata SQL Assistant
• Worked on Set, Multiset, Derived, and Volatile Temporary tables.
• Experience in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Performed Tuning and Optimization for increasing the efficiency of the scripts.
• Experience in Power Point Presentation (Financial Data, Charts).
• Generated 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.
• Involved in unit testing, system testing and integration testing

Environment: Teradata V12/V13, Teradata SQL Assistant, Oracle 10g,MVS, DB2, Tivoli, JCL, File aid, Control-M, Teradata PMON/Viewpoint, UNIX, SSH secure shell, Infosphere CDC, Infosphere Data Stage SAP Business objects

Confidential, NYC, NY

Sr Teradata Developer

Responsibilities:

• Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Involved in the analysis and implementation of their system.
• Managed Scope and change throughout the SDLC process of the product.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers Designed and developed use cases, activity diagrams, and sequence diagrams using UML
• Written several Teradata BTEQ scripts to implement the business logic
• Used Fast Load for loading the data into the empty tables
• Converted batch jobs with BULKLOAD utility to TPUMP utility
• Coded Multi Load scripts to load the data into different tables
• Wrote Fast export scripts to export data
• Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata SQL
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD
• Used Teradata SQL to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles
• Used various Teradata Index techniques to improve the query performance
• Worked on Teradata Query man to validate the data in warehouse for sanity check
• Performed bulk data load from multiple data source (ORACLE 10g, legacy systems) to Teradata RDBMS using BTEQ, Fastload, Multiload and TPump
• Performed Space Management for Perm & Spool Space
• Performance tuned ETL Batch jobs, Reporting and Ad-hoc SQL.
• Collected statistics every week on the tables to improve performance.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program.
• Developed test plans with QA team and helped test every scenario using Mercury Test Director Tool for system testing
• Participated in the support of BI applications with IT applications and technical staff.

Environment: Teradata R12, Teradata SQL Assistant, SQL Server 2008, Oracle 10g, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, DBQL, Erwin r7, Shell Scripts, Windows

Confidential, Frederick, MD

ETL/Teradata Developer

Responsibilities:

• Participated in the design phase of the project
• Created Scripts using Teradata utilities (Fast load, Multi load, Fast export, Tpump, BTEQ)
• Extensively used loader utilities to load flat files into Teradata RDBMS
• Performed high volume maintenance on large Teradata tables using MultiLoad loader utility
• Involved in Datawarehouse development using Teradata, Oracle and Unix
• Participated in Data mapping sessions with the Data modeller
• Developed load scripts from Source to target such as MIDE, MODE,SHUB into a centralized ODS called CMIE
• Analyzed the existing CDC technique used by Oracle to implement using Ab initio
• Used various Teradata Index techniques to improve the query performance
• Created Unix Scripts to run Teradata Scripts
• Performed Data profiling on the source data and created a list of valid values to populate the domain table list

Environment: Teradata V2r6, Teradata SQL Assistant, MVS, DB2, JCL, File aid, Control-M, Teradata PMON/Viewpoint, UNIX, SSH secure shell

Confidential, Ohio

Teradata developer

Responsibilities:

• Design and Developed logical and physical data model of systems that hold terabytes of data
• Worked on exporting data using Teradata fast export.
• Written Teradata Bteq scripts to implement the business logic.
• Coded Mload and Fload scripts to load the data files into Teradata.
• Extracted data from existing data source and performed ad-hoc queries using SQL.
• Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), views, using SQL scripts
• Involved in query Performance Tuning for accessing the data fast.
• Exported data into flat files in .csv, tab fixed delimiters and etc. formats.
• Documentation of scripts, specifications and other processes.
• Coded Teradata functions using macros and stored procedures.

Environment: Teradata, SQL Assist Oracle, SQL, PL SQL, MS Excel, PowerPoint. Windows

Confidential

Systems Analyst

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.
• Involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages.
• 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.
• 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.
• Documentation of all modules for user level and system level maintenance.
• 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

Confidential

Programmer

Responsibilities:

• Developed Business Process Documentation on existing information flows/systems.
• Met with Business Users, identified major functions of the organization and documented the processes required to perform the functions.
• Presented executive summaries comprising market analysis, feasibility reports and performance opportunities for company’s upcoming variable annuity product.
• Extensive programming in PL/SQL, Created stored procedure and functions.
• Developed triggers to enforce Integrity constraints, cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling.
• Used SQL Loader to load data from flat files into target tables in Oracle.
• Worked with table partitions and Database locks and Updated and maintained the database in Oracle.

Environment: Oracle 7i, SQL Loader, Shell Scripts, PL/SQL, PERL, Windows, UNIX.