Mario S. Email & Phone Number

United States

Atlanta, Georgia, United States

- Developed a cloud-based solution for gathering and analyzing historical data from brother companies and IoT data from manufacturing tools to provide insights and easy-to-understand statistics and graphs for management decision-making and auditing purposes using advanced data modeling techniques, integrating Databricks as the data analysis platform.- Designed Python-based notebooks for automated weekly, monthly, and quarterly reporting E.T.L- Automated data pipeline workflows using Apache Airflow and wrote scripts in Python.- Applied advanced data modeling techniques to provide insights and visualizations of the data in an easy-to-understand format for management decision-making and auditing purposes.- Presented data to managers and key stakeholders using data visualization tools such as Power BI, Tableau, and SAS.- Employed Spark SQL and Python libraries like Pandas for efficient data cleansing, validation, processing, and analysis.- Constructed and maintained robust data ingestion pipelines utilizing Azure Event Hubs, Azure Stream Analytics, and Azure Data Factory.- Deployed Azure Analysis Services to empower business users with self-service data exploration and visualization tools.- Utilized Azure Log Analytics for proactive monitoring and troubleshooting of data pipeline issues.- Performed the migration of large data sets to Databricks, create and administer cluster, load data, configure data pipelines, loading data from ADLS Gen2 to Databricks using ADF pipelines.

- Designed and executed a comprehensive study investigating the impact of music in different languages on the concentration and reading comprehension of Spanish-speaking students with English as a second language.- Developed a structured experimental process, including the meticulous selection of test subjects and the strategic choice of music, ensuring the validity and reliability of the study.- Collected and processed EEG signals from Unicorn of the test subjects, utilizing advanced biomedical signal processing techniques in MATLAB.- Analyzed data to identify significant differences between the conditions studied, contributing to the understanding of the effects of music on cognitive performance.- Collaborated effectively within a diverse team, including volunteers, advisors, and teachers, to successfully complete the project.- Conducted an extensive literature review, synthesizing information from a wide range of scientific sources.- Demonstrated strong research skills and the ability to reference accurately, contributing to the credibility and thoroughness of the research paper.

Monterrey

- Orchestrated and scheduled daily data extraction tasks across various databases using Google Cloud Data Fusion.- Participated in ETL, Data Integration, and Migration processes leveraging GCP services such as Google Cloud Storage, Cloud Data Fusion, and BigQuery.- Authored technical requirements, integrating existing codebases with Google Cloud Dataproc and Apache Spark.- Analyzed user profiles and application entitlements using Google Cloud Firestore and Cloud SQL.- Developed and curated internal-use dashboards using Google Data Studio.- Engineered multiple batch and streaming Spark jobs using Python on Google Cloud Dataproc.- Ensured code quality and coverage by writing unit tests using PyTest for Python.- Utilized Google Cloud Pub/Sub for real-time data collection and subsequent processing on Google Cloud Dataproc.- Managed large-scale data storage and processing tasks using Google Cloud Storage and Google Cloud Dataproc.- Constructed efficient data models for analysis in Google BigQuery.

Monterrey

• Research assistant of a nanoscience PhD student in which we studied and recreate an alpha-beta pancreatic cell transfection to analyze and test an alternative for diabetes treatment.• Research and identification of current technologies used for cellular transfection and analysis of historical data of successful and failed methods which provide clear insights and advantages of the proposed method.• Creation & coding of a micro-injector for cellular transfection strengthened with multiple configuration data and feedback of similar experiments.• 3D design, simulation, print and assembly of the structure for the micro-injector with a multiple adjustment base for different type of microscope platforms.• Creation of analytic reports regarding the micro steps behavior of the servo-motor used in the micro-injector and develop of a machine learning feedback system for the servo-motor which allowed us to get better iterations after each trial resulting on the desired and ideal behavior.

- Imaging interpretation for prosthetic development. This involved the intricate task of separating the layers and outlining the required section for the efficient connection or implementation of a prosthesis.- Utilized advanced CAD programs such as SolidWorks and AutoCAD to design and model lower limb prosthetics. These designs were meticulously crafted, taking into account individual patients' needs and anatomical specifications.- Executed comprehensive simulations and analyses of the prosthetic models. Employed software like Matlab and COMSOL to analyze mechanical properties, tension, elasticity, and dynamics, ensuring the prosthetics met both anatomical and mechanical prerequisites for optimal function and durability.- Advanced the project by assembling 3D-printed prosthetics using various materials, in preparation for rigorous testing in diverse environments under different stress conditions. This step ensured that the prosthetics were reliable and could withstand real-world usage scenarios.- Concluded the process by adjusting and calibrating medical devices, thus guaranteeing their correct implementation and usage. This final step confirmed that the prosthetics were not only structurally sound but also perfectly tailored to their intended users, ensuring optimal comfort and functionality.

- Initiated involvement in photogrammetry and video analysis projects, contributing to the physical and mechanical evaluation of individuals and mechanical instruments.- Executed kinetic analyses on multiple subjects, comparing individual techniques with standardized methodologies to discern unique performance attributes.- Conducted focused evaluations on subjects' dynamics from various perspectives, performing simulations to identify potential areas of improvement.- Investigated subjects' energy consumption from multiple angles, uncovering inefficiencies in movement patterns and providing recommendations for enhanced energy utilization.- Collaborated with Monterrey's professional athletics and cycling teams, conducting kinetic studies to analyze energy consumption and force wear.- Utilized SkillSpector software extensively for kinetic simulation and analysis, aiding in the visualization and understanding of athletes' movements and the development of effective training programs and strategies.

Tijuana, Baja California, Mexico

- Utilized Python and SQL to clean and organize the spa's client database, enabling personalized client segmentation. This segmentation was based on specific treatment preferences and frequency of service usage, optimizing client satisfaction and business revenue.- Designed and implemented local databases to manage client information securely, ensuring smooth operations and confidentiality of client data.- Developed a dynamic dashboard using Python libraries such as Pandas and Matplotlib for comprehensive data analysis.- This provided statistical insights and descriptive analysis of the spa's product and service performance.- Deployed machine learning models to forecast consumer behavior, leveraging Python's Scikit-learn. This allowed a structured classification of consumer tendencies and facilitated a comparative analysis with competitor businesses, thus guiding strategic decision making.- Implemented data visualization tools, such as Tableau, to provide easily understandable, clear visuals of business data.- This encompassed historical data-based forecasts of past and upcoming trends.- Translated complex data into actionable insights to guide the development of strategic marketing campaigns. These were tailored according to various factors such as seasonality, emerging trends, and customer demographics, ultimately driving cost savings on the monthly marketing budget.- Conducted an in-depth analysis of SQL database trends, resulting in improved marketing strategies, which were adaptable to the changing preferences of the spa's clientele, thus enhancing customer engagement and retention.

Monterrey

• Logistics coordinator, management and negotiator with suppliers for events, national trips and congress.• Coordinator and responsive of teams of 10-15 people during planning phase and the event days.• Web co-developer for the official website of the company with manipulation of multiple accounts (300-500) and provider of financial and assistance statistical analysis.

Tijuana

• Design and creation of a Webpage with multiple numerical, graphical and text report entries.• Creation of multiple accounts for different users with personalized information per account and a master account for my director.• Design and creation of mobile application to make the information accessible from anywhere on Android and IOS platform.• Geographical mapping of historical data per city, state, and country of Mexico with the information of political candidates and parties regarding previously elected politicians and preferences of the Mexican citizens.• Live data acquisition and interpretation every hour during election day which provide the current scenario of the voters which after cleaning was transmitted on the mobile app to the candidates affiliated to our consulting.

Licenciatura, Biomedical Engineering

Professional Certification, Bionic Technology

Bachillerato, Internacional