PROFESSIONAL SUMMARY:

• Around 10 years and 9 months of diversified experience in the field of Information Technology with around 8 years of experience on Data warehousing and Decision Support Systems (DSS) and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Teradata 14.10/13.10/12/ V2R5 and Unix.
• Currently working for client Apple as Teradata Technical Lead in Sunnyvale,CA. Have been working in projects in USA since 2011.
• Extensive experience in Teradata database design, physical implementation, application support, maintenance, performance tuning and Optimization. Dimension Modeling, semantic data modeling, Metadata, Multidimensional Databases.
• Experience in developing & executing Bteq, MLoad, and FastLoad scripts to load data into Teradata Enterprise Data warehouse from various source files.
• Analysis and development of Views,worksheets and Dashboards in Tableau as per business need
• Experience in developing & executing Load utilities using TPTLoad/ Stream/ Update/ Selector.
• Expertise in Teradata performance tuning with all indexing techniques and SQL tuning.
• Applied compression techniques such as BLC, MVC and taken large tables for horizontal split for better performance and space savings.
• Hands on experience in using Unity Datamover by developing xmls to migrate data between Teradata production environments and non-production environments.
• Expertise in Teradata Stored procedure, Macro, View, UDF.
• Experience in developing TPTExport, Fast export, BTeq script to export the data from Teradata.
• Extensive experience in Teradata version Up-gradation from V12 to V13 including performance benchmarking.
• Experience in designing and developing business semantic layers.
• Experience in report formatting, batch processing, data loading and exporting using BTEQ..
• Extensive experience in Teradata TD14.10/TD13.10 ETL Utilities, Bteq, MLoad, FLoad, TPT, Tpump, Fast export and Fallback Mechanisms, Control workload management using TASM for Various Application support, Debugging and fixes
• Expertise in designing the architecture of the Extract, Transform and Load process and development of transformation standards and processes using ETL best practices.
• Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.
• Have in depth knowledge and experience in implementing the best practices for design and development of data warehouses using Star schema & Snowflake schema design concepts.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Extensive experience in UNIX shell scripting (Ksh/Csh), Job scheduling using Autosys.
• Knowledge on hadoop eco system with hands on experience using HIVE and Sqoop
• Performed unit testing and integration testing for the developed data load process.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:RDBMS: Teradata 14.10, 13.10, 12.10, V2R5, DB2

Teradata Tool & Utilities: TPTLoad/Stream/Update/selector, BTEQ, Fastload, Multiload, TPUMP, PMON,Viewpoint, TD SQL Assistant, TD workbench, studio, Data mover

Data Visualization : Tableau

Compression Techniques : Blocklevel, Multivalue Compressions using Atana Suit.

Database Tools: SQL Developer, TOAD

Data Modeling Tool: Erwin

Scheduling Tool: Autosys, CA-7

Languages: SQL, Shell Scripting, BTEQs, MLoad, Fload, Tpump, Fast Export, TPT

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

Mainframe Technologies: COBOL, JCL,, DB2,VSAM, Expediter, Smartest, Intertest, Endevor, Change man, File-Aid, TSO, SPUFI, QMF, ISPF Panels, NDM, FTP, SAR Production Problem

management tools : SOLVE Problem, Unicentre, Pac2000, Peregrine ServiceCentre, Maximo

PROFESSIONAL EXPERIENCE

Confidential, Cupertino, CA

Technical Architect

Responsibilities:

• Involved in design of ETL process for the data warehouse including the initial load, which comprises of Dynamic TPT, TPUMP, FLOAD, BTEQ,
• Used Teradata utilities like TPT,FLoad, MLoad & BTEQ, and Stored Procedures to load the data into Teradata Data Warehouse.
• Analyze the reporting requirements and provides best possible solution in the CORE and the semantic layer.
• Participated in high level database design and Modeling.
• Provide high level documentation for flow design, ETL technical specifications, source system handling and incremental load strategies.
• Analyze the scripts and provide solutions to improve the performance.
• Extensive use of TASM and DBQLOGBL to analyze queries and provide feedback.
• Supported the implementation of applications into production.
• Work with ETL developers to implement the ETL logic.
• Has done POCs for various solutions that provides best visualization of the performance, trend, best in terms of usability and scales with future expansion of the GBI-EDW.
• Develops automated tools as and when required based on the requirements.
• Reviewing the architecture and code being developed on performance aspects.
• Proactive analysis on Applications and fine-tuning on performance aspects.
• Building effective learning Guide and best practices, which could be used across GBI-EDW.
• View point monitoring to check the system health and Usage.
• Have taken part in TD13-14 software up gradation

Environment: TPTLoad/Stream/export/Update, BTEQs, TPump, FLoad, Fast Export, Teradata, Erwin,Viewpoint, Sql assistant, Unix.

Confidential, Cupertino, CA

Technical Lead

Responsibilities:

• Design and development of initial loads using Teradata load utilities such as TPTLoad,stream,TPUMP, FastLoad, BTEQ.
• Design and development of semantic/presentation layer using Teradata stored Procedures and Macros
• High level database design and Modeling.
• Provide high level documentation for flow design, ETL technical specifications, source system handling and incremental load strategies.
• Overseeing installations and Release Management including the final production acceptance review and signoff
• Analyze the scripts and provide solutions to improve the performance.
• Code and design reviews
• Documenting the best practices and coding standards
• Proactive analysis and fine-tuning code on performance aspects.

Environment: TPTLoad/Stream/export/Update, BTEQs, TPump, FLoad, Fast Export, Teradata, Erwin, Informatica, Unix.

Confidential, Charlotte, NC

Sr. Teradata Developer

Responsibilities

• Requirement Analysis from the client side and coordinating with the offshore team members.
• Monitoring system and query performance
• Coordinating and executing conversion activities as per the requirement from Confidential bill pay system to Wells Fargo system
• Analyzing On-line, Batch and preparing Program Specifications as per conversion guidelines
• Workload analysis and reporting
• Preparing technical specifications
• Analyzing the abends occurring during daily, monthly cycle execution and providing break fix

Environment: Teradata, BTEQ, Unix, SQL assistant, Load utilities, PMON

Confidential, Jacksonville, FL

Teradata Lead

Responsibilities

• Working on abend resolution during ETLs and restarting the application Loads
• Clean-up and reload activities - arising due to wrong application loads
• Preparing functional and technical specifications
• Impact Analysis and coding
• Resolving functional tickets and user queries
• Teradata View point monitoring
• Handling Teradata outage calls (planned/unplanned) and taking necessary actions to catch up the lagging application loads.
• Identifying bad performing, box impacting queries and unauthorized users
• Monitoring system and query performance
• Workload analysis and reporting

Environment: Teradata, PMON, TASM, Teradata SQL Assist, Bteq, Fastload, Mload, Erwin

Confidential

Sr.Teradata Developer

Responsibilities

• Identifying impacted components
• Code changes as per specifications
• Preparing detail design documents
• Reviewing the Technical specifications, code and Test plans
• Preparing Unit test plan and String test plan
• Unit and String test Data modeling
• Unit testing and string testing
• Production Handover

Environment: Teradata, JCL, COBOL,Expeditor, Endevor, Endevor, Control-M

Confidential

Application Developer

Responsibilities

• Production Support and Break fix analysis
• Preparing Implementation Proposals
• Impact Analysis
• Code changes as per specifications
• Solving the tickets raised by the customer as per severity
• Unit test plan preparation, Unit testing, review

Environment: CICS, COBOL, DB2, VSAM, JCL, REXX, File-Aid, ENDEVOR, TSO/ISPF, Expediter