Margaret Ortiz Email and Phone Number

- Develop Data Pipelines- Develop PIT Dataset Structures for business partners- Maintain Ingestion Pathways from source systems- Create Dashboards for migration projects

- Implement PIT data warehouse structure for data use in GCP- Create DAGs, troubleshoot and monitor performance in Airflow- Develop enhancements, fix bugs and make changes to pipelines with GIT version control into GitLab- Complete user stories as a part of a Data Engineering Agile Scrum Team- Work with governance, security and other teams to ingest and transform data to fit business needs.

- Data Analysis of experimental sensor via JMP & Spotfire, giving presentations and communicate with the company to help improve their product. - Manage employee to perform laboratory experimentation and provide information for project deliverables. - Create Excel VBA applications with REST API upload features into an Oracle Database while testing with SQL queries. - Develop Device Prototypes for application-driven screening and detection of fragrance and flavors- Create educational presentations, guides and events for our office's Green Team helping increase our sustainability and recycling participation at our location.- CAD modeling and 3D printing for new prototypes- Develop Pipeline Pilot script to view and interact with automation equipment and backend data - Method Development for more exhaustive and accurate sample collection - Investigate technologies that can help to improve detection for quick screening- Laboratory work involving sample preparation, headspace collection and GCMS analysis

Test software solutions as part of an Agile Development team for Johnson & JohnsonCode automated test scripts in Java/Selenium and VBscript/UFT for a web application, involving HTML/CSS coding, SQL querying and microsoft office manipulationRun SQL queries and develop back-end test automation scripts for data migration verification.Manage testing resources for an agile supply chain reporting web application project and coordinate between development and off shore testingDevelop test scripts, log work in JIRA and execute manual test scripts in a validated software environmentLearned SQL and VBscript in New Hire training along with consulting practices

Develop a point of care biomedical device for the prognosis of anxiety. Responsible for coding of display and microcontroller in C/C++, signal analysis from an impedance based sensor, CAD design and 3D printing of prototype with Fusion 360 and mathematical algorithm for determination if measurement exceeds normal. While also performing experiments with statistical analysis for the determination of quality.Received Green Belt Six Sigma training and implemented practices in project.

Instruct an introductory class of 24 freshman engineering students Create lesson plans, grade assignments, advise students, and organize group projects.

Created a generic Use Error FMEA for all Abbott Vascular coronary devices o Identified risk and determining product and patient effects. o Standardized patient effects with corresponding product effects. o Consolidated and simplifying use errors across product IFUso Consulted with manufacturing SMEs to obtain detailed information about quality and failure of materials.Created a Use Error FMEA for the a bioresorbable stent. Reviewed DFMEAs, PFMEAs, CAPAs, ISOs, and was a part of other FDA regulatory practiciesToured the manufacturing and packaging facilities with in depth demonstrations on the equipment.

Wrote a white paper on the current trends related to food adulteration as it pertains to Abbott Nutrition, while outlining novel devices and techniques for detection.

Assist students in weekly labs and facilitate weekly discussion sections

Professor Kilian’s group is focused on the induction and differentiation of pluripotent stem cellso Make hydrogels, and micro-contact print a pattern on the gel, culture mammalian cells, stain and image to see the effect of the pattern and the stiffness of the gel on the induction of stem cell markers

Developed a probiotic to prevent cardiovascular disease using synthetic biologyo Performed synthetic biology work such as PCR, enzyme digests, ligation, SDS page, electroporationo Designed, and conducted experiments to validate our projecto Interpreted data from Spectrophotometer and Liquid Chromatography Mass Spectrometry(LCMS)o Outline daily tasks for the lab team, presented to advisorsCompetition: Our team competed in the regional and international competition. o Received Gold medal status and Best in Track: Health and Medicine at the international level.

Organized for fall International Programs in Engineering (IPENG) events, design posters, file documents, fulfilled data entry responsibilities and updated information in student database.

Worked under Dr. Mantilla in the Biomedical Engineering Program which focuses on improving respiration after cervical spinal cord injuryProject: Determining localization, volume and expression of BDNF in meseynchymal stem cells after intra-spinal injection into the cervical spinal cord of rats. Used confocal microscopy to visualize cells 1 and 3 days post transplantation.o Techniques: ELISA, Western Blot, cell culture, animal handling and intramuscular injection, immunohistochemistry staining, confocal microscopy with z-stack stitching and image analysis.

Executed sales, assisted customers, inventory, unloaded stock, was responsible for $2,500 in sales weekly.