Data Developer

ANAND TAKALE

Contact – *******@*****.*** / +1-415-***-****

Professional Summary

A Techno-Functional Consultant with over 17 years of experience in delivering data warehouse solutions and support to global corporations spread across Insurance, Banking, Telecom, Retail and Pharmaceutical industry

Associated with some of the industry leaders like Nationwide, AT&T/DIRECTV, Levi’s, Barclays Bank-UK, Lloyds Bank-UK, British Telecom-UK, TESCO-UK, Telstra-Australia, Cisco-USA, Glaxo SmithKilne-USA, Bell-Canada, Daimler-Germany in the capacity of Teradata DBA, Applications Architect, Designer and Developer

As a Database Specialist / DBA, have been responsible for but not limited to Monitoring, Performance Analysis & Engineering, Maintenance/Upgrades, User Support, Capacity Planning, Database Performance Monitoring, Indexing, Partitioning & compression Strategy, Backup and Recovery, Golden Gate for Data Replication from Oracle to Teradata, Guide the data modeling teams on Logical & Physical Data Modeling, Creation of various Database reports for Bad SQL, Space and CPU usage, table growth and skewness information, PDCR, DBQL, project code reviews, logon off data and illegal logon information and query duration reports, TAYS - Teradata At Your Service, Support Teradata GSC team during fixes, upgrades, Access Control & Securities Administration

As an Application Architect, has been responsible for Application System Architecture Design and Review, Performance Engineering, Code Effectives and Standards Review, Data Modeling tool Erwin to Perform logical and physical data modeling, Data Analysis, Profiling, Data Cleaning, ETL Mapping, Designing Semantic views and Business views.

As Designer and Developer, responsible for Data Integration; High Level Design, Low Level Design, ETL Mapping, Coding and Testing Teradata BTEQ, MLOAD, FastLoad, Fast Export scripts along with JCL, Informatica/ODI ETL tools. Migration from DB2 and Oracle to Teradata.

Extensive experience on Teradata platform spreading across tools and utilities such as MLOAD, FLOAD, BTEQ, FEXPORT, Stored Procedures, Macros, Teradata Administrator, View-Point, Teradata Active System Management (TASM)TSET, SQL Assistant, Ferret, Pack disk, Check Table, Update Space, etc.

Indexes, Locks, Space Mgmt., Compression

Experience on BAR using Symantec NetBackup with TARA as Client

Unity Data Mover to move objects from between systems

Experience in SQL Query Tuning, Capacity Planning, Database Performance Monitoring

Design and implementation of various data integration solutions for data warehouse and data mart systems.

Teradata Viewpoint – Monitor various resources

TASM exposure in analyzing the existing workloads using Teradata workload analyzer, designing, adjusting & monitoring the workloads using Workload Designer and Workload Monitor port lets.

Establish ETL/Data standards and templates to improve quality and integrity of data.

Automation Administrative & ETL processes

Proficient in Windows/Linux/Unix environments

Sqoop - Load Teradata tables into HDFS

Access HDFS data using Hive

Exposure on Netezza, Query-Grid, PRESTO

Trained and Basic Experience: Big Data Ecosystems - Hadoop, HDFS, HBase, Hive, Pig, Sqoop, Flume, Zookeeper, Oozie, Hue, Kafka.

Education

B.E - Bachelor in Computer Science and Engineering, Karnataka University, India.

Professional Experience

Nationwide, Columbus, OH Nov 2017 – present

(Employer : Fast Switch Ltd)

ETL process - Teradata-Informatica-Oracle-Unix

ETL process - Teradata-Mainframe JCL(Legacy Applicatoins)

Teradata ETL using MLOAD, FLOAD, BTEQ, FEXPORT

Performance Tuning of bad queries

Teradata V16.20, Informatica V10.2, Oracle V12.1

CA ESP schedule creation and promotion

Code deployment using UCD and Jenkin

Splunk to monitor Application logs

Applications – Policy Center, Claims, Quote System, Scoring, IBM IIB, Platform Locator

Manage various applications monthly infra activities, created automated unix tool to generate system configuration for Application servers.

ServiceNow; Incident/Change/Problem Management.

DirecTV/AT&T, Los Angeles, CA April 2017 – Nov 2017

(Employer : Kiranam Technologies)

Teradata DBA

Supporting Migration from Direct TV system to AT&T system

Teradata system monitoring through Viewpoint.

Supporting 4 environments, PROD, DR, QA and DEV

Handling of 2 6750 8 node systems

Handling of 2 Appliance systems (2700 and 2750)

Teradata V15.00 and SUSE Linux v11 versions

Expertise in using Teradata Tools and Utilities (SQL Assistant, TD Administrator, BTEQ, Fast load, Multi-load, TPUMP and TPT etc.).

Data migration/copy between PROD to DEV /Test using Data Mover

User and Database creation, maintaining proper access rights through roles and profiles.

Release Management/Deployments

SQL Code Review with BI application teams

Performance tuning for ETL and Reporting queries

Expertise in using PDCR and DBQL data for query analysis.

Support and co-ordination during Hardware and patch upgrades.

Expertise in setting up alerts through viewpoint for CPU, IO and disk space related.

BAR operations using Netbackup TARA GUI

Data Mover to copy objects between systems

Good exposure in using Oracle Golden Gate for Real-Time Data Integration

Monitoring the data loading logs and debugging the issues in Golden Gate application source and target system (Oracle to Teradata)

Monitor the replicates and resolve the GG issues

Complete setup of new replicates for new tables setup at target side

Change and Incident management process

Load tables into HDFS and Access using Hive.

Expertise in scheduling and monitoring jobs through CA Autosys scheduler

Levi’s and Straus, Dallas, USA Apr 2016 – Apr-2017

(Employer: Wipro Ltd.)

Teradata DBA / ETL Developer

Supporting Levi’s EDW is running on Teradata 13.10

Supporting 5000 users running reports from Business Objects.

Total capacity is 90TB, Current data size 50TB. Average monthly growth is about 250GB. Backup and Archive using NetBackup with TARA as client.

Capacity Planning and Space (Permanent Space Spool Space and Temp Space) Management;

Data Archrivals, and Recovery/Restore; Systems Maintenance, Compression, Blocking, Performance Monitoring & Security control; Users, Roles, Profiles and Accounts Management; Performance Tuning

Weekly/Monthly generating DBA reports. Interacting with Teradata GSC team (TAYS) during upgrades/fixes.

Manage and Supporting Application Batch & Backup jobs and take appropriate actions.

Automating the business processes/scripts which reduced the daily/Weekly process timelines.

Minor/new enhancement; Design, Coding using Teradata scripts and Testing.

ServiceNow; Incident/Change/Problem Management.

Daimler, India Jul 2015 – Mar 2016

(Employer : Wipro Ltd)

Teradata DBA

Capacity Planning and Space (Permanent Space, Spool Space and Temp Space) Management;

Data Archrivals, and Recovery/Restore; Systems Maintenance

DBQL and Access Logging, Performance Monitoring

Security control; Users, Roles, Profiles and Accounts Management

Viewpoint Alerts, TASM, Applications Design Review

Performance Tuning; Incident/Change/Problem Management.

Weekly/Monthly generating reports from DBQL

Lloyd’s Banking-UK (India) Oct 2013 – Jul 2015

(Employer : Wipro Ltd)

Teradata DBA

Capacity Planning and Space (Permanent Space, Spool Space and Temp Space) Management; Data Archrivals, and Recovery/Restore; Systems Maintenance

DBQL and Access Logging, Performance Monitoring & Security control; Users, Roles, Profiles and Accounts Management

Applications Design Review; Performance Tuning; Incident/Change/Problem Management. Query performance tuning

System monitoring using Viewpoint

Implemented the Multi-Value Compression, PI, SI, JI, PPI for optimal usage of space and improved I/O reads

System utilities such as Ferret, Pack disk, Check Table, Update Space

Bell-Canada, India Jan 2012 – Aug 2013

(Employer : Tech Mahindra)

Teradata DBA / Developer

Create and Maintain Teradata Databases, Tables, Views, Macros and Stored Procedures. Create Profile, Role, User, establish roles and security Engineering. Performance tuning for bad queries

Analyzed data and implemented the Multi-value Compression, PI, SI, JI, PPI for optimal usage of space and improved I/O reads. Application Development and Production support.

Teradata Coding using MLOAD, FLOAD, BTEQ, FEXPORT with effective Joins. Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.

Worked with project team to ensure implementation of the databases for the physical data models intended for the DataMart.

Generate reports for high consuming CPU jobs/users and recommend query changes to reduce the CPU usage/space

Tech Mahindra/Mahindra British Telecom (India/US/UK)

Aug 2002 – Dec 2011

Teradata Data Architect, Data Modular (Teradata FSLDM), Designer, Developer and IBM Mainframe Development.

Tools/Utilities:

SQL Assistant, Teradata Administrator, PMON, BTEQ, FastLoad, MultiLoad, FastExport, Erwin, Informatica, ODI(SUNOPSIS), FSLDM, BusinessObjects XI-3.1 Designer, BO Infoview, Mainframe JCL, File-aid, VSAM, SDF, Xpediter, TSO/ISPF, Endevor, SPUFI, QMF, Abend-Aid, JHS, CA-Workstation, Splunk, IBM-UCD, Jenkin, IBM-IIB 10, Policy Center, Platinum, $U(Scheduler), Netezza, Oracle, DB2, IDMS, HP Quality Center

Responsibilities:

Teradata Development using Multiload, FastLoad, Bteq, FastEXPORT scripts

ETL using Informatica / ODI

Erwin to Perform logical and physical data modeling

Data Analysis, Profiling, Data Cleaning, ETL Mapping, designing Semantic views and Business views

Experience is producing High & Low-level design documents

Tableau, Business Object Universe Design and Report Design

Mainframe development using MVS, JCL, DB2, VSAM, COBOL, CICS

Contact this candidate