Data Analytics & BI Business Analyst

Teja Gonugunta

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

Mobile: +1-737-***-****

LinkedIn: www.linkedin.com/in/gon-teja-9b4633421/

Business Analyst

PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience translating complex datasets into dashboards, reporting solutions, KPI insights, and stakeholder-ready recommendations across business operations and finance.

Experienced in SQL, Python, Excel, Power BI, Tableau, and Snowflake, delivering validated analyses, automated reporting, and reliable metrics for decision-making across functional stakeholder groups.

Skilled at requirements gathering, data modeling, ETL/ELT support, data quality checks, and visualization design to improve reporting consistency and analytical trust for business teams.

Adept at partnering with finance, operations, sales, healthcare, and compliance teams to translate business questions into scalable insights and documented solutions with measurable value.

Demonstrated minimal supervision by independently managing multiple projects, resulting in improved productivity and efficiency across teams while ensuring alignment with organizational goals and objectives.

Delivered executive-ready presentations to stakeholders, effectively communicating strategic initiatives and fostering collaboration that led to enhanced decision-making and stronger team alignment on key projects.

Created concise decision-ready presentations that provided actionable insights, enabling leadership to make informed choices quickly, which resulted in a significant boost in project turnaround times and overall operational efficiency. TECHNICAL SKILLS

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

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

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

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

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

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

PROFESSIONAL EXPERIENCE

Capital One October 2025 – Present

Sr. Data Analyst McLean, VA, USA

Spearheaded Crisis Management initiatives that reduced incident response times by 30%, implemented automated monitoring solutions, and enhanced system reliability, achieving 99.99% uptime across all critical services in production environments.

Orchestrated reporting standards that improved executive communications, leading to a 25% increase in clarity and actionable insights derived from performance metrics across multiple business units.

Revolutionized performance reporting mechanisms by integrating automated reporting inputs, achieving a 45% reduction in manual effort while enhancing data accuracy and timeliness for operational reviews.

Architected solutions for executive decision-making processes, leveraging application engineering best practices to streamline workflows, which resulted in a 50% faster turnaround on critical project approvals.

Spearheaded OT/ICS Cybersecurity initiatives by implementing advanced Identity Governance frameworks, resulting in a 30% reduction in unauthorized access incidents and enhancing overall system integrity across critical infrastructure.

Analyzed financial datasets with SQL, Python, and Excel, identifying KPI trends that strengthened reporting accuracy and improved stakeholder decisions across operations and finance portfolios.

Designed Power BI and Tableau dashboards from Snowflake data models, presenting executive metrics that improved visibility into performance, risk, and business outcomes for leaders.

Automated recurring reports through SQL Server, SSIS, and Power Query, reducing manual reconciliation effort and improving consistent delivery for business partners across reporting cycles.

Validated data quality with UAT, QA checks, and documented governance rules, increasing trust in dashboards, regulatory reporting, and analytical recommendations for cross-functional stakeholder teams. Johnson & Johnson January 2024 – September 2025

Data Analyst New Brunswick, NJ, USA

Implemented governance processes and scorecards that tracked compliance metrics, resulting in a 50% reduction in regulatory penalties and enhancing the organization’s risk posture significantly.

Streamlined operational effectiveness initiatives focused on user experience enhancements, resulting in a 30% increase in user satisfaction scores and a significant decrease in support ticket volumes.

Consolidated product management strategies with operational stakeholders, driving a 35% improvement in cross- functional collaboration and accelerating product delivery timelines by implementing agile methodologies.

Engineered executive-ready reports that integrated cybersecurity technology portfolio insights, enabling C-suite stakeholders to make informed decisions, which improved strategic alignment and investment prioritization by 25%.

Integrated healthcare and compliance data from EHR, ERP, and CRM systems, delivering SQL datasets that improved reporting consistency for analytics teams and operations leaders.

Standardized Power BI dashboards, KPIs, and data definitions, aligning stakeholders around reliable metrics that improved supply chain visibility and quality improvement decisions across teams.

Configured data validation workflows with Excel, VBA, and Alteryx, strengthening data integrity and supporting accurate compliance, operational, and healthcare analytics for enterprise business teams.

Translated requirements gathering sessions into Tableau reports, metadata documentation, and stakeholder-ready insights, improving transparency across product, finance, and operations questions for business decision makers. EY May 2020 – July 2023

Data Analyst Hyderabad, India

Streamlined workstreams and programs through process automation, eliminating 60+ manual hours weekly while improving project delivery speed and operational efficiency across teams.

Modernized leadership communications through strategic planning frameworks that aligned technical roadmaps with business objectives, improving stakeholder engagement and project visibility by over 40%.

Pioneered governance materials for senior leadership that standardized compliance processes, leading to a 20% reduction in audit findings and reinforcing organizational accountability and transparency.

Optimized OT Security protocols through comprehensive Risk Management assessments, achieving a 40% decrease in vulnerability exposure and significantly enhancing the resilience of operational technology environments.

Engineered ETL/ELT logic with dbt, Airflow, and Snowflake, transforming complex client data into trusted datasets for audit-ready business intelligence and reporting program delivery success.

Optimized SQL, Python, and Power BI solutions for multi-source analysis, improving metric traceability, documentation, and delivery quality across consulting engagements and client delivery needs.

Documented data lineage, governance controls, and semantic layers in Confluence, enabling clearer handoffs, stronger audit readiness, and reusable analytics delivery across distributed engagement teams.

Evaluated dashboard performance with Looker, MicroStrategy, and Jira backlog reviews, prioritizing enhancements that improved user adoption and insight delivery for client stakeholders and teams. EDUCATION

Master's in Information Technology Management - Webster University

Contact this candidate