Planning, Reporting and Consolidation with MicroStrategy & SYSPHERA Integration Ross Amarante CIO and CFO, Adrianna Papell Group Agenda • Adrianna Papell Group: Who we are • Planning and Reporting based on Spreadsheets • Selection Process and Market Alternatives • SYSPHERA and MicroStrategy approach: Our Project • Next Steps Adrianna Papell The Company Adrianna Papell Company Overview For 35 years, the Adrianna Papell Group, a fast paced New York City based apparel company, has been focused on a single mission -- to make every woman feel beautiful. With an artisanal attention to detail, the Adrianna Papell collections are best known for an elegance and flair that empowers women of all ages and silhouettes to feel their very best. Adrianna Papell is one of the most respected life style brands because of its exquisite sense of style, superlative fit, and quality craftsmanship. The brand has been focused on a single mission: BEAUTY REVEALED, making every woman and every moment feel special. With an artisanal attention to detail, the Adrianna Papell collection is infused with an elegance and flair that empowers women of all ages and silhouettes to feel their best. From day to evening and traditional to modern, each piece is designed for the way women live today- transitioning seamlessly from one occasion to the next. Adrianna Papell Adrianna Papell Adrianna Papell Adrianna Papell Adrianna Papell Facts and Figures Today, the Adrianna Papell brand has a substantial market share in the dress business and is distributed to all leading retailers in the United States. The Group has expanded its business across 15 countries through various channels, including free standing stores globally, and is fast growing its brand recognition in other apparel and fashion categories. Adrianna Papell Planning and Reporting based on Spreadsheets Planning and Reporting based on Spreadsheets Process Overview – Pre Sysphera 1. 2. 3. Time consuming Non-Collaborative Lack of timely information 4. Lack of Traceability 5. 6. Rigid Reports Hard Maintenance 7. Prone to errors Planning and Reporting based on Spreadsheets Previous Architecture Reporting in Spreadsheets Financial Information Operational Information Planning Process based on Spreadsheets Management Financial Local Statutory Adrianna Papell Selection Process and Market Alternatives Adrianna Papell Selection Process • Flexibility • User Friendly • Reduced implementation time • Lower cost of licenses • Powered with analysis and reporting capabilities on MicroStrategy Adrianna Papell SYSPHERA and MicroStrategy Project SYSPHERA and MicroStrategy Project Status so far 1. Started April 2014 2. Installation, connectivity & information security matters 3. Centralized data warehouse 4. All plan modules in SYSPHERA 5. Mapped initial key operational & financial information 6. Started with detailed P&L components SYSPHERA and MicroStrategy Project Status so far 7. Implemented KPIs’ reports for all Business Units 8. Implemented 2015 Operational & Financial Plan SYSPHERA and MicroStrategy Project Architecture Summary Management Reporting Intelligence Server Windows 2008 R2 16GB RAM CPU 2 x 2.90 Ghz Operational ERP detailed KPI’s Windows 2008 R2 16GB RAM CPU 2 x 2.40 Ghz Planners Web SYSPHERA and MicroStrategy Project Key Dimensions Type, Customer, Department and Region Selling, Shipping, Design, Corporate, … Months, quarters, semesters and years Time Division, Brand and Category Reporting Entity Customer P&L Dimensions Expense Department US, UK, … Scenario Company Account Actual, Accrual, Plan, 6 + 6 Forecast, ... P&L, Drivers SYSPHERA and MicroStrategy Project Planning Process SYSPHERA and MicroStrategy Project Input Forms SYSPHERA and MicroStrategy Project Reports SYSPHERA and MicroStrategy Project P&L SYSPHERA and MicroStrategy Project Main Benefits 1. One single database 2. Reports in real-time 3. Collaborative Process 4. Built in controls and financial functionality 5. Audit Log 6. Flexible Reports 7. Easy Maintenance Adrianna Papell Next Steps SYSPHERA and MicroStrategy Project Next Steps 1. Performance Dashboards 2. Planning Forms 2.0 3. Rolling Forecast 4. What-if Scenarios 5. Go Mobile Thank You! Ross Amarante CFO, CIO Adrianna Papell Group [email protected] www.adriannapapell.com
© Copyright 2024