Freelancer profile translated to English.
Back to original languageAbout John Mauricio
Soy Ingeniero de Datos con más de 9 años de experiencia en análisis, transformación y modelado de datos, especializado en SQL, PL/SQL, Power BI y Microsoft Azure (incluyendo Databricks). He liderado proyectos de migración de datos, desarrollo de ETLs eficientes y construcción de tableros estratégicos para la toma de decisiones empresariales. Combino una sólida formación técnica con visión de negocio, lo que me permite ofrecer soluciones escalables, limpias y orientadas a resultados. Estoy enfocado en aportar valor desde el primer día, trabajando de forma autónoma, ágil y con comunicación clara.
Spanish
Native or bilingual
English
Conversational
French
Basic
Can work on-site
Madrid (up to 50km)
Experience
- Famisanar EPSTechnical Note Data EngineerHEALTH AND WELLNESSOctober 2025 - December 2025 (2 months)Santafe de Bogotá, Colombia
- Creation of technical notes for fixed-amount contracts, covering the entire process: data mining, debugging, analysis, and cost projection.
- Execution of data mining in PL/SQL to identify usage patterns and relevant behaviors.
- Cleaning, validation, and analysis of information for the calculation of frequencies and average costs per event.
- Projection of key indicators for the estimation of contractual amounts.
- Automation of processes using Power BI, Excel, and Jupyter Notebook to optimize analysis time.
- Support to the team in generating queries and extracting information for other technical notes.
- FAMISANAR EPSSENIOR DATA ENGINEERHEALTH AND WELLNESSNovember 2020 - February 2025 (4 years and 3 months)Santafe de Bogotá, Colombia
- Creation of a Power BI dashboard from scratch for managerial decision-making, with monthly updates.
- Migration of the UPC sufficiency reporting process from MS Access to Oracle, reducing generation time from one month to 2 days using a PL/SQL package.
- Development of scalable ETL processes in local and Azure environments, feeding data warehouses and data lakes.
- Use of Databricks notebooks to migrate data logic from Oracle to Azure; processing Parquet files, performing joins, cleaning data, and storing in Delta tables.
- Design of predictive models to detect high-cost patients without catastrophic illnesses using Python, SQL, and PySpark.
Achievements:- Reduction of monthly report generation time from 1 month to 2 days.
- Creation of strategic dashboards with board-level impact. Contribution to cost-saving models in the healthcare sector.
- FAMISANAR EPSDATA ENGINEERHEALTH AND WELLNESSJune 2017 - October 2020 (3 years and 4 months)Santafe de Bogotá, Colombia
- Supervision of technical report delivery and coordination of data requirements. Development of PL/SQL data mining solutions for technical modeling.
Achievements:- Optimization of report generation for regulatory bodies and internal use. Introduction of efficiencies in health contract modeling.
Recommendations
Be the first to recommend John Mauricio
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master in Data ScienceUNIVERSITAT OBERTA DE CATALUNYA2018Master en Ciencia de Datos
- Industrial EngineeringUNIVERSITARIA DE COLOMBIA2015Ingeniería Industrial