Douglas Albright
Data Warehouse Architect And Business Intelligence Expert
Sinking Spring,PA
Summary
With over 20 years of experience in control system integration and data warehousing, I am an experienced leader with a proven track record of success in the production operations domain. My expertise in ELT, IoT, and Azure, as well as my ability to design and engineer high-performance, scalable, and secure data solutions, make me well-suited to lead teams in digital transformation efforts. I am familiar with Agile product development and DevOps frameworks and skilled in identifying areas where IT can support business needs and driving continuous improvement. I have a deep understanding of MES, ERP, and MRP systems and how they can be integrated to improve production operations. My experience in designing and implementing data integration solutions to connect these systems with production data sources, as well as my knowledge of key data mapping and data transformation considerations for ERP integration projects, make me a valuable asset for any organization looking to modernize their production operations. In addition, I have a wealth of experience leading teams and managing projects. The resources and strategy sections of my resume are designed to facilitate conversations on these topics and to ensure that any digital transformation effort is successful.
Overview
24
24
years of professional experience
Work History
WONDERWARE EXPERT
01.2018
- Automated manual reporting, freeing workers from manual data collection
- Built datasets for tank usage, progressive loss reporting, and utility usage analysis
- Expertise in SCADA and MES systems and report automation
DATA ENGINEER II
BOSTON BEER COMPANY
01.2022 - 01.2023
- Promote, develop, and extend the Production Operations Data Warehouse
- Enrolled in the Digital Mastermind program and became an active member of the 4.0 Solutions Community to retool for Digital Transformation strategy and architectural design
- Led efforts to retool daily reporting used by Breweries resulting in improved efficiency
FULL STACK BI DEVELOPER
BOSTON BEER COMPANY
01.2018 - 01.2022
- Consolidated hundreds of Power BI pages into a self-service platform
- Led the development of a schedule planning vs
- Actual Activities data platform
- Responsible for reporting key KPIs such as OEE, Downtime %, and Throughput calculations
- Successfully implemented a data warehouse solution that brought together enterprise and operational key metrics, resulting in improved cross-functional collaboration between production operations and enterprise resource planning teams
- Identified the correlation between starting on plan and profit margin, which was recognized as the best indicator for achieving operational success, leading to enhanced decision-making and strategic planning across the organization
- Facilitated the integration of data from multiple business domains, contributing to a more comprehensive understanding of organizational performance and enabling data-driven decision-making at all levels
- Championed the adoption of the data warehouse solution across the organization, resulting in increased efficiency, streamlined reporting, and improved data quality for key performance indicators
MES ENGINEER III
AVANCEON
01.2014 - 01.2016
- Acted as an Engineering project lead for MES integration projects
- Implemented MES solutions and served as a consultant to clients
- Developed custom interactions using C# and SQL
DIRECTOR OF OPERATIONS AND SOFTWARE
DEVELOPMENT, AI CONTROL SYSTEMS
01.2006 - 01.2014
- Managed the daily operations of engineering control and information systems
- Managed vendor relationships and ensured employee productivity
- Focused on MES solutions and SCADA solutions
BUSINESS DEVELOPMENT MANAGER
AI CONTROL SYSTEMS
01.2003 - 01.2006
- Worked for a small control systems integration firm, where my responsibilities included working with clients to define, develop, and deliver finished control solutions
- These solutions primarily focused on PLC and motion control and required integrating controls with mechanical systems
- Additionally, I was responsible for designing advanced user interfaces that utilized SCADA and reporting visualizations, as well as plant floor communication protocols
PROJECT LEAD APPLICATIONS DEVELOPER
EBLOX, INC
01.2000 - 01.2003
- Developed e-commerce solutions for catalog-based companies making their first large-scale ventures into e-commerce
TECHNICAL WRITER
LOCKHEED MARTIN
01.1999 - 01.2000
- Created highly automated reporting solutions using Oracle SQL servers and Microsoft ASP in a military setting
- Personal Anecdotes:
- One of the most memorable experiences in my professional career was when I was recognized by the founder of Boston Beer Company, Jim Koch, for speaking up at a critical moment during an all-hands meeting
- I shared my perspective on the importance of discussing topics that in other companies may become undiscussable and how this value, known as DTUs (Difficult to Discuss Topics), can be used to empower all employees to bring forward their ideas and perspectives, regardless of where they come from
- I emphasized that this is a business reason and how our company's founder, Jim Koch, built a thriving multi-billion-dollar company by enforcing this value
- This experience solidified my belief in the value of DTUs and the importance of encouraging a culture where all voices are heard, and the best ideas are implemented
- It further solidified my commitment to Digital Transformation and finding ways to empower all employees to bring forward their ideas and perspectives.
Education
Bachelor of Business Administration -
Temple University
Skills
Key performance indicators
undefinedAccomplishments
- Certifications:
- Over 1000 hours of applied training with Pragmatic Works, a leading trainer for ML, BI, and AI
- Certified Wonder Ware MES and SCADA Integration
- Certified Inductive Automation SCADA Integration
- Skills:
- ETL development
- Microsoft SSIS
- SQL, T-SQL, PLSQL
- Data visualization tools (Qlik, Tableau, Power BI, etc.)
- Azure (Data Factory, Data Lake, etc.)
- ERP integration and implementation
- Management and Leadership, strategy and practices
- Data integration and transformation
- Industrial Communication protocols and data interloper operability
- ERP system customization and optimization
Timeline
DATA ENGINEER II
BOSTON BEER COMPANY
01.2022 - 01.2023
WONDERWARE EXPERT
01.2018
FULL STACK BI DEVELOPER
BOSTON BEER COMPANY
01.2018 - 01.2022
MES ENGINEER III
AVANCEON
01.2014 - 01.2016
DIRECTOR OF OPERATIONS AND SOFTWARE
DEVELOPMENT, AI CONTROL SYSTEMS
01.2006 - 01.2014
BUSINESS DEVELOPMENT MANAGER
AI CONTROL SYSTEMS
01.2003 - 01.2006
PROJECT LEAD APPLICATIONS DEVELOPER
EBLOX, INC
01.2000 - 01.2003
TECHNICAL WRITER
LOCKHEED MARTIN
01.1999 - 01.2000
Bachelor of Business Administration -
Temple University
Similar Profiles
Rubina MontapertRubina Montapert
Patient Relations Manager at Expert Dental Midtown & Expert Dental TribecaPatient Relations Manager at Expert Dental Midtown & Expert Dental Tribeca
Abbey FriedmanAbbey Friedman
Behavioral Health Expert Witness at The Expert Witness InstituteBehavioral Health Expert Witness at The Expert Witness Institute
Abigail AlmAbigail Alm
Climbing Arborist at Davey Tree Expert CoClimbing Arborist at Davey Tree Expert Co
Shara BredbnenerShara Bredbnener
Server at Victor Emmanuel’s ClubServer at Victor Emmanuel’s Club
Sarah StavarskiSarah Stavarski
Load Planner at Penske Logistics,Load Planner at Penske Logistics,