Close

Daniel Lugo

Data Scientist | Materials Chemical Engineer

Download Resume

About Me

As a bridge between Materials Chemistry and Data Science, I offer a blend of technical expertise in Python, SQL, and Power BI. Transitioning careers, I've embraced data's transformative role in decision-making and process automation.

I've honed my skills in data integrity and ETL processes, developing actionable insights through intuitive dashboards, always in constant communication with stakeholders.

Beyond technical skills, I bring effective communication and teamwork proven across global teams, along with an analytical and problem-solving mindset. Dedicated to lifelong learning, I continuously seek out new tech to lead in data science.

Education

Data Scientist

03/2022 - 08/2022

Henry Bootcamp

I've gained expertise in the most demanded technologies and tools in the data science field, such as Python, Power Bi, SQL, and machine learning libraries. My training emphasized both technical skills and soft skills, preparing me for real-world challenges by teaching me how to harness the power of data analytics and data engineering to drive business decisions and innovation.

Materials Chemical Engineer

2016 - 2021

Universidad Autónoma de Querétaro

I possess a strong foundation in chemistry, physics, mathematics, and materials science, enabling me to lead innovations in the processing and transformation of metallic, ceramic, polymeric, and composite materials for the industrial sector.

Experience

Reply Pro (Remote - US)

Data Engineer

I built and managed weekly ETL updates for hierarchy data and user permissions at Reply Pro. This work showcased my grasp of web APIS and agility with new tech. I improved my communication and teamwork skills by engaging daily in English with colleagues around the globe.

Ministry of Finance of the State of Querétaro

Data Analyst

In the Department of Finance of the State of Querétaro, I specialized in automating ETL processes with Python, significantly enhancing efficiency and data integrity. I contributed to designing and implementing relational database structures for improved data management. Additionally, I developed advanced Power Bi dashboards for impactful data visualization, aiding in better decision-making for stakeholders.

Kenworth Querétaro

Power Bi Instructor

I taught an intensive 18-hour Power BI course over a month for the automotive company, focused on Power Query, data analysis, and visualization techniques to optimize business decision making.

Projects

ETL and Power Bi Report to analyze public transportation in Queretaro México

The Querétaro mobility agency has provided, from its databases, files that contain information related to daily and monthly public transportation upgrades. For decision making and for a broad vision of the panorama of public transportation in the state of Querétaro, a summary of the most relevant metrics of the different bases is necessary through the creation of a dashboard that must be fed monthly with new data, which is why an automated process is needed to achieve this goal.

View Project

Budget B Report Automation of the Finance Ministry of Querétaro

The chief office of Budget B in the finance ministry of Querétaro needs a monthly automated report to check that the budget goes well through the year and the expenses are all controlled. For this, an ETL pipeline is requiered to automate repetitive tasks, create a SQL database and deploy a dashboard app in Power Bi Services

View Project

Yellow taxi trips: From ETL pipeline, to analytics and machine learning

A company wants to invest in the Transportation field, they want to provide transportation services as Uber or DiDi. But first, they need to have a solid frame of reference to make good investment desicions. This is when we come in, analyzing 3.5 Million of records of yellow taxi trips of March 2022 to provide them with the necesary information of the movement in the business. We created the ETL Pipeline in AWS, then a relational database in redshift that we connected to Power BI to create the dashboards and finally, we created a machine learning model in the streamlit interface.

View Project

GraphQL API ETL

Using GraphQL, Django and Graphene, I created and implemented queries and mutations that comunicates with the Reply Pro API in order to set new alignments for hierarchies and user permissions to dashboards.

View Project

Skills

Get in Touch