Manuel Corona-Medellin
El Paso
Summary
Data & Business Analyst experienced in Power BI, SQL, Excel, Tableau, and Oracle. Skilled in data cleaning, modeling, automation, and KPI development. Strong background in building end-to-end analytical solutions using SQL, DAX, Power Query, and relational models to drive operational efficiency and informed decision-making.
Overview
4
4
years of professional experience
Work History
Accounts Receivable Specialist
Helen of Troy Limited
01.2024 - 10.2025
- Reconciled 200+ weekly retailer claims ($3K–$10K) before month-end close.
- Investigated pricing discrepancies and compliance deductions.
- Built Excel/Tableau variance reports supporting audit readiness.
- Utilized Oracle ERP to validate entries, payments, and ledger accuracy.
Undergraduate Assistant
UTEP Student Business Services
08.2021 - 07.2023
- Audited 100+ student accounts daily supporting payment plans and grants.
- Managed $40K+ in cash/check payments with accurate ledger recording.
- Processed Pell Grants, VA refunds, and third-party disbursements.
Education
BBA - Computer Information Systems
New Mexico State University (NMSU)
Las Cruces, New Mexico05-2026
Skills
- Analytics & BI: Power BI, Tableau, Excel (PivotTables, Power Query, Power Pivot), DAX
- Databases & Programming: SQL (MySQL, SQLite, Oracle), ETL, Data Modeling, Joins, CTEs
- Tools: Power Query, Power Pivot, Notion, Google Sheets
- Competencies: Dashboard Automation, Data Cleaning, Business Analysis
Languages
English
Bilingual or Proficient (C2)
Spanish
Bilingual or Proficient (C2)
Timeline
Accounts Receivable Specialist
Helen of Troy Limited
01.2024 - 10.2025
Undergraduate Assistant
UTEP Student Business Services
08.2021 - 07.2023
BBA - Computer Information Systems
New Mexico State University (NMSU)
PROJECTS
- BleuRoute Logistics – Supply Chain Performance Dashboard (Power BI, SQL, DAX), Developed dashboards analyzing delivery times, route efficiency, and KPIs., Cleaned and transformed 50K+ row datasets using SQL and Power Query., Created DAX measures and relational models improving supply chain visibility.
- SilverLeaf Market Analysis – Sales & Customer Insights (Power BI, SQL, DAX), Analyzed customer segments and product performance using SQL and DAX., Built automated KPIs for revenue, YOY growth, demand, and category trends., Designed dynamic time-intelligence models for forecasting insights., Data Cleaning & Transformation using SQL (SQLite, ETL), Executed complex SQL scripts: joins, subqueries, aggregations, window functions., Standardized raw data improving accuracy and reducing preparation time.
ADDITIONAL SKILLS
- Business Requirements
- Data Storytelling
- Process Improvement
- Critical Thinking