Thenes Consulting

Pay.UK

- Migrated 90 legacy reports to Power BI saving Pay.UK 40 hours/week. Hands on development support to team of 16 in financial services. Created an interactive compelling suite of Power BI reports & dashboards, transforming disparate data into actionable insights - Lead best practices for delivering end-to-end solutions: data sourcing, data warehousing, data modelling (star schemas), security, data analysis & visualisation. PowerBI, DAX, SQL, API Integration, Python - Expert in SQL, built large volume data warehouse SQL queries & stored procedures to optimize data models, data pipelines & produced performant re-usable golden source data - Implemented Power Automate & Power Apps to automate repetitive manual audit functions & distribute targeted stakeholder reports - Created & conducted comprehensive training & communications program. Virtual & in-person trainings, guides, blogs & awareness campaigns. Tailored my style to suit technical & non-technical stakeholders across the org. 180 of 350 staff attended at least one event - Established a citizen developer network. Developing strong relationships with key stakeholder. Getting buy-in, translating technical requirements into practical solutions & fostering adoption of Power BI - Managed project, created plan for Power BI roll-out & report migration. Managed developers & operational business users through Dev, Test, UAT & Production

Department of Jobs, Skills, Industry and Regions

- Lead development & coached ~80 developers in end-to-end data solution architecture - Lead BI Team, identified & executed strategic projects (Agile Scrum & PRINCE). Created a program of work to motivate team, leverage strengths & facilitate professional development - Created MI & Operational reporting suite: HR, Financial & KPI Management. Reports used dataflows, high performance star schemas, optimised DAX & intuitive visualizations. I centralised disparate data, improved security and increased discoverability, I increased staff engagement from 50 to ~200 users - Established federated BI architecture model. Created certified master datasets for financial, HR & executive data. Supported BI teams to integrate with and build composite models on-top of these. My work resolved core department challenge: maintaining a single source of truth while allowing specialist areas integrate their own data & reporting - Delivering in multi-stage development environment Jira/DevOps, Source Control, CI/CD - Created automated access control & security provisioning based on org hierarchy using dynamic object/row level security, this reduced security requests from >15 to <2 per week - As primary admin of Power BI Premium Capacity, monitored & maintained BI platform. Re-architected problem dataflows, datasets & ETL processes to reduce capacity load by 35% & reduce refresh times by 60% - Re-implemented data warehouse (Oracle & Azure) redesigning SQL views & SSIS, SSAS, SSRS - Improved data governance framework, establishing comprehensive data & reporting catalogues to ensure traceability, integrity & accuracy. By improving metadata management, I facilitated better data quality, compliance & privacy

Department of Jobs, Skills, Industry and Regions

- Establish & Lead the Department’s Data Analytics, Reporting & Engineering group. A successful initiative that helps data professionals within the department share knowledge, develop reporting, up-skill in data tools and create a more cohesive organization wide data strategy - Lead the data team, identifying strategic goals with directors. Created roadmaps to set priorities for the data team and focus on delivering the most effective solutions that allow team members to leverage their core strengths and contribute effectively to the work - Created reporting integrating directly with Salesforce to track team performance, assist managers with workload allocation and identify resourcing bottlenecks, this allowed team to increase number of cases resolved by 15% - Create a tool for rapid resource deployment to state emergencies, eliminating need to review data across ~10 different spreadsheets, slashing 1 hour process to 5-minutes with new ability to simulate and plan for a range of scenarios directly from the user interface - Created predictive reporting to enable workforce planning based on historical scenario analysis

Windana Drug & Alcohol Recovery Limited

- Resolve 30% ($2.4M) funding target under-performance. Transformed culture of distrust in data by designing, developing & maintaining intuitive automated dashboards. These clearly highlighted key trends, patterns & issues. Reports allowed staff to scrutinize detailed data to own & resolve data quality issues - Reduced budget deficit from $1M to $50k at primary site. Created budgetary reporting to track live spending & dynamically forecast. My new solution was actively utilized by all sites - Built dashboard suite: Finance, Payroll, Client Management, Outcomes Measurement & KPIs - Used Power Apps & PowerAutomate to automated processes around mandatory reporting, EOM, EOY, financial services, accounts reconciliation & payroll reconciliation activities. Reduced a 5-day process to 30-minutes - Lead implementation of org wide IT transformation. Implemented a new payroll & HRIS system. Extensive vendor negotiation, project management, change management & training, requirements gathering, process mapping & re-engineering. Facilitated many workshops and resolved competing interests through my well-practiced influencing skills

KINETIC DESIGN ENGINEERING LIMITED

- Full Stack Development bug fixes and enhancements using Delphi, C# & Python. Strong analytical mindset & passion for creating software to solve key business problems - Designed SQL databases & data warehouses (SQL Server, MySQL), created and modified complex queries, views, stored procedures and upgrades to model architecture - Allowed 50% of the annual incoming bugs to be resolved in weeks. Integrated CRM & error tracking system using REST APIs & SQL to provide insights for most prominent bugs - Built SQL reports for customers: customer insights, staff performance (KPIs), profitability of jobs & products, expected vs actual performance - Collaborate & build excellent working relationships with cross-functional teams to understand & document requirements and deliver impactful solutions - Extensively trained with junior staff on code base & robust ways of working (Peer-to-Peer QA) - Supported customers by providing technical support & troubleshooting assistance

Massey University

Microsoft