Summary
Overview
Work History
Education
Skills
Projects
Extracurricular Activities
Timeline
Generic

ARYAN KAKRAN

New Delhi

Summary

Results-driven Analyst with hands-on experience in data analysis, performance monitoring, and cross-functional collaboration. Proven ability to extract actionable insights from structured and unstructured data using SQL, AWS CloudWatch, and Kibana. Adept at visualizing KPIs, optimizing system operations, and supporting testing lifecycles. Seeking data/business analyst roles to leverage analytical expertise and technical proficiency in driving business outcomes.

Overview

3
3
years of professional experience

Work History

Technical Support Analyst

Salescode.ai
Gurgaon
07.2024 - Current
  • Analyzed application logs and user behavior using AWS CloudWatch, Kibana, and Firebase, delivering actionable insights to engineering and business teams.
  • Collaborated with cross-functional teams to support log analysis, identify trends, and drive improvements in product functionality.
  • Developed real-time dashboards and alert systems for monitoring app hits and user activity using Slack, improving response time by 30%.
  • Partnered with engineering and QA teams to validate new features via SIT and UAT, to flag anomalies in real time using Jenkins and Jira.
  • Acted as the primary interface for issue triaging and root cause analysis, contributing to faster MTTR.

Business Analyst Intern

iSource
Delhi
09.2023 - 11.2023
  • Conducted stakeholder meetings, created functional documents, wireframes, and documented end-to-end process flows.
  • Collaborated with dev and QA teams to ensure clarity on scope and requirements, accelerating delivery cycles by 20%.
  • Supported testing and defect tracking for feature releases, contributing to comprehensive UAT documentation.
  • Developed training materials that enabled users to become proficient in using new systems quickly.

Team Lead

Amazon Ops
New Delhi
08.2022 - 09.2022
  • Oversaw last-mile logistics operations, optimizing delivery performance by 2% through effective resource planning.
  • Built monthly KPI dashboards using Power BI and Google Sheets, allowing leadership to monitor and compare operational metrics.
  • Coordinated between hub teams and management to ensure adherence to delivery SLAs and continuous improvement efforts.

Education

Bachelor's of Technology (B.Tech) - Electronics and Communication

KIET Group of Institutions
07-2023

High School Diploma -

S.D. Public School
03-2019

Skills

  • Data analysis: SQL (MySQL), Excel, (dashboards, pivot tables, VLOOKUP)
  • Monitoring and visualization: AWS CloudWatch, Power BI, Google Sheets, Kibana, Firebase
  • C Programming and Python
  • Tools and methodologies: JIRA, Jenkins, Agile/Scrum, Slack, Git
  • Testing and documentation: STLC, SDLC, UAT, SIT, requirement gathering, wireframing

Projects

Superstore Sales Analytics - Personal Project, Oct - Nov 2023

Utilized SQL to extract and manipulate sales data across multiple tables (JOIN, VIEW) and performed EDA in Python, built visual dashboards and generated insights on customer segmentation, product trends, and profitability.

Face Detection Based Elevated Parking - KIET Institute, 2022 - 2023

Designed a smart parking system using facial recognition with >95% accuracy, published research paper at AMU’s International Conference PIECONE-23.

Analyst Portfolio Website - Personal Web Project, ongoing, designed and deployed a personal portfolio at aryan2908.github.io showcasing projects related to SQL, data analytics, and visualization, integrated GitHub-hosted notebooks, dashboards, and case studies to highlight practical skills for analytics roles, built using HTML, CSS, GitHub Pages, and customized to reflect personal branding and analytical storytelling.

Extracurricular Activities

Sports Lead - Organized and managed KIET’s Annual Sports Fest “Spardha-22” 

Student Placement Coordinator - Represented ECE department in campus drives.

Volunteer - Uddeshya NGO (College Student-led initiative for community welfare)

Timeline

Technical Support Analyst

Salescode.ai
07.2024 - Current

Business Analyst Intern

iSource
09.2023 - 11.2023

Team Lead

Amazon Ops
08.2022 - 09.2022

Bachelor's of Technology (B.Tech) - Electronics and Communication

KIET Group of Institutions

High School Diploma -

S.D. Public School
ARYAN KAKRAN