Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sumathi Gottipati

Seattle,WA

Summary

Results-driven Software Engineer with over 8+ years of experience in building and maintaining web applications. Demonstrated success in improving application performance by 20% through code optimization techniques. Proficient in Python, Perl, and SQL, with expertise in system monitoring, log analysis, and debugging using AWS CloudWatch. Skilled in developing automated scripts and dashboards to enhance visibility and operational efficiency. Seeking to leverage my technical skills in a dynamic and fast-paced development environment.

Overview

9
9
years of professional experience

Work History

Software Engineer

Amazon
08.2022 - Current
  • Designed and developed a server root file system check using Python and shell commands to monitor various partitions, including the root file system. Configured monitors by analyzing data and proposing thresholds, which reduced system downtime by 20% through early issue detection and alerts.
  • Developed and maintained Python and shell scripts for cross-platform system monitoring, reducing issue detection time by 30%.
  • Designed zonal dashboards to enhance application behavior monitoring, increasing visibility and operational efficiency
  • Developed Python scripts to consolidate checks into a single dashboard, improving visibility and streamlining operations, which led to significant time savings.
  • Developed a Python script utilizing the Time::HiRes and POSIX modules to emit and monitor system performance metrics, integrated with custom dashboards for real-time insights and analysis.
  • Implemented monitors using internal LPTs, generating alarms for efficient release monitoring, reducing engineers' time on releases by 35%


Data Engineer

L&T
01.2019 - 01.2021
  • Analysis of the Technical Specification Design document with Business Analyst, Gathering ETL requirement and design the requirement specification
  • Developed and Implemented extraction, transformation and loading the data from the legacy systems using Ab Initio
  • Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts
  • Create various Ab initio Multi File Systems (MFS) to run graphs in parallel which Increased the performance by 25%
  • Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates
  • Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects
  • Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs/Scripts
  • End to End testing of the flow in defect fixing and coordinating

Software Developer

IBM India Pvt Limited
08.2015 - 01.2019
  • Developed and modified SQL and PL/SQL code to make new enhancements or resolve problems, as per customer requirements
  • Design user defined integrity triggers to maintain the security and validity of data between users
  • Responsible for loading huge datasets and performed Bulk loading operations on Database level
  • Responsible for doing partitioning the table using database partitioning techniques (Hash/Range/List)
  • Used Bulk collect and cursors for fast processing and Bulk binding for all concepts to avoid the context switching
  • Developing the shell scripts for populating the aggregates using plsql code
  • Handled multi-dimensional and large fact tables joining used data warehouse techniques for the retrieval of data
  • Dealed with various dimensional schemas and tables like slowly changing/static/dynamic dimensional and type1/2/3/4 tables

Education

Master - computer Science and Engineering

Wright State University
Dayton, OH
07-2022

Skills

  • Python
  • Perl
  • SQL
  • PL/SQL
  • Ruby
  • Unix Shell Scripting
  • AWS CloudWatch
  • Ab Initio
  • AutoSys
  • DB2
  • Oracle
  • MySQL
  • EME/Sandbox
  • GIT
  • SVN

Timeline

Software Engineer

Amazon
08.2022 - Current

Data Engineer

L&T
01.2019 - 01.2021

Software Developer

IBM India Pvt Limited
08.2015 - 01.2019

Master - computer Science and Engineering

Wright State University
Sumathi Gottipati