We provide IT Staff Augmentation Services!

Sr. Teradata Engineer Resume

SUMMARY:

Experienced professional seeking interesting data warehousing environment on the “Cutting Edge” of Technology.

TECHNICAL SKILLS:

  • Teradata Certified Professional (V2R3, V2R5, TD14 in progress), SQL, TASM, Viewpoint, Teradata Manager, SQL Assistant, Teradata Administrator, Teradata Utilities, Tableau
  • MS Project, Embarcadero, ER Win, All MS Office Products
  • UNIX (Korn Shell, BASH) Confidential Utilities, PostgreSQL, Confidential nCluster

WORK EXPERIENCE:

Sr. Teradata Engineer

Confidential

Responsibilities:

  • In this position I help manage the capacity and performance of all EDW and deep Teradata Analytics platforms.
  • Responsible for capacity management, performance optimization and database administration on several multi - petabyte systems.
  • I also conduct user training (live and via webinar) regarding Teradata systems for analysts, program managers and database administrators.
  • Mentor the off-shore DBA team and provide on-call support.

Staff Performance Engineer

Confidential

Responsibilities:

  • In this position I help manage the capacity and performance of all EDW and deep Teradata Analytics platforms.
  • I am also responsible for developing, implementing and teaching three levels of Teradata user training Confidential in order to improve user performance and thus reducing the adverse effects of poorly written queries upon the system.
  • I have developed periodic (daily and weekly) reporting scorecards, capacity forecasting models and various performance related metrics for Teradata systems using Tableau.
  • I work with various business users to provide DBA support and workload analysis for performance.

Consulting Engineer

Confidential

Responsibilities:

  • As a Consulting Engineer Confidential Data Systems I performed in several different roles. I was the Technical Account Manager (TAM) for several Confidential accounts, develop and deliver training, and also provide technical solutions and consulting services to our clients.
  • I also served as the Technical Engagement Manager for several different accounts located primarily in the Silicon Valley of California.

Senior Technical Architect

Confidential

Responsibilities:

  • As a professional services consultant I work with Confidential clients to install Confidential systems and implement solutions.
  • I created and taught several Confidential classes (GP Fundamentals, GP Advanced SQL and GP Administration) Confidential various client sites and Confidential headquarters.
  • Several of my client solutions have been implemented as “Best Practices” Confidential other clients.

Principle Capacity Planning and Performance Analyst

Confidential, Redmond, WA

Responsibilities:

  • In this position I managed the capacity of two operational Teradata systems and forecast system usage in order to predict when either system will exceed pre-set limits.
  • These forecasts are based on upcoming projects as well as a predictive model based on prior growth experience.
  • I worked with the user community to teach Teradata SQL optimization and intercept poorly performing or highly skewed queries in order to reduce overall impact to the system.
  • I then worked with the users to optimize their queries.
  • This has resulted in better rapport between operations and the user communities as well as faster running, less resource intensive queries.
  • Also performed the duties of lead database administrator with remote DBA teams (India and Pakistan).
  • December of 2007 I transitioned to the Data Architecture team. I am responsible for design and implementation of the Enterprise Data Warehouse security initiatives, the Operational Data Warehouse (server performance) and support several other project teams on demand with logical and physical data modeling, DDL optimization and generation as well as process reviews.

Senior Data Warehouse Consultant

Confidential, Bellevue, WA

Responsibilities:

  • Provide professional services consulting in the e-business group of Confidential .
  • Implementation and ETL specialist.
  • Worked as Data Architect and Designer for E-Business Data Warehouse and large Telecommunications Fraud Data Warehouse.
  • Performed duties as a Teradata Database Administrator (DBA) for a 12 node 5350 system. Implemented the Teradata Communications Logical Data Model (cLDM).
  • Performed duties as Teradata Architect and Data Modeler for complex Business
  • Intelligence applications and data warehouse.
  • Technical Lead on Teradata implementation projects working directly with the Project Manager and providing technical expertise to diverse development teams.

Sr Software Engineeer

Confidential, Bellevue, WA

Responsibilities:

  • Lead Software Engineer for ETL (Extract, Transformation and Load) team supporting several data warehouses. Working primarily in Oracle 7.3 and 8.0, and Teradata environments.
  • Project manager for a corporate wide data transportation effort.
  • Implement complex ETL procedures for TeraData Data Warehouse using Unix (Korn Shell scripts, awk, and sed), PL/SQL, bteq, fastload and other utilities.
  • During the Y2K effort I was the principle test engineer for three data warehouses (Oracle) and their related ETL processes.

Technical Lead Consultant

Confidential, Seattle, WA

Responsibilities:

  • Performed duties as the DBA Technical Lead, Oracle (8.0) Database Administrator (minor role), and PL/SQL developer for Meter Transactions system.
  • Implemented complex packages and procedures using PL/SQL. Used SQL*Loader to insert data into Oracle database from various flat files.
  • Responsible for connectivity issues using SQL*Net and database maintenance using Developer 2000.

DBA / Developer

Confidential, NY, NY

Responsibilities:

  • Confidential . Performed duties as an Oracle (version 6 & 7) Database Administrator, GUI Applications Developer using Power Builder (version 4.0 & 5.0).
  • Provided after sales support to customer base. Convert application to run on various platforms.
  • Work with Windows 95, PowerBuilder, Personal Oracle 7.0 - 7.3, Unix, Solaris 2.6, Sun OS 5.4, SQL*Forms3.0, SQL*Menu 5.0, SQL*Plus, RPT, PL/SQL.
  • This was a telecommuting assignment with work being performed Confidential remote locations. Application is a remote / local Sales Force Automation System.

Oracle Developer / DBA

Confidential, NY, NY

Responsibilities:

  • Maintained a very high profile accounts management system for Oracle Corporation (Sales).
  • Maintained documentation, modified and enhanced the system using SQL*Forms 3.0, RPT, SQL*Plus, SQL*Menu and PL/SQL on a Pyramid UNIX platform.

Database Administrator

Confidential, Atlanta, GA

Responsibilities:

  • Provided database administration and applications support for various Stratus computer systems.
  • Designed and implemented systems with Confidential software, Pro*C, and Oracle version 6.0.(Company went out of business.)

Sr. Consultant

Confidential, Dallas, TX

Responsibilities:

  • Provided consulting services to companies located in and around Dallas, Texas.
  • Designed and developed a Confidential Control System (including modified MRP & MPS modules) using the Oracle CASE tool, SQL*Forms 3.0, RPT, SQL*Report Writer, 'C' and Pro*C, and SQL*Menu5.0 on an HP-Unix platform.
  • Wrote an Engineering Specifications System using COBOL and Powerhouse on HP3000 and HP Spectrum machines.
  • Performed the duties of database administrator on the highly visible Access Control System using an IBM System 88, 'C', SQL*Forms 3.0 and Oracle version 6.0.

Hire Now