Experience

Coupe Health

• United States
• Insurance
• 1 - 100 Employee

• Sr. Business Analyst - SQL Reporting and Data Analytics

  • Nov 2021 - Present

  Develop SQL programs through SSMS to extract and process client data. Design and and implement reporting packages for SimplePay Health members. Create and maintain routine and ad-hoc queries for SimplePay Health member clients. Responsible for creating visual analytics through dashboards using various visual analytics tools to provide detailed financial and volume data for executive level management, account management team, and clients. Manage data file transactions through EDI between multiple systems ensuring data files are delivered and received in accordance with the agreed scheduling. Responsible for ensuring all SFTP's are accurate testing security and proper placement of files. Maintain database systems, assisting with initial design and development, testing, debugging, and troubleshooting. Analyze data systems, documenting data elements, data flows, and relationships/dependencies for maximum efficiency. Develop and manage standard operating procedures for all systems and reporting and data processes. Provide technical and analytical expertise to various business units throughout the organization. Show less



SimplePay Health

• United States
• Insurance
• 1 - 100 Employee

• Reporting Analyst - SQL Reporting/EDI

  • Feb 2020 - Present

  Develop SQL programs through SSMS to extract and process client data. Design and and implement reporting packages for SimplePay Health members. Create and maintain routine and ad-hoc queries for SimplePay Health member clients. Responsible for creating visual analytics through dashboards using various visual analytics tools to provide detailed financial and volume data for executive level management, account management team, and clients. Manage data file transactions through EDI between multiple systems ensuring data files are delivered and received in accordance with the agreed scheduling. Responsible for ensuring all SFTP's are accurate testing security and proper placement of files. Analyze data systems, documenting data elements, data flows, and relationships/dependencies for maximum efficiency. Show less



OU Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Sr. Decision Support Analyst

  • Oct 2019 - Jan 2020

  Compiled, prepared and analyzed data obtained from numerous information systems and employed the judgment necessary to determine the accuracy and applicability of the conclusions. Participated in the development and maintenance of the decision support system with required structure and transaction maintenance. Processed monthly and yearly data for the decision support system performing audit processes to ensure consistency and accuracy of data dispersed to executive level management. Assembled data, prepared reports and dashboards to provide analytics support for operational and strategic decisions. Designed, developed, and documented processes and tools for Decision Support to aid the goals of the Finance department. Managed data requirements from managers and directors for construction and maintenance of report and systems. Show less



INTEGRIS Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• DSA Intermediate Analyst I - SQL Reporting and Visual & Data Analytics

  • Oct 2015 - Aug 2019

  Utilized SQL analytics, developing and documenting customers’ requirements and specifications to create and maintain queries, reporting, and visual and data analytics ensuring financial data integrity. Continually worked to improve efficiency and productivity through data management and scheduled and ad-hoc reporting of hospital-level accounting. Conducted data mining of financial and cost data to provide detailed summaries and clarifications. Incorporated business intelligence tools, providing the organization with meaningful financial analysis through dashboards and graphical and visual reporting. Conducted monthly cost accounting data loads following strict quality assurance protocols. Significantly decreased development time for creation of reporting and analytics for both the Nazih Zuhdi Transplant Institute and Integris Cardiology Physicians. Show less



American Fidelity

• United States
• Insurance
• 700 & Above Employee

• EDI Specialist

  • May 2015 - Oct 2015

  Created and maintained data files for EDI transmissions to insurance carriers consisting of 834 transaction sets and proprietary layouts. As a technical contact, guided internal and external customers through 834 file development, pre and post implementation of EDI configurations, and SFTP setups. Following strict testing, implemented production projects meeting firm go-live dates. With improved quality assurance, data transmissions were timely and effective. Collaborated with coordinators and analysts to maintain functionality of the EDI system and processes. Show less



SONIC Drive-In

• United States
• Restaurants
• 700 & Above Employee

• HRIS Reporting Analyst

  • Mar 2013 - Apr 2015

  Administered HR analytics through SQL development, data and visual analytics, tracking turnover, employee data, staffing levels, and performance in relation to productivity, benefits, and sales volume.With reporting oversight and analysis of ACA Implementation, provided employee analytics for corporate and franchisees determining the implementation impact and cost.As lead project reporting analyst, provided executives and the People Department with the full impact of implementing the new hiring management system through data management and system testing. Show less

• HRIS Analyst

  • Feb 2012 - Mar 2013

  Managed oversight for HRIS tables, systems, and processes, identifying opportunities for enhancements and improved efficiencies. Developed integral data and visual analytics aiding in the decision-making for SRI restuarants.



Waterstone Benefit Administrators (Vizient)

• Oklahoma City, Oklahoma, United States

• EDI Developer

  • Aug 2011 - Jan 2012

  Created and modified data queries using SQL and Access for data retrievals and uploads. Managed daily scheduled and manual electronic data interchanges for both 834 and 837 transaction sets. Performed weekly server reboots to update server with latest software enhancements. Assisted external customers resetting insurance portal usernames and passwords. Created and modified data queries using SQL and Access for data retrievals and uploads. Managed daily scheduled and manual electronic data interchanges for both 834 and 837 transaction sets. Performed weekly server reboots to update server with latest software enhancements. Assisted external customers resetting insurance portal usernames and passwords.



GuideStone Financial Resources

• United States
• Financial Services
• 400 - 500 Employee

• Technical Analyst

  • Nov 2007 - Aug 2011

  Developed SQL ad-hoc queries extracting insurance benefits data encompassing 300+ corporate employees, over 200,000 participants, and 36,000 churches. Implemented a software malfunction identification process, coordinating with users and software vendors to identify and log errors and perform critical testing prior to production. Improved routine vendor data file transmissions cutting transmission failures by 85 percent. Successfully, directed online insurance Get-A-Quote tool, overseeing testing plans, coordinating testing between customer service and insurance departments, and outlining project purpose and requirements. Created technical team procedures for reporting and electronic data file interchanges. Show less



Hertz

• United States
• Travel Arrangements
• 700 & Above Employee

• Programmer Analyst

  • Oct 2000 - Jan 2007

  Developed Cobol programs to extract and process customer data for Hertz European Systems. Efficiently coordinated file transfers based on file size and transfer time ensuring routine file transmissions. Provided 24x7 on call support to coordinate and ensure timely fixes and continue data process activities. Identified areas to improve programming and readability of Hertz programming standards. Developed Cobol programs to extract and process customer data for Hertz European Systems. Efficiently coordinated file transfers based on file size and transfer time ensuring routine file transmissions. Provided 24x7 on call support to coordinate and ensure timely fixes and continue data process activities. Identified areas to improve programming and readability of Hertz programming standards.