Ram Kiran Devireddy

Bachelor's in Communications and Electronics

2016 - 2020

K L Deemed to be University, Guntur, INDIA

CGPA: 9.34/10.00

• Coursework: Objected Oriented Programming, C and Data Structures, Probability and Stochastic Models, Single Variable Calculus and Matrix Algebra, Multi Variate Calculus, Discrete Mathematics, LabVIEW, Fundamentals of IT, Coding Skills in Python, Signal, and Image Processing, MATLAB
• Participated in many research activities, including with a publication on various methodologies of Facial Expression detection on IJRTE, Volume-8 Issue-5, January 2020
• Publication: E6284018520

High School in Mathematics, Physics and Chemistry

2014 - 2016

Sri Chaitanya Jr College, Vijayawada, INDIA

Percentage: 93.3 %

• Coursework: Permutations and Combinations, Differential equations, Integrations, Quadratic Expressions, Statistics, Binomial Theorem, Probability, Random Variables and Probability Distributions, Binomial Theorem, Partial fractions, Complex Numbers, Physics and Chemistry
• Financed the whole fee of 12th grade through Combined Counselling Board (CCB) meritorious Scholarship, Govt of AP.

Secondary schooling 10th Grade

2013 - 2014

KVT School, Vijayawada, INDIA

GPA: 9.5/10.0

Coursework: Algebra/Linear Algebra, Reflection and Coordinate Geometry, Geometry and Measurement, Trigonometry, Statistics and Probability, Pre-calculus, Biology, Physics and Chemistry.

Elected and Served as Class Representative for the 2012-13 and 2013-14 academic years.

National Service Scheme Volunteer

2017 - 2019

National Service Scheme, Govt of India

Ministry of Youth Affairs and Sports

• Part of many National Service Scheme camps as a volunteer, recording feedback, requirements and complians of rural and backward people.
• Apart from this, I also helped the Govt in organizing many medical camps alongside many environment protection and financial awareness campaigns.

Data Engineer

2024 - Present

Bloom Insurance Agency, Bloomington, IN, US

• I have hands-on experience in Data Modelling, Database Management, Data Migration, ETL pipelines design and implementation.
• My accomplishments at Bloom include Redshift Data warehouse design, AWS Migration, scalable ETL pipeline development.
• In a team of four for the past 1.5 years, architected and developed the main data warehouse in AWS Redshift and built pipelines to migrate data from our legacy SQL Server.
• Together, we designed many core data pipelines to ingest data from various clients through sources like SFTP and S3, and created a delivery framework to extract and deliver data to health insurance clients.
• I led the team's transition to infrastructure as code for AWS. I helped implement all our standard processes and AWS resources using Terraform. By integrating Terraform with GitHub Actions CI/CD, I automated the entire AWS deployment lifecycle.
• I also worked on many complex SQL stored procedures and built SSRS and Power Bi reports for insurance clients.
• Tech Stack: Python, AWS Glue, SSIS, AWS Lambda, SQL (Redshift, Postgres, MS SQL Server), AWS Step Functions, SSRS, Power Bi, GitHub Actions, CICD.

Data Engineer Intern

2023

• I interned at Bloom for 8 months and I remodeled more than 50 old SSIS ETL pipelines by parametrizing them and error handling with checkpoints.
• I also worked on writing complex SQL queries and stored procedures to extract last year Plan details from SQL Server for clients. I also developed a simple python automation to extract Plan details and deliver to clients.
• I worked on designing SSRS reports with complex SELECT queries during Annual Election Period (AEP). I also worked on creating and maintaining new years plan benefits data and Call Center data.
• I designed a JSON extractor using Python and Bash to extract data from JSON objects and load into CSV files.
• Tech Stack: SQL Server, SSIS, SSRS, JSON, Python, BASH.

Software Engineer

2021 - 2022

Entain India (IVY Comptech), Hyderabad, India

• I worked as a software engineer at Entain for 2 years. I led a team of 3 in handling the whole Software development life cycle from requirement gathering, designing, developing, testing to deploying and maintaining of gaming web pages and RESTFul Apis.
• Using Java, Spring and Spring Data JPA, I worked on the backend development of white labels for many gaming web pages.
• I worked on data migration of acquired companies with various database sources like MS SQL, My SQL, Mongo DB etc into our database system which is Oracle SQL. I designed transformation logic and migration scripts for more than 7 acquired clients.
• Tech Stack: Java, Spring, JDBC, Hibernate, SQL (Oracle SQL, My SQL), Mongo DB, JSON, JSPs and Servlets, HTML, CSS, Python, BASH and Jenkins.

Trainee Software Engineer

2020

• Worked on development of core related features like registrations, logins, account recovery, language and mailing through backend technologies like Java [Spring MVC and Spring Data JPA] and Oracle SQL.
• Developed strong compliance and regulatory requirements like GDPR, PCI, KYC, Geolocation, Regulatory Reporting and Responsible Gaming for various countries like US, Germany, UK, Mexico and Portugal.
• Orchestated heavy production deployements and fruitfully developed and launched 15+ projects, which got me promoted to Software Engineer.