L. Anne Dwyer
Summary
Highly organized and analytic professional with a deep understanding of data processes, statistics and reporting expertise. Outgoing, team oriented, with teaching/training experience. I have an innate ability to extract "the story" found within databases to drive business decisions.
Overview
23
23
years of professional experience
Work History
Tutor
Wyzant
11.2014 - Current
- Provide 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 levels
- Qualified also to tutor SPSS, reading, writing, grammar and vocabulary.
Health Quality Data Analyst
KFMC – Health Improvement Partners
11.2021 - 07.2023
- Member of the External Quality Review Organization (EQRO) Team
- Primarily responsible for analytic functions in support of health care program evaluation
- Serve 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 stakeholders
- Serve as the team lead, as assigned, for quality review projects (e.g., survey validation, network adequacy validation, performance improvement project validation)
- Perform analysis for Medicaid Selection of claims for review monthly
- Evaluate the statistical analysis of Performance Improvement Plans in order to validate the report as submitted to the State of Kansas.
Business Analyst
Scientific Games
11.2019 - 11.2021
- Provide data analysis for organization responsible for running the Kansas Lottery
- Provide ad hoc analyses for stakeholders regarding daily sales and sales related to promotions in Lottery Games
- Create and maintain dashboards for Kansas Lottery Staff in Tableau
- Troubleshoot problems related to vending machines for lottery tickets
- Utilize three disparate data warehouses to integrate data to fulfill all reporting needs.
Research Analyst IV
Kansas Department of Corrections
06.2016 - 11.2019
- Organized and executed all reporting for Juvenile Services using SQL Server, Crystal Reports and Access
- Completed all requests for research information related to Juvenile Corrections using SQL Server
- Created and maintained all data visualization dashboards for Juvenile Services using iDashboards
- Provided training/support to all personnel involved in creating/maintaining data visualization dashboards
- Worked in cooperation with Dept
- Of Children and Family on reporting within the Foster Care program
- Created/maintained documentation for all Crystal Reports distributed with SAP Business Object/Business Intelligence and provided training/support for others creating reports
- Provided reporting for Community Corrections/Parole using database in LotusNotes v9.01
- Compiled all information and analysis related to Annual Fiscal Reports for KS Dept
- Of Corrections.
Data Analyst
Veracity Consulting, Inc
11.2014 - 10.2015
- Contracted to Federal Acquisition Services of General Services Administration for Federal Government
- Analyzed spend and savings of Federal Agencies with the MRO category management of GSAdvantage
- Provide regular reports from contracted vendors' databases in MSAccess and MSExcel for monthly reports
- Provide all ad hoc requests for data as needed and monthly fiscal tracking reports.
Knowledge Analyst
WDS, a Xerox Company
12.2012 - 10.2013
- Gathered and analyzed data from Sprint's care channel to detect trends that will be addressed to enhance Sprint's customer experience
- Investigate self-care channel to determine if the content needed by Sprint's customers is available in order to determine which calls can be transitioned from call centers into self-care and retail channels
- Present findings and share research with colleagues.
Database Analyst
Randstad Technologies
02.2013 - 06.2013
- Contracted to PGi helping update their sales database in Salesforce
- Worked with Hoovers to ensure correct connections between parent/child companies.
Data Analyst
Cerner Corporation
08.2012 - 12.2012
- Prepare 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 Guidelines
- Write 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 Guidelines.
Data Analytics Specialist
Adaptive Solutions Group
02.2012 - 06.2012
- Write SQL queries to analyze large vendor and payment files to prevent improper payments and to detect fraud
- Train all Data Analytic Specialists and Business Analysts in basic statistics for common analyses
- Participate 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 questions
- Provide ad hoc reports and analyses comparing validity of sources
- Participate in Data Acquisition activities to support improvement of sources for the program.
Marketing Research Specialist
American Academy of Family Physicians
09.2010 - 02.2012
- Prepare survey instruments for online data collection using Perseus (Vovici) software and Novi software
- Prepare survey instruments and cover letters for printing in MS Word
- Create sampling designs to insure adequate sample for statistical significance and actionable results
- Coordinate 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 correctly
- Utilize SPSS to define data structure for each section of the evaluations
- Merge speaker sessions into one database, keeping separate Q&A sessions and Activity sessions
- Create custom tables in SPSS to summarize evaluations which include count, valid percents, mean and standard deviation
- Match files from member census to primary and other secondary data sources for segmentation analysis
- Utilize SPSS to perform descriptive analysis, correlations and custom tables for report preparation for external and internal presentations
- Created/moderated Marketing Research Online Community.
Data Analyst/Scientist I - Data Analyst II
XenoTech, LLC
06.2001 - 05.2007
- Performed training for all junior scientist on measures of central tendency, measure of dispersion, linear regression and weighted linear regression
- Maintained database in Excel of all data to insure all products conformed to acceptance criteria
- Utilized SigmaStat (SPSS) to performed statistical analyses for presentations and reports including ANOVA and linear regression
- Utilized GraFit and DeltaGraph to provide graphic representation of data trends, induction graphs, bar charts and inhibition analyses such IC50 graphs
- Prepared reports on all products released for sale
- Maintained all templates for data processing purposes
- Reviewed results for posters, presentations, and publications, including graphical representations to insure appropriate use and interpretation of statistical analyses.
Education
Master of Arts - Sociology
University of Nebraska
Lincoln, NEBachelor of Arts - Sociology
Doane University
Crete, NEAssociate of Arts -
Casper College
Casper, WYSkills
- MS Word
- MS Excel
- MicroSoft SQL Server
- MS Outlook
- SPSS
- SAS
- SAP Business Objects
- MS PowerPoint
- MS Access
- Tableau
- Crystal Reports
- IDashboards
Abstracts Publications Posters
- 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), 2004
- Effect of gender, age and ethnicity on human liver cytochrome P450 (CYP) enzyme activity and inducibility, Drug Metabolism Reviews (ISSX Vancouver, Canada), 2003
- Microsomes and S9 prepared from renal tissue yield high CYP, FMO and UGT activities that are stable over multiple freeze/thaw cycles, ISSX Hawaii, 2005
- 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 CYP3A4, ISSX Puerto Rico, 2006
- The effects of gender, age, and ethnicity on human cytochrome P450 activity, ISSX Puerto Rico, 2006
Projects
Periodic Review of the Clergy of the Lincoln Association of the United Church of Christ, Designed and executed appropriate research methodology, consisting of surveys and first-person interviews, to achieve the desired objective. Presented actionable results to organization administrators. Comprehensive Study of Vine Congregational Church, U. C. C., Designed and executed appropriate research methodology, consisting of mailed surveys, to achieve the desired objective. Presented actionable findings to organization administrators.
Training
- Good Laboratory Practices
- Biostatistics for Oncology Researchers
- Using Social Media for Customer Satisfaction Research webinar
- Crystal Reports Writing, Level I and Level II
- SAS Level 1 and Level 2
Timeline
Health Quality Data Analyst
KFMC – Health Improvement Partners
11.2021 - 07.2023
Business Analyst
Scientific Games
11.2019 - 11.2021
Research Analyst IV
Kansas Department of Corrections
06.2016 - 11.2019
Tutor
Wyzant
11.2014 - Current
Data Analyst
Veracity Consulting, Inc
11.2014 - 10.2015
Database Analyst
Randstad Technologies
02.2013 - 06.2013
Knowledge Analyst
WDS, a Xerox Company
12.2012 - 10.2013
Data Analyst
Cerner Corporation
08.2012 - 12.2012
Data Analytics Specialist
Adaptive Solutions Group
02.2012 - 06.2012
Marketing Research Specialist
American Academy of Family Physicians
09.2010 - 02.2012
Data Analyst/Scientist I - Data Analyst II
XenoTech, LLC
06.2001 - 05.2007
Master of Arts - Sociology
University of Nebraska
Bachelor of Arts - Sociology
Doane University
Associate of Arts -
Casper College