Sarah Connolly - Data expert,

Feedback from Sarah’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Main Street HealthSenior Data Analyst

Aug. 2024 - Dec. 2024Nashville, Tennessee, United States

Women Who ExploreEvent & Community Ambassador

Jul. 2023Passionate leader dedicated to empowering women to embrace the great outdoors, discover their local communities, and foster genuine connections. • Strategically plan, coordinate, and lead a diverse array of 6+ events and meetups annually, tailored to the interests and aspirations of women within the Maine chapter. • Cultivate a vibrant sense of community and foster active engagement by overseeing the regional WWE Maine Facebook group, which boasts a membership of 3K members. • Drive awareness and advocate for ongoing Women Who Explore initiatives to support and nurture our expansive community of over 500K members. Find your Women Who Explore community: https://www.womenwhoexplore.com/community

SharecareSenior Business Intelligence Developer

Sep. 2022 - Aug. 2024Greater portlandSharecare is the leading digital health company that helps people – no matter where they are in their health journey – unify and manage all their health in one place. Our comprehensive and data-driven virtual health platform is designed to help people, providers, employers, health plans, government organizations, and communities optimize individual and population-wide well-being by driving positive behavior change. Driven by our philosophy that we are all together better, at Sharecare, we are committed to supporting each individual through the lens of their personal health and making high-quality care more accessible and affordable for everyone. As a senior BI developer: Administration of our Power BI service. Design and construct robust data structures by integrating data from internal and 3rd party sources. Proficiently use SQL and Python to build and maintain data pipelines, collaborating effectively with the engineering team. Spearhead the automation of client reporting processes, resulting in a significant reduction in manual effort. Contribute to scaling day-to-day internal operations through data-driven solutions. Seek out and put into practice fresh analytics methods, refine internal tools, and devise inventive strategies to boost the effectiveness and expand the scalability of data operations.

CervelloBusiness Intelligence Developer

Oct. 2021 - Sep. 2022Boston, Massachusetts, United StatesExpertly utilize SQL and Azure to manage and transform large datasets, ensuring data accuracy and integrity. Used Snowflake as cloud database to perform SQL queries for reporting and dashboard metrics and insights. Develop and manage comprehensive Power BI dashboards, providing dynamic and actionable insights into data analytics. Create detailed wireframes using Figma to visualize dashboard layouts and functionality. Use Alteryx for efficient ETL processes, ensuring seamless data integration and transformation. Conduct thorough user testing for dashboards, ensuring usability and effectiveness. Proficiently convey analysis results and insights to stakeholders, emphasizing actionable suggestions that drive business improvements. Develop business-oriented KPI dashboards and visual representations to monitor company performance and quickly identify anomalies and trends. Act as a trusted analytical consultant to senior stakeholders across Client Success, Sales, Marketing, and Finance teams. Collaborate closely with teams to identify key business challenges and opportunities for improvement. Apply advanced data analysis methods to provide insightful analyses that guide critical decision-making within the organization. Detect trends, patterns, and opportunities for enhancing efficiency, driving strategic initiatives forward.

Health Data DecisionsData Analyst

Jan. 2019 - Dec. 2021Greater BostonReport Development and Data Visualization: Translate complex healthcare payor data sets, including EHR and claims data, into actionable reporting frameworks and models, enabling KPI visualization to support end users. Develop comprehensive dashboards and data visualization tools to effectively tell the story behind the data. Led the migration of over 50 existing reports from Excel to Power BI, resulting in a 35% increase in reporting efficiency. Utilize advanced data modeling, DAX, and M to develop sophisticated reports in Power BI. Data Analysis: Apply advanced data analysis techniques to deliver insightful analyses, informing critical decision-making processes within the organization. Identify trends, patterns, and opportunities for efficiency gains in healthcare payor data, including EHR, claims data, and ICD-10 codes. Perform data mining, data modeling, and related analyses to drive decision making and monitor performance. Use SQL and Teradata to extract and transform healthcare data, including EHR and claims data, for analysis. Improved data processing speed by 40% through optimized SQL queries and ETL processes. Conduct data analysis and data science modeling using Python, leveraging libraries such as matplotlib, scikit-learn, seaborn, plotly, and Javascript d3. Employ machine learning techniques (e.g., k-nearest neighbor, linear regression, ensemble methods, random forests) to uncover deeper insights. Data Management: Develop detailed reports from SQL for clients, ensuring accuracy and relevance. Perform ETL processes in SQL Server Management Studio (SSMS) to maintain data integrity and consistency. Communication: Effectively communicate analysis findings and insights to stakeholders across various teams, emphasizing actionable recommendations. Develop business-focused KPI dashboards and visualizations to monitor company health, proactively flagging irregularities and trends. Innovation and Scalability:

TDSenior Portfolio Analyst, US Technology Initiatives

Mar. 2018 - Jan. 2019Falmouth, MEData Analysis: Extract, transform, and load data for SQL and Access databases using Excel and PowerQuery. Create tables and views using SQL Server Management Studio for use in financial and project analysis projects. Financial Analysis: Lead variance analysis process by analyzing actual and forecast financial data, leveraging a SQL database and performing analysis in Excel. Collect and analyze results of variance analysis in Access database to provide insight into decision making for improving internal processes. Lead forecast analysis process by developing forecast data models monthly to provide insight into business decisions regarding improving the forecast process. Develop visuals and reports to support financial analysis results using Access and Excel and share with key stakeholders throughout the organization. Business Analysis: Lead design/development of complex reports, dashboards and scorecards to support business needs; ensure alignment of metrics across the organization and for presentation to executives. Coordinate with various stakeholders to complete ad hoc business analysis projects, such as targeted project forecast analysis and investigating project health trends. Support Technology portfolio funding process by monitoring and facilitating funding requests through required process, adhering to guidelines put in place.

TDData Analyst, US Technology Solutions

Oct. 2017 - Mar. 2018Falmouth, MaineDevelop and maintain Access database to track data quality Create Access database queries and tables to track new data quality checks in databases Design and develop reports and dashboards for trend analysis using Excel Design forms for SharePoint using Microsoft Infopath to allow for data gathering and report development Develop workflows using SharePoint Designer

EF Education FirstTeacher English Foreign Language

Jul. 2016 - Dec. 2017Teach English to adult students all over the world in private lessons and group classes ranging from 4 to 10 students Use of virtual classrooms to teach classes- Adobe Connect platform

PwCSenior Associate, People and Organization

Mar. 2015 - Jun. 2016Greater Boston AreaManagement Consultant for the private sector, performing as part of People and Organization team and Leading Edge Transformational Solutions Team. 1. Led development of communications strategy for system implementations, including communications across stakeholder groups from everyday users to high-level executives, resulting in effective communication to identify system transition risks and issues. System implementation spanned cross functional groups including finance and accounting systems and DMS. 2. Used Lean Six Sigma methodology to analyze processes and recommend improvements. 3. Communicated with cross functional groups to identify and document business needs. 4. Identified opportunities for process improvements and the technology impacts from the implementation of a new company wide system, ensuring that internally developed and vendor platforms align with company initiatives and operational improvements. 5. Analyzed savings strategies for the Americas region to identify trends and cost saving strategies for all member countries using business intelligence tools. 6. Part of a virtual team, using google drive to share documents and google chat to video conference. 7. Collaborated with third party vendors to define project requests, troubleshoot application issues, and maintain service standards and validated systems releases adhered to internal controls around the change environment. Services provided: Change Management Business Process Improvement Business Systems Analysis Project Management Lean Six Sigma Methodology Business Requirements Gathering Root Cause Analysis Strategy Analysis

BerryDunn — Accounting and ConsultingManagement Consultant

Jul. 2011 - Feb. 2015Portland, Maine AreaResponsible for project management and business analysis tasks for State government IT systems projects. Types of projects completed include systems analysis of business architecture, technical architecture, information architecture, design and analysis of state government systems, including “as-is” and “to-be” business process analysis and mapping, requirements engineering, development of implementation plan, testing, vendor selection assistance, and business process re-engineering. 1. Developed tools to perform business analysis including, heat map templates, Microsoft Excel spreadsheet data tracking templates, project methodology, Microsoft Access database (SQL), and organization charts in Microsoft Visio for projects. 2. Developed business recommendations using business intelligence tools to improve processes within the healthcare organization. Tools used required a high level of analysis and report building. 3. Directed the development of a toolkit consisting of templates, methodology and organization charts to streamline the process of performing current and future MITA State-Self Assessments for Medicaid agencies. Presented this toolkit at MESC, the largest Medicaid conference in the country. 4. Developed internal processes, communicated changes, and trained team members on the processes. 5. Acted as assistant project manager to complete IT systems analysis and business process re-engineering projects to save agencies time and money. Work included developing IT strategies to transition systems. 6. Worked with team members across the U.S, using SharePoint and Webex to communicate and share information. 7. Documented and coordinated the gathering of business and technical requirements for ERP upgrade and implementation projects. Requirements included functional areas such as finance and accounting, procurement, CRM, and tax. Projects required a high level of interaction with third party vendors to determine the optimal solution.