We provide IT Staff Augmentation Services!

Teradata Semantic Architect Resume

Providence, RI

SUMMARY:

  • 11 Years of Data Warehousing and Business Intelligence Experience.
  • Strongly experienced in Data Analysis and Data architecture practices.
  • Experienced in Teradata based Star/Snow - Flake designs, dimensional modeling and physical schema generation
  • Proficient in Data Access paths tuning, index designs and SQL Join strategies
  • Hands-on in Teradata based data layer designs and physical implementations.
  • Experienced in variety of tools (Atanasoft, Informatica) for Teradata object migrations.
  • Knowledgeable (V13.10) and Up to date on Teradata capabilities
  • Design, Develop, Test & Implement Teradata/Informatica based ETL processes.
  • Develop Teradata BTEQ & Loader scripts for data movement into EDW.
  • Analyze & document performance characteristics of the ETL processes to support the development of production job schedule
  • Participated and developed data governance practices and quality assurance subroutines
  • Strong experience in corporate SDLC and L3 support methodologies
  • Develop ETL mappings in Informatica to load EDW
  • Collaborate with data architects to instantiate EDW 3NF (third normal form) physical data model
  • Analyze SQL associated with database Views to improve performance characteristics
  • Recommended an implementation strategy (including criteria for use) for deployment of database Views
  • Hands on experience in Teradata database with extensive knowledge & scripting skills in BTEQ, MLOAD & FLOAD Utilities.
  • Hands-on experience in Unix Shell Scripting & SQL - PL/SQL routines development
  • A true team player with balanced mix of interpersonal, communication, leadership and negotiation skills

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Semantic Architect, Providence, RI

Responsibilities:

  • Created High Level Architecture Design Documents - Data Flow Diagram, Data Model, Source to Target Mappings, Specifications for the ETL Team
  • Worked closely with the development team during testing to ensure ETL was optimized for performance.
  • Co-ordinated ETL & BI teams to ensure seamless delivery of the project to the end business user
  • Provided Weekly Status Reports to the Project Team & The Business Users
  • Teradata Platform Maintenance Responsibilities and lead the Terdata DBA team
  • Performance Tuning of Applications
  • Actively Participate and contribute in Budgeting / Resource Allocation / Future Projects .

Confidential

Information Architect, NYC, NY

Responsibilities:

  • Created High Level Architecture Design Documents - Data Flow Diagram, Data Model, Source to Target Mappings, Specifications for the ETL Team
  • Worked closely with the development team during testing to ensure ETL was optimized for performance.
  • Co-ordinated ETL & BI teams to ensure seamless delivery of the project to the end business user
  • Provided Weekly Status Reports to the Project Team & The Business Users
  • Vendor SOW Management
  • Teradata Platform Maintenance Responsibilities and lead the Terdata DBA team
  • Performance Tuning of Applications
  • Actively participate and contribute in Budgeting / Resource Allocation / Future Projects Vendor Statement of Work and RFP Process.

Confidential, New Brunswick, NJ

Teradata Semantic Architect

Responsibilities:

  • Created High Level Architecture Design Documents - Data Flow Diagram, Data Model, Source to Target Mappings, Specifications for the ETL Team
  • Design Teradata Semantic Views for Reporting Usage and collaborate with the Reporting COGNOS and Tableau teams and address their needs for the project.
  • Performance Tuning of Existing Semantic Views and ETL Processes to enhance usage of the Teradata Platform
  • Data Profiling of Data For Fraud Detection in the Expense Application
  • Developed a POC on Teradata Aster to find patterns in unstructured data

Confidential, Los Angeles, CA

Teradata Architect

Responsibilities:

  • Created High Level Architecture Design Documents - Data Flow Diagram, Data Model, Source to Target Mappings and Low Level Interface Documents.
  • Prepare Low Level ETL Documents and Prepare Wire Frame Mock Up for Cognos Front End Application
  • Development and implementation of ETL - Teradata TPT Scripts. Automation of the GL Trial Balance Recon Process along with automatic email alerts and daily Recon Report.
  • Prepare Script Inventory / Table Structures / Confidential Migration Packages For Deployment and End Delivery.
  • Document existing TDE - Teradata Decision Experts Process between Teradata and Oracle and provide a before / After Roadmap for the Automation Process.

Confidential, Parsippany, NJ

ETL Lead & Test Lead

Responsibilities:

  • Understand current I-HUB implementation and identify changes for the Confidential
  • Create High Level Test Strategy & Build Test Cases
  • Create Informatica Mappings And Low Level ETL Specifications for the offshore team and build change package for deployment
  • Work with the MDM Team to identify data gaps for the overall reporting solution

Confidential, Chicago, IL

Teradata Architect

Responsibilities:

  • Data Architecture Management Consultant - Study existing business processes and existing systems and data models and create current state data model and business model
  • Identify gaps in the current systems implementation
  • Provide a future state roadmap for implementation to close the gaps and provide high level cost estimates for the actual implementation and system modifications
  • Present overall solution to C level Executives

Confidential, Parsippany, NJ

Teradata Architect

Responsibilities:

  • Create High Level Design Documents - Data Flow Diagram And Road Map For Migration from Old Oracle DWH to New Teradata DWH by Subject Area, Different Lines of Business
  • Create Detailed Conceptual Data Model, Logical Data Model and Physical Data Model for the Loyalty Program for the Wyndham Group of Hotels. Create High Level ETL Specifications to implement this using the exisiting Technology Stack
  • Create Power point Decks For High Level Executives for High Level Strategy Road Maps Along with Time Lines for Implementation and High Level Project Plans
  • Gather Requirements for Different Lines of Business in Meetings And Prioritize Overall DWH implementation based on inputs from various businesses.

CONSULTANT

Confidential, Boston, MA

Responsibilities:

  • Onshore co-ordinator & Tech Lead for development team offshore in India
  • Data Modeling For the Frame Work - High Level Architecture Diagram, Data Flow Diagram, Logical Data Model, Physical Data Model
  • Provide High Level ETL Specifications and Low Level ETL Specifications Documents.
  • Performance Tuning Of Teradata SQL Queries and Impact Analysis on The Teradata Platform and TASM
  • Performance Tuning of Teradata Stored Procedures And Installation of UDFs and Provide Support to Application Teams

Confidential, Bentonville, AR

Teradata DBA and Onshore Coordinator

Responsibilities:

  • Performance tuning of front end DSS/BI tools queries
  • Develop BTEQ/SQL Scripts for Confidential Implementation
  • Suggestions to implement PPI/SI/AJIs for performance tuning
  • Open up tickets for change control for Confidential migrations from DBA perspective.
  • Suggestions to implement PPI/SI/AJIs for performance tuning
  • User Management ( Roles + Profile Management)
  • Review Data Model & provide inputs to the data architect for Primary Indexes or Partitioned Primary Indexes and Secondary Indexes if needed
  • Automate Confidential Deployment Process and created a process to automate Confidential deployment and validation.

Confidential, Hartford, CT

Onshore co-ordinator & lead

Responsibilities:

  • Performance tuning of Confidential application front end queries generated from SAS & Teradata macros.
  • Develop BTEQ/SQL Scripts for Confidential and implementation plans and co-ordinate team efforts
  • Help in architecture of the new semantic layer summary tables of Confidential
  • Suggestions to implement PPI/AJIs for performance tuning for Prof & Confidential from a developer stand point
  • Open up tickets for change control for Confidential migrations from DBA perspective.
  • In charge of maintaining & setting up environments ( Dev / Test / Model Office / Production)
  • Help setup & maintain TASM settings and work with other Teradata consultants to fine tune TASM settings.
  • Generate weekly CPPT reports to submit to management.
  • Use Atanasoft for Confidential validation & compares
  • Use Atanasoft for data migrations across environments
  • Help in setting up Atanasoft Server settings
  • Confidential Implementation & Tracking in all environments.
  • Worked on hardware upgrade plan of TD13.10
  • Performance tuning of front end application queries.
  • Making PI, PPI, SI, AJIS changes for performance enhancements.
  • User Management ( Roles + Profile Management)
  • Review Data Model & provide inputs to the data architect.

Confidential

Teradata DBA

Responsibilities:

  • Help setup back up & Restore Jobs. ( Confidential )
  • Confidential Implementation & Tracking in all environments.
  • Performance tuning of front end application queries.
  • Making PI, PPI, SI, AJIS changes for performance enhancements.
  • User Management ( Roles + Profile Management)
  • Review Data Model & provide inputs to the data architect.

Confidential, Minneapolis, MN

Teradata Architect

Responsibilities:

  • Provided estimates for the ETL requirements for Matrix Corporate Performance Management
  • Interacted with client to understand the business requirements by conference calls and teleconference meetings
  • Understand changes to the Enterprise Information Model and the impact to the existing Data Model because of Matrix application.
  • Define, document and maintain the Data Model for Matrix Application.
  • Reviewed the designed document with ETL Team and resolved the queries and issues found in design documents
  • Ensure that the database designs fulfill requirements, including data volume, frequency needs, and long-term For Matrix.
  • Performed walkthrough and Reviewed of the deliverables as per standards.
  • Generated the request to move the ETL Components for Matrix Corporate Performance Management from development to QA environment and done the validation in QA once the Components are moved.
  • Interacted with the Quality Assurance testing team to check they understand the business requirements for Matrix Corporate Performance Management Project and performing validation of the BTEQ scripts as per requirements.
  • Assisted new team members to understand the basic knowledge of the Matrix Project.

Confidential

Teradata Architect

Responsibilities:

  • Provided estimates for the ETL requirements.
  • Interacted with client to understand the business requirements by conference calls and teleconference meetings
  • Reviewed the designed document with designer and resolved the queries and issues found in design documents
  • Design, Develop, & Implement ETL processes.
  • Unit Testing Of ETL Process
  • Analyze & document performance characteristics of the ETL processes to support the development of production job schedule
  • Help testing team to create appropriate test cases based on business requirements to ensure good quality data load processing
  • Provide detailed status reporting on development cycle
  • Develop ETL mappings in Informatica to load EDW
  • Analyze SQL associated with database Views to improve performance characteristics
  • Recommended an implementation strategy (including criteria for use) for deployment of database Views
  • Assisted new team members to understand the basic knowledge of the project and provide knowledge transfer sessions.

Hire Now