Andrew M. Aranda

Turning Complex Data into Stories That Drive Action

Government service1yrU.S. Department of Education (ED)

About

I’m Andrew Aranda, a dynamic and results-driven data strategist with a passion for turning complex datasets into clear, actionable insights that drive business growth and strategic decision-making. With progressive experience in analytics, visualization, and program management, I specialize in designing automated solutions that enhance financial transparency, optimize workflows, and forecast risks for long-term planning.

💡 What I Bring to the Table

🔹 Data Analytics & Visualization: Skilled in extracting, cleaning, and transforming data into compelling dashboards and reports that empower stakeholders with clarity and confidence.

🔹 Program Oversight & Compliance: Experienced in monitoring loan and grant programs, ensuring regulatory adherence, and safeguarding program integrity through rigorous analysis and reporting.

🔹 Risk Modeling & Strategic Forecasting: Adept at scenario modeling and trend analysis, providing forward-looking insights to guide policy decisions and mitigate risks effectively.

🔹 Cross-Functional Collaboration: Proven ability to work across operations, litigation, and monitoring divisions to align analytics with business goals and enhance stakeholder engagement.

Key Projects:

• Developed Power BI dashboards and user-friendly training tools that improved financial tracking and transparency across departments.

• Delivered recurring compliance and performance reports to senior leadership, identifying key risk areas and driving continuous program improvements.

My areas of expertise include:

• Data Mining & Extraction

• Dashboard Development & Data Visualization

• Risk Analysis & Scenario Modeling

• Regulatory Compliance & Program Management

• Workflow Optimization & Data Quality Assurance

• Strategic Planning & Policy Support

Let’s connect—I'd love to explore how my expertise can help your organization harness the power of data to make smarter, faster, and more informed decisions.

Roles

Oct 2024–Oct 2025
Former role

Senior Management & Program Analyst

U.S. Department of Education (ED), Analytics & Infrastructure Division

California

Data AnalystData Scientist

Conducted thorough reviews of loan and grant programs across litigation, operations, and monitoring divisions in line with federal regulations. Created Power BI dashboards and user-input training tools aimed at improving financial tracking, transparency, and accountability across departments. Performed scenario modeling and trend analysis to forecast program risks, enabling data-driven policy decisions and informed long-term strategic planning. Monitored debt repayment compliance, safeguarded program integrity, and ensured adherence to regulatory standards. Generated recurring compliance and performance reports for senior leadership, while identifying key risk areas and opportunities for program improvement.

Notable Accomplishments:

  • Rebuilt legacy reporting system, using Python backend and Power BI frontend, streamlining operations and reducing manual effort by 75%, enabling analysts to focus on high-value compliance and strategic decision support.

  • Streamlined litigation data requests by standardizing borrower records across multiple systems and achieved faster, more accurate responses to stakeholders.

  • Developed SQL and Excel automation pipelines, processed 10K+ borrower records, minimized turnaround time from days to same-day delivery, and reduced manual errors by 90%.

Key Projects

  • Conducted multi-year scenario modeling on borrower defense claims and repayment trends, guiding leadership on resource allocation and program optimization.

  • Automated litigation and compliance reporting processes, enabling leadership to identify systemic risks and enhance review procedures for improved oversight.

  • Applied federal program evaluation methods, including scenario modeling and repayment forecasting, to draw parallels with municipal housing and financial policy analysis.

  • Designed interactive dashboards for training reimbursements, empowered managers with control over ranges and scenarios, and boosted repayment accountability and financial transparency.