SUMMARY

• Years experience with Teradata Databases - 20 years
• Years experience with Multi-Node Teradata DB's - 20 years
• Years experience with V2R6 - 3 years
• Years experience with TD 15 - 1 years
• Years experience with Designing Teradata DB's - 15 years
• Years experience with Journal Tables - 1 year
• Years experience with Backup & Recovery - 15 years
• Backup & Recovery Software Used - Arcmain, NetVault, Netbackup
• Years experience with DB Access Mgt. - 6 years
• Years experience with Regulatory Compliance Evidence Collection (SOX & PCI) - 4 years
• Years experience with Supporting Teradata Hardware/Software Upgrades - 10 years
• Years experience with DBQL - 20 years
• Years experience with Query Perf. Tuning - 20 years
• Years experience with TASM - 8 years
• Years experience with UNIX for Teradata Systems (Linux & MPRAS) - 15 years
• Years experience with SQL Assistant - 20 years
• Years experience with BTEQ - 20 years
• Years experience with Fastload - 20 years
• Years experience with T-Pump - 3 year
• Years experience with Fastexport - 20 years

TECHNICAL SKILLS

• MVS
• JCL
• CICS
• PL/I
• Hadoop
• Impala
• Hive
• Sqoop
• Python

PROFESSIONAL EXPERIENCE

PerformanceTeradata DBA/Hadoop

Confidential, Baltimore MD

Responsibilities:

• Reviewed and tuned ALL SQL and semantic views prior to deployment. Operated the SQL help desk for all users with performance problems. Wrote script to analysis for MVC and implemented MVC to all tables. Evaluated and change primary index and PPI for best performance
• Evaluated and added secondary indices when needed. Complete Hadoop training. Working on project to transfer all Teradata data to Hadoop using Sqoop. Converting SQL and views from Teradata to run in Impala and Hive. Some experience in Tableau, Python, and R programming.

Teradata DBA

Confidential, Atlanta GA

Responsibilities:

• DBA group responsible for user access, creating user accounts and granting access rights. Create tables. Performance tuning. Spool space problems, connection problem and all work trouble ticket. Backup and Restore using NetBackup. Create Teradata at Your Service tickets and interface with Teradata CSR on technical problems.

Teradata DBA

Confidential

Responsibilities:

• Team member assigned to receive Teradata knowledge transfer from current DBA staff and pass information to IBMs steady state team for two Teradata contracts ( Confidential and confidential) where Confidential took over the entire IT processes.

Teradata Developer

Confidential, Atlanta GA

Responsibilities:

• Attend requirement meetings and create and designed new application. Used Temporal tables as part of the new design to maintain history records.

Teradata DBA

Confidential, Charlotte NC

Responsibilities:

• Work with four development teams. Physical modeling of tables, performance tuning, create tables, views, and macros for developers. Rotating on-call DBA.

Teradata Production DBA / DBA Trainer

Confidential, Philadelphia PA

Responsibilities:

• Supplied consulting and training to the full time DBA staff for: DBA best practices, on monitoring the database using Viewpoint, Viewpoint Portlets, and performance tuning. The “go to” DBA for solving difficult performance problems. Reviewed the current BAR process, DBS Control, DBQL
• Resusage collection and logging, and Viewpoint Alerts setting. Created an” in-house version” process to provide data synchronization between production and development databases, similar to Teradata Data Mover
• Created and presented PowerPoint presentations on TPT and performance tuning to the DBA staff. Worked with, and trained the customer on TPT Easy Loader so they could load their own data. Create Semantic Views and monitored the database when not involved in a special process.

Teradata Production DBA

Confidential, Chattanooga TN

Responsibilities:

• Worked with BCBST to implement new 13.10 Teradata development and production systems. Set up all: Roles, Profiles, DBQL, Account Strings, Resusage tables (CTL), Viewpoint, DBS Control, Users, Views, Tables, Macros, TASM, DIP and Stored Procedures.
• Used TPT and Arcmain to move data from different Teradata systems. Created daily DBA scripts to: Purged DBC into PDCRDATA, refresh stats, and to find various table problems such as skewing. Created weekly DBA jobs for: Scandisk, Check Table, and Packdisk.
• Performance tuning and analysis and created MPPI, PPI, PI, SI and Joined indexes. Create PowerPoint presentation and conducted training classes to FTE’s. Set up multicolumn compression on all tables. Set up LDAP. Viewpoint Administrator
• Setup Alerts, Users, Profiles, Data Collectors, TASM and Workload Designer.

Teradata Production DBA

Confidential, Danville, PA

Responsibilities:

• Worked with Geisinger to implement new 13.10 Teradata development and production systems. The conversion was from both Oracle and DB2. Used tools Teradata Parallel Transporter and Oleload to port over the data. Set up Profiles, DBQL, Account Strings, Resusage tables (CTL)
• Viewpoint, DBS Control, BAR, Permanent Journals, Users, Views, Tables, Macros, Stored Procedures, and UDFs. Created daily DBA scripts to: Purged DBC into PDCRDATA, refresh stats, and tofind various table problems such as skewing
• Created weekly DBA jobs for: Scandisk, Check Table, and Packdisk. Performance tuning and analysis of PPI, PI, SI and Joined indexes. Set up multicolumn compression on all tables.

Teradata Production / Application DBA

Confidential, Hill, NC

Responsibilities:

• Maintain production and development systems. Maintain databases, users, roles and profiles and monitored running jobs for performance. Analysis of PPI, PI, SI and Joined indexes. Analysis multi-column compression. Teradata tools: TASM, Teradata Manager, PMON, Teradata Administrator, Teradata SQL Assistant, DBW, Visual Explain, TSET and Netvault. Worked with the development teams and with the data modelers on new projects.
• Wrote Unix shell scripts that ran background Teradata utilities such as UPDATESPACE. Performance tuning on poor running queries. Create load both Fastload and Multiload jobs for developers.

Teradata Performance Tuning

Confidential, NY

Responsibilities:

• Identified poor performing queries in DBQL based on elapsed time, CPU time, skew and Impact CPU, to analysis and conduct performance tuning. Added stats, AJI, Secondary Indexes or rewrote query as necessary
• Check tables for skewing, compression and good primary indices. Worked with developers and instructed them on good coding practices for best performance.

Teradata Development DBA / Logical and Physical Data Modeler / MySQL DBA

Confidential, Fairborn, OH

Responsibilities:

• Various new projects - Created the Logical, Physical, and Concept Data Models for the project. Created all data object both in Teradata and MySQL. Wrote ETL using BTEQ, Fastload, and Multiloads. Created Store Procedures and Marco
• Conducted performance tuning and performance analysis on all Teradata SQL. Created QA test plans, Teradata Administration documentation, and deployment documents for each project.

Teradata Developer

Confidential, Columbus, OH

Responsibilities:

• Worked on the Revenue Connection team to maintain the Sales Datamart. Worked on the Sales Planning project which migrated data from DB2 UDB to Teradata. For this project created load jobs using Fastload and BTEQ imports.
• Worked on other special projects including with reporting team that optimize tables for Microstrategy reporting, claims loads, and special loads for exporting Florida and Kentucky data. Created new BTEQ scripts, Fastloads, Fastexports, and Mload. External documentation and presentations for the existing system.

Teradata Development DBA

Confidential, Winston-Salem, NC

Responsibilities:

• Worked with development team to implement the Voyager Connect project. Worked on the physical design and creation of tables and views, column compression, performance tuning, set-up roles, and assist developers with ETL design. Interface with System DBA to set-up BAR schedule, maintain space requirements, and access rights.

Lead Teradata Production DBA

Confidential, Detroit, MI

Responsibilities:

• Lead DBA with one other on-site DBA and two off-shore DBA’s. New production Teradata system. Helped set-up initial Teradata system including: DBQL, Priority Scheduler, Account String Expansion, Teradata Manager, TDWM, Backup and Recovery plan. Created daily and weekly maintenance jobs for: purging and maintaining history, refresh stats, and running Packdis
• Created performance reports from DBQL history to maintain: cpu usage/project each hour, number of report/project each hour, run time/project each hour. Created monthly report to management. Monitor normal production and worked as development DBA on new project and helped determine physical model. Tools include: xDBW, Teradata Manager, PMON, Teradata Administrator, Teradata SQL Assistant, xSchmon, xCtl
• Performance tuning of new and existing SQL. Create jobs to enhance DBA’s productivity such as “skew table” report, “job status” report and others. Created fastload, mulitload and bteq scripts.

Teradata Production DBA/Performance Analyst

Confidential, Eagan MN

Responsibilities:

• Monitor daily performance of system and user queries. Rewrite poorly written queries and worked with developers to develop coding standards. Maintain system and work with Confidential on all upgrades. Worked with DBQL, Priority Scheduler, Active Query Manager (AQM)
• Teradata Dynamic Workload Manager (TDWM), Teradata Manager, PMON, Teradata Administrator, VprocManager, Database Window, and Teradata SQL Assistant. Performed weekly maintenance of running the system by running Packdisk, Scan Disk and Checktable. On-call support for production problems.

Teradata Production DBA

Confidential, Richmond, VA

Responsibilities:

• Set up and maintained user accounts, roles and profiles. Reorganized the structure of the Database and User accounts. Created databases, tables and views. Started Teradata maintenance programs to regularly run PACKDISK, SCAN DISK, and CHECK TABLE
• Used Database Window, Teradata Command Prompt, Vprocmanager, and Teradata Mulitool. Implement column statistics on frequently access tables and created daily, weekly, and monthly jobs to refresh statistics. Created plan to enhance Priority Scheduler
• Updated DBS Control Utility settings. Created a plan to change from Access logging to DBQL. Implement a plan to add TDQM. Installed and maintained NETVAULT, both clients and server, installed patches and plugins, and implemented backups, backup schedules, and offsite rotation schedules. Installed and maintained Teradata Manager clients and server. Automated several processes that previously were done manually
• Maintained and enhanced aggregate jobs. Worked with Modeler to create new primary indexes and PPI for better performance. Created and maintain jobs using FASTLOAD, FASTEXPORT, MLOAD, and BTEQ. Created Marcos and Stored Procedures
• Created and regularly scheduled jobs that: clean DBC tables, clear peak spool, create views, release HUT locks, and recreate all objects, access rights, roles, logging setting and DDL. Working on the Startup and Shutdown procedure for the database, nodes, and disk arrays. Worked with the AWS and the AWS console. Familiar with the Confidential PUT utility
• Monitor performance with Teradata Manager and PMON, and assisted users on performance tuning queries at the application level. Monitor cpu usage and active processes with Task Manager and monitor the nodes with Event Viewer, at the node level. Worked with Confidential on all hardware issues and upgrades. On-call for production problems.

Teradata Node Windows DB2 Oracle

Confidential, Jacksonville, FL

Responsibilities:

• Teradata DBA: Create users, roles, and databases. System restarts, Application tuning, Backups, Restores, System tuning, Priority Scheduler, PMON, Teradata Manager, Database Window, Ferret, Teradata Administrator, SQL Assistant, Fastloads, Multloads
• BTEQs. Netvault, Window, Unix, MVS, JCL. Production Change Control and Production Support. Performance tuning, TDQM, DBQL.

Teradate DBA

Confidential, Atlanta, GA

Responsibilities:

• Performed duties such as: performance turning, monitoring production batch jobs, and correcting production problems as they occur. Set-up production environment, include creating UNIX directory structures and Teradata databases. Create a space management program, reorganized the database structure, created roles for access rights
• Create databases, users and manage access right. Worked with Priority Scheduler, setting up Performance Groups and Allocation Groups. Run special backup and restores using Arcmain. Tools used: Fastload, Multiload, BTEQ, Teradata Manager, Teradata SQL Assistant, Teradata Administrator, Visual Explain, TSET, UNIX.

Teradata ETL/Design

Confidential, Rockville, MD

Responsibilities:

• The first project consisted of creating a small data mart (12 tables). Used Erwin to create a logical and physical data model, created the Teradata tables, and loaded the data into the tables (one time load) in a UNIX system
• The second and larger project consisted of receiving data from an Oracle General Ledger System Transforming and Loading (ETL) the data into the Teradata General Ledger data mart and creating the UNIX scripts for the daily loads process.
• Took this project for its’ full life cycle, from initial design to production. Calculated Capacity Planning for current and future disk space. Performance Turning and designed best use of: Secondary, Joined, and Hash Indexes. Tools used: Fast load, BTEQ, Multiload, Stored Procedures.

Teradata Developer

Confidential, St. Louis, MO

Responsibilities:

• Created Teradata BTEQs, Stored Procedures, Multiload, Fastloads, Arcmain, Join Indexes and Macros for SBCs re-write of their Winback program. Used REXX to dynamically create Teradata SQL by replacing variable table names in commonly used queries located in SQL templates
• The templates were stored in Teradata tables and were dynamically expanded. Performance Tuning of new and existing queries.

Teradata Developer

Confidential, Bensalem, Pennsylvania

Responsibilities:

• Confidential recently purchased the Lane Bryant Department stores. Extracted, Transformed and Loaded (ETL) from Lane Bryant’s Datawarehouse to Charming Shoppe’s Teradata Datawarehouse. Created Teradata Marcos for data balancing and validation
• Created Fastloads, MultiLoad, BTEQs, and FastExports. Analyzed and conducted Performance Tuning on long running queries. Created Views using SQL with DERIVED TABLES

Teradata DBA/Design

Confidential, Atlanta, GA

Responsibilities:

• Converted three separate databases (Redbrick, Informix, and DB2) into one Teradata databases. Worked on data mapping and ETL using both Ab Inito and Cobol. Created a Logical and Physical Data Model using ERwin to create a Microsoft Access Database
• Then loaded the database, from Microsoft Excel, with the Metadata for the Teradata system. Used FastExport, FastLoad, BTEQ, and MultiLoad. Wrote programs in C++, on a Unix system, for data modifications. Created, loaded, and extracted data from tables using DB2 UDB on a Window platform.

Teradata DBA/Design

Confidential, Detroit, MI

Responsibilities:

• Extracted data from DB2 and Oracle and loaded into Teradata for Business Objects Reporting. Design Teradata tables and created Logical and Physical Data Models using ERwin design tool. Used DB2 Utilities and SQLPLUS to unload tables
• Used Teradata utilities such as FASTLOAD, BTEQ, and MULTILOAD. Used QUERYMAN for Teradata support.
• Created Physical Data Model from a completed Logical Model using ERwin. Created a Capacity Planning Document. Determined final Primary and Secondary Index choices for the Physical Model
• Determined best Application Utilities and designed production JCL for loading data. Denormalized tables and designed Join Indexes for optimal performance. Helped in creating a one terabyte, MPP, Data warehouse based on the Physical Model. Created Logical Data Mart

Teradata DBA/Developer

Confidential, St. Louis, MO

Responsibilities:

• Assigned to the Teradata DBA group, which is responsible for Physical Database Design, including: creating tables, creating views, creating indexes, loading tables, and maintaining tables. This includes new development, enhancements to existing programs, along with on-call production support, for ETL programs that extracts data from various sources, such as DB2, IMS, Oracle and datasets. Extraction programs were written in REXX, Cobol, SQLPLUS, and PL/I. Used REXX, to validate and compare output processes
• Used Teradata utilities such as FASTLOAD, BTEQ, and MULTILOAD. Extensive use of QUERYMAN and IMS EXPERT.

Teradata Developer

Confidential - Dallas, Texas

Responsibilities:

• New development and enhancements using, COBOL II, DB2, CICS, DYL280, & Teradata. Created and executed special programs/jobs as requested by Business Analysts to analysis customer buying base on special advertisements, campaigns, and newspaper inserts.
• Enhanced existing advertising analysis system with new requirements. Used CICS, DB2 and Platinum utilities, BTEQ, FASTEXPORT, MULTILOAD, & ARCMAIN. Created Cobol programs with embedded Teradata SQL
• Created Cobol programs with Dynamic SQL. Created Cobol, CICS, DB2 programs for on-line requests to select and update and local and remote DB2 tables using Distributed Database Facility (DDF). Trained College Summer Interns and new transition programmers.

Teradata Production Support

Confidential, Atlanta. GA

Responsibilities:

• Production Support. Corrective maintenance and enhancements of a Data Collection Management System. Maintained a COBOL II, DB2, CICS, and Teradata (BTEQ, ITEQ, MULTILOAD, FASTEXPORT) System.
• Investigated and corrected production problems, and made enhancements as needed. One week a month was spent with a pager for around-the-clock support. Used CA-7 to restart jobs and Demand-In jobs.
• The system loaded volume data, received throughout the day from bottlers located throughout the country, into Teradata tables. DB2 was used as control and as summary tables, and was used to validate batches prior to being loaded, trapping any records that were in error. CICS was used, accessing the DB2 tables, for the Volume Reporting Team to review errors in the batch, review summary information, and other uses.

Arthur Andersen

Confidential, Atlanta, GA

Responsibilities:

• Developed 16 new financial reports for the Confidential . The reports were need due to a merger between the Confidential and a Chicago bank. The two different reporting systems were modified into one reporting system. The development was done using COBOL II and DB2.