SUMMARY

• Teradata Certified consultant with 7 years of experience in domains like Banking, Financial Services, Manufacturing and Telecommunications.
• Involved in various phases of IT projects in planning and designing Data Warehouse applications, gathering business requirements, analysis, development, testing and implementation encompassing SDLC methodology.
• In depth knowledge in Data Warehousing concepts, Teradata Stored Procedures, Teradata Load utilities (BTEQ, FASTLOAD, TERADATA PARALLEL TRANSPORTER, FASTEXPORT, MULTILOAD), Teradata Administrator, SQL Assistant, PMON, UNIX scripting, Data Modeling.
• Proficient in architectural diagrams, logic flowcharts, data maps, operating, maintenance and support procedures, and detailed documentation of the technical design.
• Extensive knowledge of Teradata system architecture, security administration using roles and profiles mechanism, create users, grant permissions, roles and privileges.
• Expertise in Teradata appliance, physical implementation that includes UPI, NUPI, USI, NUSI, JOINS, AJI, Partitions etc.
• Good in tuning queries to leverage benefits of parallel architecture of Teradata database to enhance performance.
• Exposure in extracting, transforming and loading (ETL) data from other databases and text files using ETL tools like Abinitio and DataStage.
• Sound knowledge of logical and Physical Data Model design process in Star and Snowflake Schema, 3NF
• Expertise in debugging complex queries, performance tuning, existing ETL process.
• Working knowledge of BI tools like Cognos, Brio and Hyperion
• Experience in fork lifting data warehouses and data marts from other database like Oracle to Teradata
• Capable of identifying performance issues and implementing optimal solutions.
• Hands on experience in data modeling, program code development, test plan development and datasets creation.
• Involved in documentation of various functionalities of Data Warehouse, Data Marts, and Business Intelligence.
• Good at mentoring and training new team members, testing and result documentation, analyzing business requirement, defect fixing
• Strong communication, presentation and interpersonal skills with excellent problem solving capabilities
• Experience in offshore/onsite model

TECHNICAL SKILLS

Databases: Teradata, SAS and Oracle 9i/10g

ETL: Abinitio, DataStage

BI/APPLICATION: Cogon’s, Brio, Hyperion, HP Quality Center

Languages: SQL, PL/SQL, SAS, Java

OS: Sun Solaris 9, IBM AIX 5.3, Windows

Data Modeling: ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Teradata Consultant

Responsibilities:

• Worked as an application DBA, expertise in creating new environments.
• Created Database objects, users, roles, imposed security on the data.
• Allocated appropriate space to databases.
• Troubleshooting & fixing the existing load scripts.
• Optimized the existing views and SQL queries.
• Provided performance optimizing solutions that includes implementing JOIN INDEXES, Partitioned Primary Indexes
• Wrote TPT scripts to load/ unload data to/from Teradata that includes writing a generic script as well.
• Monitoring Database usage using PDCR Info.
• Being offshore lead was accountable for client & onsite deliveries.
• Was single point of contact for onsite team, mentored team members, daily status update reporting to project manager.
• Performed data quality and integrity testing in co - ordination with development teams.

Confidential, Wilmington, DE

Teradata Lead

Responsibilities:

• Involved in the physical design and creation of Technical Design Document.
• Used Teradata SQL with BTEQ scripts to get the data needed
• Extensively worked under the UNIX Environment using Shell Scripts.
• Analyzed the Data Distribution and Reviewed the Index choices
• Developed strategies for Testing Team to perform data validation and data integrity check.
• Involved in the Teradata set up testing that included testing Teradata Tools & Utilities, Teradata to BI Connectivity, Teradata to SAS Connectivity
• Involved in creation of test dataset.
• As Onsite lead responsible for gathering requirements, Team co-ordination, and Client interaction.

Confidential, Washington DC

Teradata Consultant

Responsibilities:

• Developed complex and highly-optimized SQLs looking up at core EDW in Third Normal Form to output at demoralized data mart requirements
• Create and execute test plans for Unit, Integration, and System test phases
• Developed UNIX shell scripts .
• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements
• Handled Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Data Profiling, Data Mapping, and Programmer Specs conforming to internal guidelines
• Assisted SIT/UAT testers in optimizing testing scripts and to ensure data accuracy and integrity.
• Extensively worked on data Extraction, Transformation and loading from source to target system using Bteq, FastLoad and MultiLoad.
• Involved in writing scripts for loading data to target data Warehouse for Bteq, FastLoad and MultiLoad.
• Did error handling and performance tuning in Teradata queries and utilities.
• Involved in unit testing and preparing test cases. Involved in manual & functional testing and peer reviews.

Confidential

Teradata Consultant

Responsibilities:

• Analyzed business requirements, transformed data, and mapped source data from the source system to the Teradata Physical Data Model.
• Developed Teradata Stored Procedures to load data from 3NF schema to Start Schema.
• Worked with Teradata PMON, Teradata Admin and Teradata Manager to monitor the performance and tuned SQLs to help improve performance.
• Optimizing Query Performance, Session Performance and Reliability.
• Perform testing activities, verify & validate compiled data.
• Understanding Business needs and implementing the same into a functional database design.
• Worked closely with business analyst and analyze source data to develop the transformation logic.
• Involved in unit testing and preparing test cases. Involved in manual & functional testing and peer reviews.

Confidential, Phoenix, AZ

Teradata Production Support Personnel

Responsibilities:

• Acquired knowledge on Teradata SQL Assistant, Teradata Administrator and Performance Monitor (PMON).
• Involved in writing extraction scripts using SQL, BTEQ, Fast Export scripts.
• Create and drop Databases, Profiles, Roles, Tables, Views, Indexes (Primary, Secondary, partitioned etc.), Triggers, Macros and stored procedures.
• Data loading to Teradata tables using Fast load and Multi load scripts.
• Created simple Datastage jobs.
• Supported reporting tool like Brio & Hyperion.
• Created Physical data model using Erwin Data modeling tool.
• Provided 24/7 on call Prod support.
• Scheduling and Monitoring of Jobs using Maestro Scheduler.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues, enhanced SQLs for performance tuning.
• Rolled out documentation for the ETL Process and Data Profiling.
• Supported the production implementation of the data warehouse, monitored jobs & fixed failed scripts
• Supported throughout the lifecycle of project and was involved in Migration from Oracle to Teradata