Ian Mccracken Email and Phone Number

-Backlog owner for ETL group at a high-growth vet-tech company, partnering with groups such as Marketing, Sales, Analytics, and eCommerce product groups to elicit business requirements and translate into technical specifications for group of data engineers-Promoted to Product Owner position from Business Analyst in under 5 months tenure-Manage and prioritize work for ETL-internal and cross-functional projects surrounding the company’s Snowflake implementation, using dbt for data model builds and Kafka for data loading, to support data delivery for analytical/operational reporting as well as feature enhancements for development teams -Frequently use SQL to conduct data exploration and QA activities in support of data delivery and reporting requests

-Member of the Data Operations and Analysis team charged with reporting on the effectiveness of ACOclinical and financial initiatives-Full-process analyst, meeting with various stakeholders to gather business and technical requirements to turn specifications into deliverable analytics solutions-Lead analyst for Ambulatory Clinical Documentation Improvement project, working with hospitals in the organization to improve capture of chronic conditions on claims and reporting out results-Continually validate data stored in the Arcadia Data Warehouse to ensure accurate data capture and reporting quality, often communicating with the vendor about validation resolution

-Epic Reporting Analyst supporting clinical areas in the MaineHealth system, achieving Epic proficiency ahead of schedule for Cogito, Clinical, and Access Data Models with an emphasis on OpTime and Willow applications-Assist clinical users in translating business information needs into deliverable requirements and technical specifications for execution-Communicate requirements to the BI Developers and assist in the creation of reports -Created the network’s first iteration of the Med Administration dashboard that tracks all medication dispenses across the entire network of hospitals as well as the First Case on Time Starts report to track timeliness of surgery case start times-Educate clinical users about development process, user interface, and content delivery options -Develop relationships with service lines to better facilitate communication of requirements and delivery of end results -Achieved Proficiency in the Clinical Data Model

-Engaged in full sales cycle with customers, identifying current needs and recommending relevant solutions for the back office (Financial Management, Human Capital Management, Supply Chain)-Employed various sales methodologies to connect with customers and discover relevant sales opportunities, resulting in total contract closed revenue of $215,000 while in seat-Collaborated with territory managers on deal progression strategies -Identified high-value customers by employing account and territory management strategies

-Generated demand and opportunities for both inside and outside account representatives -Developed prospecting strategies in conjunction with sales team to target high-value accounts-Uncovered customer needs and projects and share industry best practices related to analytics for their given industry-Trained myself in functionality of Data Visualization and Business Intelligence tools, in some instances conducting high-level demonstrations for customers-Supported sales representatives through later stages of sales cycles as necessary-Collaborated with product development on creation of effective sales campaigns