Joseph M. Genet

* ********* *****

Merrimack, NH 03054

Cell: 603-***-****

Email: ad3sz7@r.postjobfree.com

www.linkedin.com/in/joegenet

Summary

Innovative and detail-oriented System / Data Analyst / Developer with experience in the Health Insurance, Family Practice and Telecom industries. Successful in analyzing, designing, testing and implementing enhancements and new systems for provider demographics, claims processing, Medicare, FEP, billing and health care systems for online and batch processing using multiple platforms. Analyze, correct and reprocess orders to medical billing systems. Analyze Customer and Prospect data. Create reports for senior management in Sales and Marketing to enable successful marketing strategies. Create Health Care reports for Clinicians and senior management.

Skills

Platforms: IBM mainframe P/390 VM and MVS Systems, HP UNIX, Microsoft, XP, and Linux

Languages: COBOLII, JCL, PL/SQL, My SQL, SQL Server, PLSQL, Postgres, Eztrieve, Toad

Applications: Business Objects, Informatica, Lavastorm, Centricity, SSRS, IBI App Studio, IBI WebFocus

Tools: IBM Productivity Tools, IDCAMS, ISPF, UltraEdit, Microsoft Office Suite Products, CoreFTP, Jira, Confluence

Professional Experience

CLEARSENSE Llc, Jacksonville, FL June 2021 – July 2023

Business Analyst

Interviewed clients to determine the critical data elements needed for the archive and access of patient’s medical and administrative data.

Completed data analysis of input data for accuracy and verifying all data needed for reports are available.

Collaborated with clients to create report templates and data mapping documents for the archival data.

Worked in partnership with clients to create system Business Requirements and Data Governance Documents.

Created research SQL queries for data analysis, verification, and conformity purposes for the new data hub.

Created multiple input system data to data hub documentation.

Verified data from multiple provider systems matched the data hub utilizing SQL code.

Documented single source of truth rules for selecting the source of truth from multiple systems.

Created auditing scripts for verification of data as it passes through environments.

Worked on QA documents and SQL queries for data validation.

GREATER LAWRENCE FAMILY HEALTH CENTER, Methuen, MA September 2015 – May 2020

Senior Application/BI Data Analyst

Instrumental in the design and implementation of the new Business Intelligence Data Warehouse. Scope of work included EMR system analysis, data mart analysis, lead QA on new BI tables, and preparing test data for quality assurance analysis.

Created dashboards, reports and portals using WebFocus for clinicians to drive better patient outcomes based on identification of patients at risk.

Worked with Director of Clinical Programs to create the OBAT Suboxone portal for clinicians to track their patients and whether patients were compliant on their medication from start to finish. Project included the analysis, SQL procedures, and Portal including reports and charts. Created an algorithm to decipher the daily dose from a prescription.

Worked with Clinicians to create Clinician Cancer panel portals from start to finish. Created procedures to extract data from the BI warehouse and EMR system used in creating the Cancer portal for Breast, Cervical, and Colon cancer screenings. Created portal page, all graphs and drill down reports.

Create reports and portals for senior management to make organizational decisions based on cost analysis.

Created Measurement reports for ACO and GLFHC senior management for Grants and State Requirements.

Modified existing SSRS reports for management, operations, and clinicians.

Created Clinician SSRS reports that directly accessed data from the EMR system to see their cancer panels. Reported on whether they are up to date on their screenings for Breast, Cervical, and Colon cancer. Reported next due date for patients up to date and list of patients that are overdue for their screenings as well as patients that are excluded from the screenings due to a medical issue.

Created and modified procedures and reports for measurements HEDIS required by the state.

FAIRPOINT COMMUNICATIONS, Manchester, NH 2011 – 2015

Senior Marketing Analyst September 2013 – May 2015

The marketing team was based in Portland, ME so I worked remotely from home. Spent 1 week in Portland every couple of months.

Extract data from multiple sources to create weekly and monthly marketing analysis reports for senior management using SQL and Lavastorm graphs.

Created Churn Report which measured the loss rates across products and technologies.

Created Market Segmentation report containing detail information on demographics and availability of products by zip code for customers and prospects.

Business Solutions Analyst September 2011 – August 2013

Researched and corrected order issues so they processed through to the billing system culminating in increased revenue.

Key member of backlog reduction team reducing backlog by 80%.

Wrote PL SQL queries and Lavastorm graphs to help analyze data reducing analysis time by 35%.

HEALTH DIALOG, Bedford, NH 2006 – 2011

Applications Analyst September 2010 – May 2011

Analyzed issues within health coach application used by nurses to track member’s health issues and treatment.

Partnered with end users to determine nature of issue or if enhancement is required.

Managed issues through to implementation working with application developers.

Senior Data Analyst November 2007 – August 2010

Created SQL Queries to correct data in the data warehouse. Tested the corrections and scheduled the process to be run in production. Created SQL queries to verify data correction was correct on a daily basis after production release.

Analyzed, created, tested and implemented PL/SQL script to cleanse data warehouse tables of data errors helping to attain NCQA accreditation.

Created PL/SQL script to clean up batch control system for new ETL process that extracted data from the data warehouse to the new coaching application resulting in reduction of startup issues.

Senior Production Specialist October 2006 – November 2007

Processed monthly data feeds from client’s data warehouses.

Used standard reports and other analytic techniques to monitor data quality.

Performed research to resolve accuracy, and reduced FTE hours by 60% for same process.

WELLPOINT INC. (ANTHEM INC.), Manchester, NH 1995 – 2006

Senior Programmer Analyst October 1995 – September 2006

Analyzed, designed, programmed, tested and implemented new Access Database for upload to CAQH provider data to provider credentialing system. Delivered phase 1 of the project 2.5 weeks early. Delivered phase 2 two months early.

Led redesign of Medicare Professional Demographic system. Redesigned: DB2 tables, on-line CICS system, batch system, and claim interfaces. New system increased accuracy, efficiency, and decreased provider related issues by 70%.

Designed and programmed temporary update interface for vendor software package from host system. Interface became permanent when it outperformed the vendor’s upgrade.

Completed highly successful and on-time conversion projects including analysis, design, programming, testing and implementation.

EDUCATION

BA, Applied Computer Science, Minor Business Management

Keene State College, Keene, NH, Magna Cum Laude

CERTIFICATIONS

Project 2000: Introduction to Managing Projects with Project 2000

Introduction to Client / Server & the Database Environment

Secrets of Successful Technical Writing

Root Cause Analysis Training for Practitioners

Six Sigma Introduction

COMMUNITY INVOLVEMENT

Coached Little League Baseball, Pop Warner Football, Flag Football

American Legion SAL 1st Vice and American Legion Riders

Contact this candidate