Meghana Macha
Spring Hill,TN
Summary
Experienced Data Engineer & BI Developer with 5+ years in ETL, data analytics, and cloud solutions. Skilled in Power BI, SQL, Snowflake, Apache Spark, and Azure Data Factory, with a strong focus on automation, optimization, and real-time data processing. Proven ability to enhance reporting efficiency, streamline ETL pipelines, and drive data-driven insights in agile environments.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
Lithia Motors
01.2023 - Current
- Developed 10+ ETL pipelines using Python & Apache Spark, reducing data processing time by 40%
- Automated workflows in Azure Data Factory & Data bricks, enhancing data accessibility for business teams
- Designed Power BI dashboards for real-time tracking of sales, inventory, and performance KPIs
- Integrated Apache Kafka for real-time analytics, improving sales forecasting accuracy
- Optimized SQL queries in Snowflake, reducing report execution time by 35%
Data Analyst
Tata Consultancy Services
07.2021 - 07.2022
- Developed complex SQL queries for healthcare data analysis, ensuring HIPAA compliance
- Built ETL workflows in Snowflake & AWS Redshift, processing high-volume patient and claims data
- Created interactive Power BI & Tableau dashboards, improving operational decision-making
- Automated pipeline deployments using Apache Airflow, reducing manual effort by 40%
- Implemented data validation and anomaly detection, improving data accuracy by 30%
SQL Developer
Cognizant
10.2019 - 07.2021
- Designed SQL-based financial data models for transaction analysis & fraud detection
- Optimized database schemas, reducing query execution time by 50%
- Built SSRS dashboards for risk assessment and regulatory compliance
- Managed ETL workflows using SSIS, automating data extraction and transformation
Education
Master of Science -
Webster University
Orlando, FL03.2024
Bachelor of Technology - Computer Science
Anurag Group of Institutions
Hyderabad, India05.2020
Skills
- SQL (T-SQL, PL/SQL)
- Python (Pandas, NumPy, PySpark)
- Java
- Power BI
- Tableau
- Alteryx
- Apache Spark
- Snowflake
- SSIS
- Informatica
- Data Warehousing
- Azure (Databricks, Data Factory, Synapse)
- AWS (S3, Redshift, Glue)
- GCP (BigQuery)
Technical Skills
SQL (T-SQL, PL/SQL), Python (Pandas, NumPy, PySpark), Java, Power BI, Tableau, Alteryx, Apache Spark, Snowflake, SSIS, Informatica, Data Warehousing, Azure (Databricks, Data Factory, Synapse), AWS (S3, Redshift, Glue), GCP (BigQuery)
Certification
- Azure Data Engineer Associate
- AWS Data Engineer Associate
Timeline
Data Engineer
Lithia Motors
01.2023 - Current
Data Analyst
Tata Consultancy Services
07.2021 - 07.2022
SQL Developer
Cognizant
10.2019 - 07.2021
Master of Science -
Webster University
Bachelor of Technology - Computer Science
Anurag Group of Institutions
Similar Profiles
Emily WhitworthEmily Whitworth
Dealership Accountant at Lithia MotorsDealership Accountant at Lithia Motors
Laurie SommersLaurie Sommers
Account Administrator at Lithia MotorsAccount Administrator at Lithia Motors
Patricia MartinezPatricia Martinez
Accounts Manager III at Lithia MotorsAccounts Manager III at Lithia Motors