Experience

WelbeHealth

• United States
• Hospitals and Health Care
• 400 - 500 Employee

• Associate Director, Analytics

  • Nov 2022 - Present



SUTTER GOULD MEDICAL FOUNDATION

• United States
• Medical Practices
• 1 - 100 Employee

• Manager, Data & Web Services

  • Aug 2008 - Mar 2022

  Modesto, California, United States Using a bottom-up management approach, developed a Lean culture focused on creating success for each team member. This environment produced a highly engaged and satisfied team. -Keep the patient as the core of every decision. -Trained team in problem solving; Ask “5 Whys?” to get to the actual problem. -Trained team in data validation and identifying anomalies in the data. -Individual team members own their projects from start to finish; from customer engagement to final… Show more Using a bottom-up management approach, developed a Lean culture focused on creating success for each team member. This environment produced a highly engaged and satisfied team. -Keep the patient as the core of every decision. -Trained team in problem solving; Ask “5 Whys?” to get to the actual problem. -Trained team in data validation and identifying anomalies in the data. -Individual team members own their projects from start to finish; from customer engagement to final output. Creative control from start to finish. -Trained team to provide what the requestor really needs and wants, not just what they are asking for. -Trained team to actively look for and evaluate processes and applications for areas of improvement. Lean: -Implemented and trained to 5S (Sort, Set in Order, Shine, Standardize, Sustain). -Creation of Standard Work for the department's processes. -Had the team develop best practices for report/application setup/design and user interface style; this has the benefit of reducing development and maintenance time while giving a common, professional appearance. -Engaged team to create metrics to track their work, completion of required training modules, team production reports, server job status, ETL run times, report rendering times, etc. Modernized department’s reporting capabilities. Moved from Excel files on shared network drives to: -Implemented SQL Server Reporting Services(SSRS) across the foundation. Additionally brought Power BI to the team. -Lead team to create a dimensional data model based on the Kimball model to better support data and reporting needs. End result: Standardized source of truth to eliminate variation amongst reports and reports that took days to create and validate could now be done in hours. Transformed local office team to 100% remote team starting March, 2020. -Easy audio/video collaboration via Microsoft Teams and Discord. -Daily use of screen and file sharing for team based projects.

• DEVELOPER II

  • Apr 2007 - Aug 2008

  Modesto, California, United States Anticipate and evaluate the needs of others with a heavy emphasis on translating user requirements into technical specifications to develop an appropriate solution in a timely manner. Train and mentor junior members of the team in the tools and methodologies used on a daily basis as well as any data related day-to-day questions that may arise. Accountable for leading the migration of the development platform from Visual Studio 2003 to Visual Studio 2005 and implemented A.J.A.X… Show more Anticipate and evaluate the needs of others with a heavy emphasis on translating user requirements into technical specifications to develop an appropriate solution in a timely manner. Train and mentor junior members of the team in the tools and methodologies used on a daily basis as well as any data related day-to-day questions that may arise. Accountable for leading the migration of the development platform from Visual Studio 2003 to Visual Studio 2005 and implemented A.J.A.X. controls to better meet the needs of application users. Responsible for the design, development, testing, implementation and support of new applications that assist users in their day-to-day operations; emphasis on web based technologies with SQL Server. Also redesign, refine and test existing applications to use current technologies/methodologies which allows for a more refined user interface, better application response times, and better data integrity. Developed web based reporting applications for informational and analytical purposes. Daily use of Visual Studio.NET 2005, SQL Server 2005, Visual Basic.NET, T-SQL



MedicAlert Foundation - United States

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Business Intelligence Analyst

  • Oct 1999 - Nov 2006

  Turlock, California, United States Primarily responsible for the design and development of reporting applications and the preparation of data analysis to support senior management with daily operational decisions Developed an array of intranet web based reporting applications for informational and analytical purposes. Administrator for the company intranet portal; currently using Rainbow. Responsible for new user set-up, user maintenance and security as well as updating content for all departments Develop… Show more Primarily responsible for the design and development of reporting applications and the preparation of data analysis to support senior management with daily operational decisions Developed an array of intranet web based reporting applications for informational and analytical purposes. Administrator for the company intranet portal; currently using Rainbow. Responsible for new user set-up, user maintenance and security as well as updating content for all departments Develop and maintain intranet web based on-line forms to replace paper based forms and processes. warehouse inventory tracking system, employee suggestion form submission with integrated managerial review/discussion and resolution posting, submission and retrieval system for member testimonials, emergency responder ignored emblem tracking and various employee surveys. Developed custom reporting for the Symposium Call Center application running on a Sybase database. Data manipulation and report creation was done in Microsoft Access. Responsible for implementing Metafile’s fundraising application Resultsplus!. This included gathering user requirements, working with Metafile on mapping data from MedicAlert’s main database to Resultsplus!, developing all mapping templates and SQL pertaining to populating Resultsplus! with historical data as well as on-going data updates. Other duties include data extracts for all mailing campaigns, telesales campaigns, and email campaigns. Heavy dissection of the member demographics information was required as each campaign was tailored to a specific member group. Use of Visual Studio.NET, SQL Server , C#, PL/SQL, T-SQL, Microsoft Access, Excel, Visual Basic for Applications, Oracle SQL Developer, ComponentOne’s Doc-to-Help, ASP 3.0, JavaScript, Macromedia’s Dreamweaver, and Crystal Reports. Show less



Sutter Gould Medical Foundation

• Report Writer/Analyst

  • Jan 1998 - Oct 1999

  Modesto, California, United States Primarily responsible for the development and preparation of data analysis support to assess trends and outcomes related to utilization management. Extensive use of Microsoft Excel, Access, Word, Crystal Reports, IDX, and knowledge of KB-SQL and DBMS required on a daily basis to provide said analysis. Prepare monthly/quarterly/yearly statistical reports for informational and analytical purposes including, but not limited to: facility bed day reports, referral status reporting… Show more Primarily responsible for the development and preparation of data analysis support to assess trends and outcomes related to utilization management. Extensive use of Microsoft Excel, Access, Word, Crystal Reports, IDX, and knowledge of KB-SQL and DBMS required on a daily basis to provide said analysis. Prepare monthly/quarterly/yearly statistical reports for informational and analytical purposes including, but not limited to: facility bed day reports, referral status reporting, facility utilization reports, physician enrollment reports, membership reporting, physician utilization analysis, H.E.D.I.S. preparation, cost analysis reporting by facility/department/physician and other miscellaneous ad hoc reports. Monitor and maintain interfaces between the core system (IDX) and the multiple satellite systems used in daily operations. This includes user testing for upgrades to existing software as well as implementation of new applications. Prepare detailed financial performance reports for physician groups and hospitals as part of reimbursement incentive programs. Show less



National Health Plans

• Information Analyst

  • Oct 1995 - Dec 1997

  Modesto, California, United States Responsible for the preparation of data analysis support to assess trends and outcomes of health plan operations. Use of Excel, Lotus 123, Fox Pro, Word, the HSII health plan database system, and a good knowledge of KB-SQL to query the main database required on a daily basis to provide said analysis. Prepare monthly and yearly statistical reports for informational and analytical purposes including: pharmacy analysis, medical group analysis, IPA analysis, and other miscellaneous ad hoc… Show more Responsible for the preparation of data analysis support to assess trends and outcomes of health plan operations. Use of Excel, Lotus 123, Fox Pro, Word, the HSII health plan database system, and a good knowledge of KB-SQL to query the main database required on a daily basis to provide said analysis. Prepare monthly and yearly statistical reports for informational and analytical purposes including: pharmacy analysis, medical group analysis, IPA analysis, and other miscellaneous ad hoc reports. Build and maintain a database containing all information pertaining to groups and their associated benefits; used for loss ratio calculations for each group or plan of benefits and for determining rating strategies on a quarterly basis. Show less