SUMMARY

• Progressive and innovative software professional wif over 7 years of Data Warehousing experience. Over 5 years of experience on Teradata development and DBA for OLTP & OLAP environment on Very Large Databases(VLDB).
• Having Good experience in installing and configuring databases on TD13/TD12.
• Performed various database administration tasks like creating database such as Database Console utilities, security, work - load management.
• Worked on databases sizes ranging up to 15TB.
• Have hands on experience wif issues around database, client tool, and hardware upgrades and have Ability to write, debug and tune sql, macros, procedures, implementation of multi-value compression.
• Strong hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Fast Export, T-pump, Visual Explain, Query man, Win DDI).
• Having good experience wif Teradata Parallel Transporter in database migration.
• Having good experience in Capacity Planning Practices for Forecasting Disk.
• Experience in Backup and Restore (BAR) methodologies. Design, implement and coordinate all back-up and restore strategies
• Ability to develop documentation of process and procedures for implementation plans.
• Ability to develop shell scripting in C, ASP, .net, COBOL, and JCL.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Strong hands in utilities like Teradata Manager, Administrator, SQL Assistant, TSET, Visual Explain, Arcmain, TASM.
• Experience wif the Linux operating system and command set as well as competence wif shell scripting and having good Experience wif database monitoring and tuning tools such as Teradata Manager and PMON.
• Expert in Performance tuning by creating indexes, optimizing execution plans, proper usage of indexes, and partitioning .
• Expertise in using TD13/TD12/V2R6, TPT, BTEQ, Teradata SQL assistant, T-Pump, Multi-load, Informatica, Fast Load and Fast Export.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN,Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Created ETL dependency scripts, stored procedures and macros.
• Strong knowledge in Teradata along wif SQL assistant and BTEQ experience.
• Written BCP/FASTLOAD, SPOOL/FASTLOAD scripts to load the large size tables from Different servers.
• Familiar in Creating Primary indexes, Secondary indexes, Partition Primary Indexes and Join/Hash indexes in Teradata.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems and Used extensively Derived Table, Volatile Table and Global Tables in many of the BTEQ scripts.
• Experienced in reading Explain statements and understanding data skewing, and performance monitoring.
• Expertise in different data sources ranging from flat files, MS SQL Server, MS Access, MS Excel, SQL on Windows platforms.
• Excellent communication, presentation and interpersonal skills and having Strong troubleshooting and organizational skills.
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS

RDBMS: Teradata V2R6/V12/V13,Oracle 9i/ 10g/11g, MS SQL Server.

Programming: C, Java, & T-SQL.

Operating System: MS DOS, Windows NT/ 2000/ XP, Solaris and UNIX

Utilities: Teradata SQL Assistant, PMON, BTEQ, M Load, T Pump, BTEQ FASTLOAD, FAST EXPORT.

Tools: TOAD 8.6.1, Arcmain, Teradata Adminstrator, Visual Explain, TASM, Putty, SQL Assistant,PMON

Web Technologies: HTML, HTML5,CSS,XHTML.

Other: Microsoft products (word, excel, power point, outlook), Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Teradata DBA

Responsibilities:

• Database and Data Architecture, Modeling, Design, Development and Administration.
• Worked to tune the performance of the applications and Backups.
• Involved in developing Unit Test cases for the developed mappings.
• Extensively worked in the performance tuning of transformations, Sources, Sessions, Mappings and Targets.
• Used ETL methodology for supporting data extractions, transformation and loading process.
• Involved in the logical and physical design of the database and creation of the database objects.
• Ensured data integrity and referential constraints for accurate database operations.
• Encapsulated the functionality into packages for an easy interface to the front end.
• Create and Maintain load jobs using Bteq, Fast load and M load.
• Worked wif UNIX shell scripts and Perl Scripts.
• Extensively used Autosys Job Scheduler Tool.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Performed Data analysis and Data validations.
• Coordinating tasks and issues wif Project Manager and Client on daily basis.
• Troubleshooting slow running queries and stored procedures.
• 24x7 on-call support on alternate weeks.

Environment: Teradata13, SQL, BTEQ/BTEQWin, TPT, Fast-Load, M Load, FastExport, and Teradata SQL assistant 7.0/6.1, Informatica Power Center 8.5/7.1,Ab Initio, Erwin4.0, Connect: Direct, Syncsort, Tivoli maestro, Oracle 10g/11g, Solaris 8, Windows XP/2000, NCRs 5400E MPP.

Confidential, St.Louis, MO

Teradata DBA

Responsibilities:

• As DBA, the responsibilities were to deliver new and complex, high quality solutions to clients in response to varying business requirements.
• Implementation of the New Database, including Creating users, Database Objects .
• Profile, Role management of database users.
• Physical implementation of LDM for the Warehouse, including selection and implementation of Indices, MPPIs, Semantic layer, and Performance AJI structures.
• Current Space usage analysis, and recommendation regarding the utilization of space.
• Statistics Analysis and selection and implementation of the system wide object demographic Statistics.
• Compression analysis and implementation.
• User sessions analysis, resource usage analysis and implementation of the required Workloads.
• Weekly planning and implementation of Backup and Archiving Activities using Net Vault Backup utility.
• Identified potential bottlenecks wif user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) .
• Usage of Teradata Explain and Visual Explain to analyze and improve query performance.
• Implementing the Teradata manager Services to enable the system wide resource collection, and reporting.
• Implementing the Alerting mechanism for the Production system using the Alerting service both to SNMP, and SMTP
• Upgrading the Teradata manager services to Viewpoint
• Performing database health checks and system health checks on a regular time frame.
• Mentoring the DBA Team for Operations.
• Used IBM Rational Clear Case as a version tool.
• Worked on Tivoli Work Scheduler.
• Supported24 X 7 Production environment.

Environment: Teradata V2R12, SQL, BTEQ/BTEQWin, Fast Load, Multi Load, Fast Export, PMONT pump, Visual Explain Query man, Oracle 8i, PL/SQL, UNIX, IBM Mainframes, Windows NT/2000,NCRs world mark 5200 MPP.

Confidential, Los Angeles, CA

Teradata Developer/DBA

Responsibilities:

• Involved in Data Extraction, Transformation and Loading from source systems.
• Performed Data analysis and prepared the Physical data base based on the requirements.
• Performed Data validations.
• Responsible for populating warehouse-staging tables.
• Responsible for capacity planning and performance tuning.
• Prepared Performance Matrices.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Developed BTEQ scripts for Teradata.
• Automated Workflows and BTEQ scripts
• Responsible for tuning the performances of Informatica mappings and Teradata BTEQ scripts.
• Worked wif DBAs to tune the performance of the applications and Backups.
• Worked on exporting data to flat files using Teradata Fast EXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively wif the Teradata SQL Assistant to interface wif the Teradata.
• Written various Macros and automated Batch Processes
• Integrate high volumes of data wif significantly reduced impact to the production system. Support continuous extract, transform, and load functionality across systems using INFORMATICA.
• Changes are captured as they happen, allowing up-to-the-minute data to flow between systems to support real-time reporting, business intelligence, and synchronization of applications by CDC
• Used Repository Server Administration Console to create and backup Repositories.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files.
• Used CVS as a versioning tool.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Coordinating tasks and issues wif Project Manager and Client on daily basis

Environment: Teradata V12, SQL, BTEQ/BTEQWin, Fast Load, Multi Load, Fast Export, Ab InitioTpump, Visual Explain, Teradata SQL assistant 6.1, Oracle 10g, PL/SQL, SQL Loader, UNIX, ControlMVisual Source Safe, Windows XP/2000,NCRs world mark 5200 MPP systems wif 16 CPU and 4 Nodes.

Confidential, Hartford, CT

Teradata Developer

Responsibilities:

• Collaborated closely wif client managers, architects, and DBA’s and business users.
• Developing the queries using Teradata SQL Assistant.
• Created tables as required by the users for most frequently used data and written scripts for those tables.
• Involved in performance tuning of the SQL queries and the reports.
• Helping in maintenance work related to reports.
• Extracted from OLTP system to dump files and upload to data warehouse using Fast Load, Multi Load and TPump.
• Debugged the problems when migrating from Oracle to Teradata (Conversion of data types, Views, Synonyms, tables etc.).
• Designed and developed Ab Initio graphs for the EDW.
• Using Ab Initio ETL to load the data to Data warehouse Systems. Using Ab Initio converted text files from ASCII to EBCDIC.
• Created and supported Development and Testing Teradata databases and proposed backup and recovery strategies to the client.
• Collect data on the current system configuration, resource usage, status of an individual Access Module Processor (AMP), Parsing Engine (PE), node and also the resource usage and status of an individual session.
• Interacted wif mainframe server running on MVS to extract the DB2 data available in data sets using JCL, which includes Teradata SQL statements and calls Teradata utilities like Fast Export, Fast Load, Multi Load and BTEQ.
• New Database Creation (Permanent, Temp and Spool Space allocation).
• New tables, macros, views and procedures creation.
• Query optimization - explain plans, collect statistics, data distribution across AMPs, Primary and Secondary indexes, locking etc.
• Transferring data between production and development environment.

Environment: Teradata 12, Ab Initio, SQL, BTEQ/BTEQWin, FastLoad, MultiLoad, FastExport, Tpump, Visual Explain Queryman, Oracle 10g, PL/SQL, UNIX, IBM Mainframes, Windows NT/2000,NCRs world mark 5200 MPP.

Confidential

SQL Developer

Responsibilities:

• Installed and configured MS SQL Server and Clients.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
• Managed Disk space, memory and User connections
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Established DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server
• Implemented and maintained Replication(Transactional, snapshot) using Dynamic scripts and solving problems
• Performed query tuning and reduced response time by 60%
• Discussions wif Product team for new features
• Performed query plans and enforced indexing in each and every query
• Propped up the new schema changes and additional new features on Development, Staging/QA and Production servers
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and creating Partition views for better performance.
• Programmed in T-SQL to implement Stored Procedures and Functions for different tasks
• Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor. Assisted the SQL Developers in query tuning and optimization.
• Created updatable partitioned views
• Created Stored Procedures and triggers to perform automated rules and updation of related tables.

Environment: MS SQL server 2000, Windows 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler