Work Experience

• Business Intelligence - Healthcare Data Analyst - Providence Health Plan
  (Beaverton, OR)
  Feb 2023 - Sept 2024
  
• Performed Encounter Data management functions surrounding Medicare Advantage (RAPS/EDPS) and ACA (EDGE) data submissions critically important for Risk Scores/Risk Adjustment
• Ensured complete data submissions to CMS, the States of OR and WA, and data transfers to 3rd parties
• Took the small team from minimal documentation and no list of all functions performed to all processes documented in OneNote and using Microsoft Planner for regular task management
• Used SQL (SSMS), Python, Visual Studio SSIS packages, VS Code, and Excel to import/export/transform data
• Example of creating automated processes with Python: Loading flat files of regularly-received reports to database tables using glob, database connections, calling stored procedures with passed variables, and SQL
• Monitored data extracts, validated results, and resolved failures where able or communicated with IS/Dev teams for fixes via jira and Team Foundation Server/Azure DevOps tickets
• Worked with internal teams and external vendors on data needs surrounding new requirements and layouts
• Created Flows in Power Automate to populate spreadsheets and trigger email notifications
• Business Intelligence - Associate Healthcare Data Analyst 2 - Providence Health Plan
  (Beaverton, OR)
  June 2021 - Feb 2023
  
• Performing data coordination and analysis/support for multiple programs, projects, and departments with a focus on Medicare Advantage ‘Encounter Data’ management
• Working with member and claims data using SQL Server Management Studio
• Utilizing Python, SQL, and Windows Task Scheduler to automate some monthly tasks/reporting
• Membership Accounting - Analyst - Providence Health Plan
  (Beaverton, OR)
  May 2019 - June 2021
  
• Supporting three sub-groups of the Operations-Membership Accounting-Individual Product department (Enrollment Services, Premium Services, and Member Services).
• Responsibilities include running reports using SQL and Access, updating and creating tools on the team SharePoint site, and liaising with other departments to support team needs.
• Membership Accounting - Specialist II - Providence Health Plan
  (Beaverton, OR)
  March 2018 - May 2019
  
• Processing Federal Marketplace and Direct Health Insurance Plan Applications, changes, and terminations utilizing Facets, InfoPath (Marketplace data received through EDI), CRM, and Sharepoint while meeting stringent accuracy requirements
• Cross trained on Premium Services tasks relating to billing and electronic/check payment processing
• Membership Accounting - Specialist I - Providence Health Plan
  (Beaverton, OR)
  April 2017 - March 2018
  
• Processing Direct and Federal Marketplace Health Insurance Plan Applications and Plan Changes utilizing Facets software and MS Dynamics CRM
• Membership Enrollment Specialist - Providence Health Plan
  (Contract position through Motus Recruiting)
  (BEAVERTON, OR)
  October 2016 - April 2017
  
• Assisting the Membership Accounting team with 2017 Open Enrollment
• Processing Direct and Federal Marketplace Health Insurance Plan Applications and Plan Changes utilizing MS Dynamics CRM and Facets software
• Realtor^® - Pivot Realty Group
  (CINCINNATI, OH/NORTHERN KENTUCKY)
  Feb 2010 - Feb 2015 (Part time through Dec 2017)
  
• (Full-time until moved to Oregon in Feb 2015)
• Spearheaded the effort to adopt dotloop’s cloud-based e-signature and transaction management Software-as-a-Service to increase efficiency for the company and all agents
• Sold over $11 Million in real estate representing Buyers and Sellers in the Greater Cincinnati market
• Used knowledge of residential real estate contracts to guide Buyer and Seller clients smoothly through the transaction process
• Prepared detailed and accurate sales agreements and negotiated terms within critical timelines
• Assisted clients in the evaluation, appraisal and listing/marketing of residential homes for sale
• Coordinated with sales representatives/agents to schedule home showings and provide guided tours
• Researched recent area home sales to find comparison properties to determine value
• Auditor - The Kroger Co.
  (CINCINNATI, OH)
  July 2007 - Jan 2010
• Performed financial, operational, and SOX audits to ensure value for customers and shareholders
• Traveled across the country, individually and as a team, approximately 65% of the year to accounting centers, division offices, retail stores, manufacturing plants, and distribution centers for testing
• Through testing, was exposed to all facets of the company in terms of accounting, record keeping, and compliance, and was trusted with sensitive employee and company information
• Performed analysis on accounts such as Cash, Fixed Assets, A/R, A/L, Real Estate, and HR and other items within audit scopes
• Collected appropriate data for testing through correspondence with associates and through queries using SAP BusinessObjects or other proprietary software
• Assisted external auditor EY to assist with Kroger store Construction Audits and assisted external auditor PwC with SOX testing at division offices (including Fred Meyer)
• Intern - Audit Department - The Kroger Co.
  (CINCINNATI, OH)
  March 2006 - Sep 2006
• Performed financial, operational, and SOX audits to ensure value for customers and shareholders
• Traveled across the country, individually and as a team, approximately 65% of the year to accounting centers, division offices, retail stores, manufacturing plants, and distribution centers for testing
• Through testing, was exposed to all facets of the company in terms of accounting, record keeping, and compliance, and was trusted with sensitive employee and company information
• Performed analysis on accounts such as Cash, Fixed Assets, A/R, A/L, Real Estate, and HR and other items within audit scopes
• Collected appropriate data for testing through correspondence with associates and through queries using SAP BusinessObjects or other proprietary software
• Intern - Capital Management Department - The Kroger Co.
  (CINCINNATI, OH)
  Sep 2005 - Dec 2005
  March 2005 - June 2005
• Evaluated/analyzed proposed Fuel Center budgets submitted from all company divisions for accuracy and reasonableness in terms of estimated ROI, margins, etc.
• Presented Fuel Center proposals from all Kroger divisions at monthly Capital Committee meetings with Real Estate/Capital Management VP's and Directors where ultimate approval was determined for all store and fuel center projects
• Performed closing analyses for underperforming stores to determine whether they should stay open