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