Senior Consultant
Oracle
India
Client: Walgreens, USA 6/2015 to 9/2016Role: Solution ArchitectWalgreens specializes in filling prescriptions, health and wellness products, health information, and photo services. Walgreens has chosen to implement Oracle E-Business Suite (EBS) and OBIA, Oracle Business Intelligence Enterprise Edition (OBIEE) to replace the existing platform. The new Oracle EBS and OBIEE platform was implemented for the enterprise including all lines of businesses – Retail, WIRS, Health Care Clinics (Take Care), and Specialty. Implementation of Oracle Accounts Payable, Accounts Receivable, Purchasing, iProcurement, I Supplier, Project Costing, Assets, eBTax, AGIS, and shell of Inventory (from eProcurement project), and partial Cash Management, Full sunset of Lawson AP, GL, AR, and Billing.Walgreens Find Care allows certain healthcare providers that have contracted with Walgreens to advertise and provide information to consumers about their respective healthcare services. • Enhancement and modification to the prebuilt data warehouse schema, the Oracle Business Analytics Warehouse, with associated extract, transform, and load (Informatica) metadata and data-movement infrastructure to support aggregation and transformation for the analysis of data from all transactional sources.• Data model design for inclusion of additional components including consideration of data lineage.• A pre-built Oracle BI Applications metadata repository to support analysis of the data in the Oracle Business Analytics Warehouse.• Solution guidance to team on OBIA and Oracle modules.