Hemanth Kumar Kandregula
Data Analyst | Business Analyst | ETL Developer | Certified Power BI Developer | CDP & Campaign Analytics Expert
- Role
- System Engineer at Tata Consultancy Services
- Location
- Hyderabad, TG, IN
- LinkedIn followers
- 500 followers
About Hemanth Kumar Kandregula
As a Data and Business Analyst with 4+ years of experience, I specialize in turning…
Experience
System Engineer
Feb 2024 — Present · Hyderabad, IN
Working for global automotive giant Stellantis N.V. as a Data/Business Analyst, delivering insights for 5+ vehicle brands and 7M+ connected vehicles. Designed and optimized ETL workflows using IBM DataStage and Treasure Data CDP, processing 2M+ records daily, reducing manual intervention by 25% and improving data SLAs by 30%. Designed and maintained Vehicle Health Report (VHR) email workflows driving over $500M USD in annual revenue. Tuned long-running queries by adding indexes, rewriting subqueries, and optimizing execution plans, cutting runtimes by up to 60%. Produced daily and weekly SQL reports automatically delivered to stakeholders, tracking campaign performance and vehicle health trends. Developed 7+ Power BI dashboards covering consolidated campaign performance, connected vs. non-connected vehicle analytics, In-Vehicle Message (IVM) recall tracking, campaign click-through and conversion rates, Vehicle Health Report (VHR) responses, and Loyalty Program insights. Created a generic Python script to track daily email volumes for 5+ brands and 100K+ daily emails. Implemented unit tests achieving 80%+ code coverage, ensuring production stability for critical scripts. Collaborated with cross-functional teams to optimize data workflows and enhance data quality.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.