Akshitha Kolaboina
Hyderabad
Summary
Dynamic Software Development Engineer with a proven track record at Lumen Technologies, specializing in ETL pipeline development and data migration to GCP BigQuery. Expert in Python and SQL, I excel in optimizing data processes and fostering collaboration. Successfully reduced setup time by 90% through innovative automation solutions, driving impactful results.
Overview
1
1
Certification
3
3
years of professional experience
Work History
Software Development Engineer
Lumen Technologies
Bangalore
08.2024 - Current
- Designed and developed enterprise ETL pipelines using IDMC (IICS) to seamlessly migrate data from diverse on-premises sources to GCP BigQuery for 11+ critical applications.
- Implemented robust SCD (Slowly Changing Dimension) strategies, ensuring precise source-to-target data type mapping and optimized loading patterns into BigQuery.
- Architected and developed an automated DDL Generator tool to dynamically create BigQuery schemas for Raw, STG, and SRV layers, reducing manual developer effort and setup time by 90.
- Engineered comprehensive metadata ingestion pipeline to capture Informatica asset relationships, connections, schedules, and job run metrics into BigQuery, streamlining dependency mapping and enhancing audit trails.
- Executed production deployments and managed post-production monitoring, data refresh cycles, and query optimization, supporting downstream users with reliable data access.
- Enforced rigorous data governance protocols, validating data uniqueness, accuracy, and structural consistency across all BigQuery layers.
- Leveraged GCP services like Cloud Run, Functions, GCS, and Pub/Sub to enhance application performance. Executed a project that utilized Cloud Run Functions to extract metadata from Informatica through REST APIs. Implemented storage of the metadata in BigQuery for analysis and reporting.
- Constructed ETL pipelines for data storage in BigQuery, improving retrieval efficiency.
Applied data warehousing principles to optimize data organization.
Conducted data analysis by querying BigQuery tables to drive informed decision-making.
Internship
Lumen Technologies
Bangalore
02.2024 - 07.2024
- Migrated legacy SOAP web services to Spring Boot RESTful APIs, significantly enhancing system scalability, efficiency, and overall performance.
- Proposed strategies and solutions in team meetings to enhance performance.
- Executed daily operational tasks, maintaining workflow efficiency.
Education
Bachelor of Technology - Electronics and communication Engg
MLR Institute of Technology
01-2024
Higher Secondary Education - MPC
Sri Chaithanya Junior College
01-2020
Secondary Education - ssc
H.A.L Secondary school
01-2018
Skills
- ETL pipeline Development
- BigQuery optimization
- Data warehousing principles
- Data integration and migration
- Data analysis and monitoring
- Google Cloud Platform services
- GCS, Cloud run functions, pub/sub
- Informatica Cloud integration
- Spring Boot framework
- REST APIs development
- SQL and MySQL
- Python and Java
- Jira Kanban methodology
- Looker Studio visualization
Certification
- AI Basic Level Certification
- AI Intermediate Level Certification
- Certified in Java by HackerRank
Projects
- Brain-Controlled Wheelchair (BCW): Engineered an accessible, real-time mobility solution for severely disabled individuals by integrating a low-cost, portable EEG headset (NeuroSky) with AI-driven robotics and sensor-based obstacle avoidance systems.
- Signature Verification Using MATLAB, Image Processing, Developed a specialized software system in MATLAB designed to analyze and verify handwritten signatures to effectively prevent forgery., Implemented image preprocessing techniques such as binarization, thinning, and feature extraction to compare test signatures against reference samples.
Timeline
Software Development Engineer
Lumen Technologies
08.2024 - Current
Internship
Lumen Technologies
02.2024 - 07.2024
Bachelor of Technology - Electronics and communication Engg
MLR Institute of Technology
Higher Secondary Education - MPC
Sri Chaithanya Junior College
Secondary Education - ssc
H.A.L Secondary school