Gunvant K.

Gunvant K.

Data & BI Architect,Bigdata,Python,Teradata,ETL,DWH EXPERT,PowerBI,BO,Qlik

Warszawa , Poland

Experience: 13 Years

Gunvant

Warszawa , Poland

Data & BI Architect,Bigdata,Python,Teradata,ETL,DWH EXPERT,PowerBI,BO,Qlik

13 Years

Now you can Instantly Chat with Gunvant!

About Me

12+ years of IT experience as Data & BI Architect / BIG Data Consultant/DBA
Data And BI Architecture and Strategy, TOGAF 9.1, Vision and Road map for BI & Big Data. Tactical and Strategic solutions, Full cycle DWH & BI Solution Implementations...

Show More

Portfolio Projects

Kesko-EDW KESKO Finland (BI-Teradata Project Development)

Company

Kesko-EDW KESKO Finland (BI-Teradata Project Development)

Description

  • Requirement Analysis and Estimation for the Project
  • Design of PDM and implementation from Teradata
  • Translating the logical Model to the Physical Model.
  • Profiling the Data for Column level Compression.
  • Efficient SQL & exposure to query tuning.
  • Developing Stored Procedure/Views for different Layers & suggesting Optimization & Design and Development of Customised Semantic Layer.
  • Extensive expertise in analyzing performance, tuning, working with large volumes of data.
  • Optimizing and re-writing the Teradata queries & Performance Tuning of Semantic Layer

Show More Show Less

Skills

SQL Teradata

Tools

Power BI

BI/ASM Lead Teradata DBA

Company

BI/ASM Lead Teradata DBA

Description

  • Working on different assignments like Skew Analysis, Join index Analysis, stats analysis, PPI analysis, Conducted risk workshop to identify, plan, and mitigate those risks.
  • Analysing System for highly CPU/IO consuming queries and providing concrete solutions, guiding developers for best practices in Teradata.
  • Analysing Performance of System from TASM Perspective, Recommending TASM changes as per the requirement. Performing Monthly TASM analysis and presenting to client.
  • Tweaking TASM Rules/Workload Throttles as per the Requirement
  • Attending Calls with Client along with Weekly Report preparation and analysis
  • Actively involved with P1 issues and providing solutions within the given SLA. Coordinating with GSC for P1 issues.
  • Scheduling Automated Alerts for bad running jobs on the system through Shell script
  • Creating Test and Development environments and granting access/privileges based on requirement.
  • Performing Code review for queries send by development team. Reviewing code for performance issue and to ensure queries are as per coding standard and providing DBA sign-off.
  • Solving ad hoc requests for access rights, query tuning, space management, Lock release etc. as per the user requirement.
  • Performing Data Copy request (Backup and restore) for data movement from one server to another using NetBackup tool, help project Team for environment preparation.
  • Worked on MVC analysis for few production tables for space saving on Production systems.
  • Tracking Capacity requirement before any production implementation and ensuring estimated space availability, in order to ensure smooth loads after production Implementation.
  • Creation and maintenance of new environments, databases, users, roles.
  • User Management (Creating users, assigning profiles, roles depending on user’s specification according to the organizational policies.)
  • Manage and maintain data in production and non-production databases.
  • Manages ticket queues to ensure items such as requests, incidents, and changes are assigned the proper priority.
  • Designing Teradata objects & Application Dba activities (user creation, role creation, profile creation, Performance Tuning, Stats collection).
  • Expert in advanced Teradata concepts like Join strategy, Index choice, Performance Optimization, Compression Having working experience in PDCR
  • Support the application development teams for technical issues. Teradata Upgrades/Migration
  • Coordinating with Customer Data Architect and Data Modeling.

 

Team Management responsibilities:

  • Managing team of Senior Teradata DBA and ETL Developers and Reporting.
  • Representing the CAB for Critical Approval and Priority Issue from Operational Perspective
  • Managing release process from Both Operational and Project Perspective.
  • Decision making and problem solving on wide variety of technological issues.
  • Conducting technical interviews with new hires and performance interviews with team members.

Show More Show Less

Skills

Teradata

Tools

ETL

FDW: Financial Datawarehouse

Company

FDW: Financial Datawarehouse

Description

  • Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, Fast Load.
    Performance & Quality Check Review.
  • Unit Test case preparation, Coding and Unit Testing.
  • Quality check for code and Test Results.
  • Suggesting best practices to ETL developers to improve performance of the code.
  • Involved in writing scripts for loading data to target data Warehouse for Bteq, Fast Load, and MultiLoad.
  • Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.

 

IDA: DWH Market/support and development, Application development, ETL development & Support

PW: Campaign Management & Development for Customer Fund Data

MasterData: DB support and Enhancement

Technologies Used: Teradata 14.10, Datastage, BTEQ, TPT,SAS,FASTLOAD, Teradata SQL, Teradata Stored Procedures, Shell Scripting,ContolM,Crontab,TeradataViewPoint,Oracle PL-SQL,SAS,SAS Studio

Products Used: Teradata DB, Teradata PDCR, Windows Server, Remedy, Jira.

Show More Show Less

Skills

Unit Testing

Tools

ETL

DWH Architect/ Teradata CONSULTANT

Company

DWH Architect/ Teradata CONSULTANT

Description

  • Handling change requests and requirements and support the IT and business Stakeholders
  • Performance Tuning/Developing Optimized Stored Procedure for CDW
  • Proactively DWH Optimization and Architectural Changes
  • Expert with management tools - View Point,TASM,Teradata Studio,TASM
  • Performance Reports on Teradata system & Implementing Optimization  
  • Handling team of 6 People
  • data modeling and ETL modeling

Show More Show Less

SAGE Poland (Product Based)

Company

SAGE Poland (Product Based)

Description

  • Architecting Data Models and  Data Strategy for Sage
  • Application Portfolio Rationalization Exercise across 24 Countries.
  • Leading Joint design sessions with business users and reporting staff for defining DW & ODS Standard
  • Developing  Metadata Strategy, Data Stewardship, Master Data Management (MDM),AWS,Bigdata Hadoop & Advanced Analytics
  • Developing Roadmap standards &procedures, tools & technology for SAGE

Thorough working knowledge of EU data protection legislation (GDPR

Show More Show Less