Denise Porterfield Email & Phone Number

Los Angeles, Ca, Us

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.• Mapped and implemented ETL for core claims database to Epic Community Specifications for Epic Implementation• Created ETL for EPIC MPI and RME data loads.• Performed 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). • Planned, designed, and implemented database objects, such as stored procedures, views, and functions.• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.• Developed new ETL packages utilizing SSIS.• Worked with auditors and third-party vendors to provide data as needed.• Created and deployed Reporting Workbench, SSRS, and Power BI reports.

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.• Monitored and provided front-line support of daily processes.• Migrated legacy Access databases to SQL Server.• Created and deployed SSRS and Tableau reports.• Contract employee May 2016 – September 2016.

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).• Troubleshoot database issues and processes to identify areas of improvement.• Provide technical support to other Reporting Specialists in the department as needed. • Document all reporting projects and database objects within a project consistently to meet company standards.• Contract Employee September 2014 - January 2015.

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 by 30%.• 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 regions.• 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.•Reviewed forms and reports and conferred with management and users about format, distribution, and purpose, and to identify problems and improvements.•Documented findings of study and prepared recommendations for implementation of new systems, procedures, or organizational changes.