Santiago Vargas
Chicago,USA
Overview
2
2
years of professional experience
1
1
Certification
Work History
Volunteer Business Analyst
Community Dreams Foundation
09.2025 - Current
- Cleaned, normalized, and modeled donor and operational datasets in Excel using Power Query, PivotTables, and calculated fields to enable reliable analysis and support planning and fundraising decisions.
Business Analyst Intern
Vortex Liquid Colors
05.2025 - 08.2025
- Partnered with Senior Business Analyst to gather and clarify requirements related to supplier invoices, purchase records, and cost data, translating business questions into structured analysis tasks.
- Cleaned, standardized, and validated supplier and invoice datasets in Excel using Power Query, PivotTables, XLOOKUP, and data validation rules to ensure accuracy and consistency for reporting and audit support.
Executive IT Intern
Rainbows for All Children
07.2023 - 06.2023
- Conducted stakeholder interviews and stakeholder analysis to capture document management requirements, then mapped as-is vs. to-be processes for SharePoint workflows.
- Developed a RACI matrix, Gantt chart, and risk analysis to define ownership, task sequencing, dependencies, and timelines, enabling structured execution of the SharePoint redesign initiative.
- Designed and implemented a new SharePoint folder architecture and task structure; presented the solution to stakeholders, who adopted the redesigned system to improve document retrieval and collaboration.
Translator and Interpreter
DePaul University, Translator and Interpreter Corps
07.2023 - 06.2025
- Supported multilingual communications by translating and proofreading over 150+ academic and administrative documents, improving accuracy and accessibility for students and staff.
- Provided live English Spanish interpretation for immigrant clients during legal consultations and translated official documents for DePaul University and partner law firms, ensuring clarity and cultural consistency in all communications.
Education
Bachelor of Science - Business Analytics Minor: Accountancy
DePaul University
Chicago, IL06.2025
Skills
Analytics & Tools: Excel (Power Query, PivotTables, XLOOKUP), SQL (Basic joins, aggregations), Tableau (coursework)
Business Analysis Methods: Requirements gathering, Stakeholder analysis, Process mapping (As-Is / To-Be), RACI, Gantt charts, Risk analysis
Certification
- Business Analysis Fundamentals — Microsoft (Coursera)
- Advanced Relational Database & SQL — Coursera
- Excel Essentials / Excel Managing & Analyzing Data — Microsoft / LinkedIn Learning
Leadership & Activities
- Treasurer, Association of Latino Professionals for America (ALPFA DePaul Chapter) (Budgeting, Financial Tracking)
- Event Coordinator, MESA (Planning, Coordination)
Timeline
Volunteer Business Analyst
Community Dreams Foundation
09.2025 - Current
Business Analyst Intern
Vortex Liquid Colors
05.2025 - 08.2025
Executive IT Intern
Rainbows for All Children
07.2023 - 06.2023
Translator and Interpreter
DePaul University, Translator and Interpreter Corps
07.2023 - 06.2025
Bachelor of Science - Business Analytics Minor: Accountancy
DePaul University