H

Hemanth Mederamelta

About

Detail

Uttar Pradesh, India

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • CarMax
    Sr. Data Engineer
    CarMax
    Jul 2020 - Current (6 years 1 month)
    • Built real-time ingestion pipelines using Event Hub, and Delta Lake to enable streaming analytics. • Developed ML workflows in Databricks and tracked experiments using MLflow for fraud and lead scoring. • Integrated OpenAI GPT APIs to automate feedback summarization and customer support insights. • Created Azure Function Apps to auto-trigger ETL on file arrival, improving process automation. • Processed equipment telemetry using EMS data to support predictive maintenance reporting. • Designed and developed RESTful APIs in Python to support data ingestion, transformation, and retrieval across multiple applications. • Wrote advanced SQL stored procedures in Snowflake to handle complex transformation logic. • Implemented DBT models f
  • BNY Mellon
    Data Engineer
    BNY Mellon
    Feb 2018 - Jun 2020 (2 years 5 months)
    • Built serverless ETL pipelines using AWS Glue and Lambda for automated data ingestion from internal systems. • Integrated DynamoDB and S3 datasets for building reporting layers in Redshift and Athena. • Created reusable ETL frameworks with parameterized scripts in Python to onboard new sources. • Implemented AWS IAM roles and policies to ensure fine-grained access to data assets. • Built operational dashboards to monitor data pipeline status and job execution metrics. • REST APIs may have been used for third-party data ingestion (SFTP/APIs) and integration with AWS services. • Collaborated with QA to implement automated data validation checks pre-load and post-load. • Designed audit-friendly logging and metadata tracking for compl
  • CVS Health
    Data Engineer
    CVS Health
    Nov 2015 - Jan 2018 (2 years 3 months)
    • Designed batch data pipelines on Hadoop using Hive and MapReduce for daily claims data processing. • Ingested large volumes of streaming data using Kafka for near-real-time processing. • Performed transformation and enrichment in Hive before loading to reporting databases. • Integrated external datasets using PostgreSQL for comprehensive analytics. • Automated validation processes with Python scripts to ensure data consistency. • Developed scalable Hive queries to handle claim-level joins and aggregations. • Worked with analysts to define KPIs and build reporting datasets. • Coordinated with infrastructure team to optimize data node performance. • Implemented Kafka consumer groups to handle parallel message processing. • Migrate
  • T
    Data Analyst / Modeler
    The Hartford Insurance
    Jan 2014 - Oct 2015 (1 year 10 months)
    • Created logical and physical data models using Erwin for enterprise warehouse projects. • Designed star and snowflake schemas to support multi-dimensional OLAP reporting. • Collaborated with stakeholders to gather and define data requirements. • Wrote complex SQL queries and stored procedures for reporting and analysis. • Created SSIS packages for ETL to and from multiple source systems. • Built MDM strategies to align customer and product dimensions across systems. • Developed Tableau dashboards to visualize trends in policy and claims data. • Worked with business to define KPIs and reporting strategies. • Assisted in DDL creation and schema revisions across multiple environments. • Optimized existing queries for performance an