Kiio M. Email & Phone Number

Columbia, Md, Us

Columbia, Md, Us

Remote

Am a dedicated CompTIA Data+ Certified data analyst with 3 years of experience in transforming raw data into actionable insights. My expertise lies in data cleaning and report creation using tools such as SQL, Google Sheets, Excel, and Power BI. I am passionate about leveraging data to improve patient outcomes and operational efficiency in healthcare settings and beyond. Proficient in Population Health Analytics, Care Management, Risk Adjustment, and Quality Analytics Reporting, with a strong attention to detail and a proven track record of meeting tight deadlines. Healthcare data mapping

New York, New York, United States

Developed daily census reports for ADT (Admission, Discharge, and Transfer Alerts) across various payers.Created monthly reports to track patient office visits and identify those lacking professional office visits within a specified timeframe.Generated monthly risk adjustment reports tracking Persisting ICD-10 codes from patient cohort groups.Produced HEDIS reports to track patient measures, identifying those needing outreach for open measures.Compiled monthly financial reports for the Finance department.Developed and maintained reports for HARP Eligible and HARP Members.Improved report layouts by addressing user feedback and correcting data errors.Created monthly Inpatient Postpartum and Mental Health reports, including ED admissions.Developed and maintained PPEs (Potentially Preventable Events) and Utilization reports.Maintained a centralized dataset for report generation, updated monthly.Supported the maintenance of the JHU centralized dataset (Inpatient Admissions and Discharges).Contributed to the Analytics Business Glossary and Reporting Terms and Definitions.Assisted in developing Business Requirement Documents (BRDs).Created monthly membership reports for FQHCs with various payers.Documented processes for report generation and updated as needed.Managed data from various payers, including United Healthcare, Emblem Health, and Fidelis.Performed data clean-up and manipulation, primarily using Google Drive SaaS tools.

Baltimore, Maryland, United States

Provided in-house expertise and technical support to end-users on database and record-keeping systems.Identified data errors and missing data points, reaching out to concerned parties.Pulled data into Power BI dashboards for stakeholder and management viewing.Used VLOOKUP and Excel formulas to pull data into DemandTool and Salesforce.Conducted ad hoc data pulls as required by management and other stakeholders.Built creative reports and communication formats to drive work management and data clean-up.Oversaw all Homeless Services and Workforce program dashboards.Trained users on effective database system utilization and data-based decision-making.Completed ongoing assessments of database user skill levels and determined support/training needs.Coordinated the design of solutions to complex analytic questions.Conducted monthly and quarterly data scrubs and audits.Performed weekly and monthly data pulls into Salesforce.Ran reports on HMIS and pulled client data from HMIS.Acted as a Salesforce Power User, with the ability to reset user passwords and login access.

Annandale, Virginia, United States

Used Joins to analyze Claims Data and Case statements.Managed and analyzed large datasets using SAS grid and other parallel processing techniques.Worked with clients to verify analysis parameters and specifications.Efficiently queried large databases of healthcare claims and eligibility data.Wrote detailed specifications and documentation of data processing and analytical steps.Wrote effective and efficient code both independently and under the guidance of project managers using best practice quality control procedures.Maintained a consistently high degree of accuracy and attention to detail in all tasks.Prepared data and information for internal and external use, contributing to reports and assisting with project coordination tasks.Conducted data collection, statistical modeling, literature review, and compiled findings for reports.Understood Medicaid and CHIP claims data, acting as the primary point of contact with state agencies.Performed research and analysis tasks to support federal and state government.Conducted data mapping, sampling, and review analysis.Supported a team of senior economists, statisticians, and policy analysts.Reviewed Univariate Data from States for analysis purposes.Built Universe of Medicaid and Medicare data for analysis.Created temporary tables to run queries, optimized for efficiency and performance.

Rockville, Maryland, United States

Utilized Medicare and Medicaid rules and regulations to perform quality assurance and data reviews.Analyzed documents for errors and anomalies, submitting final error reports to management.Remediated non-Section 508 compliant aspects of documents and deliverables for proper formatting.Stored and maintained documents on the team's SharePoint site and Client's Salesforce.Performed document creation, quality assurance, and quality control reviews.Utilized a prescribed set of checklists and accessibility checkers for document reviews.Formatted MS Word documents, PowerPoint presentations, Excel spreadsheets, and PDF documents per Section 508 specifications.Tracked document submissions, filing them in the correct document repository.Assisted in directing/forwarding submitted documents to the appropriate contractor via SharePoint.Conducted research to ensure document checklists are up to date with the latest Section 508 needs.Identified proper channels to resolve issues and followed up on resolutions.

Gaithersburg, Maryland, United States

Part of the LabCorp pharmaceutical division, specializing in drug development and laboratory services.Responded to inbound calls from customers, triaging and documenting calls per program specifications.Conducted outbound calls and insurance verifications, facilitating prior authorizations, assisting with problem claims, and performing case management.Screened and processed patient assistance applications, verifying eligibility and making necessary follow-up calls.Responded to inquiries regarding PAP operations, patient enrollment status, product shipments, and returns.Worked with distributors and manufacturers to request and track product shipments.Applied Medicare Rules and Regulations, ICD-9, and ICD-10 codes.Managed private insurance claims and ensured compliance with Medicare and Medicaid enrollment regulations.

Frederick, Maryland, United States

Managed private insurance claims and ensured compliance with Medicare and Medicaid enrollment regulations.Made phone calls to insurance companies, members, providers, and Medicare.Coordinated benefits with CMS and updated claims for reprocessing.Assisted the Enrollment Department and maintained internal procedures manual.Provided Coordination of Benefit explanations within federal regulations.

Rockville, Maryland, United States

Analyzed records to transcribe appropriate ICD-9, ICD-10, CPT, and HCPCS codes.Monitored Medicare LCDs and updated relevant staff.Applied subject matter expertise to drive program offerings.Accurately interpreted patient insurance, prescription, and other health-related documentation.Communicated with insurance companies, patients, providers, and prescribers to coordinate reimbursement and access solutions.Handled high call volumes in a call-center environment.Advocated on behalf of patients to resolve reimbursement and access issues.Worked aged accounts, processed appeals or corrected claims, researched and reconciled credit balance accounts, and processed adjustments as needed.Interacted with patients, clinicians, insurers, Reimbursement Supervisor, and Billing management to ensure timely collection of accounts.Created and maintained accurate contract price schedules in the computer system to facilitate accurate billing, correct accounts receivable, and prompt payment.