M

Miguel Morales

About

Detail

California, United States
Contact Miguel regarding: 
work
Full-time jobs
Starting at USD80k/year

Timeline

work
Job
folder
Project

Résumé

Jobs verified_user 0% verified
  • Blueprint Test Prep
    Senior Data Analyst
    Blueprint Test Prep
    Mar 2022 - Jul 2025 (3 years 5 months)
    ❖ Collaboration: Worked with internal stakeholders to understand their business needs and deliver data products that would resolve their issues (reports, excel workbooks with macros, daily emailed data dumps, automated data transformations, etc). ❖ Reporting: Used SQL (Redshift and Snowflake) and Looker to create complex queries combining disparate data sources (web scraping bots, zoom data, etc). Performed ad hoc analysis using Python for more complex requests, Excel was utilized for less technical/c-level executive reports. ❖ Ingestion: Maintained and optimized ETL pipelines (10's GB daily and 100's of GBs stored) as well as created and maintained transformations (Airbyte & dbt). Mastered numerous AWS services: Glue, Lambda, EC2, ECR, etc
  • Facebook
    Data Analyst
    Facebook
    Jan 2021 - Jan 2022 (1 year 1 month)
    ❖ Analysis: Was a member of the Civic Integrity team which focused on impersonations of civic related people/relationships. Involved deep statistical discussions about past and current behaviour, historical analysis, and developing and improving metrics by presenting statistically significant and compelling data. ❖ ETL & Reporting: Used SQL and internal tools to create new tables for own analysis, transformed data to allow for more efficient analysis, and created reports for stakeholders. Presented these reports as well as offered guidance into insights and further research. Used Python (w/ Numpy, Pandas, Scikit-Learn, and other ML packages) to perform more complex analysis and reporting.
  • Dolls Kill
    Business Intelligence Analyst
    Dolls Kill
    Sep 2018 - Dec 2020 (2 years 4 months)
    ❖ Collaboration: Partnered with internal teams (marketing, product, operations, etc) to develop reports and dashboards. Involved managing tickets onJira as well as maintaining documentation on Confluence. ❖ Data Ingestion: Used DBT to manage data pipelines to automate data ingestion (ETLs, scripts, etc) and transformations across marketing, e-commerce, and customer behavior datasets. Reporting: Launched a new Looker instance and built many of the models and the initial reporting. Continued using SQL to maintain Looker instance (user groups, model development, reporting, etc) as well as support other legacy reports (Power BI and excel). Managed excel workbooks for the finance team and used Python for other ad hoc analysis. ❖ Led the implemen
Education verified_user 0% verified
  • UC Berkeley
    B.S. in Applied Mathematics
    UC Berkeley
  • G
    Google Data Analytics Professional Certificate
  • G
    Google Professional Data Engineer
Projects (professional or personal) verified_user 0% verified
  • O
    Open AI Wrapper
    Jan 2025 - Jun 2025 (6 months)
  • L
    LLM/AI Development
    Jan 2025 - Jun 2025 (6 months)
  • A
    A/B Testing
    Sep 2018 - Dec 2019 (1 year 4 months)
  • S
    SQl 2 NL
    Created application to convert SQL code into readable natural language (NL). Uses publicly available SQL/NL data but can also take in custom pairs to train models. Developed a program to convert SQL to natural language (NL) i.e. a SQL chatbot. Based off of the previous program, this program was developed to have more control of the training and tuning process. I used Open AI for embeddings, Facebook AI Similarity Search (FAISS) to store vectors locally, and Google's flan-t5-small generator.
  • L
    LLM Fine Tuning