Back to Developers
Sruthi Pinnaka

Sruthi Pinnaka

Business Analyst

Bangalore 4+ yrs exp 89 · Excellent

About

Results-driven Business Analyst with 4.8+ years of experience in data analytics, dashboard development, business intelligence, process automation, and stakeholder management. Proven expertise in transforming complex datasets into actionable insights through advanced analytics, visualization, and automation. Skilled in SQL, Python, Tableau, Power BI, Excel, and ETL workflows, with a strong track record of improving operational efficiency and enabling data-driven strategic decisions.

Skills & Expertise (24)

SQL Advanced
8.4/10
5
Years Exp
Tableau Advanced
8.3/10
5
Years Exp
Power BI Advanced
8.3/10
5
Years Exp
Python Advanced
8.1/10
4
Years Exp
ETL Pipelines Advanced
8.0/10
5
Years Exp
Joins Window Functions CTEs Advanced Formulas XLOOKUP VLOOKUP Power Query Pivot Tables Google Apps Script Google Sheets KPI Tracking Process Improvement RCA Requirement gathering Data Modeling Data Transformation Data Cleaning NumPy Pandas

Work Experience

Data Analyst / Business Analyst

Ola Electric

Feb 2025 - Feb 2026

Designed and deployed 10+ executive-level Tableau & Power BI dashboards, enabling real-time visibility into mission-critical KPIs and accelerating strategic decision-making by 20%. Automated 5+ manual reporting workflows using Python (gspread), SQL, and Google Apps Script, reducing processing time from 15 hours/week to under 30 minutes with zero manual error. Conducted business process analysis to identify inefficiencies, operational gaps, and optimization opportunities across departments. Partnered with cross-functional stakeholders to gather requirements and translate business needs into analytics solutions. Developed KPI monitoring systems and automated trackers using Excel, SQL, and Power BI. Built and maintained data pipelines for extraction, transformation, and reporting of structured/unstructured data. Performed root cause analysis to resolve data quality and reporting issues. Developed dashboards, trackers, and KPI monitoring systems using Excel (Pivot Tables, Power Query, VLOOKUP/XLOOKUP, advanced formulas) to track business performance.

Consultant / Data Analyst

Capgemini

Jun 2021 - Feb 2025

Built scalable reporting and analytics solutions for enterprise clients using SQL, Python, Tableau, and Power BI. Automated recurring data processing and reporting workflows, significantly improving operational efficiency. Developed optimized SQL queries and enhanced database/reporting performance for analytical workloads. Designed and maintained ETL/data pipelines for structured and unstructured enterprise datasets. Collaborated with stakeholders, QA teams, and development teams to deliver end-to-end analytics/reporting solutions. Provided production support and troubleshooting for dashboard/reporting environments. Documented technical workflows, business requirements, and automation processes. Created interactive and user-friendly dashboards to enable real-time business decision-making. Performed data validation and quality checks to ensure accuracy and consistency across reports. Utilized advanced SQL techniques (CTEs, window functions, joins) for complex data analysis.

Education

Bachelor of Technology (B.Tech) – Electronics and Communication Engineering - Jawaharlal Nehru Technological University, Kakinada

2014 - 2018 · 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 14/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 89/100

Profile Overview

Member sinceMay 2026