Summary
Overview
Work History
Education
Skills
Additional Information
Accomplishments
Hobbies and Interests
Languages
Timeline
Generic
Pavan Shanmukh Maddu

Pavan Shanmukh Maddu

Kakinada

Summary

AWS data engineer with expertise in Glue, S3, Lambda, Athena, Redshift and snowflake, specializing in designing robust data solutions, developing and productionizing Glue jobs, complex domain models, and managing ETL pipelines. Proven track record of resolving issues and delivering scalable solutions in dynamic environments.

Overview

3
3
years of professional experience

Work History

Senior Software Engineer - Delivery

Mastek
Mumbai
08.2021 - Current
  • Demonstrated proficiency in AWS services, including Glue, S3, Lambda, Athena, and Redshift
  • Successfully handled responsibilities in all aspects of the project, including development, implementation, testing and maintenance
  • Developed and maintained data pipelines to ingest, store, process and analyze large datasets in AWS S3 buckets.
  • Created ETL processes using Python scripts to move data from various sources into the target databases on AWS Redshift or RDS.
  • Developed a robust data migration utility in AWS Glue, efficiently transferring data from Redshift to Snowflake with comprehensive error logging and end-to-end validation.
  • Designed conceptual, logical and physical data models for various databases handling large datasets.
  • Developed data models to meet the business requirements of clients.
  • Managed code versions using Git and deployed jobs through CI/CD pipelines by developing CloudFormation templates (CFNs).
  • Received appreciation and recognition for delivering high-quality solutions and completing deliveries on time
  • Leveraged SQL Server, Power BI and Microsoft Business Intelligence (MSBI) tools such as SSIS, SSRS, and SSAS in a project called SIS.

Education

Bachelor of Technology - Mechanical Engineering -

Aditya Engineering College

Skills

  • Experience with AWS services such as Glue, S3, Lambda, Athena, Redshift and RDS
  • Proficient in SQL
  • Strong understanding of ETL processes and tools
  • Familiarity with data warehousing and data lake architectures
  • Basic knowledge of programming languages such as Python and Java, with Python being the primary language for both knowledge and experience
  • Familiarity with DBT (Data Build Tool) for data transformation processes
  • Basic understanding of Snowflake data platform for cloud data warehousing
  • Familiarity with Agile methodologies and project management tools like Octane
  • Working knowledge of Confluence page for collaborative documentation and knowledge sharing
  • Excellent problem-solving and communication skills
  • Ability to work collaboratively with cross-functional teams and stakeholders
  • Proven ability to handle UK & US clients and deliver successful projects

Additional Information

AWS services(Glue, Lambda, S3, Redshift, RDS, Athena etc..), Snowflake, Python, Java, DBT, Power BI & MSBI

Dbeaver, GIT, Octane, SQL server

Accomplishments

  • Earned HackerRank SQL certifications, displaying proficiency in database management and programming.
  • Received "True champion" team award for unwavering commitment to team success, as cited by positive customer feedback.
  • Graduated from competitive Mastek LEAP Program and earned a spot in coveted ACE40 program, demonstrating expertise in AWS data engineering.
  • Received prestigious Bright Spark award for on-time deliveries, supporting the team, and communication skills.
  • Recognized with "Customer Delight" award for delivering excellent production releases and for effective communication and collaboration, which led to the key to success.

Hobbies and Interests

  • Listening to music is a great stress-reliever for me and helps me to focus better on my work.
  • I enjoy reading a variety of books, which has helped me to improve my critical thinking and problem-solving skills.
  • Travelling to different places and experiencing new cultures is something I find very enriching and helps me to broaden my perspective.
  • I enjoy playing sports like Cricket, badminton & basketball, which helps me in relieving all the stress and helps in increasing my concentration towards my tasks.

Languages

  • English, Fluent
  • Telugu, Native speaker
  • Hindi, Beginner

Timeline

Senior Software Engineer - Delivery

Mastek
08.2021 - Current

Bachelor of Technology - Mechanical Engineering -

Aditya Engineering College
Pavan Shanmukh Maddu