Yair Martínez Email & Phone Number

Cdmx

- ETL processes to consult different security data sources from emergency numbers like 911 and stolen cars databases for building data visualizations using DBeaver and PySpark.- Creation of Named Recognition Entities model for Natural Language Processing using PySpark and SpaCy. - Migration of a Graph Model from Networkx using pandas to Graphframes using PySpark.- Fake emergency callings prediction model using Fourier and PySpark.- Code documentation.- Engaged in code development with end-client feedback, collaborated horizontally with cross-functional teams for the optimization of two projects, and spearheaded the development of a new project.

Consulting and Freelancer-Denovicon: AI model that can predict the bioavailability of a drug implementing the models PCA, XGBoosting, DNN and SVR; using an ensemble model. -Guimajo: Consultancy in biotechnology for a law expert report in vegetables | Microbiological traceability | Supply chain monitoring and control- Industriales de Naucalpan: Marketing for a new soccer football team | Business plan development for a soccer school. -Marcan: Development of Copper based disinfectant and UV-C lights equipments | Business plan development, negotiation with suppliers, COFEPRIS norms. -Abacera de salud: Process plant design for Kombucha fermentationRegistration to the PEI from CONACyT.

Cdmx

• Data cleaning ( Pandas, Polars, Oraclebd)• ETL process design (Ubuntu, SSH, APACHE Parquet)• Data warehouse creation ( PostgreSQL, MongoDB) • Prediction models for customers and engineering• Data acquisition from Raspberry in real time for performance monitoring.Programming language: SQL, Python, LinuxDBMS: Oracle, PostgreSQL, DBeaver

México

• Classification model for campaigns in customers Pension funds (AFORE). ( Pandas, Matplotlib )• ETL for customers behavior analysis and KPI designs. ( DB2-IIAS, SAS, Python)• Dashboard creation for data visualizing ( Dash Dashboard, Plotly Express, Power BI ) Programming language: SQL, Python, R DBMS: SAS, DBeaver

Irapuato, Guanajuato, México

• Development of a biosensor applying synthetic biology tools (CRISPR Cas 12a), used for food safety (Listeria monocytogenes) for agro industry. ( Research and experiment design, Laboratory skills,Buyer, lab assistant coordination )• Use of bioinformatics tools for RPA and LAMP primers design.( Python BioConda )• SMART Farm design (Industria 4.0) on organic strawberries greenhouse for automate cultivationprocesses ( Sensors, automatization, data collection )• Commercialization of PCR test for covid. ( Nurses coordinator, SanitaryResponsible, Marketingfor B2B and B2C )Project planning and development, management, experimentation and commercialization.

Naucalpan De Juárez Y Alrededores, México

• Key accounts and national distributors, price list management, trainings and technical support for the sales force and final customers. ( PowerBI, CRM, B2B, KPI, POA, Collaboration agreement,Distribution agreement )• APIs and Formulations, equipments and consumables for production up-stream and down-stream, sterile process validation, CHO cells and PEGilation ( NOM-051, NOM-059, IQ OQ PQ )Brands: Merck, Millipore, Sigma-Aldrich.

• Opening of the first Apple Store in LatAm. ( B2B - B2C, Apple SAP, Marketing )• Tropicalization of internal and external logistics, visual standards, NPS, “Apple Business”, Swiftprogramming workshop, audiovisual edition, text and numbers processing, e-commerce and userexperience. ( Swift, Numbers/Excel, Pages/Word Workshops )

Juan Sanchez Azcona 1447, Benito Juárez, 03100 Distrito Federal

• Market analysis, trainings for sales force and final customers, inventory and stock management, price list management, installation, negotiation and presentation on seminars and conferences.( CRM, B2B, Public bidding, Marketing tools, Salesmen capacitation, IQ OQ PQ )Main brands : Büchi, Parr y Chemglass.Brands: Thermo Scientific, Sartorius, Ohaus, Eppendorf, Brookfield, Cole-Parmer, Julabo, MasterFlex.

Acueducto S/N, La Laguna Ticoman, Gustavo A. Madero

Student Advisor of The Bachelor's Degree in Biotechnological Engineering in my University

Acueducto S/N, La Laguna Ticoman, Gustavo A. Madero

Differential and Integral Calculus, Vector Algebra, Programming, Numerical Methods, Physics, Thermodynamics, Transport Phenomena, Mass Transfer Operations, Fluid-Fluid Bioseparation, Solid-Fluid Bioseparation and Biomolecular Production.

Engineer'S Degree, Biotechnological Engineering

UPIBI - IPN

Degree, Productivity And Quality

Artificial Intelligence, Data Science

Comprehension matemática y aplicación de arquitecturas y librerías para aplicar Machine Learning y Deep Learning en visión computacional y.