Summary
Overview
Work History
Education
Skills
Certification
Timeline
web
Anita Rao
Open To Work
Verified
This profile is verified using an email address.

Anita Rao

Irvine,CA

Summary

Results-driven data professional with strong foundation in data analysis and business intelligence. Known for transforming complex datasets into strategic business solutions while maintaining rigorous standards. Consistently fosters team collaboration and adapts seamlessly to dynamic project requirements, leveraging skills in SQL and Power BI to drive impactful outcomes.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Molina Healthcare, Inc.
Remote
05.2022 - Current
  • Deliver ad-hoc and recurring analytics for Marketplace, Medicaid, Medicare, and Duals lines of business using SQL (SSMS and Azure Databricks)
  • Design, develop, and deploy SSRS and Power BI dashboards supporting enrollment and operational reporting
  • Improve data accuracy and reporting reliability through validation of SQL logic and dashboard outputs across UAT and production environments
  • Collaborate with cross-functional stakeholders to define reporting requirements and enhance data accessibility
  • Provide code reviews and feedback, improving report quality and consistency across projects
  • Train and onboard new hires on reporting workflows and ticket management systems, accelerating team ramp-up
  • Leverage enterprise systems (QNXT, MEBS, MMW) to support data extraction, validation, and reporting initiatives

Data Processing Technician

Tustin Unified School District
Tustin, CA
10.2016 - 04.2022

Led district-wide data reporting and analytics initiatives supporting student performance, compliance reporting, and operational decision-making.

Key Contributions:

  • Developed KPI dashboards and reports for board presentations, analyzing enrollment, academic performance, and student outcomes across multiple data sources
  • Conducted in-depth analysis of CAASPP, graduation rates, attendance, and A-G requirements to support strategic planning
  • Automated and streamlined data processing workflows for SAT, PSAT, and AP datasets, reducing manual effort and improving data accuracy
  • Produced staff analytics reports (CBEDS-ORA, survey analysis) to support workforce planning and organizational insights
  • Built and maintained reporting for PBIS/MTSS programs, tracking discipline trends and student support metrics
  • Performed advanced Excel-based data transformations to reconcile student enrollment and transfer records
  • Supported district-wide stakeholders by resolving data/reporting requests and improving access to actionable insights

Market Risk Analyst

Pacific Summit Energy
Newport Beach, CA
09.2008 - 08.2010
  • Monitored gas and power market risk exposure and produced daily P&L reports for trading portfolios
  • Validated financial and physical transactions to ensure accurate representation in risk systems
  • Generated mark-to-market and value-at-risk reports supporting trading and risk management decisions
  • Developed SOPs for reporting processes, improving audit readiness and operational consistency
  • Performed historical price analysis and maintained databases to support forecasting and risk evaluation

Business Intelligence Analyst

Accredited Home Lenders
San Diego, CA
02.2004 - 12.2005
  • Produced recurring and ad-hoc reports on loan performance, broker productivity, and operational metrics
  • Designed and maintained BI reports and dashboards using Excel and database tools
  • Gathered and documented business requirements to support reporting and analytics initiatives
  • Developed SOPs and provided end-user support for reporting systems and tools

Education

Master of Science - Statistics

San Diego State University

Bachelor of Science - Management Science

University of California, San Diego

Skills

  • Data & BI Tools: SQL (SSMS, Azure Databricks), Power BI, SSRS, Advanced Excel
  • Analytics: Statistical analysis, KPI development, data validation, trend analysis
  • Data Management: Data modeling, data quality assurance, reporting automation
  • Process Improvement: Lean Six Sigma Yellow Belt, SOP & job aid development
  • Collaboration: Jira, stakeholder engagement, cross-functional support
  • AI Tools: Copilot for SQL optimization, logic validation, and trend summarization GitHub Copilot in SQL Server Management Studio 22 for writing and managing T-SQL queries Copilot AI agent creation

Certification

  • Google Digital Marketing & E-commerce Professional Certificate, Coursera - In Progress
  • Lean Six Sigma Yellow Belt, Molina Healthcare, Inc - 2025

Timeline

Senior Data Analyst

Molina Healthcare, Inc.
05.2022 - Current

Data Processing Technician

Tustin Unified School District
10.2016 - 04.2022

Market Risk Analyst

Pacific Summit Energy
09.2008 - 08.2010

Business Intelligence Analyst

Accredited Home Lenders
02.2004 - 12.2005

Bachelor of Science - Management Science

University of California, San Diego

Master of Science - Statistics

San Diego State University