Nancy Lee
Woodbury,MN
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
13
13
years of professional experience
Work History
Business Analyst - Data Analytics & Actuarial/Finance Reconciliation
Optum
03.2018 - Current
- Analyze client contract and work closely with the legal and internal contract management team to understand the performance guarantee requirements and metrics
- Review and interpret contract terms and conditions related to performance guarantees to ensure a clear understanding of obligations and measurement criteria
- Develop and implement data collection procedures to gather relevant performance data from various sources
- Conduct data reconciliations and comparing actual performance data against the stipulated metrics in client contracts, identify and discrepancies or deviations
- Generate accurate and comprehensive reports based on the reconciled data providing insights on performance against performance guarantees
- Produce, publish, and distribute scheduled and ad-hoc client and operational reports relating to the development and performance of products, processes, and technologies
- Create and maintain documentation of data analysis process, ensuring transparency and data integrity.
Metrics & Reporting Analyst - Clinical Review Unit
Prime Therapeutics
02.2015 - 03.2018
- Function as a liaison between technology and business partners and converting data into meaningful and actionable reporting products
- Participate in the collection of reporting requirements through intake and prioritization sessions Recommend quality and system improvements by analyzing the data issues, maintaining and enhancing data iteration processes, and collaborating with system owners to improve upstream processes
- Create, maintain, and improve new and existing reporting solutions as required by the business
- Facilitate team request intake sessions to collect reporting requirements and determine project prioritization
- Collect, validate, interpret, and organize various types of data into meaningful reports and/or summaries for designated client groups
- Use statistical analysis and best practices to identify risks and opportunities and define reporting solutions
- Support the business in decision making and customer service efforts by providing business intelligence services.
Support Technician - Clinical Review Unit
Prime Therapeutics
09.2013 - 02.2015
- Provide technical support to pharmacy benefit insurance operations, troubleshooting and resolving issues related to pharmacy management systems, claims processing
- Collaborate with internal teams and pharmacy partners to identify and resolve technical issues, ensuring minimal disruption to operations
- Assist in the loading of new prior authorization criteria for operations.
Certified Pharmacy Technician - Clinical Review Unit Operations
Prime Therapeutics
03.2011 - 08.2013
- Responsible for the processing, communicating, documenting, and tracking of requests for formulary exceptions, prior authorization, and quantity exceptions, and brand override processes for delegated utilization management (UM) products and services.
Education
Associate of Applied Science - Computers/Information Management
Normandale Community College
BloomingtonSkills
- SQL
- Alteryx
- Data Analysis
- Data Cleaning and Manipulation
- Data Management
- Data Validation
- Data Visualization
- Data Warehouse
- Database Administration
- Microsoft Access
- Microsoft Excel
- Performance Metrics
- Process Improvement
- Quality Assurance
- SAS
- Tableau
Timeline
Business Analyst - Data Analytics & Actuarial/Finance Reconciliation
Optum
03.2018 - Current
Metrics & Reporting Analyst - Clinical Review Unit
Prime Therapeutics
02.2015 - 03.2018
Support Technician - Clinical Review Unit
Prime Therapeutics
09.2013 - 02.2015
Certified Pharmacy Technician - Clinical Review Unit Operations
Prime Therapeutics
03.2011 - 08.2013
Associate of Applied Science - Computers/Information Management
Normandale Community College
Similar Profiles
Ashly MillerAshly Miller
Medical Assistant/Phlebotomist at OptumMedical Assistant/Phlebotomist at Optum
Dawnda CookDawnda Cook
Associate Clinical Administrative Coordinator at OptumAssociate Clinical Administrative Coordinator at Optum
Patricia ApodacaPatricia Apodaca
Medical Assistant at OptumMedical Assistant at Optum
Rushik Reddy GangamRushik Reddy Gangam
Software Engineer - Remote at OptumSoftware Engineer - Remote at Optum
FREDERICK D. SPENCERFREDERICK D. SPENCER
Co-Founder & CFO at AYO WEST AFRICAN FOODSCo-Founder & CFO at AYO WEST AFRICAN FOODS