SUMMARY

• 10 years of extensive experience as a Technical & Functional Consultant in Analysis, Design, Development, Testing, Version upgrades, Data migrations, conversions, Customizations and spread across Implementations of Software Applications using Oracle Technologies.
• A competent professional wifover 8+years of experience in design, development, implementation, testing,maintenance and administration of Teradatadatabase
• Experienced on Teradata Database Architecture, DatabaseFeatures,Teradatatools and worked onTeradataDatabase Internals Parser, Optimizer and teh Amp modules
• Experience in using Teradatatools and utilities likeBTEQ, SQLAssistant, TSET,TeradataAdministrator,TeradataManager,TeradataWorkload Analyzer,TeradataVisual Explain,TeradataIndex Wizard,TeradataStatistics Wizard, Fast Load, Multi Load, TPump, ARCMAIN (Archive/Recovery), FastExport, DBQL, QCD, QRYSESSION,CTL,Filer,Rebuild,Check Table,AbortHost, DIP, DBSCONROL,LokDisp,Priority Scheduler(schmon),Recovery Manager, Tpareset, Vproc Manager.
• Strong Knowledge onSQL, DDL, DML’s, various types of Indexes,JoinPlanning, JoinMethods, JoinTypes, Joinalgorithms used inTeradata Database.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer andTeradataSQL Assistant.
• Experience on utilities like Fast Load,Multi Load,TPump,Fast Export,tpt.
• Experience in Database Programming, SQL, PL/SQL (StoredProcedures, Functions and Triggers) for faster transformations and Development using Teradata.
• Ability to deliver quality improvements and streamlining processes in a cross functional environment
• Experience inData warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation

PROFESSIONAL EXPERIENCE

Confidential

Senior Teradata Developer/DBA

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying teh data sources required for teh requests.
• Proficient in importing/exporting large amounts of data from files toTeradataand vice versa.
• Developed teh DW ETL scripts using BTEQ, Stored Procedures, Macros inTeradata
• Development of scripts for loading teh data into teh base tables in EDW using Fast Load, Multi Load and BTEQ utilities of Teradata.
• Created numerous scripts wifTeradatautilities BTEQ, MLOAD and FLOAD
• Developed mappings to load data from Source systems like Oracle, AS400 to Data Warehouse
• Highly experienced in Performance Tuning and Optimization for increasing teh efficiency of teh scripts.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using theTeradataadvanced techniques like rank, row number
• Communicated wif business users and analysts on business requirements. Gathered and documented technical and business Meta data about teh data.
• Worked on Data Verifications and Validations to evaluate teh data generated according to teh requirements is appropriate and consistent.
• Tested teh database to check field size validation, check constraints, stored procedures and cross verifying teh field size defined wifin teh application wif metadata
• Experienced in using OLAP functions like sum, count, csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to teh marketing and financial departments usingTeradataSQL.
• Experience in Power Point Presentation (Financial Data, Charts).
• Expertise in generating 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.
• CreatedData moverjobs for data moving from PROD to DEV/TEST.
• SupportProduction, Test & Development environmentsfor a large enterprise data warehouse project.
• Used highly tuned queriesdat facilitate action-taking or decision making in a time-sensitive environment by usingTactical queries.
• Took advantage of techniques such as request (query plan) caching and session-pooling by usingTactical queries.
• Create / Modify / DropTeradataobjects like Tables, Views, Join Indexes, Triggers, Macros, Databases.
• HandledUSER management requestssuch as creating newUsers& Profiles, and Roles.
• Extensively usedBTEQ scripts on UNIXto execute application specific scripts, transform data.
• Actively involved indesigning teh primary indexes, secondary indexeswif teh application team for tables.
• Done different types ofBackup jobssuch asDaily/Weekly/MonthlyandFull/Online backupandPPI&Triggeredbased backup jobs inNetvault/NetbackupGUI Tool.
• Having good experience wif Backup and Recovery usingTeradataARCMAINin Net Vault.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• MonitorTeradataDatabase usingTeradataViewpoint,Performance MonitorandTeradataManager.
• Recommend users to improve teh performance of teh query by changing teh Primary Index, use global temporary table, volatile table & derived table for intermediate results.
• Establish / recommend technical database administration standards, archiving strategy and security policies standards to ensure databases are compliant and optimized.
• Write, test and implementTeradataFastLoad,MultiLoad,FastExportand BTEQ scripts, DML and DDL.
• Monitor Database /Table Space Usage &Skewness at Database/ Table / Vproc level
• Implement Partitioned Primary Indexes to improve performance of date range queries.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Reportspreparedfor CPU, IO, Space and presented it to client

Environment: Teradata14.1, FastLoad, Mload, FastExport, Tpump,TeradataSQL assistant 14.10BTEQ, BMC Remedy, WinSCP, tstl4514 Putty.

Confidential

Senior Teradata Developer/DBA

Responsibilities:

• Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
• Teh project involved extracting data from various sources, tan applying teh transformations before loading teh data into target (warehouse) Stage tables and Stage files.
• Created teh mappings using transformations such as teh Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Configured teh source and target database connections using .dbcfiles
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching teh business requirements toTeradataRDBMS.
• Worked wifDBAteam to ensure implementation of teh databases for teh physical data models intended for teh above data marts.
• Created properTeradataPrimary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all teh available AMPS. Considering both teh business requirements and factors, created appropriateTeradataNUSI for smooth (fast and easy) access of data.
• Adapted Agile software development methodology to ETL teh above data marts.
• Created mapping documents from EDS to Data Mart. Created several loading strategies for fact and dimensional loading.
• Designed teh mappings between sources (external files and databases) to Operational staging targets.
• Created properTeradataPrimary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all teh available AMPS. Considering both teh business requirements and factors, created appropriateTeradataNUSI for smooth (fast and easy) access of data.
• Did teh performance tuning forTeradataSQL statements usingTeradataExplain command.
• Created .dml files for specifying record format.
• Analyzed teh Data Distribution and Reviewed teh Index choices
• Tuning ofTeradataSQL statements using Explain analyzing teh data distribution among AMPs and index usage, collect statistics, definition of indexes
• Extensively worked under teh UNIX Environment using Shell Scripts.

Environment: TeradataRDBMS, BTEQ, FastLoad, MultiLoad, Fast ExportTeradataManager,TeradataSQL Assistant, Rational Clear Quest, UNIX, MQ, NDM, FTP.

Confidential

Senior Teradata Developer/DBA

Responsibilities:

• Assessed teh code and developing teh new logic to handle dis cost-based duplicate removal approach
• Documented teh HLSDS and SIS.
• Developing teh test cases to test teh developed code
• Fix teh bugs opened in feature testing.
• Designed & implemented code in teh Optimizer area
• Assessed teh code, identified teh root cause of problem and rendered fix for bugs identified during testing
• Updating teh system using teh dip and sysint.
• Version switching theteradatamachine using teh ctl.
• Enabling teh features using teh dbcontrol and diagnostics.
• Using teh tpareset and vprocmanager bring AMP online of found teh problem.
• Install theteradatapackages and upgrade and downgrade teh machine.
• Looked after theTeradata‘optimizer & teh dispatcher’ database code and related bugs. Developed test cases to test teh feature

ENVIRONMENT: TERADATA14,14.10,15.00,BTEQ,FLOAD,CHECKTABLE,CNSRUN,CTL,DIP,XDBW,DBSCONTROL,DUL,FERRET,GTWCONTROL,LOKDISP,SCHMON,QRYSESSN,RCVMANAGER,SHOWLOCKS,TPARESET,VPROCMANAGER.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developer, Up gradation & Migration of CARD system from oracle Forms 4.5 Version to Oracle Forms 6i Version
• Designed & Developed teh Application Using Oracle & Forms, Reports
• Managing R&D division wif continuous improvements
• Involved in creating teh Table space.
• Involved in estimating teh Hardware for teh Oracle software.

Environment: Oracle 8i, Oracle forms and reports 4.5 version,Windows,Linux.