Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Hobbies and Interests
Languages
Timeline
Generic

SANDEEP M. YALLAWAR

Hyderabad

Summary

Seasoned IT Project Manager with over 16 years experience, specializing in AWS Databricks, Teradata, and Informatica. Managed complex database environments to enhance performance and security while leading projects and collaborating across teams. Delivered efficient solutions through strategic planning and effective team management.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Project Manager

Wipro Limited
Hyderabad
06.2022 - Current
  • Managed resources and timelines for multiple concurrent projects effectively.
  • Led cross-functional teams to deliver complex technology projects on schedule.
  • Fostered collaboration among 15+ professionals across various tech stacks, enhancing project quality.
  • Facilitated regular status meetings to communicate progress and resolve issues promptly.
  • Implemented process improvements that increased efficiency across technology initiatives.
  • Mentored junior engineers, promoting skill development and team cohesion.

Technical Lead

Wipro Limited
Hyderabad
06.2019 - 05.2022

Lead Admin (Teradata, Informatica, AWS Databricks) :

  • Managing and overseeing various aspects of Databricks clusters and environments.
  • Configuring clusters, monitoring their performance, ensuring security and access controls, and optimizing resource utilization.
  • Responsible for data management tasks, such as setting up data sources, managing storage, and monitoring data pipelines.
  • Collaborating with data engineers, data scientists, and other stakeholders to ensure smooth operations and troubleshooting any issues that arise.
  • Performance optimization to tune clusters for efficiency and reduce costs.
  • Ensure IAM, security groups, and compliance measures.
  • Configuration of VPCs, subnets, and connectivity whenever required.
  • Monitoring of resources, costs and optimize spending's based on analyses
  • Coordination with Databricks and AWS vendors for troubleshooting the issues.
  • Backup monitoring for production database.
  • Abhor Backup and restoration through DSA.
  • Database and table setup as requested by development team in Testing and development environment.
  • Data copy request from production to development database.
  • Database and space Management through Teradata administrator.
  • Implementation of the New Database, including Creating users, Database Objects etc
  • Monitoring Teradata system through viewpoint.
  • Co-ordinating with Teradata GSC team for any database issues through Tabs.
  • User management, roles creation and profile management.
  • Performance monitoring and Query tuning
  • Installing, configuring, maintaining, and monitoring the Informatica PowerCenter

Senior System Engineer

CGI India
Hyderabad
04.2016 - 06.2019
  • Teradata DBA
  • Backup monitoring for production database.
  • Adhoc Backup and restoration through Net vault.
  • Database and table setup as requested by development team in Testing and development environment.
  • Data copy request from production to development database.
  • Viewpoint monitoring.
  • Database and space Management through Teradata administrator.
  • Implementation of the New Database, including Creating users, Database Objects etc
  • Monitoring Teradata system through viewpoint.
  • Co-ordinating with Teradata GSC team for any database issues through tays.
  • User management, roles creation and profile management.

Associate Technical Consultant

Teradata India Pvt. Ltd
Pune
10.2012 - 04.2016
  • Enrolling, Controlling and monitoring users access to the database.
  • Database space audit management.
  • Teradata SQL Assistant to interface with the Teradata database.
  • Use of Teradata Administrator, Teradata SQL Assistant, BTEQ, Viewpoint.
  • Query Monitoring and tuning.
  • Table copy from one server to another server.
  • Database and space Management through Teradata administrator.
  • Implementation of the New Database, including Creating users, Database Objects etc.
  • Handled ETL/MDM processes as a part of Project.
  • Monitoring Teradata system through viewpoint.
  • Monitoring the on-going Production Batch job activities, and keeping a close look on Blockings, delays, Long running jobs consuming lot of CPU and I/O.
  • Monitoring the Space growth for the load jobs and placing the compression on the column values.
  • Co-ordinating with Teradata GSC team for any database issues through tays.
  • Worked on MVC implementation activity.

System Engineer

IBM India Pvt. Ltd
Pune
07.2009 - 10.2012
  • Installation and configuration of 10g Database.
  • Creation of Database through manual and dbca.
  • Creating and maintaining database Users, privileges, roles, and profiles and managing security of database users access.
  • Installed and configured Oracle Enterprise Manager (OEM) in order to provide ongoing, remote database support using the OEM.
  • Regular monitoring of Alert Logs.
  • Creating and managing the Database objects and schemas.
  • Database upgradation.
  • Managing tablespace and users profiles for availability of Database.
  • Monitoring Database Activities, Checking for Tablespaces Availability, Monitoring the Hit Ratios.
  • Assigned Cron Jobs for Backups.
  • Applied patches on Oracle Home using Opatch.
  • Documented the Backup and Recovery procedures.
  • Experience with terabyte databases.
  • Creating, maintaining, restoring on Standby databases.

Education

Masters of Computer Science -

University of Pune
Maharashtra
01.2008

Bachelor of Computer Science -

SRTMU Nanded
Maharashtra
01.2005

Skills

  • AWS Databricks
  • Teradata 1710
  • Informatica PowerCenter 1055
  • Viewpoint
  • Teradata Administrator
  • Net vault
  • DSA
  • Teradata SQL Assistant
  • Informatica PowerCenter
  • AIX 53
  • AIX 61
  • Red Hat Linux
  • Windows 2003
  • Windows 2000
  • Windows 2008

Certification

  • Databricks certified data engineer associate
  • Microsoft Fabric Analytics Engineer associate
  • Teradata Vantage certified Administrator (16.20)
  • ITIL V3 Foundation Certified

Personal Information

Date of Birth: 04/20/84

Hobbies and Interests

  • Sports
  • Music
  • Traveling

Languages

  • English
  • Hindi
  • Marathi
  • Telugu

Timeline

Project Manager

Wipro Limited
06.2022 - Current

Technical Lead

Wipro Limited
06.2019 - 05.2022

Senior System Engineer

CGI India
04.2016 - 06.2019

Associate Technical Consultant

Teradata India Pvt. Ltd
10.2012 - 04.2016

System Engineer

IBM India Pvt. Ltd
07.2009 - 10.2012

Masters of Computer Science -

University of Pune

Bachelor of Computer Science -

SRTMU Nanded
SANDEEP M. YALLAWAR