Business-focused Data Analyst with 5 years of experience building trusted reporting, automating data workflows, and connecting complex datasets to decisions in finance, sales, healthcare, and operations.
I’m Vishnu Vardhan Penta, a Data Analyst with five years of experience across finance, healthcare, e-commerce, semiconductor, and rubber industry domains. I build Power BI dashboards, automate reporting, and use SQL and Excel to make large datasets accurate and useful for business teams.
Analyzed more than 2 million records and built dynamic dashboards for sales targets, conversion rates, regions, employees, and business domains. Automated recurring reporting gave teams a consistent view of performance and sales gaps while reducing repetitive manual work.
My role: Data extraction, analysis, KPI design, dashboard development, and report automation.
Consolidated SQL data for four businesses into a unified reporting model. Delivered consistent P&L, balance sheet, sales, cost, and MTD, QTD, and YTD views for management, finance, operations, board members, and customers. Migration validation supported reliable reporting.
My role: SQL consolidation, data modeling, DAX measures, reconciliation, and stakeholder reporting.
Prepared more than 100,000 customer records for downstream database and reporting processes. Automated spreadsheet cleaning and preprocessing, then validated and reconciled mapped data to improve consistency and reduce manual handling before upload.
My role: Data preprocessing, validation, mapping, rebate analysis, and Power BI reporting.
Developed operational KPI reporting that brought footfall, department-level revenue, target comparisons, and efficiency trends into view. Revenue forecasting and trend analysis supported informed financial and operational planning.
My role: KPI reporting, footfall and revenue analysis, trend analysis, and forecasting.
Accenture · Intel client
Exel Group · SPINMAX, EXEL, ACE, VILLAS
Yashoda Hospitals
Carbanio · B2B e-commerce
Power BI dashboards, data visualization, KPI reporting, DAX measures, Power Query transformations, and data modeling for clear, dependable business views.
SQL Server and MySQL for extraction, joins, aggregation, consolidation, and validation. ETL, data cleaning, mapping, reconciliation, and cloud migration support.
PivotTables, Power Pivot, XLOOKUP, VLOOKUP, and VBA macros for analysis, reconciliation, customer-file preprocessing, and repeatable reporting workflows.
Trend and variance analysis, financial and sales reporting, rebate calculations, forecasting, stakeholder requirement gathering, and translating findings into actionable insights.
Recurring report and workflow automation using Excel VBA, Google Apps Script, and Google Sheets to reduce repetitive manual steps and improve consistency.
Collaborating with finance, sales, operations, and technical teams; defining useful KPIs; documenting assumptions; and communicating analysis in business terms.
Python (basics), Microsoft Office 365, Excel add-ins, and reporting support for on-premises to cloud data migration.
MySQL for Data Analytics and Business Intelligence · Udemy
SQL Data Reporting & Analysis · LinkedIn
Advance Power BI · LinkedIn Learning
Business Analysis · Coursera
Microsoft Office 365 Tools · SRT Institute
Finance · Osmania University
Life Sciences · Osmania University