The client’s team members pulled information from three systems into a myriad of spreadsheets to produce financial statements. And the translation and reconciliation of that data took a lot of time. For example, there were Funds in all three systems, but one system held actual and accrued revenues. Another held actual expenses. And the third stored revenues and expenses after allocations were applied in the spreadsheets. And the same Funds had different names and identifiers in each system.
The client’s accounting team was siloed and unfamiliar with master data management (MDM). When I performed the process assessment and documentation for the future ERP implementation project, this was an easy, obvious improvement that would significantly increase productivity.
I held several working sessions in which we determined the source of truth for Funds (and other master data) and designed the supporting processes. Then we had collaborative sessions with key groups (i.e., IT, Ops, AP, Finance), obtained their buy-in and finally got the approval from the CFO. During the new ERP implementation, the system integrations were built on these MDM principles and supporting processes.
Careers at 8020 Consulting
We take pride in nurturing long-term relationships with our team members and our clients. If you’re interested in working on our team of accounting and finance consultants, visit the careers section of our website to learn more about life at 8020. You can also put in an application for consideration by following the instructions at the bottom of the page:
8020 Consultant Ellen Vayner has over 20 years of experience in management consulting and project management. She has worked with several multi-national and cross-functional teams to achieve a variety of results, including several financial systems implementations, among them Concur; an international manufacturing facility move; the establishment of an invoice-to-cash process; and the creation of a new reporting package for an executive office. She has worked with clients in entertainment, manufacturing, oil and gas, biotechnology, banking, consumer products and real estate, and her specialties include corporate strategy assessment and development, corporate finance, business case development, and project management. She holds an MBA in Finance and International Business from Carnegie Mellon’s Tepper School of Business, attended London School of Economics as well as took courses at universities in the Soviet Union, Germany, the Czech Republic and Slovakia. She also holds a Project Management Professional certification from the Project Management Institute.