Acerca de Julian
Data Analyst - Engineer and Front-End Web Developer
Consultant, engineer, and data analyst with over four years of experience implementing analytics tools such as QlikSense, Tableau, and PowerBI. Skilled in web development (ReactJS, D3.js) and Cloudera (Big Data/Hive, Impala, Sqoop, Oozie). Developed ETLs in projects using tools like SQL, Python, and PostgreSQL, and handled integration and migration to SAP for effective business analysis. I have led teams as a Team Lead and Scrum Master. Experienced in various sectors including construction, pharmaceuticals, and logistics in Colombia, Spain, and as a consultant for projects in Mexico and the US.
Results-oriented and committed to meeting timelines.
---------------------------------------------------------------------------------------------
Data Analyst - Engineer and Front-End Web Developer
Consultor, ingeniero y analista de datos por mas de cuatro años implementando herramientas de analisis con Qliksense, Tableau, PowerBI, Web Development (ReactJS, D3.JS), Cloudera (Big data /Hive, Impala, Sqoop, Oozie). Desarrolle ETLs en proyectos con herramientas como SQL, Python y PostgrestSQL, integracion y migracion a SAP para crear un analisis de negocio efectivo. He liderado equipos siedo el Team Lead Scrum master. En diferentes sectores como construccion, farmaceutico y logistico en Colombia, España y como consultor para proyectos en Mexico y EU.
Orientado a resultados y ajustado a timelines.
Español
Bilingüe o nativo
Inglés
Competencia profesional completa
Acepta trabajo presencial
Madrid (hasta 50 km)
Experiencia
- IBERMIRData Engineer | Product Managerenero de 2023 - Hoy (3 años y 5 meses)Main Responsibilities• Lead system migration to SAP, providing technical expertise and strategic business consulting. Collaborate closely with team members to develop overarching strategies and ensure alignment with diverse processes, effectively addressing specific requirements.• Deliver Data & Analytics support to drive business strategy and execution across the entire group in the Americas and Spain, meeting the needs of respective areas.• Design, develop, and maintain infrastructure, tools, scripts, and frameworks to facilitate data collection, analysis, and visualization. Collaborate with cross-functional teamsto understand their data requirements and develop solutionsforactionable insights extraction.• Maintain and monitor the team pipeline in Power BI, including change management, data refresh, Power BI service configuration, semantic models, and dataflows.• Enhance the creation, optimization, and maintenance of Power BI Semantic Models.• Identify, design, and implement internal process enhancements: automating manual tasks, optimizing data delivery, orchestrating refreshes, and redesigning infrastructure forenhanced scalability.• Assist the marketing team in refining web page strategies by restructuring and providing technical advice.• Collaborate with the team to develop a recommendation model for the purchasing department, leveraging various insights to minimize costs across the logistics area and optimize warehouse inventory management. Skills: Problem solving, teamwork, Python, R, Stata, time series forecasting, JavaScript, Power BI, Cloud computing, ETL, SQL, ERP software, SAP, data mining, business rules.
- ADRESData Analytics Consultantenero de 2021 - enero de 2023 (2 años)Main Responsibilities• Improved financial efficiency and accuracy in the healthcare and pharmaceutical system by enabling comprehensive analysis, follow-up and incoming data consolidation.• Designed and developed a robust demographic projection model in collaboration with Data Science team to enhance forecasting accuracy and improve per capita payment calculations for the health system Resource Administration Unit.• Played a key role in the analysis, follow-up, data consolidation, and reporting of activities within the health action plan of the Health Financial Resources Management Directorate, ensuring adherence to financial goals and KPIs.• Increased efficiency and cost savings through process improvement initiatives that identified areas for enhancement and implemented strategiesto streamline operations.Skills: Problem solving, teamwork, Python, R, Stata, time series forecasting, pharmaceutical economics, JavaScript, Power BI, Cloud computing, ETL, SQL, ERP software, Azure cloud, data mining, business rules.
- Vector Ingenieros & ArquitectosBI & SFE Analystenero de 2019 - enero de 2021 (2 años)Main Responsibilities• Played a key role in client clustersegmentation tool development to identify buy-sell behavior patterns in construction area and create differentiated contact strategiesfor marketing and commercial teams.• Designed and developed a natural language processing (NLP) reading tool to automatically extract relevant information from specific bidding process documents and upload to a database for easy filtering.• Designed Power BI dashboards using market data and applied strategic analytics solutions on various data sources to deliver sales force effectiveness KPIs and market performance insights to the commercial and marketing teams.Skills: Customer relationship, R, Data visualization, KPIs, NLP, Microsoft Office tools, Project Management Software, Clustering models, Real estate economics, Tableau, Frontend development.
Recomendaciones
Sé el primero en recomendar a Julian
Ayuda a este freelance a destacar compartiendo tu experiencia.
Estos perfiles de freelance también coinciden con tus criterios
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
Formación
- Big Data and AnalyticsBusiness School–Madrid2024BIG DATA AND ANALYTICS
- Project Management and DevelopmentESCUELA DE INGENIEROS JULIO GARAVITO2021Project Management and Development