Joseph Choi Email & Phone Number

Sacramento, Ca, Us

Sacramento, Ca, Us

Phoenix, Az, Us

Responsible for the development of project control reports and data management solutions at a leading construction management corporation.● Design, develop, and maintain data models, dashboards, and paginated reports using SQL, Power BI Desktop, and Power BI Report Builder to deliver insights and KPIs to internal and external clients● Develop automation solutions to streamline project control processes, including cost control, scheduling control, and data collection to improve efficiency and reduce manual efforts using SQL, Power Query, and Power Automate● Maintain comprehensive documentation of dashboard development processes, risk management reports, and automation solutions, ensuring clarity and ease of use for end-users● Deliver training and support to end-users, enabling them to effectively utilize dashboards and automation solutions● Collaborate with the IT department to ensure compliance with data governance and security standards, maintaining the confidentiality, integrity, and availability of project data

Cypress, Ca, Us

Responsible for data analytics, project management, and BI systems support for a major motorsport manufacturer.● Developed automated inventory and cost reporting processes using SAP and SQL to generate and export key data, resulting in a 50% increase in domestic transportation operational efficiency for supply chain management● Created 5 data models and 25+ dashboards using Power BI that improved visibility by 80%, enabling stakeholders to understand key metrics such as On-Time Delivery, Damage and Loss, and Cost per Shipment● Developed and executed ETL pipelines utilizing SQL and Power Query, simplifying the data collection process and significantly improving accuracy, resulting in a 100% reduction in search query time for data processing

Oversaw in-house data operational procedures for optimization and efficiency at a leading 3PL firm.● Managed and streamlined daily data operations for a team of 5 coordinators, conducting training sessions on leveraging Excel to make data-driven decisions, resulting in a 20% increase in efficiency● Conducted comprehensive performance reviews for all 5 team members, analyzing key transportation metrics and providing actionable recommendations, which resulted in a 20% increase in overall productivity● Created internal dashboards using Tableau to visualize core business KPIs, improving visibility into overall financial performance and resulting in a 20% increase in data accessibility and efficiency for the organization

Front-line point of contact for all data channels of distribution for an established 3PL firm.● Developed 50+ dashboards for large-scale accounts, resulting in a 20% increase in transportation operational efficiency for customers in Tableau● Generated comprehensive daily reports analyzing customer logistics metrics and target goals, resulting in a 15% increase in on-time deliveries● Designed and executed a cost analysis model to identify areas of inefficiency in transportation operations, resulting in a 5% reduction in freight costs

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Data Science

Education record