MEGHANA ALUGUBELLI
Summary
Experienced Data Engineer with over 3+ years of hands-on experience in designing, developing, and maintaining large-scale data processing systems. Expertise in leveraging a wide array of data technologies and programming languages to build reliable and scalable data solutions. Proficient in cloud-based technologies, with a strong focus on optimizing data warehousing, ETL processes, and real-time data streaming services.
Overview
5
5
years of professional experience
Work History
DATA ENGINEER (Snowflake, Azure, SQL, ADF)
VOYA FINANCIAL
05.2024 - Current
- Designed and implemented stored procedures and views in Snowflake, leveraging Medallion Architecture to optimize data structuring and processing
- Reduced data discrepancies by 40% with automated Python checks for data accuracy, validation, and anomaly detection.
- Designed and developed data ingestion pipelines using Azure Data Factory (ADF) to load and transform data into Snowflake
- Ensured 99% job success rate by leveraging Tidal for scheduling and orchestrating data pipelines.
- Managed source code versioning using Git, enabling streamlined development, tracking, and collaboration
DATA ENGINEER (ETL, AWS, MySQL, Python)
Synechron
07.2023 - 04.2024
- Designed and implemented robust ETL pipelines using SQL, Python, and AWS Glue to extract, transform, and load data from diverse sources into Snowflake, ensuring optimal performance and data integrity
- Utilized AWS S3 as a data lake for handling large volumes of raw and processed data, implementing data partitioning and compression techniques to optimize storage efficiency
- Reduced data errors by 45% by implementing automated data validation checks using Python and SQL scripts, ensuring accuracy and completeness.
- Integrated data validation processes into the CI/CD pipeline, enabling continuous testing and validation of ETL workflows
- Improved workflow efficiency by 25% using Git for version control and Control-M for orchestration, ensuring seamless collaboration and process automation.
DATA ENGINEER (ETL, Cloud, MySQL)
PLASTICON TECHNOLOGIES
06.2020 - 12.2021
- Led the creation of data pipelines, successfully transferring over 10TB of data from on-premises source systems to Azure cloud data lake storage, enhancing data accessibility and reliability
- Developed and maintained end-to-end data pipelines using Azure Data Factory (ADF) services, resulting in a 30% increase in data processing efficiency and a reduction in manual data handling for Azure SQL Server loads
- Engineered ETL pipelines for both historical and incremental data loads, managing the migration of data from SQL databases to Synapse Warehouse
- Created over 50 custom data visualizations using Power BI, which helped stakeholders understand complex data trends and contributed to a 20% increase in data-driven decision-making efficiency
- Executed over 100 complex mappings, transformations, and workflows in Informatica, leading to a 15% improvement in data quality and validation processes, and ensuring high data integrity
- Implemented a comprehensive pipeline monitoring system using email notifications, reducing downtime by 40% through prompt identification and resolution of pipeline failures
DATA ANALYST (Jupyter, Excel, Power BI)
JP MORGAN CHASE & CO.
01.2020 - 04.2020
- Used Perspective to generate a live graph that displays a data feed in a clear and visually appealing way for traders to monitor
- Improved stock price analysis accuracy by 35% by integrating a stock price data feed with real model solutions in collaboration with the Chase team.
- Enhanced dashboard usability and application stability by 50% through open-source data visualization, UI improvements, and fixing broken TypeScript files.
Education
Master’s Degree - Computer Science
UNIVERSITY OF MISSOURI KANSAS CITY
Kansas City, MO05.2023
Bachelor’s degree - Electronics and Communication Engineering
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Hyderabad, India06-2021
Skills
- Python
- PySpark
- SQL
- ETL development
- Apache Kafka
- MS SQL
- MongoDB
- AWS S3
- EC2
- Glue
- Redshift
- Azure Data Factory
- Azure Databricks
- Snowflake
- Power BI
- Data warehousing
Personal Information
Visa Status: Currently on F-1 Visa, Need H1-B Sponsorship in future.
Timeline
DATA ENGINEER (Snowflake, Azure, SQL, ADF)
VOYA FINANCIAL
05.2024 - Current
DATA ENGINEER (ETL, AWS, MySQL, Python)
Synechron
07.2023 - 04.2024
DATA ENGINEER (ETL, Cloud, MySQL)
PLASTICON TECHNOLOGIES
06.2020 - 12.2021
DATA ANALYST (Jupyter, Excel, Power BI)
JP MORGAN CHASE & CO.
01.2020 - 04.2020
Master’s Degree - Computer Science
UNIVERSITY OF MISSOURI KANSAS CITY
Bachelor’s degree - Electronics and Communication Engineering
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Similar Profiles
Michael SmithMichael Smith
Vice President/Product Director at Voya Financial/ING/Aetna Financial ServicesVice President/Product Director at Voya Financial/ING/Aetna Financial Services
Pete NelsonPete Nelson
Implementation Consultant at Voya FinancialImplementation Consultant at Voya Financial
Cheyenne HortonCheyenne Horton
Employee Benefits RFP Specialist at Voya FinancialEmployee Benefits RFP Specialist at Voya Financial