Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic
SABESH SURESHKUMAR

SABESH SURESHKUMAR

Carrollton,TX

Summary

Over 9+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing and Migration of Data Warehouse development and database adminstration in Telecom and Wireless.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Technical Lead

Mahindra Americas Inc
02.2021 - Current
  • Interacted with business representatives for requirement analysis and to define business and functional specifications.
  • Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification from Teradata and Vertica to Azure Container and Snowflake .
  • Involved in complete SDLC including analysis, design, development, implementation, migration and maintenance of various application code.
  • Involved in migration of Teradata and Vertica data to Snowflake database with Azure Cloud.
  • Designed and developed a process to handle high volumes of data and high volumes of data loading in a given load window or load intervals on Datawarehourse Envrinoment.
  • Worked in Production Support environment for Major / Small / Emergency projects, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Set up batches and sessions to schedule the loads at required frequency and extensively worked on Maestro to schedule the jobs for loading data into the targets through TWS and UC4 tools.
  • Creating the ETL run book and actively participated in all phases of testing.
  • Estimation, Requirement Analysis and Troubleshooting implementation / post implementation issues.
  • Identified project risks and developed solutions and contingency plans to prevent mistakes and delays.
  • Expanded systems with new features and structural components.
  • Devised technology-based solutions to meet range of operational needs.
  • Developed work teams and delegated tasks according to employee strengths.
  • Performed security audits to locate potential threats and identify improvement areas.

Database Administrator

Tech Mahindra Pvt Ltd
Pune, Maharastra
05.2017 - 02.2021
  • Experienced with various heterogeneous sources such as Oracle11g/12c, Oracle R12, Goldengate, Teradata and Flat Files to load the data into the target Oracle data warehouse.
  • Installation, Upgrades, Maintenance and Administration of Oracle 10g, 11g and 12c Databases.
  • Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
  • Reviewed database design to recommend enhancements or improvements.
  • Responsible for creating and efficiently managing large Database and its Application. Perform database tuning and performance monitoring.
  • Oracle RDBMS backup and recovery using RMAN, Datapump and Export/Import Utility.
  • Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privilege.
  • Troubleshoot database issues to create and resolve trouble tickets for connection failures, killing of user sessions, space issues in Temp, Undo and permanent Tablespaces.
  • Support the Application Management team to manage and execute database.
  • Working knowledge of Oracle Golden Gate. Creating Replicat ,Extract as per requirement and mapping schema, table from source to target .
  • Creating GGS trail files, alter trail files and adding trails. Use Logdump. Utility to check Trail files.
  • Part of U2L migration of DB. Generating reports like ASH, AWR, ADDM reports. Part of Automation team to automate the daily activities. Being part of all the deployment activities.
  • Creating and Scheduling Oracle Backend Process Jobs in Crontab.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads.
  • Supported end users in selecting, procuring and using software applications.
  • Developed and implemented security initiatives to protect important company data.
  • Collaborated with stakeholders to gather business requirements for enhancements and change requests.
  • Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.

Software Engineer

Tech Mahindra Pvt Ltd
Pune, Maharastra
02.2014 - 04.2017
  • Provide global, 24x7 operations support to Dataware house and Finance Applications.
  • Troubleshoot minor and major system problems in a timely manner and escalate to L3 support when necessary.
  • Administration of multiple Oracle Databases of CSG’s telecommunication clients.
  • Worked extensively with development teams on query optimization and tuning on Oracle and GoldenGate Database.
  • Extensive experience in Performance Tuning of queries, stored procedures and execution plan optimization.
  • Solve critical production problems well within SLA .
  • Automate Linux/Unix script to monitor the server usage and Job alrerts.
  • Manage team ticket queue and resolve in timely manner.
  • Issue advisories for any outages/incidents which affect the user community.
  • Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
  • Documented technical specifications and project testing methods for future reference.
  • Engaged with user experience designers crafting clean interfaces with simple, intuitive interactions and functions for software package.
  • Introduced automation tools to enhance workflow.
  • Engineered cross-platform software and exported system performance data.

Education

Bachelor of Technology - Electronics and Communication Engineering

Anna University
05.2013

Skills

  • Agile/Scrum Methodology
  • Snowflake ETL Process
  • Unix and Shell Scripting
  • Oracle(11g/12c), Oracle Apps(R1225), Goldengate(11g/12c), MSSQL(2016), Teradata, Vertica
  • Azure, AWS, Oracle cloud ceritifed professional
  • Microsoft Power BI, Microsoft Office, Excel
  • Relational Database Management
  • Performance Analytics
  • Linux Environments

Accomplishments

  • Ace Award (Best Employee of year) - 2019
  • Pat on the Back Award -2021
  • AT&T Client Achievement Award - 2021

Certification

  • AWS Solution Architect | February 2019
  • Oracle Cloud Professional | September 2019
  • Azure Solution Architect | August 2020
  • SAFe 5 Agilist | April 2021
  • Snowflake Essential | 2022

Timeline

Technical Lead

Mahindra Americas Inc
02.2021 - Current

Database Administrator

Tech Mahindra Pvt Ltd
05.2017 - 02.2021

Software Engineer

Tech Mahindra Pvt Ltd
02.2014 - 04.2017

Bachelor of Technology - Electronics and Communication Engineering

Anna University

Similar Profiles

CREATE PROFILE
SABESH SURESHKUMAR