Sasidhar Gadepalli

Professional Experience

Overall, 12 years of IT experience as a software developer in various roles
I've worked closely with clients at their locations for over 7 years, tailoring tech solutions to fit their specific needs
Designed and implemented scalable PySpark ETL frameworks that streamlined data ingestion, transformation, and loading processes, enhancing data pipeline reliability and efficiency
Developed and maintained a robust data lake using PySpark on top of AWS S3
Expertly managed large datasets with AWS S3, implementing best practices in data storage, security, and accessibility
Proficient in building scalable and robust data pipelines using AWS Glue, adept at data extraction, transformation, and loading (ETL) processes, significantly improving data accessibility and analytics workflows
Skilled in utilizing AWS Athena for complex data queries and analysis, optimizing performance and cost-efficiency by crafting well-structured SQL statements and effectively managing data partitions and storage formats
Developed and maintained scalable data processing workflows with Airflow, enhancing automation and monitoring
Leveraged AWS S3 for secure and durable object storage, implementing lifecycle policies and versioning that enhanced data governance
Designed and implemented serverless data processing workflows using AWS Lambda
Designed a fault-tolerant and resilient multi-tier AWS infrastructure, employing services like EC2, RDS, and S3
Developed a comprehensive disaster recovery strategy on AWS, using cross-region S3 replication and RDS snapshots to achieve a Recovery Point Objective (RPO) of less than 5 minutes and Recovery Time Objective (RTO) of less than 15 minutes.
Crafted an AWS security framework that integrated IAM policies, Security Groups, and VPC configurations
Utilized Python to automate data cleaning and preprocessing tasks, improving data quality
Developed Python scripts for complex data analysis, uncovering hidden patterns
Used different AWS services such as EC2, Elastic beanstalk, S3 and Simple Queue Service
Extensive experience in handling all these services
Very quick in analyzing the problem and coming up with fix
PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Strong experience in Data warehouse concepts, ETL.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL

Professional Projects

Client: Capital Group Companies
Location: Irvine, CA

Duration: 2019 September - Current
Role: Senior AWS Developer

Roles and Responsibilities:

Guided a seven-member team through every stage of the project, ensuring tight collaboration with the client for optimal results
Built various data pipelines from S3
Engineered high-performance data processing jobs using PySpark
Designed and implemented scalable PySpark ETL frameworks that streamlined data ingestion, transformation, and loading processes, enhancing data pipeline reliability and efficiency
Developed and maintained a robust data lake using PySpark on top of AWS S3
Expertly managed large datasets with AWS S3, implementing best practices in data storage, security, and accessibility
Developed and maintained scalable data processing workflows with Airflow, enhancing automation and monitoring
Leveraged AWS S3 for secure and durable object storage, implementing lifecycle policies and versioning that enhanced data governance
Designed and implemented serverless data processing workflows using AWS Lambda
Designed a fault-tolerant and resilient multi-tier AWS infrastructure, employing services like EC2, RDS, and S3
Developed a comprehensive disaster recovery strategy on AWS, using cross-region S3 replication and RDS snapshots to achieve a Recovery Point Objective (RPO) of less than 5 minutes and Recovery Time Objective (RTO) of less than 15 minutes.
Crafted an AWS security framework that integrated IAM policies, Security Groups, and VPC configurations

Client: Warner Music Group
Location: Burbank, CA

Duration: 2017 August - 2019 September
Role: Python AWS developer and Data Engineer

Roles and Responsibilities:

Engineered and optimized ETL pipelines using Python
Utilized Python to automate data cleaning and preprocessing tasks, improving data quality
Used different AWS services such as EC2, Elastic beanstalk, S3 and Simple Queue Service with extensive hands-on
Successfully deployed and managed multiple web applications using AWS Elastic Beanstalk, automating scaling and load balancing
Designed a highly available and secure storage solution utilizing AWS S3, implementing best practices for data lifecycle management and cross-region replication
Integrated AWS Simple Queue Service (SQS) to decouple microservices, leading to a more resilient application architecture
Developed a CI/CD pipeline that utilized AWS Elastic Beanstalk for seamless application updates
Leveraged AWS S3 for cost-effective archival of terabytes of legacy data, applying intelligent tiering to reduce storage costs

Client: Warner Music Group
Location: Burbank, CA

Duration: Aug 2016 - 2017 Aug
Role: Java Developer

Roles and Responsibilities:

Developed a suite of scalable, secure Java-backed RESTful APIs, serving as the backbone for a high-traffic web application
Spearheaded a cross-functional team in the end-to-end development of a feature-rich web application, leveraging Java for server-side logic and JavaScript for a responsive, intuitive user interface
Architected a Java-based microservices framework that increased application modularity
Refactored legacy codebase to modern Java standards
Designed and implemented a comprehensive data auditing solution using Oracle PL/SQL triggers
Developed a suite of PL/SQL functions and procedures for a financial reporting system, facilitating the generation of real-time fiscal reports that provided key insights into organizational financial health

Client: Warner Music Group
Location: Hyderabad, India

Duration: Feb 2012 - 2016 Aug
Role: Java Developer

Roles and Responsibilities:

Developed a suite of scalable, secure Java-backed RESTful APIs, serving as the backbone for a high-traffic web application
Spearheaded a cross-functional team in the end-to-end development of a feature-rich web application, leveraging Java for server-side logic and JavaScript for a responsive, intuitive user interface
Architected a Java-based microservices framework that increased application modularity
Refactored legacy codebase to modern Java standards
Designed and implemented a comprehensive data auditing solution using Oracle PL/SQL triggers
Developed a suite of PL/SQL functions and procedures for a financial reporting system, facilitating the generation of real-time fiscal reports that provided key insights into organizational financial health

Professional Experience

Professional Certifications

Technical Skills

Education

Professional Projects