SUMMARY

• 8+ years of experience in the IT industry, coupled with extensive experience in Data Warehousing Teradata & UNIX Environment for Decision Support Systems.
• 7 Years of experience in Teradata Database design, implementation, maintenance and administration mainly in large scale Data Warehouse environments.
• Extensive experience in Administration and maintenance of Dev, Stage, prod and standby databases for DSS and Data Warehousing environments.
• Hands on experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata Parallel Transporter (TPT), Teradata SQL and BTEQ Teradata utilities.
• Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
• Experience in performance trending and analysis including recommending indexing strategies, partitioning, Join Indexes, compression opportunities and statistic collection planning.
• Experienced with handling RESUsage and DBQL data.
• Expertise in Dynamic Workload and Resource Management using TDQM.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Proficient in complex Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling (Star Schema, Snow - Flake schema Design and Normalized structures (3NF)).
• Proficient with MS SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
• Expertise in Query Analyzing and performance tuning.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager (TASM).
• Experience in Designing and implementing disaster recovery plans.
• Performed backup and recovery of Teradata databases using Arc utility.
• 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.
• Very good understanding of Reporting tools like Micro Strategy and Business Objects.
• Ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

Databases: Teradata V2R5 / V2R6 / 12/V13/V14, DB2, Oracle 8.x / 9.x/10.x/11.x

Tools: Viewpoint, Teradata Manager, Teradata Administrator, Teradata SQL Assistant, BTEQ, MLOAD, TPT, PMON, ArchMAIN, TASM, Tpump, ERWIN

Programming: PL/SQL, VBA, UNIX Shell Scripting, Teradata SQL, ANSI SQL, Transact SQL, C, SQL, C++, JAVA, HTML, XML, JavaScript, COBOL, JCL

O/S: NCR UNIX 00 / 5500, Sun Solaris 2.6 / 2.7, HP-UX, IBM AIX 4.2 / 4.3, MS-DOS 6.22, Novell NetWare 4.11 / 3.61

PROFESSIONAL EXPERIENCE

Confidential, Hoffman Estates, IL

Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Capacity planning including review and analysis of usage, capacity, and performance data.
• Performed Space Management for Perm & Spool Space.
• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Actively involved in the TASM workload management setup across the organization. To define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Backup and Recovery Operations Using Net-Backup & TARA
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Used various AMP based utilities like VPROC manager, Lockdisp, Showlock, Qrysessn.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Performed bulk data load from multiple data source (legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Used FastLoad for loading into the empty tables.
• Analyzed initial workload to understand the impact of various designs prior to having populated tables using TSET.
• 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.
• Collected statistics every week on the tables to improve performance.

Environment: Teradata 13.10/14,Viewpoint, Teradata Administrator Teradata Manager, Suse Linux, Shell Scripting,, Teradata SQL Assistant, Bteq, TPT, PMON, ArchMAIN, TASM, Tpump, Net Backup 6.5, BTEQ, ERWIN.

Confidential, Columbus,OH

Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Used various AMP based utilities like VPROC manager, Lockdisp, Showlock, Qrysessn.
• Involved in the analysis and implementation of their system.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Performed Space Management for Perm & Spool Space.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Used FastLoad for loading into the empty tables.
• 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.
• 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.
• Collected statistics every week on the tables to improve performance.

Environment: Teradata V12, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, Teradata Analyst Pack, MLOAD, ARCHMAIN, UNIX, Windows 2000, Shell scripts.

Confidential, Lisle, IL

Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Modified Databases, Users, Roles & Profiles, Views & Macros.
• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Performed Space Management for Perm & Spool Space.
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Dealt with Incremental data as well Migration data to load into the Teradata.
• Have experience in tuning some batch BTEQ queries.
• Enhanced some queries in the other application to run faster and more efficiently.
• Data was extracted from Teradata, Processed/Transformed using Ksh programs and loaded into Data Mart.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Implemented MS SQL Server Integration Services (SSIS) based solutions.
• Implemented MS SQL Server Analysis Services (SSAS), cubes and MDX based solutions.
• Architected and developed reports using MS SQL Server Reporting Services (SSRS)
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.

Environment: Oracle 9i, MS-Access, SQL SERVER, SSIS SSAS, SSRS,TOAD, Teradata Administrator, Teradata V2R6, Teradata SQL Assistant, Teradata Manager, SQL, UNIX and Windows NT.

Confidential, Cincinnati, OH

Teradata Developer/DBA

Responsibilities:

• Configured Load Utilities like FLOAD, MLOAD
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles..
• Constant Testing of Source and Target after loading to ensure Consistency in the Data
• Worked on call to ensure system availability
• Implementation of TASM and Analyst Packs to identify the system variations and SQL trends.
• Moved Teradata Databases from UNIX-MP RAS to Linux SUSE 64 bit to increase performance.
• Worked with Logical and physical data models with help of Erwin.
• Wrote scripts for BTEQ, and other tools.
• Used Teradata Tools and Utilities and configured them to understand the System.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Worked on Teradata Queryman to validate the data in warehouse for sanity check.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Upgraded older versions of Teradata through PUT utility.
• Analyzed performance after upgrade
• Worked on FSLDM to create physical data models.
• Performed Back up and Recovery activities as and when required.
• Monitored user sessions
• Implemented security as per the Norms of the Company.
• Automated recollection of stats by shell scripting as well as STATS Wizard.
• Selection of Indexes when creating a Table.
• Recommendation of SI and JI to influence the Optimizer.

Environment: Teradata V2R5, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.

Confidential

Software Developer

Responsibilities:

• Involved in identifying the activities for the development of I-Shipping Module job.
• Involved in the data transformation using XML and XSL by mapping the data to the scrapping engine.
• Had the responsibility of COM / DCOM, MTS, MSMQ implementation.
• Designed and developed dynamic web pages in HTML, CSS, JSP and DHTML for end users.
• Used PL/SQL codes extensively for the creation of forms and reports and Stored procedures and Functions for application Development
• Designed the DB connectivity using Active-X Data Objects (ADO) extensively for data exchange and maintenance in the Business Objects.
• Setup Net8 connectivity between various computers in a Distributed Database Environment.
• Tuned memory structures such as shared pool buffer cache on Oracle 8i.
• Assisted developers with SQL and stored procedure development.
• Configured hardware and software with the system administrator.
• Database design and client interaction for database design specifications.

Environment: JSP, VB6.0, HTML, DHTML, VBScript, JavaScript, COM, Visual Interdev, ActiveX EXE & DLL, Visio Professional, Oracle 8i