Develop SQL programs to extract and process client medical and RX claims data. Design and implement reporting packages for Coupe Health members.Create and maintain routine and ad-hoc queries for Coupe 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.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 within the organization and external clients.

Develop SQL programs to extract and process medical and RX claims data. Design 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.

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.

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.

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.

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.

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.

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.

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.

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.