SUMMARY:

• A Teradata Master and Senior Data Warehouse Consultant, providing leadership in architecture, project management, construction and tuning Enterprise Scalable Teradata BI/Warehouses and associated applications.
• With end - to-end knowledge of the SDLC and Agile processes and in-depth technical experience built over more than twenty-five plus years of progressive experience in Information Systems, fifteen years as a Teradata professional services consultant and fifteen years as an independent contractor specializing in Data Warehouse development and relational applications, and nine plus years of project-managing diverse application development projects.
• Specializing in query performance tuning services as well as application architecture and design. Performance services for Data Warehouse optimization including query optimization, physical data modeling, primary index selection, statistics collection, secondary and join index design, table partitioning, as well as data compression services. Application design services include requirements analysis, architecture design, code development, test and validation as well as documentation.
• Provides services for Data Warehouse Administration.
• Performance tuning for Teradata RDBMS. Beginning with developing the physical model from the logical model, optimize the primary indexes of each database table. Collect the correct statistics and create useful indexes to support loading and consumption. Use of Viewpoint, DBQL and PDCR databases to identify and analyze problem queries. Expert knowledge for tuning Teradata databases and tables to achieve optimal performance.
• Application Architect and Developer. Experienced with architecting and developing real-time relational applications using SQL in Macros and Stored Procedures.
• In depth knowledge of Teradata Explain Plans for analyzing problem queries.
• Expert in optimizing IO performance through Teradata compression methods; MVC, ALC and BLC.
• Modeling experience using ErWin. Worked with 3NF-logical, physical and Star-Schema models for both current snapshot and temporal data warehouses. Experience with Teradata ULDM, FSLDM and MLDM.
• Project management and leadership. Able to lead and manage a project team as well as provide quality assurance validation of technical deliverables.
• ETL skills required to load large volumes of data. UNIX and LINUX shell scripting, BTEQ, Fastload, Fast Export, Multiload, Tpump, Teradata Parallel Transport (TPT) utilities.
• Expertise with SQL Assistant and Teradata Administrator.
• Expertise with application development using Teradata Stored Procedure Language.
• LINUX and UNIX Scripting.
• MVS JCL, Windows expertise.
• Excellent communications skills, quick understanding of new environments and ability to manage multiple simultaneous tasks.
• Works successfully in on-shore, off-shore environments.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Performance tuning specialist

Responsibilities:

• Tuned application queries to meet performance objectives.
• Tuned ETLs to meet loading objectives.
• Revised and recommended revisions to queries to improve performance.
• Wrote stored procedures to automate recognition of poorly performing queries.
• Recommended changes to tables and views to improve query performance.
• As an improvement to a previously developed query similarity index, developed stored procedures that create a unique hash code for each query.

Tools: Teradata TASM tools as well as ERWin for database analysis.

Confidential, Forbestown, CA

Developer and DBA

Responsibilities:

• Developed curriculum and presentation to train the data warehouse personnel in how to analyze the Teradata Explain plan.
• Developed curriculum and presentation to train data warehouse personnel in how to tune their queries once they were developed.
• Tuned production report queries.
• Helped develop policies related to system management, specifically how to manage system alerts.
• Proposed policies for automated database space management.
• Proposed policies and recommended ECR procedures.
• Assisted in implementation of some of the above mentioned policies and stimulating thought and dialog about the others.
• Helped to revise the ECR process to become a simpler, better defined, and more automated process.
• Served as on-call DBA during the week in order to become familiar with the entire data warehouse operation.

Confidential, Columbus, Ohio

Responsibilities:

• Revised the physical database to store data more consistently with reporting methods.
• Tuned existing reports to improve run times.
• Recommended design direction for future reports to capitalize upon both data storage methods and parallelism of Teradata system.

Tools: used: ErWin, Teradata SQL, SQL Assistant, Teradata Administrator.

Confidential, Arizona

Responsibilities:

• Developed the scope and definition with the end-user community.
• Architected and developed logical and physical database designs.
• Developed the algorithms to parse and analyze the legacy SQL.
• Developed and implemented the Teradata Stored Procedures to analyze and categorize the legacy SQL.
• Developed and implemented report definitions and specifications showing recommended conversion SQL.
• Administration of the database.
• As an adjunct to the Legacy DB Converter, conceived, specified and developed a view-to-table metadata processor. The processor builds tables of equivalences between all view columns and end database table columns.
• As an adjunct to the Legacy DB Converter, conceived, specified and developed a Data Use Evaluator. The Evaluator scans all user queries that have been run against the data warehouse to determine which columns are accessed most often or not at all.
• As an adjunct to the Legacy DB Converter, conceived, specified and developed a Query Similarity Index. The Index develops a code based upon the columns accessed which can be used to compare other queries for similarity.

Tools: used: Teradata SQL, Teradata Stored Procedures, SQL Assistant and Teradata Administrator.

Confidential, Dallas, Tx

ETL Developer

Responsibilities:

• Developed ETL processes to load the data warehouse using Fastload, Multiload, Teradata Parallel Transport, Bteq and Tpump.
• Develop the logical model and physical model for database and SQL processes necessary to support “Flight-In-Trouble”.
• Design and Implement reports for the “Flight-In-Trouble” database.

Tools: Used: ErWin, Python, UNIX shell, Teradata SQL