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...
Skills
Portfolio Projects
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 LessDescription
- 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
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
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.
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