Miguel Angel López Medina

Miguel Ángel López Medina Phone: - e-mail:-Skype live:8504fe59d516874 DNI-D Birth Date: 18/11/1982 Spanish #ComputerEngineer #BIArchitect #MachineLearning #Researcher ABOUT ME I am a computer engineer at the University of Jaen (2006) and Official Master of Research in Intelligent Systems at the University of Cordoba (2016). Currently I focus my researching studies in PhD computer Information and Communication Technologies at the University of Jaen (International Mention), and I’m member of researching group “ASIA” indeed University of Jaen. I’m continue developing my professional career as Data Engineer (Business Intelligence and Machine Learning platforms administrator and models developer) at the Spanish Public Healthcare Service, since 2011 as member of the Department of Computer and Information Systems. Furthermore I have worked as BI Platforms administrator for INDITEX inside the architect-middleware department, and others privates companies as BI senior consultant engineer. I have experience leading teams and with the mains Data and BI technologies but like Microsoft ecosystem; SQL Server Integration Services, Analysis Services and Reporting Services (SSIS, SSAS, SSRS) on premise and Power BI and Microsoft Azure in cloud. EDUCATION • University of Jaen: phD Information and communication technologies on course (2017-present) In collaboration with University of Ulster (UK), University of Halmstad (Sweden) and University of Florence (IT) inside the European Project “Remind”. Marie Curie Skłodowska -H2020. • University of Cordoba. Master SoftComputing Intelligent Systems Research Profile. Data Mining, Big Data, Business Intelligence. Fuzzy Logic and Machine Learning (2016). • University of Jaen (Spain). Computer Engineer. (July 2006) • MAIN SKILLS • Data Analyst / BI: Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Sever Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS). SSAS Azure. Tabular and Multidimensional Models. Duties and responsibilities: Head of the Microsoft BI Teams. Deals, Schedule, Design, Develop, Deploy, Management. • Microsoft Azure Cloud ecosystem: Azure Data Factory, Azure Blob Storage, Data Lake, Data warehouse, Analysis Services, Machine Learning Studio tool used for classify and prediction. Data Lakes, Data Factory. • IoT & Machine Learning projects (Design and Deploy). • Microsoft Power BI: Design, develop and deploy dynamic and analytical reports as make decision tools. • MicroStrategy, Tableau admin and developer. • Scripting: Python, C#, PowerShell. Anaconda platform. • Agile / Scrum work methodology. JIRA & Confluence. • Data processing: Python (Numpy, Pandas,..) C#, and Java frameworks like Json, Jsoup. • Query languages: MDX, DAX queries, SQL, T-SQL, Views, Stores Procedures. SQL Profiler for troubleshooting. • DataBases: Microsoft SQL Server, Oracle. Microsoft Data Lake (Microsoft Azure) EXPERIENCE-: INDITEX S.A. Central Offices Arteixo La Coruña Spain: as Business Intelligence platforms administrator inside ArchitectMiddleware department. www.inditex.com www.indracompany.com • Duties and responsibilities: Administrator “BI Operational” team inside Microsoft BI Technologies. • Technologies: SSAS, SSIS, SSRS Azure. Scripting Power Shell Tabular Models process and synchronizations between nodes. 2019 PRODWARE SPAIN S.A. Senior BI Consultant Madrid, Spain https://www.prodware.es/ 2012-Today: Public Services Healthcare: BI Developer, Data Analyst, Big Data engineer. BI development of multidimensional models based on SQL Server SSIS, SSAS and SSRS. Development of indicators of program contract design Health and the Ministry of indicators to support decision making. Big Data, BI, OLAP Cubes, Data mining. Public Healthcare Spanish system. http://www.ephag.es • Duties and responsibilities: Head of Information System Area, Microsoft BI technologies based. Requirements, Schedules, Deals, Designs, developments, deploys and management. • Technologies: ETLs, Data warehouse, SSAS, SSRS-: C# .Net and Java Software Developer and support at Agencia Sanitaria Hospital Alto Guadalquivir. Montilla (Córdoba). Spain. http:// www.ephag.es Using NetBeans as Java IDE. 2006 - 2010 Vice-president at company: Mengisoft S.C.A. and Software development. www.mengisoft.com- TIC Consultant Certificate at Public Spanish Government Junta de Andalucía. NOVAPYME consultor. RESEARCH 2019: Author Article: “Activity Recognition for IoT Devices Using Fuzzy Patio-Temporal Features as Environmental Sensor Fusion.” Sensors 2019, 19, 3512; dos:10.3390/s- 2018: “Predicting the urgency demand of COPD patients from environmental sensors within smart cities with high-environmental sensitivity. Artificial Neutral Networks based model.” Article (PDF Available) in IEEE Access PP(99):1-1 · April 2018 DOI: 10.1109/ACCESS- 2016: Ordinal Regression with educational datasets Comparative study of ordinal regression algorithms based on neural networks artificial (R.N.A.). Department of Computer Science University of Cordoba Memeber of researching group “ASIA” (Advances in Intelligence Systems and Applications) at the University of Jaen, Spain. OTHER PROJECTS • DWH (Data Warehouse) Architect. Healthcare Public Services, ETLs, Olaf Cubes, Reporting, Dashboards. • Architecture and development of ETL multi Hospital model. Defining metrics, dimensions, analytical models and dashboards for make decision tasks. 2019. • Evaluating design SSAS Tabular Models, Performance Analyzing Tool. Migrations planning BI platform INDITEX S.A. • TroubleShooting BI Models (ETLS, Reporting, Mutidimensional and tabular cubes) for many private companies. • Desing and deploy IoT project Model for monitoring the quality of Water and Air in SmartCities. • Design and development of model holding the minimum basic data set Hospitalization (C.M.B.D). Spanish Public Healthcare Services. 2.018 • Design and development of the operating model of C.M.B.D. Emergency Department. ) . Spanish Public Healthcare Services. 2.016. • Design and implementation of a multidimensional model for analyzing digital radiology tests. . Spanish Public Healthcare Services. 2.014 • Design and development of a software balancer tomcat connections against the station. . Spanish Public Healthcare Services.2.013. • Design and development Java Tools for supply different areas inside the Public Healthcare Spanish Services. www.ephag.es • Design and development of an ERP for the integrated management of oil mills. Production and management. • Implementation of a simulator Clinical cases. Department of Nursing at the University of Jaen. 2.008 LANGUAGES Spanish: Native English: B1 Level Cambridge. Chinese: Learning. FURTHER TRAINING ! Harvard University USA Data Science: Machine Learning HarvardX: PH125.8x (Nov 2019) ! ! ! MicroStrategy: 10.311 Administration for Enterprise Analytics (Nov 2017) MicroStrategy: 10.611 Analytics Performance Tuning (Nov 2017) Big Data aplicado a Sanidad. Granada, Escuela Andaluza de Salud Pública. Octubre 2016. ! Data Analysis in hospital emergency Escuela Andaluza de Salud Pública. Sevilla 2.015 ! Microsoft SQL SERVER Administration.Techno-Learning. Jun2013. ! ! ! SQL SERVER Database management. ( 2012) C#.Net (Feb 2.010) Neural Network, Classification Algorithms (January 2.013) ! ! ! ! Cryptography and computer security (University of Jaen 2005) ICT teacher trainers. (Mayo 2009) Modern oratory techniques. (Marzo Julio 2006). Universidad de Jaén. STARTGRAPHICS applied to engineering 2002. University of Jaen. HOBBIES • Music: Piano, Sports: Running and Martial arts 4th. Dan Black Belt in American Kenpo.