Derek Lankeaux

Data analyst and applied statistician (M.S., Applied Statistics) with ten years of R and SAS programming across undergraduate and graduate statistical study — Base SAS, SAS/STAT, macro development, and PROC SQL applied to statistical analysis and automated reporting. Advanced production SQL on SQL Server — complex joins, window functions, stored procedures, and query optimization — supporting ETL interfaces, batch troubleshooting, and BI reporting on Linux. Translates complex, multi-source data into decisions stakeholders can act on.

AI Evaluation Analyst (Contract) - Handshake AI

(2025-11)

• Design evaluation rubrics and stratified sampling plans applied to 10,000+ daily model outputs, producing documented, reproducible scoring standards used by downstream teams.
• Build A/B testing frameworks and gold-standard acceptance criteria, translating ambiguous quality dimensions into measurable, auditable metrics.

Cloud Software Analyst - BRdata Software Solutions - Melville, NY

(2024-04 - 2024-11)

• Designed and executed complex SQL queries against SQL Server to extract, transform, and analyze large multi-source retail and operational datasets, translating stakeholder business questions into analytical deliverables.
• Optimized query performance and system reliability through schema redesign, indexing strategy, and stored-procedure refactors — reducing query latency 10% and improving reliability 20%.
• Built and maintained ETL data interfaces integrating SQL Server with cloud architecture; troubleshot batch processing failures and traced recurring data and process issues to root cause, documenting durable fixes that improved reporting accuracy.
• Developed REST API endpoints and validation test suites supporting downstream BI and dashboard consumption, preventing data-quality regressions across releases.
• Delivered a natural-language query interface over the relational database reaching 90% query accuracy, enabling nontechnical business users to self-serve analytics without SQL.
• Gathered requirements directly from non-technical clients and converted ambiguous business needs into documented technical specifications and data definitions, managed through JIRA and Confluence.

Mathematics Instructor - Huntington Learning Center - Huntington, NY

(2021-10 - 2023-12)

• Taught statistics and quantitative methods to 30+ students, breaking down technical concepts for non-technical audiences — raising standardized scores up to 150 points while maintaining a 95%+ satisfaction rating.
• Tracked and analyzed individual performance data to design targeted interventions, mentoring students through progressive skill development.

Master of Science - Applied Statistics - Rochester Institute of Technology

Bachelor of Science - Applied Mathematics & Statistics - Stony Brook University