EIS - Black Diamond | OneStream Solutions

EIS + ONESTREAM

Case Study

ABOUT EIS

EIS is a leading North American distributor of process materials, production supplies, specialty wire and cable and value-added fabricated parts for the electrical OEM, motor repair and electronic assembly markets.

THE CHALLENGE

EIS was in a constant state of growth through acquisition and they had no enterprise CPM. Their excel process was manual which led to lost time and efficiency and was prone to formula errors. Currency translation and Intercompany Eliminations were all manual. Using many tools such as Blackline for Account Reconciliations, Excel for consolidations and planning, and Sisense for Reporting created integration and visibility challenges. Consolidations was a “must-have” with the real goal of creating forward looking budgets and forecasts longer term. Excel was not providing the level of visibility they needed to analyze Actuals. Ultimately, they wanted to drill back to their source systems.

INDUSTRY
Private Equity Owned – Leading Distributor of Specialty Electrical Parts
REVENUE
$761.36m
FORMER EPM
Excel, Blackline, Sisense
EVALUATED
Hyperion Panning, Planful
BENEFITS SUMMARY
- Modeling in OneStream created views for Year over Year price/mix/ volume attribution.
- READ MORE

ELEMENTS OF SUCCESS

OneStream XF Planning, Financial Consolidation, Executive Reporting, Account Reconciliation

THE PROJECT

Built a system that allows them to build a budget, build a Long-Range Plan and track a monthly rolling forecast:
• By person labor planning model, a direct connect to ADP for employee/workforce information and insight.
• By asset class capital expenditure model that calculates depreciation based on class depreciable life.
• Created an M&A event model with adjustable event date and full IS/BS costs water-falling from event date.
• Built revenue model that incorporates raw material pricing, allows for YoY price/mix/volume attribution.
• Allowed for balance sheet modeling providing DSO/DIO/DPO inputs to drive working capital, debt schedule planning, prepaids/accruals driven by % of sales, and roll forward level of detail for fixed assets.

TECHNOLOGY & INTEGRATION
SAP, EBS and various other G/L
BUSINESS CHALLENGES
- No enterprise CPM, everything was manual
- They wanted the ability to drill back to their source system data
- Currency translation and Intercompany eliminations were all manual
- Using so many tools created integration and visibility challenges
SCOPE
Planning & Forecasting, Consolidations, Executive Reporting, Account Reconciliations, Private Equity

KEY BENEFITS

Black Diamond implemented a solution that allows EIS to build a budget, long-range plan, and track monthly rolling forecast.

The use of OneStream offered increases visibility of price/mix/volume impact on YoY numbers combined with the modeling capability and creates views for Year over Year price/mix/ volume attribution.

EIS experienced large gains in the ability to produce financial statements at differing levels of granularity while extending their analysis and reporting capability for near real-time results.

The balance sheet modeling methodology implemented by Black Diamond provides DSO/DIO/DPO inputs to drive working capital, debt schedule planning, prepaid/accruals driven by % of sales, and roll forward level of detail for fixed assets.

Labor planning by person model is directly connected to ADP for employee/workforce information and insight.

Implemented by asset class capital expenditure model that calculates depreciation based on class depreciable life.

Created an M&A event model with an adjustable event date and full IS/BS costs waterfalling from the event date.

OneStream Software allowed EIS the flexibility to bring new acquisitions into the fold easily, despite various source systems.

ABOUT BLACK DIAMOND

Black Diamond is the leading Digital Finance Transformation firm and OneStream Diamond Partner. We leverage the depth of experience and breadth of knowledge to define client needs. We are industry Experts who anticipate current and future challenges and share our experience and knowledge to address them. We seek to have joint development of the solutions we create and remain engaged with clients throughout the entire transformation journey to ensure the greatest value is derived.

Black Diamond Advisory is based in Golden, Colorado. Our Advisory and Consulting Experts are located throughout the United States and are deployed to each customer location to provide hands-on support through the duration of the implementation process. For more information, visit www.blackdiamondadvisory.com or on LinkedIn at https://www.linkedin.com/company/blackdiamondadvisory

SHAUNA GOODSELL

Shauna offers over 17 years of functional and program leadership experience in national and international software implementations. She effectively managed and delivered over 20 complex performance management projects. She ensures client success by being a dedicated partner to the client. She believes successful projects are achieved based on frequent and concise communication, transparency, and discipline. .

Shauna’s Why:

I came to Black Diamond to be part of an “A” rated team. Where the leadership has a clear vision and aggressive strategy for the future and growth.

JASON KARBER

Jason is a Black Diamond practice manager. Over an 18 year career at Koch Industries, he ranged from transactional accounting and ledger ownership to complex consolidation and leadership roles at multiple business divisions and industries. He has reputation for customer focus and driving change. By writing the business case for OneStream and overseeing the replacement of legacy technology, he has coordinated entire organizations digital transformation. His customer spectrum includes finance staff, controllerships, information technology and C-Suite executives.

Jason’s Why:

“Helping people be more more effective with world class technology is very fulfilling.”

MIKE VANNONI

Mike uses his experience to guide clients through transformational OneStream projects. Mike is an energetic, entrepreneurial-minded individual known for his ability to partner, strategize, problem-solve and deliver. His 20 years of related work experience in a variety of industry verticals combined with excellent communication skills, strong business acumen and team approach are the foundation of his success at Black Diamond Advisory.

Mike’s Why:

When you’re finished changing, You’re finished.’ – Benjamin Franklin.

VINCENT VALENTINE

Vincent, Chartered Accountant and Solution Architect, specializes in OneStream encompassing enterprise. He focuses on performance management, consolidation, planning, strategic financial planning & EPM related integrations and architecture. He connects the world of Finance and IT to translate business needs into the methods of technologists. His diligent work ensures successful CPM/EPM implementations. Vincent’s hard work and enthusiasm delivers the highest quality results.

Vincent’s Why:

At Black Diamond, I get to help make our clients efficient. There are things that people do well, and yet others that computers do well. I strive to find the efficient balance.

JOE TOMLIN

Joe offers over 15 years of business and technical experience in financial consolidations and reporting. He identifies business processes requiring improvements from minor enhancements to a complete overhaul. His ability to think outside the box for a better solution delivers success. His expertise in consolidation and account reconciliations transports the client success to life when implementing OneStream.

Joe’s Why:

I came to Black Diamond to become a ‘doer of things that matter’, and to hold myself accountable for our customer’s successes.

MARK GOODMAN

Mark has 20+ years of experience in the EPM space specializing in consolidations working with OneStream, HFM, and FDM/FDMEE. He has a proven track record of blending finance and IT by combining Big Four auditing background with software programming skills. He has end to end experience including leading design sessions, metadata and rules build, mapping/data integration, knowledge transfer, reports build, end-user training, and post-go-live support.

Mark’s Why:

“Get busy living.. or get busy dying.” –Andy Dufresne – Shawshank Redemption

SHERRI SCHAFFROTH

Sherri brings over 20 years’ experience in strategic new business development, marketing, and sales of software and services in the Commercial and Government sectors. She is a Managing Partner of Black Diamond and a former Director of Sales and Marketing, serving several Alliance Partners for IBM, Oracle, and OneStream.

Prior to her Alliance experience, Sherri served on the Corporate Leadership Round Table, was consistently nominated to Elite President’s Club Membership, and was awarded a US Commercial Sales Innovation Award, as a result of accomplishments at SAS, IBM, and Oracle.

Sherri’s Why:

“Surround yourself with people who are smarter than you are.” – Henry Ford

“Seek first to understand.” – Steven Covey

RANDY WERDER

Randy brings over 30 years of business and industry experience to Black Diamond. He is a Co-Founder of Black Diamond. Formerly, Randy was the Managing Director of Alithya’s OneStream Practice. He was one of the original members of Ranzal & Associates where he served in many leadership roles including Southeast Planning & Essbase Leader for delivery and Managing Director of the Advisory Practice. As an implementation thought leader, Randy has guided over 150 global clients in re-engineering their outdated planning processes into industry-leading successful solutions.

Randy’s Why:

If you are not the lead dog, the view never changes.

Common sense is not that common.

CARL YOST

Carl brings more than 25 years of experience in business consulting to help clients transform their financial and business application processes. He is Co-Founder of Black Diamond and former Managing Principal of Grant Thornton’s Technology Solutions Practice. Prior to joining Grant Thornton, he was a partner and co-founder of MarketSphere Consulting, serving many leadership roles including chief operating officer and national industry leader. Having served organizations in multiple industries and varying sizes, Carl’s expertise in finance and operations has led him to develop best practices and thought leadership leveraged across several industries. Prior to founding MarketSphere, Carl was a Partner in the Enterprise Performance Management practice of Arthur Andersen and held senior finance executive positions at Motorola and Wyeth.

Carl’s Why:

Experts Only represent that our firm should be a destination employer – the best OneStream talent in the world will have a family and a home at Black Diamond.

We don’t implement projects; we deliver solution platforms.

Name*
First Last
Company Name*
Email*
Enter Email Confirm Email
Black Diamond Advisory is committed to protecting and respecting your privacy, and we’ll only use your personal information to administer your account and to provide the products and services you requested from us. From time to time, we would like to contact you about our products and services, as well as other content that may be of interest to you. If you consent to us contacting you for this purpose, please tick below to say how you would like us to contact you:
I agree to receive other communications from Black Diamond Advisory.
You can unsubscribe from these communications at any time. For more information on how to unsubscribe, our privacy practices, and how we are committed to protecting and respecting your privacy, please review our Privacy Policy.

By clicking submit above, you consent to allow Black Diamond Advisory to store and process the personal information submitted above to provide you the content requested.

Name*
First Last
Company Name*
Email*
Enter Email Confirm Email
Black Diamond Advisory is committed to protecting and respecting your privacy, and we’ll only use your personal information to administer your account and to provide the products and services you requested from us. From time to time, we would like to contact you about our products and services, as well as other content that may be of interest to you. If you consent to us contacting you for this purpose, please tick below to say how you would like us to contact you:
I agree to receive other communications from Black Diamond Advisory.
You can unsubscribe from these communications at any time. For more information on how to unsubscribe, our privacy practices, and how we are committed to protecting and respecting your privacy, please review our Privacy Policy.

By clicking submit above, you consent to allow Black Diamond Advisory to store and process the personal information submitted above to provide you the content requested.

Name*
First Last
Company Name*
Email*
Enter Email Confirm Email
Black Diamond Advisory is committed to protecting and respecting your privacy, and we’ll only use your personal information to administer your account and to provide the products and services you requested from us. From time to time, we would like to contact you about our products and services, as well as other content that may be of interest to you. If you consent to us contacting you for this purpose, please tick below to say how you would like us to contact you:
I agree to receive other communications from Black Diamond Advisory.
You can unsubscribe from these communications at any time. For more information on how to unsubscribe, our privacy practices, and how we are committed to protecting and respecting your privacy, please review our Privacy Policy.

By clicking submit above, you consent to allow Black Diamond Advisory to store and process the personal information submitted above to provide you the content requested.

ABOUT EIS

THE CHALLENGE

INDUSTRY

REVENUE

FORMER EPM

EVALUATED

BENEFITS SUMMARY

ELEMENTS OF SUCCESS

THE PROJECT

TECHNOLOGY & INTEGRATION

BUSINESS CHALLENGES

SCOPE

KEY BENEFITS

ABOUT BLACK DIAMOND

SHAUNA GOODSELL

JASON KARBER

MIKE VANNONI

VINCENT VALENTINE

JOE TOMLIN

MARK GOODMAN

SHERRI SCHAFFROTH

DAMON MITTLEIDER

RANDY WERDER

CARL YOST

Coming Soon...

Enter your information below to view the press release.

RANDY WERDER