PROFESSIONAL SUMMARY

Senior Data Analyst – Systems Analyst - Programmer/Analyst with extensive experience in a wide variety of industries, most recently 16 years as a Senior EDW Analyst with Highmark Health, a Blues plan Insurance company in NY and PA performing production support.

Additional highlights of my experience are: EDW, SQL, ETL, COGNOS, report writing, warehouse analytics, HEDIS and Data Governance, QA testing Mercury Test Director/HP QC.

Accomplishments include; performed as a technical project lead, facilitated projects as an SME, established standards for specification writing, data mapping, profiling and analysis. Acted in a support role for EDW. Senior Analyst that delivered major analytic, resourcing and business initiatives including vendor interfaces working with external business partners, data loads, and extracts. Designed, enhanced and supported EDW. I possess strong knowledge of healthcare data, specializing in claims and related data. Boosted the Data Governance program with my intimate knowledge of the EDW data. Knowledge of Facets, HEDIS and BHI/BCBSA. Previous experience includes HTML, API, EDI, Technology Conversion, Oracle Financial system, PeopleSoft Financials & HRMS. COBOL, Splunk, FACETS, ICD-10, APIs, Intern Mentor.

TECHNICAL SKILLS and TOOLS

Project Schedule Management

Specifications & Mapping Development

Systems Development -coder/programmer

Systems Integration

EDI

Business Analysis Systems Analysis

Team Facilitation

Agile Project Management

Informatica 9.5/10.2 PowerCenter

UNIX

MS SQL Server

Teradata

Biq Query

Sybase

Facets

Oracle

QA testing

Mainframe

COBOL

JCL

SQL

Cognos

HPSA

EDW

HEDIS

ultra-edit/ultra-compare

DBA duties

MS Office suite

PROFESSIONAL EXPERIENCE

HIGHMARK INC./HEALTH NOW, BUFFALO, NY 4/2008 – 3/2024

Senior Data Analyst / BI Analyst EDW team.

EDW Production Support

Well-versed in many aspects of Healthcare Insurance areas, primarily:

oClaims (medical/dental/pharmacy)

oMembership/eligibility

oProducts

Performed requirements review with business customers, translated those business use cases into technical requirements, technical data mappings. report specs. These tasks were integrated into, but not limited to:

oExtracts

oData Governance

oData modeling

oCognos & Tableau

Integrated incoming data from a variety of external vendors and on-prem systems into the EDW, including Facets, Medco/ESI, FEP accomplishing improvements to our HEDIS STAR score and improving customer satisfaction.

Acted in a vendor management role, working with vendors such as HCS, Medco/ESI, FEP, and many smaller case-specific vendors. Performed analysis and profiling on data, worked with data architect and developer to integrate into EDW. Knowledge of HEDIS.

Heavily involved in Blues Health Initiative (BHI) and BCBSA (Blue Cross Blue Shield Association) for requirements facilitation, analysis, mapping, and testing.

Accomplished senior level EDW production support using Service now, Jira & Cherwell

Recognitions include Kudos Certificate of Recognition, Employee of the Month & Tupper Best in Class

SofTrek Buffalo, New York

Senior Systems Analyst – ORACLE DB

Design team – created specifications and tested for PledgeMaker Fundraising Software

Performed technical support roles including design, specifications, mappings, and testing

Fisher Price - Mattel East Aurora, NY

Programmer/Analyst 2. HP3000,Unix, COGNOS, JDEDWARDS, EDI, Harbinger Translation Software, ORACLE Financials. Utilized Sybase, SQL, SQL Report Writing, Oracle. Redbrick DBA. Handled database transfers within multiple database structures. Wrote several conversions between financial systems.

Collier-Jackson/CompuServ Tampa, FL

Programmer/Analyst 2. HP3000 UNIX, Collier Jackson newspaper advertising software. UNIVAC/UNYSIS COBOL JCL

The Buffalo News, Buffalo NY

Programmer/Analyst 2. HP3000 UNIX, Collier Jackson retail advertising software. UNIVAC/UNYSIS COBOL JCL.

HSBC Buffalo, NY

Programmer/Analyst 2 IBM, TSO, JCL, COBOL, EFT, MAINFRAME

EDUCATION and PROFESSIONAL DEVELOPMENT

BRYANT & STRATTON BUSINESS INSTITUTE, Buffalo NY - AAS - Data Processing

Buffalo State College, Buffalo NY - CIS Programming

Medaille College, Buffalo NY - MIS

University of Buffalo - Six Sigma

Contact this candidate