Advanced Analytics
Uxbridge, West London, Gb
• Data extraction from source systems (ECC, APO, CRM, flat file)• Data modeling in SAP BW (InfoSources, DSO, Cube, Multi-providers)• Process chain creation/maintenance• Front end reporting using Business Explorer Query Designer• Business Objects reporting universes based on BEx queries• Dashboard Design leveraging Live Office and QAAWS• Project Management• Functional and Technical Specification Development• Speaker at Sapphire May 2012 (Dashboard Design)• Salesforce.com (dataloader, reporting, workbench, monitoring, field accessibility)• Integrating data from SFDC, SAP BW, and flat files into SQL Server for reporting against Microstrategy• Tableau reporting on consolidated SAP BW and SAP BPC data• ETL using AWS (S3, SNS, Redshift)Project Highlights:• Auto Liability and Workers Comp Reporting App (WEBi, Xcelsius)• Business Objects Meta-data Sharing (BOBJ SDK, SharePoint) o 2010 Intranet Innovation Award (3rd Party)• Corporate Responsibility and Sustainability BW App (BEx)• North American Data Split from Europe (Data Deletion)• Supplier Network Collaboration Product Replenishment (APO/BEx) o 2011 Golden Crown Award “Customer Focused” (CCE award)• Business Partner On Time In Full (CRM/BEx)• Sales and Distribution Reporting (BEx, BOBJ, BWA, multiple data sources)• Development Cycle Release (Assisting with master transports and go lives)• Sales Represenative Dashboard (BOBJ, Live Office, Xcelsius)• SAP BPC Annual Business Planning (Data integration from SAP BW to BPC Model)• SAP BW to SalesForce integration (SAP CRM -> SAP BW -> Middleware -> SFDC)• Consolidated reporting in Amazon Redshift (SAP BW -> S3 -> Python -> Redshift -> Tableau )