Challenges
- The client is starting digital transformation to establish the baseline cloud infrastructure using AWS technologies as the foundation to support enterprise data enablement
- Target state data platform and create the ability to scale data and analytic solutions
- Develop data catalog, metadata capabilities
- Simplify data ownership while integrating data via API’s
Solutions
- Foundational Cloud Infrastructure
- Identified and federated access management through integration with AD (AWS SSO optional)
- Centralized log archive, monitoring using Cloud Watch and SNS End-user account provisioning using AWS Service Catalogue
- 360 view of Financials & Critical business KPI
- Replaced current Penn data warehouse, ColdFusion, and DIVERBI with modern data tools
- 360 view of suppliers
- Created a global view of supplier characteristics that will support optimization of supplier negotiations
- 360 view of customers
- Developed customer characteristics view that will support all projects that require customer data with a combined view of prospects and accounts
Tools & Technologies
Amazon SNS, Cloudwatch, Control Tower, JD Edwards, SAP, IQMS, Salesforce, Qlik
Key benefits
- Complete data and analytics foundation and capabilities on Cloud to speed up data landscape
- Reduced technical debt from legacy BI applications
- Comprehensive coverage of reports and metrics for each business persona for faster and meaningful access to insights
- Better data management and data governance for the entire data landscape in the Cloud
- Enriched business experience and functionality with advanced analysis capability for insights-driven decision making
- Faster onboarding of business users and new subject areas as data and capabilities gets consolidated
