Kim Upper
Data Analyst and Database Developer at Integrity Management Services, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Integrity Management Services, Inc.
-
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
-
-
-
Verisys
-
United States
-
IT Services and IT Consulting
-
300 - 400 Employee
-
DBA
-
Oct 2007 - Feb 2010
-
-
-
Lowe's Companies, Inc.
-
United States
-
Retail
-
700 & Above Employee
-
Team Lead
-
2005 - 2007
-
-
-
-
Data Manager
-
1999 - 2000
-
-
-
-
AGM
-
1997 - 2000
-
-
-
Adobe
-
United States
-
Software Development
-
700 & Above Employee
-
Business Systems Analyst
-
1994 - 1998
-
-
-
Aldus Corporation
-
Software Development
-
1 - 100 Employee
-
Systems Analyst
-
1990 - 1994
-
-
Education
-
University of Wisconsin-La Crosse
Master of Science - MS -
University of Washington
M.S. -
University of Wisconsin-Madison
B.S.