Business Analyst - Data Analytics & BI

Pavithra Rayala

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

Mobile: +1-302-***-****

LinkedIn: linkedin.com/in/rayalapavithra

Business Analyst

PROFESSIONAL SUMMARY

Data Analyst with 4+ years analyzing operational, financial, healthcare, and marketplace datasets through SQL, Python, Excel, dashboards, and stakeholder-focused reporting solutions for decision-making teams.

Skilled in building Tableau, Power BI, and Looker dashboards, validating data quality, documenting business logic, and presenting actionable insights to cross-functional stakeholders across programs.

Experienced with Snowflake, dbt, SQL Server, ETL pipelines, data modeling, reporting standards, and query optimization supporting reliable self-service business intelligence outcomes for operations teams.

Applies statistical analysis, trend analysis, root cause analysis, forecasting, and compliance-focused reporting to translate complex requirements into measurable business recommendations for leadership review cycles.

Demonstrated minimal supervision by independently leading a cross-functional team to achieve project milestones, resulting in enhanced collaboration and productivity while exceeding client expectations and delivering solutions ahead of schedule.

Delivered executive-ready presentations to stakeholders, effectively communicating complex strategies and actionable insights that drove informed decision-making and strengthened relationships, ultimately contributing to a 20 percent increase in project approvals.

Implemented continuous improvement initiatives that streamlined processes and fostered a culture of innovation, leading to significant efficiency gains and empowering team members to contribute ideas for enhancing operational effectiveness. TECHNICAL SKILLS

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

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

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

Data Warehousing - Star Schema, Snowflake Schema, Fact/Dimension Tables, ETL Pipelines, Data Modeling, OLAP Concepts

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

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

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

Uber January 2025 – Present

Data Analyst San Francisco, CA, USA

Streamlined technology portfolio management by integrating comprehensive reporting inputs into governance processes, achieving a 15% reduction in operational overhead and enhancing resource utilization across teams.

Pioneered Identity Governance solutions within OT Security frameworks, driving senior leadership engagement and achieving a 99.9% compliance rate with industry standards across all operational processes.

Engineered a comprehensive OT /ICS Cybersecurity framework, integrating advanced risk/crisis management protocols into application engineering processes, resulting in a 40% reduction in security incidents across critical infrastructure.

Analyzed marketplace operations data with SQL and Python, translating customer, product, and performance trends into dashboards that strengthened business decision-making visibility for reporting.

Optimized self-service reporting in Tableau and Power BI, validating KPIs across operational datasets and improving stakeholder access to timely performance insights for planning cycles.

Standardized data dictionaries and business logic within Snowflake and dbt, aligning metrics definitions across teams and improving consistency in recurring analysis deliverables for reporting.

Evaluated product experiments through A/B testing, segmentation, and statistical analysis, identifying customer behavior patterns that supported prioritized process improvements across marketplace operational planning efforts. Bank of America August 2023 – December 2024

Data Analyst Remote, USA

Optimized technology needs assessment through structured workstreams and detailed scorecards, facilitating informed decision-making that increased project success rates by 30% and improved resource allocation.

Modernized user experience through strategic planning initiatives, enhancing portfolio governance that resulted in a 35% increase in user engagement and a notable reduction in support ticket volume.

Spearheaded executive decision-making initiatives, enhancing operational effectiveness through strategic product management practices that increased project delivery speed by 30% and improved stakeholder satisfaction metrics.

Developed financial reporting dashboards with SQL, Excel, and Tableau, reconciling revenue, expense, and portfolio metrics to strengthen banking performance reviews for executive decisions.

Configured automated variance analysis workflows through Power Query and SQL Server, improving audit readiness and consistency across financial planning datasets for recurring compliances.

Assessed compliance and risk management data with SAS and Excel, identifying anomalies that enhanced control monitoring and supported accurate regulatory reporting across banking programs.

Reconciled General Ledger, profitability, and cost analysis extracts with SQL queries, producing validated datasets that improved finance stakeholder confidence during monthly close reporting cycles. Optum May 2021 – November 2022

Data Analyst Hyderabad, India

Consolidated governance materials and leadership communications, establishing performance reporting metrics that improved project visibility and accountability, resulting in a 20% increase in on-time project deliveries.

Orchestrated decision-ready presentations for operational stakeholders, facilitating cross-departmental liaisons that streamlined project alignment and boosted resource allocation efficiency by 25% across multiple engineering teams.

Engineered healthcare analytics dashboards in Tableau and Snowflake, monitoring claims, Medicaid, Medicare, and utilization metrics to improve clinical program visibility for operational decision makers.

Validated HIPAA-aligned clinical data with SQL and data quality checks, resolving reporting inconsistencies and strengthening accuracy for claims analytics workflows across healthcare stakeholder programs.

Modeled risk stratification and readmissions datasets through Python and statistical analysis, enabling clearer population health insights and measurable care management prioritization for program teams.

Automated recurring healthcare reports with dbt and Power BI, streamlining HEDIS, utilization management, and claims monitoring for reliable operational reviews across Optum stakeholder groups. CERTIFICATIONS

Google Data Analytics Professional Certificate

IBM Data Analyst Certificate

EDUCATION

Master's in Information Assurance - Wilmington University

Bachelor's in Electronics and Communication Engineering - JNTUH

Contact this candidate