Data Analyst Test

Rickell B. Kelly

*** **** ******* ****, ********** SC 29016 803-***-**** ************@*****.***

Objective

Obtain a full-time position so I can utilize my 24 years of experience at BlueCross BlueShield of South Carolina in the areas of Private Business Testing, quality audits, training analysts, Caremark, membership, and customer service.

Experience

Business Test Analyst II, Blue Cross Blue Shield of SC (1/2019-Current)

Develops test plans and test matrices, conducts testing and reports test results for system changes.

Coordinates implementation and debugging of new software, ensuring that the new or modified applications work in the production environment and meet the expectations of customers.

Researches and defines system production issues and works with Information Systems on both short-term and long-term resolutions.

Partner/communicate with other internal/external customers/plans regarding new evolving applications

Data Analyst II, Blue Cross Blue Shield of SC (3/2019-12/2019)

Reviews, extracts, and analyzes data to be used in formulation of procedures, processes and other requirements. Provides reports of relevant activity to be used to identify problematic areas and to provide basis for modification and/or elimination of operations issues.

Completed quote sheets for new and renewal groups

Documents reporting procedures so other staff can run ad hoc reports independently. Designs, codes, and maintains complex database programs for the extraction and analysis of data to support financial and operational decisions.

Documented and pulled weekly reports for repricing and group models.

Business Test Analyst II, Blue Cross Blue Shield of SC (4/2017-2/2019)

Develops test plans and test matrices, conducts testing and reports test results for system changes.

Coordinates implementation and debugging of new software, ensuring that the new or modified applications work in the production environment and meet the expectations of customers.

Researches and defines system production issues and works with Information Systems on both short-term and long-term resolutions.

Partner/communicate with other internal/external customers/plans regarding new evolving applications.

Senior Quality Analyst, Blue Cross Blue Shield of SC (7/2014-3/2017)

Audits benefits within BlueChoice AMMS systems and Rules databases to ensure timely and accurate processing of claims.

Conducts testing on Caremark and AMMS systems due to system conversion.

Trains Caremark analysts on policies, procedures and adjudicating claims regarding new databases within BlueChoice.

Creates and analyzes reports for various departments within BlueChoice.

Serves as primary contact regarding Caremark small/large/complex accounts

Membership Analyst (Coordinator)/ Web Migration Specialist, Blue Cross Blue Shield of SC (4/2005-6/2014)

Performed quality audits for all of National Alliance accounts to meet expected completion dates.

Developed procedures and monitored analysis progress.

Trained analysts on policies and procedures for National Alliance and Major Group.

Coordinated the enrollment of new groups, renewals, changes and cancellations, responded to all inquiries and resolved group and member issues.

Synchronized with Marketing, Underwriting, Claims and Benefit Files to ensure that appropriate group structures, benefits, and billing were accurately stated in the Group Library or benefits checklist.

Accounting Associate III, Blue Cross Blue Shield of SC (9/2001-3/2005)

Prepared monthly external General Ledger and accounting reports using problem-solving techniques and system-generated reports to collect and verify data for completeness and mathematical accuracy.

Prepared monthly bank account reconciliation for the lower complexity accounts.

Made necessary journal entries and initiated corrections to the financial files to resolve all items timely.

Used system-generated reports to complete the weekly and monthly cash management electronic spreadsheets of Issues, Voids, and Deposits.

Balanced the monthly resource Sharing and Support spreadsheet to system generated CDS reports.

Finance Associate I / Finance Associate II, Blue Cross Blue Shield of SC (2/1997-8/2001)

Completed preliminary research for refund checks using internal computer system {SOND, ROMS, and Claims History} to determine the correct bank account for deposit.

Finished deposit tickets for each day’s deposit, which included running calculator tapes to balance for mathematical accuracy, made check copies, and prepared the deposit for mailing to the bank.

Keyed data into the Excel spreadsheet of incoming refund receipts for Tricare Finance lines of Business.

Used system-generated reports to match data and completed General Ledger Account Reconciliation and related journal entries for lower complexity Void, Void/Reissue, IRS Tax Levy, Interest Payable, and Accounts Receivable reports.

Skills/Abilities

Microsoft Office, Word to Web, Excel, TextPad, Access, DB2, SQL

Education

1993-1996 Lugoff-Elgin High School, Diploma

1993-1996 Applied Technology Education Campus, Certificate in Marketing

Contact this candidate