Summary
Overview
Work History
Education
Software
Certification
Timeline
Generic

Brad Julian

Business Intelligence / Systems Developer
234 East 300 North Orem Utah, 84057,UT

Summary

Experienced Business Intelligence Analyst with a strong foundation in Lean Manufacturing principles, including Six Sigma, Standard Operating Procedures, Poka-yoke, Ishikawa (root cause analysis), Value Stream mapping, and Kaizen events. Extensive knowledge of Industry 4.0 and IIOT structures, systems, and protocols. Proficient in ETL/data processing using REST API, Python, Azure Data Factory, Azure Synapse, Azure Analysis Services, and Microsoft Fabric. Skilled in Office365 suite (Excel, Visio, Project, SharePoint, Power Automate, Power BI/Fabric), Microsoft SQL Server/MySQL Server administration and development. Proficient in Business Workflow software (Decisions, Trello, Asana) and CAD experience with SolidWorks. Possess advanced mechanical expertise in mechanical and electrical schematic understanding and troubleshooting.

Overview

23
23
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
3
3
Languages

Work History

Business Intelligence Analyst

Ultradent Products
South Jordan, Utah
02.2021 - 05.2025

Business Intelligence Analyst that represented manufacturing arm of Ultradent Products.

  • Lead in the researching, acquiring and deployment of business systems to accommodate the move to Industry 4.0. Including moving to a report by exception model and inclusive IIOT systems and protocols (UNS - Unified Name Space, MQTT, Sparkplug B)
  • Heavily involved in a moving working databases and data warehouses from on premise servers to Azure Cloud Services and Fabric workspaces
  • Extensively used REST API with Postman and Power Query Data Flows to seamless integration of disparate data sources into cohesive analytical frameworks for comprehensive reporting purposes.
  • Implemented robust data warehousing solutions that provided a single source of truth for critical business information.
  • Championed a data-driven culture within the organization by promoting the use of analytics tools and methodologies across departments.

Quality Systems Engineer

IntelliServ
Provo, Utah
03.2019 - 12.2020

Systems administration including developing UX and new automated process flows for the manufacturing of wired drill pipe for the Oil and Gas Industry

  • Administrated: PTC Windchill, J.D. Edwards ERP, MS SQL Server, MYSQL Server, Decisions Workflows, and several home grown platforms for manufacturing traceability and quality records
  • Developed new business work flows with UX and automation to help stream line business concerns and issues (Delegation of Authority, purchasing requisitions, management of change)
  • Built and maintained custom dashboards to feed information from SQL databases to stakeholders and management to help answer and respond to business needs

Manufacturing Engineering

Schlumberger Megadiamond
Provo, Utah
01.2009 - 12.2018

Process Engineering/Manufacturing Technician focused on the manufacturing of PCD (polycrystalline diamond)

  • Industry 4.0 implementation of modular systems including seamless data exchange, cloud collaboration and connected cellular manufacturing
  • Lean manufacturing trainer including Value Stream Mapping, 5S, Poka Yoke, Visual process control/management
  • Developed and implemented brazing/bonding product value stream and manufacturing process for joint Caterpillar/Megadiamond product
  • Developed and deployed real-time analytic dashboards and KPI's to drive performance based goals and increase first pass yield using Google API and MySQL
  • Developing machine based vision and learning using multiple systems (Keyence, Python, R) to aid in decision making during the manufacturing process

Shop Foreman

Kitchens Direct
06.2005 - 01.2009
  • Oversaw production of modular cabinets
  • Scheduling of all aspect of cabinet manufacturing from order placement to final inspection/delivery/installation
  • Handled resource management for multiple installation sites including several large multi-unit projects

Raised Flooring Technician

Intellivex
10.2002 - 06.2005
  • Installed raised access flooring
  • Working on multiple technology install sites on the U.S. West coast
  • Developed working relationships with several large general contractors
  • Skilled with theodolite surveying of installation sites for layout of floor

Education

Some College (No Degree) - Information/Computer Science

University Of Evansville
Evansville, IN
08.1996 - 11.1998

High School Diploma -

Hamilton High School, High School Diploma
Hamilton, OH
08.1994 - 08.1996

Software

Microsoft Office 365 (Excel, Access, Word, Power Point, Visio, Project, SharePoint)

Decisions Workflows / Microsoft Power Automate (business workflow automation software)

Microsoft SQL Server, Azure Synapse SQL, MySQL server, T-SQL, PL-SQL

MS PowerBI (DAX, M Query Language, Report Builder)

Python for Data Analytics (Pandas, Numpy, Mathplotlib, Bokeh, Scikit-learn)

Microsoft SQL Analytical Services (SSAS), Azure Analytics Services, Fabric Workspaces

Multiple ERP systems (JD Edwards, Oracle, Sage MAS 90, Alliance MFG, MAX MFG, Crystal Reports)

SolidWorks CAD

Certification

Lean Transformation Certification (World Class Transformations)

Timeline

Business Intelligence Analyst

Ultradent Products
02.2021 - 05.2025

Black Belt Advance Business Systems - Lean / Continuous Improvement (IntelliServ) 

08-2019

Quality Systems Engineer

IntelliServ
03.2019 - 12.2020

Green Belt Continuous Improvement / Lean (Schlumberger)

05-2018

Mindfulness Meditation and Teaching (Elevate Corporate Wellness)

10-2016

Lean Transformation Certification (World Class Transformations)

08-2015

Manufacturing Engineering

Schlumberger Megadiamond
01.2009 - 12.2018

Shop Foreman

Kitchens Direct
06.2005 - 01.2009

Raised Flooring Technician

Intellivex
10.2002 - 06.2005

Some College (No Degree) - Information/Computer Science

University Of Evansville
08.1996 - 11.1998

High School Diploma -

Hamilton High School, High School Diploma
08.1994 - 08.1996
Brad JulianBusiness Intelligence / Systems Developer
Create your own profile for free at Zety.com