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. Excelled in visual data representation and report writing, showcasing exceptional analytical and communication skills.
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
Canyon, TX08-2021
Bachelor of Science - Economics
The University of Tampa
Tampa, FL08-2016
Skills
- Data formatting
- Graphical Data Representation
- Python programming
- Data mining
- Structured query language (SQL)
- SAS programming
- Time series analysis
- Large dataset manipulation
- Statistical analysis
- MS Excel
- Data interpretation
- Data Analysis
- Report writing
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
Teymur JalilzadeTeymur Jalilzade
Operations executive at Commodity Trading FirmOperations executive at Commodity Trading Firm
ABHISHEK SHINDEABHISHEK SHINDE
Global Delivery Lead (BackOffice Technology) at Trafigura (Commodity Trading House)Global Delivery Lead (BackOffice Technology) at Trafigura (Commodity Trading House)
NOURHAN ELNABOULSINOURHAN ELNABOULSI
Procurement Manager at Commodity FragrancesProcurement Manager at Commodity Fragrances