We provide IT Staff Augmentation Services!

Teradata Developer Resume

SUMMARY

  • 5+ plus years of experience as BI Consultant experience in Development, operations and Maintenance of various Client/Server and applications in Finance, Telecom and health projects.
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
  • Extensive SQL experience in querying, data extraction and data transformations. Wrote Teradata Macros and used various Teradata analytic functions.
  • Strong hands on experience using Teradata utilities (SQL, B - TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 16.20, Analytical functions, performance tuning of SQL queries and different scripts.
  • Coordinate discussions between leads, business analysts and ETL developers and help facilitate design and development to ensure requirements are fully coded, tested and implemented.
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
  • Proficient in Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary, derived tables etc.
  • Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 16.20, Analytical functions, performance tuning of SQL queries and different scripts.
  • Provides leadership on development projects, assignments, and highly complex analysis.
  • Proficient in Teradata EXPLAIN plans, Collect Statistics option, Primary Indexes, Secondary Indexes, Partition Primary Index, Join Indexes, Volatile, global temporary, derived tables etc.
  • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors, Hash Indexes in Teradata.
  • Involved in migration projects to migrate data from data warehouses on Oracle and migrated to Teradata.
  • Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD). Expertise in all phases of Software Development Life Cycle (SDLC). Very good insight of Waterfall / Agile project management methodology
  • Strong experience in designing and developing large scale and optimized Data Warehouses using Teradata
  • Good exposure in Data Modelling for OLAP, OLTP, ODS and Data Mart or Data Warehouse for Financial Application.
  • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
  • Teradata System Performance Tuning/Optimization
  • Collected statistics periodically on tables to improve system performance.
  • Performed tuning and optimization of application complex SQL using Query analyzing tools. Experience in creating Ad hoc-reporting ready universes using SAP Business Objects xi4.1 Universe Designer.
  • Experienced with mentoring Teradata Development teams/new join, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
  • Migrated reports from Business Objects 6.5 to Business Objects XI 3.1, BI 4.0/4.1/4.2.
  • Migrated from Universe design tool (UDT) to Information design tool (IDT).
  • Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
  • Extensively used Teradata versions, Informatica Power Center 10.1/9.6/9.5/9.1/8.6/8.1 , Informatica Data Quality (IDQ) 10.1/9.5/9.1 as ETL tool for extracting, transforming and loading data from various source data inputs to various targets.

TECHNICAL SKILLS

Databases: Teradata 16.20,V2R5, V2R6, V2R13, V215, DB2, Oracle 10g, 11g, 12C.

SQL Tools: Teradata SQL Assistance 16.20, TOAD 12.8, SQL Developer, T-SQL.

Languages: SQL, PL/SQL, Java Script, Perl, Python.

Reporting Tools: SAP Business Objects BI 4.2/ XI 3.1. SAP Business Objects Dashboards/Xcelsius 2008, SAP BO Web Intelligence Rich Client

ETL Tools: BTEQ, Fast Load, Multiload, Fast Export, Tpump, TPT

Configuration Tools: BMC Remedy, Confidential Rational Team Concert6.02, Zillow

Project Methodology/Tools: Waterfall, Agile, Hybrid, Scrum, MS office 2016, MS VISIO 2016, MS Project 2016, JIRA, SVN.

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Teradata Developer

Environment: /Tools Used: Teradata 16.20 Utilities -TPT, BTEQ, MLOAD, FAST LOAD, FAST EXPORT, Teradata Viewpoint 16.20, Stored Procedure, Oracle 12c, Informatica Power Center 10.1, Linux, WinSCP3, Toad 12.8.4, CICD, GIT GUI, DevOps, JIRA, SAS DI 4.9, SharePoint, Tableau, IWS, Confluence.

Responsibilities:

  • Direct interaction with Confidential business users, Daily sprint update at 9:15 AM meetings and updates. Meeting with different stake holder Analysts and Modeler.
  • Writing Complex Data warehouse Teradata 16.20 SQL Queries, Dynamic SQL queries.
  • Extensively used Fast export to export data out of Teradata 16.20 tables.
  • Worked extensively with Teradata 16.20 utilities - BTEQ, Fast load, Multiload, Teradata Parallel Transporter (TPT) to load huge amounts of data into Teradata database.
  • Created BTEQ scripts to invoke various load utilities, transform the data and query against Teradata database.
  • Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
  • Writing BTEQ scripts and do CICD build process via Jenkins.
  • Proficient in Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary, derived tables etc.
  • Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 16.20, Analytical functions, performance tuning of SQL queries and different scripts.
  • Experience in performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance.
  • Created Tableau Data Sources using EDW Tables and custom SQL with inner, left and right joins.
  • Created Oracle PL/SQL Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor, External Tables and Collections, Dynamic SQL, and Exception handling.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Developed Oracle PL/SQL triggers and master tables for automatic creation of primary keys.
  • Used Rank functions, advanced analysis in Tableau, analytical functions in SQL and parameter passing through SQL to build

Confidential

Teradata Developer Environment: /Tools Used: Teradata 16.20 Utilities -TPT, BTEQ, MLOAD, FAST LOAD, FAST EXPORT, Teradata Viewpoint 16.20, Stored Procedure, Oracle 12c, Informatica Power Center 10.1, Linux, WinSCP3, Toad 12.8.4, CICD, GIT GUI, DevOps, JIRA, SAS DI 4.9, SharePoint, Tableau, IWS, Confluence.

Responsibilities:

  • Leading and managing team and monitor day to activity.
  • Direct interaction with Confidential - Confidential global business customers, receiving feedback and assign to appropriate team member. Allocate tasks to respective team members.
  • Test Documents, SQL Coding, SQL Tuning, Extract the data from different source file excel CSV format and text loaded the required data in oracle data base, applying the complex business logic and excel formulae.
  • Create mapping and migration analysis documents. For data migration writing and Unit testing the following scripts: Teradata Parallel Transporter- TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Load data from several flat files sources using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT).
  • Create mapping and migration analysis documents. For data migration writing and Unit testing the following scripts: Teradata Parallel Transporter- TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Load data from several flat files sources using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT).
  • Design and Development of SAP Business Objects Universe's using Information Design Tool to drive Static and ad-hoc reports.
  • Implemented Event Based, Pdf Bookmark scheduling of Crystal, SAP Business Objects Web intelligence reports to a SharePoint location.
  • Created SAP Business Objects reports using IDT from more than one data source.
  • Migrated users, categories, groups, SAP Business Objects reports, folders, Universes, security models from SAP Business Objects XIR3 version to Business Objects 4.0 and fixed the issues during the migration and after migration.
  • Reduction of revenue leakage from under billing of usage and usage analysis.
  • Reduction in churn through provision of churn analysis and predictive modeling.
  • Development of basic campaign list generation functionality.
  • Basic Profitability Analysis to identify customers who are profitable to base on their usage behavior.
  • Identify the target audience for a proposed tariff plan based on usage behavior of Subscriber.
  • Identify the Impact of a Tariff Plan based on change in usage behavior after the Tariff plan introduction.
  • Identify Target market of subscribers from analysis of the incoming.
  • CDR Reconciliation across Interconnect, Mediation and Billing.

Hire Now