SUMMARY:

• Teradata Consultant in the field of DataWarehousing and Business Intelligence with around 15+ years of experience
• Managed team of 35+ of ETL Support, BO Admin, Teradata Admins and Tableau Developers
• Cloud transformation Migration enablement. Azure, Google cloud and Snowflake certified.
• Direct interaction with business users and stake holders with delivery ownership.
• Database administrator and Teradata Consultant.
• Expertise in Teradata and DWBI. Learning Big Data, Splunk and Tableau
• Good Knowledge on SDLC life cycle for Design , Development and Staging phases of the projects with support of Data - Flow, Process Models, E-R Diagrams.
• Keen interest towards automation of routine tasks and reports.
• Good hands-on Performance tuning and cost reduction initiatives
• Worked extensively on performance tuning of the SQL queries & database tuning. Extensive experience in dealing with high volumes of data, partitioning, materialized views and tuning the code units to meet the performance requirements.
• Ability to identify root cause of problems. Consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Excellent communicator and quick learner with an ability to work independently.
• Good communication skills and team player with analytical, problem solving, interpersonal skills.

TECHNICAL EXPERTISE:

Databases: Teradata 15.10, Oracle, SQL Server 7, Mysql

Operating Systems: MP RAS, AIX 5.2, Linux and SCO UNIX

Big data Basics: Hadoop, HIVE, PIG, MongoDB

Programming: C, C++

Scripting Language: Shell Scripting, AWK, SED, Perl

Migration / ETL Tools: Informatica basics

Reporting Tools: Tableau, Excel based reports

Cloud Computing: Google cloud, Azure, Snowflake, AWS

PROFESSIONAL EXPERIENCE:

Confidential

Principal Consultant / Teradata DBA

Environment: Teradata 15.10, Informatica, Suse UNIX and Windows.

Teradata Tools: Teradata Administrator, ViewPoint, TARA GUI, NetBackup, BTEQ, SQL ASSISTANT, Teradata Utilities, PDCR, Autostats, DSA (Data stream architecture), Data Mover

BI Tools: Tableau, Excel based reports.

ETL Tool: Informatica, Teradata bulkload utilities like Fload, Mload, Bteq, Fexp

Responsibilities:

• Handling overall project delivery from DWBI project delivery.
• Experience with Teradata 15.10 and earlier versions on Linux
• Coordination with Teradata GSC, Informatica support.
• Leading a team of DBAs, ETL admins, BO Admins and Production support.
• Working with Tableau developer to develop Platform availability, usability and performance reports.
• Automating routine DBA tasks like space management, daily & weekly reporting, user management, stats collection, Invalid logon checks and access management.
• Worked on Teradata upgrade from 13.10 to 14.10
• Direct interaction with Client DBA for getting requirement and planning
• Planning and coordinating tasks for local team. Managing escalation with proper RCA report.
• Internal Resource utilization management
• Writing/Modifying stored procedures
• Tuning bad performing Teradata SQL query
• Creating and Analyzing AWT chart to identify bad performing queries
• Managing and designing platform collect stats
• Analyzing tables for sample stats and its implementation
• DDL reviews of new tables to decide PI, PPI, Secondary Indexes, Join Indexes etc.
• Monitoring and handling Database production issues related to Teradata
• Design and create Teradata DB, initially size the databases and manage their sizes
• Set up users, roles based on customer’s internal standards and security model
• Access management of Teradata Database objects for the users
• Facing SOX and other compliance Audit for customer
• Design and maintain table compression using MVC and statistics collection of Teradata tables
• Carry out various maintenance tasks (Monthly table purging, Space management, Password reset/unlock etc.)
• Weekly reporting for Teradata system performance to the customer
• Backup, vault and restore database / tables using Net backup according to project’s needs

Confidential

Analysis, Development and Reporting

Environment: Teradata, UNIX and Windows.

ETL Tools: Teradata BTEQ, SQL ASSISTANT, Teradata Utilities

Responsibilities:

• Analysing functional and technical requirements and providing solution.
• Working with team at onsite to implement.
• Co-ordinating with onsite and assigning tasks to offshore.
• Helping to implement process and policies as per Confidential and client specifications.

Confidential

Analysis, Development and Reporting

Environment: Teradata, SQL, MP RAS UNIX, Excel Reports.

ETL Tools: Teradata BTEQ, FASTLOAD, SQL ASSISTANT, MULTILOAD

Responsibilities:

• Implementation of End to End solution.
• Used BTEQ, FASTLOAD, SQL Assistant and MULTILOAD to load data.
• Performance tuning of inefficient business queries and making data accessible to them in best possible way.
• Prepared Meta Data dictionary for final tables used by other users as reference document.
• Implementing data cleaning and reconciliation strategy.
• Designing Migration document and migrating processes to P&D team by providing them required documentation to run them from offshore.
• Investigating root cause of inefficient queries and working with developers to fix them.
• Ensuring that agreed coding standard and practices followed and adhered.
• Experience of implementing both sparse and snapshot architecture for storing data.

Commercial

Analysis, Development and Reporting

Environment: Teradata, SQL, MP RAS UNIX, Excel Reports.

ETL Tools: Teradata BTEQ, FASTLOAD, SQL ASSISTANT, MULTILOAD

Responsibilities:

• Implementation of End to End solution.
• Automating the process through UNIX shell scripting and sending reports to business users directly through UNIX without any user involvement.
• Used BTEQ, FASTLOAD, SQL Assistant and MULTILOAD to load data.
• Designing Migration document and migrating processes to P&D team by providing them required documentation to run them from offshore.
• Implementing various financial business logics through SQL to get results.
• Ownership of development database.
• Responsibility of handling database space and access related issues.
• Investigating root cause of inefficient queries and working with developers to fix them.
• Ensuring that agreed coding standard and practices followed and adhered.
• Experience of implementing both sparse and snapshot architecture for storing data.
• Implementing normalization to leverage better management and control of data.
• Regularly interacting with business users to understand new requirements and implementing the solutions.

Confidential

Development, Testing and Configuration Management

Environment: : AIX, Teradata, Shell Scripts.

ETL Tools: Teradata BTEQ, FASTLOAD, SQL ASSISTANT, MULTILOAD

Responsibilities:

• Preparation of Technical Specification
• System Analysis and Enhancement
• Used AbInitio, BTEQ, FASTLOAD and MULTILOAD to load data.
• Assisting teammates during development by solving business and technical queries.
• Interacting with clients on regular basis to get clear understanding of business requirement.
• Enhancement and Maintenance of existing process.
• Analysing inefficient queries and tweaking them to run efficiently.
• Ensuring that general coding standards followed to make the code readable and manageable.
• Ensuring that COLLECT STATS done on correct fields and they are refreshed regularly to enable efficient query performance.