Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Prudhvi Reddy

BENGALURU

Summary

Experienced Data Engineer with 6+ years of experience in all aspects of software development(Data Engineering) life cycle, including requirement gathering,implementation,Testing,Maintenance and Development.

Overview

7
7
years of professional experience

Work History

Senior Consultant

Capgemini
07.2022 - Current

•Worked on PNR Module of Air-france Project in the process of migration to GCP environment and loading the data into Big-Query with the tech stack being used as python in cloud function, airflow in cloud composer and with pub-sub to send the data as an event with metadata information to big-query.

• Testing the solution to analyze the processing speed of pub-sub in loading the data to big-query.
• Development of scripts based on python for cloud run,dataflow,cloud composer and related services.
• Setting up the GCP environment with the necessary IAM permissions to access specific functionalities in GCP
• Resolution of issues related to python and fixing the issues to process the data.

Data Engineer

Ford Motors
05.2021 - 07.2022
  • Performed large-scale data conversions, transferring hive data into standardized GCP formats for integration into Google cloud platform.
  • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
  • Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.
  • Involved in the migration of jobs and data from Cloudera to Google Cloud Platform.
  • Designed and developed Big-Query and scala scripts and analytical data structures.
  • Tested and validated models for accuracy of predictions in outcomes of interest.
  • Created YAML Scripts for the automation of workflow jobs in GCP and created Dependency between jobs.
  • Worked on the GCP components that includes Creating and solving issues with Clusters,Creation of buckets and storing the scripts and data with in,solving issues related to service accounts.

Software Engineer

Amdocs Development Center, AT&T Communications
10.2019 - 05.2021
  • Working as a part of Amdocs Data Intelligence Team
  • As a part of VFIT ,worked as a part of the Developing team .Involved in all the development activities both the Data warehouse level and source system level
  • As a part of testing keenly involved testing the user stories resolved issues related to defects in software development with technologies being used are hive at source system level and teradata at Data warehouse level and fixing issues before prod migration.
  • As a part of AT&T (EDM-Project) worked as a part of the development team helping team in solutions with java applications based on JSON parsing and Kafka
  • Investigate issues by reviewing/debugging code, provides fixes and workarounds, and reviews changes for operability to maintain existing software solutions
  • Technologies being used are
  • Java and Vertica
  • As a part of AT&T(Sunrise-Project) worked as a part of the sustainment team with technologies being used are teradata and unix
  • Involved in solving issues in daily run Business as usual scripts and building One-time scripts for correcting historical data.
  • Involved in finding out the sensitive potential information related to clients in databases and developed a code to find out the early detection of potential data to make necessary actions before mis-using.

Software Engineer

Robert Bosch Engineering And Business Solutions
05.2018 - 03.2019
  • Information Management and Analysis Responsibilities
  • Extracted data and built a logic for dashboard which provides sales related information
  • Gathered the requirements for design and development of the database and building the solutions
  • Implemented back end scripts in python and sql for the generation of reports to the Business users
  • Fixing the issues in ETL applications, developing ETL Jobs as per client requirements scheduling for the developed automation scripts for the efficient delivery of solution
  • Implement the automation in the application for finding out the potential customers
  • Implemented the scripts in Python for analysis of the products generating the graphs using matplotlib,pandas etc
  • Improving the sales of Automotive OEMS by providing the meaning full information with BI application as interface

Software Engineer

IQVIA
10.2017 - 05.2018
  • Design and Development of ETL
  • Working with the Big Data Tools as a part of C.D.H (Commercial data hub) process for data processing at source level
  • Cleansing the data-sets related to Pharma clients on H.D.F.S clusters using Qubole as interface using hive queries
  • Quality check on the data after the completion of each E.T.L step to check for the consistency of Data
  • Creating a complete solution by integrating a variety of programming languages & tools together
  • Setting up the Reltio Cloud Environment with necessary constraints as per the change requirements from the clients
  • Responsible for solving production issues for timely delivery of data
  • Indexing the records and testing the data in reltio using Postman with Get and Post Operations
  • Description
  • As part of BIG Data Management Team I was responsible for delivering data to clients as it is a health based company we do work for pharmaceutical companies which includes VALENT, ABBVIE and Allergan
  • Technologies being used for projects are SQL, HIVE, Big data Environment which includes RELTIO, HADOOP clusters like QUBOLE and INFORMATICA as E.T.L tool Having working knowledge of CSV files, J-SON files, POSTMAN Software and Unix-commands
  • Resolution of bugs and interacted with the team to resolve issues.

Education

Master's in Software Engineering - Computer Science

Vellore Institute of Technology
Vellore, India
05.2017

NARAYANA JUNIOR COLLEGE - 91.2%
Nellore, AP
05.2012

NETHAJI HIGH SCHOOL - 86%
03.2010

Skills

  • ETL AND DATABASES
  • Teradata ,SQL,PL-SQL (Procedures ,Functions and Triggers),Informatica Power Center ,Hive and Vertica
  • SCRIPTING SKILLS
  • Python, Shell scripting,Terraform,YAML,Unix and Java
  • Scheduling Tools
  • Tivoli workload scheduler,oozie
  • BIG DATA Environment
    Reltio Cloud,Git hub,Cloud-era,Hadoop,Kafka and Py-Spark,NI-FI, AIR-FLOW and AZURE
  • Google Cloud Platform

Data-proc,Cloud Function,Pub/sub,Cloud Composer,

Big-Query,Data-flow,Big-Table,Cloud Storage,IAM

Accomplishments

  • Trained in Distributed Computing with good working knowledge of Data Engineering
  • Certificate in Quality Management of software from BOSCH
  • Appreciation from Allergan , pharmaceutical client for efficient management of CDH and MDM process
  • Appreciation from AT&T for enhancement and development EDM application and software delivery
  • Academic internship certificate from Infosys for project completion
  • SQL and Python certification from Udemy
  • Power BI Certification course completion certificate from IQ-VIA, Azure AZ-900 certified ,

Timeline

Senior Consultant

Capgemini
07.2022 - Current

Data Engineer

Ford Motors
05.2021 - 07.2022

Software Engineer

Amdocs Development Center, AT&T Communications
10.2019 - 05.2021

Software Engineer

Robert Bosch Engineering And Business Solutions
05.2018 - 03.2019

Software Engineer

IQVIA
10.2017 - 05.2018

Master's in Software Engineering - Computer Science

Vellore Institute of Technology

NARAYANA JUNIOR COLLEGE - 91.2%

NETHAJI HIGH SCHOOL - 86%
Prudhvi Reddy