Dan Ebisawa

Dan ebisawa

bookmark on deepenrich
location of Dan EbisawaGreenbelt, Maryland, United States
Phone number of Dan Ebisawa+91 xxxx xxxxx
Followers of Dan Ebisawa13 followers
  • Timeline

    May 2018 - Aug 2018

    Laboratory Assistant

    The University of New Mexico Health Sciences Center
    Sept 2019 - Feb 2020

    Sales Associate

    New Balance
    Sept 2020 - May 2022

    Assistant Manager

    J.Crew
    Hanover, Maryland, United States
    Jul 2022 - Nov 2022

    Sales Coordinator

    Ampersand
    Sept 2023 - Dec 2024

    Database Specialist

    University of Maryland
    Current Company
    Sept 2023 - now

    Business Intelligence Analyst l

    Universal Service Administrative Co. (USAC)
  • About me

    Future DBA & Data Architect/Engineer

  • Education

    • Eleanor roosevelt high school

      2011 - 2015
      High school diploma
    • University of maryland global campus

      2022 - 2024
      Master of science - ms database systems technology
    • Prince george's community college

      2015 - 2017
      Associate's degree
    • University of maryland baltimore county

      2017 - 2021
      Bachelor of science - bs computational biology and bioinformatics

      Second Major: Biology

  • Experience

    • The university of new mexico health sciences center

      May 2018 - Aug 2018
      Laboratory assistant

      Worked independently on project assigned by principal investigator. Researched cell differentiation of mice brain cells from early progenitor cells to astrocyte and oligodendrocyte in response to multiple growth factors and external stimuli.

    • New balance

      Sept 2019 - Feb 2020
      Sales associate
    • J.crew

      Sept 2020 - May 2022

      • Supervised Men’s and Kid’s division.• Supervised visual aspects of the store such as mannequin, window props, and display. • Created BI reports using Microsoft Excel and Word based on sale trends.• Analyzed the sale trend derived from Qlik to modify the sale floor to highlight certain items for more visual presence• Keep store materials in stock by ordering supplies and keeping track of needed items.•Assisted store operation.

      • Assistant Manager

        Jan 2021 - May 2022
      • Sales Associate

        Sept 2020 - Jan 2021
    • Ampersand

      Jul 2022 - Nov 2022
      Sales coordinator

      Assist in running weekly political advertisement campaign during the political cycle. Provide correct rates for television ad buys and order confirmations to advertisement agency. Use spreadsheet-like platform to transmit ads buy and modifications to cable companies. Create Pivot table in Excel to document missed dollar amount from ads not aired properly.

    • University of maryland

      Sept 2023 - Dec 2024
      Database specialist

      - Design Entity-Relationship Diagrams to store student athletes' performance data and business data related to the athletics department in 3NF and Dimensional Model formatArchitect end-to-end data pipeline from sources to reporting using Azure DevOps pipeline and MS Fabric- Create an enterprise data warehouse with a 3-layer Medallion Architecture with data from various sources related to athletics, including Paciolan, Fanatics, Catapult, Vald, Perch, and National Statistical, and develop PowerBI dashboards for business stakeholders, ranging from athletic trainers to media teams in MS Fabric- Create SQL queries and PySpark scripts against databases to answer ad-hoc business questions- Optimize and reduce the compute time of the Merge statement by 50% against delta tables using partition pruning Migrate existing ETL pipelines to ELT pipelines into MS Fabric with Azure Blob Storage as a data lake- Integrate Azure DevOps with MS Fabric to implement version controlling and CI/CD principle- Monitor database logs, data pipeline logs, and downstream PowerBI reporting for troubleshooting and potential data discrepancy from sources- Implement data governance, data catalog, and business glossary using Azure Purview to ensure the entire ecosystem complies with the University's security compliances Show less

    • Universal service administrative co. (usac)

      Sept 2023 - now

      - Design an Entity-Relationship Diagram that relates business capabilities and processes to IT assets to allow top- down visualization of dependencies and to associate ownership to IT assets- Create POC of CMDB on MS Access with visualization capability utilizing VBA scripts to connect front-end UI and back-end functionality- Assist in the implementation of Collibra to visualize data lineage and manage data assets for enterprise-level data governance- Create ad-hoc script on DuckDB and Jupyter Notebook to process PDF files to structured data- Help migrate ServiceNow and BMC Footprint ITSM workflows to Atlassian Service Management Show less

      • Business Intelligence Analyst l

        Jan 2025 - now
      • Enterprise Architect

        Sept 2023 - Jan 2025
  • Licenses & Certifications