Kim Upper

Data Analyst and Database Developer at Integrity Management Services, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Sauk City, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Business Consulting and Services
    • 1 - 100 Employee
    • Data Analyst and Database Developer
      • Feb 2013 - Present

      Alexandria, VA Member of the data analysis team with side responsibilities in SQL development, ETL, data architecture and database administration. • Serve as database administrator and developer for a Healthcare Sanctions Screening Project (SQL Server/T-SQL/SSIS environment), designing, constructing, maintaining, and updating the database. • Develop stored procedures to process data and match customer input data against sanctions from multiple sources. • Develop and maintain ETL packages for staging… Show more Member of the data analysis team with side responsibilities in SQL development, ETL, data architecture and database administration. • Serve as database administrator and developer for a Healthcare Sanctions Screening Project (SQL Server/T-SQL/SSIS environment), designing, constructing, maintaining, and updating the database. • Develop stored procedures to process data and match customer input data against sanctions from multiple sources. • Develop and maintain ETL packages for staging and loading data from over 100 sources of provider and sanction data, most loaded on a monthly basis. • Design proactive analysis projects by starting with a potential Medicare or Medicaid fraud scheme and regulatory research, identifying likely data aberrancies created by the scheme or violation, and designing programs to identify providers based on data anomalies. • Present findings of proactive data analysis projects in written memos and in client meetings. • Perform detailed analysis on outlier providers to develop referrals for investigations. • Completed an entity resolution analysis that involved matching Medicare and Medicaid providers in the state of Florida using name, address, and other available identifiers.. • Develop SQL and SAS code to process data, assign risk to recipients, and attribute recipients to providers for the Health Homes benefit for a state Medicaid Health Home attribution project. • Develop ETL for loading state Medicaid claims into SQL Server on a monthly basis and produce monthly reports. • SQL and data handling subject matter expert for the organization. Show less

    • Independent Database and PHP Developer
      • Jun 2011 - Sep 2013

    • Database & Backend PHP Developer
      • Apr 2010 - Apr 2012

      Huntsville, AL

    • Alpaca Breeder
      • Mar 2002 - Aug 2010

    • United States
    • IT Services and IT Consulting
    • 300 - 400 Employee
    • DBA
      • Oct 2007 - Feb 2010

    • United States
    • Retail
    • 700 & Above Employee
    • Team Lead
      • 2005 - 2007

    • Data Manager
      • 1999 - 2000

    • AGM
      • 1997 - 2000

    • United States
    • Software Development
    • 700 & Above Employee
    • Business Systems Analyst
      • 1994 - 1998

    • Software Development
    • 1 - 100 Employee
    • Systems Analyst
      • 1990 - 1994

Education

  • University of Wisconsin-La Crosse
    Master of Science - MS
    2021 - 2024
  • University of Washington
    M.S.
    1986 - 1990
  • University of Wisconsin-Madison
    B.S.
    1982 - 1986

Community

You need to have a working account to view this content. Click here to join now