Elderberry Consulting
  • Links
  • Blogs
  • About
    • Why
      • Elderberry Capabilities Overview
  • Audio Recording
  • Contact
  • Roger Dahlin’s – Books
    • Dad’s Garden
  • Wedding
  • img

    Inquisitive passionate Subject Matter Experts (SME)

    Elderberry’s specialty: Highly complex projects requiring phased in delivery

    About Elderberry Consulting
  • img

    Engineering solutions for:

    Renewable Energy Projects

    Efficient, and discrete fixers
  • img

    Contract Negotiation for Capital and Construction

    Staff augmentation or complete outsourcing

    Contract

Highly complex projects requiring phased in delivery for occupied spaces

Business Solutions

Giving Small Businesses Big Impact

Business Intelligence Services

Our vast experience in project management and business intelligence makes us a leader in the industry. Custom reports and dashboards are just a few of the technologies we use to make your business data more palatable.

Web Services

We support the full life cycle of web based projects. Whether you have current solutions that aren't meeting your needs or are trying to bring your business onto the internet with a new web site or app, we can get you there.

Compliance, Quality and Risk Mitigation

Think of Elderberry for quality plans, investigations, root cause analysis and auditing services.

What keeps you up at night?

Contract Negotiation for Capital and Construction

Staff augmentation or complete outsourcing to meet your capital asset management project requirements.

Capital Asset Management Services

Meet Elderberry Team

We are a group of inquisitive polite Cost and Quality Engineers, Schedulers, Data Scientists, Project Managers and Marketing Geeks that love solving complex business problems.

Director of Operations, General ManagerCDahlin@ElderberryConsulting.com
 

Craig D.T. Dahlin (Director of Operations, General Manager)

Responsible for delivering on all aspects of business development, cost estimation, profitability, contract compliance, risk management, and quality of service.

Michael Pfleegor, CMA CFO
 

Michael Pfleegor, CMA (CFO)

Mike is the former Director of Finance at Penn State Health St Joseph with 17 years’ experience in the hospital & health care industry. Healthcare consulting, budgeting, and business process improvements are his expertise.

Cheryl MoonEagle Arndt, PhD
 

Cheryl MoonEagle Arndt, PhD (Director Analytics)

As researcher, director, and VP, She's performed qualitative, quantitative, and mixed methodology research across a wide array of social sciences applications.

Elderberry Consulting Blog

We are a group of inquisitive polite Cost and Quality Engineers, Schedulers, Data Scientists, Project Managers and Marketing Geeks that love solving complex business problems.

Nov 8,2018 Leave a Reply

Power BI skills – analysis and industrial internet of things

With our renewed push into industrial internet of things solutions we have been refreshing our Power BI skills. This included setting up a professional subscription to Microsoft Power BI. Elderberry Consulting is now able to embed the reports so that they are configured with public access. This way any one on the internet can use them. Additionally, it is very easy to publish into internal SharePoint sites. This includes utilizing Data Analysis Expressions (DAX) the programing / formulas used to generate measures and calculated columns.

Here are a few recent examples of our work:

  • Distribution / transformer networking reports
  • Financial management analysis of a nonprofit
  • Fleet Generation KPI’s

OSIsoft Analyzing PI system Data
Oct 26,2018 Leave a Reply

OSIsoft – Analyzing PI System Data

Thanks to our friends at Rajant Corporation I attended OSIsoft’s Analyzing PI System Data class this week. What I enjoyed most about the class was learning new business intelligence techniques that Elderberry Consulting can use to evaluate and audit industrial IOT data utilizing OSIsoft tools.

I’ll also point out that Rajant, and OSIsoft recently announced a partnership to bring enhanced industrial IOT offering to mining, transportation, energy, and oil & gas sectors.

Think of Elderberry Consulting for better reporting and analysis of your industrial IOT data. (See Example of PowerBi Reporting of the OSIsoft Data)

Together let’s prevent deviations,

Craig D.T. Dahlin
Director of Operations, General Manager
Elderberry Consulting, LLC
Email:CDahlin@ElderberryConsulting.com
http://www.ElderberryConsulting.com

The Pennsylvania Municipal Planning Education Institute (PMPEI) & The Lehigh Valley Planning Commission (LVPC) logo
Oct 17,2018 Leave a Reply

Community Planning

I am happy to report that I completed the community planning course presented by Pennsylvania Municipal Planning Education Institute (PMPEI). The event was sponsored and hosted by the Lehigh Valley Planning Commission (LVPC).

The coolest things I learned from attending the community planning course:

  1. How little knowledge I possessed of the actual interworking’s of municipal governance.
  2. How dedicated and hardworking our municipal representatives work to improve our communities.
  3. Finally, the true power of Joint Municipal Zoning (Article VIII-A). This provision allows municipalities to work together, plan for their future, regulate growth and change in a cooperative manner.
    I am happy to report that my township Heidelberg adopted a multi-municipal comprehensive plan for the northern region of Lehigh County the five other joining members are Slatington Borough, Lowhill, Lynn, Washington and Weisenberg Townships.

I would highly recommend this course to municipalities staff or citizens like myself that are simply interested in learning more about how our local Pennsylvania government works.

Other 2018 classes include:

  • Zoning Administration – starts October 16
  • Subdivision + Land Development Review – starts November 1

Craig Dahlin

Mar 4,2018 Leave a Reply

USAProgMusic

USAProgMusic Progressive rock in America and beyond

With a little help from their friends at Elderberry Consulting and Microsoft Skype, USAProgMusic launched their new website utilizing WordPress hosted on GoDaddy . This comes just in time for Rozfest music festival that takes place on May 4th in Gettysburg, PA. For more information on the event and use of  bands photographs contact Mike Flavin of USAProgMusic.

Recent Projects

Elderberry Consulting provides Market, Business & Finance Analysts disciplined in improving performance. Our Team of efficient, and discrete fixers will review your business units and translate your needs into actionable outcomes.

  • All
  • Business Optimization
  • Construction and Capital Projects
  • Product Development
Microsoft logo Business Analyst

Server Farm to Cloud Computing

Role: Business Analyst for migration of small six server farm to cloud computing servers tasks completed in 3 months. • Microsoft servers to Azure, Integrated Office 365 with Skype, Dynamics 365 CRM and SharePoint, upgraded previous addition of CRM to Dynamics 365 CRM, installed field service, project service and portals modules, set up custom fields, reports, marketing templates and campaigns. • Set up project document system by connecting SharePoint and MS Project online.

U.S. Department of Agriculture, Salem Oaks, Finance Analyst

Salem Oak Vineyards

Role: Finance Analyst - Working with the owner during the conception of the winery, developed feasibility study, business and marketing plan and cash flow analysis. Work was used to secure independent investors and receive $25,000 in grant funding from the U.S. Department of Agriculture. Salem Oak Vineyards has been in operation since 2008 selling over a half a million bottles of wine. My personal favorites wines are Julia-Marie, Mathis and Jessica Rose. Stop in and tell them Craig sent you.

USAProgMusic, Business Analyst

USAProgMusic – Progressive rock in America and beyond

Role: Business Analyst - With a little help from their friends at Elderberry Consulting and Microsoft Skype, USAProgMusic launched their new website utilizing WordPress hosted on GoDaddy .

Market Research product development

Market Reader Pro

Technology Guru (CTO), business analyst - global market research firm. • Developed technology & sales pipeline • Managed hundreds of projects with top tier clients (Microsoft, Whirlpool, IFF, Reckitt Benckiser, etc.). • Operational manager responsible for: defining scope of work, cost estimation, contract negotiation, scheduling resource planning, staffing, procurement, budgeting, scheduling and quality of delivery.

Supply Chain Management for the Health Care Industry & Businesses

Vizient/ Provista | Supply Chain Management for the Health Care Industry & Businesses

Role: Business Analyst - Oncology office in Chicago, provided preconstruction planning, along with business feasibility services.

international Flavors and Fragrances • Role: Business Analyst - Custom consumer market research tools integration of SQL Server SharePoint PowerPivot and Facebook focuses groups,

International Flavors and Fragrances – IFF

Role: Business Analyst - Custom consumer market research tools integration of SQL Server SharePoint PowerPivot and Facebook focuses groups, research report writer and dashboards developer

business plan , sell business, raise capital Pedricktown Tank Wash

Pedricktown Tank Wash Inc.

Role: Finance Analyst - Working with owner, developed business plan, raised $300,000 in capital to buy out partner, developed letters of intent to 70% of capacity. Owner sold company at terms that were very agreeable with him.

GSK

GSK – Compliance Manager (Sr Project Controls Specialist)

Provided staff augmentation - worldwide real estate and facilities construction activities. • Conducted root cause analyses related to product quality, good laboratory practices, environmental impact, financial irregularities, tax law, and state licensing requirements and developed corrective action/preventive action (CAPA) resolutions.

Trade Adjustment Assistance, TAA,United States Department of Labor

US Government Trade Adjustment Assistance (TAA)

Role: Business Planning Consultant - Provided business-planning consulting to 90 lobster famers in a territory that ranged from NY to MA. Regional top 10% performer and achieved over $780,000 of international grant money provided to individual businesses to help them improve their operations and P&L.

Legg Mason logo,Business Analyst -Managed multiple software projects

Legg Mason

Role: Business Analyst -Managed multiple software projects including gap analysis reviews on Enterprise Data Management, Business Intelligence Solutions, and Customer Relationship Management (CRM) systems (Salesforce, Microsoft Dynamics, Satuit, and others).

Provided staff augmentation (project controls /cost engineer) for transmission and distribution construction projects.

PPL Electric Utilities (PPL)

Provided staff augmentation (project controls /cost engineer) for transmission and distribution construction projects. • Integrated Primavera schedule, actual and accrual costs and estimate (WinEstimator) for a 1.2-billion-dollar construction project. PMBOK and DOE’s earned value management (EVM) compliant. Used for contingency cost and risk planning • GE and DOE smart grid project, 480 & 173 million-dollar power transmission distribution construction projects, New Operations / Data Center.

Product Development Childern Books The Otter Way

The Otter Way to Grow Up Happy & Healthy

Working with the JGA Marketing we provided consumer market research services for the The Otter Way series of books - Grow Up Happy & Healthy features six fun and colorful books that tell the tales of Crispin and Cristi Otter as they go on adventures and learn healthy habits along the way. This brother and sister duo are like little ones everywhere with their desire to explore the world around them and learn new things.

Federal Health Care Clinic

Role: Vender Contract Analyst - Elderberry Consulting performed vendor contract analysis for commissioning and site movement plans on a 20-million-dollar federal health care clinic upgrade.

The Heart Care Group, P.C.

Cardiologist Practice – The Heart Care Group, P.C.

Role: Business Analyst - Worked with The Heart Care Group, P.C. an east coast Cardiologist practice on their marketing and business development plan designed to transition their business to an outpatient practice based upon a preventative and integrated care model.

Microsoft logo Business Analyst

Server Farm to Cloud Computing

Role: Business Analyst for migration of small six server farm to cloud computing servers tasks completed in 3 months. • Microsoft servers to Azure, Integrated Office 365 with Skype, Dynamics 365 CRM and SharePoint, upgraded previous addition of CRM to Dynamics 365 CRM, installed field service, project service and portals modules, set up custom fields, reports, marketing templates and campaigns. • Set up project document system by connecting SharePoint and MS Project online.

U.S. Department of Agriculture, Salem Oaks, Finance Analyst

Salem Oak Vineyards

Role: Finance Analyst - Working with the owner during the conception of the winery, developed feasibility study, business and marketing plan and cash flow analysis. Work was used to secure independent investors and receive $25,000 in grant funding from the U.S. Department of Agriculture. Salem Oak Vineyards has been in operation since 2008 selling over a half a million bottles of wine. My personal favorites wines are Julia-Marie, Mathis and Jessica Rose. Stop in and tell them Craig sent you.

USAProgMusic, Business Analyst

USAProgMusic – Progressive rock in America and beyond

Role: Business Analyst - With a little help from their friends at Elderberry Consulting and Microsoft Skype, USAProgMusic launched their new website utilizing WordPress hosted on GoDaddy .

Supply Chain Management for the Health Care Industry & Businesses

Vizient/ Provista | Supply Chain Management for the Health Care Industry & Businesses

Role: Business Analyst - Oncology office in Chicago, provided preconstruction planning, along with business feasibility services.

business plan , sell business, raise capital Pedricktown Tank Wash

Pedricktown Tank Wash Inc.

Role: Finance Analyst - Working with owner, developed business plan, raised $300,000 in capital to buy out partner, developed letters of intent to 70% of capacity. Owner sold company at terms that were very agreeable with him.

Trade Adjustment Assistance, TAA,United States Department of Labor

US Government Trade Adjustment Assistance (TAA)

Role: Business Planning Consultant - Provided business-planning consulting to 90 lobster famers in a territory that ranged from NY to MA. Regional top 10% performer and achieved over $780,000 of international grant money provided to individual businesses to help them improve their operations and P&L.

Legg Mason logo,Business Analyst -Managed multiple software projects

Legg Mason

Role: Business Analyst -Managed multiple software projects including gap analysis reviews on Enterprise Data Management, Business Intelligence Solutions, and Customer Relationship Management (CRM) systems (Salesforce, Microsoft Dynamics, Satuit, and others).

The Heart Care Group, P.C.

Cardiologist Practice – The Heart Care Group, P.C.

Role: Business Analyst - Worked with The Heart Care Group, P.C. an east coast Cardiologist practice on their marketing and business development plan designed to transition their business to an outpatient practice based upon a preventative and integrated care model.

Supply Chain Management for the Health Care Industry & Businesses

Vizient/ Provista | Supply Chain Management for the Health Care Industry & Businesses

Role: Business Analyst - Oncology office in Chicago, provided preconstruction planning, along with business feasibility services.

GSK

GSK – Compliance Manager (Sr Project Controls Specialist)

Provided staff augmentation - worldwide real estate and facilities construction activities. • Conducted root cause analyses related to product quality, good laboratory practices, environmental impact, financial irregularities, tax law, and state licensing requirements and developed corrective action/preventive action (CAPA) resolutions.

Provided staff augmentation (project controls /cost engineer) for transmission and distribution construction projects.

PPL Electric Utilities (PPL)

Provided staff augmentation (project controls /cost engineer) for transmission and distribution construction projects. • Integrated Primavera schedule, actual and accrual costs and estimate (WinEstimator) for a 1.2-billion-dollar construction project. PMBOK and DOE’s earned value management (EVM) compliant. Used for contingency cost and risk planning • GE and DOE smart grid project, 480 & 173 million-dollar power transmission distribution construction projects, New Operations / Data Center.

Federal Health Care Clinic

Role: Vender Contract Analyst - Elderberry Consulting performed vendor contract analysis for commissioning and site movement plans on a 20-million-dollar federal health care clinic upgrade.

U.S. Department of Agriculture, Salem Oaks, Finance Analyst

Salem Oak Vineyards

Role: Finance Analyst - Working with the owner during the conception of the winery, developed feasibility study, business and marketing plan and cash flow analysis. Work was used to secure independent investors and receive $25,000 in grant funding from the U.S. Department of Agriculture. Salem Oak Vineyards has been in operation since 2008 selling over a half a million bottles of wine. My personal favorites wines are Julia-Marie, Mathis and Jessica Rose. Stop in and tell them Craig sent you.

Market Research product development

Market Reader Pro

Technology Guru (CTO), business analyst - global market research firm. • Developed technology & sales pipeline • Managed hundreds of projects with top tier clients (Microsoft, Whirlpool, IFF, Reckitt Benckiser, etc.). • Operational manager responsible for: defining scope of work, cost estimation, contract negotiation, scheduling resource planning, staffing, procurement, budgeting, scheduling and quality of delivery.

international Flavors and Fragrances • Role: Business Analyst - Custom consumer market research tools integration of SQL Server SharePoint PowerPivot and Facebook focuses groups,

International Flavors and Fragrances – IFF

Role: Business Analyst - Custom consumer market research tools integration of SQL Server SharePoint PowerPivot and Facebook focuses groups, research report writer and dashboards developer

Product Development Childern Books The Otter Way

The Otter Way to Grow Up Happy & Healthy

Working with the JGA Marketing we provided consumer market research services for the The Otter Way series of books - Grow Up Happy & Healthy features six fun and colorful books that tell the tales of Crispin and Cristi Otter as they go on adventures and learn healthy habits along the way. This brother and sister duo are like little ones everywhere with their desire to explore the world around them and learn new things.

All Rights Reserved - Elderberry Consulting, LLC