Brendan Phan

Business Intelligence Consultant at DesignMind
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
San Francisco Bay Area

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • MPN Competency: SQL Server 2016 - Mission Critical and Hybrid (MPN14355)
    Microsoft
    Feb, 2020
    - Nov, 2024
  • MPN Competency: Data Platform & Analytics Foundational for Data Platform Competency (MPN14354)
    Microsoft
    Jan, 2019
    - Nov, 2024
  • Analyzing and Visualizing Data with Microsoft Power BI
    Microsoft
    Mar, 2020
    - Nov, 2024

Experience

  • DesignMind
    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Business Intelligence Consultant
      • Feb 2022 - Present

      •Developed analytic reports through Power BI and Paginated Report Builder that capture KPIs for executives.•Migrated Power BI reports to different Data Warehouses (HANA to Snowflake). •Optimized Data model for dashboard performance by using appropriate joins, removing unused columns and inactive relationship. •Created SQL views to convert import mode Power BI reports to Direct Query by switching Dataflows to the views. •Constructed refresh automation through Dataflows and Power Automate for Power BI reports.•Engineered parameters in Power Query that switches between Development and Production Workspaces and Dataflows.•Calculated KPIs with DAX (calculated column and measures) and custom columns in Power Query.•Enhanced Row Level Security in Power BI that limits data access through a Division, Region, and Role level. •Managed Offshore team by assigning them incident and enhancement tickets.•Presented at a user group meeting on Power BI advanced UI/UX techniques with addition to a blog post and videos. Show less

    • Report Developer
      • Mar 2020 - Feb 2022

      • Individual and team contributor for developing the entire stack of 8 production Power BI Apps for Finance, C-level Executives, Accounting Ops, Senior Sales VPs, Global Sales, Global Marketing, and Onboarding teams. • Turned Dashboard mockups into powerful Power BI reports that are fully productionalized which leverage different navigation and interactivity techniques. UX features included interweaving buttons, bookmarks, what-if parameters, slicers (hidden and not), spotlighting, dashboard tiles, and report level measures.• Maintained the release process for all Power BI apps which included managing reports, paginated reports, datasets, dataflows, and dashboards within workspaces. Upkept versions, runbooks and data dictionaries in Sharepoint and/or Teams, as well as securing access with appropriate security groups.• Updated reports with real-time connections to Dynamics 365 CRM leveraging the new Dataverse connection with minimal impact to performance.• Maintained dataflows/datasets leveraging Redshift data warehouse in both Dev and Production workspaces.• Developed and trained users on paginated reports and excel reports for operational reporting using subscription and on-demand techniques.• Designed reports and datasets iteratively through regular meetings with stakeholders, analysts, and end users to create new dashboard layouts, enhancements, filter capabilities, and information elements to make reports as intuitive and user-friendly as possible. Show less

    • Contract Administrator
      • Jan 2020 - Mar 2020

      •Executed writing statements of work, mutual nondisclosure agreements, and scope of work. •Reviewed company and clients contracts within the company.•Monitored multiple ongoing projects.

  • Zen Sushi Bistro
    • Food Server
      • Jan 2017 - Sep 2017

      •Multitasked in maintaining facility, delivering food, and table presentation. •Delivered strong verbal communication skills among employees and customers in a fast paced environment. •Provided support to employees to increase efficiency of the workplace and customer experience. •Multitasked in maintaining facility, delivering food, and table presentation. •Delivered strong verbal communication skills among employees and customers in a fast paced environment. •Provided support to employees to increase efficiency of the workplace and customer experience.

Education

  • University of California, Davis
    Bachelor's degree, Economics
    2017 - 2019

Community

You need to have a working account to view this content. Click here to join now