Automation & BI
I connect operational sources, SQL queries, and generation processes so reports arrive on time with clear traceability.
Python · SQL · Power BI · ExcelProfessional portfolio · Cali, Colombia
Data turned
into action.
I am Jorge Vasquez Morales, a SENA Technician in Data Processing for Artificial Intelligence Models. I work with automation, analytics, reporting, and pipelines that turn operational information into decisions.
AI / BI / DATA
Current focusData Analyst
with applied AI
with applied AI
01
Automation
ETL
Data modeling
01
What I do
I build reliable processes before asking data for answers.
My work combines data preparation, automation, databases, and visualization. The goal is not simply to deliver a dashboard, but to leave behind a process that is understandable, maintainable, and useful to the teams making decisions.
Analysis-ready data
I design ETL workflows to clean, validate, consolidate, and document information from files, email, internal systems, and relational databases.
pandas · PostgreSQL · Oracle · SQLAlchemyApplied AI & technical exploration
I develop learning projects with tabular data, audio, and images, including dataset preparation, exploratory analysis, clustering, and pattern detection.
scikit-learn · Random Forest · K-Means · Audio02
Selected projects
Technology applied to concrete problems.
Academic exploration
Bird data in Cali
An academic project built around bird records, BirdNET results, audio, and geographic locations. The work brought together scripts, data curation, and a functional map for exploring the available evidence without presenting it as a production-validated identification system.
MaterialAudio, BirdNET CSV data, and 383 curated records
TestsAudio, spectrograms, and georeferencing
StatusFunctional geospatial prototype
- The original export of 542 rows was reduced to a conservative subset of 383 records, with all 159 exclusions documented.
- The map uses real WGS84 coordinates, search, filters, repeated-location grouping, and permission-based geolocation.
- The project is not presented as a finished application or as an identification model validated for production.
Territorial evidence
Explore the records
01
383 conservative records displayed on real-world cartography.
0254 primary species and 312 unique locations.
03Technical curation with external taxonomic validation still pending.
Automation & reporting
Data processes for operations and business
Workflows that download, validate, consolidate, and distribute operational information using Python, SQL, Power BI, Excel, and Excel/PDF outputs.
Focus: less manual work, better traceability, and decision-ready reports.
Computer vision
Image analysis prototype
An academic project featuring a local server, image upload and gallery, visual processing, color novelty detection with K-Means, and object detection tests with SSD.
Focus: practical experimentation with images and detection, not a finished commercial product.
03
Recent experience
Automation, analytics, and support for business decisions.
Hands-on experience in data and reporting processes for operational teams, integrating scattered sources and delivering usable information.
20252026
Data Analyst & Automation
- Automated operational and management reports with Python, SQL, Power BI, and Excel/PDF outputs.
- Built ETL processes for loading, transforming, cleaning, validating, and consolidating data from Excel, CSV, email, and relational databases.
- Created queries, views, and database structures in PostgreSQL and Oracle to support dashboards and business indicators.
- Used bots, scheduled tasks, file handling, Outlook/OneDrive, logs, and technical documentation to reduce manual work.
04
Toolkit
A stack built to move data, not fill a list.
PythonSQLPower BIPostgreSQLOraclepandasNumPySQLAlchemypsycopg2ExcelETLGit
05
Education
Technical learning with practical application.
Technician in Data Processing for Artificial Intelligence Models
SENA
Implementation of Artificial Intelligence Solutions
SENA
The Editor's Guide to DaVinci Resolve 20
Blackmagic Design
Complementary specialization
Video editing
and visual communication.
I also have freelance experience providing technical and audiovisual support for events, capturing material, and editing video. This complements my core profile when a project needs to communicate data or a technical solution with visual clarity.
Available for opportunities in data, BI, and applied AI