SUMMARY

• Over 11+years of IT experience in the Business Analysis, Design Data Modeling, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Energy, Sales & Distribution, Telecom Industries and banking .
• 9+ years of experience using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, exposure to T pump on UNIX/Windows environments and running the batch process for Teradata CRM.
• Experience in Dimensional Data Modeling using Kimball methodology.
• Proven client - facing skills, outstanding project success record, communication and collaboration excellence.
• Experience in Migration and Data Conversion from Oracle to Teradata.

TECHNICAL SKILLS

D W & BI: TeradataV13.10,InformaticaPowerCenter8/7.x/6.x/5.x,OLAP,OLTP,Microstrategy

Databases: Oracle 9i/8.x/7.x, MS SQL Server, MS Access, DB2, Teradata V2R5/V2R6

Programming: C, C++, UNIX Shell Scripting, PL/SQL

Environment: UNIX, Windows, Mainframes

Other Tools: Toad 8.5, SQL Navigator, control M, AUTOSYS, Tivoli, VMware

Web Servers: IIS 6.0, Apache 1.3.x, Sun One Web server, Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Teradata Lead

Responsibilities:

• Meeting with business customers and SME’s to gather business requirements to support developers in handling the design specification.
• Inventory the existing objects and processes. Convert DDL from Oracle to Teradata Database.
• Migrate history from Oracle tables to Teradata tables.
• Migrate ETL processes to point to or operate with Teradata Database.
• Sloe responsiblefor Semantic layer design and implementation.
• Organizing data values efficiently to meet the business requirements.
• Extensive experience in writing and executing scripts for validation and testing of the session, data integrity between source and target database and for report generation.
• Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
• Creating the Views based on the business requirement and consolidated the Views as a CASD.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Prepare the Technical spec based on the BA and DM sheets.
• Successfully handled migration of data across environments.
• Sole responsible for using of Logical Data Model and Physical Database design to build technical specs.
• Using Multi Load, Fast Load, Fast BTEQto populate target tables.

Confidential, Orlando, FL

Teradata- Lead

Responsibilities:

• Familiar with Logical Data Model and Physical Database design.
• Translate business rules/requirements into conceptual/logical dimensional model and worked with complex denormalized and normalized data model.
• Understanding SDD’s, Data required document and mapping documents.
• Creation of Data bases and users
• Space and User maintenance on dev machine
• Designing the ETLs and conducting review meeting.
• Involvement Daily loads, weekly loads.

Environment: Teradata V2R12, SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP, Sun Solaris 2.8

Confidential, Irving, TX

Lead Teradata Developer

Responsibilities:

• Working as a Teradata developer to load the data into FTW server.
• Using Teradata Utilities to load daily, weekly and monthly data.
• Using NPANXX and PN GUIDE tables to find PN states data.
• Analysis on Winback and Winover for Customer.
• Populate or refresh Teradata staging tables in BAU production for PN states.
• Preparation of Production support document.
• Preparing Test Cases and performing Unit Testing.

Environment: TeradataV2R12, SQLServer, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP

Confidential, Dublin, OH

Teradata Developer

Responsibilities:

• Working as a Teradata team lead to coordinate the team.
• Using SQL server DTS and Teradata.
• Communication with business users and analysts on business requirements. Gathering and documenting the technical and business Meta data about the project.
• Involved in discussions on the data requirement topics.
• Monitored Masking activity on the sensitive data.
• Worked with Teradata Analytical functions.
• Used Data Demographics to select columns for Primary Index.

Environment: Mainframe,Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP, Sun Solaris 2.8.

Confidential, Jersey City, NJ

ETL Developer

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Space estimations and User maintenance on dev machine.
• Designing the CDC and summary tables.
• Designing the ETLs and conducting review meets.
• Performance tuning the long running queries.

Environment: Informatica7.1/8, Oracle.

Confidential, New York

Teradata Developer

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities.
• Such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader.

Environment: Windows, UNIX, Vi Editor, Oracle 9i, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, SFTP, PMON, TD ADMINSTRATOR, Teradata manager.

Confidential, Rahway, NJ

Teradata Developer

Responsibilities:

• Communication with business users and analysts on business requirements. Gathering and documenting the technical and business Meta data about the data.
• The Teradata EXPLAIN facility, which describes to end-users how the database system will perform any request.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the
• SQL’s on UNIX environment.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing and loading history data into Teradata.

Environment: Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP, Windows XP, UNIX.

Confidential, Kansas City,KS

Teradata Developer

Responsibilities:

• Responsible for designing ETL strategy for both Initial and Incremental loads.
• Responsible for writing Program specifications for developing mappings
• Loaded data into Teradata using Fast Load, BTEQ, and FastExport, MultiLoad, and Korn shell scripts.
• Sending the stats report to the high level management using the pivot tables and xls graphs.
• Created mappings with different transformations, mapping parameters and variables

Environment: Informatica 6.1,Teradata V2R5, SFTP, BTEQ, Query man, Multi load, fast export,Oracle9i, ERWIN, PL/SQL, Perl, SQL*Loader, Visual Basic, SAS, Business Objects, Toad, Data Quality, Control M, UNIX and Windows, SQL Server.

Confidential

Teradata developer

Responsibilities:

• Created parameter file to reuse the mapplet/mapping for different criteria and wrote pmcmd, pmrepcommand scripts to automate the process.
• Created the mappings/workflows to FTP the files merge the files and integrate them in data store.
• Migrating objects from one environment to another.
• Improve the performance and functionality with the new requirement and feature.
• Moved maps to production after successful peer review, involved in change control documentation.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Involved in production support.
• Created Informatica Standards documentation to be followed by developers and to maintain consistency.

Environment: Informatica 7.1.1/7.1.4/6.2 , Oracle 8i/9i, Sybase 10, UDB/DB2, Teradata v2r4/v2r5, Flat files, PL/SQL, XML, TOAD 8.0, Tidal, Mantas, SQL, Erwin, UNIX, Sun Solaris, Test Director, Power Exchange 7.x, Business Objects 6x.