Sravani Katragadda

On-Premise to Cloud-Scaled Migration Client: Commonwealth Bank of Australia. Managed job execution in AWS by establishing necessary prerequisites to ensure smooth operational flow. Conducted data reconciliation between on-premises systems ensuring data integrity and accuracy. Experience with SQL queries and Unix commands, creating the reports based on the requirement, filtering, grouping and modifying the data. Identified and documented defects related to data discrepancies, effectively tracking them to resolution. Led and contributed to the successful end-to-end migration of enterprise data infrastructure in on-premises servers enhancing scalability, reliability, and cost efficiency. Orchestrated large-scale data migration workflows utilizing custom Spark ETL scripts. Achieved a 40–60% improvement in system performance while significantly reducing operational overhead.

Client: Commonwealth Bank of Australia. Collaborated with Technical BA to analyze Business Requirements Document (BRD) and address queries before initiating build activities. Developed data ingestion pipelines from various source systems, transitioning file-based and batch processing files. Hands on Experience in Big data technologies mainly in Hive. Created SQL queries, Spark objects, and packages, automating jobs with AutoSys and configuring the existing Spark ETL framework within IntelliJ IDE. Optimized data structures for analytics and reporting, resulting in a 40% improvement in query performance. Implemented ETL pipelines on spark and using autosys for scheduling workflows based on project requirements. Validated and transformed data from diverse systems, ensuring alignment with business logic before loading it into Amazon Aurora Database. Merged code into the master branch to establish a production-ready version after completing unit testing, system testing, end-to-end testing, and securing testing sign-off.