Senior BIE in Redfin's People Analytics team with deliverables including: Creation of headcount models and algorithms which show what actions to take to meet headcount goals given recruiting productivity, attrition, vacancy rates, and timeline. Data structure design Deployment of custom email alerting tool, directly sending data-driven alerts to in-house customers.

Analyst in Redfin's People Analytics team, focused on recruiting analytics, including: Recruiting funnel and conversion rate analysis Creation of self-service dashboarding for recruiting data using Tableau Productivity deep dives and root cause analysis

Led analytical transformation from Excel-based ad hoc reporting to automated Tableau-based reporting based on analytical models.Built data infrastructure for the medical group, drawing in data from multiple siloed sources to create validated data sets ready for user consumption.Developed analytical models for member utilization, provider attrition, and staffing levels.Created dynamic workflows for data acquisition and user interaction allowing for streamlined processes with minimal support needed.Developed and deployed a novel payroll system pulling in data from multiple sources in order to accurately pay employee based on both regular shifts and dynamic work conditions.

Translated business requirements from internal and external clients into dynamic solutionsLead end to end development of client dashboards using Tableau and SQLDeveloped innovative claims-based quality analytics used for patient targetingPrimary tools used: SQL, Tableau, Excel (VBA)

Principle CMS Star Ratings Subject Matter Expert (SME) (including HEDIS, CAHPS, and HOS measures) for internal teams and external communication via presentations and webinarsLed redesign of existing BI platform in order to more appropriately display client data using new technology (Tableau)Developed several new analytic procedures, including: developing methodology for forecasting Star Rating cut points, integrating client forecast model with intervention impact reporting, and creation of analytic models for Star Rating calculations

Performed analyses relating to understanding and improving Medicare Star ratings for client health plansGenerated content for marketing presentations and webinarsCoordinated data issues between multiple teams, leading to issue resolutionChosen to join Inovalon's Business & Technology Leadership Training program, a Leadership Development program that selects ~5% of Inovalon employees annually

Enhanced marketing messaging cohesiveness through the identification of 5 target customer segments, which required extensive data mining, analysis, and reporting of a 300k contact databaseIncreased database size by 15% through the development and execution of a data augmentation planCreated a bulk load program to enable mass imports from alternative database sourcesDeveloped excel-based email campaign and business intelligence tracking systemsAudited database marketing processes to identify 6 data quality issues

General ManagementManaged, mentored, and evaluated a department of 4 administrative employeesBuilt analytical models on office financials, backlog, and marketing efforts for managing directorsTechnologyDeveloped and implemented relational databases across three sites which allowed management of project schedules, personnel staffing, outstanding client requests, and quality management reviewsDesigned custom Word and Excel tools for project planning, word processing, and employee reviewsOperationsStreamlined business processes and cut costs by performing comprehensive operational reviews which optimized workflows and enhanced oversight in 3 WSP Flack + Kurtz officesAccomplished operational improvements consisting of a 23% decrease in client submittal turnaround time, increased management oversight, and an overall reduction in non-conforming documents by 12%Directed an ISO implementation team which resulted in ISO 9001 Certification for the Seattle officeMarketingIdentified B2B marketing opportunities and issued proposals and qualifications totaling $12M annuallyCreated and managed employee resumes, project fact sheets, and client satisfaction metricsMaintained client data in the firms marketing database, Deltek Vision (web-based CRM)

Developed and implemented new document standards which became WSP Flack + Kurtz standardsCoordinated project deadlines with project team members and oversaw client deliverables