Teradata/ET
Resume:
Naren Annapreddy
***************@*****.***
Teradata Consultant/ETL Developer
PROFESSIONAL SUMMARY:
Over 8 years of experience in the IT industry, coupled with extensive experience in Data Warehousing Teradata (V12/13/14/15/16) & UNIX Environment for Decision Support Systems.
Over 7 Years of experience in TeradataDatabase design, implementation and maintenance mainly in large scale Data Warehouse environments.
Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning.
Extensive experience in Administration and maintenance of Teradata,Dev, Stage, prod and standby databases for DSS and Data Warehousing environments.
Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
Hands on experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata SQL and BTEQ Teradata utilities.
Hands on experience in Teradata Server using VIEWPOINT,NODE performance.
Expertise in Resource Management using TDQM
Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
Expertise in Query Analyzing, performance tuning and testing.
Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager.
Experience in writing UNIXshell scripts to support and automate the ETL process.
Scheduled the Shell scripts through Maestro Jobs to kick off the Batches.
Experience in different database architectures like Shared Nothing and Shared Everything architectures. Very good understanding of SMP and MPP architectures.
Experience in Oracle RDBMS Architecture.
Extensive experience in Logical and physical modeling using Erwin. Hands on experience in 3NF, Star and Snowflakeschema design and De-normalization techniques.
Involved in Unit Testing, Integration Testing and preparing test cases.
Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.
Experience in ETL tools like Informatica, Ab Initio.
Experience with Teradata Unity system in the environment
Very good understanding of Reporting tools like Cognos and Business Objects.
Involved in production support activities 24/7 during on call and resolved database issues.
Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
TECHNICAL ENVIRONMENT:
OPERATING SYSTEMS:
Sun Solaris 8, 9, 10, AIX 5.1, 5.2, Mainframes MVS, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows.
RDBMS:
Teradata(12.0/13.0/V14.0/V15), Oracle 11g/10g/9i, Oracle 10g Real Application Clusters (RAC), SQLServer2005.
LANGUAGES:
SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.
SOFTWARE / APPLICATIONS/ TOOLS:
Teradata SQL Assistant, Viewpoint,BTEQ, FastLoad, MultiLoad, FastExport, TpumpORACLE 9i/10g/11i, Real Applications Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters, EMC Storage,Trillium 7.6/6.5,Developer 2000, SQL Loader, TOAD, Oracle Enterprise Manager,Informatica, Ab Initio (Co>Operating system 3.0/2.15, GDE 3.0/1.15), Business Objects Suite.
WEB TOOLS
HTML, XML, Java Script, VB Script, JCL,Java, ASP, CGI with Perl and Java Servlets, Visual Age, Visual Cafe and Jbuilder, Apache and IIS 4.0.
PROFESSIONAL EXPERIENCE:
Frontier Communications, Allen, Tx Oct’19-Present
Role: Lead Teradata DBA/Analyst/Developer (Data Warehouse)
Environment: Teradata V16, Viewpoint, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, Erwin Designer, UNIX, MVS,SQL SERVER, SSIS, Shell scripts.
Responsibilities:
Design, implementation, and maintenance of Teradata databases. Advanced working knowledge in relational database administration and enterprise data warehousing. In-depth database administration experience with the Teradata RDBMS systems and Teradata administration utilities. Perform database performance and tuning, database design, implementation and support, capacity management, backup/recovery, and business continuity.
Developing and analyzing highly complex system standards, thresholds, and recommendations to maximize system performance
Evaluating products and upgrades for appropriateness and lead the implementation and upgrade strategies
Creating / Modifying the database tables, views, or other database objects to support the projects and change requests that impact the Data Warehouse
Supporting backup and restore/retrieval process - using the BAR DSA and NetBackup. Create, implement, and maintain BAR strategy for the Teradata (TD) application and system databases
Maintaining rules set in TASM and supporting workload management. Maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels
Maintaining Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc
Performing Teradata SQL troubleshooting and fine tuning of scripts
Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools and application servers and make preventive or corrective actions as needed
Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage, security administration etc.
Coordinating with Teradata to perform Teradata system hardening and delivery SCSEM Reports as needed addressing issues in the hardening and vulnerability scan report
Generating and maintaining capacity management, Space, and CPU reports on analyzing the Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance and growth requirements
Reviewing and resolving Teradata alerts and communicate any risk / issues or impact to the management, team, and business users through appropriate communication strategy
Creating Teradata incident on issues, tracking using TAYS, setting appropriate priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
Providing weekly status update and update the weekly status report with the summary of database related activities including maintenance and issues
Analyzing project requirements and develop detailed specifications for new and existing data warehouse database related requirements
define problems, and devise solutions and alternatives and make appropriate recommendations
Working with the team and data modelers, facilitate modification of the logical design to create a physical design most suited to the business needs of the customer
Working with developers and Enterprise Data Warehouse (EDW) team to create and maintain database standards
United Airlines, Chicago, IL May’18-Oct’19
Role: Teradata Developer
Environment: Teradata V15, Viewpoint,Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, Erwin Designer, UNIX, MVS,SQL SERVER,SSIS,Shell scripts.
Responsibilities:
Created tables, views in Teradata, according to the requirements.
Involved in the analysis and implementation of their system.
Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data Mart
Involved heavily in writing complex SQL queries based on the given requirements.
Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, FastLoad, MultiLoad and Tpump
Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements.
Performed tuning and optimization of complex SQL queries using Teradata Explain.
Created a BTEQ script for pre population of the work tables prior to the main load process.
Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
Performance Tuning of sources, Targets, mappings and SQL queries in transformations
Used FastLoad for loading into the empty tables.
Created reports using BTEQ scripts reporting functionalities and FastExport for the end user.
Used volatile table and derived queries for breaking up complex queries into simpler queries.
Created an archive process that archives the data files and FTP to the remote server.
Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
Created a shell script that checks the corruption of data file prior to the load.
Created unit test plans to unit test the code prior to the handover process to QA.
Involved in troubleshooting the production issues and providing production support.
Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
Collected statistics every week on the tables to improve performance.
Developed unit test plans and involved in system testing.
American Express, Phoenix, AZ Feb’16-Apr’18
Role: Teradata Developer/DBA
Environment: Teradata V14, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, MVS, Erwin Designer, UNIX, Windows 2000, DB2, Shell scripts.
Responsibilities:
Created tables, views in Teradata, according to the requirements.
Involved in the analysis and implementation of their system.
Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, FastLoad, MultiLoad and Tpump
Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data Mart.
Performed tuning and optimization of complex SQL queries using Teradata Explain.
Created a BTEQ script for pre population of the work tables prior to the main load process.
Used volatile table and derived queries for breaking up complex queries into simpler queries.
Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
Performance Tuning of sources, Targets, mappings and SQL queries in transformations
Used FastLoad for loading into the empty tables.
Involved heavily in writing complex SQL queries based on the given requirements.
Created an archive process that archives the data files and FTP to the remote server.
Created reports using BTEQ scripts reporting functionalities and FastExport for the end user.
Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements.
Involved in troubleshooting the production issues and providing production support.
Created a shell script that checks the corruption of data file prior to the load.
Created unit test plans to unit test the code prior to the handover process to QA.
Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
Enhancements were done to the existing system as specified by the customer using Cobol, DB2, and JCL.
Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
Collected statistics every week on the tables to improve performance.
Developed unit test plans and involved in system testing.
Key Bank, Cincinnati, OH Dec’14-Jan’16
Role: Teradata Developer/DBA
Environment: Oracle 10g, MS-Access, TOAD, Teradata Administrator, Teradata V13, Teradata SQL Assistant, Teradata Manager, SQL, UNIX and Windows NT, AutoSys.
Responsibilities:
Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
Assisted DBA to Create tables and views in Teradata, Oracle database.
Dealt with Incremental data as well Migration data to load into the Teradata.
Have experience in tuning some batch BTEQ queries.
Enhanced some queries in the other application to run faster and more efficiently.
Created some data files by using FAST Export and have developed a common FTP script to port them on to the clients’ server.
Data was extracted from Teradata, Processed/Transformed using Ksh programs and loaded into Data Mart.
Used various Teradata Index techniques to improve the query performance
Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
Modified BTEQ scripts to load data fromTeradata Staging area to Teradata data mart
Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit and system test.
Created series of Macros for various applications in TERADATA SQL Assistant.
Responsible for loading data into warehouse from different sources using Multiload and Fastloadto load millions of records.
Performed tuning and optimization of complex SQL queries using Teradata Explain.
Created several custom tables, views and macros to support reporting and analytic requirements.
Performed Unit testing, System Testing and Integration testing to validate the data being staged.
Fedex, Memphis, TN__ Oct’13 to Nov ‘14
Role: Teradata / ETL Developer
Environment: Unix /Sun Solaris, Windows XP, Oracle 10g, SQL, PL/SQL, Teradata V12, Informatica Power Center,Erwin, XML, TOAD,Unix
Responsibilities:
Worked on the Module Call Detail Record, sustaining its Production support, implemented digits analysis on the called number to identify the called country, within and outside the nation and identified the international long distance calls.
Developed the shell scripts to automate the Call Detail Records – Informatica processes and subsequent concatenation of load ready files.
Worked on different subject areas like Product, Billing, Subscription, and Party.
Worked on the National Billing Instance (NBI) - module which involving modifying no. mappings and corresponding FastLoad and Bteq scripts.
Performed functional/requirements testing, testing for defects, regression testing.
Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Informatica Workflow Manager.
Developed Source to TargetMappings using Informatica PowerCenter Designer from Oracle, Flat files sources to teradata database, implementing the business rules.
Created Stored Procedures to transform the data. Worked extensively on SQL, PL/SQL for various needs of the transformations.
Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer, Stored Procedure, Union etc.
Extensively used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Used the Informatica Workflow manager to create sessions, worklets and workflows to create Load Ready Files (flat files).
Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart
Used FastLoad for loading into the empty tables.
Used volatiletable and derived queries for breaking up complex queries into simpler queries
Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
Worked on Teradata Queryman to validate the data in warehouse for sanity check.
Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
Protech Systems, Hyderabad, India Aug ’12 to Sep ‘13
Role: Programmer / Analyst
Environment: Oracle, SQL, PL/SQL, Developer 2000, Reporter 4.5, UNIX and Windows NT, Korn Shell.
Responsibilities:
Extensively involved in requirements gathering and data gathering to support developers in handling the design specification
Involved in designing and coding of functional specifications for the development of user interfaces
Created tables, indexes, sequences, constraints and snapshots
Developed packages, procedures, functions and PL/SQL blocks for data validation
Developed PL/SQL scripts to validate and load data into interface tables
Fixed software bugs and interacted with developers to resolve technical issues
Designed and developed a Generic Billing system for a Telecommunication company
Responsible for all pre-ETL tasks upon which the Warehouse depends including managing & collection of various existing data sources.
Contact this candidate