Justin Fazzio Email & Phone Number

Eden Prairie , Mn, Us

- Monitoring ETL of raw data from COB client into SQL server, detecting anomalies in quality, quantity, and type- Monitor several stored procedures that process transformations of multiple data loads into standardized combined tables- Analyzing the data loads that determine recovery opportunities by developing process maps, queries and reports in Excel and Power BI to determine when any issues with files and data matching occur. When they occur, engaging in root cause analysis projects to diagnose, solution, test. Then working with DBAs to implement the solutions I generate- Building queries to find opportunities that haven’t been data mined yet. - Work hand in hand with consumers (end-users and managers) of this data to improve their efficiency and outcome based metrics. Owning the success of their work as much as they do. - Develop, manage and own Power BI dashboards of various metrics related to each of our client business analysts including quality assurance, anomaly detection, process and output metrics. Devising ways to automate these data pipelines. Instrumental in freeing up resources from ETL busy work and allowing more detection of opportunities for COB revenue growth.

Eden Prairie , Mn, Us

- Designed and currently manage the department's data warehouse including data transformation, data management & ETL processes from various data sources ranging from text, Excel and SQL. Tables range from several thousand to several million rows of data.- Tableau developer focusing on both reporting dashboards (balanced scorecards, monthly targets, drill drown/hierarchy reports) and analytics (customer profiling via clustering, trend forecasting, what if analysis). - Report automation via Power BI and Alteryx Designer- Statistical analysis via Minitab and Alteryx to compare member populations and develop cohorts of most and least likely to be compliant with measure targets... risk profiling

Eden Prairie , Mn, Us

360° assessment of pharmacy customer service operation and delivery of a comprehensive implementation road map to senior executives for 2018 business planConducted current state analysis via over 40 interviews and gemba exercises, at 4 different call centers across the USA, with process owners and stakeholders (including end user consumers and employees) documenting process, pain points, voice of the customer and barriers in the form of process maps, swimlane charts, VSMs, observation sheets, and FMEAsPresented recommendations to achieve 2MM in call volume reduction and 4-point increase in NPS via:o Cycle time reduction (reduce clicks by rearranging CSR application)o Transfer reduction (empower CSRs to handle high frequency tasks; add poke yoke checks)o Reduce quartile performance gap between top and bottom 25% of CSRs by documenting best practice behaviors and training, rearranging placement of CSRs on floor so best and worst performers sit near each other and redesigned reportingo Automation of repetitive taskso Data validation to reduce mistakes and subsequent call backsCreated and current administrator of a Tableau reporting portal – replaced weekly email based reports with live hosted Tableau dashboards

Philadelphia, Pa, Us

Responsible for analysis and management of data to support the hospital's process improvement activities, patient safety, and hospital quality assurance, reporting to the CMOExtracts, validates, interprets and communicates data from various healthcare sources including: CMS (QualityNet: VBP, HAC, Star Ratings, Validation Requests, etc.), Truven Health abstracted data, Midas+, Allscripts, Leapfrog, ECRI, and othersAnalysis and improvement efforts on customer satisfaction initiatives from Press-Ganey databases, including HCAHPS, Ambulatory, ED, and Behavioral Health measures. Conversion of data into consumable dashboards at the executive, director, service and unit levels. Particular attention to high risk group profiles (MD, Unit, Service, demographic, etc.)Comparison of entity performance vs. other hospitals and health systems after adjusting for CMI, demographics, location, and attributes (trauma center, community vs. AMC, etc.) to determine applicable cohorts from which to compare performanceValidation of data to the various hospital systems including Sunrise and EPIC in coordination with the system analytics group, including data and calculations for readmissions, mortality, LOS, HAIs, etc. Data extraction from data warehouses and universes such as Horizon Performance Manager, Health Data Management (HDM), etc. and translated into consumable dashboardsExpert use of Excel to clean data (Power Query), merge (Power Pivot) and present (Power BI) multiple datasets in an easy to understand manner by consumers and decision makersFacilitator and adviser to process improvement activities including Lean and Six Sigma methods: construction of VSMs via Gemba, data collection plans (Gage R/R, construction of complex SharePoint forms), hypothesis testing to determine significant differences vs. standards and other departments, geometric mean analysis to compare unlike units and metrics, etc. Expert use of Tableau, Minitab, Excel, Access, PowerBI/Pivot/Query

Chevy Chase, Md, Us

Management and mentorship of 10 Six Sigma Green Belt Managers in all areas of the business in both Underwriting and Claims and in the functional areas of team leadership, statistical analysis, stakeholder communication, and time management Taught 20 Six Sigma classes in Sigma Station and Yellow Belt Certifications with a 4.7/5.0 student rating Expert in Lean Six Sigma methodologies - 7 years of experience with GEICO in the field Advanced statistical analysis and proficiency in Minitab and ExcelLed 10 regional and corporate-wide process improvement projectsInteraction with IT project managers and leads to develop custom process focused solutions including the use of JIRA, UAT, VOC and survey assessment, pilot testing scenarios and eventual rollout and verificationRegular presentation and meeting facilitation to and for upper level and executive management on timelines, results and decision points related to material project elements.

Chevy Chase, Md, Us

Regional Management business plan development, forecasting, budgeting, and business modeling. Establishing, forecasting, and monitoring goals and performance. Emphasis on cost efficiency and process improvement to improve the bottom line. Data analysis from data retrieval through to dashboards and presentations with recommendations, implementation and monitoring.

Chevy Chase, Md, Us

Managed the development and performance of two customer service representatives on efficiency, quality, and customer service metrics. 200% improvement in handling time efficiency metrics. Led them to top of the class results.

Chevy Chase, Md, Us

DMAIC Six Sigma Process Improvement - project manager for a company and country-wide project to consolidate, and standardize the Internet Customer Service process. Led a team of 7 management associates and 30 extended team members for 12 months.

Master Of Business Administration (Mba), Marketing

Bachelor Of Science, Psychology