Prabhath Kumar Yerabaty
Senior Data Engineer
Hyderabad
Summary
Worked in building Data warehouses that help in decision making for applications generating $100 million in revenue yearly.
Migrated legacy systems to cloud based systems thereby improving the performance of the systems and also helped in reducing operational costs.
Worked on designing and building OLTP systems in Marketing, Loyalty and EduTech domains.
Built reporting systems for compliance and funding from USA's state education department.
Overview
13
13
years of professional experience
5
5
years of post-secondary education
Work History
Software Engineer III
paypal
hyderabad, Telangana
2021.Sep - Current
- Worked as senior data engineer by building scalable and modular data pipelines that daily process Terabytes of data.
- End-to-end ownership of analysis, design, development and deployment of pipelines using GCP BigQuery, Spark SQL, Data transfer services, DVT, Unix Shell scripting and Python( for data analysis and validations).
- Collaborated with cross functional teams to build Data warehouses and Data marts from enterprise Data lake.
- Successfully migrated old data pipelines from TeraData to BigQuery platform using BigQuery SQL Translation.
- Build encryption/ decryption scripts to handle sensitive data transfer.
- Have setup GPG keys to enable passwordless connection to SFTP servers.
- Improved the existing solutions by reducing average runtime cost by more than 40%
- Provided and implemented solutions to the existing pipelines to improve runtime.
- Worked with product team to present our data offerings for enterprise audience.
- Mentored junior developers.
lead Engineer I
powerschool
07.2020 - 08.2021
- Powerschool SIS (Student Information System) project is the core product for Powerschool systems. It handles the student registration, grading, attendance, transfers etc, for the school districts.
- Designed and implemented automated reposting systems for multiple schools to the respective state authorities.
- Involved in designing and implementing effective alerting systems to identify potential data issues in the existing SIS system.
- Implemented data driven development methodology.
- collaborated with product owners and product managers to review and design the solutions for the requirement of various state authorities.
- implemented automated mail systems to inform the stakeholders of any failures of batch jobs.
- Mentored junior developers
- Worked as the the stakeholder in performing code merges and production releases for my team.
Lead database engineer
Epsilon
06.2016 - 07.2019
- I was leading the database development and design team at Epsilon in implementing the loyalty program for Banking clients like Amex, first national bank of Omaha, Bank of America and aviation customers like Delta airlines
- My responsibilities include Communicate with clients to understand specific system requirements
- Data analysis ETL design and Implementation using PL/SQL and Unix shell scripting Job automation using Crontab Query Tuning Production Support stakeholder management
- Sprint planning code reviews
Associate
cognizant
01.2011 - 06.2016
- I was working as an associate for cognizant as a software developer
- I was handling software development for Healthcare clients using Pro
- C/C, Pl/Sql, Unix shell scripting
- Our projects primarily focused on running retail/Mail order pharmacies.
Education
Diploma in Machine Learning -
Great Lakes Institute of Management
Chennai, Tamilnadu 01.2019 - 11.2019
Bachelor of Science: Computer science and engineering -
KAMALA INSTITUTE OF TECHNOLOGY & SCIENCE
Karimnagar, Telangana 08.2006 - 05.2010
Skills
GCP
undefinedTimeline
Software Engineer III
paypal
2021.Sep - Current
lead Engineer I
powerschool
07.2020 - 08.2021
Diploma in Machine Learning -
Great Lakes Institute of Management
01.2019 - 11.2019
Lead database engineer
Epsilon
06.2016 - 07.2019
Associate
cognizant
01.2011 - 06.2016
Bachelor of Science: Computer science and engineering -
KAMALA INSTITUTE OF TECHNOLOGY & SCIENCE
08.2006 - 05.2010
Similar Profiles
Shaun GarnerShaun Garner
Risk Operations Agent at PayPalRisk Operations Agent at PayPal
MALLIKARJUN NMALLIKARJUN N
Business Analyst at PayPalBusiness Analyst at PayPal
Jagadeesh PamarthiJagadeesh Pamarthi
Senior Data Engineer at PaypalSenior Data Engineer at Paypal
James AbelJames Abel
Head of EMEA Collections (PayPal Site Lead) at PayPalHead of EMEA Collections (PayPal Site Lead) at PayPal
V V V SATYA NAVEENV V V SATYA NAVEEN
SAP Basis Consultant at Tata Consultancy ServicesSAP Basis Consultant at Tata Consultancy Services