Business Intelligence Quality Assurance

Fnu G Pranusha

ad6o53@r.postjobfree.com • 571-***-****

Summary

Experienced IT Lead SAS Programmer with 8 years of hands-on experience in healthcare data management and analysis. Proven ability to translate complex business requirements into technical solutions, develop SAS programs for data extraction, and ensure data quality. Skilled in Oracle, SQL Server, PL/SQL, and SAS programming tools. Strong understanding of healthcare claims processing and data modeling techniques. Excellent communicator with a track record of delivering business intelligence solutions.

Areas of Expertise

Enhanced data extracts for the Transformed Medicaid Statistical Information System, ensuring compliance with federal mandates.

Conducted quality assurance on data, collaborating with division/federal staff, vendors, and stakeholders to resolve data quality issues.

Managed all data extracts according to established policies and standards.

Analyzed and performed data mapping using information from the data warehouse, Medicaid claims processing system (MMIS), Encounter Processing system (PHP-Encounters), and PBM (RX Claims).

Identified future opportunities, including developing Tableau Dashboards, job scheduling, and building/maintaining parameterized SAS Stored Processes.

Provided SAS programming training/support to DHHS staff and staff from other State agencies.

Track record of managing multiple projects efficiently, capable of thriving both independently and within team settings.

Enhanced data extracts for the Transformed Medicaid Statistical Information System ensuring compliance with federal mandates.

Proficient in SAS BI Suite, Enterprise Guide, SQL, and PL/SQL.

Strong understanding of data modeling techniques and relational database concepts.

Experienced with various file transfer methodologies and file types/layouts.

In-depth knowledge of Medicaid and MMIS.

Excellent verbal and written communication skills for technical and business audiences.

Proven experience delivering Business Intelligence solutions.

Technical Proficiencies

SAS Programming: Base SAS 9.2, SAS BI Suite, Enterprise Guide

Database Management: Oracle, MS SQL Server, PL/SQL

Data Analysis & Mapping: Data warehouse, Medicaid claims processing system (MMIS), Encounter Processing system (PHP-Encounters), PBM (RX Claims)

Quality Assurance: Data quality assurance, policies and standards compliance

Business Intelligence: Tableau Dashboard Development, Job Scheduling, SAS Stored Processes

ETL Tools: Hands-on ETL tool experience

Professional Experience

Eliassen Group, Client: Pfizer, Groton, CT

Lead SAS Programmer (Jun 2017 – Feb 2024)

Led enhancements of data extracts for the Transformed Medicaid Statistical Information System, ensuring compliance with federal mandates for Medicaid Reform Project.

Collaborated with division/federal staff, vendors, and stakeholders to resolve data quality issues and manage data extracts based on policies and standards.

Analyzed and mapped data from data warehouse, Medicaid claims processing system (MMIS), Encounter Processing system (PHP-Encounters), and PBM (RX Claims).

Developed SAS programs and ran batch processes to create extract files for CMS, improving data accessibility and efficiency.

Provided technical training and support to DHHS and other State agency staff, facilitating knowledge transfer and ensuring project continuity.

Identified and implemented future opportunities for development, including Tableau Dashboards and job scheduling, enhancing data visualization and management capabilities.

Charter Communications, Denver, CO Sept 2015-May 2017

Statistical Programmer

Developed and maintained SAS programs for healthcare data analysis and reporting.

Conducted data extraction, transformation, and loading (ETL) to support business intelligence initiatives.

Collaborated with stakeholders to gather and translate business requirements into technical solutions.

Ensured data quality and integrity through rigorous testing and validation procedures.

Delivered comprehensive reports and dashboards using Tableau, enhancing data-driven decision-making processes.

Managed all data extracts according to established policies and standards.

Analyzed and performed data mapping using information from the data warehouse, Medicaid claims processing system (MMIS), Encounter Processing system (PHP-Encounters), and PBM (RX Claims).

Identified future opportunities, including developing Tableau Dashboards, job scheduling, and building/maintaining parameterized SAS Stored Processes.

Provided SAS programming training/support to DHHS staff and staff from other State agencies.

Education:

Masters in computer science, GPA: 3.8/4

University of Silicon Valley, CA

Bachelor of Engineering in Electronics & Communication, GPA: 3.8/4

JNTU University, India

Certifications:

SAS Certified Base Programmer for SAS 9

Oracle Certified Associate (OCA)

Contact this candidate