Avani Kala

Business Analyst Intern

Xcel Energy•  January 2024 - August 2024•  Saint Paul, MN

Extracted and transformed raw operational data from SAP, ensuring compliance by validating presence of work order for maps. Engineered daily ingestion pipeline of pre/post trip logs from GeoTab API, cutting down time spent comparing worker logs. Analyzed patterns from year-to-date gas emergency calls in St. Paul using advanced visualization techniques via Matplotlib and Seaborn, leading to insights that targeted three primary causes impacting service response times directly. Streamlined manual paper-based processes by incorporating tools like Microsoft Forms and Power Automate, thereby simplifying daily manual work for field workers and managers by 2 hours.

Data Analyst

Bajaj Finance Ltd.•  September 2021 - August 2022•  Pune, India

Reimagined Personal Loan through Centre Of Excellence Dept., by enhancing ongoing pre-approved journeys and ideating new journeys. Designed Business Requirements Documents & refined them by communicating with technical team and higher stakeholders. Developed merchandising strategies for loan journeys based on regression analysis; identified key attributes to increase traffic and conversion, resulting in 25% sales lift. Built daily status dashboard on Power BI to visualize core business KPIs, reducing manual reporting by up to 6 hours per week. Analyzed data from 22k monthly active users and used outputs to guide marketing and product strategies for Phase 2 development.

Software Engineer

Zensar Technologies•  August 2019 - August 2021•  Pune, India

Co-developed a comprehensive knowledge base with a team using statistical analysis to identify common customer queries and provide efficient self-service solutions. Designed formal ERD, Sequence and Method diagrams useful to keep record of relationship of data and tables as database complexity grew over time. Implemented data-driven strategies to revamp customer support processes, resulting in 20% reduction in ticket volume on ServiceNow.