SUMMARY

• 5.8 years of IT experience in Teradata Administration, Analysis, Design, Implementation, coding, reporting and testing business technology solutions.
• Primary Skill set - Teradata, UNIX, mainframe, ETL (Informatica 9.1, 8.6), Oracle.
• Extensively practical and architectural knowledge of applying SPP and MPP approaches with Informatica Power center using either Teradata or Oracle.
• Achieved Teradata Certified Professional and SQL Specialist.
• Extensively used tools of MLOAD, BTEQ, FastExport, FastLoad, TPUMP and TPT to design and develop dataflow path for loading transforming and maintaining databases.
• Used BTEQ, Queryman and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Hands on experience using query tools like TOAD and SQLPLUS.
• Expertise in creatingdatabases, users, tables, triggers, macros, views, stored procedures, functions, joins and hash indexes in Teradata database.
• Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
• Expertise in writing large/complex queries using SQL.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN, Collect Statistics in Teradata.
• Experienced inUNIX shell scriptsto write wrapper scripts to call ETL Jobs
• Excellent Experience withdifferent indexes (PI, SI, JI, AJIs, PPI )
• Involved in design, enhancement and development of applications for OLTP, OLAP and DSS using dimensional modeling with Teradata.
• Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basicdata modeling.
• Actively worked inQuality Processes and release management activities- To establish, monitor and streamline quality processes in the project.
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.
• Proven client-facing skills, outstanding project success record, communication and collaboration excellence.

TECHNICAL SKILLS

Operating Systems: Windows XP, 2000, UNIX/LINUX, Z/OS

Modelling Tool: Visio

Databases: Teradata V2R5/R6/R12/R13, Oracle (10g/11g)

Teradata tools & Utilities query facilities: SQLAssistant, BTEQ, Visual Explain,View Point

Load & Export: FastLoad, MultiLoad, TPUMP, TPT, FastExport, BTEQ

ETL: Informatica Power Center 8.6/9.1

Languages: JCL, SQL, Shell Scripting, COBOL

Scheduler: Crontab, ESP

Domain: Telecom

Other tools: Changeman, Putty

PROFESSIONAL EXPERIENCE

Confidential

Teradata Analyst/ Senior Teradata Developer

Responsibilities:

• Actively engaged in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation directly with the client.
• Data Analysis and issue identification.
• Propose Architectural design changes to improve data warehouse performance.
• Troubleshooting database issues related to performance, queries, stored procedure
• Fine-tune the existing scripts and process to achieve increased performance and reduced load for faster user query performance.
• Performance tuning, including collecting statistics, analyzing explains and determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Architected and developed Fast Load and MLoad scripts in control file developed BTeq scripts to process the data in staging server.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MLOAD, FASTLOAD, TPT and Informatica
• Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
• Performed database health checks and tuned the databases using Teradata Manager.
• Delivered new and complex high quality solutions to clients in response to varying business requirements and creating and managing user accounts.
• Through Explain Plan analyzed and modified indexes and modified queries with derived or temporary tables to improve the performance. Also utilized Teradata viewpoint
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to business rules.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Designed and developed workflows and automated with UNIX shell scripts and ESP. Created shell scripts to drop and re-create indexes to load data efficiently and decrease load time.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Worked as Tier 3 Support and also as Tier 2 Support.
• Actively worked in providing user support for executing System Integration Testing & Acceptance Testing to business partners.
• Extensively handled production implementation of new systems and Teradata system upgrades as part of maintenance

Confidential

Senior Teradata Developer

Responsibilities:

• Handling ABEND (Job Failure).
• Giving Temporary and permanent fixes to ABENDs.
• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Extensively worked on to convert ORACLE scripts into Teradata scripts.
• Prepared technical specifications to develop INFORMATICA ETL mappings to load data into various tables confirming to the business rules.
• Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the Teradata database.
• Created Teradata objects like Tables and Views.
• Used Joins like Inner Joins, Outer Joins while creating tables in Teradata database.
• Analyzed and designed USI and NUSI based on the column used in joins during data retrieval.
• Worked with SET and MULTISET tables for performance evaluations of the scripts.
• Strong hands on experience using Teradata Utilities (FastExport, MultiLoad, FastLoad, Tpump, BTEQ).
• Used SQL to query the databases and do as much crunching as possible in Teradata using complicated SQL Query Optimization (explain plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc) to achieve better performance.
• Assisted Developers with coding and effective Join issues.
• Designed and Developed workflows and automated with UNIX shell scripts and ESP. Created shell script to drop and re-create indexes to load data efficiently and decrease load time.
• Actively involved in the data modeling and design of the data warehouse with Data Architect, Designed and Implemented star schema models, Identified and built Facts, Dimensions, Aggregate tables to support the reporting needs and requirements of the users.
• Responsible for handling ad-hoc requests & queries from client.
• Application design, Unit testing, system test support, deployment plan preparation.
• Guided the new team members to observe the development methodologies and architecture.

Confidential

Teradata Developer

Responsibilities:

• Tier -3 production support & Batch Cycle Monitoring.
• Handled production live defects very effectively and provided them with permanent fix.
• Worked extensively on Enhancement Work independently and providing user support for executing System Integration Testing and Acceptance testing.
• Expertise in Disaster Recovery Exercises.
• Used COBOL to produce report by table and report by unit of work; purpose was to provide a quicker review of database changes.
• Involved in identifying the performance bottlenecks and optimizing respective databases and processes for performance improvement.
• Accomplished data movements process that load data from DB2 into Teradata by the using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, and improved the design of Extract and Load specifications.
• Developed and executed business reports using Teradata SQL advanced techniques like rank, row number and etc.
• Tuned the queries to improve the performance of the existing reports for various functional areas.
• Created a UNIX script that uses BTeq to access Teradata Database.
• Created a shell script that checks the corruption of data file prior to the data load.
• Created Global and volatile temporary tables to load large volumes of data into Teradata database.
• Created various tables, indexes, views, string functions and joins in Teradata.
• Involved in writing stored procedures for testing SQLs.
• Involved in installing batch programs.
• Involved in enhancement work on new programs as requirement changes.
• Expertise in writing sort cards using DFSORT and SYNCSORT utilities
• Experience in preparing user documentation and user training using MS-WORD, MS-VISIO.