Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

TUSHAR ZAWARE

Wembley

Summary

To be a world-class software professional working with best-in-class organization in the most challenging position that could provide opportunities to learn, grow, contribute and develop by utilizing my professional and technical skills for the development of my team and the organization, one complementing the other.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Snowflake Data Engineer

NTT DATA UK
08.2022 - Current
  • Worked on development of Google Cloud(GCP) to Snowflake Migration Tool
  • Experience conducting Azure & Snowflake architectural reviews for various projects and industries.
  • In-depth knowledge of Azure services and best practices for designing and implementing Azure solutions.
  • Experience reviewing Azure solutions for compliance with industry standards and regulatory requirements.
  • Experience identifying and recommending improvements to Azure architecture, including cost optimization and security enhancements.
  • Experience with Azure monitoring, logging, and alerting using Azure Monitor and Azure Log Analytics.
  • Experience providing feedback and guidance to development teams to ensure adherence to Azure architectural best practices.

Snowflake Developer

Mistral-Data
07.2021 - 07.2022
  • Database Migration - SAP to Snowflake
  • Snowflake Promotion management using Flyway & Liquibase (POC)
  • Hands on experience on creating Multi Cluster Warehouses, Databases, Schemas, Tables, Pipes, File Formats, Stages(Internal & External), Tasks, Streams, Materialized views, Secure views etc
  • Deep understanding of Snowflake architectural components like Storage, Compute, Cloud Services
  • Implemented Column-level Security by creating Dynamic Data Masking feature that uses masking policies to selectively mask plain-text data in table and view columns at query time
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning.
  • Deploying Snowflake features such as data sharing & reader accounts
  • Access & Security Management in Snowflake - Creating Users, Roles , Policies
  • Auto kill Long running queries & Auto assign access using complex stored procedures
  • Well versed with concept like Micro Partitioning , Clustering , Fail Safe & Time travel
  • ETL using Matillion, AWS , Python
  • Matillion Administrator – Setup Matillion instance from AWS, Upgrade , Migrate , Deployment and integration using GIT
  • Organize documentation using Confluence

Cloud Data Engineer

Accenture
06.2015 - 07.2021
  • Database Migration - Teradata to Snowflake
  • ETL using Informatica , Snowpipe & SnowSQL
  • Scheduling using Snowflake tasks
  • Power BI & Excel Reporting on Snowflake DB
  • Performance management – Analyze query profile, snowflake cache, Warehouse capacity, clustering etc
  • Amazon IAM service enabled to grant permissions and resources to users
  • Managed roles and permissions of users with the help of AWS IAM
  • Teradata to AWS Redshift Migration using AWS SCT
  • AWS Backup & Restore - Creating backup plan and perform daily, weekly backup & adhoc restore
  • Developing and orchestrating highly performant, scalable and re-usable data ingestion and transformation pipelines across AWS components and services such as AWS Lambda and AWS Glue
  • Management and Administration of AWS Services CLI , EC2 , VPC , S3 , ELB Glacier, Route 53 , Cloudtrail , IAM , and Trusted Advisor services
  • Built S3 buckets and managed policies for S3 buckets and used
  • S3 bucket and Glacier for storage and backup on AWS
  • Initiating alarms in CloudWatch service for monitoring the server's performance, CPU Utilization , disk usage etc to take recommended actions for better performance
  • Creating required cloud infrastructure using code (e.g Cloud Formation, Terraform) and through use of relevant CLI's
  • Extensively worked on CI/CD pipeline for code deployment by engaging different tools (Git, Jenkins, CodePipeline) in the process right from developer code check-in to Production deployment
  • Familiar with Docker, DBT, Quicksight etc
  • Disaster Recovery Setup using ABU (Appliance Backup Utility), NFS file system.

Teradata DBA

Teradata India Pvt. Ltd
03.2013 - 06.2015
  • Working on 24x7 Support Environment managed by strict Service Level Agreements with time limits for ticket acknowledging, ticket resolution/Escalation
  • Working as a Teradata Production DBA spanning over 34TB of production environment
  • Experience in Teradata Upgrade
  • Hands-on experience in SQL tuning and optimization
  • Viewpoint monitoring (session monitoring, blockings/Long running jobs, locks, system/database health monitoring, database performance, space and node related alerts) and administration
  • Creating Teradata objects like Databases, Users, Profiles, Roles, Tables, etc
  • Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles
  • Carried out statistics analysis for identifying the stale/missing statistics and getting rid of unwanted stats from production tables
  • Handling Planned and Unplanned Outage communication and co-ordination with different teams across client for the duration of downtime
  • Setup Backup & Recovery policies for tapes retention, media management and alerts
  • Continuous checking of DBQL data to look for bad queries, notify the concerned persons/teams and working on query optimization
  • Carrying out Space Management so that there are no failures in
  • ETL batch run or BO reporting failure due to Perm Space issues or Spool Space Issues
  • PDCR management and using PDCR toolkit to extract monthly/weekly/daily/dba reports
  • Recommended and implemented different types of tuning suggestions
  • Creating, managing and coordinating T@YS incidents with
  • Teradata GSC for all high level performance issues
  • Handled number of P1 incidents for Performance project in given critical time with feasible solution.

Software Engineer

Wipro Technologies
12.2010 - 03.2013
  • Experience on Teradata & ETL development as well as production support as having dual role
  • Requirements analysis, system design, development, testing and implementation using Agile Methodology
  • Understanding the business requirements and converting them to technical functionalities and estimation of work
  • ETL development using Informatica Powercenter
  • Database Monitoring using Teradata Viewpoint and ETL job monitoring through Informatica
  • Creating/Modifying/Dropping Teradata objects like Databases,
  • Users, Profiles, Roles, Tables, etc
  • Database & Unix Space Management
  • Hands on experience with Teradata Utilities failures such as BTEQ, Fastload , Multiload, Fastexport, TPT etc
  • Expert in Database backup and restore tools like TARAGUI,
  • Netvault, Netbackup & ABU(Appliance Backup Utility)
  • Collecting statistics and identifying missing statistics
  • Created P1/P2 incident and coordinate with Teradata GSC for resolution
  • Monitoring viewpoint alerts for DB space issues, system performance issues and taking corrective actions
  • Implement incident and change management tickets
  • Managing weekly/monthly/quarterly management call and technical discussions with client.

Education

Master of Science - Computer Science

Pune University
2010

Skills

  • Domain: Healthcare, Retail & Banking
  • OS : Windows , Linux & Unix
  • Database: Snowflake, Teradata, Oracle, Redshift
  • Programming Languages : Shell Scripting , Python
  • Cloud Technologies: AWS, Azure, GCP
  • BI Tools: Power BI, Business Objects
  • ETL Tools: Datastage, BODS, SSIS, Informatica, Matillion
  • DevOps: BitBucket, Jenkins, UDeploy, GIT, CodePipeline
  • Scheduling Tools : CA workstation ESP, Crontab, Control-m

Certification

  • SnowPro Core Certified (Snowflake)
  • Aws Certified Solution Architect
  • Aws Certified Developer Associate
  • Microsoft Certified : AI Fundamentals
  • Microsoft Certified : Azure Fundamentals
  • Teradata Certified Professional
  • EXIN Scrum Master

Timeline

Snowflake Data Engineer

NTT DATA UK
08.2022 - Current

Snowflake Developer

Mistral-Data
07.2021 - 07.2022

Cloud Data Engineer

Accenture
06.2015 - 07.2021

Teradata DBA

Teradata India Pvt. Ltd
03.2013 - 06.2015

Software Engineer

Wipro Technologies
12.2010 - 03.2013

Master of Science - Computer Science

Pune University
TUSHAR ZAWARE