Denise Porterfield Email & Phone Number

Irvine, CA, US

Orange, California, US

US

• Utilize Azure DevOps services such as Azure Repos and Azure Boards to plan work, collaborate on code development, deploy functions, views, and stored procedures.
• Design and develop code and scripts that leverage structured and unstructured data integrated from multiple sources.
• Provide subject matter expertise and guidance to BI developers and internal operational groups.
• Automate manual processes to increase overall efficiency and improve production time.
• QA and validate team members' procedures and queries to ensure accuracy.

Newport Beach, California, US

• Created tools for internal business units to improve accuracy and efficiency.
• Developed and maintained SSIS packages for all CMS daily and monthly Medicare reports.
• Streamlined and automated the HEDIS monthly data submission process to a third-party vendor.
• Designed internal database and Access application to track and manage GAPS in HEDIS measures.
• Developed ETL for Lab Orders in Clarity database for HEDIS gap closers.
• Implemented reconciliation of HEDIS measures between Clarity and external vendor systems.

Chicago, IL, US

US

• Administered SQL Server databases for the Systems and Analytics team.
• Automated manual processes to increase overall efficiency and improve production time.
• Automated 75% of the daily reports requiring manual intervention.
• Collaborated with Telecom, Experian, and Call Center business units to develop an ETL process for the outbound dialer implementation project.
• Automated the reconciliation and adjudication process for outsourced medical group claims, resulting in significant cost savings in manpower.
• Worked with internal and external clients for import and normalization of third-party data.

Atlanta, Georgia, US

• Compile and Analyze data for regulatory compliance with CMS and DHCS.
• Optimize Access databases to use SQL pass-through queries to reduce execution time by 50%.
• Create standardized SQL views of datasets to be utilized by the Healthcare Informatics team.
• Streamline reporting by converting access reports to SSRS to be automatically distributed.
• Collaborate with various business units to determine users’ needs and objectives for reports, Identify methodology for extracting data from SQL data sources and ensure the delivered report is accurate and timely.
• Perform quality control checks of data loaded into the SQL server for process compliance data including but not limited to (Pharmacy, Eligibility, Claims and Encounter data).

Hanover, MD, US

Seattle, Washington, US

• Automated daily, weekly and monthly production reports from SQL Server database utilizing stored procedures and Crystal Reports.
• Developed and implemented a more robust reporting system to track employee performance and service levels in the call center. This led to several service level improvements including an improved average speed of answer.
• Initial team that launched a new subsidiary company, Delta Data and Analysis Center, which stored all the data from participating Delta Dental Plans in multiple data warehouses which allowed for data mining across.
• Performed quality control checks on data loaded into the data warehouse.
• Collaborated with Fraud and Abuse team to identify and audit outliers.
• Worked with doctors to design studies and extract appropriate data from source systems to publish studies in multiple dental journals, including Journal of American Dental Association.

• Managed reporting to ensure corporate service level agreements for the Microsoft helpdesk contract were met. Managed roll out of new call tracking tool for the Helpdesk and coordinated updates with the programming team.
• Developed and implemented Access reporting tools for managers to retrieve information on specific criteria from SQL database to cut back ad-hoc reporting requests.
• Collaborated with IT and Intecom to automate Callwise (call tracking tool) productivity reports. Automating these reports increased our efficiency by 25%.
• Compiled, analyzed and presented daily, weekly and monthly employee performance reports.
• Maintained the Helpdesk knowledge base providing employees with the correct information.
• Analyzed data gathered and developed solutions or alternative methods of proceeding.