Alonso Ortiz
Washington
Summary
Accomplished Data Analyst with a proven track record at the Commodity Futures Trading Commission, adept in Python programming and statistical analysis. Spearheaded the transformation of technical specifications into actionable insights, significantly contributing to key internal publications. Pursuing full-time role that presents professional challenges and leverages interpersonal skills, effective time management, and problem-solving expertise.
Overview
9
9
years of professional experience
Work History
Data Analyst
Commodity Futures Trading Commission
01.2024 - Current
- Led the conversion of Part 45 and Part 43 Guidebook and Technical Specifications into a Data Dictionary in Collibra,
- Created Excel documents to assist with pulling metrics data and presenting information.
- Used statistical methods to analyze data and generate useful business reports.
- Contributed to the publishing of the Office of the Chief Economist’s Treasury Cash-Futures Basis Trade internal paper by obtaining and converting Commodity Pool Operator Pool Quarterly Reports (CPO-PQR) and annual reports from the National Futures Association (NFA).
Economist
Bureau of Labor Statistics
08.2016 - 01.2024
- Generated Touch Tone Data Entry (TDE) non-response faxes with SAS to inform and persuade respondents to continue submitting employee data for monthly national unemployment rates.
- Monitored and updated daily Held Desk metrics used to generate monthly Call Center Report with a combination of Word, Excel, and IC Business Manager application.
- Created and updated documentation in Registry and Data Flows’ SharePoint to communicate the proper steps to follow.
- Generated yearly Current Employment Statistics Annual Sample Update report where the Registry branch communicates to the rest of the bureau the process of rotating the Unemployment Insurance (UI) units.
Education
Master of Science - Finance And Economics
West Texas A&M University
08-2021
Bachelor of Science - Economics
The University of Tampa
08-2016
Skills
- Python programming
- Structured query language (SQL)
- Predictive modeling
- Machine learning
- Regression Analysis
- Data analysis
- Data visualization and presentations
- Data cleaning
Languages
Spanish
Native or Bilingual
Timeline
Data Analyst
Commodity Futures Trading Commission
01.2024 - Current
Economist
Bureau of Labor Statistics
08.2016 - 01.2024
Master of Science - Finance And Economics
West Texas A&M University
Bachelor of Science - Economics
The University of Tampa
Similar Profiles
JonMarc BuffaJonMarc Buffa
Counsel to the Director of Enforcement for Cooperative Enforcement at U.S. Commodity Futures Trading CommissionCounsel to the Director of Enforcement for Cooperative Enforcement at U.S. Commodity Futures Trading Commission
Alonso OrtizAlonso Ortiz
Data Analyst at Commodity Futures Trading CommissionData Analyst at Commodity Futures Trading Commission
Anfrenee RandallAnfrenee Randall
Finance Intern at Commodity Futures Trading CommissionFinance Intern at Commodity Futures Trading Commission
SKYLER MCMURRAYSKYLER MCMURRAY
Executive Assistant at Office of the Assistant Secretary of the Army (Acquisition, Logistics & Technology)Executive Assistant at Office of the Assistant Secretary of the Army (Acquisition, Logistics & Technology)
Misty BellMisty Bell
Sales Manager at Hilton CorporationSales Manager at Hilton Corporation