SUMMARY

• Over 7 years of total IT experience andTechnical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modeling, Development, Database Administration, testing and documentation.
• Experience in TeradataDatabase design, implementation, and administration mainly in large - scale Data Warehouse environments
• Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning
• Good experience in Teradata RDBMS using FastLoad, MultiLoad, TPump, FastExport, Teradata SQL Assistant and BTEQ
• Experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis
• Experience in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers
• Worked on full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support
• Experience in Query Analyzing, performance tuning and testing
• Experience in writing UNIX Korn shell scripts to support and automate the ETL process
• Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x - Power Center, Power Mart, Client tools-Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange
• Experience in testing the applications and creating test cases for Unit Testing, Integration Testing and make sure the data extracted from source is loaded into target properly in the right format
• Experience in troubleshooting of Informatica jobs and addressing issues like performance tuning and enhancements
• Excellent understanding of Software Development Life Cycle (SDLC).
• Strong technical background, and posses excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.
• Excellent communication skills, both written and verbal.

TECHNICAL SKILLS

DataWarehousing Database Tools: Teradata 14.0/13.10/V12/V2R6/V2R5; SQL Client Configuration utility, SQL Management Studio, SQL Server Business Intelligence Development Studio

Teradata Utilities: BTEQ, FastLoad, MultiLoad, FastExport, SQL*Loader,Teradata SQL Assistant, Exp/Imp.

ETL Tools: BTEQ, Informatica.

Reporting Tools: Business Objects,OBIEE 10.x, Excel.

Databases: Teradata, MS SQL Server 2005/2008,Oracle, MS-Access

Other Tools: .Net frame work, MS Office, Quality centre 9.0

Languages: SQL, HTML, XML, PL/SQL, C programming, java

Operating Systems: Windows XP/2000/98, Win NT, UNIX, MS-Dos

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Teradata Developer

Responsibilities:

• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata
• Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirements
• Performed tuning and optimization of complex SQL queries using Teradata Explain
• Created a BTEQ script for pre population of the work tables prior to the main load process
• Used volatile table and derived queries for breaking up complex queries into simpler queries
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse
• Involved heavily in writing complex SQL queries to pull the required information from Database using TeradataSQL Assistance
• Created a shell script that checks the corruption of data file prior to the load
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fastload, Multiload) and working with loader logs
• Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Involved in troubleshooting the production issues and providing production support
• Streamlined the Teradata scripts and shell scripts migration process on the UNIX box
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
• Involved in troubleshooting the production issues and providing production support
• Worked in Agile methodology where I had to involve in daily scrum meetings to discuss about deliverables of the project.
• Involved in the internal team meetings to update the status of the project.
• Developed unit test plans and involved in system testing

Environment: Teradata 14.0, MVS,TeradataSQL Assistance13,Hadoop,Hive, TeradataUtilities (Mload, Fastload, FastExport, BTEQ),TPT,UNIX Shell Scripting,MS Office, Windows XP.

Confidential, Schenectady, New York

Sr. Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules
• Work with the data modelers, architects and Cognos developers to create a consumption layer in Teradata and Congos.
• Performance optimization on the data and consumption layer in Teradata
• Create and Maintain Teradata Tables, Views, Macros, Triggers and Stored Procedures
• Coding using Teradata Analytical functions, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• 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
• Created a BTEQ script for pre population of the work tables prior to the main load process
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Create and Maintain Teradata Databases, Users, Tables, Views and Macros
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment
• Developed processes on both Teradata using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata), Exposure to Tpump on UNIX environments
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database
• Responsible for loading data into warehouse from different sources using Multiload and Fastload to load millions of records
• Involved in Performance tuning for the long running queries
• Developed UNIX shell scripts to run batch jobs in production
• Performed tuning and optimization of complex SQL queries using Teradata Explain
• Application development that enables data to be moved from legacy systems and 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
• Led the development Team of 5 members, estimated the work efforts in terms of hours and resources based on the requirements
• Collaborated with Project Manager to prioritize development activities and subsequently handle task allocation with available team bandwidth.

Environment: Teradata 13.0, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, Unix Shell scripts, Informatica 8.6, Cognos, FTP.

Confidential, Mount Laurel, New Jersey

Teradata Developer

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Converting Logical models into physical models using data modeling software like Erwin.
• Involved in Designing the ETL process to Extract, transform and load data from OLTP Oracle database system to Teradata data warehouse.
• Monitor and maintain a production Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Maintain and Tune Teradata Production and Development systems.
• Supported application development time lines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production Teradata systems.
• Creating Mainframe datasets, submitting JCL, check the dataset files using File-Aid.
• Perform tuning and optimization of database configuration and application SQL, Define database backup & recovery strategies, implement and administer.
• Create and Maintain users for Production/Development Teradata Systems.
• Created Fast Load, Fast Export, Multi Load, TPUMP, BTEQ to load data from Oracle database and Flat files.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Converting existing Oracle/SQL Server data into Teradata.
• Dynamically set query priorities using Teradata scheduler. Capacity Planning: Re-size storage and spool space proactively, to accommodate growing data content.
• Gather information from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi Load, BTEQ and Unix shell scripts.

Confidential, Fairfield, NJ

Teradata Developer

Responsibilities:

• Worked on Balancing Process of Enterprise Data Warehouse.
• Thoroughly studied HYBRID Model of Enterprise Data Warehouse.
• Closely worked with ETL & Data Modeling teams to identify and updating the balancing defects.
• Created Join indexes and Temporary tables to improve the query processing.
• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance
• Created Unix Shell Scripts to load the data into Data Warehouse
• Creation of customized Mload scripts on UNIX platform for Teradata loads using Informatica.
• Fine tuning of Mload scripts considering the number of loads scheduled and volumes of load data.
• Written scripts to extract the data from Oracle and load into Teradata.
• Worked on exporting data using Teradata FastExport.
• Written Teradata BTEQ scripts to implement the business logic.
• Hands on with Teradata Queryman to interface with the Teradata.
• Involved in writing proactive data audit scripts.
• Involved in writing data quality scripts for new acquisitions integration
• Developed complex transformation code for derived duration fields.
• Developed BTEQ scripts to extract data from the detail tables for reporting requirements.
• Created the Project documentation, System and Integration Test cases.
• Code MULTILOAD, TPUMP and FASTLOAD scripts for use in conversion table load processes.
• Code MULTILOAD scripts to load data files using Teradata.
• Support UNIX batch cycle using KORN shell scripting.
• Coded TERADATA functions; Macros and stored procedures.
• Develop UNIX Shell Scripts to perform load tasks with complex TERADATA SQL
• Mentored new for application development using TERADATA, UNIX

Environment: Teradata 12.0 (BTEQ, FastLoad, MultiLoad, T-SQL, FastExport) IBM z/OS, FTP, RACF, FTP, JCL, TSO/ISPF, COBOL, DB2, Oracle, Informatica Power Center 8.0, Sun Solaris UNIX Shell-scripting

Confidential, Washington DC

Teradata Developer

Responsibilities:

• Migrated tables from Oracle to Teradata.
• Wrote BTeQ and Mload scripts to load data from Oracle to Teradata.
• Helped V-MIS in preparing usage inventory document.
• Analyzed the dependencies of existing job on Oracle data mart (BCMS).
• Used UNIX/Perl scripts to access Teradata & Oracle Data.
• Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools.
• Security and user management, repository backup was also done using the same tool.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Server Manager used for creating and maintaining the Sessions. Server Manger Also used to Monitor, edit, schedule, copy, aborts and deletes the session.
• Used ETL for efficient mapping and transformation techniques.

Environment: Red Hat Enterprise Linux 64-bit, Windows XP, Informatica Power Center 7.1, NCR Teradata V2R7.1.0, Business Objects 11, Crystal Reports 10.