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 /.

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.
• 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.
• 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.
• 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..

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.
• 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.
• 2009 Xerox Global Services Spirit of Excellence Award recipient.

Bachelor'S Of Science, Business Administration

Associate'S Degree, Word Processing / Secretarial