Kiran Mai Pallela - Code Instructor

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

years of professional experience

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

Websites

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