Karthik Kolapalli

About Karthik Kolapalli

Data Engineer with experience in designing, building, and optimizing scalable data…

Experience

1. Software Developer - Data Analytics

   Rev Leasing

   Nov 2024 — Present · Houston, TX, US

   Spearheaded the development of a centralized SQL data warehouse integrating cloud, Excel, and CRM data, slashing data silos by 90% and boosting query performance by 60% for analytics teams.• Orchestrated real-time CRM data ingestion pipelines using AWS API Gateway, Lambda, and S3, enhancing data freshness and reducing latency from hours to seconds to support real-time reporting.• Enforced data governance best practices by implementing strict data type validations and regex logic in web forms, OLAP database, and CRM systems, improving overall data quality and accuracy by 40%.• Developed a sentiment scoring model using Python and NLP on customer reviews, enabling delivery of client-focused business recommendations and boosting engagement by 30% through automated KPI-driven insights.• Engineered Python-based ETL pipelines from web forms, CRM, and external data scraping tools, enabling self-serve analytics and reducing manual work by 80% via cloud-based job scheduling and transformation workflows.• Leveraged OpenAI\'s Generative AI API to auto-classify communications, reducing response handling time by 70%.• Deployed interactive Tableau dashboards with embedded KPI tracking and executive reporting, reducing delivery time by 90% and improving stakeholder visibility.• Led a 3-member team on a client project, accelerating delivery by 20% by efficient coordination.

Education

• The University of Texas at Dallas

  Master's, Business Analytics

• Shanmugha Arts, Science, Technology and Research Academy

  Bachelor of Technology (B.Tech.), mechanical