JAVIER RIVERA

I queried the Sofia Plus database with SQL during my ADSI Technologist internship at SENA - Centro de Comercio y Servicios. I tracked instructors, students, and payments, managed records and reports for more than 200 internal users, and prepared executive Excel reports for HR and academic coordination.

For my E-commerce Sales Analysis project, I cleaned data with Python and Pandas, then used SQLite queries to examine revenue, trends, and customer segments. I created an interactive Power BI dashboard that identified 160 VIP customers and showed USD 7.76M in total revenue.

I also created a retail executive dashboard from a star schema, with DAX measures for revenue, time variation, and regional drill-down. It provided real-time revenue visibility across three countries and reduced manual reporting time.

In my House Price Prediction project, I applied feature engineering and data cleaning in a CRISP-ML pipeline, then optimized an XGBoost regression model that reached an approximate validation R² of 0.91. I'm completing my Systems Engineering degree at Unicomfacauca and am available for fully remote work.