Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

SRINIVASA REDDY PENTHALI

Hyderabad

Summary

Results-driven Data Engineer known for high productivity and efficient task completion. Skilled in big data processing frameworks like Apache Spark, database management using SQL. Excel in problem-solving, collaboration, and adaptability to leverage technical skills in developing innovative data solutions across diverse environments. A proven track record of working in a fast-paced environment.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Data Engineer

Tech Mahindra
12.2022 - Current
  • Service NAB (Service Now) is NAB’s Enterprise Service Management Platform, underpinning incident, problem, change and related processes, comprising base platform, CMDB and related components
  • This is comprised of the base platform; IT Service Management (ITSM) including Incident, Problem, Change, Configuration Management and related processes; IT Operations Management (ITOM) discovery management, and related components
  • The Purpose of this project Service NAB is to add data from a new source system to the existing data warehouse
  • Performing data profiling across multiple data repositories
  • Unpacking existing data-pipe line logic and creating source to target mapping documents
  • Performing impact analysis of value-added changes
  • Closely working with data-design teams and developing pipelines
  • Performing Unit testing, SIT and other documentation
  • Environment: Databricks, Python, SQL, GitHub, Jenkins, Rally

Developer / Environment Support Analyst

Tata Consultancy Services
06.2016 - 11.2022
  • Global Investment and Financial Services team is responsible for configuration Management of each individual application has been turned over to the SI team who owns that application, we still exist to provide the support of the Ansible workflow utilized by our clients
  • We support the Ansible playbooks and processes used for configuring and deploying Java Batch, TC Server/Apache, TIBCO, Data stage, WAS8, XI50 and Payload applications to the legacy (non-AWS) on-prem Linux environment
  • Provisioning the web, UI and batch applications using the Ansible playbooks
  • Ansible playbook/role maintenance, including enhancements to support new requirements from SI teams
  • Inventory updates (if a client makes their own inventory updates, we are responsible for reviewing their PR, merging once approved and syncing in tower)
  • Troubleshooting deployment failures
  • Consulting in support of SI team’s config updates
  • New application setup - if/when a new NGSA application is created by an SI team, GIFS environment team is responsible for completing the link steps to setup the application for Ansible deployment
  • Retiring applications
  • Bit bucket project/repo ownership and PR review
  • GIFS environment is responsible for owing, maintaining, supporting the contents of and reviewing PRs for the projects/repos described under special bit bucket and admin configuration
  • Responsible in AMI monthly rehydration process
  • Environment: DevOps, Ansible, Bitbucket, Git, Jira, AWS, Confluence, Nexus, Putty/No-Machine, Service-Now, Unix, Python and Shell Scripting

Database Developer

Tata Consultancy Services
05.2015 - 04.2016
  • The Volcker Rule designed to prohibit a bank or institution that owns a bank from engaging in proprietary trading that is not at the behest of its clients, from owning or investing in a hedge fund or private equity fund, and limits the liabilities that the largest banks can hold
  • Preparing SQL aggregate scripts and modifying existing aggregate scripts as per business requirement
  • Developing DB Objects like Materialized View, Views, and Tables and associated objects like Indexes and Triggers
  • Working in DPF Environment
  • Create New Tables and give index & partitions
  • Preparing DML & DDL Statements
  • Database Performance Tuning (Explain Plan)
  • Run stats / Reorg Utility
  • Developed Automation scripts
  • Db2 Utilities (load/export/import)
  • Environment: IBM DB2 LUW, SQL, UNIX, Python, Shell Scripting, Perl, AutoSys, Saturn, Perforce

Senior Software Engineer

Artech Info Systems Pvt Ltd
04.2013 - 12.2014
  • IDEA Cellular Limited-BI includes Setting up advanced analytics eco-system for Idea
  • Identifying the business problems & conceptualizing the analytical support area
  • Developing go-to-market strategies based on analytical findings
  • Setting up the evaluation criteria for the program results and adapting plans accordingly
  • Maintaining high-level understanding and competency in statistical and analytical principles, tools and advanced techniques
  • Preparing SQL aggregate scripts and modifying existing aggregate scripts as per business requirement
  • Extensively worked in the performance tuning process
  • Working in DPF Environment
  • Create New Tables and give index & partitions
  • Preparing DML & DDL Statements
  • Database Performance Tuning (Explain Plan)
  • Run stats / Reorg Utility
  • Developed Automation scripts
  • Db2 Utilities (load/export/import)
  • Knowledge in UNIX Shell Scripting (FTP, SFTP Pairing)
  • Preparing Implementation Plan (low level document) and check lists
  • Unit test of new aggregates in Development environment
  • Working with BMC Remedy Ticketing tool for project change request
  • Using Repository tool clear case for project document
  • Working with Development & Production environments
  • Creating users using Tivoli identity manager
  • Environment: Informatica Power Center 9.X, IBM DB2, UNIX, Shell Scripting, Clear Case, Sql Dbx, Tivoli Manager, BMC Remedy

Database Developer

Navayuga InfoTech Pvt Ltd
10.2010 - 04.2013
  • The focus of the project shall be on actual, demonstrable performance in terms of sustained loss reduction
  • Establishment of reliable and automated systems for sustained collection of accurate base line data, and the adoption of Information Technology in the areas of energy accounting will be essential before taking up the regular distribution strengthening projects
  • The environment is DB2 100+ users on Windows 2008 Server
  • Ability to use export/import, DB2move, Load utility
  • DB2 node directory / catalogue configuration
  • Good experience in DB design
  • Database performance tuning DB2explain utilities
  • Installing DB2 9.5 Windows 2008 Server & Creation of New Databases
  • Managing Users, Roles & User Profiles
  • Different Backup strategies: Daily Backups & schedule Backups and restoration using Task Center
  • Creating tables, views, triggers, store procedures, cursors, indexes, schemas& Managing Table spaces for availability of database
  • DB Objects migration thru different loaders
  • Usage of database catalogs, Space management
  • Involved in Unit Testing and Production Deployment
  • Environment: IBM DB2 LUW, SQL, SQL PL, UNIX, Basic Shell Scripting

Database Developer

Navayuga InfoTech Pvt Ltd
10.2010 - 04.2013
  • The focus of the project shall be on actual, demonstrable performance in terms of sustained loss reduction
  • Establishment of reliable and automated systems for sustained collection of accurate base line data, and the adoption of Information Technology in the areas of energy accounting will be essential before taking up the regular distribution strengthening projects
  • The environment is DB2 and DB2 Database, 100+ users on Windows 2008 Server
  • Ability to use export/import, DB2move, Load utility
  • Database performance tuning DB2explain utilities
  • Installing DB2 9.5 Windows 2008 Server & Creation of New Databases
  • Managing Users, Roles & User Profiles
  • Different Backup strategies: Daily Backups & schedule Backups and restoration using Task Center
  • Creating tables, views, triggers, store procedures, cursors, indexes, schemas& Managing Table spaces for availability of database
  • Usage of database catalogs, Space management
  • Involved in Unit Testing and Production Deployment
  • Environment: IBM DB2 LUW, SQL, SQL PL, UNIX, Basic Shell Scripting

Test Engineer

Innowe Software Solutions Pvt Ltd
05.2010 - 09.2010
  • The focus of the project shall be on actual, demonstrable performance in terms of sustained loss reduction
  • Establishment of reliable and automated systems for sustained collection of accurate base line data, and the adoption of Information Technology in the areas of energy accounting will be essential before taking up the regular distribution strengthening projects
  • Installing Oracle 11g on Windows 2008 Server & Creation of New Databases
  • Managing Users, Roles & User Profiles
  • Creating tables, views, and indexes
  • Creating users & privileges with appropriate roles and levels of security
  • Creating stored procedures and functions
  • Uploading shape file into database, spatial indexes on geometry
  • Implemented Backup strategy
  • Performing Logical backups using Export utility and restoring specific object or schema using Import utility
  • Exporting and importing databases and data loading in tables using SQL Loader
  • Backup of the Production & Development Database
  • Environment: IBM DB2 LUW, SQL, SQL PL, UNIX, Basic Shell Scripting

Education

Master of Computer applications -

Jawaharlal Nehru Technological University
Andhra Pradesh

Skills

  • IBM DB2
  • Oracle
  • SQL Server
  • SQL
  • SQL PL
  • UNIX
  • Shell Scripting
  • DevOps
  • Ansible
  • Data Warehousing
  • SQL and Databases
  • Bitbucket
  • Git
  • GitHub
  • Jira
  • AWS
  • Confluence
  • Putty/No-Machine
  • Informatica Power Center
  • Databricks
  • Python
  • Windows
  • Linux

Certification

  • Databricks Certified Data Engineer Associate
  • Certified AWS Cloud Practitioner

Timeline

Data Engineer

Tech Mahindra
12.2022 - Current

Developer / Environment Support Analyst

Tata Consultancy Services
06.2016 - 11.2022

Database Developer

Tata Consultancy Services
05.2015 - 04.2016

Senior Software Engineer

Artech Info Systems Pvt Ltd
04.2013 - 12.2014

Database Developer

Navayuga InfoTech Pvt Ltd
10.2010 - 04.2013

Database Developer

Navayuga InfoTech Pvt Ltd
10.2010 - 04.2013

Test Engineer

Innowe Software Solutions Pvt Ltd
05.2010 - 09.2010

Master of Computer applications -

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
SRINIVASA REDDY PENTHALI