Sam Macdonald Email & Phone Number

Heckmondwike, Gb

Leeds, England, United Kingdom

Business Intelligence DeveloperProviding BI and MI across the business, maintenance and integrity of the data warehouse and supporting the business intelligence analysts with their data requirements.Key call outs:-Power BI - Created numerous dashboard to aid the business to be data driven and make well informed decisions.Standardised the format for all dashboards. Ensured datasets ran with no issues and in a timely manner.Power Automate - Used to create an alert system for the business for various different metrics including a data warehouse health check dashboard alerting data failures of the ETL processes.Data warehouse - Gate keeper to the data warehouse, documented and implemented data warehouse releases, ensured the build of the relational database was maintained.T SQL - created various views to pinpoint the data requirements, Helped the team to write efficient queries.Created store procedures to speed up data querying and extraction.

Bradford, England, United Kingdom

SQL Developer :- ReportingTo provide end to end reporting solutions, predictive analytics and deliver adhoc requests across the business using various data sources and front end software,main processes used:-Extract - Google big query and GCP - advanced scripting, data architecture, data triggers, store procedures, cost efficient script.Microsoft SQL(MSSMS) Advanced scripting, Including creating Stored Procedures, Data tables andagents.Oracle SQL Advanced scripting, data intergity.Transform - Microsoft Visual Studio(SSRS) Create complex reporting solutions and data visualisations using direct TSQL & Oracle SQL. Create Qlikview Data(QVDs) using Qlikview SoftwareLoad - Google Data Studio - high performance dashboard building, providing valued data insight.Microsoft Report Manager. Load visual studio reports for stakeholder viewing, including setting upsubscriptions including data driven. Qlikview & Qlik Sense, create front end dashboards for viewing and data analytics across the business.

Ordering stock and allocating stock for the full estate(over 500 stores) Setting forecasts/budgets for store’s products(covering bread, cakes and fish) Providing solutions and support for stores markdowns and waste issues, plus supporting stores for any bulk promotion activity. Generating business cases for poor selling lines to challenge the commercial team. Securing and chasing up loss of stock and poor service level from various suppliers. The implementation and planning of seasonal, promotional products. Team trainer, seasonal coordinator (Christmas, Easter, bank holidays etc..,) Foreseeing the effect of weather and other variables on a specific range. Using all aspect of Microsoft office.

Science

Hnd Science, Pass With 4 Merits