We provide IT Staff Augmentation Services!

Data Warehouse Resume

New Jersy, NJ

Professional Summary:

  • 14 plus years of work experience in the IT industry.
  • Designing, development, DBA activities involving Teradata and designing, developing and supporting various features in Teradata namely Teradata Stored Procedures, Teradata V2R5 Triggers and Teradata UDFs and solid experience in developing SQLs in Teradata.
  • Have good experience in Teradata DBA activities like Teradata database installations, version up gradations, database maintenance activities, Archive/Recovery operations, Teradata user and database creations. Creating and managing user accounts. Prepared scripts for monitoring the system. Automated the Arcmain for the database. Installed Teradata drivers for the teradata utilities. Refreshed the data by using fast export and fastload utilities. Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Fully aware of the IUMB (Install, Upgrade, Migration, and Backdown) procedures of V2R51 and V2R6 Teradata Software on all flavors of UNIX and WINDOWS platforms.
  • Extensively worked in Teradata DBA activities like: Archive/Recovery, DBS installation / upgrading / maintenance, Creating Teradata Users, Teradata Databases
  • Lead the teams in the usage of mostly all the Teradata Utilities like Backup and Restore Utilities (ARCMAIN/Net Vault/Net Backup), Fastload, Multiload, Tpump, BTEQ, FastExport, Pmon.
  • Worked extensively in C, C++, Bourne Shell, Unix Internals, TCP/IP, Socket Programming, Perl languages, Teradata and well versed with RDBMS: MS-SQL server, Sybase and Teradata RDBMS. Strong in developing tools and system applications using Unix Internals, TCP/IP, Socket Programming and FTP. Worked on Windows NT, 95, CE, SCO-UNIX, HP-Unix and Linux, Sun OS 5.5 platforms. Conversant with Wipro & Satyam\'s ISO 9001 quality procedures.
  • Worked extensively in Teradata Manager, ARC, BTEQ, TDADMIN, SQLA, PMON, Priority Scheduler, Teradata RDBMS, SQL, TPT,Teradata Data Modeling, Teradata Client Utilities and Backup and Recovery Utilities on operating systems like UNIX MP-RAS, Solaris-SPARC, HP-UX, SUSI Linux, .NET and Windows 2000 and on hardware platforms such as NCR4400, NCR4300, NCR4100, Pentium and Itanium.
Certifications
  • Teradata Basics V2R5 (NR0-011) - SR2061037
  • Teradata Physical Implementation V2R5 (NR0-012) - SR2061037
  • Teradata Administration V2R5 (NR0-014) - SR2061037
  • Teradata SQL V2R5 (NR0-013) - SR2061037
  • Teradata Design Architecture (NR0-015) – SR2061037
  • Teradata Application Development (NR0-016) – SR2061037
  • Teradata Certified Master V2R5
Experience:

Confidential, 02/2010 – Till Date
Teradata Analyst & DBA - Data Warehouse

big Casino Gaming company providing services for gaming line customers. I worked as a Sr Teradata DBA/Application DBA / Architect to provide EDW Data mart solution for marketing department to analyze Campaign Analytics with Customer Analytics. Informatica 8.x, 7.1.3/6.2 is used as ETL tool & SQL Server, Teradata 12 & 6.2 is the database & Cognos is used for Reports.
Contribution

  • Worked on NetBackup/NetVault Technology to take the hot and cold backups.
  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
  • Setup core process required to source new data streams into Teradata data mart
  • Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
  • Responsible for providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
  • Involved in workload balancing through TASM.
  • Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
  • Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
  • Performed database health checks and tuned the databases using Teradata Manager.
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
  • Use of all database administration tools to analyze system status/performance.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Teradata SQL, OLAP functions, and Load/Unload utilities
  • Perform report development, MSTR architecture work, and interaction with business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines.
  • Installed patch sets and upgraded Teradata.
  • Automated data warehousing and datamart refreshes using Transportable table space option.
  • Worked on creating and managing the partitions.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for the teradata utilities.
  • Refreshed the data by using fastexport and fastload utilities.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

Confidential, 06/2009 – 02 /2010
Sr. Teradata DBA/Application DBA /Teradata Architect

Telecommunications company providing services for wireless and wire line customers. I worked as a Sr Teradata DBA/Application DBA / Architect to provide BI Data mart solution for marketing department to analyze Campaign Analytics with Customer Analytics. Informatica 8.x, 7.1.3/6.2 is used as ETL tool & Oracle 10g/9i , Teradata 12 is the database & Micro strategy Ver. 8 is used for Reports.
Contribution

  • Worked on NetBackup Technology to take the hot and cold backups.
  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
  • Setup core process required to source new data streams into Teradata data mart
  • Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
  • Responsible for providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
  • Involved in workload balancing through TASM.
  • Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
  • Using the workload management tool and methodology to manage the system workload to help business team to meet SLA
  • Performed database health checks and tuned the databases using Teradata Manager.
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
  • Use of all database administration tools to analyze system status/performance.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Teradata SQL, OLAP functions, and Load/Unload utilities
  • Perform report development, MSTR architecture work, and interaction with business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines.
  • Installed patch sets and upgraded Teradata.
  • Automated data warehousing and datamart refreshes using Transportable table space option.
  • Worked on creating and managing the partitions.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for the teradata utilities.
  • Refreshed the data by using fastexport and fastload utilities.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

Confidential, 01/2009 – 06/2009
Application DBA and Sr Teradata DBA

  • Worked on Netback up/TERA Technology to take the hot and cold backups.
  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines.
  • Installed patch sets and upgraded Teradata.
  • Automated data warehousing and datamart refreshes using Transportable table space option.
  • Worked on creating and managing the partitions.
  • Performed database health checks and tuned the databases using Teradata Manager.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for the teradata utilities.
  • Refreshed the data by using fastexport and fastload utilities.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EADW.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.
  • Acted as a liaison between the offshore and onsite teams.
  • Also performed functions as Project Lead (teams up to 15 people)

Confidential, 02/2007 – Till Date
Application DBA and Teradata DBA
Contribution

  • Worked on Netvault Technology to take the hot and cold backups.
  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5450, 17 node for production, development and testing.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines.
  • Installed patch sets and upgraded Teradata.
  • Automated data warehousing and datamart refreshes using Transportable table space option.
  • Worked on creating and managing the partitions.
  • Performed database health checks and tuned the databases using Teradata Manager.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for the teradata utilities.
  • Refreshed the data by using fastexport and fastload utilities.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.
  • Acted as a liaison between the offshore and onsite teams.
  • Also performed functions as Project Lead (teams up to 15 people)

Environment : Teradata, NETVAULT,TMGR, TDADMIN, PMON, SQLA, TSAW, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and DataStage. MPRAS V2R6, HPUX, MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-bit, Erwin, Power Designer, MP-RAS, W2K, DB2, Oracle

Confidential, 01/2006 – 02/2007
Teradata Lead DBA and Project Manager
Contribution

  • Worked on Netvault Technology to take the hot and cold backups.
  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5400, 12 node for production, development and testing.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
  • Moved databases between machines.
  • Installed patch sets and upgraded Teradata.
  • Automated data warehousing and datamart refreshes using Transportable table space option.
  • Worked on creating and managing the partitions.
  • Performed database health checks and tuned the databases using Teradata Manager.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for the teradata utilities.
  • Refreshed the data by using fast export and fastload utilities.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Creating and modifying MULTI LOADS for DataStage using UNIX and Loading data to DataStage.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FAST EXPORT, MULTI LOAD and DataStage .
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, Setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.
  • Acted as a liaison between the onshore teams.
  • Also performed functions as Project Lead (teams up to 15 people)
  • Was responsible for certifying Teradata Manager against Teradata running on .NET

Environment : Teradata, NETVAULT,TMGR, TDADMIN, PMON, SQLA, TSAW, TSWIZ, Priority Schedule, BTEQ, FastLoad, MultiLoad, FastExport , Tpump and DataStage. MPRAS V2R6, HPUX, MS Win 9x, Win NT4.0, W2K Professional, Windows XP 32-bit, Erwin, Power Designer, MP-RAS, W2K, DB2, Oracle

Hire Now