Ilona Smith Email & Phone Number

Rochester, Ny, Us

Victor, New York, United States

Rochester, Ny

• Develop monthly equipment order forecast at SKU level for multiple products and routes to market with three to five-month lead times.• Project forecast up to 24 months in future utilizing statistical model within Hyperion toolset.• Maintained average 101% forecast accuracy for three-month lead time forecast in last year.• Collaborate with Go to Market teams, Global Offering/Product Launch teams, Finance, etc.• Identify exceptional demand opportunities outlooked in CRM tool (Salesforce) exceeding and qualify with Sales and Finance.• Develop, maintain, and publish reporting of forecast accuracy, forecast waterfall, unit and UMC dollarized forecast change metrics, etc., within Microsoft Power BI, as well as, ad hoc reporting utilizing Hyperion / Oracle data.

Rochester, Ny (Xerox Square)

• Manage Business Intelligence (BI) reporting dashboard and analysis for the Managed Print Services – Contract to Cash (MPS-CTC) business process transformation program.• Develop knowledge of data / relational database structure in Oracle EPR modules (Service Contracts, Install Base, Accounts Receivable, Advanced Pricing, and Inventory) and Noetix Analytics solution for data extraction and data warehouse.• Manage overall BI Budget of $1M (2012 – 2017) used to develop 46 web focus reports (Operational and Customer Facing) that generate average 100K reports annually by 250 active users through partnership with Enterprise Business Intelligence Platform IT Team.• Obtain report requirements, prototype, and translate into design documents for handoff to IT Development Team. Review and approve test cases and test results for production release.• Involvement in process to enable conversion of Equipment Print Services Contracts into MPS-CTC. Prototype and create design document for IT Team to extract legacy system data from several systems and compile files for validation and upload into Oracle.• Develop ad hoc queries and reporting of Xerox Print Services Contract Financials (Revenue and Cost). Retrieve data from multiple systems / manual sources and generate calculations for allocating costs for a Xerox vs. Non-Xerox breakdown to the Contract Number level.

Rochester, Ny

• Develop aggregation methodology for account segmentation using Dun & Bradstreet Legal Hierarchy, MDR, and Billians. Manually create Account Aggregation databases to support Account views by Segment and business development opportunity.• Partner with SIGMA Marketing to develop database for target market / territory building and campaign targeting to support the Pre-Pipeline Management automation tool.

Rochester, Ny

• Implement Client Delivery Manager Account Scorecard to enable Account-based strategy.• Develop Post Sale Revenue Planner; a first bottoms-up sales pipeline and financial management tool for largest revenue stream. Achieved 100% user adoption.• Develop territory configuration methodology based on coverage principles to establish ‘straw-case’ configurations for 5 Entities (plus Federal); saving weeks of cycle time and improved coverage by establishing a starting point aligned to strategic principles.• 2009 Xerox Global Services Spirit of Excellence Award recipient.

Bachelor'S Of Science, Business Administration

Associate'S Degree, Word Processing / Secretarial