Ian Stock

Background

About Ian Stock

I have extensive experience in finance, operations and risk management with an emphasis in the use of analytics, information design and the latest technology to achieve successful business results. I am technical, detailed team player by participating in large, complex system implementations producing actionable KPI reporting, forecasting and optimization analysis support to senior management.Industry Experience: Healthcare, Insurance Brokerage and Claims Management, Construction Materials, Software as a Service, Public and Private Investments, Property Management.Specialties: corporate finance, financial reporting, financial forecasting, goodwill impairment testing, fair value, NPV, DCF, EVA, valuations, data conversions, data ETL, data quality analysis, data mining, KPI reporting, information design, statistics, hypothesis testing, process control, regression analysis, decision under uncertainty, optimization, project management Azure Expertise: Azure Active Directory, Azure Functions, Power Automate, Windows Virtual Machines, SQL Server on Virtual Machines, Virtual Networks, Virtual Gateways, Network Security Groups, Network Endpoints, Azure SQL Managed Instance, Azure Database for MySQL (Single & Flexible), Storage and Data Lake Storage V2, Storage Tables, Dev Ops - Azure Repos and Boards, Azure Synapse, Azure Data Factory, Azure Data Catalog, Azure Data Studio, Visual Studio, Visual Studio Code, Event Grid, Azure Automation using PowerShell, Azure Backup, Cost Management and Billing, Azure Key Vaults, Azure Storage ExplorerProgramming Languages: SQL, R, VBA, C# & Python ScriptingDatabase Platforms: Oracle, MS SQL Server, MySQL, PostgreSQL, Access, FoxProOLAP Platforms: MS Tabular SSASBig Data Platforms: AWS Redshift, Azure Synapse, Google BigQueryETL Platforms: MS SSIS, Azure Data Factory, Monarch, BoomiReporting, Dashboard & Analysis Platforms: PowerBI, Tableau, SSRS, Yellowfin, Crystal, SAP XcelsiusBilling, Accounting & Finance Platforms: Zuora, WHMCS, Hyperion, F9, DMSI Agility, WhitebirchTransaction Processing: Stripe, Vantiv/WorldPay, Chase, AMEX, ProfitStars, Fiserv, Paysafe, Global CollectWeb Marketing: Google AnalyticsCRM Platforms: Salesforce, Dynamics 365Project Management Platforms: Jira, Confluence, Smartsheet, Trello, Azure DevOps, Office 365Optimization & Forecast Platforms: Crystal Ball,@RiskCloud Platforms: Azure, AWS, Google