Summary
Overview
Work History
Education
Skills
Websites
Projects
Awards
Certification
Work Preference
Timeline
Generic
Open To Work

Kiran Mai Pallela

Campbell,CA

Summary

Aspiring Data Analyst with strong proficiency in SQL, Python, Tableau, and Power BI. Experienced in analyzing, modeling, and visualizing data to transform complex datasets into clear, actionable business insights.

Overview

4
4
years of professional experience
2
2
Certifications

Work History

Code Instructor

Code Ninjas
Livermore, California
10.2025 - 02.2026
  • Guided students in programming fundamentals with Python, Scratch, Roblox Studio, and Minecraft, fostering foundational coding skills.
  • Assisted students in building and programming LEGO robotics, enhancing understanding of automation and basic engineering concepts.
  • Simplified technical concepts for non-technical learners, enhancing clarity in communication and teaching effectiveness.

Software Engineer/Data and Risk Analyst

LTIMindtree
Bangalore, India
10.2021 - 08.2024
  • Led the automation of data workflows using UiPath, significantly improving operational efficiency and enabling timely decision-making across teams.
  • Enhanced data visibility and operational efficiency by implementing Salesforce CRM automation within 3 months, streamlining user access workflows across environments.
  • Collaborated with engineering, customer experience, and support teams to translate business requirements into actionable analytical insights.
  • Documented metrics, methodologies, and findings, communicating analytical results effectively to technical and non-technical stakeholders.
  • Passionately working on Excel and Power BI projects to analyze and visualize data. Independently performing data cleaning, transformation, and modeling, and creating KPIs and interactive dashboards. Designed dashboards with a focus on clarity and actionable insights. View my work in my portfolio.
  • Experience with ServiceNow for incident tracking, access management, and workflow automation.
  • Supported vendor-managed applications through regular backups, troubleshooting, and user access resolution, ensuring compliance with data security policies and operational governance.

Education

Master of Technology - Computer Science and Engineering

New Horizon College of Engineering
Bangalore, India
12.2024

Bachelor of Engineering - Computer Science and Engineering

Ballari Institute of Technology And Management
Ballari, India
08.2021

Skills

  • Technical Expertise: Python, SQL
  • Workflow Automation: UiPath, Salesforce CRM, Alteryx
  • Data Handling & Analysis: Pivot tables, Power Query
  • Data Visualization & Reporting: Advanced Excel, Power Bi, Tableau
  • Others: ServiceNow, IRM Compliance

Projects

Shopify Sales & Customer Insight

11/2025 - 12/2026

  • Built an interactive Power BI dashboard using a star schema design and custom DAX KPIs including AOV and Repeat Rate.
  • Created dynamic slicers for multi-dimensional analysis across products, regions, and time periods.
  • Visualized sales trends using line and area charts, maps, and drill-through for detailed regional and transaction-level insights.
  • Performed advanced analytics to uncover customer behavior patterns and key business metrics.
  • Enabled data exploration and reporting through interactive dashboards for enhanced analysis of sales, marketing, and customer engagement.

Ecommerce sales

01/2026 - 02/2026

  • Developed Excel dashboards to monitor key performance indicators (KPIs) including total sales, total profit, number of orders, quantity sold, and profit margin.
  • Designed charts to visualize top-selling sub-categories, profit vs. sales, regional performance, and category-wise profitability.
  • Utilized pivot tables, conditional formatting, and formulas to summarize and analyze large datasets effectively.
  • Implemented dynamic filters for year, region, category, and ship mode to allow detailed, drill-down analysis.
  • Organized and presented data in a clear, interactive format for easy interpretation and trend analysis.

Electric Vehicle Analysis

12/2025 - 01/2026

  • Analyzed EV data to track growth, range, and type (BEV/PHEV).
  • Built interactive Power BI dashboards to visualize trends by year, state, make, and model.
  • Highlighted EVs eligible for CAFV incentives for policy and adoption analysis.
  • Identified top EV brands and models in the market using data-driven insights.
  • Delivered actionable insights to support strategic EV adoption and market planning decision

Awards

Competed at state and national levels in badminton, representing Karnataka (India) as a VTU Blue's player in Inter-University tournaments.

Certification

Data Analytics Internship
09/2025 - 10/2025
IIM Skills

Work Preference

Job Search Status

Open to work

Salary Range

$70/yr - $200000/yr

Timeline

Code Instructor

Code Ninjas
10.2025 - 02.2026

Software Engineer/Data and Risk Analyst

LTIMindtree
10.2021 - 08.2024

Master of Technology - Computer Science and Engineering

New Horizon College of Engineering

Bachelor of Engineering - Computer Science and Engineering

Ballari Institute of Technology And Management
Kiran Mai Pallela