SUMMARY:

• I have significant experience with the design, planning, installation, development and administration of enterprise database and data warehouse systems.
• I have hands on working experience with: Teradata, MS SQL Server, Oracle, Sybase, DB2, MariaDB, PostgreSQL, noSQL, MongoDB, Red Brick, Model 204. I am most versed with Teradata products.
• I am now a full time employee at Confidential in Clayton Missouri working as a Solution Architect involved with transitioning
• Teradata based systems to AWS. I am responsible for overall system design of new databases and reporting Financial Analytics applications with emphasis on ETL and automation.
• All work is done a Agile Framework and JIRA based. I have 7 direct reports who I manage and mentor.
• I have over 15 years of Teradata experience working as a consultant and as a Teradata employee. I have focused my Confidential at companies who utilize Teradata and related software.
• My clients include Amazon Web Services, Ping, eBay, Teradata Professional Services, Vodafone, Telephia, Bed Bath and Beyond, and Maxtor (Seagate) and others.

PROFESSIONAL EXPERIENCE:

Confidential

Teradata DBA and ETL Deployment Systems Engineer

Responsibilities:

• Designing, creating and generating tuned physical database objects (tables, views, indexes) from PDM
• I have Expertise in designing and writing ddl and dml for effective Teradata Joins, Indexes,and CollectStatistics operations to assure fast access paths to data of interest.
• Used Teradata Administrator and Teradata Studio for management of user, role and profiles, grants, object security.
• I performance tune long running complex queries by evaluating the efficiency of PI/SI indexes, Join Index, PPI, using SQL Explain and & Visual Explain. I evaluate data distribution and skewing across AMPs and index usage with respect to statistics collected, I also look for poorly performing correlated sub queries. I have a excellent understanding of DBQL and Viewpoint and can focus performance tuning on application SQL that needs the most attention.
• I have experience in writing Stored procedures, Triggers, macros, User Defines Functions and Data Types in Teradata, Oracle and MS SQL Server systems.
• I have designed and developed data models from high level business requirements. I can provide design options, alternatives and recommendations based on experience and best practices for database design
• Created enterprise level Erwin data models. I have experience in creating Erwin logical, dimensional and physical data models including business rules and naming conventions and implementing these into well designed relational Teradata based solutions.
• Created data mapping specifications and ETL system interface specifications to support the loading of data streams
• I have used Teradata, BTEQ, Teradata Parallel Transporter, Fast Load, Multi Load, Tpump and Fast Export scripts to build ETL job workflows with reliable data load reporting, error/exception handling and rollback capabilities. I have automated of file processing as well as all ETL processes within a job workflows.
• I use Tidal, Control - M for automation of above processes
• I have current Teradata experience with writing Java / Teradata applications and utilities using the Teradata Plug-in for Eclipse, Java Runtime Environment . I have written Java script Teradata Stored Procedures and Used Defined Functions for Analytics related to Mobile Phone Drive Testing.
• I have used Ab Initio to clean, aggregate and load Teradata tables. Writing Ab Initio Graphs
• Coded Perl and java Scripts for database object and data migration between Teradata and SQL Server, and PostgreSQL database instances

Confidential

Teradata Architect / DBA / Developer

Responsibilities:

• Providing24x7 Call Center Support for Teradata Users with connectivity and performance issues. I have also managed the resolution of clients open calls for their Teradata systems with Teradata support.
• I have provided understanding and interpretation of Teradata Explain Plans for the purpose of tuning SQL and achieving improved performance.
• Implemented Teradata Manager/ DBQL / RAS to monitor and manage Teradata RDBMS resource utilization, created alert policies for monitoring database space, cpu consumption, locking and disk usage.
• I have fully automated capacity planning functions within 8 and 4 node Teradata configurations
• Determined optimal workload management settings in TASM to be able to meet response time SLA's as well as to optimize resource consumption.
• I have implemented Teradata Viewpoint Alerts for locking that prevents other sessions from running. I have also used Viewpoint to create Alerts for impending Space Usage issues. I have used Teradata Viewpoint Stats Manager portlet to define jobs that collect statistics
• I have managed the planning and execution of major Teradata hardware/software upgrades and expansion.
• I have current understanding and operational experience with production class Teradata AWS implementations.
• Assisted Program/Project managers as required to create estimates of work, costs, and risk analysis.
• Assist with decisions and trade-offs regarding possible changes in requirements throughout the software development lifecycle.

Confidential, San Francisco, CA

Sr Systems Engineer / SSR

Responsibilities:

• I assisted my clients with Extract, Transformation,and Load (ETL) activities such as normalization, cleansing, aggregation, sumarization/profiling, and integration.
• I trained users Unix, Pearl and Python shell scripting of Teradata Utilities ( BTEQ, MLOAD, Fastload, Multiload, TPUMP) and other products (Informatica, Ab Initio, and Microstrategy ) to control data movement and the reporting of data availability, data loading error and exception handling .