SKILLS

Ian has used Python in a 'Pandas' capacity for data analysis and modeling. Python Pandas is a fast and efficient data frame object for reading and writing data between in-memory data structures and different formats, intelligent data alignment and integrated handling of missing data, flexible reshaping and pivoting of data sets, and much more.

Ian has used SQL and SQL Server in a data staging capacity. Custom SQL query developed in SQL Server can be used to create views through SQL stored procedures, create temporary staging tables, or be placed in Tableau or Power BI to extract data from databases.

Ian has used Tableau in a visual analytics developer capacity. Tableau - a Salesforce product - is a multi-faceted visual analytics tool used to create highly customized dashboards to satisfy any business case. These dashboards can be published to a Tableau server environment where end-users can view their dashboards.

Ian has used Power BI in a visual analytics developer capacity. Power BI - like Tableau - is a multi-faceted visual analytics tool used to create highly customized reports and dashboards to satisfy any business case. Power BI has distinct advantages over Tableau when working with data from an Azure cloud environment.

Ian has used Epic EHR for patient case management, Cogito analytics, SlicerDicer models, and extracting data from the Epic Clarity and Caboodle databases for analysis in Tableau and Power BI. Epic is the most widely used EHR system with more than 280 million patients having an electronic medical record in Epic.

Ian has used WorkDay to develop in-app finance and budget reports, extract data for other financial analyses, and add processes to streamline HR service delivery. WorkDay Enterprise Management for healthcare organizations has increased costs savings and ROI and improved talent management and retention.

Ian has used ServiceNow to triage and resolve incidents, assess and develop report requests, perform project management, track time spent on incidents/requests/projects, serve as an 'on-call' analyst for a data and analytics department, and develop free-form visual task boards. ServiceNow provides digital solutions that transform how work gets done.

Ian has used GitHub to automate workflows, host and manage packages, write code, manage code changes, plan and track work, and collaborate with other developers.

Ian has used Azure DevOps to implement Azure pipelines, track work with configurable kanban boards, connect to GitHub for code review, and explore test plans.

Ian has used Informatica for data cataloging and internal governance and privacy policies. Informatica rapidly delivers data marts with standardized metric definitions across an enterprise. This increases end user trust in data and metrics accuracy.