Business Intelligence & Database Developer working within Avalere Health Group IT to provide data analysis via integrated dashboards across the Avalere Health business. * Worked with Group stakeholders to create Financial and Sales Pipeline dashboards. Created staff Utilisation reporting to enable senior managers to manage projects and people better.* Worked with HR and Employee experience teams to create a People dashboard that give an executive view downwards of key measures… Show more Business Intelligence & Database Developer working within Avalere Health Group IT to provide data analysis via integrated dashboards across the Avalere Health business. * Worked with Group stakeholders to create Financial and Sales Pipeline dashboards. Created staff Utilisation reporting to enable senior managers to manage projects and people better.* Worked with HR and Employee experience teams to create a People dashboard that give an executive view downwards of key measures such as salary, tenure, attrition, diversity and engagement.* Worked with stakeholders across the business divisions to create a client satisfaction dashboard that allows users to explore the various survey details returned over time and slice and drill into the data.Avalere Health is a leading global commercialization partner for the biopharmaceutical, medical technology, and wellness industries.Our 1,500+ experts combine their knowledge and expertise across its core disciplines—Consulting; Medical; Policy, Access, Value, and Evidence; Marketing; and Digital Experience Technology—to create the connections that make better health happen. We partner with clients to navigate the complex and rapidly changing healthcare ecosystem. We help clients connect patients with life-changingtherapies, realizing the potential of strategies and solutions to accelerate innovation that improves lives. Show less

Business Intelligence Developer working in a small team using Microsoft's BI Stack including SQL Server, SSIS, SSAS, Power BI, SSRS, Power Apps etc. Taking data from ERP and associated systems located at over 50 locations (ZBSData, Kronos, Microsoft NAV, Starchef, LiveRes, Social Media, Customer Feedback etc ) into a SQL server based data warehouse. From this outputting consolidated data via SSAS cubes and custom SQL which is then used in reports and dashboards via Power BI, Excel, SSRS… Show more Business Intelligence Developer working in a small team using Microsoft's BI Stack including SQL Server, SSIS, SSAS, Power BI, SSRS, Power Apps etc. Taking data from ERP and associated systems located at over 50 locations (ZBSData, Kronos, Microsoft NAV, Starchef, LiveRes, Social Media, Customer Feedback etc ) into a SQL server based data warehouse. From this outputting consolidated data via SSAS cubes and custom SQL which is then used in reports and dashboards via Power BI, Excel, SSRS throughout the company.• Worked with stakeholders to create a Managed House dashboard combining data from finance, HR, compliance, customer feedback and community data. This enables each houses to be ranked using normalised data against each other (and the business medium), showing key business indicator trends in a single view.• Worked with Operations Director to replace Excel based sales & labour reporting for all Managed Houses with an online dashboard using Power BI. This automated system reduced errors and the time ops staff were taking to produce previous reporting.• Working across the business to move Excel based reporting for menu’s, stock, finance and labour to online automated dashboards.• Creating SQL databases for business data silos (NAV, Kronos WFC, Social Media, Axiom etc) for customer feedback, compliance, finance and labour reporting.• Integrating data into SSAS cubes for sales, labour and stock.• Training and providing support to non-developers of Power BI throughout business. Show less

Business Intelligence developer working with Sisense BI platform, SQL Server, SSRS and web based reporting. Helping to move .Net legacy system to a web based offering.• Created customer and internal dashboards in Sisense connecting to SQL server, website API's and Excel. These provide key metric to enable business decisions by their users.• Introduced and developed Microsoft SSRS to business as a cost effective, quick to deploy replacement to Crystal reports and bespoke… Show more Business Intelligence developer working with Sisense BI platform, SQL Server, SSRS and web based reporting. Helping to move .Net legacy system to a web based offering.• Created customer and internal dashboards in Sisense connecting to SQL server, website API's and Excel. These provide key metric to enable business decisions by their users.• Introduced and developed Microsoft SSRS to business as a cost effective, quick to deploy replacement to Crystal reports and bespoke reporting within Class software. SSRS combined with Power BI will also provide a significant cost saving on licensing cost should the company proceed with using it for its BI needs.• Created the landing page dashboard for new Class Web using SQL stored procedures , C# and Angular. This dashboard will provide a user customisable overview of their language school business. Show less

• Design, Plan, Develop and deploy web based portals for internal and customer use.• Principal administrator and developer on Tibco Spotfire Analytics Enterprise platform.Google Analytics admin & insight reporting• Design and creation of client facing extranet portals for Xerox Marketing, RadioShack, Sprint, and Tesco and others showing performance of WDS company toolset within their business.• Production of internal web based portals including business critical call… Show more • Design, Plan, Develop and deploy web based portals for internal and customer use.• Principal administrator and developer on Tibco Spotfire Analytics Enterprise platform.Google Analytics admin & insight reporting• Design and creation of client facing extranet portals for Xerox Marketing, RadioShack, Sprint, and Tesco and others showing performance of WDS company toolset within their business.• Production of internal web based portals including business critical call centre wallboards and management reports tying our tools use to our sales and finance.• Successfully helped deploy Spotfire BI Analytics platform throughout WDS and provided on-going technical support and documentation to users as a subject matter expert (SME).• Recognised as an expert within business for analytics/data reporting tools including Oracle, Spotfire and SAP Crystal Reports, reducing time for users to deploy dashboards.• Designed and created a social dashboard for Xerox Marketing allowing them to use WDS social tools and see on-going sentiment of users from multiple social sources in near real time.• Adapted JQuery Mobile and Twitter Bootstrap framework to work on unsupported Oracle Portal platform and provide responsive web versions of company extranet and call centre operational wallboards for use on mobiles and tablets. This extended the life of the platform allowing increased investment in our business intelligence solution. Show less

• Part of a information management team that develop and deploy web based portals and reporting for internal and customer use, based primarily on Oracle Data Warehouse.• Designed and ran month end client reporting for all European and US customers moving from Excel based manual reporting to Crystal Reports pulling in data directly from Lotus Notes. This successfully reduced the report run time from a week to less than a day.

• Worked with call center team on producing insightful reporting based on key call and problem metrics.