Andrew Castillo Email & Phone Number

Santa Monica, California, Us

Los Angeles, California, Us

Develop the data platform to standardize reporting on all metrics across the company tech stack.Create and maintain scalable data pipelines to manage and transform large amounts of survey, social and behavioral data for analytics use cases and company-wide reporting.Leverage engineering methods and best practices to deliver well-defined, tested, documented, and code-reviewed data sets.Provide thought leadership in defining models such as marketing attribution, pricing and inventory optimization, and customer affinity.Design, build and optimize data models in the data modeling layer (dbt), reducing runtime and decreasing unnecessary complexity.Lead the team for more efficient, effective data modeling, reviewing pull requests, suggesting improvements, and helping/coaching others on the team to write better code.Develop data driven stories to answer some of the toughest questions in ecommerce through data visualization and the summarizing of insights in verbal and written form.

Los Angeles, California, Us

Analyzed data from 300,000 monthly active users and used outputs to guide marketing and product strategy: increased average app engagement time by 2x and decreased dropoff rate by 30%Developed an Internal KPI dashboard in tableau that executive and board leadership used daily to monitor business health, automating ~20 hours of weekly reportingWorked closely with internal and external stakeholders to provide insights and analysis on product optimization strategies that generated another 1 Million in ARRManaged multiple projects and prioritized work based on urgency and complexity, while adhering to timelinesAccount managed 20 clients, addressing 5.4 Million in ARR

New York, Ny, Us

Worked closely with the Data Engineering and Product team to Launch HBO MaxManaged a cross-functional team of 5 analysts in 2 locations(LA and New York) and collaborated with business development, data analysis, operations and marketingCut projected time for data analysis by one week by developing reusable ETL components and implementing a round robin JIRA ticketing systemAnalyzed campaign performance across 2,000 different content creators by pulling API bulk data from Tik Tok, Youtube, Facebook and InstagramLeveraged stored data to drive business sales, increasing revenue by 3.4 Million dollarsCollaborated with product managers to perform cohort analysis that identified an opportunity to reduce pricing by 15% for a segment of users to boost yearly revenue by 5%

Aliso Viejo, Ca, Us

Implemented a data lake to store genetic variations and phenotypes for ease of reportingEngaged in end to end data data collection processes using qualitative methods for 10+ research projectsRecommended upgrades that improved platform architecture in response to data catalog performancePreformed data cleaning necessary for predictive models that analyzed over 10,000+ genetic variations Role of SMARCA4 Mutations in Ovarian Carcinoma: Preliminary Data from a Laboratory-based Multigene Panel Testing Cohort.https://www.ambrygen.com/file/view/1024/Herrera%20Mullar%20et%20al%20WAGO%202017%20SMARCA4%20ABSTRACT%203.20%20FINAL.pdfposter:https://www.ambrygen.com/file/view/1025/Herrera-Mullar%20J_WAGO%202017_Role%20of%20SMARCA4%20Mutations%20in%20Ovarian%20Carcinoma%20Preliminary%20Data%20from%20a%20Laboratory%20based%20Multigene%20Panel%20Testing%20Cohort_Poster.pdfResults of multi-gene panel testing in a gastric cancer cohort: it’s not all CDH1https://www.ambrygen.com/file/view/1218/Paudyal_NSGC%202017_Results%20of%20MGPT%20in%20a%20Gastric%20Cancer%20Cohort.pdfIs Bigger Always Better? An Updated Comparison of Multi-gene Panel Results for Common Cancershttps://www.ambrygen.com/file/view/1214/Panos%20L_NSGC%202017_Is%20Bigger%20Always%20Better%20An%20Updated%20Comparison%20of%20Multi-gene%20Panel%20Results%20for%20Common%20Cancers_Poster.pdf

Published Organic ChemistHyperpolarized Sodium [1-13C]-Glycerate as a Probe for Assessing Glycolysis In Vivo.https://www.ncbi.nlm.nih.gov/pubmed/28467066• Invited to the laboratory by the Principal Investigator, Kelvin Billingsley PhD, after excelling in his Organic Chemistry Lecture. • Synthesized a [13C]- Glycerate analog through flash column chromatography, calculated titrations, Separations, purification and recrystallization techniques, roto-vaping, and Proton and [13C] Nuclear Magnetic Resonance (NMR) to act as a cancer detection probe.• Collaborated with Prof. Daniel Spielman at Stanford University to use my product for In Vitro Hyperpolarized 13C Magnetic Resonance Spectroscopy Studies in Prostate Cell line (PC-3) to test toxicity of the product, along with Transgenic Adenocarcinoma of the Mouse Prostate (TRAMP) mice to serve as an In Vivo Hyperpolarized 13C MRS Studies.

Novato, Ca, Us

• Analyzed the yeast replicative lifespan of a large number of open reading frame (ORF) deletions.• Used Saccharomyces Cerevisiae as a model organism to further study in aging, work includes, but not limited to: creation of RNA primers, deletion genes, transformation of modified genes, Polymerase Chain Reaction (PCR), gel electrophoresis, yeast dissections, progeny crossing, recording in excel and word.

Provide routine pre-op, intra-op, and post-op care of the patient with acute and chronic conditions, in collaboration with the supervising nurse, through implementation of standardized procedures. Multitask while remaining professional and courteous in fast-paced environments. Prepare documentation needed for the admission and discharge of a patient. Oversee the flow of patients with coordination to the fluctuating surgery schedule through anticipatory turnover of operation rooms and patient bays. Excellent interpersonal and team building skills with an aptitude for building rapport with a diverse range of patients, families, managers, and colleagues. Conduct inventory tracking, ordering, invoices, and restocking with effective communication between the nursing staff and materials manager.