Tama Francisquez

Designed and delivered a functional beta for forest ecological monitoring: live data ingestion from Excel, UI development in QTK4 with a Python backend, reproducing ecological analyses of dendrometry, thinning, captures, and temperatures, and interactive visualization. Included a PoC in Microsoft Power BI as a professional dashboarding alternative, evaluating data modeling and licensing costs against a custom local solution.

Data consulting at SolidQ (Microsoft Gold Partner, Data Platform). Advanced analytics and BI projects on the Microsoft stack (SQL Server, SSAS, SSIS, Power BI) for banking, betting, and maritime transport clients:

- Enterprise-scale ETL (SSIS) for an automotive company in Spain: maintenance and evolution of integration processes for a business and customer 360° vision initiative — nightly and weekly loads from hundreds of source databases to the analytical layer (centralized relational repository + non-relational storage + corporate KPI cube).

- Development of metrics and KPIs in DAX on tabular models (SSAS) in production: creation of new measures and migration of calculations from SQL views to DAX, with nightly processing and consumption in dashboards.

- Cross-sell models and market basket analysis for a North American banking institution, aimed at commercial actions.

- Recommendation system and customer product analysis for a Mexican betting company (international client, business stakeholders).

- Development of a demo project on Microsoft's ML engine for technical pre-sales.

- Development of a PoC for predictive analytics for TEU allocation on Danish shipping company vessels.

- Regular work in R, Python, and SQL on large volumes of transactional data.