Headline

Data Analyst | BI Analyst | Excel, SQL, Python | 40% Process Automation Impact

About

I build dashboards and reports that leadership actually uses to make decisions — not ones that get opened once and forgotten. Diagnosed a follow-up SLA gap behind a falling conversion metric at Sujay's Dental Care, delivering a fix that lifted conversion 1-2% Deployed automated analytics infrastructure across 4 business functions (Dental Lab, Assistant Performance, Clinical Ops, HR) using SQL, Google Sheets, and App Script Automated 8+ recurring reports using Power BI, Looker Studio, and Advanced Excel — cutting manual effort 40% and turnaround time 15%

Location

Greater Bengaluru Area

AI stack

claude

gemini

ChatGPT

Julius AI

Work experience

Marketing Analyst at Sujay's Dental Care, Nov 2024 - Present · 1 y 10 mo, Bengaluru, • Own MIS reporting end to end, maintaining 4 dashboards on daily, weekly, and monthly cadences for leadership review • Deployed automated analytics infrastructure across SQL, Google Sheets, and App Script spanning 4 business functions (Dental Lab, Assistant Performance, Clinical Operations, HR) • Built dashboards supporting 4 recurring reporting workflows across business units • Automated 8+ recurring reports using Power BI, Looker Studio, and Advanced Excel, cutting manual reporting effort 40% and turnaround time 15% • Diagnosed a follow-up SLA gap behind a drop in conversion metrics, delivering a recommendation that lifted conversion 1-2% • Managed stakeholder relationships across Clinical Ops, Dental Lab, and HR, running 3 requirements-gathering cycles across 3 stakeholders • Built an operatory timetable system that reduced scheduling conflicts across 7 operatories Delivered weekly trend and variance analysis across 5-6 KPIs in each of 4-5 recurring reports for management revie

Personal goal pursuit at Career Break, Oct 2022 - Oct 2024 · 2 y, Bengaluru, Karnataka, I took some time off to focus on my well-being and personal development. This time away made me more self-aware and confident, preparing me to take on new challenges. I'm incredibly excited about the opportunities ahead and I am actively searching for opportunities in the Analysis field

Data Analytics Intern at Henry Harvin, Mar 2022 - Apr 2022 · 2 mos, Remote, ● Completed 3 Python-based data analysis projects using pandas, NumPy, Matplotlib, Scikit-Learn, and Seaborn — covering data cleaning, EDA, visualization, and predictive modelling. ● Built 3 comprehensive case studies spanning diverse domains, applying end-to-end analytics workflows from raw data ingestion to insight presentation. ● Developed proficiency in translating analytical findings into clear visual narratives using Matplotlib and Seaborn.

Programmer Analyst at Cognizant, Jul 2019 - Dec 2020 · 1 yr 6 mos, Bangalore Urban, Karnataka, India, • Designed and executed 10+ detailed test scenarios for critical project modules, ensuring comprehensive unit test coverage and reducing pre-release defect rates. • Co-developed an automation tool that improved unit testing efficiency by 20%, accelerating QA cycles and reducing repetitive manual testing effort. • Authored technical design documentation for 10 project modules, adopted as the standard reference across a cross-functional engineering team.

Education

Master of Business Administration - MBA, Business Analytics, B. M. S. College of Engineering

Bachelor of Engineering, Information science and engineering, Dayananda Sagar Academy Of Technology And Management, Bangalore

Public links

github: https://github.com/Ksheeraja-Prasad