SUMMARY:

• Having 10 Years of total IT experience in which 10 Years in Teradata Database and 2 Years in Azure cloud services
• Implemented Azure Cloud services for Univision data ware housing projects
• Hands on developing data ingest to data lake process from various source systems (OLTP, FTP, Web log)
• Hands - on AzureCLI Scripting
• Hands-on Azure SQL Data warehouse, Polybase
• Worked on planning and reviewing strategies and calculate effort for Teradata Azure migration
• Worked in collaboration with other Microsoft azure experts to provide recommendation for azure SQL DW migration
• R&D Azure SQL data warehouse comparing Teradata features for Teradata Azure Cloud Migration
• Performed POC and Implemented applications on R Analytics, Spark on HDInsight, Azure SQL data warehouse, Polybase, Azure Data lake, NIFI, KAFKA in collaboration with Enterprise Architecture team
• Expertise in Planning, coordinating, implementation and testing of Teradata upgrade activities
• Involved in Planning, implementation of Application migrations from 6650H to 6700 Hardware
• Performed POC on Teradata New features TD 14,15,16
• Expertise Design and Implement DR using NBU, Tara and UNIX scripting
• Expertise in BAR Operations
• Expertise in automating operation activities
• Expertise in Teradata Physical and Logical data modeling
• Expertise in Viewpoint Administration
• Expertise in Teradata tools and utilities ( TD administrator, SQ Assistant, TSET, TPT, TPump, NBU and TARA )
• Expertise in Error handling and troubleshooting of Teradata load/unload utilities like Fast Load, Multiload, Fast Export, Tpump, Arc/Restore. Working closely with DEV team and assisting them in data modeling.
• Extensive experience monitoring and maintaining a production Teradata environment. Familiar with logging onto the Teradata nodes, running tools from the Supervisor screen.
• Expertise in Physical Designing Databases, Roles, Access rights and Profile as per the SOX standards
• Extensive experience in Performance Monitoring, identifying bottlenecks, error, exception handling tuning of Stored Procedures, T-SQL Queries, Joins, Cursors, long running queries
• Well-versed with Change Management, Service Management, Incident Management,
• Automated the process of identify the security breaches in Teradata environment
• Expertise in Installing and Troubleshooting Teradata client tools.
• Extensive experience working with Teradata incidents through Teradata @ Your Service and the Global Support Center (GSC). Know how to use TSET to send the GSC information they need to analyze problems and create the problem on their in-house Teradata system for analysis and code debugging.
• Expert in Incident management, service outage management, Problem Management.
• Designed and implemented a production Change Control policy and procedures
• Have good knowledge in MSSQL2008/2008R2, SSRS, SSIS, Informatica, Cognos Spotfire, Tableau.
• Hands on ERWN data modeler
• Have good communication skills, a good team player and good understanding of client requirements.

TECHNICAL SKILLS:

Platforms: Windows NT/2000/XP/2003, Linux-REDHAT 2.6.7 & SLES 9/10/11.

Programming: C, C++, Unix Shell Scripting, Python, Java, R, Scala

Database: Teradata V2R6/V12/V13.0/V14.0/V14.10, MSSQL Server 2008/2008R2

Hadoop Ecosystem: Hadoop, Data lake, HDFS, Hive, SPARK, NIFI, Hbase, Java, Python, Scala

BI/ETL Tools: Informatica, SSIS, SSRS, Tableau, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Database Architect

Responsibilities:

• Design and Implement Disaster Recovery Work Flow using NBU, TARA and UNIX Scripting
• Assist other ETS Members such as ETL, BI and Oracle Apps/BO (Financial Reporting)
• POC, Design and implement compression techniques to reduce storage cost and improve performance
• Hardening Teradata database design and implement Roles, Access Rights as per the SOX standards
• Design and configure TASM
• Automated sever Operational Activities.
• Accomplished Teradata Upgrades 14.10, 15.10 during 3years
• Implemented 100+ enhancements
• Perform system level and database level performance tuning
• Leveraged SYSLIB functions to use default Teradata functions
• Performed POC on Teradata New features (temporal, columnar, geospatial, JSON)
• Re-architect Complex SP for Finance application to support Realtime time and consistent reporting
• Created 100+ Teradata Infrastructure and Application documents for SOP
• Modify & Update Data models and STTM documents for new enhancements.
• Created Customized Teradata platform reports for Weekly meeting with Management
• Create Custom PDCR reports for weekly Management Meetings
• Design Teradata scripts and objects Version control using SVN, Python Teradata modules
• POC on Azure SQL data warehouse using polybase and Azure blob storage
• Work with GSC on Teradata Incidents
• Played key role in designing Big data initiatives in Univision
• Understanding the data nature from different OLTP systems and designing the injection processes for HDFS
• Developed data ingest to data lake process from various source systems (OLTP, FTP, Web log)
• Involved in Implementing Consumer data hub on Azure SQL DW for Univision digital media campaign project leveraging Polybase, Data factory and azure blob storage
• Designed data model on Hive for FIS (Univision Prepaid cards data)
• Involved in designing solutions and calculating effort for datacenter migration, public/hybrid Cloud migration and azure cloud migration
• Create and review strategy and calculate effort estimate for Teradata cloud and Teradata Azure cloud migration
• Performed POC for latest Azure cloud-based Storage services (Structured, Unstructured) and securing storage
• Automated Azure CLI scripts creating azure services (database, backups, re-creating database, DR)

Confidential - NC

SR Teradata DBA

Responsibilities:

• 24X7 support for TERADATA Platform
• Provide Production support 24X7 to applications and supporting technologies
• Worked on Configuring IBM Gaurdiam as part of TD migration to 14.10
• Worked with TD GSC to Re-Architecture Existing Archive and Restore jobs
• Monitor and Admin DR as part of admin Archives and Restore
• Perform DB copies from higher to lower Env using Data mover
• Monitor Workloads and make changes to TASM as required
• As part of daily activities worked on Service now requests and Incidents as per the application team requirements.
• As part of weekly and monthly activities worked on PDCR and CCPT reports and coordinate with application teams under the guidance of Teradata Management.
• Automated few of the daily tasks like release locks, load table recovery, unlock user accts etc. as per SN request raised by application teams.
• Perform system level and database level performance tuning as part of SN incident analysis.

Confidential, NJ

SR Teradata DBA/Hadoop Admin

Responsibilities:

• 24x7 Support for TERADATA Platform engineering and operations
• Accomplished Teradata Upgrade from
• Accomplished Teradata Upgrade from 14 to14.10
• Accomplished Application migrations from 6650H to 6700 Hardware
• Accomplished Teradata viewpoint upgrade to Teradata 15.0
• Re-Architecture Users, Roles and Access rights during Teradata server upgrade
• Install all the client Teradata tools on Teradata platform and other reporting Platforms.
• Automated various jobs related to DBA activity APT, Application Database setup, Users set.
• PDCR data and create customized performance reports as per management requirement
• Perform System level and Database level performance tuning.
• Perform backups, restore and monitor jobs as per application team requirements.
• Involved in taking care of day-to-day needs for the Development team with in the specified SLA and also taking care of the ad-hoc requests.
• Reviewing the DDL/DML before it goes into TEST/PROD. Discuss/Review with the DEV team from the initial stages of the design, data model and understanding the business needs in order to choose the Indexes and other Architect things that need to be taken care and provide the recommendations in the CAB
• Performance Monitoring/Tuning using tools such Viewpoint, TASM, TD Administrator, TDWM, PMON, DBQL and other TD tools.
• Monitor and Manage Archive and Restore jobs using Net backup and TARAGUI
• Worked in collaboration with Hortonworks and cloudera on POC and implementation of Hadoop ecosystem
• Developed tools and utilities to administer Hadoop jobs, manage queues and monitor performance
• Formulated procedures for installation of Hadoop patches, updates and version upgrades
• Created loading processes using sqoop and Teradata connecters to load data in to Hadoop

Confidential, Parsippany NJ

SR Teradata DBA

Responsibilities:

• 24X7 Production Server Support for TERADATA and MS SQLSERVER
• Provide 24X7 on-call support to the enterprise Data Warehouse. Handle database restarts, release database utility locks, analyze spool issues, and Manage space issues.
• Monitoring workloads, creating workloads and analyzing workloads using Teradata analyst package and monitoring workloads using Teradata Viewpoint
• Performance Tuning, Indexing, collecting and refreshing statistics and Implement TASM changes and maintaining access rights and role rights
• Managing change management, understanding the business requirement, reviewing code change, approve it and deploy to production as per request submitted by developers
• Create, schedule, manage and troubleshoot ETL jobs as requested by ETL Team.
• Review and deploy reports and created customized scripts to monitor failed reports (SSRS)
• Designed and Implement Database Archives and Restore process for disaster recovery using NetBackup
• Involved in designing and recommending workload definitions, Resource partition allocation group and scheduling the priorities as per business needs.
• Participated in Teradata Upgrades and patching (T12 to T13 and TTU 12 to TT13)
• Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of ResUsage, Amp Usage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different complicated and technical issues.

Confidential, NJ

Teradata Application Support

Responsibilities:

• Created Fast load, Multiload, and Fast Export SQL scripts for data Extraction,
• Transformation and Loading (ETL) from other primary and legacy database systems.
• Created scripts to convert data from different data sources to Teradata and check for data quality by cleansing and filtering data.
• Created SQL scripts to transform and update data.
• Worked closely with DBAs to transition logical models to physical implementation.
• Supported daily extraction, staging and load processes
• Performance tuning, monitoring and index selection while using PMON, Teradata
• Supporting Dev environment in Physical designing of databases in the point performance, data integrity, security and space management by creating
• Proper Indexes PI, SI, PPI, JI,
• Analyze the data structure for RI implementation
• Analyze the data and implement MVC
• Data obfuscation
• Modification of views on Databases, Performance Tuning and Workload Management.
• Performance tuning, monitoring and index selection while using PMON, Teradata Dashboard, Statistics wizard and Index wizard and Teradata Visual Explain to see the flow of SQL queries in the form of Icons to make the join plans more effective and fast