P vamsi kishore

Associate Consultant

Hyderabad, Telangana, India8 yrs 10 mos experience

Highly Stable

Key Highlights

Designed impactful dashboards for healthcare programs.
Led data-driven initiatives improving project efficiency by 25%.
Expert in advanced Excel and Power BI analytics.

Stackforce AI infers this person is a Data Analytics professional with expertise in Healthcare and Finance sectors.

Contact

Skills

Core Skills

Data AnalyticsBusiness Intelligence (bi)FinanceOperations Management

Other Skills

Power BI Dashboard DevelopmentSQL & Data TransformationData Modeling & DAXPower Query (ETL Automation)Advanced ExcelPower BISQLData VisualizationMicrosoft Power QueryData AnalysisData CleaningMicrosoft ExcelFinancial ReportingExcelManagement Information Systems (MIS)

About

I bring over 8+ years of experience as a Data Analyst and MIS Specialist across diverse domains, including the Public Health Sector, Insurance, and Finance & Accounts. I have a strong understanding of operational workflows and excel in designing reports and dashboards tailored to client and organizational needs, enabling data-driven decision-making. My expertise includes managing large datasets, leveraging data analytics tools to evaluate key performance indicators, extract actionable insights, and support strategic initiatives. I have successfully led sections of projects independently, worked closely with senior government officials, and served as the primary point of contact for client communications and deliverables. 🥇Skills: - ✔Advance Excel ✔PowerPoint Presentation ✔Power BI Dashboard Development ✔Data Modeling & DAX ✔Power Query (ETL Automation) ✔VBA ✔SQL & Data Transformation ✔Cross-Functional Collaboration

Experience

8 yrs 10 mos

Total Experience

2 yrs 2 mos

Average Tenure

Current Experience

Primus partners india

Senior Consultant - Data Analyst

Dec 2021 – Aug 2025 · 3 yrs 8 mos · Vijayawada, Andhra Pradesh, India · On-site

Designed a state-level dashboard for the NCD-CD program to monitor hypertension and diabetes screening/treatment for 5 crore+ citizens, reducing manual analysis time by ~1 hour for the NCD-CD team.
Developed interactive Power BI reports and Dashboards with custom tooltips, visuals, AI insights, and dynamic card titles & Bookmarks—streamlined reporting workflows, enabling the timely achievement of 18 DLRs within the target period.
Wrote 20-25 daily SQL queries to analyze patient and citizen health data, using joins, filters, and aggregate functions to support real-time program monitoring.
Applied advanced Excel formulas and DAX functions (e.g., CALCULATE, ITERATOR functions, FILTER and other key functions) to create high-performance analytical reports and dashboards to improve data analysis speed significantly.
Successfully implemented hierarchical Row-Level Security (RLS) to allow data access and permissions for Program officers, overcoming typical implementation challenges.
Created a state-wide Patient Experience Feedback dashboard, enabling health facilities to access and download service performance data within 10 minutes.
Designed and presented stakeholder decks, transforming 4–5 pages of data into 2 visually engaging PowerPoint slides using infographics and icons for clear communication.
Streamlined data collection, stakeholder coordination, and performance tracking, achieving a 25% boost in project efficiency and timely delivery of key health outcomes and DLRs.
Developed Requests for Proposals (RFPs) for project proposals and delivered MS Office suite training to client-side employees.

Power BI Dashboard DevelopmentSQL & Data TransformationData Modeling & DAXPower Query (ETL Automation)Advanced ExcelData Analytics+1

Absolute barbecues india

Data Analyst - Dy Manager

Feb 2021 – Nov 2021 · 9 mos · India

Collected, cleaned, and validated sales data for 48 outlets with 95% accuracy. Because we designed a template for obtaining the data, which saves a significant amount of time for data cleaning.
Designed Power BI data models, reports, and DAX measures (Time Intelligence & Iterator functions) for Sales 15+KPIs tracking, contributing to an increase in quarterly sales growth.
Create workforce dashboards for headcount, attrition, diversity, and employee engagement metrics – with this dashboard, enable leadership with real-time insights for faster decision-making.
Build an employee variable pay system linked to sales and employees’ performance, boosting sales by ~2-4% each outlet per month.
Use historical data to forecast sales, identify seasonal trends, and support strategic planning to the Operations team. 80% accurately given the forecast report.

Power BIMicrosoft Power QueryData AnalysisData Analytics

The akshaya patra foundation

Sr. Executive Accounts and Finance (Analyst)

Sep 2017 – Feb 2021 · 3 yrs 5 mos · Hyderabad Area, India · On-site

Created automated Excel dashboards using functions like VLOOKUP, INDEX-MATCH, SUMIFS, and conditional formatting to track real-time financial metrics.
Analysed financial data to identify trends and cost optimization opportunities.
Supported audits, reconciliations, and forecasting activities.
Planned and maintained advanced Excel dashboards and automated reports (Power Pivot) for real‑time financial insights like variance analysis, comparative analysis, and forecasting.
Built Cost-Per-Meal report for 52L+ meals FY, using Excel (PivotTables, Power Query, SUMIFS), reducing cost by ~1Rs Per Meal through better resource allocation
Created and presented Budget‑vs‑Actual reports for ₹23.50Cr budgets for all the resources, identifying up to ~3.5% variances and enabling corrective actions to improve budget adherence

Microsoft ExcelData AnalysisFinancial ReportingFinance

Max life insurance company limited

Operations Executive

Sep 2016 – Sep 2017 · 1 yr · Hyderabad, Telangana, India · On-site

Prepared MIS reports on sales, claims, and customer service metrics, which include 15+KPIs.
Coordinated with underwriting and finance teams for process efficiency.
Automated report preparation using Excel (Power Query & VBA), cutting manual effort from 30-45 minutes to 15 minutes. Just clicking the refresh and run button.

Microsoft ExcelManagement Information Systems (MIS)Operations Management