4+ Years Data Analyst - SQL, BI Dashboards

Hemanth Naga Vamsi Gunnam

Email: ******************@*****.***

Mobile: +1-914-***-****

LinkedIn: www.linkedin.com/in/vamsi-gunnam948778280 Business Analyst

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience delivering SQL, Excel, Power BI, and Tableau solutions, transforming complex datasets into dashboards, reports, metrics, and insights.

Translated business requirements into governed reporting solutions with data validation, reconciliation, documentation, and KPI definitions, strengthening trust in analytical outputs across cross-functional teams consistently.

Supported analytics initiatives through Python, SQL, ETL processes, and statistical analysis, identifying trends, variance drivers, and opportunities for operational improvement across enterprise reporting environments.

Partnered with stakeholders to develop self-service analytics, automate recurring reports, and present clear recommendations for data-driven decisions and process improvements across business functions effectively.

Executed strategic planning initiatives with minimal supervision, resulting in enhanced project alignment and increased efficiency across teams, which fostered improved productivity and collaboration towards common goals.

Delivered executive-ready presentations that effectively communicated leadership communications, leading to informed decision-making and strengthened relationships with stakeholders, ultimately driving team engagement and organizational success.

Facilitated collaboration across teams by employing strong leadership communications, which resolved conflicts and encouraged innovative solutions, significantly boosting overall team morale and performance in achieving project objectives.

TECHNICAL SKILLS

Data Analytics & BI - SQL, Power BI, Tableau, Excel, Power Query, Power Automate, Power Apps, Looker, Qlik, SAP BI, KPI design, ad-hoc analysis, dashboarding, self-service analytics

Process & Collaboration - Agile, Scrum, Kanban, JIRA, Confluence, Git, GitHub, stakeholder management, requirements gathering, UAT coordination

Programming & Statistical Analysis - Python, R, SAS, MATLAB, STATA, statistical modeling, regression, classification, clustering, time-series analysis, A/B testing, machine learning, NLP

Reporting & Productivity - PowerPoint, SharePoint, advanced Excel (Power Pivot, macros), documentation, executive reporting, storytelling decks

Data Engineering & Warehousing - ETL, ELT, dbt, Apache Airflow, data pipelines, data modeling, dimensional modeling, data warehouse, data marts, data lake, data quality, data governance

Cloud & Big Data Platforms - AWS, Azure, GCP, Hadoop, Spark, S3, Databricks

Databases - Snowflake, Amazon Redshift, Google BigQuery, Oracle, MySQL, PostgreSQL, SQL Server, MongoDB

Cybersecurity & Compliance - Identity Governance, OT Security, ICS Cybersecurity, Risk Management, Crisis Management

PROFESSIONAL EXPERIENCE

Capital One June 2025 – Present

Sr. Data Analyst McLean, VA, USA

Spearheaded crisis management initiatives by designing robust scorecards that provided real-time visibility into system health, enabling proactive incident response and achieving a 40% reduction in critical downtime across distributed services.

Architected comprehensive ICS Cybersecurity strategies that integrated Risk Management frameworks and established governance processes, achieving a 99.99% reduction in security incidents across operational technology environments.

Engineered a robust Identity Governance framework integrating OT Security protocols, enabling application engineering teams to derive actionable insights that enhanced security posture and compliance across critical infrastructure systems.

Designed SQL-driven data models and Power BI dashboards for Capital One reporting, improving KPI visibility, reconciliation accuracy, and executive insight across financial operations teams.

Engineered Python and Tableau analyses on complex datasets, identifying customer trends, risk indicators, and performance drivers that strengthened stakeholder decision-making across banking program reviews.

Standardized data validation, lineage documentation, and governance routines across SQL Server workflows, reducing reporting inconsistencies and improving confidence in analytical deliverables for operational stakeholders.

Automated recurring Excel and Power Query reports with documented quality checks, accelerating issue detection and improving operational visibility for daily business users across teams. Norton Healthcare January 2024 – May 2025

Data Analyst Louisville, KY, USA

Modernized user experience through operational effectiveness initiatives, enhancing system reliability and scalability which led to a 25% increase in user satisfaction scores across deployed applications.

Spearheaded executive decision-making processes in product management, driving continuous improvement initiatives that streamlined product engineering workflows and significantly reduced time-to-market for new features by 30%.

Integrated claims, clinical data, and operational metrics from relational databases, producing Tableau dashboards that improved healthcare reporting consistency for Norton Healthcare analytics program stakeholders.

Validated source-to-report pipelines with SQL, data profiling, and reconciliation controls, increasing reliability of recurring dashboards and regulatory reporting outputs across healthcare analytics operations teams.

Configured Power BI datasets, KPI definitions, and self-service views, enabling stakeholders to monitor utilization trends, quality metrics, and operational performance with improved reporting clarity.

Investigated data anomalies through SQL queries, root cause analysis, and documentation, resolving discrepancies that improved dashboard trust and audit readiness across healthcare analytics workflows. Tata Consultancy Services May 2021 – July 2023

Data Analyst Hyderabad, India

Consolidated reporting inputs and governance materials into a centralized dashboard, facilitating real-time visibility and decision-making that improved compliance audit readiness by 50% across all departments.

Optimized the cybersecurity technology portfolio by implementing performance reporting mechanisms that adhered to stringent reporting standards, resulting in a 40% increase in incident response efficiency across the organization.

Developed reusable SQL scripts, data mappings, and Tableau reports for IBM analytics projects, enhancing delivery consistency and simplifying performance reviews across client workstreams effectively.

Implemented ETL documentation, data cleansing logic, and QA checks across Snowflake and SQL workflows, improving readiness for dashboard deployments during enterprise agile delivery cycles.

Optimized Excel, Power Query, and Power BI reports, streamlining recurring analysis and helping stakeholders interpret metrics, trends, and operational exceptions with clearer stakeholder insights.

Documented business requirements, lineage, and reporting specifications in Jira and Confluence, improving collaboration, traceability, and handoff quality across analytics teams during agile project execution. EDUCATION

University of New Haven - Master's in Computer Science

Contact this candidate