Back to Developers
Kalisetti Kiran

Kalisetti Kiran

Junior Analyst

Andhra Pradesh, India 80 · Excellent

About

Detail-oriented and analytical Junior Analyst with hands-on experience collecting, cleaning, and organizing data from multiple sources to identify trends, patterns, and business insights. Proficient in MS Excel (Formulas, Pivot Tables, Charts), SQL, and Power BI – skilled in preparing reports, dashboards, and performance metrics for senior analysts and stakeholders. Committed to data accuracy and consistency, maintaining clear documentation and reporting processes, and presenting findings in a clear and structured manner to support data-driven decision-making.

Skills & Expertise (45)

SQL Advanced
8.0/10
2
Years Exp
Data Cleaning Advanced
8.0/10
2
Years Exp
MS Excel Advanced
8.0/10
2
Years Exp
Problem-solving Advanced
8.0/10
2
Years Exp
Analytical Thinking Advanced
8.0/10
2
Years Exp
Attention to Detail Advanced
8.0/10
2
Years Exp
Power BI Intermediate
7.5/10
2
Years Exp
Data Warehousing Intermediate
7.0/10
2
Years Exp
ETL Intermediate
7.0/10
2
Years Exp
Statistical Analysis Intermediate
6.5/10
2
Years Exp
MySql T-SQL SQL Server Postgresql Trend Analysis Business Insights Customer Segmentation EDA NumPy Git GitHub SQLAlchemy Cross-Functional Collaboration Communication Documentation Subqueries Formulas Pivot Tables Charts Power Query VLOOKUP SUMIFS Countifs Joins Aggregations Seaborn Window Functions CTEs Stored Procedures Dashboards Performance Metrics KPI Reporting DAX Pandas Matplotlib

Work Experience

Junior Analyst

HR Analytics

Present - Present

Collected, cleaned, and organized a 2M-record employee dataset from multiple sources using Python (Pandas) and MS Excel – ensured data accuracy and consistency throughout; engineered analytical columns (attrition flag, experience level, salary band) to identify trends and patterns across departments and work modes. Assisted senior analysts by running 10 structured SQL queries (joins, aggregations, trend analysis) to prepare performance metrics and business insights – surfaced key findings: 29.92% attrition rate, IT leads exits (180K), Senior-level accounts for 204K attritions; maintained clear documentation of reporting processes throughout. Prepared dashboards and performance metrics reports using Power BI with slicers (department, work mode, experience, salary band) – presented findings in a clear and structured manner; revealed on-site workers drive 60% of total attritions, enabling cross-functional HR teams to make data-driven retention decisions.

Junior Analyst

Q-Commerce Sales & Delivery Performance Analytics

Present - Present

Collected and organized Q-commerce order data from multiple business sources – cleaned and validated data using Python and MS Excel (Formulas, Pivot Tables); identified trends and patterns in sales, delivery performance, and refund behavior; ensured data accuracy and consistency before analysis. Prepared reports, dashboards, and performance metrics using SQL and Power BI – identified through trend analysis that delivery delays directly correlate with lower ratings and higher refunds; presented findings in a structured manner to assist senior analysts and cross-functional teams in making data-driven operational decisions.

Junior Analyst

SQL Data Warehouse – Medallion Architecture

Present - Present

Collected and organized raw ERP and CRM data into a 3-layer Medallion data warehouse (Bronze – Silver – Gold) – built ETL pipelines using T-SQL stored procedures with data accuracy and consistency checks at each layer; maintained documentation of data processes and reporting structures to enable downstream business insights.

Junior Analyst

SQL Data Analytics – Sales Insights

Present - Present

Performed 13-stage SQL analysis to identify trends, patterns, and business insights – covered EDA, segmentation, cumulative trends, and part-to-whole reporting; used MS Excel (Pivot Tables, Charts, Formulas) to prepare and present performance metrics reports identifying top revenue contributors and monthly sales trends for senior stakeholders.

Education

Bachelor of Technology (B.Tech) – Computer Science - Rajiv Gandhi University of Knowledge Technologies

- 2027 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceJun 2026

Availability Details

Relocation

Not Open to Relocation