Pomerol PartnersSenior Business Intelligence Consultant
Mar. 2016 - Jul. 2020London, United KingdomPower BI Showcase | Senior Consultant
• Built a dashboard from scratch using a local excel database with curated dummy sales data linked to real pharmacies and postcodes across the UK
• Created visuals for 3 years of sales and cost data for a concise sales rep and region-based dashboard
• Used Power Query to connect multiple excel files hosted on OneDrive Zimmer Biomet | Senior Consultant
• Created a new QlikView focused BI environment from scratch to provide insight and forecasting with a focus on daily activities and performance monitoring
• Created incremental, hourly updates tying two separate ERP systems together using loops in the load script and a waterfall styled QMC schedule
• Provided report maintenance with hourly QMC updates along with detailed documentation at handover
• Provided a technical plan of costing and road map, taking care of stakeholder management throughout the entire project lifecycle Dematic Corp. | Senior Consultant
• Travelled between the US and the UK for face to face stakeholder management
• Created the QlikView platform of applications for Materials Management, Factory Operations and SIOP Forecasting
• Global BI Platform integration for North America, China, Australia and Europe
• Provided reports and NPrinting maintenance with daily QMC updates • Worked on call for logic updates, requirement gathering and execution as well as ad hoc report building for stakeholders
• Investigated data quality issues in SAP tables requiring in depth understanding of the table layouts and SAP transactions
• Manipulated SAP tables to create a cross module connection and form better business insights than what SAP currently offers
• Daily stakeholder engagements and management