Ryan Wake Email & Phone Number

Australia

● Revolutionized the delivery of in-house reporting for a large financial corporation using Databricks Notebooks, Python, Databricks SQL, and dbt.● Moderated and refined a Data Warehouse using medallion architecture.○ Was nominated for an internal Versent Aspire Award for my work.● Worked with Snowflake, Power BI and ArcGIS to deliver a proof of concept for a client tender.● Self-studied to earn Databricks and AWS certifications.

Brisbane, Australia

● Enable Business Intelligence with drill-down functionality using Microsoft Power BI through:○ Connecting to internal and external databases to allow data querying○ Building Datasets and Reports with appropriate star schema and measures using DAX○ Publishing Datasets and Reports to Workspace to be viewed by relevant parties across the business○ Merging key visuals from Reports into high-level Dashboards for executive consumption○ Overall Administration of the Power BI Workspace○ Moderation of the development lifecycle of Power BI Online Workspace from testing to deployment○ Intelligence delivered to-date includes:■ Revenue and Churn reporting across the business■ Customer statistical reporting■ Product level reporting including volume and margin■ Target hit-rates and projections■ Mobile Data Usage and Allowance statistics● Construct and Maintain a Least Cost Routing system to increase margin on significant areas of the business using Python, SQL, and Cloud Technology.● Build reports using SQL to inform decision making across the business.● Perform Commercial Modelling to determine viability of new products and set business rules.● Carry out Risk Management for mobility products to ensure margin remains high.● Execute Due Diligence on any new acquisitions of business to estimate future revenues.● Assist the Finance Team with Revenue and Cost allocation for multiple levels of the business.● Complete billing assurance and reconciliation, responsible for all aspects of creating and dispatching monthly invoices and analysing trends.● Training others on the complete billing process.● Optimise and consolidate service supplier sources through modelling product pricing, usage statistics, and service locations.● Reconcile inventory to remove any redundancies such as ceased supplier services still billing to customer and active customer services ceased with supplier.● Troubleshoot data irregularities to identify root cause and systematically repair.

Edinburgh, United Kingdom

● Worked with a global financial services client analysing a ~$100M annualestate● Instrumental in bringing >$60M spend under visibility for analysis● Communicated with the client and carriers through weekly calls and clientsite visits● Demonstrated attention to detail and proficiency in Excel to analyse clientinventory and data, supported by Python skills● Applied a self-starting attitude to identify new data sources and prepthem for analysis● Delivered reporting to client project leadership, demonstrating timemanagement and communication skills across all levels of business● Showed excellent problem solving skills when building queries anddashboards to analyse data● Worked with the development team to test updates and bug fixes● Engaged coworkers in social activities outside of work, starting weeklyrunning and board game clubs

Edinburgh, United Kingdom

• Worked with a FTSE 250 client to provide a TEM solution for an 8-figure annual estate.• Communicated with Account Managers during the initial data gathering state to define requirements with the client/carrier.• Performed data cleansing where required using both Excel and Python before loading into the in-house system.• Liaised with the client and carriers to load both BAU and new data into in-house system.• Validated billing data from carriers and issuing monthly cost breakdown reporting to the client.• Updated appropriate project documentation on a weekly basis.

Glenrothes

• Developed algorithm using Visual Basic for Applications to extract experimental information.• Performed physical probing of Silicon Carbide integrated circuits to identify functionality and extract parametric curves.• Calculated mechanical sizes and tolerance of an optical assembly as part of a wider optical fire detector project.