SUMMARY

• Over 7 years of extensive experience in data migration, data warehousing database design and manual testing.
• Extensive experience with ETL/Data warehousing tools.
• Involved in various stages of Software development life cycle.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in - depth understanding in Database Hierarchy, Data Integrity concepts.
• Skilled in Data Warehousing Data Modeling using Star Schema and Snowflake Schema.
• Good knowledge of Teradata RDBMS Architecture, Tools & Utilities.
• Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, IBM DB2, Oracle, and SQL Server and loaded into Oracle and Teradata DW.
• Extracted source data from Mainframe Z/OS using JCL scripts and SQLs into Unix Environment and Created a formatted reports for Business Users using BTEQ scripts
• Strong Teradata SQL, ANSI SQL coding skills.
• Expertise in Report formatting, Batch processing, Data Loading and Export using BTEQ.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes
• Well versed with Teradata Analyst Pack including Statistics Wizard, Index Wizard and Visual Explain.
• Developed UNIX shell scripts and used BTEQ, FastLoad, MultiLoad, and Fast Export utilities extensively to load to target database.
• Skillfully used OLAP analytical power of Teradata by using OLAP functions such as Rank, Quantile, Csum, MSum, group by grouping set etc. to generate detail reports for marketing folks.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the BTEQ scripts.
• Involved in designing and building stored procedures and macros for the module.
• Expertise in Oracle 9i/8.x/7.x, SQL/PLSQL, Procedures, Functions, Database Packages and Triggers. And experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.
• Good knowledge of Performance tuning, Application Development and Application Support on UNIX, MVS and WINDOWS NT Environments.
• Developed UNIX Shell scripts for Batch processing.
• Responsible for writing Deployment/Release Notes before the project release and End Users Manual for production team.

TECHNICAL SKILLS

Operating Systems: Windows XP, 2000, UNIX/Linux.

Database: Teradata Express Edition 12.0, V2R5/V2R6.0, Oracle (8i/9i/10g), SQL Server 2000, DB2.

Teradata tools & Utilities query facilities: SQL Assistant, BTEQ.

Load & Export: Fast Load, Multi Load, Fast Export, BTEQ, OLE load, Oracle SQL Loader.

ETL: Informatica 8.1, Datastage7.5.

Languages: C, C++, Java, Visual Basic, ASP.Net, JCL.

Scripting languages: UNIX Shell, JCL, Java Script, VB Script, Perl.

Others: Business Objects, Cognos, and Auto Sys.

PROFESSIONAL EXPERIENCE

Confidential, FL

ETL/Teradata Developer

Responsibilities:

• Worked on loading of data from several flat files sources using Teradata Fast Load and Multi Load.
• Writing Teradata SQL queries to join or any modifications in the table.
• Transfer of large volumes of data using Teradata Fast Load, Multi Load and T-Pump.
• Database-to-Database transfer of data (Minimum transformations) using ETL (Data Stage).
• Fine-tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance.
• Creation of customized Mload scripts on UNIX platform for Teradata loads using Data Stage.
• Sorted data files using UNIX Shell scripting.
• Fine tuning of Mload scripts considering the number of loads scheduled and volumes of load data.
• Used data profiler in ETL processes, Data integrators to ensure the requirements of the clients including checks on column property, column value, and referential integrity.
• Acted as a single resource with sole responsibility of Data Stage - Teradata conversions.
• Written scripts to extract the data from Oracle and load into Teradata.
• Worked datasets for analysis.
• Worked with SAS on exporting data using Teradata Fast Export.
• Written Teradata BTEQ scripts to implement the business logic.
• Hands on with Teradata Queryman to interface with the Teradata.
• Used SQL Profiler for trouble shooting, monitoring, optimizing SQL Server From developers and testers.
• Used UNIX scripts to access Teradata & Oracle Data
• Developed UNIX shell scripts for data manipulation
• Involved in writing proactive data audit scripts.
• Involved in writing data quality scripts for new market integration.
• Developed complex transformation code for derived duration fields.
• Developed BTEQ scripts to extract data from the detail tables for reporting requirements.

Environment: Teradata V13.10 (BTEQ, Fast Load, Multi Load, Teradata SQL, Fast Export), Oracle, Mainframes MVS/OS, JCL, TSO/ISPF, COBOL, DB2, SAS, Business Objects 3.1, Crystal Reports 11, Shell-scripting.

Confidential, NJ

ETL/Teradata Developer

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Involved in the design of complex campaigns for the Business users to accomplish different marketing strategies.
• Coordinated with the test team in the design of test cases and preparation of test data to work with different Channels, setup regency and timeout for the Campaigns.
• Involved in running the batch process for Teradata CRM.
• Creation of BTEQ, Fast export, Multi Load, TPump, Fast load scripts.
• Worked on complex queries to map the data as per the requirements.
• Extracted data from various production databases SAS, SYBASE, and Teradata to meet business report needs.
• Designed and implemented stored procedures and triggers for automating tasks in SQL.
• Worked on some critical problems like booked metrics and solved them successfully using SAS/SQL
• Interacted with technical and business analyst, operation analyst to resolve data issues
• Analyze the current data movement process and procedures.
• Used Data profiler to allow the analysis of data directly in the database, which improves performance, while eliminating the time and costs of moving data among databases.
• Identify and assess external data sources as well as internal and external data interfaces
• Created and updated MS Excel mapping document by doing field level analysis and field mapping.

Environment: Teradata Visual Explain, BTEQ, Teradata Manager, Teradata SQL Assistant, FastLoad, MultiLoad, Fast Export, Rational Clear Quest, Control-M, UNIX, MQ, NDM, FTP.

Confidential, Chicago, IL

Teradata Developer

Responsibilities:

• Migrated tables from Oracle to Teradata.
• Wrote Bteq and Mload scripts to load data from Oracle to Teradata.
• Helped in preparing usage inventory document.
• Analyzed the dependencies of existing job on Oracle data mart.
• 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 Linux64-bit, Windows XP, Informatica Power Center 7.1, NCR Teradata V2R7.1.0, Business Objects 3.1, Crystal Reports 10.

Confidential, Philadelphia, PA

Teradata Analyst

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Create export scripts using Teradata Fast Export Utility.
• Create data manipulation and definition scripts using Teradata Bteq utility.
• Involved in the design and implementation of the Module.
• Create load scripts using Teradata Fast Load and Mload utilities.
• Involved in System Testing, UAT, Regression Testing.
• Carry out the Enhancement work as per the MCR given by Client.
• Created UNIX Scripts to manipulate and Load the data.
• Code Reviews.
• Attending corporate meeting for the kick-off of major enhancements at corporate level.
• Organizing meeting with the SME’s of the dependent systems when changes are done for the existing system.
• Involved in documentation for the customer deliverables and preparing user documentation.

Environment: Teradata RDBMS, BTEQ, Fast Load, Multi Load, Fast Export Teradata Manager, Teradata SQL Assistant, Rational Clear Quest, UNIX, MQ, NDM, FTP.

Confidential

Software Engineer

Responsibilities:

• Creating oracle instances and maintaining on Windows platform.
• Applying patches to the RDBMS server.
• Involved in troubleshooting oracle related issues.
• Was involved in coordinating between the development and the database team.
• Involved database related technical writing.
• Used SQL* loader to load data into the databases.
• Wrote PL/SQL procedures/packages/triggers for various application purposes.

Environment: Windows-NT, Oracle 8i, SQL* Plus, MS Word, PL/SQL, PL/SQL Developer.