Professional Summary

Data Analyst with hands-on experience in financial analysis, data visualization, and business strategy. Strong foundation in SQL, Tableau, Excel, and Python. Created a full business plan and predictive financial models during a capstone project, demonstrating ability to translate data into actionable business insights. Skilled in stakeholder communication and real-world problem solving in legal and financial environments.

Skills
Technical Tools

SQL, PostgreSQL, MongoDB, Excel (PivotTables, VBA, Macros), Tableau, R, Python (pandas, matplotlib), PowerPoint, Google BigQuery

Business Analysis and Strategy

Requirements gathering, SWOT analysis, risk assessment, stakeholder engagement, strategic planning, SDLC knowledge.

Communication and Documentation

Technical writing skills, translating technical jargon to stakeholders, business writing, presentation skills.

Financial and Operational Insight

Variance analysis, cash flow optimization, credit risk analysis, financial reconciliation, process improvement.

PROFESSIONAL EXPERIENCE
Our Nevada Judges, Las Vegas, NV
Data Analyst, Jan 2025-Present
  • Tableau & Python: engineered judicial dashboards to surface trends in case outcomes.
  • Analyzed multi-year jurisdictional datasets; informed model design and statistical reporting logic. Developed prototype statistical models to support predictive analysis of court behaviors and performance indicators ahead of a May 2025 analytics module release.
  • Partnered with developers and product stakeholders in agile sprints to translate analytical requirements into scalable front-end features, ensuring technical feasibility and alignment with user experience goals.
  • Audited existing datasets for consistency and integrity, implementing quality
Technoir Group, Las Vegas, NV
Staff Accountant, Aug 2024-June 2025
  • Analyzed financial statements to identify trends and forecast performance, improving reporting accuracy by 60%.
  • Built Excel models (PivotTables/VLOOKUP/INDEX-MATCH) to improve forecast accuracy from 70% to 88%.
  • Automated reconciliations in Excel (VBA), cutting processing time 30% and improving data quality.
  • Led monthly variance analysis across 12+ accounts; identified drivers that reduced expenses 8% quarter-over- quarter.
Career Break
Family Care, 2017-2022

Pursued part-time Computer Science studies at Fort Hays State University (20 courses; see Education), including Web Development (HTML/CSS/JavaScript) and MIS.

HGS Digital, Chicago, IL
Accounts Receivable Specialist, Jan 2009-Aug 2017
  • Analyzed financial performance and improved cash flow by 15%, reducing outside financing reliance by 12%
  • Reduced processing time by 40% through workflow optimization
  • Collaborated with sales to implement Salesforce solutions, improving contract compliance by 80%
  • Maintained customer dispute logs and improved financial reporting accuracy
PROJECTS
Capstone Project - InfoTech Consulting LLC, Feb 2025
  • Developed a comprehensive business plan for a data consulting startup, InfoTech.
  • Conducted industry research, SWOT analysis, and built dashboards for business intelligence services.
  • Created tiered pricing models and financial forecasts using Excel and Tableau.
  • Integrated KPIs and automation strategies into a business growth framework.
PostgreSQL Project - EcoMart, May 2025
  • Designed relational database from raw data for e-commerce business.
  • Design Process Video: https://vimeo.com/1081363542/bea5a5d5c0
MongoDB Project - HealthFit Consulting, Jul 2025
  • Designed NoSQL database from raw data using MongoDB, health tracker project (Python, JavaScript, MongoDB Query Language, MongoDB Aggregation Pipelines).
  • Analyzed healthcare data to identify trends and insights, informing business decisions and driving strategic growth.
  • Design Process Video: https://vimeo.com/1101080044/6d02eeb9ff
EDUCATION
  • Master of Science, Data Analytics (In Progress), Western Governors University, Projected Apr 2026.
  • Bachelor of Science, Information Technology Management, Western Governors University, Feb 2025 (studied 2022 – 2025).
  • Fort Hays State University - Computer Science track; 20 courses completed (non-degree study) 2017 – 2021. Relevant coursework: Web Development (HTML, CSS, JavaScript), Management Information Systems (MIS), Systems Analysis & Design (SDLC), Statistics, Business Calculus, Financial Accounting, Managerial Accounting.
CERTIFICATIONS
  • Google Data Analytics Professional Certificate, Mar 2025.
Nginx
HTML 5

©2025 Joanna Ronchi

Version: 0.1.0

LinkedIn
Facebook