Brian Scott Email & Phone Number

San Diego, Ca, Us

Hartford, Ct, Us

• Developed and executed on a data and analytics strategy to restructure and modernize the entire HR analytics function• Successfully migrated HR Analytics to the Cloud, modernizing the technology stack (AWS Snowflake, Tableau) and sunsetting legacy Oracle warehouse and BI/Reporting tools while establishing in-house expertise with targeted use of external vendors and partners• Owned key functional project tracks of a 14-month Workday implementation-data conversion, data simplification, reporting, and analytics• Drove technology related expense reduction of $4.7M and over 1,000+ hours saved across HR• Designed a comprehensive Employee 360 dashboard solution, providing an end-to-end, self-service view of the employee experience spanning from application process to retention/attrition• Led analyses including Diversity, Equity and Inclusion, Frontline hiring and retention, Pay Equity, Internal • Mobility and Enterprise Succession Planning• Performance metrics work stream lead for Return to Office/ Future of Work initiative, analyzing work arrangement trends, turnover, performance and employee wellness in support of a future work model focused on flexibility• Led predictive analytics projects exploring Employee Segmentation and Health of Talent (retention of frontline employees) informing key strategic initiatives and improving retention in key roles• Championed a data Literacy program to elevate the profile of data skills and analytical capabilities throughout the organization to fully realize the value of data & analytics investments• Led HR Data Governance and Information Protection Management functions; improving HR data integrity, refreshing program framework including audit processes and examining regulatory impacts from GDPR, CPRA, and CT Pay Disclosure

Hartford, Ct, Us

• Developed and delivered on a comprehensive BI strategy encompassing solution architecture, engagement and operating models, data visualization design framework and best practices, and change management• Successfully executed a multi-year end-to-end BI transformation including Analytical data environment to suites of Tableau dashboards in Small Commercial, Middle Market and Specialty(Large Accounts)• Developed a Data Visualization framework around dashboard development, standards, and quality testing• Provided thought leadership in tool evaluation decisions, technology choices, technology and tool optimization decisions• Built and sustained a high performing Analytics team and 3 Agile delivery teams (approx. 40 people)• Created an environment and culture of analytic innovation• Provided thought leadership on creating BI job families, Agile delivery methodologies for BI and data visualization standards and best practices

Seattle, Wa, Us

• Managed multiple BI implementations ranging from data visualization engagements to designing a strategy and roadmap including operating & governance frameworks for a Business Intelligence CoE• Accountable for oversight of project teams from 2-10 analysts, architects and developers• Created sales proposals, statements of work, and executive communications throughout engagements• Oversaw selection and rationalization of Business Intelligence, Data Visualization tools and other technologies for multiple clients• Built current state technology assessments and provided future state recommendations around conceptual architecture for infrastructure, BI tool selection, reporting needs, and roadmap for implementation• Responsible for overall client engagement and success and quality of the project deliverables• Led client meetings, requirements gathering, wire framing and design sessions as well as senior level report-outs and project strategy sessions

New York, Ny, Us

-Business lead for a $18million CRM Teradata warehouse/Microstrategy build; coordinated business representatives and IT delivery owners to establish and manage project priorities and scope of Business Intelligence needs to ensure the highest level of business value was delivered on time and within budget-Led and oversaw multiple work tracks including overall data and BI requirements, design, UAT, dashboard wire framing, operational readiness-Business architected marketing campaign metadata, attribution logic, customer/ household definitions and rules-Built and managed a team of Business Intelligence professionals to provide high quality, actionable reporting and descriptive analytics-Partnered with cross functional teams including web and call operations, MI, and marketing to identify operational and system enhancement opportunities; provided strategic recommendations for enhancing operational processes and business rules

Wellington, Wellington Region, Nz

-Prepared project plans, time and resource estimates for small to medium size projects-Managed data quality issues for a HRA(Health Risk Assessment) system; identified, analyzed, reported and resolved data quality issues; developed and maintained management reports to track issues as well as the effectiveness of corrective resolutions and controls

New York, Ny, Us

-Designed and implemented a SAS based data delivery process and data repository for Claim -Research platform, successfully integrated and delivered 10 years of claim data in 6 months-Team Lead for 4 Data Analysts/ consultants; provided direction and technical support, consultation and evaluation.-Oversaw DataFlux proof of concept, driving technical requirements, integration and implementation into the existing environment; Dataflux successfully went from POC to mission critical in 3 months

-Developed data infrastructure and scalable technical processes for the development of predictive models and Research projects-Identified and analyzed data sources for availability and quality; manipulated large data sets between Oracle data warehouses and SAS data stores -Performed descriptive and basic statistical/exploratory data analysis

Wellington, Wellington Region, Nz

-Reconciled claim data across six source systems; improved data quality in the finance data warehouse(DB2) and data marts by identifying and analyzing issues and coordinating solutions-Researched and identified areas in need of process improvement and provided cost benefit estimates, timelines, and technical design-Designed and created solutions to improve existing processes and enhance management reporting; replaced manual reporting processes reducing effort by over 50%-Provided production and ad hoc support for the monthly close processes, regulatory requirements, and audits for Managed Care Accounting, Stop Loss, and Indemnity Divisions

-Lead Oracle Developer for Received Money and Premium Suspense processes for all Individual Annuity business, including work with bank deposit, EDI, ACH, and reconciliation processes that processed an average of $40M daily-Wrote well structured, concise business and technical specifications and built and executed thorough test plans for unit, system, regression, and acceptance testing-Coordinated and executed unit, assembly, and integration testing including providing test data and test scenarios and assisted Quality Assurance team with follow up testing efforts