Sreekanth Kamaraju

worked on telemetry ETL pipeline development with AWS Glue for structured onboarding of self serve analytics data from multiple application teams in Cisco with a extendable frame work to serve many application teams and their data from JSON sources into Athena table useful for business analysis through powerbi dashboards. Working on a telemetry data platform Team focused on scalable and cost-efficient data onboarding from multiple application teams for running the business and ETL pipelines using AWS and big data technologies. Developed reusable onboarding framework to ingest telemetry JSON data into structured formats in Parquet files in Aws S3 using AWS Glue, and schema validation and accessing it through AWS Athena tables used to create analytics on the data to visualize it in powerbi for making business decisions. worked with multiple application teams and stakeholders holders to gather the requirement and onboard the data accordingly. Built Glue-based ETL pipelines for pull telemetry and push Telemetry for transforming the nested json structured data into a flat paquet file through athena table use this data for supporting analytics and dashboards. Migrated pipelines from Apache Flink to AWS Glue, enabling better maintainability, reprocessing at date-hour granularity, and improving performance by 40%. Processed time-series data from InfluxDB using dynamic schemas, regex-based routing, and supported multi-format outputs (Parquet, Avro). Designed dual-schema pipelines for both analytical and machine-readable outputs, supporting CSDF and other platform teams. Implemented unit testing for ETL scripts and resolved EXT support issues through root cause analysis, enhancing reliability and stakeholder trust.

Engineered end-to-end ETL workflows for headcount, absence, and entitlement reporting across global TESCO teams. ⋄ Developed and validated 10 Dimension files monthly by integrating raw and API-sourced colleague data ⋄ Implemented business logic across Raw, Enrich, and Domain layers to derive aggregated Data for turnover ratio, redundancy planning, and organizational restructuring. ⋄ Processed leave (absence/entitlement) data sourced via Kafka topics and enriched weekly for financial year reporting. ⋄ Enabled operational dashboards and weekly business reporting by using Azure Databricks pipelines and validating Tableau visualizations ⋄ Identified 1M Dollar in annual savings through data modeling and analytics across workforce planning initiatives. ⋄ Actively participated in troubleshooting, root cause analysis, and stakeholder support for both HR and operational dashboards

Project: Clinical Insights Engine -CIE (Feb 2020 – Mar 2022) Domain: Health Care ⋄ Built Batch ETL jobs for pharmacy analytics using PySpark and Hive ⋄ Worked on Daily ETL and incremental loading to ensure timely availability of up-to-date insights to help business to take key decisions on claims processed everyday ⋄ Sent timely medicine refill updates to patients based on the medical history through the pyspark ETL jobs and increases the user experience Systems Engineer at Tata Consultancy Services Dec-2018-Apr 2022 Project: Intelligent Prescription - IRX (Jan 2019 – Jan 2020) Domain: Health Care ⋄ Developed SQL scripts and shell automation for Reports Generation of claims submitted/processed Everyday creating cost analysis report for Business ⋄ Providing Pro-active production support to help customers have seamless experience. ⋄ Received formal Recognition from customers for pro active assistance