Pablo Agustín Nava Vieyra
Verified Expert in Engineering
Database Engineer and Developer
Zapopan, Mexico
Toptal member since July 16, 2024
Pablo is a skilled data analytics engineer with over four years of experience. He excels in data engineering and analysis and has a keen interest in mathematics and continuous learning, complemented by strong interpersonal and communication abilities. Pablo specializes in using Bash scripting to develop data pipelines and routinely employs tools such as Airflow, Snowflake, and dbt while remaining enthusiastic about mastering new technologies.
Portfolio
Experience
- Mathematical Modeling - 12 years
- Python - 8 years
- Software Documentation - 6 years
- SQL - 6 years
- Git - 4 years
- Snowflake - 3 years
- Bash Script - 3 years
- Data Build Tool (dbt) - 2 years
Availability
Preferred Environment
Bash Script, Apache Airflow, Control-M, Git, Snowflake, Data Build Tool (dbt), C, Python, Pandas, Matplotlib, Amazon Web Services (AWS), Docker, Spark, BigQuery, Google Cloud Platform (GCP)
The most amazing...
...project I've worked on involved improving the advertising budget efficiency of a local international pharmaceutical company by 15%.
Work Experience
Big Data Cloud Engineer
Tata Consultancy Services
- Collaborated with a global team to design, build, and optimize ELT data pipelines using the Agile methodology, adhering to continuous improvement and continuous delivery (CI/CD) best practices using GitLab.
- Specialized in coding Bash scripts for data processing across eleven different 3rd-party pipelines, solving 29% of ServiceNow incident tickets with a single script.
- Created documentation for software processes and procedures and developed training programs on fundamental technologies for new members, improving training fulfillment speed by 70%.
- Reduced costs and increased scalability and mobility by migrating from an on-premise Netezza warehouse to a Snowflake cloud service solution within three months.
Advanced Mathematics Tutor
Freelance
- Taught STEM subjects ranging from foundational concepts for middle and high school students to advanced topics for undergraduates, ensuring the academic success of over 100 students.
- Identified and addressed key knowledge gaps in students' subjects or career paths while enhancing their attention to detail and intuitively developing mathematical rigor.
- Worked as a mentor, developing tailored hands-on training content and materials for each student's unique needs and goals, both in person and remotely.
- Engaged with theory and practical applications to deliver comprehensive course curricula, including advanced statistics, linear algebra, and quantum mechanics over a few days.
Financial Analyst Consultant
Agrícola Villagómez
- Performed data analysis and visualization using Python for a long-term investment portfolio.
- Conducted extensive exploratory data analysis across multiple industries, prioritizing key trends and challenges.
- Demonstrated that the company's solution outperformed the second-best alternative by 30% over a decade, proving its significant impact on potential investors.
Business Data Analyst
Pisa Pharmaceuticals
- Identified the most effective advertising channels for various pharmaceuticals, boosting the digital media department's operational efficiency by 15%.
- Built growth rate dashboards and presented the findings to stakeholders to facilitate strategic decision-making.
- Performed clustering tests to segment high and low sales seasons in three different products, improving their logistics.
Experience
NLP Analysis During the COVID-19 Pandemic
https://github.com/AgustinVieyra/NLP-about-CoVid-19The findings provided valuable insights for authorities during the critical vaccination distribution phase, enabling them to measure and understand the societal effects of the pandemic at that time.
DBT Data Engineering Pipeline
https://github.com/AgustinVieyra/First-dbt-projectThis initiative equipped the company with a robust data infrastructure, empowering data-driven decision-making and improving our value proposition.
Advertising Channels Optimization
Deep Learning Cloud Classifier
https://github.com/AgustinVieyra/cloud-classifierEducation
Bachelor of Science Degree in Nanotechnology Engineering
Instituto de Estudios Superiores de Occidente - Guadalajara, Jalisco, Mexico
Certifications
Microsoft Certified: Azure Data Engineer Associate
Microsoft
Skills
Libraries/APIs
PySpark, Pandas, Matplotlib, NumPy, SciPy, X (formerly Twitter) API
Tools
Apache Airflow, Control-M, MATLAB, Jira, GitLab CI/CD, GitHub, Jupyter, Microsoft Power BI, Git, Cloudera, Informatica ETL, Tableau, Zoom, BigQuery, Terraform
Languages
Bash Script, Python, SQL, Snowflake, C, R, Scala
Paradigms
ETL, Business Intelligence (BI), Design Thinking
Platforms
Databricks, Amazon Web Services (AWS), Azure, Docker, Google Cloud Platform (GCP), Azure Synapse Analytics, Azure Event Hubs, Azure Data Lake Storage
Storage
Data Pipelines, Databases, API Databases, Amazon S3 (AWS S3), Microsoft SQL Server
Frameworks
Hadoop, Delta Live Tables (DLT), Jinja, Spark
Other
Research & Investigation, Mathematical Modeling, Data Engineering, Data Orchestration, Data Visualization, Data Analysis, Data Interpretation, Data Build Tool (dbt), GitOps, Software Documentation, Economics, Statistics, Big Data, Data Management, Data Architecture, Data Quality, Data Modeling, Orchestration, Forecasting, Azure Databricks, DLT Pipelines, Scientific Data Analysis, ServiceNow, Portfolio Analysis, Mathematical Finance, Systems Thinking, Data Warehouse Design, Data Warehousing, Google Colaboratory (Colab), Whiteboarding, Informatica, Encryption, Identity, Azure Data Factory (ADF), Azure Stream Analytics, Design and implement data storage, Data Processing, Secure, monitor, and optimize data storage and data processing, Azure Synapse Link
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring