Back to Developers
Shiva

Shiva

Business Analyst

Hyderabad, India
85
Profile Score

About

Analytical professional with 7+ months of experience in business analytics, operational reporting, and data-driven insights. Proficient in SQL, Python, Advanced Excel, and Power BI for ETL automation, KPI tracking, and dashboard development. Demonstrated ability to improve efficiency by 70%, achieve 96% compliance, and deliver actionable insights supporting strategic decision-making.

Skills & Expertise (21)

Advanced Excel Intermediate
7.3/10
0.5
Years Exp
Power BI Intermediate
7.0/10
0.5
Years Exp
SQL Intermediate
7.0/10
0.5
Years Exp
Python Intermediate
6.8/10
0.5
Years Exp
ETL automation Intermediate
6.5/10
0.5
Years Exp
Clear Insight Presentation Attention to Detail stakeholder communication Problem-solving Analytical Thinking Process Optimization Growth Opportunity Identification Operational Data Analysis Automated Reporting MIS & KPI Tracking Data Integration Data Validation & Quality Exploratory Data Analysis (EDA) Business & Product Analytics Dashboard Development KPI Tracking

Work Experience

Business Analyst

1Cell.Ai

Jul 2025 - Present

Automated daily sales reporting and incentive calculations for 50+ sales representatives using Advanced Excel (VLOOKUP, INDEX-MATCH, Pivot Tables) and Python ETL scripts, processing 10,000+ transaction records monthly, eliminating 15-20% duplicates, and reducing manual calculation time by 70% through rule-based eligibility engine. Analyzed laboratory operations data using SQL queries (JOINs, aggregations, window functions) to monitor TAT across 1,200+ monthly samples, achieving 96% compliance with 12-day SLA and reducing average TAT by 18% through root cause analysis and process optimization. Designed 12+ interactive dashboards in Power BI and Zoho Analytics with 20+ DAX measures tracking revenue performance across 5 regions and 25+ product lines, enabling data-driven insights on MoM/YoY growth, target achievement, and sales rep productivity for 15+ stakeholders. Built automated data pipelines generating 8+ derived fields (market segmentation, regional codes, product categories) with data quality validation and cleansing ensuring accuracy across multi-source datasets. Collaborated with cross-functional teams to translate business requirements into analytical solutions, conducting EDA to identify operational trends, bottlenecks, and growth opportunities supporting strategic decision-making.

Education

Bachelor of Science (Data Science) - Pragati Mahavidyalaya Degree College, Osmania University

- 2023 · Afghanistan

Certifications

Data Science Bootcamp

UpGrad · 2024

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 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceFeb 2026

Skills (21)

Advanced Excel Power BI SQL Python ETL automation Clear Insight Presentation Attention to Detail stakeholder communication Problem-solving Analytical Thinking +11 more