Home · About · Blog · Contact · Sitemap

You are here: Home / Sample Resumes / Computer Resume / Teradata Resume Sample One

Teradata Resume Sample One

999 Main Street, Any Town, NY 99999 • email@yahoo.com

Patrick Johnson

Technical Summary

Languages: SQL, PL and SQL
Operating Systems: MS DOS, MS Windows
Software: MS Works, MS Office, Lotus Notes, MS Outlook, Remedy, SharePoint
Relational Databases: Oracle 9i and 10g, MS Access 97, MS SQL Server 2005, Teradata.
Databases tools: SQL*PLUS, Sql Assistant, TOAD, MS Analysis, Golden, Crystal Reports, Business Objects (Universe, deski, webi, Zabo in version 5.x, 6.x, XIr2, XIr3), Xcelsius, BI Query.
Methodologies: RUP, Relational database Methodologies, SOA (service oriented architecture), Rapid Application Development

Experience

ABC Inc., Any Town, NY March 2010 to July 2010
Sr. Teradata Analyst

  • Involved in requirements gathering and data gathering to support developers in handling the design specification.
  • Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirements.
  • Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
  • Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
  • Involved in loading of data into Teradata from legacy systems and flat files using complex
  • scripts.
  • Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
  • Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
  • Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
  • The mappings involved extensive use of transformations like Aggregate, Filter, Join, Expression, Lookup, Update Strategy, Expressions, Sequence Generator Transformations. Used debugger to test and fix mapping.
  • Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
  • Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
  • Prepared Unit Test Specification Requirements.

XYZ Corp., Any Town, NY Feb.2009 to March 2010
Teradata Analyst

  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) in operation 24×7.
  • 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 and USI and NUSI and 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.

BCD Inc., Any Town, NY Feb. 2006 to Sept. 2006
Enterprise Data warehouse Sr. Developer and Analyst

  • Worked on Teradata dual active systems project. To support data center and Teradata dual active system efforts, worked with the team to clone jobs, programs and Teradata tables and make sure both Teradata systems get updated simultaneously and in sync all the time.
  • Supported TCRM (Teradata Customer Relationship Management) application. Responsible for TCRM administration, maintenance and provided the first line of support to Business users. Also worked with Teradata CRM GSC team to report, analyze and resolve any incidents with the application. Worked on TCRM Communication, Analysis, personalization modules. Managed TCRM application security, Metadata mapping changes, coordinate new installations and upgrades, baseline and benchmark testing and acceptance.
  • Responsibilities include interpret business requirements and enhancement requests, create scoping documents, program specs and technical design documents. Conduct code reviews, QA check. Compliance with company policies and procedures. Job tasks include involving in design and developmental activities, developing and maintaining data structures and ETL processes that source data from various operational groups (logistics, transportation, merchandising , pricing etc..) and apply business rules to route leads to appropriate destinations and support DSS and Financial planning and Analysis users.
  • Scope and assess change requests and reported defects in order to provide recommended solutions and associated level of effort and time estimates.

Sample Resume in PDFClick to download the Teradata Resume Sample One in PDF.

Related Resumes

Mistake #1
click here
Mistake #2
click here
Mistake #3
click here