Aneta Zuczek

Lead systems analyst for all financial applications, including QbyteFM, OpenInvoice, Execute, analytic cubes, PAS, etc.

Project Leadership and Cross-Functional Collaboration.

Process Optimization and Workflow Design.

· Managed the implementation of Power Platform tools; Analytic cubes, Power BI for corporate reporting. Data requirements, KPI’s, reporting standards. Reporting & Data Visualization (Power BI, DAX)

· Master Data Analysis & Cleanup.

· Support, Upgrades and Training.

Projects

· Design, management, and successful implementation of the Finance and Open Invoice cubes, including adding price book capabilities to the OI Cube. Provide all support and updates to our models.

· Designed a unique voucher review and annotation workflow for Torxen, expediting the voucher review and posting process while meeting audit requirements, saving significant hours of work.

· Data health checks and exception reporting to identify and remedy data inconsistencies.

· Streamlined the month-end process to meet strict deadlines

· Implemented Execute AFE system, integrating with QbyteFM.

• Responsible for financial systems daily support and troubleshooting: QbyteFM, Open Invoice, PAS, CS Explorer.
• Master data stewardship is responsible for all master data maintenance in QbyteFM.
• Ad hoc report writing using SQL against Oracle data sources.
• Month-end execution and analysis. Streamlined month-end process, eliminated obsolete steps, and improved procedures, reducing cycle time.
• Responsible for all audit and SOX inquiries from external auditors.
• Disposition activity: prepared data and updated records for 10 or more deals.
• Streamlined allocations process: created a simplified spreadsheet model, now loaded directly into QbyteFM.
• Implemented a new corporate hierarchy in QbyteFM.
• Prepared test cases, organized training, tested new functionality, updated integration points; AFE Navigator, CS, and Open Invoice; post-upgrade troubleshooting, and SOX compliance.
• ESTMA reporting.

• Supported Hyperion Essbase toolset, including Financial Reporting Studio, Planning, and SmartView.
• Enhanced Capital Cube to accommodate the new AFE numbering scheme and structure.
• Business requirements gathering for a new Volumes reporting solution.
• Updated the finance cube to Hyperion Essbase ASO technology.
• Modified and updated planning cubes for acquisitions and business process enhancements.

• Facilitated working sessions to elicit reporting requirements and business process changes.
• Data, report validation, and analysis.
• Created SSRS reports to supplement Microsoft Dynamics AX finance and HR analysis.
• Wrote SQL queries for ad hoc analysis, integrating various datasets.
• Documented business requirements and report designs.
• Wrote, documented, and diagrammed SQL queries.

• Member of the Microsoft Dynamics GP 2013 R2 re-implementation team.
• Requirements gathering, process documentation, business-to-IT liaison, master data conversion mapping.
• Developed corporate reporting standards with the cooperation of end users at all levels of the organization.
• Designed and created corporate reports using Microsoft Management Reporter 2012.
• Created and presented training material for new business processes and applications.