About This Book

Publication

Michael Queeney

Published in 2022 by OneStream Press.

Copyright (c) 2022 OneStream Software LLC, Ryan Connors, Kelly Darren, Jessica McAlpine, Michael Malandra, Michael Queeney. Al1 rights reserved.

OneStream and the OneStream logo are trademarks of OneStream Software LLC, www.OneStream.com, and used with permission.

ISBN: 978-1-8382528-4-7

All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without the prior permission of the publisher.

This book is sold subject to the condition that it shall not, by way of trade or otherwise, be lent, re-sold, hired out or otherwise circulated without the publisher’s prior consent in any form of binding or cover other than that in which it is published and without a similar condition including this condition being imposed on the subsequent purchaser.

OneStream Press has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, OneStream Press cannot guarantee the accuracy of this information. OneStream Press is an imprint of Play Technologies (England) Limited. 6 Woodside, Churnet View Road, Oakamoor, ST10 3AE, United Kingdom.

www.OneStreamPress.com

Disclaimer

While the advice and information in this book is believed to be true and accurate at the date of publication, OneStream Press, the author, and OneStream Software LLC do not guarantee the accuracy, adequacy, or completeness of any information, and are not responsible for any errors or omissions or the results obtained from the use of such information.

OneStream Press, the author, and OneStream Software LLC make no warranty, express or implied, with respect to the material contained herein, and hereby disclaim any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from negligence, accident, or any other cause.

Note: Any Files provided for Exercises in this OneStream Press Book are for the use of Customers and Partners in an On-Premise environment and are not supported by the OneStream Support Team.

About the Authors

Ryan Connors is a Senior Delivery Manager on the OneStream Partner Enablement team. He joined OneStream in 2018 and has 10 years of experience with CPM technology. Ryan currently resides in Hingham, Massachusetts, with his wife Alyson and son Cooper.

To my father, Jimmy. Thank you for always supporting me. Your memory will live on forever.

Kelly Darren is the Global Domain Director for the Financial Close process at OneStream Software. She is a CPA and CSSBB and has worked in industry within Shared Service departments, responsible for improving close processes within organizations. Specializing in this area, she moved into accounting software, working for BlackLine Systems. She subsequently worked for a consulting firm implementing SAP BPC, focusing on consolidation, before joining OneStream in 2018.

I would like to thank OneStream for allowing me to be an integral contributor in this space and to my husband, Michael Darren, who has always been my rock and encouragement to go beyond my dreams.

Jessica McAlpine is a CPA and the Group Product Director for Financial Close and Consolidations at OneStream Software. In her role, she leads the product strategy for the close and consolidations domain. Prior to joining OneStream in 2019, she spent seven years as an Administrator for an early adoption customer, and was a member of the team that implemented consolidations, planning, and tax provision. Jessica has also worked in external and internal audit.

I’d like to thank my boys, Brian, my husband, and Grayson and Cooper, my kiddos, for all your love and support. And my mom, Lynn, and sister, Amy, for showing me that we women can do anything we put our minds to.

Michael Malandra was employee #56 at OneStream and has over 20 years of experience in Financial Consolidations and Reporting, Account Reconciliations, Variance Analysis, Planning and Forecasting, and Cost Benefit Analysis. In 2015, when joining OneStream, he became one of four OneStream architects in the Services organization. He then joined Direct Analytics in 2020, where he has continued architecting multiple OneStream applications.

Thanking everyone who has impacted my journey would become a book unto itself, so I will start with the most important person, my lovely and wonderful wife, Margaux. I cannot thank you enough for all the support you have shown me over the years, from leaving your highly successful career in New York City and following me to Arizona, back to New Jersey, and finally to Pittsburgh. To my three beautiful children: Makayla, Michael, and Matthew; to my partner in crime, Mike Queeney; to all my OneStream colleagues (you know who you are); and finally (in no particular order) – Lauren K, Todd A, Peter F, Steve M, Terry S, Eric D, Jerri M, Jon G, Eric O, Chul S, Debra O, Dawn W, Christine K, Jenn S, and of course Tom and Bob – Thank You!

Mike Queeney is a Managing Partner at Direct Analytics and has been a partner with OneStream since their founding. Mike has worked in CPM for over 20 years, implementing integrations, models and solutions for his clients. After moving on from the Oracle/Hyperion suite, Mike has fully committed to the OneStream model of CPM and works diligently to give clients the best-in-class service that accompanies OneStream software.

It has been a long career in this business, so it would be hard to mention everyone, but I would like to thank Hemsha, Greg, Nan, Terry, Lauren, and my partner in Onestream, Mike Malandra, for listening to me rant while getting this project completed. It has been a fantastic experience. I am humbled to have been able to work with so many talented people in my career and during the writing of this book.

Technical Reviewers

Jason Ruge has been a leader in the software industry for over 25 years, focusing on delivering product excellence in his roles within Software Quality Assurance. His acute attention to technical details and passion for quality has led him to be involved as Technical Editor on multiple publications across several industries, most recently being OneStream Financial Close. He is one of the original members of the OneStream MarketPlace Engineering team, leading and guiding the organization through scale and delivery for all OneStream Solutions. He leans heavily on his faith to lead with deep compassion, honesty, and integrity to be a role model and mentor to his peers and extended teams.

This professional dedication goes to the following: Mike Phipps – your partnership and willingness to figure things out together as we got rolling in MarketPlace Engineering has been such a great experience. We helped each other along the way and, without even realizing it, helped shape the foundation of excellence we have all come to expect from the MarketPlace Engineering organization. Adam Romatz – your superior technical knowledge matched with your humble leadership style has put you in rare air in my career. Your desire to care about the 1 Pixel changes with me and yet also help lead the technical revolution within MarketPlace Engineering will have a very broad-reaching impact for many years to come. Jessica McAlpine – sharing this OneStream journey with you has been a highlight of my entire career. I am so proud of your growth and accomplishments and look forward to seeing you continue to flourish in your OneStream career.

Your trust and collaboration have been very special to me, and I wouldn’t trade them for anything. Shawn Stalker – when we first met in March 2018, you laid out a vision for the OneStream MarketPlace that convinced me to join OneStream. Thank you for your trust and partnership to help accomplish everything we have so far, and I am sure the best is yet to come.

Shawn Stalker joined OneStream in 2013 and serves as the Vice President of MarketPlace Development. Shawn has worked in the Corporate Performance Management (CPM) area for over 20 years, maintaining, implementing, and supporting consolidation and financial systems. He has worked on products including Oracle Hyperion Enterprise, Oracle Hyperion Essbase, Oracle Hyperion Financial Management and OutlookSoft before joining UpStream Software in 2006, where he helped to build their development and QA teams. He worked at UpStream through acquisitions by Hyperion and then Oracle prior to joining OneStream, where he helped start the QA and MarketPlace teams.

For my Wife… Always.

Errata

Despite best efforts, mistakes can sometimes creep into books. If you spot a mistake, please feel free to email us at [email protected] (with the book title in the subject line).

The errata page for this book is hosted at www.OneStreamPress.com/FinancialClose