Responsible for using various tools to complete data conversion from other software packagesDevelop standardized procedure for common conversion routines to increase efficienciesUtilized SQL Server, Oracle database, and MS Office productsWork cross-organizationally with functional consultants, customers, internal, and external teamsResearch, analyze, and document scope of work for data conversion projectsCreate/update SQL scripts for data conversions from LINQ legacy systems or outside vendorsInvestigate and troubleshoot data-related issues

Performed electronic and manual conversion of payroll, demographic, and HR information from client’s prior providers with the use of SQL. Assisted in the design and development of process and procedures to assist team members in learning data transfers of new providers.

Managed audits of the pharmacy benefit management systems for various clients, which included copays, pricing, clinical structure, and performance guarantees. Communicated with clients in regard to issues resolution, audit findings, and PBM reimbursement. Analyzed audit findings and wrote detailed reports outlining results. Utilized Toad and SQL queries to retrieve audit data.

Assisted technical audits to help analyze current infrastructure. Collaborated with internal audit teams to maintain and define proper invoicing controls. Reconciled invoicing, including processed and confirmed client invoices as they were received. Create and monitor CBA agreements. Request and troubleshoot WBS (Work Breakdown Structure) numbers and run reports in Symphony Project System for team.

Controlled user access to the graphical user interface which includes maintaining user IDs, user access, and password resets. Performed technical audits to analyze the strengths and weaknesses of the current infrastructure. Created and ran Sequel queries using Toad for Oracle to retrieve information from the data stored in tables. Analyzed the data to determine issue patterns and corrective actions. Created and maintained Excel/Access database for all internal user information. Responsible for quarterly and annual graphical user interface internal ID audit. Collaborated with internal audit to maintain and define proper controls as they relate to SAS70 and SOC-1 regulations. Reviewed user access to determine the correct access has been granted per mandated audit controls. Created procedures and process flows for daily processes as well as audit controls.

Controlled user access to the graphical user interface which includes maintaining user IDs, user access, and password resets. Performed technical audits to analyze the strengths and weaknesses of the current infrastructure. Created and ran Sequel queries using Toad for Oracle to retrieve information from the data stored in tables. Analyzed the data to determine issue patterns and corrective actions. Created and maintained Excel/Access database for all internal user information. Responsible for quarterly and annual graphical user interface internal ID audit. Collaborated with internal audit to maintain and define proper controls as they relate to SAS70 and SOC-1 regulations. Reviewed user access to determine the correct access has been granted per mandated audit controls. Created procedures and process flows for daily processes as well as audit controls.

Received, entered, and processed State, Government and Pharmacy Claims. Researched and resolved claims issues with use of Pharmacy Benefit System and customer issue tickets. Designed metrics Excel sheets to track the time and amount of claims processed. Assigned tasks and communicated with 10-16 employees. Built tracking sheets for incoming and backlogged claims. Designed and utilized multiple letters to handle claims that could not be processed. Set up incoming staff with access and permissions for computer systems and programs. Developed guidelines and procedures on how to process claims. Streamlined the procedures for processing state-subrogated, government, and pharmacy claims. Organized and managed multiple temporary employees. Tracked clients that had terminated or do not allow for claim processing. Utilized PBS and Claims Submission Program. Utilized MS Access, MS Excel, and Business Objects to help track, control, and resolve claim issues.

Booked travel for the President, Executive Vice President of the company as well as potential candidates. Handled correspondence between clients, candidates, and the company. Assisted the President, Executive Vice President, and consultants with regular operations. Set up and scheduled appointments for both the President and Executive Vice President.

Responsible for the management and safety of employees and guests within rides operation department. Trained and scheduled employees.