Mindi Geouge
Elizabeth
Summary
Dynamic Senior Data Reporting Analyst with extensive experience at Mountain State/Highmark Blue Cross and Blue Shield. Proven expertise in SQL querying and database management, driving process improvements and enhancing operational efficiency. Adept at risk assessment and financial data analysis, delivering impactful reports that support strategic decision-making.
Overview
24
24
years of professional experience
Work History
Senior Data Reporting Analyst
Mountain State/Highmark Blue Cross and Blue Shield
11.2019 - Current
- Designed ad hoc and recurring queries and reports based on management requests.
- Troubleshot and repaired Microsoft Access database issues to ensure operational efficiency.
- Provided technical support for Underwriting department, enhancing workflow.
- Analyzed claims data to assess group risk and establish concession rates.
- Extracted and consolidated budget and concession reports using Microsoft Access and Excel.
- Researched and resolved errors in proprietary Underwriting Renewal Exhibit package.
- Updated and edited proprietary reports for renewal exhibits and dental rates.
- Created tables, forms, and reports within departmental Access databases.
Lead Underwriter (Development and Reporting)
Mountain State/Highmark Blue Cross and Blue Shield
09.2013 - 10.2019
- Executed monthly renewals and generated high claims reports using Microsoft Access and Teradata SQL Assistant.
- Performed daily backup and maintenance of quoting and underwriting databases in Microsoft Access.
- Conducted ad hoc queries and reports per customer and management requests.
- Troubleshot and resolved issues within Microsoft Access databases to ensure operational continuity.
- Supported internal and external audits by supplying relevant data and procedural documentation.
- Provided technical support to Underwriting and Sales departments, enhancing system functionality.
- Facilitated compliance with new ACA laws for automated systems in Sales and Underwriting departments.
Operational Analytic Reporting Analyst II
Mountain State/Highmark Blue Cross and Blue Shield
07.2011 - 09.2013
- Generated monthly corporate enrollment reports utilizing Microsoft Excel, SQL Plus, and SAS Enterprise Guide.
- Developed and maintained new corporate enrollment databases to enhance data management.
- Executed ad hoc queries and reports based on customer and management requests.
- Applied knowledge of corporate enrollment categorization codes for effective reporting.
Underwriting Development Analyst II
Mountain State/Highmark Blue Cross and Blue Shield
08.2005 - 07.2011
- Generated monthly claims and departmental reports using Crystal Reports and Cognos Impromptu.
- Developed and maintained high-claim reporting extracts and databases.
- Executed daily backup and maintenance of Microsoft Access quoting and underwriting databases.
- Managed quarterly individual rate feed process to ICIS to ensure billing accuracy.
- Produced ad hoc queries and reports per customer and management requests.
- Updated Microsoft Access databases based on customer and management requirements.
- Troubleshot and repaired issues within Microsoft Access databases for optimal performance.
- Assisted auditors by providing documentation and test data for Highmark West Virginia systems.
Systems Designer/Data Analyst
Mountain State/Highmark Blue Cross and Blue Shield
12.2004 - 08.2005
- Executed monthly, quarterly, and ad-hoc data extracts from CAPS claims payment system using TSO.
- Updated EasyTrieve and Cobol programs on a periodic and ad-hoc basis.
- Maintained Access databases through regular updates and troubleshooting.
- Resolved Access database issues to ensure data integrity and accessibility.
- Sustained Mountain State coding tables for pricing including DRG and RVU.
- Mapped current MSBCBS tables, queries, and reports for seamless conversion to Highmark systems.
- Contributed to Bridge Reporting Oracle database table, query, and report design for effective conversion.
Human Resources Compliance Specialist
Mountain State/Highmark Blue Cross and Blue Shield
03.2002 - 12.2004
- Designed, programmed, and maintained Parking Lot, Job Description, and Administration Databases via Microsoft Access.
- Created ad hoc reports and queries in Microsoft Access based on user requests.
- Audited PeopleSoft HRMS data against personnel records to ensure accuracy using provided queries.
- Researched federal hiring laws per management and user inquiries.
- Provided budget variance reporting utilizing Microsoft Excel to enhance financial oversight.
- Drafted and maintained corporate organizational charts and Equal Employment Opportunity Commission logs.
- Prepared and updated annual Affirmative Action Plan to meet compliance standards.
- Managed all federal employment practice reporting requirements efficiently.
HIPAA Department Administrative Assistant
Mountain State/Highmark Blue Cross and Blue Shield
11.2000 - 03.2002
- Supported business analysts in researching and interpreting HIPAA privacy laws during compliance requirements gathering.
- Documented system requirements to ensure regulatory adherence.
- Created data maps for claims and demographic information using Microsoft Excel.
- Designed, programmed, and maintained Privacy Database utilizing Microsoft Access.
- Developed reports in Microsoft Excel and Access based on user specifications.
Education
Bachelor’s Degree - Information Technology
University of Phoenix
02.2007
Skills
- Microsoft Office Suite
- Database management
- SQL querying
- Data analysis and reporting
- Process improvement strategies
- Financial data analysis
- Risk assessment
- Budgeting Analysis
- Insurance underwriting expertise
Timeline
Senior Data Reporting Analyst
Mountain State/Highmark Blue Cross and Blue Shield
11.2019 - Current
Lead Underwriter (Development and Reporting)
Mountain State/Highmark Blue Cross and Blue Shield
09.2013 - 10.2019
Operational Analytic Reporting Analyst II
Mountain State/Highmark Blue Cross and Blue Shield
07.2011 - 09.2013
Underwriting Development Analyst II
Mountain State/Highmark Blue Cross and Blue Shield
08.2005 - 07.2011
Systems Designer/Data Analyst
Mountain State/Highmark Blue Cross and Blue Shield
12.2004 - 08.2005
Human Resources Compliance Specialist
Mountain State/Highmark Blue Cross and Blue Shield
03.2002 - 12.2004
HIPAA Department Administrative Assistant
Mountain State/Highmark Blue Cross and Blue Shield
11.2000 - 03.2002
Bachelor’s Degree - Information Technology
University of Phoenix
Similar Profiles
Rachel GrahamRachel Graham
Claims Adjuster at Highmark Blue Cross Blue ShieldClaims Adjuster at Highmark Blue Cross Blue Shield
Clare PhillipsClare Phillips
Customer Service Advocate at Highmark Blue Cross Blue ShieldCustomer Service Advocate at Highmark Blue Cross Blue Shield
Pamela GibbsPamela Gibbs
Customer Service Advocate at Highmark Blue Cross Blue ShieldCustomer Service Advocate at Highmark Blue Cross Blue Shield
RAFAEL P. SORIANORAFAEL P. SORIANO
Air and Missile Defense Crewmember at U.S. ArmyAir and Missile Defense Crewmember at U.S. Army
Anna KaufmanAnna Kaufman
Volunteer at Epilepsy FoundationVolunteer at Epilepsy Foundation