Brenda M. Morinia ad3iir@r.postjobfree.com

***-** ***** *****, ***. 4D Jamaica, NY 11434 516-***-**** (Cell) 718-***-**** (Home)

Data Analyst

Summary of Qualifications

Self-motivated and results-oriented programmer/applications analyst with over 25 years of professional experience in leading projects and systems development.

Through data analytics developed meaningful insights, target marketing and system optimization.

Experience working on IBM Mainframe (30 years), COBOL, IMS, DB2, lite Assembler), Developer. Windows Server (15 years), SQL Server (5 years). Oracle Server (10) years. Experience as IMS DBA and lite experience updating CICS tables.

Strong communication, presentation, and problem-solving skills.

Certified Project Manager, creating specifications for enterprise systems.

Recognized as a visionary and creative thinker and problem resolution expert.

Experience in Claims processing (Hospital, Provider and Pharmacy).

Experience in leading Qualitative and Quantitative Data Analysis.

Compilation of solutions/strategies/analysis for presentation

BUSINESS APPLICATION/AREAS SUPPORTED

Retail Employers: Avon Products, Bristol Myers, and Zale Corp – Programmer Analyst

General Business Applications: Inventory, Human Resources, Sales, Marketing, Finance, Payroll, Operations Research, General Ledger, Fixed Assets, and Capital Projects.

Healthcare Applications: Credentialing, Actuarial Reporting, Claims Processing (Provider, Hospital and Pharmaceutical), Medical Management, and Risk Adjustment, Compliance, Policy and Regulatory Reporting, Marketing, and Product Support.

Software Development: Systems Analysis and Reengineering of Systems, Programming, QA Testing, Data Compliance, ETL Loads. Data Mapping, Table Design,

Other: Project Management, Database Administration, CICS Tables. IMS DBA

Skills

Base SAS and SAS Enterprise Guide with Macro Processing; SQL Server; Microsoft Office, Microsoft Access, and Microsoft Excel with VB. Tableau, Data Analysis, Microsoft Power BI; Pivot Tables, Interactive Spreadsheets in Excel; Reengineering of Processes using control files for repeatable jobs. Programming across systems, IBM Mainframe to Client Server platforms; Power Point; COBOL, DB2, IMS for legacy systems. Agile Training, Base SAS Certification, PMP Certification. Project Management and Lead Programmer experience.

Six Sigma Training to green belt level. Over 25 years of programming. IMS DBA Experience; Systems Experience updating CICS tables. Built SAS macros for accessing healthcare terminology on SNOMET CT, ISO, HL7, X12 for conversion/documentation/reference purposes.

Professional Experience

Apex Systems Richmond, VA

Program Manager (Contractor) 09/2023 – 01/2024

Onboarding providers into Epic System

Monitoring Requests on Work Front

Analysis of Potential Provider Groups for Epic Payer Platform

Molina Healthcare Long Beach, CA

Finance Analyst 08/2022 – 07/2023

Ad-Hoc Reporting and Data Cleansing

Risk Adjustment

Actuarial Reporting

Analysis of claims rejected by CMS.

oReason and Solution

Metroplus New York, NY

Finance Analyst 01/2022 – 05/2022

Ad-Hoc Reporting and Data Cleansing

Support of Member Enrollment Processes

Risk Adjustment

Financial Analysis of profits/expenses by Provider Group

LIFQHC Westbury, NY

Data Analyst - Contract 07/2021 – 12/2021

Reengineering processes to ensure maximum return on gaps and care analysis.

Maximization of Electronic Medical Records for additional data analysis inclusive of giving providers advance notification of upcoming services, procedures, and vaccinations for patients.

Analysis of possible in-house systems to replace systems currently outsourced.

Anthem Health New York, NY

Advanced Analytics Analyst Consultant 08/2015 – 02/2020

Risk Adjustment Analysis

Ad-Hoc Reporting and ETL Processing for sending files to Vendors and Receiving files from Providers.

Data preparation is done in SAS with some VB used in Excel for special formatting.

Investigative Analysis and Reporting for Medicaid State Submission Issues and Regulatory Reporting

Program/Project Management for Risk Adjustment analysis for Critical Claims identification.

Data Artifact to give dollar visualization of monies being held up by claims in Pend/Reject Status for Medicaid

Work with actuarial department for specialized statistical analysis and development of clinical algorithms.

Work with Information Technology team and SAS Admins data mining and SAS table development issues.

Converted COBOL/ DB2 logic to SQL to run in Base SAS Applications.

Emblem Health New York, NY

Lead Business Data Analyst 02/2014 – 07/2015

Report and analyze claims for claims operations, provider operations, and government health programs.

Manage integrated data analysis for members and provider systems for claims, enrollment and quality.

Deliver actionable recommendations for the business implementation to improve business performance.

Conduct trending analysis to identify/understand the customer experience and provide guidance internally.

Identify process improvement opportunities to improve service efficiency and execute needed changes.

Experience in automating reporting, using SAS, Excel, MS Query, SQL, SQL Server, Data Warehouse, etc.

Monitor/determine specific claims details and create standard and ad hoc reports for the management.

TEL used to convert some Cobol Datasets to tables to be used in SAS Enterprise Guide..

Healthfirst New York, NY

Information Analyst/Marketing Analyst 08/2010 – 01/2014

Provided systems analysis for Medical Management, Product Management, and Marketing Departments.

Worked with client and project team members to develop specifications of data management systems.

Determined scientific and statistical needs for the project. Wrote specifications for new database system.

Analyzed plan’s structured and unstructured data across different systems and platforms through various data manipulation and merging techniques to develop advanced statistical/modeling analyses.

Conducted meetings with the business and captured functional business and technical requirements.

Census data research for support of Public Health programs and community demographics to support marketing outreach,

Socioeconomic market research using Anthem Data, Census Data and other government agency data for analysis and target marketing.

North Shore Long Island Jewish Health System Manhasset, NY

Applications/Data Analyst 06/2007 – 11/2009

Effectively designed, programmed, and managed databases for hospital and medical research projects.

Determined scientific and statistical needs for each project. Wrote specifications for database system based on client needs. Transformed and loaded data for hospital conversions into centralized database.

Performed data mining activities, guided team of quality analysts, and drove root cause analysis cases.

Collaborate with SME (Credentialing Managers) for identification and understanding of data.

Creating data dictionary for migration of columns into Echo (New Credentialing Database)

Data mapping old Hospital Credentialing database data into new Credentialing database

Perform data edits and quality checks on transformed data for accuracy.

Programmed in Microsoft Access for all ETL conversion of data.

Conversion of multiple hospitals credentialing databases into one centralized database using ETL Process coding in Microsoft Access with VBA.

Worked with Credentialing Staff in multiple hospitals to understand their current processes and compile data dictionary and use cases for data conversion.

Financial Medical Systems Hauppauge, NY

Senior Programmer Analyst 02/2005 – 06/2007

Developed and supported medical billing programs using COBOL, JAVA, and VB on a UNIX platform.

Conducted analysis of vendor progress via schedule, metrics, and earned value measurement analysis. Reviewed deliverables at the final stage/phase of the project. Reduced overhead cost through internal resource use and scheduling. Generated, updated, and improved project strategies and methodologies.

Demonstrated ability to develop needed processes to complete tasks, understand, and apply applicable and appropriate measurements to projects, and identifies opportunities for synergy and integration.

Computer Associates Islandia, NY

QA Engineer 02/2002 – 01/2005

Initiated processes for installation of product and necessary databases or software required for testing.

Created test cases/test plans/documentation while supervising QA of programmers in India and Ohio.

Deeply experienced in resolving issues regarding the project and communicating with IT management.

Led projects related to the new system and software testing. Conducted weekly project status meetings.

Coordinated the efforts of multiple teams (i.e., with the outsourced teams to deliver projects to deadlines).

Communicated QA issues raised by team to software development team; wrote up software defects.

Report and document problems to software development team.

QA testing was done on Mainframe applications. CICS Tables and DB2 PSBs and PCBs updated.

AVIS, Inc. Garden City, NY

Operations Research Analyst 06/1997 –10/2001

Managed presentations of proposed architecture redesign. Rewrote mainframe system to Client Server.

Supported both Sales and Marketing Systems on mainframe, COBOL, IMS, DB2, and Easytrieve Plus.

Developed improved measurement tools on Sales and Marketing Systems for data collection, metrics to assess the effectiveness of process revisions, and control tools for use in sustaining project results.

Automated many of the AVIS ongoing day-to-day systems for support of the business using SAS, which reduced the implementation time. Provided forecasts and projections using SAS for AVIS Yield System.

Participated and led in preparation of system architecture and follow-up to ensure regulatory compliance.

Conversion of COBOL programs to JAVA for Object-Oriented programming requirements.

Barnes and Noble Westbury, NY

Lead Analyst 02/1992 – 05/1997

Implemented system support for EAM and CMMS (formerly Capital Projects System), Fixed Assets and General Ledger Systems, Customer Billing, and Inventory Analysis using SAS, COBOL, VSAM, IMS, FoxPro, Easytrieve and CICS.

Download data from IMS Data Bases, data manipulation using Easytrieve and then uploaded back to IMS databases. This was to save processing time.

Prepared reports, abstracts, and presentations based on the analysis of process measures of system.

Reviewed and analyzed quality-related to support quality improvement activities and programs.

Defined purpose, roles, milestones, budgets, and measures of success, and managed all project activity.

Off-hours and on-call production support once a month on rotation for defect and problem resolution.

Avon Products Rye, NY

Sr. Programmer 05/1982 – 01/1992

Programming in COBOL, IMS, CICS, DB2 and Easytrieve Development and Support for Inventory, Sales, and Finance Systems.

Data Base Administrator for one year, creating PCBS.

Data mapping IMS/VSAM data to Relational Databases for IMS to Relational Databases (DB2).

Documentation of Programs/Processes by extracting business rules from legacy COBOL code.

Ran Easytrieve or SAS programs to parallel legacy system output to new relational database output.

Education

Dowling College Oakdale, NY

MBA Management/Leadership May 2010

Iona College New Rochelle, NY

Bachelor of Business Administration May 1992

Training / Certifications

PMP Certification Six Sigma Green Belt Training

SAS Certified Base Programmer for SAS 9

Affiliations

Project Management Institute – New York State Chapter of PMI

Computer Skills

Hardware: IBM Mainframe, IBM PC, UNIX

Software: OS/VS, MVS/ESA z/OS, TSO/ISPF, PROCS, DOS/VSE, VM/SP, CMS, JCL (MVS/DOS), SDSF, UNIX Scripting (VI), DB2 Connect, TCP/IP, PASSPORT, Endeavor, COBOL, COBOL II,VSAM, IBM Utilities, Command-Level CICS, IMS, Crystal, Microsoft Suite(Word, Excel, PowerPoint, Outlook, Access), Internet Explorer, CA7-Job Scheduler, Easytrieve, SAS, DB2,SQL Server, QMF, Syncsort, FILEAID, MQSeries, and light Assembler, SPSS, Base SAS, SAS Enterprise Guide, Pass-Through Queries, SAS Macro Processing, Proc Sort, Data Step, Proc Transpose, TABLEAU, MSSQL, JAVA, C, C++, Perl, Oracle, Sybase, HTML, SQL, FOXPRO, and Micro Focus COBOL,VBA

Contact this candidate