Teradata database is an industry leader in data warehousing and data-mart consolidation. The following sections document 10 years of client engagements while with Teradata Inc.MAJOR PROJECTS ACCOMPLISHED:SQL DeveloperBevMo! 01/2024 – 10/2024Project: GoPuff Marketing CampaignAchieved efficient distribution of daily marketing email campaigns for BevMo! by generating targeted flat files and ad-hoc reports using SQL, database VIEWS, and Teradata data model.ETL LeadCharter Communication 01/2022 – 01/2024Project: TPT ETL ConversionImproved load performance by multiple hours per day by leading an offshore team to develop and implement a customized ETL framework using TPT, stored procedures, and shell scripts, enhancing data processing efficiency.Application DeveloperCharter Communication 01/2021 – 12/2021Project: Teradata MDM Server (Master Data Management Application)Streamlined defect communication for Charter’s Master Data Management application by creating a VBA-driven Excel defect sheet, while enhancing the UI to allow customized business request forms and data change requests while serving as a liaison with the offshore development team to resolve defects in the application built using Eclipse/JAVA/XML.

COP TAS UpgradeAttained significant performance improvements in daily ETL loads by converting and creating Teradata database objects from Informatica jobs to Teradata stored procedures during the COP Teradata Analytics for SAP upgrade project.

PHP by Metro MigrationContributed to the successful integration of MetroPCS data into T-Mobile’s Integrated Data Warehouse (IDW) by orchestrating comprehensive source data analysis and creating source-to-target mapping documents.

Stalin Project – Common Defense Data Warehouse (CDDW)Revitalized data integration within BOEING's Teradata data warehouse by successfully migrating F15, F18, and V22 defense aircraft data from SQL Server and PostgreSQL using DataStage, ensuring robust QA testing with Toad Data Point and comprehensive data profiling throughout the ETL process.

Teradata Enterprise Data Warehouse (EDW) ImplementationBuilt Teradata Data Warehouse for CCA, integrating multiple SQL Server data marts into a unified RDMS, while leading EDW architecture design, ETL development, and DBA activities in partnership with client IT and offshore ETL/QA teams.

Motor Vehicle Bureau Legacy Report ConversionMaximized reporting performance by developing 15 individual SSRS reports that replaced a legacy process, utilizing Data Warehouse Semantic Layer Development, custom SQL, macros, and stored procedures, while ensuring thorough report specification documentation, unit testing, and client sign-off.

Teradata OLAP Connector Proof of Concept (POC)Delivered an OLAP reporting system for NCR that enabled ad-hoc reporting through Excel pivot tables, enhancing data accessibility and analysis capabilities; seamlessly completed the setup of the Teradata OLAP Connector repository and developed comprehensive best practices documentation.

Access/Semantic Development for a Teradata EDW ImplementationBoosted reporting capabilities by adding an Access/Semantic Layer on the new Teradata EDW, converting the Athena reporting structure, and developing an ETL process for daily table population using PL/SQL and Cognos Framework Manager integration.

Teradata Tools and Utilities (TTU) & Teradata RDBMS (TD DB) 14.10 Upgrade SupportResolved upgrade and installation issues for the Teradata version 14.10 in BOA’s software distribution portal by troubleshoot ing TTU installation packages and collaborating with server administrators, ensuring successful support for DBA, ETL, and BI teams post-RDBMS upgrade.

Teradata Data Mover Disaster Recovery (DR) ProjectEfficiently analyzed and selected in-scope database objects for migration to the Disaster Recovery environment through the development of a DM Spreadsheet, which streamlined the modification and submission of Data Mover jobs; led QA efforts by introducing a comprehensive test plan and collaborating with client to finalize test scenarios for the Teradata framework.