Osvaldo Pelaez

Data Analyst with experience rebuilding manual data processes into automated data pipelines and turning complex data into BI dashboards and reports leadership relies on. Hands-on experience with database querying and management, multiscript data automation, financial forecasting models, and BI dashboard development. Core tools include are SQL, Python, Power BI, and advanced Excel, with an emphasis on data accuracy and building solutions that hold up over time. Bilingual in English and Spanish.

Operations Analyst at RAS LaVrar – Law Firm (2026-01 – Present)

• Redesigned how the firm reconciles client inventory, replacing a monthly manual process with an automated Python and SQL solution that reduced processing time by over 95% while improving match accuracy and consistency.
• Maintain and update multi-script automation pipelines that import, parse, and validate vendor data through FTP and file-based integrations, covering exception detection, deduplication, and automated report generation across several states.
• Manage and query enterprise databases through SQL and ODBC to extract, validate, and reconcile records across systems, tracing discrepancies to root cause and documenting the fix so the issue does not resurface.
• Developed BI dashboards serving distinct operational purposes that are actively used by senior leadership and department managers to monitor performance, production, and pipeline status.
• Maintain machine learning financial forecasting models supporting several major financial portfolios, consistently projecting outcomes within a 10% accuracy margin to guide monthly planning.
• Identified a gap in how the firm evaluated account strategy, scoped and built the analysis independently, and delivered findings that leadership adopted to shape company direction.
• Present analytical findings to executive leadership on a recurring basis, translating technical results into recommendations non-technical stakeholders can act on.

Data Analyst Intern at Florida Crystals Corporation (2025-06 – 2025-08)

• Built Power BI and Excel dashboards tracking operational KPIs for management teams.
• Developed R scripts for scheduling and resource allocation, improving departmental efficiency.
• Validated data and authored technical documentation to support knowledge transfer across teams.

B.S. in Data Science, Minor in Statistics – University of Central Florida (2025-12)