Hemanth Brahmendra Mallela
Powell,OH
Summary
Motivated and detail-oriented data engineer with solid knowledge of data gathering, cleaning, and transformation. Proficient in Python and SQL, with a passion for using data to create insights in the electrical industry. I'm eager to contribute to data-driven initiatives and work with cross-functional teams to improve operational efficiency.
Overview
4
4
years of professional experience
Work History
Data Engineer
American Electric Power(AEP)
02.2024 - Current
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Managed large datasets using Python (NumPy, Pandas) for deep analysis and business analytics, achieving a 20% improvement in data processing efficiency.
- Applied advanced data analysis techniques including regression analysis, trend analysis, and actionable insights, optimizing sales strategies.
- Developed SQL queries and utilized SAS for data analytics with filtering structures to refine datasets, extract pertinent information, and enable focused analysis, facilitating the derivation of actionable insights.
- Planned and installed upgrades of database management system software to enhance database performance.
- Automated end-to-end testing environments on AWS using Boto3 Python, including security group management and custom monitoring with CloudWatch. Designed and built a data pipeline design, which increased data efficiency by 20%.
- Hands on Experience on Databricks tables performance tuning by caching and vacuuming the data.
- Standardized and efficient database models ensure data consistency across several sources.
- Assisted with the design and implementation of ETL procedures for integrating data from several sources into the data warehouse.
- Create, build, and manage scalable data pipelines for massive datasets using Java and frameworks such as Apache Spark or Apache Flink.
- Established and secured enterprise-wide data analytics structures.
Python Developer Intern
Venky's Vision IT Solution & PVT Ltd
01.2021 - 06.2021
- Assist with the development of product management application features such as inventory tracking, pricing, and classification.
- Create and maintain Python scripts to automate repetitive operations in product data management.
- Collaborate with database administrators to ensure that product-related data is efficiently stored and retrieved.
- Assist in the creation of SQL queries and Python scripts to alter product data while maintaining data integrity.
- Participate in testing methods, including unit tests and integration tests, to verify product features perform as expected.
- Identify and resolve issues with product data or application functionalities.
- Tested functional compliance of company products.
- Understanding of e-commerce platforms and related technologies.
- Basic understanding of front-end technologies (HTML, CSS, and JavaScript) is required for potential integration activities.
Education
Master of Arts - Information Technology
Webster University
Saint Louis, MI12.2023
Bachelor of Science - Civil Engineering
CMR College of Engineering & Technology
03.2020
Skills
- Code Writing
- Object-Oriented Programming
- Linux Environment
- Python
- Test Automation
- Project Planning
- API Development
- Data Migration
- Data Modeling
- ETL development
- SQL Programming
- Windows
- Data Bricks
Accomplishments
- AutoCad Certification
- Certified in Python for Beginners
Timeline
Data Engineer
American Electric Power(AEP)
02.2024 - Current
Python Developer Intern
Venky's Vision IT Solution & PVT Ltd
01.2021 - 06.2021
Bachelor of Science - Civil Engineering
CMR College of Engineering & Technology
Master of Arts - Information Technology
Webster University
Similar Profiles
Kimberli AndingKimberli Anding
Executive Administrative Assistant at American Electric Power, AEPExecutive Administrative Assistant at American Electric Power, AEP
Anthony DavisAnthony Davis
Line Crew Supervisor at American Electric Power, AEPLine Crew Supervisor at American Electric Power, AEP
Micheal McCathernMicheal McCathern
Real Time Market Operations at American Electric Power, AEPReal Time Market Operations at American Electric Power, AEP