Nancy Sobotka Email & Phone Number

Missouri, United States

• CPA (non-practicing) with accounting and financial systems experience in a variety of industries including technology, healthcare, manufacturing, and consumer services and products• Financial Reporting, Analysis, and Forecasting• Hyperion Enterprise administrator, used for Financial Reporting, including international accounting• Leadership roles, including supervising, training colleagues on SAP and other technology software• SAP ERP• Presenting and communicating on financial results to upper management• Collaboration across multiple departments for problem solvingForecasting revenue based on customers statement of work, validated accounting treatment,Produced margin reporting by customerImproved the P&L by customer processVerified applicable 3rd party expenses

St. Louis County, Missouri, United States

Hyperion Administrator, loaded and consolidated data, produced reports via extracts, matched data sets through access database to provide consolidated graphical results. Reported on variances.

• Technical and business administrator for Finance and Financial Planning teams for Hyperion Applications• Maintain metadata additions, changes and mapping tables between all financial systems as needed and communicate changes to global users and management.• Maintain and support Enterprise applications including managing system security, data processing, and troubleshooting user issues including reporting and retrieve add-ins.• Data reconciliation between multiple data source systems and Enterprise system to ensure data integrity• Train Super Users on Hyperion reporting, Retrieve functionality and data extracts.• Responsible for multiple currency translations including Euro, MXN, Yen, Arg Peso, Chinese RMB. Reporting at historical rates and constant Fx.• Developed reporting tool in Access to compare category data at lowest level, sku, customer, brand, package, (our data is too large for Hyperion Enterprise Reporting)• Incorporate latest acquisition of Grupo Modelo to ABII Enterprise