Pablo Medrano Email & Phone Number

Bilbao, PV, ES

Chicago, Illinois, US

Redmond, Washington, US

• Create data models to onboard data into a new operations analytics platform.
• Onboard data according to the data models into the analytics platform.
• Transform data reverse engineering legacy PowerBI reports to create new reports following business guidance.

Redmond, Washington, US

• Work as part of the Launch BI Engineering Team within Data Services, Microsoft Business Operations
• Ingest data from different systems such as Sharepoint, Power Apps and SQL DBs both on prem and Azure PaaS using Azure Data Factory and internal tools based on Spark into Azure Data Lake
• Apply transformations to data based on business requirements using Spark in Databricks
• Mantain and enhance a tabular model in Azure Analysis Services
• Follow SAFe principles within Azure DevOps
• Work with a team based in India managing priorities and load

Naperville, IL, US

• Work as part of the Connectivity Partner Integrations solutions team at Tempus Inc.
• Led the technical relationship with new data partners to gather and discuss pipeline requirements.
• Create Airflow DAGs to run ingestion data pipelines for new partners in AWS Batch from SFTP servers and S3 into Tempus’ systems (S3, Redshift) applying transformations and enriching data (structured and unstructured).
• Support and enhance pipelines for current partners.

Chicago, Illinois, US

• Lead the development of new ETL pipelines.
• Reduced time for parsing metrics from JSON files by 90% using a Kafka consumer and RDD in PySpark.
• Successfully created a POC in Airflow to migrate an ETL pipeline from crontab.
• Mentor new hires.
• Document release changes, submit change requests and participate in code deployments.
• Implemented new branching strategies in Git for the team.

Chicago, Illinois, US

• Participate in the Agile Software Development lifecycle of a Business Analytics application.
• Parse and store data from 10K+ lines XML and JSON files from upstream applications.
• Ingest tables from Oracle and PostgreSQL into Hive using Sqoop.
• Manipulate, cleanse and transform data with PySpark in Hadoop and Hive ecosystem.
• Unit test Python code using Pytest.
• Export tables back to Oracle from Hive using Sqoop.

Chicago, Illinois, US

• Configured monitoring dashboards using Grafana with Prometheus and Graphite backend for EC2 instances and a virtualized storage cluster (Ceph).
• Deploy Prometheus node exporter to 500+ EC2 instances in AWS using Ansible and Docker for Ceph.
• Proactive monitoring of various applications on AWS infrastructure using CloudWatch API, Python boto3 library to check ELB and target groups status. Perform actions using Fabric to check running services and.
• Developed a Python script to decrypt the password of JMS modules in 40+ domains and compare it to the real one across 6 environments, including Production, using Hudson to deploy the code.
• Worked with the support team to troubleshoot issues & fix environment defects for Weblogic infrastructure in AWS (700+ servers).
• Update Weblogic templates to build new Weblogic domains using Chef. Rewriting Chef cookbooks to Ansible playbook for infrastructure configuration and automation

Master'S Degree, Computer Science

Master'S Degree, Industrial Engineering

Bachelor'S Degree, Industrial Engineering