Praveen Sai Kumar Koduri

Client: Vanguard

5+ Years of Experience as an AWS Data Engineer in US based investment project with extensive technical and functional experience. Skilled in leveraging AWS tools to manage and transform large scale data sets. It includes ETL development, database Management, Big data processing, Data security, Performance optimization.

Data Migration from on-premises DB to cloud data lake (June 2022- Current)

• Developed and maintained data pipelines to ingest, store and process the data in data lake.
• Developed various utilities like process keys, change data capture for the application.
• Developed and maintained Control-M jobs, Workflows, dependencies and schedules.
• Performed root cause analysis of production related issues and prepared the SQL queries to check if the overnight data being ingested correctly, so that downstream users can use this data to run their jobs.
• Developed Splunk dashboard for the users in order to check the on-premises DB count and data lake count.
• Reduced almost 20% of the cost by changing the EC2 instance types and memory related configuration.

Retail Data Analytics (September 2019-June 2022)

• Developed Automated scripts using CloudFormation templates to deploy and configure AWS resources such as EC2 Instances, S3 buckets and IAM policies.
• Used AWS glue for the data transformation, validate and data cleansing.
• Worked on RDS snapshots export to data lake (both automated and manual snapshots) using Lambda and glue.
• Worked on AWS services like IAM, S3, Lambda, Glue, CloudFormation templates, EMR, Athena, CloudWatch, SNS.