Candidate Information | Title | Data Analyst Business | Target Location | US-MO-Kansas City | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateWork ExperienceHealth Quality Data Analyst November Street Address to July 2023KFMC Health Improvement Partners Topeka, KSoMember of the External Quality Review Organization (EQRO) Team. Primarily responsible for analytic/statistical functions in support of health care program evaluationoServe as data analytic lead to project teams, conducting/coordinating analytic activities (e.g., data cleaning, data comparisons, statistical testing, trending, geographical mapping, etc.), thorough process documentation, dissemination of valid information to stakeholdersoServe as the team lead, as assigned, for quality review projects (e.g., survey validation, network adequacy validation, performance improvement project validation).oPerform analysis for Medicaid Selection of claims for review monthlyoEvaluate the statistical analysis of Performance Improvement Plans in order to validate the report as submitted to the State of KansasBusiness Analyst November 2019 to November 2021Scientific Games Topeka, KSoProvide data analysis for organization responsible for running the Kansas LotteryoProvide ad hoc analyses for stakeholders regarding daily sales and sales related to promotions in Lottery GamesoCreate and maintain dashboards for Kansas Lottery Staff in TableauoTroubleshoot problems related to vending machines for lottery ticketsoUtilize three disparate data warehouses to integrate data to fulfill all reporting needsResearch Analyst IV June 2016 to November 2019Kansas Department of Corrections Topeka, KSoUpon starting the position, I realized that all queries and calculations for monthly reports published online contained errors, leading to mis-reported data. Worked with Applications Development staff to correct this leading to the first accurate reports published for several yearsoBuilt rapport with Judicial Districts around the state to provide accurate data for their individual districts reporting needsoCreated and maintained all data visualization dashboards for Juvenile Services using iDashboardsoProvided training/support to all personnel involved in creating/maintaining data visualization dashboardsoWorked in cooperation with Dept. of Children and Family on reporting within the Foster Care programoCreated/maintained documentation for all Crystal Reports distributed with SAP Business Object/Business Intelligence and provided training/support for others creating reportsoCompiled all information and analysis related to Annual Fiscal Reports for KS Dept. of CorrectionsTutor November 2014 to presentWyzant Overland Park, KSoProvide one-on-one tutoring to students primarily in statistics. Worked with statistic students at levels from high school to Ph. D. level coursework, including counseling psychology, medical statistics and institutional research at masters and doctoral levelsoQualified also to tutor SPSS, reading, writing, grammar and vocabularyData Analyst November 2014 to October 2015Veracity Consulting, Inc Lenexa, KSoContracted to Federal Acquisition Services of General Services Administration for Federal GovernmentoAnalyzed spend and savings of Federal Agencies with the MRO category management of GSAdvantageoProvide regular reports from contracted vendors databases in MSAccess and MSExcel for monthly reportsoProvide all ad hoc requests for data as needed and monthly fiscal tracking reportsDatabase Analyst February 2013 to June 2013Randstad Technologies Overland Park, KSoContracted to PGi helping update their sales database in SalesforceoWorked with Hoovers to ensure correct connections between parent/child companiesKnowledge Analyst December 2012 to October 2013WDS, a Xerox Company Overland Park, KSoGathered and analyzed data from Sprints care channel to detect trends that will be addressed to enhance Sprints customer experienceoInvestigate self-care channel to determine if the content needed by Sprints customers is available in order to determine which calls can be transitioned from call centers into self-care and retail channelsoPresent findings and share research with colleaguesData Analyst August 2012 to December 2012Cerner Corporation Kansas City, MOoPrepare data visualization requirements for healthcare providers to analyze and compile data from large databases to submit to incentive programs, such as Accountable Care Organizations, Meaningful Use, Core Measures and Get with the GuidelinesoWrite data visualization requirements for electronic health record dashboards to provide real time reports for programs including Accountable Care, Meaningful Use, Core Measures and Get with the GuidelinesData Analytics Specialist February 2012 to June 2012Adaptive Solutions Group Kansas City, MOoWrite SQL queries to analyze large vendor and payment files to prevent improper payments and to detect fraudoTrain all Data Analytic Specialists and Business Analysts in basic statistics for common analysesoParticipate in all on-boarding projects for several government agencies, including participating in conference calls with government agencies in preparation for their participation in the program, providing feedback to agencies via conference calls and Live Meetings to presenting findings from analyses of their files and answering questionsoProvide ad hoc reports and analyses comparing validity of sourcesoParticipate in Data Acquisition activities to support improvement of sources for the programMarketing Research Specialist September 2010 through February 2012American Academy of Family Physicians Leawood, KSoPrepare survey instruments for online data collection using Perseus (Vovici) software and Novi softwareoPrepare survey instruments and cover letters for printing in MS WordoCreate sampling designs to insure adequate sample for statistical significance and actionable resultsoCoordinate printing and mailing with Digital Imaging, Mailing Services and Warehouse Services to insure all mail pieces include survey, cover letter, BRE and that mailing list is uploaded correctlyoUtilize SPSS to define data structure for each section of the evaluations. Merge speaker sessions into one database, keeping separate Q&A sessions and Activity sessionsoCreate custom tables in SPSS to summarize evaluations which include count, valid percents, mean and standard deviationoMatch files from member census to primary and other secondary data sources for segmentation analysisoUtilize SPSS to perform descriptive analysis, correlations and custom tables for report preparation for external and internal presentationsoCreated/moderated Marketing Research Online Community from organization membersData Analyst/Scientist I - Data Analyst II June 2001 through May 2007XenoTech, LLC Lenexa, KSoPerformed training for all junior scientist on measures of central tendency, measure of dispersion, linear regression and weighted linear regressionoMaintained database in Excel of all data to ensure all products conformed to acceptance criteriaoUtilized SigmaStat (SPSS) to performed statistical analyses for presentations and reports including ANOVA and linear regressionoUtilized GraFit and DeltaGraph to provide graphic representation of data trends, induction graphs, bar charts and inhibition analyses such IC50 graphsoPrepared reports on all products released for saleoMaintained all templates for data processing purposesoReviewed results for posters, presentations, and publications, including graphical representations to insure appropriate use and interpretation of statistical analysesComputer SkillsMS Word MS Excel MicroSoft SQL Server MS OutlookSPSS Power BI SAP Business Objects MS PowerPointMS Access Tableau Crystal Reports iDashboardsEducationMaster of Arts, Sociology (emphasis in Methods and Statistics) University of Nebraska, Lincoln, NEBachelor of Arts, Sociology Doane University, Crete, NEAssociate of Arts Casper College, Casper, WYProfessional TrainingGood Laboratory Practices XenoTech, LLCBiostatistics for Oncology Researchers KU Medical School, Kansas City Cancer Institute - Biostatistics KU Continuing EducatioUsing Social Media for Customer Satisfaction Research webinarCrystal Reports Writing, Level I and Level II Kansas Department of TransportationSAS Level 1 and Level 2 SAS InstituteResearch ProjectsPeriodic Review of the Clergy of the Lincoln Association of the United Church of ChristoDesigned and executed appropriate research methodology, consisting of surveys and first-person interviews, to achieve the desired objectiveoPresented actionable results to organization administratorsComprehensive Study of Vine Congregational Church, U. C. C.oDesigned and executed appropriate research methodology, consisting of mailed surveys, to achieve the desired objectiveoPresented actionable findings to organization administratorsAbstracts, Publications, and PostersZell W. Woodworth, Landon Watkins, Terry D. Graves III, Brian D. Smith, Lisa A. Collins, I. Rochelle Riley, Amy E. Gipson, L. Anne Dwyer, Tiffin M. Ramsey, Kathleen M. Carroll, and Andrew Parkinson. (2004) Microsomes prepared from eluted enterocytes yield high cytochrome P450 and UGT activities that are stable over multiple freeze/thaw cycles. Drug Metabolism Reviews (ISSX Vancouver, Canada)Daniel R. Mudra, Kathleen M. Carroll, Cory Johnson, Anne Dwyer, Andrew Parkinson. (2003) Effect of gender, age and ethnicity on human liver cytochrome P450 (CYP) enzyme activity and inducibility. Drug Metabolism Reviews (ISSX Vancouver, Canada)Terry D. Graves II*, Zell W. Woodworth*, Stephanie A. Helmstetter, Lisa A. Collins, Clayton J. M. Otwell, Tiffini N. Hensley, L. Anne Dwyer, Tiffin M. Ramsey*, Jennifer A. Skibbe*, Oliver T. Parkinson*, Kathleen M. Carroll*, and Andrew Parkinson* (2005 ISSX Hawaii) Microsomes and S9 prepared from renal tissue yield high CYP, FMO and UGT activities that are stable over multiple freeze/thaw cyclesZell Woodworth, L. Anne Dwyer, Lisa Collins, Terry Graves, Stephanie Helmstetter, Brian Ogilvie, Clayton Otwell, Chad Pope (2006 ISSX Puerto Rico) Kinetic constants and sample-to-sample variation in the rate of metabolism of two or more substrates for human liver microsomal CYP1A2, CYP2B6, CYP2C8, CYP2C9, AND CYP3A4Lisa A. Collins, L. Anne Dwyer, Zell Woodworth, Tiffin Ramsey, Clayton Otwell, Chad Pope, Stephanie Helmstetter, Terry Graves, Josh Snyder, and Andrew Parkinson (2006 ISSX Puerto Rico) The effects of gender, age, and ethnicity on human cytochrome P450 activity. |