Information Systems + Finance

I turn complex operations into clean, automated workflows and dashboards. Strengths in Python, SQL, and analytics — with finance intuition to prioritize the metrics that matter.

Python • SQL • Excel (VBA)

Power BI • Tableau

APIs & Automation

Logistics Analytics

Financial Modeling

El Paso, TX • Remote‑friendly • English/Spanish

About

How I work

Mission

I bridge business needs and technical delivery. From requirements to rollout, I communicate clearly, document well, and optimize for measurable outcomes.

Translate ops pain points into automation + analytics.
Own the data flow: extract → clean → model → visualize.
Ship responsive, accessible, maintainable interfaces.

Quick Facts

B.B.A. Computer Information Systems (Finance minor), UTEP
BIAS member • Alteryx Designer Core
Focus: Logistics, fintech, automation

Skills

What I use to deliver

Data & Engineering

Python (pandas, NumPy, FastAPI), SQL (Postgres/MySQL)
ETL pipelines, APIs, automation, data modeling
Power BI, Tableau, Excel (Power Query, DAX, VBA)
Proficient in version control (Git) and collaborative workflows
Data visualization design with focus on clarity and usability

Product, IT & Networking

HTML/CSS/JS, React basics, responsive UI & UX writing
Microsoft 365 admin, system troubleshooting, and deployments
Networking basics (VLANs, port security, firewalls)
Docker basics, cloud deployments, automation scripts
Experience with SOP creation, process documentation, and training

Finance & Analytics

Financial modeling (DCF, WACC, ratio analysis, valuation models)
Cost analysis and forecasting with Excel/Power BI
Strong foundation in portfolio optimization and investment analysis
Alteryx Designer Core Certified; pursuing Google Data Analytics
Bilingual: Fluent in English & Spanish for cross‑functional collaboration

Experience

Highlights & impact

Customer Service & Logistics — Sky Transportation

08/2024 – Present • El Paso, TX • Tesla account (~35% of company revenue)

Own day‑to‑day coordination across drivers, planners, and Tesla stakeholders; maintain real‑time shipment visibility and handle priority escalations.
Built a route & dwell‑time tracking workflow (Excel/Power BI + VBA) that cut average dwell by ~18% and improved OTIF to ~97% on key lanes.
Standardized customer communication templates and SOPs, reducing response time by ~22% and missed updates by ~40%.
Created weekly KPI report (OTIF, dwell, utilization, exceptions) to inform load planning and cost control; flagged outliers for corrective actions.
Tools: Excel (Power Query), Power BI, SQL basics for data extraction, email automation/macros.

Designer — Next Step Design

08/2022 – 08/2024 • El Paso, TX

Delivered CAD/Revit packages for 10+ simultaneous projects; supported Fontainebleau Las Vegas (largest company project) from schematic to close‑out.
Introduced file‑naming and revision control SOPs that shortened handoff cycles by ~30% and reduced rework.
Partnered with PMs to sequence deliverables, improving on‑time submittals and change‑order clarity.
Tools: Autodesk Inventor/Revit, CAD, Microsoft 365, SharePoint.

Geek Squad — Best Buy

10/2015 – 06/2022 • El Paso, TX

Resolved 1,000+ support tickets with ~95% CSAT; Top‑75 Sales & Million Dollar Club (3 yrs).
Automated diagnostic/check‑in steps with spreadsheets & macros to standardize troubleshooting.
Mentored new agents on workflow, safety, and customer communication.

Projects

A few things I’ve built

LinkedIn Auto‑Apply Bot

Python + Selenium bot: ranks jobs, tailors résumé, and submits Easy Apply with human‑like timing.

Logistics KPI Dashboard

Pipeline from CSV/API to Power BI: OTIF, dwell, utilization; alerts exceptions via email.

Microsoft Valuation

WACC, SGR, DCF with sensitivity analysis; clear visuals and executive summary.

Let’s build something useful.

Email: lfvargas@miners.utep.edu • LinkedIn: luis‑vargas‑341509349 • Phone: (915) 504‑2051

Résumé (PDF) About Me